trunc(x.block_timestamp,'day') as date,

--status,

count(distinct from_address) as daily_users,

sum(daily_users) over (order by date) as cum_users,

count(distinct x.tx_hash) as daily_transactions,

sum(daily_transactions) over (order by date) as cum_transactions,

sum(tx_fee) as daily_fees,

sum(daily_fees) over (order by date) as cum_fees,

avg(tx_fee) as avg_fee_per_tx

from avalanche.core.fact_transactions x

join avalanche.core.fact_event_logs y on x.tx_hash=y.tx_hash

join avalanche.core.dim_labels z on y.contract_address=z.address

where project_name='wyndblast' and x.block_timestamp>='2022-08-09' --event chainlink

--https://twitter.com/chainlink_eco/status/1557018871814569987?s=20&t=seCVm-U8qPO7h7WDzGgKbQ

group by 1

order by 1 asc