2844MOST USERS- Fees
Updated 2022-07-05
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT sender as "user",
SUM (FEE) AS "TOTAL FEE",
COUNT (TX_ID) AS "TRANSACTIONS"
--COUNT (DISTINCT SENDER) AS "UNIQUE USERS",
--sum("FEES") over (order by "DATE" asc) as "COMULATIVE FEES"
FROM flipside_prod_db.algorand.transactions T
RIGHT JOIN flipside_prod_db.algorand.account A ON A.ADDRESS= T.SENDER
WHERE block_timestamp> '2022-01-01'
GROUP BY 1
ORDER BY 3 DESC
limit 10
Run a query to Download Data