lagandispenserHeadline NFT's Daily and Cumulative Sales Number
Updated 2022-06-17
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
29
30
31
32
33
34
35
36
›
⌄
WITH
sales AS
(
SELECT
transfers.date,
transfers.tx_group_id,
MAX(payment_transaction.amount) AS sale_amount
FROM
flipside_prod_db.algorand.payment_transaction
JOIN (
SELECT
asset_transfer_transaction.block_timestamp::date AS date,
tx_group_id,
tx_id
FROM
flipside_prod_db.algorand.asset_transfer_transaction
JOIN
flipside_prod_db.algorand.asset
ON
asset_transfer_transaction.asset_id = asset.asset_id
WHERE
asset_transfer_transaction.asset_amount > 0
AND
asset.creator_address = 'K3NSXYMHPRCK7PMYT3QUQXUGPZJ4MKWJXW2HJRYPVMQUMKJAOJEIEO4HK4' AND asset.asset_deleted = FALSE
) AS transfers
ON
payment_transaction.tx_group_id = transfers.tx_group_id
WHERE
payment_transaction.amount > 10
GROUP BY
date, transfers.tx_group_id
ORDER BY
date
)
SELECT
sales.date AS date,
Run a query to Download Data