piperRekt Chickens - Opensea sales per day (Polygon)
Updated 2023-08-07
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 all_transactions AS (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
MATIC_VALUE,
TX_FEE,
FROM_ADDRESS
FROM
polygon.core.fact_transactions
WHERE
--TX_HASH = '0x3e44e94b11f9ed401665aab68c0346270c3d67b0b6768cbc049ac783a0ca21e5'
TO_ADDRESS = lower('0x00000000000000adc04c56bf30ac9d3c0aaf14dc')
AND
MATIC_VALUE > 0
AND
STATUS = 'SUCCESS'
),
all_nft_transfers AS (
SELECT
TX_HASH,
NFT_ADDRESS,
PROJECT_NAME,
NFT_FROM_ADDRESS,
TOKENID
FROM
polygon.core.ez_nft_transfers
WHERE
--TX_HASH = '0x3e44e94b11f9ed401665aab68c0346270c3d67b0b6768cbc049ac783a0ca21e5'
--EVENT_TYPE = 'other'
NFT_ADDRESS = lower('0xB609996E8F1754e63eF08300406C6D7529bb4007')
)
SELECT
--all_nft_transfers.tokenid,
--all_transactions.*
Run a query to Download Data