Mrfti2023-03-25 11:51 AM
Updated 2023-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH gyro as
(WITH gyro_tx as
(select
rank() over (ORDER BY count (DISTINCT tx_hash) DESC) as rank,
FROM_ADDRESS as address
from polygon.core.fact_transactions
where FROM_ADDRESS = lower('{{ADDRESS}}')
AND to_address = '0x68bdee1bf95ad730f379a05eb8c51fb5dfa07748'
group by 2)
select
address,
rank
from gyro_tx)
select
address,
rank
from gyro
Run a query to Download Data