----------------------------DAI------------------------------ WITH TABLE1 AS (with final_tab as (with tab4 as (with tab3 as (with tab1 as (select to_address, sum(raw_amount)/pow(10,18) as input_vol from base.core.fact_token_transfers where contract_address=lower('0x50c5725949a6f0c72e6c4a641f24049a917db0cb') group by 1), tab2 as (select from_address, sum(raw_amount)/pow(10,18) as output_vol from base.core.fact_token_transfers where contract_address=lower('0x50c5725949a6f0c72e6c4a641f24049a917db0cb') group by 1) select to_address as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.to_address=tab2.from_address) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume-output_volume as "Balance" from tab3 ORDER BY 4 DESC), tab5 as (select address, ADDRESS_name from base.core.dim_labels) select tab4.address as ADDRESS, "Balance", case when "Balance"<=1 then 'Balance<=1 Unit' when "Balance">1 and "Balance"<=10 then '110 and "Balance"<=100 then '10100 and "Balance"<=1000 then '1001000 and "Balance"<=10000 then '1K10000 and "Balance"<=100000 then '10K100000 and "Balance"<=1000000 then '100K1000000 then 'Balance>1M Unit' end as "Classification" from tab4 left join tab5 on tab4.address=tab5.address WHERE "Balance">0) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", 'DAI' as "Stablecoin" from final_tab group by 1 order by 2), ----------------------------MIM------------------------------ TABLE2 AS (with final_tab as (with tab4 as (with tab3 as (with tab1 as (select to_address, sum(raw_amount)/pow(10,18) as input_vol from base.core.fact_token_transfers where contract_address=lower('0x4a3a6dd60a34bb2aba60d73b4c88315e9ceb6a3d') group by 1), tab2 as (select from_address, sum(raw_amount)/pow(10,18) as output_vol from base.core.fact_token_transfers where contract_address=lower('0x4a3a6dd60a34bb2aba60d73b4c88315e9ceb6a3d') group by 1) select to_address as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.to_address=tab2.from_address) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume-output_volume as "Balance" from tab3 ORDER BY 4 DESC), tab5 as (select address, ADDRESS_name from base.core.dim_labels) select tab4.address as ADDRESS, "Balance", case when "Balance"<=1 then 'Balance<=1 Unit' when "Balance">1 and "Balance"<=10 then '110 and "Balance"<=100 then '10100 and "Balance"<=1000 then '1001000 and "Balance"<=10000 then '1K10000 and "Balance"<=100000 then '10K100000 and "Balance"<=1000000 then '100K1000000 then 'Balance>1M Unit' end as "Classification" from tab4 left join tab5 on tab4.address=tab5.address WHERE "Balance">0) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", 'MIM' as "Stablecoin" from final_tab group by 1 order by 2), ----------------------------USDbc---------------------------- table3 as (with final_tab as (with tab4 as (with tab3 as (with tab1 as (select to_address, sum(raw_amount)/pow(10,6) as input_vol from base.core.fact_token_transfers where contract_address=lower('0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca') group by 1), tab2 as (select from_address, sum(raw_amount)/pow(10,6) as output_vol from base.core.fact_token_transfers where contract_address=lower('0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca') group by 1) select to_address as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.to_address=tab2.from_address) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume-output_volume as "Balance" from tab3 ORDER BY 4 DESC), tab5 as (select address, ADDRESS_name from base.core.dim_labels) select tab4.address as ADDRESS, "Balance", case when "Balance"<=1 then 'Balance<=1 Unit' when "Balance">1 and "Balance"<=10 then '110 and "Balance"<=100 then '10100 and "Balance"<=1000 then '1001000 and "Balance"<=10000 then '1K10000 and "Balance"<=100000 then '10K100000 and "Balance"<=1000000 then '100K1000000 then 'Balance>1M Unit' end as "Classification" from tab4 left join tab5 on tab4.address=tab5.address WHERE "Balance">0) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", 'USDbc' as "Stablecoin" from final_tab group by 1 order by 2), ----------------------------axlUSDC-------------------------- TABLE4 AS (with final_tab as (with tab4 as (with tab3 as (with tab1 as (select to_address, sum(raw_amount)/pow(10,6) as input_vol from base.core.fact_token_transfers where contract_address=lower('0xeb466342c4d449bc9f53a865d5cb90586f405215') group by 1), tab2 as (select from_address, sum(raw_amount)/pow(10,6) as output_vol from base.core.fact_token_transfers where contract_address=lower('0xeb466342c4d449bc9f53a865d5cb90586f405215') group by 1) select to_address as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.to_address=tab2.from_address) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume-output_volume as "Balance" from tab3 ORDER BY 4 DESC), tab5 as (select address, ADDRESS_name from base.core.dim_labels) select tab4.address as ADDRESS, "Balance", case when "Balance"<=1 then 'Balance<=1 Unit' when "Balance">1 and "Balance"<=10 then '110 and "Balance"<=100 then '10100 and "Balance"<=1000 then '1001000 and "Balance"<=10000 then '1K10000 and "Balance"<=100000 then '10K100000 and "Balance"<=1000000 then '100K1000000 then 'Balance>1M Unit' end as "Classification" from tab4 left join tab5 on tab4.address=tab5.address WHERE "Balance">0) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", 'axlUSDC' as "Stablecoin" from final_tab group by 1 order by 2), ----------------------------USDC-------------------------- TABLE5 AS (with final_tab as (with tab4 as (with tab3 as (with tab1 as (select to_address, sum(raw_amount)/pow(10,6) as input_vol from base.core.fact_token_transfers where contract_address=lower('0x833589fcd6edb6e08f4c7c32d4f71b54bda02913') group by 1), tab2 as (select from_address, sum(raw_amount)/pow(10,6) as output_vol from base.core.fact_token_transfers where contract_address=lower('0x833589fcd6edb6e08f4c7c32d4f71b54bda02913') group by 1) select to_address as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.to_address=tab2.from_address) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume-output_volume as "Balance" from tab3 ORDER BY 4 DESC), tab5 as (select address, ADDRESS_name from base.core.dim_labels) select tab4.address as ADDRESS, "Balance", case when "Balance"<=1 then 'Balance<=1 Unit' when "Balance">1 and "Balance"<=10 then '110 and "Balance"<=100 then '10100 and "Balance"<=1000 then '1001000 and "Balance"<=10000 then '1K10000 and "Balance"<=100000 then '10K100000 and "Balance"<=1000000 then '100K1000000 then 'Balance>1M Unit' end as "Classification" from tab4 left join tab5 on tab4.address=tab5.address WHERE "Balance">0) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", 'USDC' as "Stablecoin" from final_tab group by 1 order by 2) ------------------------------------------------------------- SELECT * FROM TABLE1 UNION ALL SELECT * FROM TABLE2 UNION ALL SELECT * FROM TABLE3 UNION ALL SELECT * FROM TABLE4 UNION ALL SELECT * FROM TABLE5

🔵Performance Analysis of Stablecoins on the Base