-- *

date_trunc('hour', block_timestamp) as hour,

-- topic1,

-- topic2,

-- data

-- -- count(*)

count(distinct ethereum.public.udf_hex_to_int (substr(data, 64+3, 64))) as d1,

-- ,substr(data, 64+3, 64) as d2

SUM(

ethereum.public.udf_hex_to_int (substr(data, 128 + 3, 64))::float / 1e18

) as token_amount,

count(*) as cnt

-- ,ethereum.public.udf_hex_to_int(substr(data, 192+3, 64)) as d4

polygon.core.fact_event_logs

contract_address = '0xc3e5ad11ae2f00c740e74b81f134426a3331d950'

and topics[0] = '0x0f066129e5902e103e22209fff5d12a79f07dc9ef7c78fe10ff64c741a20c8ec'

and block_timestamp >= date('2022-12-01')

and block_timestamp <= date('2022-12-09')

group by

1