avg(price) as price

from crosschain.price.ez_prices_hourly

where token_address = lower('0xc383a3833a87009fd9597f8184979af5edfad019')

and day = current_date - 1

group by 1)

,

tb1 as (select distinct origin_from_address

from ink.core.ez_token_transfers

where from_address = '0x0000000000000000000000000000000000000000'

and contract_address = '0x11476323d8dfcbafac942588e2f38823d2dd308e'

select

ifnull(label,to_address) as Contract,

count(distinct from_address) as users,

count(distinct tx_hash) as transactions

from ink.core.fact_transactions a join ink.core.dim_labels b on a.to_address = b.address

group by 1

order by 3 desc

limit 30