with total_fee_sender as( SELECT sum(nvl(fee,0)) as sum_fee ,sender from flipside_prod_db.algorand.transactions where BLOCK_TIMESTAMP>='2022-01-01' group by sender ) SELECT '0' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee=0 UNION SELECT '0-0.001' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>0 and sum_fee<0.001 UNION SELECT '0.001-0.002' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.001 and sum_fee<0.002 UNION SELECT '0.002-0.003' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.002 and sum_fee<0.003 UNION SELECT '0.003-0.004' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.003 and sum_fee<0.004 UNION SELECT '0.004-0.005' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.004 and sum_fee<0.005 UNION SELECT '0.005-0.006' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.005 and sum_fee<0.006 UNION SELECT '0.006-0.007' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.006 and sum_fee<0.007 UNION SELECT '0.007-0.008' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.007 and sum_fee<0.008 UNION SELECT '0.008-0.009' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.008 and sum_fee<0.009 UNION SELECT '0.009-0.01' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.009 and sum_fee<0.01 UNION SELECT '0.01-0.1' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.01 and sum_fee<0.1 UNION SELECT '0.1-1' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=0.1 and sum_fee<1 UNION SELECT '1-10' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=1 and sum_fee<10 UNION SELECT '10-100' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=10 and sum_fee<100 UNION SELECT '<100' as tag, COUNT(*) as count_sender from total_fee_sender where sum_fee>=100 --SELECT count(*) from flipside_prod_db.algorand.prices_swap --where block_hour='2022-01-05 22:00:00.000'

Algorand Fees 2022 Q111