Flash Bounty: Reddit NFTs - Mints

CryptoIcicleFlash Bounty: Reddit NFTs - Mints

Updated 2022-10-30

-- Pay by Quality Your score determines your final payout.

-- Grand Prize 112.5 USDC (A score of 11 or 12 earns you a Grand Prize title)

-- Payout 75 USDC

-- Score Multiplier0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%

-- Payout Network Ethereum

-- Level Intermediate

-- Difficulty Hard

-- Reddit is officially in the NFT game. Find 3 metrics to compare the Reddit NFT launch to the launches of other major NFTs.

-- Add any other interesting metrics comparing this launch to Polygon NFTs in general

-- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!

-- SQL Credit: https://app.flipsidecrypto.com/velocity/queries/f027a0fc-d7e2-40ac-b459-97dbdcdd5099

with txns as (

select

block_timestamp,

tx_hash,

contract_address as collection,

event_inputs :_to as to_wallet,

event_inputs :_from as from_wallet,

event_inputs :_id as nft_id

from

polygon.core.fact_event_logs

where

(

contract_address = '0xfec90bc707fc93aefeb0c18c2eb56bc79d32163e'

OR contract_address = '0x91ac106090fe2b0fa7d01efdf4487a5bfafad7fa'

OR contract_address = '0x7e680862c572e4b945cf45912130c8d884109b59'

OR contract_address = '0xd5ae5a16fbaf964f96e242645a4a6f10b98fd0c4'

OR contract_address = '0x37db2523d221d19838632eb62d1af911e52632c3'

OR contract_address = '0x5fd4d6fef3b87b91c7df8658727b5edd7210cf5a'

OR contract_address = '0x45ee1caed83525673843321107bccadecb9065d7'

OR contract_address = '0xe1b5e23fdbc003aec16e6e79726a0b5f75ff93f5'

OR contract_address = '0xbcea6c4029203b8753c856a2514a6ed211c69777'

OR contract_address = '0x334ad326a787dd332f26cbe8b4d7adfa8bd25f92'

OR contract_address = '0xbc096988fa38c78d65c0637453fd3d3c38b1cfd4'

Run a query to Download Data