wanlinCex Movement - 0. Ethereum Wallets copy
    Updated 2023-05-13
    -- forked from pinehearst / Cex Movement - 0. Ethereum Wallets @ https://flipsidecrypto.xyz/pinehearst/q/untitled-query-_uLinw

    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_dex_swapsethereum.core.ez_token_transfers
    where block_timestamp >= '2022-11-04'
    AND block_timestamp <= '2022-11-18'
    union
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    eth_from_address,
    eth_to_address,
    '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' as contract_address, -- take weth price
    'WETH' as symbol, -- 'weth' but actually eth / for pricing missing tables
    amount,
    amount_usd
    from ethereum.core.ez_eth_transfers
    where block_timestamp >= '2022-11-04'
    AND block_timestamp <= '2022-11-18'
    ),
    eth_cex AS (
    SELECT
    block_timestamp,
    from_address,
    to_address,
    Run a query to Download Data