c2ctrader03 - Top 10 Wallets
Updated 2022-05-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with first_transaction as (
SELECT *
FROM flipside_prod_db.polygon.transactions t
INNER JOIN
(
SELECT FROM_ADDRESS wallet, MIN(BLOCK_TIMESTAMP) As first_occurence
FROM flipside_prod_db.polygon.transactions
where --block_timestamp>='2022-01-01 00:00:00.000' and
SUCCESS=TRUE
GROUP BY FROM_ADDRESS
) X
ON t.FROM_ADDRESS = X.wallet AND t.BLOCK_TIMESTAMP = x.first_occurence
)
select from_address "Wallet Address", count(*) "Number of Transaction" from flipside_prod_db.polygon.transactions
where from_address in (select from_address from first_transaction) and SUCCESS=TRUE
group by from_address order by "Number of Transaction" DESC
limit 10
Run a query to Download Data