(select date(block_timestamp) as datetime,

tx_hash

--count(*) as token_launched,

--sum(count(*)) over (order by date(block_timestamp)) as cum_token_launched

from base.core.fact_transactions

where to_address = lower('0xF66DeA7b3e897cD44A5a231c61B6B4423d613259')

and

origin_function_signature = '0x3c0b93aa'

select date(block_timestamp) as datetime,

sum(amount) as total_virtual,

sum(sum(amount)) over (order by date(block_timestamp)) as cum_virtual,

sum(amount_usd) as total_virtual_usd,

sum(sum(amount_usd)) over (order by date(block_timestamp)) as cum_virtual_usd

from base.core.ez_token_transfers a join launched_tx b

on a.tx_hash = b.tx_hash

where contract_address = lower('0x0b3e328455c4059EEb9e3f84b5543F74E24e7E1b')

group by 1