DATE | ASSET | VOLUME_USD | |
|---|---|---|---|
1 | 2025-04-28 00:00:00.000 | wFLOW | 161870.468918228 |
2 | 2025-04-28 00:00:00.000 | AVO | 13.656273364 |
3 | 2025-04-28 00:00:00.000 | USDC.e | 106.612519 |
4 | 2025-04-28 00:00:00.000 | TRUMP | 3045.470243823 |
5 | 2025-04-27 00:00:00.000 | USDC.e | 78.102446 |
6 | 2025-04-27 00:00:00.000 | TRUMP | 7092.48343559 |
7 | 2025-04-27 00:00:00.000 | BETA | 39.683102748 |
8 | 2025-04-27 00:00:00.000 | wFLOW | 144508.200735055 |
9 | 2025-04-27 00:00:00.000 | AVO | 45.370932483 |
10 | 2025-04-26 00:00:00.000 | TRUMP | 10371.826780485 |
11 | 2025-04-26 00:00:00.000 | AVO | 62.820921116 |
12 | 2025-04-26 00:00:00.000 | BETA | 170.910935502 |
13 | 2025-04-26 00:00:00.000 | USDC.e | 95.284568 |
14 | 2025-04-26 00:00:00.000 | wFLOW | 171658.196280751 |
15 | 2025-04-25 00:00:00.000 | TRUMP | 3552.623844153 |
16 | 2025-04-25 00:00:00.000 | wFLOW | 294867.993205826 |
17 | 2025-04-25 00:00:00.000 | USDC.e | 74.255201 |
18 | 2025-04-25 00:00:00.000 | BETA | 47.793859479 |
19 | 2025-04-25 00:00:00.000 | AVO | 137.393049933 |
20 | 2025-04-24 00:00:00.000 | BETA | 30.119129327 |
adriaparcerisasPunchswap swaps volume by asset
Updated 9 hours ago
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
›
⌄
WITH swaps AS (
SELECT x.tx_hash,
x.origin_from_address,
x.contract_address,
y.tx_fee,
x.block_timestamp,
CASE
WHEN lower(x.contract_address) = LOWER('0x1b97100ea1d7126c4d60027e231ea4cb25314bdb') THEN 'ankrFLOWEVM'
WHEN lower(x.contract_address) = LOWER('0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52') THEN 'USDC.e'
WHEN lower(x.contract_address) = LOWER('0x5598c0652b899eb40f169dd5949bdbe0bf36ffde') THEN 'stFlow'
WHEN lower(x.contract_address) = LOWER('0x9C7Efd8ecD7C5e8b51a3833F6FB67c6E2F4f4a9B') THEN 'FROTH'
WHEN lower(x.contract_address) = LOWER('0x68eb683a393C8a1C816255b4FC4B89d73C52AD4b') THEN 'PUMP'
WHEN lower(x.contract_address) = LOWER('0xd8Ad8AE8375aa31BFF541e17dC4b4917014EbDAa') THEN 'BETA'
WHEN lower(x.contract_address) = LOWER('0x995258Cea49C25595CD94407FaD9E99B81406A84') THEN 'AVO'
WHEN lower(x.contract_address) = LOWER('0xEC0F7E75128781c2924Ad907A379909Ae531d050') THEN 'LOPPY'
WHEN lower(x.contract_address) = LOWER('0x6a2cD141d75864944318acf272443FEBC54855a9') THEN 'VINYL'
WHEN lower(x.contract_address) = LOWER('0x4DcDd1b9A5103fA5F13CC4c3b758E05FFaccb4DD') THEN 'MVP'
WHEN lower(x.contract_address) = LOWER('0x169bb04590fbF18B09739f951274Aa5650DFcCdE') THEN 'TSR'
WHEN lower(x.contract_address) = LOWER('0xD59D7c7F4D063A707a021C7c49c5cFb4fAF94cB0') THEN 'PEPE'
WHEN lower(x.contract_address) = LOWER('0x40b0f603Fd1165db32AF769771428Be100f8434E') THEN 'COON'
when lower(x.contract_address)=lower('0x8b2f3a6e7ad5f971ff5d4e597a4ebc58b2d2758e') then 'DUCAT'
when lower(x.contract_address)=lower('0xd3378b419feae4e3a4bb4f3349dba43a1b511760') then 'TRUMP'
ELSE 'wFLOW'
END AS asset,
x.event_index,
x.data,
CASE
WHEN lower(x.contract_address) = LOWER('0x1b97100ea1d7126c4d60027e231ea4cb25314bdb') THEN 18
WHEN lower(x.contract_address) = LOWER('0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52') THEN 6
WHEN lower(x.contract_address) = LOWER('0x5598c0652b899eb40f169dd5949bdbe0bf36ffde') THEN 18
WHEN lower(x.contract_address) = LOWER('0x9C7Efd8ecD7C5e8b51a3833F6FB67c6E2F4f4a9B') THEN 18
WHEN lower(x.contract_address) = LOWER('0x68eb683a393C8a1C816255b4FC4B89d73C52AD4b') THEN 18
WHEN lower(x.contract_address) = LOWER('0xd8Ad8AE8375aa31BFF541e17dC4b4917014EbDAa') THEN 18
WHEN lower(x.contract_address) = LOWER('0x995258Cea49C25595CD94407FaD9E99B81406A84') THEN 18
WHEN lower(x.contract_address) = LOWER('0xEC0F7E75128781c2924Ad907A379909Ae531d050') THEN 18
WHEN lower(x.contract_address) = LOWER('0x6a2cD141d75864944318acf272443FEBC54855a9') THEN 18
Last run: about 9 hours ago
...
1124
55KB
6s