alitaslimiWash Trades Over Time
    Updated 2025-01-17
    with
    -------------------- Hourly AVAX Price --------------------
    prices as (
    select
    hour,
    price as avax_price
    from
    avalanche.price.ez_prices_hourly
    where
    token_address = '0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7'
    ),
    -------------------- Raw Transfer Transactions --------------------
    transfers as (
    select
    block_timestamp,
    tx_hash,
    from_address,
    to_address,
    amount
    from
    avalanche.core.ez_native_transfers
    union
    select
    block_timestamp,
    tx_hash,
    from_address,
    to_address,
    amount
    from
    avalanche.core.ez_token_transfers
    where
    contract_address = '0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7'
    ),
    -------------------- Raw Sale Transactions --------------------
    transactions as (
    select
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived