flipside

    predict fees 1
    Pine Analyticspredict fees 1
    Updated 2024-09-06
    with tab1 as (
    SELECT
    date(hour) as day,
    median(price) as token_price

    from ethereum.price.ez_prices_hourly
    WHERE token_address LIKE lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2')
    GROUP BY 1
    )

    SELECT
    date(block_timestamp) as date,
    sum(RAW_AMOUNT_PRECISE) / power(10, 18) as fee_volume_eth,
    sum(RAW_AMOUNT_PRECISE * token_price) / power(10, 18) as fee_volume_usd,
    count(DISTINCT tx_hash) as events,
    count(DISTINCT FROM_ADDRESS) as users
    FROM blast.core.fact_token_transfers
    LEFT outer JOIN tab1
    on date(block_timestamp) = day
    WHERE to_address like lower('0xd20c3890FAea09eCCa7487afD54F4D99C1C93482')
    AND contract_address LIKE lower('0x4300000000000000000000000000000000000003')
    --limit 1000
    GROUP BY 1

    QueryRunArchived: QueryRun has been archived