SocioCryptoTVL Over Time - Assets Composition
Updated 2023-11-04
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from global pools overview @ https://flipsidecrypto.xyz/edit/queries/a6e50735-8cfd-4119-9180-2cf42ee049a3
--MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA
-- Global pool
-- 6uQDwA2MAxCPNGho6yxPGbtPDky3mn8dfZ3atb1aB6SG -- uxd
-- 7P2TQHYgVJkXv1VPaREsL5Pi1gnNjVif5aF3pJewZ9kj -- wbtc
-- 26kcZkdjJc94PdhqiLiEaGiLCYgAVVUfpDaZyK4cqih3 -- bonk
-- DD3AeAssFvjqTvRTrRAtpfjkBF8FpVKnFuwnMLN9haXD -- sol
-- ELXogWuyXrFyUG1vevffVbEhVxdFrHf2GCJTtRGKBWdM -- eth
-- 8RcZHucpVHkHWRRdMhJZsxBK9mqKSYnMKGqtF84U8YEo -- bsol
-- 9r6z6KgkEytHCdQWNxvDQH98PsfU98f1m5PCg47mY2XE -- usdt
-- 3uxNepDbmkDNq6JhRja5Z8QwbTrfmkKP8AKZV5chYDGG -- usdc
-- 7VDS9KHnHuebmN8maraoiDAomdf4xdJ8tNF8KLJCKHin -- stsol
-- 7Ng54qf7BrCcZLqXmKA9WSR7SVRn4q6RX1YpLksBQ21A -- jitosol
-- 2SQcKvhxwyBHzwgWFvBT9DdbEkAQ8EDdVpL1LXuswN1T -- dust
-- 6YxGd65JbXzgFGWjE44jsyVeCnZp7Bb1wfL9jDia1n8w -- msol
-- Isolated pools
-- AjsyrYpgaH275DBSnvNWdGK33hVycSFuXN87FKnX6fVY -- HNT
-- 6PWVauGLhBFHUJspsnBVZHr56ZnbvmhSD2gS7czBHGpE -- LST
--
-- lst tvl solana : DqhH94PjkZsjAqEze2BEkWhFQJ6EyU6MdtMphMgnXqeK
--
with gp as ( SELECT * FROM
( values
('6uQDwA2MAxCPNGho6yxPGbtPDky3mn8dfZ3atb1aB6SG', 'uxd'),
('7P2TQHYgVJkXv1VPaREsL5Pi1gnNjVif5aF3pJewZ9kj', 'wbtc'),
('26kcZkdjJc94PdhqiLiEaGiLCYgAVVUfpDaZyK4cqih3', 'bonk'),
('DD3AeAssFvjqTvRTrRAtpfjkBF8FpVKnFuwnMLN9haXD', 'sol'),
('ELXogWuyXrFyUG1vevffVbEhVxdFrHf2GCJTtRGKBWdM', 'eth') ,
('8RcZHucpVHkHWRRdMhJZsxBK9mqKSYnMKGqtF84U8YEo', 'bsol'),
('9r6z6KgkEytHCdQWNxvDQH98PsfU98f1m5PCg47mY2XE', 'usdt'),
('3uxNepDbmkDNq6JhRja5Z8QwbTrfmkKP8AKZV5chYDGG', 'usdc'),
('7VDS9KHnHuebmN8maraoiDAomdf4xdJ8tNF8KLJCKHin', 'stsol'),
Auto-refreshes every 24 hours
Run a query to Download Data