WITH
dates AS (
SELECT
date, auto_wallet_type
FROM
(
VALUES
( 'T', 'Holder' ),
( 'T+1', 'Holder' ),
( 'T+2', 'Holder' ),
( 'T+3', 'Holder' ),
( 'T+4', 'Holder' ),
( 'T+5', 'Holder' ),
( 'T+6', 'Holder' ),
( 'T+7', 'Holder' )
) AS dates_temp ( date, auto_wallet_type )
),
airdrop AS (
SELECT
tx_to AS recipient,
MIN(block_timestamp) AS block_timestamp
FROM solana.core.fact_transfers
WHERE mint = 'CKfatsPMUf8SkiURsDXs7eK6GWb4Jsd6UDbs7twMCWxo'
AND tx_from = '7MyTjmRygJoCuDBUtAuSugiYZFULD2SWaoUTmtjtRDzD'
AND block_timestamp >= '2023-05-25'
AND block_timestamp <= '2023-05-31'
GROUP BY 1
),
airdrop_recipients AS (
SELECT *
FROM airdrop a CROSS JOIN dates b
ORDER BY recipient, date
),