flipside

    test swaps
    datavortextest swaps
    Updated 2025-03-04
    WITH token_mapping AS (
    SELECT
    tx_hash,
    amount_raw,
    token_id,
    block_timestamp,
    CASE
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'sol-c58e6539c2f2e097c251f8edf11f9c03e581f8d4.omft.near' THEN 'TURBO'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'base.omft.near' THEN 'WETH'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'eth-0xdac17f958d2ee523a2206206994597c13d831ec7.omft.near' THEN 'USDT'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'sol-df27d7abcc1c656d4ac3b1399bbfbba1994e6d8c.omft.near' THEN 'TURBO'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'token.sweat' THEN 'SWEAT'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'zec.omft.near' THEN 'WZEC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'gnear-229.meme-cooking.near' THEN 'GNEAR'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'abg-966.meme-cooking.near' THEN 'ABG'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'token.0xshitzu.near' THEN 'SHITZU'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'gnosis-0xddafbb505ad214d7b80b1f830fccc89b60fb7a83.omft.near' THEN 'USDC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'gnosis-0x4d18815d14fe5c3304e87b3fa18318baa5c23820.omft.near' THEN 'SAFE'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'arb-0xaf88d065e77c8cc2239327c5edb3a432268e5831.omft.near' THEN 'USDC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'eth-0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9.omft.near' THEN 'AAVE'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'blackdragon.tkn.near' THEN 'BLACKDRAGON'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'gnosis-0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1.omft.near' THEN 'WETH'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'sol-c800a4bd850783ccb82c2b2c7e84175443606352.omft.near' THEN 'USDT'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'base-0x833589fcd6edb6e08f4c7c32d4f71b54bda02913.omft.near' THEN 'USDC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'bera.omft.near' THEN 'BERA'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'token.v2.ref-finance.near' THEN 'REF'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'sol.omft.near' THEN 'SOL'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'doge.omft.near' THEN 'DOGE'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'aaaaaa20d9e0e2461697782ef11675f668207961.factory.bridge.near' THEN 'AURORA'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'noear-324.meme-cooking.near' THEN 'NOEAR'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'eth-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.omft.near' THEN 'USDC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'sol-d600e625449a4d9380eaf5e3265e54c90d34e260.omft.near' THEN 'MELANIA'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'eth-0x6b175474e89094c44da98b954eedeac495271d0f.omft.near' THEN 'DAI'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'btc.omft.near' THEN 'WBTC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'a35923162c49cf95e6bf26623385eb431ad920d3.factory.bridge.near' THEN 'NEAR'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'aurora' THEN 'AURORA'
    Last run: 3 months ago
    TX_HASH
    AMOUNT_RAW
    TOKEN_ID
    TOKEN_SYMBOL
    AVERAGE_PRICE
    DECIMALS
    DAYS
    AMOUNT_USD
    1
    		D79B9Huqrio1wCr3qSoY7rY3dwcWm8e9mPTYYGeKfNGw7946586053425570
    nep141:eth.omft.near
    		WETH2257.37849182025-02-27 00:00:00.00017.938452426
    2
    		E4aTAH98mK7fZrj55RrgE9Xibhqbi6bUsJynGCGhDfR4000000000000000
    nep141:base.omft.near
    		WETH2257.37849182025-02-27 00:00:00.0009.02951396
    3
    		D3yuJ9qVuFpTehsX9G9NA55oBxHuX6Qu1a24sqG3XckX1836638
    nep141:eth-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.omft.near
    		USDC0.93585662025-02-27 00:00:00.0001.718828692
    4
    		FxqgWv43aWoYddL9QpjKn5y5krh6UHGQkvKUjh5RqNVs100000000000000000000000
    nep141:wrap.near
    		NEAR3.072187182025-02-27 00:00:00.000307218.7
    5
    		C9edyFgxzdAtNTbAbav1x1vWFANhFrZqAiTg5dyzo4j2100000000000000000000000
    nep141:wrap.near
    		NEAR3.072187182025-02-27 00:00:00.000307218.7
    6
    		8p85shg4sGBD1DiMXUdR6xWtqAbqopMRtbCvMxynG4TZ454400
    nep141:17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1
    		USDC0.93585662025-02-27 00:00:00.0000.4252529664
    7
    		C3RRUwTBaJTz7gZCn48rQdARyPwRawiBgtR78eZcMt6x1000000000000000000
    nep141:eth.omft.near
    		WETH2257.37849182025-02-27 00:00:00.0002257.37849
    8
    		DSf5wx7Kig8hpxqXMKauZEEtMn8K26yyra3atdroaAhX100000000000000000000000
    nep141:wrap.near
    		NEAR3.072187182025-02-27 00:00:00.000307218.7
    9
    		3EC3j4M2Y8Yse86v8rUhEhLbvJndTHFQHhoFonRAx3Rh6677059
    nep141:eth-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.omft.near
    		USDC0.93585662025-02-27 00:00:00.0006.248765728
    10
    		Eg9HnNhRsZtQCr2ZJAbYJrmxYB6DDgWz6yDyeauGGzne100000000
    nep141:eth-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.omft.near
    		USDC0.93585662025-02-27 00:00:00.00093.5856
    11
    		FUYR3Q5peYLarHHjnjQQ9tRCJGEZH8DJ9RWFQc3GZKyB100000000000000000000000
    nep141:wrap.near
    		NEAR3.072187182025-02-27 00:00:00.000307218.7
    12
    		EZwW3yGmkjZxYpFbQxZgXkeiwzCD3PrsgRhEQN3mNoB3500000000000000000
    nep141:base.omft.near
    		WETH2257.37849182025-02-27 00:00:00.0001128.689245
    13
    		3VvPK23VEpHcCQHmaobn1EZ48FePY3qZVu98trCT17Ai100000000000000000000000
    nep141:wrap.near
    		NEAR3.072187182025-02-27 00:00:00.000307218.7
    14
    		CPk4C8eWVraUn8VCmUwMAhDBe5PQzdbYCW9Wk6ksCsWT55536787
    nep141:eth-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.omft.near
    		USDC0.93585662025-02-27 00:00:00.00051.974435335
    15
    		GDmjStgbNahf79WHQ5Ut9xf1DMNWNN97UQHnPkn116Fp4998810
    nep141:eth-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.omft.near
    		USDC0.93585662025-02-27 00:00:00.0004.678166331
    16
    		ATsUBh1M2ir7emQy6YGwch9eGE1wownLGsH8p4XPaSS355536787
    nep141:eth-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.omft.near
    		USDC0.93585662025-02-27 00:00:00.00051.974435335
    17
    		545ZtU5aegPo9qg8hEeE5FeVxsXCJ3Xhw8WF8uXK9ocZ100000000000000000000000
    nep141:wrap.near
    		NEAR3.072187182025-02-27 00:00:00.000307218.7
    18
    		4wjVAcQ4y4iMWnipjmiZeMtNKxsTEkutPNqzwuZBgj1Q100000000000000000000000
    nep141:wrap.near
    		NEAR3.072187182025-02-27 00:00:00.000307218.7
    19
    		8GYg3g4YQtV2MgMWrEf48xig4JVdpyX7FaxsVQq3LGzz100000000000000000000000
    nep141:wrap.near
    		NEAR3.072187182025-02-27 00:00:00.000307218.7
    20
    		2BeDcyZqQ6hbF8KKX1fNyKWXXFm3QpWtkYDmpdDbtDki1682987
    nep141:base-0x833589fcd6edb6e08f4c7c32d4f71b54bda02913.omft.near
    		USDC0.93585662025-02-27 00:00:00.0001.575033482
    ...
    25430
    4MB
    4s