flipside

    sandbox
    tomingsandbox
    Updated 2025-03-21
    -- SELECT
    -- *
    -- from
    -- ethereum.core.ez_token_transfers
    -- WHERE
    -- block_timestamp BETWEEN (CURRENT_DATE - 2) AND CURRENT_DATE
    -- AND
    -- contract_address=lower('0x1121acc14c63f3c872bfca497d10926a6098aac5')
    -- TO_ADDRESS = lower('0x4A422B7739ba007c2C58F7a1f5C1fF1EF82F44Bf')
    -- AND
    -- block_number > 20566704
    -- LIMIT 100


    -- SELECT
    -- count(tx_hash) as tx_num,
    -- contract_address,
    -- SYMBOL_IN,
    -- SYMBOL_OUT,
    -- TOKEN_IN,
    -- TOKEN_OUT
    -- FROM
    -- ethereum.defi.ez_dex_swaps
    -- WHERE
    -- block_timestamp > '2024-09-11'
    -- GROUP BY
    -- 2,3,4,5,6
    -- ORDER BY
    -- 1 DESC


    select
    *
    from
    bsc.defi.ez_dex_swaps
    where
    Last run: 26 days ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    ORIGIN_FUNCTION_SIGNATURE
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    CONTRACT_ADDRESS
    POOL_NAME
    EVENT_NAME
    AMOUNT_IN_UNADJ
    AMOUNT_IN
    AMOUNT_IN_USD
    AMOUNT_OUT_UNADJ
    AMOUNT_OUT
    AMOUNT_OUT_USD
    SENDER
    TX_TO
    EVENT_INDEX
    PLATFORM
    TOKEN_IN
    TOKEN_OUT
    SYMBOL_IN
    SYMBOL_OUT
    _LOG_ID
    EZ_DEX_SWAPS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		476429702025-03-20 22:43:15.0000x5c03db7cb619a6b721338144edb5244052b50a37d1ac63dd3a582cc11764f4ea0x414bf3890xce74d93027d62e323807dbfed9408dd0e4a0a7070x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap4.07305756915304e+214073.057569153120371253395431000000120.3712533950x1b81d678ffb9c0263b24a97847620c99d213eb140xce74d93027d62e323807dbfed9408dd0e4a0a707227pancakeswap-v30x29e7dee3bb8c735d8f7877a91b318f77fa8d92eb0x55d398326f99059ff775485246999027b3197955OBBUSDT0x5c03db7cb619a6b721338144edb5244052b50a37d1ac63dd3a582cc11764f4ea-227cc126901c014f7f093f76c717600e7942025-03-21 00:03:54.4552025-03-21 00:03:54.455
    2
    		476428752025-03-20 22:38:30.0000x24c9e64fa2769abd672c92f27b0d02e108cfc163e5be17a813362f88198c650b0x414bf3890xd47ad47bac0ca0c168df0666cb5a760440741ffa0x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap2.11329640987864e+212113.2964098796292637906734370000062.9263790670x1b81d678ffb9c0263b24a97847620c99d213eb140xd47ad47bac0ca0c168df0666cb5a760440741ffa229pancakeswap-v30x29e7dee3bb8c735d8f7877a91b318f77fa8d92eb0x55d398326f99059ff775485246999027b3197955OBBUSDT0x24c9e64fa2769abd672c92f27b0d02e108cfc163e5be17a813362f88198c650b-229b3ae9b0d9d5f5a0a2e2b06969fa8e5922025-03-21 00:03:54.4552025-03-21 00:03:54.455
    3
    		476428702025-03-20 22:38:15.0000xa72dbcadcc61fdb17eda5f488cad40554071a8e6df6c1a93ba8fdcc7b05745980x414bf3890x25866268c6d8311d924bb57d0ad673583a6c0aab0x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap3.4347341443908e+213434.734144391102970207733938000000102.9702077340x1b81d678ffb9c0263b24a97847620c99d213eb140x25866268c6d8311d924bb57d0ad673583a6c0aab138pancakeswap-v30x29e7dee3bb8c735d8f7877a91b318f77fa8d92eb0x55d398326f99059ff775485246999027b3197955OBBUSDT0xa72dbcadcc61fdb17eda5f488cad40554071a8e6df6c1a93ba8fdcc7b0574598-13885d5086b593977996cededd6e67ef8142025-03-21 00:03:54.4552025-03-21 00:03:54.455
    4
    		476427752025-03-20 22:33:30.0000x2285d6fde886b8cf662679482548509d82ee9eba83b7fad4b365eb28bc6b22b10x414bf3890x7514c6f600e4ad278c085bf1f67e1f25d88c1e390x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap69902247572479900006.990224757232211251413069000000232.2112514130x1b81d678ffb9c0263b24a97847620c99d213eb140x7514c6f600e4ad278c085bf1f67e1f25d88c1e39195pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0x2285d6fde886b8cf662679482548509d82ee9eba83b7fad4b365eb28bc6b22b1-195b1a9304d010c1eed15352f6b484f1cad2025-03-21 00:03:54.4552025-03-21 00:03:54.455
    5
    		476427712025-03-20 22:33:18.0000x07c5f1ee696e8e69564ebd7eab4878f3450577ac79ff49b5540ad838cfc702430x414bf3890x22167a4827c094cbd77b559bb9db243b8ab075f10x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap105759775242752000000105.7597752433.52949500796039e+213529.495007960x1b81d678ffb9c0263b24a97847620c99d213eb140x22167a4827c094cbd77b559bb9db243b8ab075f13636pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0x07c5f1ee696e8e69564ebd7eab4878f3450577ac79ff49b5540ad838cfc70243-3636eaec3a91a7e7e486f45070653069a8c42025-03-21 00:03:54.4552025-03-21 00:03:54.455
    6
    		476426772025-03-20 22:28:36.0000x96f744baeb277eaf79a91b70906643e8ac47e1126c90741b4f4dff7dab1ab8f90x414bf3890xf65061dd0af03ca791d98d655e483a9bab785ebe0x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap7663267652752970000076.6326765282.57659895450442e+212576.5989545040x1b81d678ffb9c0263b24a97847620c99d213eb140xf65061dd0af03ca791d98d655e483a9bab785ebe155pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0x96f744baeb277eaf79a91b70906643e8ac47e1126c90741b4f4dff7dab1ab8f9-155fe7532e1bba0e8ab2a3bdebdba0ff7ca2025-03-21 00:03:54.4552025-03-21 00:03:54.455
    7
    		476426752025-03-20 22:28:30.0000x7d8505337904f1be5425befa5dc678d9764f07ef25ac63793e9cc603a76cba7c0x414bf3890xcb428b0f1e8a4bce41cfc991201c6a2610b8115b0x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap5732835149281130000057.3283514931.93816385256592e+211938.1638525660x1b81d678ffb9c0263b24a97847620c99d213eb140xcb428b0f1e8a4bce41cfc991201c6a2610b8115b148pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0x7d8505337904f1be5425befa5dc678d9764f07ef25ac63793e9cc603a76cba7c-14847ca9f17c04d91afe4cdfdc924c3169c2025-03-21 00:03:54.4552025-03-21 00:03:54.455
    8
    		476426702025-03-20 22:28:15.0000x90481d3b1bfd35e5aa00850406739cfe609a4b14ac8fa7ac178733d6cc6b5de20x414bf3890xd5404f8c606de1346221e3f1964abe354beed0180x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap5166897197965910000051.668971981.75468493206979e+211754.684932070x1b81d678ffb9c0263b24a97847620c99d213eb140xd5404f8c606de1346221e3f1964abe354beed018154pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0x90481d3b1bfd35e5aa00850406739cfe609a4b14ac8fa7ac178733d6cc6b5de2-1547868d402ed1d2086a2252e9f2b2c55132025-03-21 00:03:54.4552025-03-21 00:03:54.455
    9
    		476425702025-03-20 22:23:15.0000x9046817fc53f1f9714024c7d2b3e7f665cbf8cc1e3d35dbee9b751492d08c3650x414bf3890x536b51f686ef762be914e659fc967f45d9a011620x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap3.93514107262799e+213935.141072628116159752940892000000116.1597529410x1b81d678ffb9c0263b24a97847620c99d213eb140x536b51f686ef762be914e659fc967f45d9a01162149pancakeswap-v30x29e7dee3bb8c735d8f7877a91b318f77fa8d92eb0x55d398326f99059ff775485246999027b3197955OBBUSDT0x9046817fc53f1f9714024c7d2b3e7f665cbf8cc1e3d35dbee9b751492d08c365-14995a56ff7bb76b4d24844034896671c4f2025-03-21 00:03:54.4552025-03-21 00:03:54.455
    10
    		476424752025-03-20 22:18:30.0000xa8fd164bcf42ac831d191dd11e0ac7d568a1c45b7a2405b98b0ea5c761d775dd0x414bf3890xc80c507db7ab9cc0f339493c9608eb155d33354f0x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap5864628912687360000058.6462891271.98165921050214e+211981.6592105020x1b81d678ffb9c0263b24a97847620c99d213eb140xc80c507db7ab9cc0f339493c9608eb155d33354f80pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0xa8fd164bcf42ac831d191dd11e0ac7d568a1c45b7a2405b98b0ea5c761d775dd-80bf196212a3d7bcbf0023c114fa5849392025-03-21 00:03:54.4552025-03-21 00:03:54.455
    11
    		476424712025-03-20 22:18:18.0000x6adb796ba0ebbb1b6b99eb72005ab4f3f11bdd3644302bea5a95a7eb1c0c62630x414bf3890xe713e5022c027b2e4fb66299c590889f20040f020x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap119803710873126000000119.8037108734.07804549498823e+214078.0454949880x1b81d678ffb9c0263b24a97847620c99d213eb140xe713e5022c027b2e4fb66299c590889f20040f02125pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0x6adb796ba0ebbb1b6b99eb72005ab4f3f11bdd3644302bea5a95a7eb1c0c6263-12545df30c674f021e23f866a85af0e348d2025-03-21 00:03:54.4552025-03-21 00:03:54.455
    12
    		476423702025-03-20 22:13:15.0000x11674b3c4b205c3e5ff9af1fcfd2e126b81450c4b73ea41efb3ffa71724378aa0x414bf3890x632d6ccc0364a0d8714c9c8da6643f59a839fd130x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap4.61882238136509e+214618.822381365135752486845732000000135.7524868460x1b81d678ffb9c0263b24a97847620c99d213eb140x632d6ccc0364a0d8714c9c8da6643f59a839fd13106pancakeswap-v30x29e7dee3bb8c735d8f7877a91b318f77fa8d92eb0x55d398326f99059ff775485246999027b3197955OBBUSDT0x11674b3c4b205c3e5ff9af1fcfd2e126b81450c4b73ea41efb3ffa71724378aa-10652bf6c4593f0d1df0713848499a6ff632025-03-21 00:03:54.4552025-03-21 00:03:54.455
    13
    		476422742025-03-20 22:08:27.0000x75a409c2bcc2f3a3f57eef8255e029905115cd7274727e50512b41c8631dfdf70x414bf3890x5080d3c6ca8673c2b0ee7044100fcc2a310f744d0x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap2229476167111670000022.294761671754859547936355000000754.8595479360x1b81d678ffb9c0263b24a97847620c99d213eb140x5080d3c6ca8673c2b0ee7044100fcc2a310f744d301pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0x75a409c2bcc2f3a3f57eef8255e029905115cd7274727e50512b41c8631dfdf7-3019fad57a01be2974b9da92ce193c1ad582025-03-21 00:03:54.4552025-03-21 00:03:54.455
    14
    		476422702025-03-20 22:08:15.0000x50c23ac8a937635c9d511936a9bb14ac26d4e1e4ef9497caf23e4ab7397021430x414bf3890x536b51f686ef762be914e659fc967f45d9a011620x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap121715238328883000000121.7152383294.14560609602663e+214145.6060960270x1b81d678ffb9c0263b24a97847620c99d213eb140x536b51f686ef762be914e659fc967f45d9a01162134pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0x50c23ac8a937635c9d511936a9bb14ac26d4e1e4ef9497caf23e4ab739702143-134cd90505ad0b43d146bacb2c091c6157b2025-03-21 00:03:54.4552025-03-21 00:03:54.455
    15
    		476421772025-03-20 22:03:36.0000xe8e7c01834047ecb07810fcc1f933660bfb18b4e10176a1ccc80d350c1e2305b0x414bf3890xc33185fc5cb2f2cfb2c861be2a5944dd619a65ab0x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap3.70330030808863e+213703.300308089108648949671244000000108.6489496710x1b81d678ffb9c0263b24a97847620c99d213eb140xc33185fc5cb2f2cfb2c861be2a5944dd619a65ab143pancakeswap-v30x29e7dee3bb8c735d8f7877a91b318f77fa8d92eb0x55d398326f99059ff775485246999027b3197955OBBUSDT0xe8e7c01834047ecb07810fcc1f933660bfb18b4e10176a1ccc80d350c1e2305b-143c5d80a53eb32db0ab33af1ed018f128c2025-03-21 00:03:54.4552025-03-21 00:03:54.455
    16
    		476421742025-03-20 22:03:27.0000x4cbef84d4701b48e812b056e774b2c66a89f293f8b73b2a0d314d84b9c6051110x414bf3890x4182dcb0d1b1ec577aab4c690c0b7b9e3be3cf450x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap939951412551009000000939.9514125512773229014828390000027.7322901480x1b81d678ffb9c0263b24a97847620c99d213eb140x4182dcb0d1b1ec577aab4c690c0b7b9e3be3cf45177pancakeswap-v30x29e7dee3bb8c735d8f7877a91b318f77fa8d92eb0x55d398326f99059ff775485246999027b3197955OBBUSDT0x4cbef84d4701b48e812b056e774b2c66a89f293f8b73b2a0d314d84b9c605111-177505899763b82d3774e360382f5d0c2982025-03-21 00:03:54.4552025-03-21 00:03:54.455
    17
    		476421712025-03-20 22:03:18.0000xd7c59e0e08e7de69c3d895768bc5d0f86ba87d705651ac757cde293756a37ad20x414bf3890xcff75e832db1131cd3cdb15123871c95cf96ef330x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap2.04673557781308e+212046.7355778136060653385570560000060.6065338560x1b81d678ffb9c0263b24a97847620c99d213eb140xcff75e832db1131cd3cdb15123871c95cf96ef33133pancakeswap-v30x29e7dee3bb8c735d8f7877a91b318f77fa8d92eb0x55d398326f99059ff775485246999027b3197955OBBUSDT0xd7c59e0e08e7de69c3d895768bc5d0f86ba87d705651ac757cde293756a37ad2-133139d89f7efcefea2f987ebf6eb7d106e2025-03-21 00:03:54.4552025-03-21 00:03:54.455
    18
    		476420772025-03-20 21:58:36.0000x6601a9e5b71662a1a9b90360ea350c260b362868f4030979e3485157bea0a37a0x414bf3890xbf347e54133bcc96a2c05710e6ca023205aa41160x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap86462817774744900008.646281777291311319605811000000291.3113196060x1b81d678ffb9c0263b24a97847620c99d213eb140xbf347e54133bcc96a2c05710e6ca023205aa4116147pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0x6601a9e5b71662a1a9b90360ea350c260b362868f4030979e3485157bea0a37a-1476767d5d2e937450063644fa55035d7c52025-03-21 00:03:54.4552025-03-21 00:03:54.455
    19
    		476420752025-03-20 21:58:30.0000xd7615484f03f655a98cb7fac876cfc1c0d25888eca5c6ee75b90fc98aaa0a7bd0x414bf3890x54bc708fd5bd1a262e4982186d8e499041b6c1310x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap9302821108449680000093.0282110843.14744725682288e+213147.4472568230x1b81d678ffb9c0263b24a97847620c99d213eb140x54bc708fd5bd1a262e4982186d8e499041b6c131201pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0xd7615484f03f655a98cb7fac876cfc1c0d25888eca5c6ee75b90fc98aaa0a7bd-201df6796d5605633e545778f0395ded7222025-03-21 00:03:54.4552025-03-21 00:03:54.455
    20
    		476420702025-03-20 21:58:15.0000xce972a72454ecf071f1c61ab0638e3f97ec4ec900d77bd042830103044525d130x414bf3890xd47ad47bac0ca0c168df0666cb5a760440741ffa0x1b81d678ffb9c0263b24a97847620c99d213eb140x4c666cc063ec8972502981a7b9a5697381635040OBB-USDT 100 1 PCS-V3 LPSwap8577550713802870000085.7755071382.92352345477558e+212923.5234547760x1b81d678ffb9c0263b24a97847620c99d213eb140xd47ad47bac0ca0c168df0666cb5a760440741ffa175pancakeswap-v30x55d398326f99059ff775485246999027b31979550x29e7dee3bb8c735d8f7877a91b318f77fa8d92ebUSDTOBB0xce972a72454ecf071f1c61ab0638e3f97ec4ec900d77bd042830103044525d13-175af8eebec324f284cc2931d00fccd75012025-03-21 00:03:54.4552025-03-21 00:03:54.455
    ...
    200
    145KB
    3s