hurimaasDaily Volume of Polygon NFTs
Updated 2022-09-24
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 tokens AS (
SELECT address AS token_address
FROM polygon.core.dim_labels
WHERE label_type ILIKE 'layer2'
),
contracts AS (
SELECT
DISTINCT(contract_address) AS nft_contracts
FROM polygon.core.fact_event_logs
WHERE origin_to_address ILIKE '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' --OpenSea contract
AND contract_address NOT ILIKE '0x70c006878a5a50ed185ac4c87d837633923de296' --REVV token
AND contract_address NOT ILIKE '0x264808855b0a6A5a318D238C6ee9F299179f27FC' --SPACE token
AND contract_address NOT ILIKE '0xC17c30e98541188614dF99239cABD40280810cA3' --RISE token
AND contract_address NOT ILIKE '0xdba7b24257fc6e397cb7368b4bc922e944072f1b' --someother tokens
AND contract_address NOT ILIKE '0x7e6aca675a46de846f9dc092356329510dfa6966'
AND contract_address NOT IN (
SELECT token_address
FROM tokens
)
)
SELECT
DATE_TRUNC(
'day',
block_timestamp
) AS DATE,
COUNT(tx_hash) AS nft_transaction
FROM polygon.core.fact_event_logs
WHERE contract_address IN (
SELECT nft_contracts
FROM contracts
)
GROUP BY DATE
ORDER BY DATE DESC
Run a query to Download Data