jackguyTop HBB Trasferers
Updated 2022-10-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
tx_from,
sum(AMOUNT) as volume,
avg(amount) as avg_transfer_size,
count(DISTINCT tx_id) as transfers
-- count(DISTINCT ) as sender
FROM solana.core.fact_transfers
-- LEFT outer join solana.core.dim_labels
-- ON mint = address
WHERE mint LIKE 'HBB111SCo9jkCejsZfz8Ec8nH7T6THF8KEKSnvwT6XK6'
GROUP BY 1
ORDER BY 2 DESC
LIMIT 100
Run a query to Download Data