veysbeystark_par -tx rank 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
›
⌄
-- forked from stark_par -tx rank copy @ https://flipsidecrypto.xyz/edit/queries/a6047e08-9d82-41f6-8efc-0793be710b21
-- forked from Hessish / stark_par -tx rank @ https://flipsidecrypto.xyz/Hessish/q/_PoWI7uLDIP7/stark_par--tx-rank
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('{{Starknet_address}}')
--'0x07480f307b7c0dc18bfc17ef425f8ad3319b89e1d347897537d9b5fe66b1f7f7'
Run a query to Download Data