Penta Limited TeamVRTX transfers 4
Updated 2024-12-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from cristinatinto / gswift transfers 4 @ https://flipsidecrypto.xyz/cristinatinto/q/7IIfSOQIe514/gswift-transfers-4
SELECT
--case when block_timestamp<'2023-03-10' then 'a.Before SVB announcement' else 'b.After SVB announcement' end as period,
pool_name,
count(DISTINCT tx_hash) as swaps,
sum(AMOUNT_IN_USD) as volume
FROM arbitrum.defi.ez_dex_swaps
WHERE (token_in='0x95146881b86b3ee99e63705ec87afe29fcc044d9' or token_out='0x95146881b86b3ee99e63705ec87afe29fcc044d9') and AMOUNT_IN_USD is not null
--and block_timestamp>=CURRENT_DATE-INTERVAL '2 WEEKS' and pool_name is not null
GROUP BY 1 order by 1 asc
QueryRunArchived: QueryRun has been archived