DATE | VOLUME_USD | TOTAL_VOLUME_USD | |
|---|---|---|---|
1 | 2025-04-28 00:00:00.000 | 45177.14 | 14055632.92 |
2 | 2025-04-27 00:00:00.000 | 31912.16 | 14010455.78 |
3 | 2025-04-26 00:00:00.000 | 55299.29 | 13978543.62 |
4 | 2025-04-25 00:00:00.000 | 112554.29 | 13923244.33 |
5 | 2025-04-24 00:00:00.000 | 40177.22 | 13810690.04 |
6 | 2025-04-23 00:00:00.000 | 79873.08 | 13770512.82 |
7 | 2025-04-22 00:00:00.000 | 60350.89 | 13690639.74 |
8 | 2025-04-21 00:00:00.000 | 30744.57 | 13630288.85 |
9 | 2025-04-20 00:00:00.000 | 27313.93 | 13599544.28 |
10 | 2025-04-19 00:00:00.000 | 26231.63 | 13572230.35 |
11 | 2025-04-18 00:00:00.000 | 26260.31 | 13545998.72 |
12 | 2025-04-17 00:00:00.000 | 22859.15 | 13519738.41 |
13 | 2025-04-16 00:00:00.000 | 53812.81 | 13496879.26 |
14 | 2025-04-15 00:00:00.000 | 29832.27 | 13443066.45 |
15 | 2025-04-14 00:00:00.000 | 57926.66 | 13413234.18 |
16 | 2025-04-13 00:00:00.000 | 38640.2 | 13355307.52 |
17 | 2025-04-12 00:00:00.000 | 22072.78 | 13316667.32 |
18 | 2025-04-11 00:00:00.000 | 51963.34 | 13294594.54 |
19 | 2025-04-10 00:00:00.000 | 45184.29 | 13242631.2 |
20 | 2025-04-09 00:00:00.000 | 88016.06 | 13197446.91 |
adriaparcerisasPunchswap swaps volume
Updated 20 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'
when lower(x.contract_address)=lower('0x2aaBea2058b5aC2D339b163C6Ab6f2b6d53aabED') then 'USDF'
when lower(x.contract_address)=lower('0xF1815bd50389c46847f0Bda824eC8da914045D14') then 'stgUSDC'
when lower(x.contract_address)=lower('0x3A33C904C132822Ce01948CE318C15988727D1dB') then 'JUICE'
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
Last run: about 20 hours ago
...
230
11KB
6s