ErsvanVolume per day in sales of NFD
Updated 2022-06-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS DAY,
SUM(AMOUNT) AS AMOUNT_PER_DAY,
SUM(AMOUNT)-(SUM(AMOUNT)*.05) AS AMOUNT_PER_DAY_NO_FEE,
(SUM(AMOUNT)*.05) AS FEE_CHARGED
FROM flipside_prod_db.algorand.PAYMENT_TRANSACTION
WHERE TX_GROUP_ID IN (
(SELECT DISTINCT TX_GROUP_ID FROM flipside_prod_db.algorand.ASSET_TRANSFER_TRANSACTION WHERE ASSET_ID IN (
SELECT ASSET_ID FROM flipside_prod_db.algorand.asset WHERE ASSET_NAME LIKE '%.algo'
)AND ASSET_AMOUNT IS NOT NULL)
)
GROUP BY DAY
ORDER BY 1 DESC
Run a query to Download Data