hbd1994Swaps in Base - Overview
Updated 2023-08-29
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
'' as "Network",
count(distinct ORIGIN_FROM_ADDRESS) as "Swapper",
count(distinct tx_hash) as "Swap Transactions",
count(*) as "Swaps",
sum(coalesce(AMOUNT_OUT_USD , AMOUNT_IN_USD)) as "USD Volume",
count(distinct TOKEN_IN) as "From Tokens",
count(distinct TOKEN_OUT) as "To Tokens",
count(distinct CONTRACT_ADDRESS) as "Pools"
from base.defi.ez_dex_swaps
where block_timestamp >= '{{Start_Date}}'
and block_timestamp <= '{{End_Date}}'
Run a query to Download Data