as total_transactions,

block_timestamp::date

as date_time

from ethereum_core.fact_event_logs

where contract_address = '0xae78736cd615f374d3085123a210448e74fc6393'

and event_name = 'TokensBurned'

and block_timestamp::date >= current_date - 90

and block_timestamp::date < current_date - 1

group by date_time

order by date_time