AleXtop 5 blockchain
Updated 2024-08-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from top 5 token in /tx @ https://flipsidecrypto.xyz/studio/queries/9bbd7203-0361-4676-a50a-14f22ab7317f
-- forked from top 5 token in @ https://flipsidecrypto.xyz/studio/queries/ca58a7dc-0be9-47fd-bcf9-28ce91675e27
-- forked from daily @ https://flipsidecrypto.xyz/studio/queries/fa611747-7986-4455-aeb1-928fceb28114
select BLOCKCHAIN , count(DISTINCT TX_ID) as tx_count,
count (DISTINCT FROM_ADDRESS) as user , sum(FROM_AMOUNT_USD) as vol
from thorchain.defi.fact_swaps
where BLOCK_TIMESTAMP>=current_date-60 and AFFILIATE_ADDRESS='dx' and FROM_AMOUNT_USD is not null
GROUP by 1
order by 4 DESC
QueryRunArchived: QueryRun has been archived