theericstoneAll Ethereum Swaps
Updated 2022-04-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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