--------------------------------------------------------------------- WITH date_range AS ( SELECT '2024-05-28'::date AS start_date, current_date AS end_date, DATEDIFF(day, '2024-05-28'::date, current_date) AS days_difference ) --------------------------------------------------------------------- --------------------------------------------------------------------- -- MOTHER , tab1_MOTHER AS ( SELECT block_timestamp, owner, CASE WHEN (pre_balance < .00001 AND balance > .00001) THEN 1 WHEN (pre_balance > .00001 AND balance < .00001) THEN -1 ELSE 0 END AS event FROM solana.core.fact_token_balances WHERE mint LIKE '3S8qX1MsMqRbiwKg2cQyx7nis1oHMgaCuc9c4VfvVdPN' ), tab2_MOTHER AS ( SELECT DATE_TRUNC('day', block_timestamp) AS Date, SUM(event) AS Net_Holders FROM tab1_MOTHER GROUP BY 1 ), tab3_MOTHER AS ( SELECT Date, SUM(Net_Holders) OVER (ORDER BY Date) AS Cumulative_Holders, ROW_NUMBER() OVER (ORDER BY Date) AS date_num FROM tab2_MOTHER ) --------------------------------------------------------------------- -- WIF , tab1_WIF AS ( SELECT block_timestamp, owner, CASE WHEN (pre_balance < .00001 AND balance > .00001) THEN 1 WHEN (pre_balance > .00001 AND balance < .00001) THEN -1 ELSE 0 END AS event FROM solana.core.fact_token_balances WHERE mint LIKE 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm' ), tab2_WIF AS ( SELECT DATE_TRUNC('day', block_timestamp) AS Date, SUM(event) AS Net_Holders FROM tab1_WIF GROUP BY 1 ), tab3_WIF AS ( SELECT Date, SUM(Net_Holders) OVER (ORDER BY Date) AS Cumulative_Holders, ROW_NUMBER() OVER (ORDER BY Date) AS date_num FROM tab2_WIF ) --------------------------------------------------------------------- -- BONK , tab1_BONK AS ( SELECT block_timestamp, owner, CASE WHEN (pre_balance < .00001 AND balance > .00001) THEN 1 WHEN (pre_balance > .00001 AND balance < .00001) THEN -1 ELSE 0 END AS event FROM solana.core.fact_token_balances WHERE mint LIKE 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263' ), tab2_BONK AS ( SELECT DATE_TRUNC('day', block_timestamp) AS Date, SUM(event) AS Net_Holders FROM tab1_BONK GROUP BY 1 ), tab3_BONK AS ( SELECT Date, SUM(Net_Holders) OVER (ORDER BY Date) AS Cumulative_Holders, ROW_NUMBER() OVER (ORDER BY Date) AS date_num FROM tab2_BONK ) --------------------------------------------------------------------- -- MEW , tab1_MEW AS ( SELECT block_timestamp, owner, CASE WHEN (pre_balance < .00001 AND balance > .00001) THEN 1 WHEN (pre_balance > .00001 AND balance < .00001) THEN -1 ELSE 0 END AS event FROM solana.core.fact_token_balances WHERE mint LIKE 'MEW1gQWJ3nEXg2qgERiKu7FAFj79PHvQVREQUzScPP5' ), tab2_MEW AS ( SELECT DATE_TRUNC('day', block_timestamp) AS Date, SUM(event) AS Net_Holders FROM tab1_MEW GROUP BY 1 ), tab3_MEW AS ( SELECT Date, SUM(Net_Holders) OVER (ORDER BY Date) AS Cumulative_Holders, ROW_NUMBER() OVER (ORDER BY Date) AS date_num FROM tab2_MEW ) --------------------------------------------------------------------- -- POPCAT , tab1_POPCAT AS ( SELECT block_timestamp, owner, CASE WHEN (pre_balance < .00001 AND balance > .00001) THEN 1 WHEN (pre_balance > .00001 AND balance < .00001) THEN -1 ELSE 0 END AS event FROM solana.core.fact_token_balances WHERE mint LIKE '7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr' ), tab2_POPCAT AS ( SELECT DATE_TRUNC('day', block_timestamp) AS Date, SUM(event) AS Net_Holders FROM tab1_POPCAT GROUP BY 1 ), tab3_POPCAT AS ( SELECT Date, SUM(Net_Holders) OVER (ORDER BY Date) AS Cumulative_Holders, ROW_NUMBER() OVER (ORDER BY Date) AS date_num FROM tab2_POPCAT ) --------------------------------------------------------------------- -- BILLY , tab1_BILLY AS ( SELECT block_timestamp, owner, CASE WHEN (pre_balance < .00001 AND balance > .00001) THEN 1 WHEN (pre_balance > .00001 AND balance < .00001) THEN -1 ELSE 0 END AS event FROM solana.core.fact_token_balances WHERE mint LIKE '3B5wuUrMEi5yATD7on46hKfej3pfmd7t1RKgrsN3pump' ), tab2_BILLY AS ( SELECT DATE_TRUNC('day', block_timestamp) AS Date, SUM(event) AS Net_Holders FROM tab1_BILLY GROUP BY 1 ), tab3_BILLY AS ( SELECT Date, SUM(Net_Holders) OVER (ORDER BY Date) AS Cumulative_Holders, ROW_NUMBER() OVER (ORDER BY Date) AS date_num FROM tab2_BILLY ) ------------------------FINAL TABLES--------------------------------- SELECT date_num, 'MOTHER' as Token, Cumulative_Holders FROM tab3_MOTHER WHERE date_num <= (SELECT days_difference FROM date_range) UNION ALL SELECT date_num, 'WIF' as Token, Cumulative_Holders FROM tab3_WIF WHERE date_num <= (SELECT days_difference FROM date_range) UNION ALL SELECT date_num, 'BONK' as Token, Cumulative_Holders FROM tab3_BONK WHERE date_num <= (SELECT days_difference FROM date_range) UNION ALL SELECT date_num, 'POPCAT' as Token, Cumulative_Holders FROM tab3_POPCAT WHERE date_num <= (SELECT days_difference FROM date_range) UNION ALL SELECT date_num, 'MEW' as Token, Cumulative_Holders FROM tab3_MEW WHERE date_num <= (SELECT days_difference FROM date_range) UNION ALL SELECT date_num, 'BILLY' as Token, Cumulative_Holders FROM tab3_BILLY WHERE date_num <= (SELECT days_difference FROM date_range)

Mother Iggy (MOTHER)