Dapps copy | fat_darth_vader-yxkQbB

Updated 2025-03-13

-- forked from Dapps @ https://flipsidecrypto.xyz/studio/queries/8b85698d-ebe0-4005-adce-bae60eae5ecb

-- SELECT COUNT(*)

-- FROM SOLANA.core.dim_labels

-- 39.936.758

-- SELECT COUNT(*)

-- FROM SOLANA.defi.ez_dex_swaps

-- 6.720.212.239

-- This table is very slow for some reason

-- SELECT COUNT(*)

-- FROM SOLANA.defi.fact_bridge_activity

-- 5.991.388

-- SELECT COUNT(*)

-- FROM SOLANA.defi.fact_swaps

-- 7.214.992.084

-- SELECT COUNT(*)

-- FROM SOLANA.defi.fact_swaps_jupiter_inner

-- 2.383.808.

-- SELECT COUNT(*)

-- FROM SOLANA.marinade.ez_swaps

-- 44.342.430

-- SELECT INITCAP(SPLIT_PART(SPLIT_PART(platform, ' ', 1), '.', 1)) AS platform, COUNT(program_id)

Last run: about 1 month ago

	COUNT(*)
1	268734249

13B