SocioAnalytica$VIBE Swaps _ Token in and out
Updated 2025-03-04
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 $VIBE Swaps @ https://flipsidecrypto.xyz/studio/queries/c3a240a3-22ce-469c-88fb-09cca28bf762
SELECT 'buy' as action,
date_trunc('hour',BLOCK_TIMESTAMP) as hour,
count(distinct tx_hash) as n_swaps,
count(DISTINCT swapper) as n_swappers,
sum(amount_out_unadj) /pow(10,8) as VIBE_swapped,
sum(amount_in_usd) as VIBE_swapped_in_USD
FROM aptos.defi.ez_dex_swaps
WHERE token_out = '0xeedba439a4ab8987a995cf5cfefebd713000b3365718a29dfbc36bc214445fb8'
group by 1 ,2
UNION
SELECT 'sell' as action,
date_trunc('hour',BLOCK_TIMESTAMP) as hour,
count(distinct tx_hash) as n_swaps,
count(DISTINCT swapper) as n_swappers,
sum(amount_in_unadj)/pow(10,8) as VIBE_swapped,
sum(amount_out_usd) as VIBE_swapped_in_USD
FROM aptos.defi.ez_dex_swaps
WHERE token_in = '0xeedba439a4ab8987a995cf5cfefebd713000b3365718a29dfbc36bc214445fb8'
group by 1 ,2
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived