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_token_transfers
    where block_timestamp > '{{date}}'
    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 > '{{date}}'
    ),
    eth_cex AS (
    SELECT
    block_timestamp,
    from_address,
    to_address,
    a.label as from_label,
    a.label_type as from_label_type,
    Run a query to Download Data