0xtollex$KRAV VOLUME STATS
Updated 2024-04-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
--date_trunc(week, block_timestamp) as date,
count(tx_hash) as Number_Transaction,
-- platform,
count(DISTINCT origin_from_address) as Active_User,
sum(amount_in_usd) as Total_Volume
FROM base.defi.ez_dex_swaps
WHERE block_timestamp >= 2023-08-07 AND
token_out = '0xbe3111856e4aca828593274ea6872f27968c8dd6' OR
token_in = '0xbe3111856e4aca828593274ea6872f27968c8dd6' AND
--HAVING Total_Volume > 0
--GROUP BY 1,3
--ORDER BY 1 DESC
--LIMIT 100
QueryRunArchived: QueryRun has been archived