theericstoneAll Ethereum Swaps
    Updated 2022-04-20
    with swaps as (select * from ethereum_core.fact_event_logs where lower(event_name) like 'swap%' and block_timestamp > current_date - 2 limit 500),
    lsw as (select *
    from swaps
    join ethereum_core.dim_labels labels
    on swaps.contract_address = labels.address)
    select
    lsw.tx_hash, lsw.block_timestamp, lsw.event_name,
    lsw.event_inputs, lsw.contract_address as pool_address, lsw.label as protocol,
    lsw.address_name, xfers.amount, xfers.contract_address as token_contract, xfers.symbol, xfers.amount_usd, xfers.token_price,
    xfers.from_address, xfers.to_address
    from lsw
    join ethereum_core.ez_token_transfers xfers
    on lsw.tx_hash = xfers.tx_hash;

    Run a query to Download Data