frankmaseo2023-06-27 02:47 PM
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
35
36
›
⌄
WITH
max_tx as (
SELECT COUNT(*) as max_tx
SELECT COUNT(*)
FROM ethereum.core.ez_token_transfers
WHERE
contract_address = '0x6982508145454ce325ddbe47a25d4ec3d2311933'
)
SELECT *
FROM (
SELECT
FROM_ADDRESS,
TO_ADDRESS,
tx_count,
ROW_NUMBER() OVER (ORDER BY FROM_ADDRESS, TO_ADDRESS) as edge_id
FROM(
SELECT
FROM_ADDRESS,
TO_ADDRESS,
max_tx.max_tx,
COUNT(DISTINCT TX_HASH) / max_tx.max_tx as tx_count
FROM ethereum.core.ez_token_transfers
, max_tx
WHERE
contract_address = '0x6982508145454ce325ddbe47a25d4ec3d2311933'
GROUP BY 1,2,3)a)aa
WHERE edge_id < 500000 AND edge_id >= 400000
Run a query to Download Data