select

block_timestamp,

tx_hash,

event_name,

event_inputs:_to as to_address,

event_inputs:_from as from_address,

event_inputs:_id as token_id,

case

when ORIGIN_TO_ADDRESS='0x67f4732266c7300cca593c814d46bee72e40659f' then 'ZED RUN'

when ORIGIN_TO_ADDRESS='0x9d305a42a3975ee4c1c57555bed5919889dce63f' then 'Sandbox'

when ORIGIN_TO_ADDRESS='0x49cb83b4c4980029200b6759d5fb7d3b21f10134' then 'Decentral Games ICE Poker'

when ORIGIN_TO_ADDRESS='0xdc0479cc5bba033b3e7de9f178607150b3abce1f' then 'Crypto Unicorns Market'

when ORIGIN_TO_ADDRESS='0xa9a6a3626993d487d2dbda3173cf58ca1a9d9e9f' then 'Unstoppable Domains'

when ORIGIN_TO_ADDRESS='0xda302bc91cad1af9afcd40cff238d59424d6ba11' then 'CONUSIVERSE'

when ORIGIN_TO_ADDRESS='0xdb46d1dc155634fbc732f92e853b10b288ad5a1d' then 'Lens Protocol Profiles'

else 'Reddit Collections'

end as collection

from

polygon.core.fact_event_logs

where

event_name in ('TransferSingle', 'Transfer') and

tx_status = 'SUCCESS' and

ORIGIN_TO_ADDRESS in (

'0xdb46d1dc155634fbc732f92e853b10b288ad5a1d',

'0xda302bc91cad1af9afcd40cff238d59424d6ba11',

'0x67f4732266c7300cca593c814d46bee72e40659f',

'0x9d305a42a3975ee4c1c57555bed5919889dce63f',

'0x49cb83b4c4980029200b6759d5fb7d3b21f10134',

'0xdc0479cc5bba033b3e7de9f178607150b3abce1f',

'0xa9a6a3626993d487d2dbda3173cf58ca1a9d9e9f',

'0xfec90bc707fc93aefeb0c18c2eb56bc79d32163e',

'0x91ac106090fe2b0fa7d01efdf4487a5bfafad7fa',

'0x7e680862c572e4b945cf45912130c8d884109b59',

'0xd5ae5a16fbaf964f96e242645a4a6f10b98fd0c4',

'0x37db2523d221d19838632eb62d1af911e52632c3',