wanlinCex Movement - 1. Ethereum - Last 24 Hours (Outflow) copy
    ethereum.core.ez_token_transfersethereum.core.ez_nft_transfersethereum.core.ez_nft_transfers-- forked from pinehearst / Cex Movement - 1. Ethereum - Last 24 Hours (Outflow) @ https://flipsidecrypto.xyz/pinehearst/q/untitled-query-rcyAWq

    with all_transfers AS (
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    from_address,
    to_address,
    contract_address,
    symbol,
    amount,
    amount_usd
    from ethereum.core.ez_token_transfers
    WHERE block_timestamp >'{{date}}'--
    -- WHERE date(block_timestamp)>= CURRENT_DATE - INTERVAL '24 hours'-- Last n hours
    union
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    eth_from_address,
    eth_to_address,
    '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' as contract_address, -- take weth price
    'ETH' as symbol, -- 'ETH' but actually eth / for pricing missing tables
    amount,
    amount_usd
    from ethereum.core.ez_eth_transfers
    WHERE block_timestamp > '{{date}}'--
    -- WHERE date(block_timestamp)>= CURRENT_DATE - INTERVAL '24 hours'-- Last n hours
    ),
    eth_cex AS (
    SELECT
    block_timestamp,
    from_address,
    to_address,
    Run a query to Download Data