SajjadiiiUntitled Query
Updated 2022-10-29Copy Reference Fork
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 reddit AS (
SELECT block_timestamp,
tx_hash,
event_inputs:_to AS buyer,
event_inputs:_id AS tokenID,
event_inputs:_value AS tokensCount,
contract_address AS collection,
event_inputs:_from AS seller
FROM polygon.core.fact_event_logs
WHERE contract_address IN (
'0x4670e4890bc1b76f3ae5c7660aa98e0b6668c6f3', -- Reddit CA: Old School Cool
'0x91ac106090fe2b0fa7d01efdf4487a5bfafad7fa', -- Reddit CA: Spooky Season
'0x8d0501d85becda92b89e56177ddfcea5fc1f0af2', -- The Senses
'0x2d58a44d6c0a355de25761fb33a1f6269a97e2c5', -- Aylia
'0x2956409293da98603025cc0121c06a4244752039', -- Reddit CA: Protectors of the Forest
'0x47749c5b970e63f3a0ed57cd6cef773e74fafe9d', -- Reddit CA: Cute, Cool and Creepy
'0x150afa2dfcaaada471472dfa6ad4b79e718a197c', -- Reddit CA: TreasureOfOphiel Token
'0x808ed3e23aac685126524aa4416d8eaeb2e767b9', -- Reddit CA: Wearing Your Emotions
'0x71dc46607f31f30510f0ccc670b0963f431b212a', -- Reddit CA: Celestial Assembly
'0xd6261320f49d38c137f6e229a2ea4ab0f4fae6de', -- Reddit CA: Peculiar Gang
'0xe1b5e23fdbc003aec16e6e79726a0b5f75ff93f5', -- Reddit CA: Spooky Season: tfoust10
'0x97439ee4c93ff9f76417696ce648aa6f35ab3b25', -- Reddit CA: Creatures of the Nighties
'0xc5aa1f91b0d52e26d2847f8e51f505d6e2ece795', -- Reddit CA: Lightspeed Lads
'0xee1ee80338958fa596471ceb70f0177daff80323', -- Reddit CA: Growl Gang
'0xd8cf23bf309de778609d234bd2410b0156118c26', -- Reddit CA: Magic of the Woods
'0x27b37e4befacc50b02102d1e2117c4ea8a54beff', -- Reddit CA : 5 Boro Bodega
'0x621ce7e7e44d43a428a183d5390c4f4572c9ff9d', -- Reddit CA: Spooky Season: eando9745
'0x5846728730366d686cdc95dae80a70b44ec9eab2', -- Reddit CA: Imagination Station
'0x81ba34b90876f42f34a4f232cfc0fe4b6ec949a3', -- Reddit CA: Spooky Season: StutterVoid
'0x907808732079863886443057c65827a0f1c64357', -- Reddit CA: Foustlings
'0x425bf054ef7bad65b7bdd8e6587b1c3500e4f4ca', -- Reddit CA: Avatar Rock Out
'0x3e4627665bf2e52c69be03788e664ab545f2be71', -- Reddit CA : Spooky Season Rojom
'0x946ad8e53db653053e8ef7c02dfca83ce8ba8022', -- Reddit CA: Token
'0xdaa6e4ba2d4022ed820460bb501b9e061d9614fb', -- Reddit CA : Spooky Season Sys32Template
'0x65a83530ca8abc27969907913fe5e641a5da2e9f', -- I quit my job to be an Artist: Token
'0x63e2f0c058ce9a194ec68f04320b7eb8ca555bd3', -- Reddit CA: Enlightenment
Run a query to Download Data