LI.FIrestaker
    Updated 2024-07-04
    -- forked from restaking @ https://flipsidecrypto.xyz/edit/queries/57a3ac74-0804-4eeb-9410-30c95d258148

    with

    prices_2 as (
    select
    price,
    hour
    from
    ethereum.price.ez_prices_hourly
    where
    token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    ),

    token_transfers as (
    select
    raw_amount,
    contract_address,
    block_timestamp,
    from_address,
    to_address,
    'ethereum' as chain
    from ethereum.core.fact_token_transfers
    union all
    select
    raw_amount,
    contract_address,
    block_timestamp,
    from_address,
    to_address,
    'arbitrum' as chain
    from arbitrum.core.fact_token_transfers
    union
    all
    select
    raw_amount,
    QueryRunArchived: QueryRun has been archived