select hour,

avg (price) as ethprice

from ethereum.price.ez_hourly_token_prices

where token_address = lower ('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2')

group by 1)

select t1.from_address as "Wallet Address",

count (Distinct t1.tx_hash) as "Transactions",

count (Distinct t1.block_timestamp::date) as "Active Days",

count (distinct contract_address) as "Interacted Contracts",

sum (tx_fee) as "Paid Fees [ETH]",

sum (tx_fee*ethprice) as "Paid Fees [USD]"

from blast.core.fact_transactions t1 join ethpricet t2 on date_Trunc (hour,block_timestamp) = t2.hour

join blast.core.fact_event_logs t3 on t1.tx_hash = t3.tx_hash

where t1.block_timestamp >= '2024-02-29 00:00:00.000'

group by 1

order by 2 desc

limit 100