Ali3NAverage Blast Users Contracts Used
    Updated 2024-06-03
    with ethpricet as (
    select hour,
    avg (price) as ethprice
    from ethereum.price.ez_hourly_token_prices
    where token_address = lower ('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2')
    group by 1),

    userst as (
    select origin_from_address as "Wallet Address",
    count (Distinct contract_address) as "Interacted Contracts"
    from blast.core.fact_event_logs
    where block_timestamp >= '2024-02-29 00:00:00.000'
    group by 1)

    select round (avg ("Interacted Contracts")) as "Average Interacted Contracts"
    from userst