h4wkAll Base DLN TXs
    Updated 2024-08-18
    with price as (
    select hour::date as price_date,
    token_address,
    symbol,
    decimals,
    avg(price) as price
    from Base.price.ez_prices_hourly
    group by 1,2,3,4
    )
    , ETH_price as (
    select hour::date as price_date,
    token_address,
    symbol,
    decimals,
    avg(price) as ETH_price
    from ethereum.price.ez_prices_hourly
    where symbol = 'WETH'
    group by 1,2,3,4
    )
    , base_from_Base as (
    select distinct tx_hash
    from Base.core.fact_token_transfers t
    where 1 = 1
    and block_timestamp >= '2023-04-01' and block_timestamp < CURRENT_DATE
    and to_address = '0xef4fb24ad0916217251f553c0596f8edc630eb66'
    )
    , cancelled_tx as (
    select tx_hash
    FROM Base.core.fact_event_logs
    where 1 = 1
    and block_timestamp > '2023-04-01'
    and topics[0] = '0x7d7d1c5b3eadbe275ceb358e65cd57410b35997187258dbaaae42ab6e1405fd8'
    )
    , from_Base as (
    select block_timestamp::date as date,
    'From' as route_type,
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived