joel_a0Getting Started
    Updated 2025-02-26
    with token_info as (
    select *
    from $query('75f58bb3-b2cd-4208-85e9-e3d75d901a1c')
    )

    SELECT
    t.block_timestamp,
    t.tx_hash,
    t.from_address,
    t.to_address,
    t.amount as token_amount,
    t.amount_usd,
    t.symbol,
    FROM polygon.core.ez_token_transfers t
    JOIN token_info ti
    ON t.symbol = ti.symbol
    WHERE t.block_timestamp::date >= '2025-01-27'
    AND t.block_timestamp > CURRENT_DATE - 100
    AND t.block_timestamp <= CURRENT_DATE - 23
    ORDER BY t.block_timestamp DESC;
    QueryRunArchived: QueryRun has been archived