contract_address as contract

from blast.core.fact_event_logs

where block_Timestamp::date >= '2024-02-29'

,

new_contract as ( select min(block_timestamp::date) as date,

from contracts

group by 2)

select

contract,

count(distinct TX_HASH) as transactions,

count(distinct from_address) as users,

sum(value) as volume,

from blast.core.fact_transactions a join new_contract b on

a.to_address = b.contract

group by 1

order by 2 DESC

limit 100