SniperTotal Deposit Transactions
Updated 2024-06-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with vertex as ( select date(block_timestamp) as date,
tx_hash,
trader,
symbol,
amount_usd
from arbitrum.vertex.ez_clearing_house_events
where MODIFICATION_TYPE = 'deposit'),
tbl as (select
date,
count(DISTINCT tx_hash) as "TXs",
count(DISTINCT trader) as "Users",
sum(amount_usd) as "Volume"
from vertex
group by 1)
select sum ("TXs") as "Total TXs",
sum("Users") as "Total Depositers",
sum("Volume") as "Total Deposit Volume"
FROM tbl
QueryRunArchived: QueryRun has been archived