KARTODTransfers humans on Solana
Updated 2022-06-19
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
›
⌄
WITH bots AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Day",
TX_FROM AS "Bots",
COUNT(DISTINCT TX_ID) AS "Transactions"
FROM solana.core.fact_transfers
WHERE BLOCK_TIMESTAMP >= CURRENT_DATE() - INTERVAL'15 day'
GROUP BY "Day", "Bots"
HAVING COUNT(DISTINCT TX_ID) >= 25
),
bots_list AS (
SELECT
DISTINCT "Bots" AS "Bot"
FROM bots
)
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Day",
ADDRESS_NAME,
SUM(AMOUNT) AS "Amount",
COUNT(DISTINCT TX_FROM) AS "User",
COUNT(DISTINCT TX_ID) AS "Transactions"
FROM solana.core.fact_transfers
LEFT JOIN solana.core.dim_labels ON MINT = ADDRESS
WHERE BLOCK_TIMESTAMP >= CURRENT_DATE() - INTERVAL'15 day' AND TX_FROM NOT IN (SELECT "Bot" FROM bots_list)
GROUP BY "Day", ADDRESS_NAME
HAVING COUNT(DISTINCT TX_ID) > 100
Run a query to Download Data