maybeyonaszap-out-eth
    Updated 2022-11-28
    with zap_out_eth as(
    select distinct tx_id
    from ethereum.udm_events
    where origin_function_signature = '0xf6216495'
    and from_address = '0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a'
    )
    select
    block_timestamp,
    tx_id,
    symbol,
    contract_address as token_contract,
    amount,
    amount_usd,
    'zapOut' as event
    from ethereum.udm_events
    where tx_id in (select * from zap_out_eth)
    and from_label_type = 'dex' and symbol='WETH'

    -- select *
    -- from ethereum.udm_events
    -- where -- origin_function_signature = '0xf6216495'
    -- -- and from_address = '0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a'
    -- tx_id = '0x2f743a5bee4c0821e28a211f7b3935c7eb44804e671279aad0599156934de190'
    -- -- limit 100
    Run a query to Download Data