winnie-fssim stark_par -tx rank copy copy copy
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
›
⌄
-- forked from sim stark_par -tx rank copy copy @ https://flipsidecrypto.xyz/edit/queries/ff94d8fa-c0b6-4a3a-b6be-b1ae66f50268
-- forked from Hessish / sim stark_par -tx rank copy @ https://staging.flipsidecrypto.xyz/Hessish/q/Hwm1t4CREInB/sim-stark_par--tx-rank-copy
-- forked from stark_par -tx rank @ https://flipsidecrypto.xyz/edit/queries/f16ee22a-057b-49cd-a058-66dbddf1d7b6
with x as
(SELECT DISTINCT contract, count(DISTINCT tx_hash) as txs, row_number() over (order by txs desc) as rank
from external.tokenflow_starknet.decoded_transactions
where
CHAIN_ID = 'mainnet' group by 1
order by rank
)
SELECT rank ,txs
from x
where
contract = lower('{{Your_address}}')
Run a query to Download Data