SELECT count(*)
FROM "datalake_raw_878695318857_ek_1201695"."crawler_stockdata"
WHERE symbol = 'BTC_USD' and
date_format(from_unixtime(transaction_ts),'%Y-%m-%dT%H') =
'2020-10-01T00'
union all
SELECT count(*)
FROM "datalake_raw_878695318857_ek_1201695"."processed_stockdata"
WHERE HOUR=0 and DAY=1 and MONTH=10 and YEAR=2020
and symbol = 'BTC_USD';