airdrop_list_t1 as (

select

from_address as user_address,

300 as amount,

'tier 1' as label

from (

select from_address, count(distinct tx_hash) as txs

from ethereum.core.fact_transactions

where status = 'SUCCESS'

and to_address in ('0x31837aaf36961274a04b915697fdfca1af31a0c7', -- Genie LooksRare Aggregator

'0xf97e9727d8e7db7aa8f006d1742d107cf9411412', -- Genie x2y2 Aggregator

'0x0a267cf51ef038fc00e71801f5a524aec06e4f07', -- Genie GenieSwap

'0x2af4b707e1dce8fc345f38cfeeaa2421e54976d5',

'0xcdface5643b90ca4b3160dd2b5de80c1bf1cb088') -- Genie Seaport Aggregator

and block_timestamp < '2022-04-15' ::date

group by 1

having txs > 1

)

),

airdrop_list_t2 as (

select

user_address,

1000 as amount,

'tier 2' as label

from (

select

nft_to_address as user_address,