0-MIDTop Tokens
Updated 2025-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
with tab1 as (
select --BLOCK_TIMESTAMP::date as day
TX_HASH
,ORIGIN_FROM_ADDRESS
,TOKEN_ID
from ronin.nft.ez_nft_transfers
where ORIGIN_TO_ADDRESS='0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc'
and ORIGIN_FUNCTION_SIGNATURE='0x2beee4c7'
and NAME='Lumiterra Game Item'
and BLOCK_TIMESTAMP::date>='2024-11-11'
),
tab2 as (
select --BLOCK_TIMESTAMP::date as day
TX_HASH
,VALUE
from ronin.core.fact_transactions
)
select TOKEN_ID
,sum(VALUE) as volume
from tab1
left join tab2
on tab1.TX_HASH=tab2.TX_HASH
where VALUE>0
group by 1
order by 2 desc
QueryRunArchived: QueryRun has been archived