potmoall_chains_transfers_data
    Updated 2024-06-12
    with arbitrum_transfers as (
    select block_timestamp,
    from_address ,
    amount_usd,
    'native' as source_token,
    tx_hash
    from arbitrum.core.ez_native_transfers
    where to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    and block_timestamp > current_timestamp - interval '30 days'
    and amount_usd >= 20
    union all
    select block_timestamp,
    from_address ,
    amount_usd,
    symbol as source_token,
    tx_hash
    from arbitrum.core.ez_token_transfers
    where to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    and block_timestamp > current_timestamp - interval '30 days'
    and amount_usd >= 20
    ),

    avalanche_transfers as (
    select block_timestamp,
    from_address ,
    amount_usd,
    'native' as source_token,
    tx_hash
    from avalanche.core.ez_native_transfers
    where to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    and block_timestamp > current_timestamp - interval '30 days'
    and amount_usd >= 20
    QueryRunArchived: QueryRun has been archived