with ape_token as ( select (block_timestamp) as day, to_address as from_address, RAW_AMOUNT/pow(10,18) as amount from ethereum.core.ez_token_transfers where contract_address = lower('0x4d224452801aced8b2f0aebe155379bb5d594381') and from_address = lower('0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f') and day >= '2022-03-17') , tb1 as ( select from_address, case when origin_function_signature = '0x46583a05' then 'BAYC Pool' when origin_function_signature = '0xd346cbd9' then 'BAKC Pool' when origin_function_signature = '0x9dcaafb4' then '$APE Pool' when origin_function_signature = '0x8ecbffa7' then 'MAYC Pool' end as pool_type, count(DISTINCT tx_hash) as count_tx, sum(RAW_AMOUNT/pow(10,18)) as ape_amount, avg(RAW_AMOUNT/pow(10,18)) as avg_amount, max(RAW_AMOUNT/pow(10,18)) as max_amount, median(RAW_AMOUNT/pow(10,18)) as median_amount, min(RAW_AMOUNT/pow(10,18)) as min_amount from ethereum.core.fact_token_transfers where to_address = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9' and contract_address = '0x4d224452801aced8b2f0aebe155379bb5d594381' group by 1,2 having pool_type is not null) select '1K-2.5K Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount > 1000 and ape_amount <= 2500 group by 1,2 UNION select '100-1K Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount > 100 and ape_amount <= 1000 group by 1,2 UNION select '10-100 Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount > 10 and ape_amount <= 100 group by 1,2 UNION select 'Below 10 Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount > 0 and ape_amount <= 10 group by 1,2 UNION select '2.5K-5K Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount <= 5000 group by 1,2 UNION select '5K-10K Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount <= 10000 group by 1,2 UNION select '10K-15K Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount <= 15000 group by 1,2 UNION select '15K-25K Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount <= 25000 group by 1,2 UNION select '25K-50K Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount <= 50000 group by 1,2 UNION select '50K-100K Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount <= 100000 group by 1,2 UNION select '+100K Ape' as type, pool_type, count(DISTINCT from_address) as total from tb1 where ape_amount > 100000 group by 1,2

-Pool of The Week-