0xHaM-dswaps last week
Updated 2025-02-15
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 flyingfish / swaps last 24 hours @ https://flipsidecrypto.xyz/flyingfish/q/uEBRTtdYIfGk/swaps-last-24-hours
-- forked from h4wk / swap total @ https://flipsidecrypto.xyz/h4wk/q/fawA-tt5y7ol/swap-total
-- forked from swap total by dex @ https://flipsidecrypto.xyz/studio/queries/f477de70-d9fe-46dd-8f56-0b54658e438b
-- 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'),
('ETH', '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)
)
QueryRunArchived: QueryRun has been archived