Penta Limited TeamVRTX transfers 5
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
21
22
›
⌄
-- forked from cristinatinto / gswift transfers 5 @ https://flipsidecrypto.xyz/cristinatinto/q/SFwJrxcPKCrz/gswift-transfers-5
SELECT
date_trunc('week',block_timestamp) as weeks,
pool_name,
count(DISTINCT tx_hash) as swaps,
count(distinct origin_from_address) as swappers,
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 '6 months' and pool_name is not null
and weeks<trunc(current_date,'week')
GROUP BY 1,2 order by 1 asc
QueryRunArchived: QueryRun has been archived