lagandispenserPolygon - Opensea Fees 3. daily copy copy
    -- Extracting and Analyzing Token Transfer Data

    WITH TokenPrices AS (
    -- Calculate daily average prices for relevant tokens
    SELECT
    date_trunc('day', hour) AS date,
    symbol,
    decimals,
    AVG(price) AS price
    FROM
    ethereum.price.ez_hourly_token_prices
    WHERE
    symbol IN ('WETH', 'USDC', 'DAI', 'REVV')
    GROUP BY
    1, 2, 3
    ORDER BY
    1 DESC
    ),

    TokenTransfers AS (
    -- Retrieve relevant token transfer data
    SELECT
    BLOCK_TIMESTAMP::date AS date,
    to_address AS fee_wallet,
    CASE
    WHEN CONTRACT_ADDRESS ILIKE '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' THEN 'WETH'
    WHEN CONTRACT_ADDRESS ILIKE '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' THEN 'USDC'
    WHEN CONTRACT_ADDRESS ILIKE '0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' THEN 'DAI'
    WHEN CONTRACT_ADDRESS ILIKE '0x70c006878a5a50ed185ac4c87d837633923de296' THEN 'REVV'
    END AS symbol,
    SUM(RAW_AMOUNT) AS total_raw_amount
    FROM
    polygon.core.fact_token_transfers
    WHERE
    origin_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
    AND to_address IN ('0x8de9c5a032463c561423387a9648c5c7bcc5bc90', '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073')
    Run a query to Download Data