davidwallUntitled Query
    Updated 2023-01-14
    --credit : https://app.flipsidecrypto.com/velocity/queries/51f81321-bdb5-482b-b65a-4c536f3ce7e5
    with receivetable as (
    select block_timestamp as receive_date,
    eth_to_address as receiver1,
    '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' as token1
    from ethereum.core.ez_eth_transfers
    where block_timestamp::date >= '2022-12-17' and block_timestamp <= '2023-01-01'

    union ALL

    select block_timestamp as receive_date,
    to_address as receiver1,
    contract_address as token1
    from ethereum.core.ez_token_transfers
    where block_timestamp::date >= '2022-12-17' and block_timestamp <= '2023-01-01'

    union ALL

    select block_timestamp as receive_date,
    to_address as receiver1,
    contract_address as token1
    from arbitrum.core.fact_token_transfers
    where block_timestamp::date >= '2022-12-17' and block_timestamp <= '2023-01-01'

    union ALL

    select block_timestamp as receive_date,
    eth_to_address as receiver1,
    '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' as token1
    from arbitrum.core.ez_eth_transfers
    where block_timestamp::date >= '2022-12-17' and block_timestamp <= '2023-01-01'

    union ALL

    select block_timestamp as receive_date,
    bnb_to_address as receiver1,
    Run a query to Download Data