AntekCV - count farm level 15+
Updated 2024-03-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH transaction_counts AS (
SELECT
from_address,
COUNT(DISTINCT tx_hash) AS num_transactions
FROM
blast.core.fact_transactions
WHERE
to_address = '0xf6f795eb013a2ce8659038666bf0ae883f326ebd'
and origin_function_signature = '0xebb130c1'
GROUP BY
from_address
)
SELECT
COUNT(*) AS num_wallets_with_more_than_9_transactions
FROM
transaction_counts
WHERE
num_transactions > 14;
QueryRunArchived: QueryRun has been archived