SajjadiiiUntitled Query
    Updated 2022-10-29
    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