satsihSummary Stats All Historical
    Updated 2023-04-20
    with
    cexs as (
    SELECT
    *
    FROM
    avalanche.core.dim_labels
    WHERE
    label_type = 'cex'
    ),
    inflows as (
    SELECT
    a.block_timestamp,
    a.tx_hash,
    a.from_address,
    a.to_address,
    address_name,
    project_name,
    avax_value,
    b.price as avax_price,
    avax_value * b.price as value_usd,
    tx_fee,
    tx_fee * b.price as tx_fee_usd,
    gas_used
    FROM
    avalanche.core.fact_transactions a
    LEFT JOIN (
    SELECT
    *
    FROM
    avalanche.core.fact_hourly_token_prices
    WHERE
    symbol = 'WAVAX'
    ) b ON date_trunc('hour', a.block_timestamp) = b.hour
    INNER JOIN cexs c ON a.to_address = c.address
    ),
    outflows as (
    Run a query to Download Data