SELECT

block_timestamp as date,

tx_hash,

from_address,

to_address

FROM ethereum.core.fact_transactions

WHERE date BETWEEN '2022-01-01' AND '2022-01-31'

GROUP BY 1,2,3,4

ORDER BY 1

),

transfers as (

SELECT

block_timestamp as date,

tx_hash,

symbol,

amount

FROM ethereum.core.ez_token_transfers

WHERE date BETWEEN '2022-01-01' AND '2022-01-31'

AND symbol = 'TOKE'

GROUP BY 1,2,3,4

ORDER BY 1

),

contract as (

SELECT

block_timestamp as date,

tx_hash,

event_name

FROM ethereum.core.fact_event_logs

WHERE contract_address = LOWER('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')

AND date BETWEEN '2022-01-01' AND '2022-01-31'

GROUP BY 1,2,3

ORDER BY 1