Punchswap swaps volume

adriaparcerisasPunchswap swaps volume

Updated 7 hours ago

-- 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'

-- WHEN lower(x.contract_address) = LOWER('0x7296ebca325e835eb6c1b690484cf6fb4c396d2c') THEN 'Bartholomeow'

-- WHEN lower(x.contract_address) = LOWER('0x6a64e027e3f6a94acbdcf39cf0cbb4bead5f5ecb') THEN 'HotCocoa'

-- when lower(x.contract_address)=lower('0xE8b7423b80f9aF33480D365171c7ceDa3586aa35') then 'Purrzival'

-- when lower(x.contract_address)=lower('0xf45CBE30bD953590C9917799142Edb05Be3F293F') then 'Gwendolion'

-- when lower(x.contract_address)=lower('0x8bD75008361517Df04AA3ea033F03ba33C0C0A66') then 'GangGang'

-- when lower(x.contract_address)=lower('0x9b565507858812e8B5FfbFBDE9B200A3bc2e8F76') then 'Catseye'

-- when lower(x.contract_address)=lower('0x10448481630fb6d20B597e5B3d7e42DCb1247C8A') then 'Pawderick'

-- when lower(x.contract_address)=lower('0xC618a7356FcF601f694C51578CD94144Deaee690') then 'TSHOT'

-- ELSE 'wFLOW'

-- END AS asset,

-- x.event_index,

Last run: about 7 hours ago

...

244

12KB

11s

flipside