nitsDaily Amount Swapped
Updated 2022-07-04
9
1
2
3
4
5
6
7
›
⌄
SELECT date(block_timestamp) as day,sum(event_inputs:amount1)/pow(10,9) as vol, sum(vol) over (order by day) as cum_vol,
count(DISTINCT tx_hash) as total_txs, sum(total_txs) over (order by day) as cum_txs,
avg(event_inputs:liquidity)/pow(10,18) as avg_liquidity
from ethereum.core.fact_event_logs
WHERE contract_address = '0xb386c1d831eed803f5e8f274a59c91c4c22eeac0' and event_name = 'Swap' and origin_function_signature = '0xa94e78ef'
GROUP by 1
-- LIMIT 100
Run a query to Download Data