piperRaffle Tickets
Updated 2023-11-13
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
›
⌄
⌄
/* SELECT
NFT_FROM_ADDRESS AS "Wallet",
COUNT(DISTINCT TOKENID) AS "Number of burned Tickets",
FLOOR(("Number of burned Tickets"/6)) AS "Raffle Tickets",
SUM("Raffle Tickets") OVER (ORDER BY 3) AS "Total Raffle Tickets"
FROM
polygon.nft.ez_nft_transfers
WHERE
NFT_TO_ADDRESS = lower('0x000000000000000000000000000000000000dEaD')
AND
PROJECT_NAME = 'GoodieBags'
GROUP BY 1
ORDER BY 3 DESC */
SELECT
DECODED_LOG:from AS "Wallet",
COUNT(DISTINCT DECODED_LOG:tokenId) AS "Number of burned Tickets",
FLOOR(("Number of burned Tickets"/6)) AS "Raffle Tickets",
SUM("Raffle Tickets") OVER (ORDER BY 3) AS "Total Raffle Tickets"
FROM
polygon.core.fact_decoded_event_logs
WHERE
BLOCK_TIMESTAMP > '2023-11-01'
--TX_HASH = lower('0x26ded74be89659718ce6127293024939b3c78620ce18a9e2d5911c7bcb03e3ff')
AND
FULL_DECODED_LOG:address = '0xF57F97dba198af1CD0183ACf2681366b4841bEe0'
AND
DECODED_LOG:to = '0x000000000000000000000000000000000000dead'
AND
EVENT_NAME = 'Transfer'
GROUP BY 1
ORDER BY 3 DESC
Run a query to Download Data