Flipside Teamswap total by dex copy
Updated 2024-11-14
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 h4wk / swap total by dex @ https://flipsidecrypto.xyz/h4wk/q/fHeWQDphqsLT/swap-total-by-dex
-- forked from swap over time by dex @ https://flipsidecrypto.xyz/studio/queries/c03e405c-f219-4565-a386-49cda32c8153
-- forked from base swap table @ https://flipsidecrypto.xyz/studio/queries/68dd4673-940f-45a1-b102-3c29067c140a
-- Sample TXs
------------------------------------------------------------------------------
-- LIFINITY (Program ID 4UsSbJQZJTfZDFrgvcPBRCSg5BbcQE6dobnriCafzj12)
-- TX vAfKovZVf8TmLTh1otpEGHwFb241vTAa3jnBbSqN4HUuWE2nfZZjYHpjCXygpbvDm1TFAnHGXJwBQaWA1GFrfB6
------------------------------------------------------------------------------
-- INVARIANT (Program ID iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEU)
-- TX 4s3KyStaQf7Ks3tiCqqTZAa6bVXTGzWAUacQgsGrKRUEox2SaLV6SZq9A1kqzoxvqZfYfxZngdteqrSsNVAxw7UP
------------------------------------------------------------------------------
-- ORCA (Program ID whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc)
-- yzytQ8XFsPVHxjNJQvitjuxQ2VB7J17mE6FEd27xF3jv6JHJVzFCHubMCWjKpYaNRV9m62wgwEhNegpTHztf8ZF
------------------------------------------------------------------------------
with tokens as (
select * from ( values
('USDC', 'USD Coin', 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'),
('SOL', 'Solana', 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL'),
('WIF', 'DogWifHat', '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH'),
('tETH', 'Turbo ETH', 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn'),
('ORCA', 'Orca', '2tGbYEm4nuPFyS6zjDTELzEhvVKizgKewi6xT7AaSKzn'),
('USDT', 'Tether USD', 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm'),
('TIA', 'Celestia', '9RryNMhAVJpAwAGjCAMKbbTFwgjapqPkzpGMfTQhEjf8'),
('STTIA', 'Stride Staked TIA', 'V5m1Cc9VK61mKL8xVYrjR7bjD2BC5VpADLa6ws3G8KM'),
('WEETHS', 'Super Symbiotic LRT', 'F72PqK74jc28zjC7kWDk6ykJ2ZAbjNzn2jaAY9v9M6om'),
('WBTC', 'Wrapped BTC', '7UTjr1VC6Z9DPsWD6mh5wPzNtufN17VnzpKS3ASpfAji'),
('ETH', 'Ethereum', 'So11111111111111111111111111111111111111112')
) as t(symbol, name, mint)
)
, dexs as (
select * from ( values
('LIFINITY', '4UsSbJQZJTfZDFrgvcPBRCSg5BbcQE6dobnriCafzj12'),
('INVARIANT', 'iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEU'),
QueryRunArchived: QueryRun has been archived