flipside

    NFT Contract Metrics
    D3 AnalyticsNFT Contract Metrics
    Updated 11 hours ago
    select *
    from ethereum.defi.ez_dex_swaps
    where tx_hash = '0x506d493db83032a540e0220f495868f5da729c1a58e16e6709c192c2fba5701a'
    order by block_timestamp desc
    limit 100
    Last run: about 11 hours 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
    		221226792025-03-25 08:18:47.0000x506d493db83032a540e0220f495868f5da729c1a58e16e6709c192c2fba5701a0x8100fc130x00000000000124d994209fbb955e0217b5c2eca10x7ed439d2d363864885d2ea27d50accbf9f7318e60x10358db0e8532455d3374fb09cf3fbec631b1914INSP-USDT 10000 200 UNI-V3 LPSwap2.670896e+2226708.96203.71196708768196.708768196.710x7ed439d2d363864885d2ea27d50accbf9f7318e60x772542da746b6455bf7c20458197d53e70565b35382uniswap-v30x186ef81fd8e77eec8bffc3039e7ec41d5fc0b4570xdac17f958d2ee523a2206206994597c13d831ec7INSPUSDT0x506d493db83032a540e0220f495868f5da729c1a58e16e6709c192c2fba5701a-38266913b2dc55baffd2f94b22ece2ba96b2025-03-25 08:54:46.2122025-03-25 08:54:46.212
    2
    		221226792025-03-25 08:18:47.0000x9f3ea3055f892f6552ad65106b7d5f71b9a4725fd6ed995ed7f6154026800e130x38ed17390xbbb5008da7ef90a416a4389fdad3872d6896cff90x7a250d5630b4cf539739df2c5dacb4c659f2488d0xffa98a091331df4600f87c9164cd27e8a5cd2405POLS-WETHSwap4628075570369140000.462807557949.933.67569e+213675.69879.490x7a250d5630b4cf539739df2c5dacb4c659f2488d0xf2449a4db678fe88b130fab68d7a90fb5ff884a7543uniswap-v20xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x83e6f1e41cdd28eaceb20cb649155049fac3d5aaWETHPOLS0x9f3ea3055f892f6552ad65106b7d5f71b9a4725fd6ed995ed7f6154026800e13-543675c81353b13dcae161d66b4e7c2e0232025-03-25 08:54:46.2122025-03-25 08:54:46.212
    3
    		221226792025-03-25 08:18:47.0000x839105638837079f2f451bbfcd038be461c32f5b180eb5df2221f66f9fcb5d170x2b6645850xd1fa51f2db23a9fa9d7bb8437b89fb2e70c60cb70xd4bc53434c5e12cb41381a556c3c47e1a86e80e30x4585fe77225b41b697c938b018e2ac67ac5a20c0WBTC-WETH 500 10 UNI-V3 LPSwap2399999687458290000023.99999687549260.71571166210.5711662149514.970xd4bc53434c5e12cb41381a556c3c47e1a86e80e30xd4bc53434c5e12cb41381a556c3c47e1a86e80e3236uniswap-v30xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x2260fac5e5542a773aa44fbcfedf7c193bc2c599WETHWBTC0x839105638837079f2f451bbfcd038be461c32f5b180eb5df2221f66f9fcb5d17-2364bd55123486a427ea59938b9866ba04e2025-03-25 08:54:46.2122025-03-25 08:54:46.212
    4
    		221226792025-03-25 08:18:47.0000xec3da02cc2b1e9e105e234fe0004a87e414957f3ee82eb5d04e367869d33c8010x3593564c0xbd0c76f9f1d694d87b943ee9771d93618e742ed00x66a9893cc07d91d95644aedd05d03f95e1dba8af0x0d4a11d5eeaac28ec3f61d100daf4d40471f1852WETH-USDTSwap40430277234043.0277234043.0319600494097755400001.960049414023.060x66a9893cc07d91d95644aedd05d03f95e1dba8af0x8d547a3e42828093e31a8c3f2a864036984b64ee404uniswap-v20xdac17f958d2ee523a2206206994597c13d831ec70xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2USDTWETH0xec3da02cc2b1e9e105e234fe0004a87e414957f3ee82eb5d04e367869d33c801-404326d593215d3a4d90ebbc80fd10e69092025-03-25 08:54:46.2122025-03-25 08:54:46.212
    5
    		221226792025-03-25 08:18:47.0000xdd27aeb878c29977685821eef39adee125041b7cd44637fb350ea933ba624f6b0x3593564c0xd62a13451a49b22ebd69e427255cbb7ebd6bb9180x66a9893cc07d91d95644aedd05d03f95e1dba8af0xc36b64d98330c700785d562a3683309055730fb6KHAMOO-WETHSwap894216267977865000894216267.977865141765998589060000.0141765998629.10x66a9893cc07d91d95644aedd05d03f95e1dba8af0x66a9893cc07d91d95644aedd05d03f95e1dba8af442uniswap-v20x8f66cf0f1db84f8ee2a46352409370a69ae4e0590xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2KHAMOOWETH0xdd27aeb878c29977685821eef39adee125041b7cd44637fb350ea933ba624f6b-4425d633ab8707f07f59f1f1b168bf0956f2025-03-25 08:54:46.2122025-03-25 08:54:46.212
    6
    		221226792025-03-25 08:18:47.0000x81fc99ce8ff3084b6a23dba84d5f949a21e02eb440e4f7b5e93e0a9e794c5d350x7ff36ab50x6934e617658cd856c88bfe01fcf23aa2b1b2973a0x7a250d5630b4cf539739df2c5dacb4c659f2488d0x44bc63ac2c534b3621bb975a8c2f72fad3e15808WETH-EICSwap260000000000000000.02653.372.118172686439e+2221181.726864390x7a250d5630b4cf539739df2c5dacb4c659f2488d0x6934e617658cd856c88bfe01fcf23aa2b1b2973a597uniswap-v20xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20xf2aaba9cd64e2b6ea8bbd40305f96f966532422fWETHEIC0x81fc99ce8ff3084b6a23dba84d5f949a21e02eb440e4f7b5e93e0a9e794c5d35-597d0fa6d2e8a12c5caf46eb7f8b93772ea2025-03-25 08:54:46.2122025-03-25 08:54:46.212
    7
    		221226792025-03-25 08:18:47.0000x8cf53a08a57604e5ddf7bf82ae24492593854882aa71ed1dc9906175579a5a6b0x5f5755290x389a653b9053cc908c6d223eaf5103fbde79198b0x881d40237659c251811cec9c364ef91dc08d300c0x1cef61dfb750d7c75ea2f0ac1e6d1a5ff0935cb9WETH-HMTDodoSwap595538944691008000000595.53894469128.14117443128448537000.0117443128424.110x5141b82f5ffda4c6fe1e372978f1c5427640a1900x5141b82f5ffda4c6fe1e372978f1c5427640a190417dodo-v20xd1ba9bac957322d6e8c07a160a3a8da11a0d28670xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2HMTWETH0x8cf53a08a57604e5ddf7bf82ae24492593854882aa71ed1dc9906175579a5a6b-4170b42faf238c0948d5bc3991b74be443e2025-03-25 08:54:46.2122025-03-25 08:54:46.212
    8
    		221226792025-03-25 08:18:47.0000x9f8fc7f83641d8c192df4c151053daea5f7392d56cf0f555dcf567abfbb59fd90x04e45aaf0x4c5f6ad6628d205259443ebcf6cc4cdd7d6cbf810x68b3465833fb72a70ecdf485e0e4c7bd8665fc450xac8ba9d6fa2f9ff7c712bef5670cb0f7e4177965ZND-USDT 3000 60 UNI-V3 LPSwap2.24957539196e+212249.57539196424.35474713545474.713545474.710x68b3465833fb72a70ecdf485e0e4c7bd8665fc450x4c5f6ad6628d205259443ebcf6cc4cdd7d6cbf81557uniswap-v30x2d8ea194902bc55431420bd26be92b0782dce91d0xdac17f958d2ee523a2206206994597c13d831ec7ZNDUSDT0x9f8fc7f83641d8c192df4c151053daea5f7392d56cf0f555dcf567abfbb59fd9-5576a3f27f3f3598cd7d4e1195cf58350ec2025-03-25 08:54:46.2122025-03-25 08:54:46.212
    9
    		221226792025-03-25 08:18:47.0000xb9a220da9036e70f80606b0d16bb57f3a271ee33035ceeb76732481cef655ed30x3a5712990x72bffc3ea58623959a482f2618523faf9400c9a00x3a10dc1a145da500d5fba38b9ec49c8ff11a981f0x8009048dfbe3a7f8ae7d216b84e873f90f39f5acGAV-WETHSwap23780963805884202378096.380588421365159821183190000.1365159821280.20x3a10dc1a145da500d5fba38b9ec49c8ff11a981f0x3a10dc1a145da500d5fba38b9ec49c8ff11a981f332uniswap-v20x19785e1cae5f72e835bb5a3123065824d149acd10xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2GAVWETH0xb9a220da9036e70f80606b0d16bb57f3a271ee33035ceeb76732481cef655ed3-33201dd29025377dbc74bad6805d41b31dc2025-03-25 08:54:46.2122025-03-25 08:54:46.212
    10
    		221226792025-03-25 08:18:47.0000xcfb1a9e2fe0ec9cc8b629362020893a2e186dcf9cdc019b0a836ea3258abbfaa0x088890dc0x92011871298911a280ee10c927685f2aa67329b00x80a64c6d7f12c47b7c66c5b4e20e72bc1fcd5d9e0x23f31ddf57a06c4e0d545d7eced8de7460fbd305SORA-WETHSwap3000000000000000000.3615.7699107050432898109910705.043289810x80a64c6d7f12c47b7c66c5b4e20e72bc1fcd5d9e0x92011871298911a280ee10c927685f2aa67329b0356uniswap-v20xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20xaed6087ce812dfb7684b713b48e837ce33719b83WETHSORA0xcfb1a9e2fe0ec9cc8b629362020893a2e186dcf9cdc019b0a836ea3258abbfaa-3566ce743cb21fc95b4cb5a2d893341dd952025-03-25 08:54:46.2122025-03-25 08:54:46.212
    11
    		221226792025-03-25 08:18:47.0000x839105638837079f2f451bbfcd038be461c32f5b180eb5df2221f66f9fcb5d170x2b6645850xd1fa51f2db23a9fa9d7bb8437b89fb2e70c60cb70xd4bc53434c5e12cb41381a556c3c47e1a86e80e30x4ebdf703948ddcea3b11f675b4d1fba9d2414a14WETH-CRV-crvUSDTokenExchange8265624875654180000.82656248761696.541.69976784987257e+211699.7678498731699.590xd4bc53434c5e12cb41381a556c3c47e1a86e80e30xd1fa51f2db23a9fa9d7bb8437b89fb2e70c60cb7249curve0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20xf939e0a03fb07f59a73314e73794be0e57ac1b4eWETHcrvUSD0x839105638837079f2f451bbfcd038be461c32f5b180eb5df2221f66f9fcb5d17-24945d4c49884d938f49df8f288edfbd0912025-03-25 08:54:46.2122025-03-25 08:54:46.212
    12
    		221226792025-03-25 08:18:47.0000x79f39231991066399512bb45aed65ae319b7880d654a1ecde9010cedd257b7a30x3593564c0xbc41b05c1e34e47d2fef8fe966b83254e8a754c80x66a9893cc07d91d95644aedd05d03f95e1dba8af0xecbfe82e3bdf799a52d5273fd3926457fe397671VATAN-USDT 3000 60 UNI-V3 LPSwap1000000001001.1098846697396e+211109.884669740x66a9893cc07d91d95644aedd05d03f95e1dba8af0x66a9893cc07d91d95644aedd05d03f95e1dba8af575uniswap-v30xdac17f958d2ee523a2206206994597c13d831ec70xbad6c59d72d44512616f25b3d160c79db5a69ddfUSDTVATAN0x79f39231991066399512bb45aed65ae319b7880d654a1ecde9010cedd257b7a3-575433dafec4807d4d83fa22a49d646c9572025-03-25 08:54:46.2122025-03-25 08:54:46.212
    13
    		221226792025-03-25 08:18:47.0000xb056b2d91a34c52e4040d2e417397d52f8cd7ecf0743a954184dd052995fe0ac0x83bd37f90xb907787e667a08c52c7aadcb5e6ac3b36896f1a40xcf5540fffcdc3d510b18bfca6d2b9987b07725590x713dc4df480235dbe2fb766e7120cbd4041dcb58LINK-USDCTrade372998143448256000000372.9981434485643.4656755181265675.5181265674.870xb907787e667a08c52c7aadcb5e6ac3b36896f1a40xcf5540fffcdc3d510b18bfca6d2b9987b077255945hashflow-v30x514910771af9ca656af840dff83e8264ecf986ca0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48LINKUSDC0xb056b2d91a34c52e4040d2e417397d52f8cd7ecf0743a954184dd052995fe0ac-4517a2b9f0e04341a84e70ae5ef4c146542025-03-25 08:54:46.2122025-03-25 08:54:46.212
    14
    		221226792025-03-25 08:18:47.0000x839105638837079f2f451bbfcd038be461c32f5b180eb5df2221f66f9fcb5d170x2b6645850xd1fa51f2db23a9fa9d7bb8437b89fb2e70c60cb70xd4bc53434c5e12cb41381a556c3c47e1a86e80e30xf5f5b97624542d72a9e06f04804bf81baa15e2b4WBTC-WETH-USDTTokenExchange1996277520458060000.199627752409.74410381579410.381579410.380xd4bc53434c5e12cb41381a556c3c47e1a86e80e30xd1fa51f2db23a9fa9d7bb8437b89fb2e70c60cb7244curve0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20xdac17f958d2ee523a2206206994597c13d831ec7WETHUSDT0x839105638837079f2f451bbfcd038be461c32f5b180eb5df2221f66f9fcb5d17-244aed226d700bda56ca9f8729e76060f332025-03-25 08:54:46.2122025-03-25 08:54:46.212
    15
    		221226792025-03-25 08:18:47.0000xec3da02cc2b1e9e105e234fe0004a87e414957f3ee82eb5d04e367869d33c8010x3593564c0xbd0c76f9f1d694d87b943ee9771d93618e742ed00x66a9893cc07d91d95644aedd05d03f95e1dba8af0x8d547a3e42828093e31a8c3f2a864036984b64eePin-WETHSwap19600494097755400001.960049414023.065.01250000057985e+215012.500000583965.920x66a9893cc07d91d95644aedd05d03f95e1dba8af0x66a9893cc07d91d95644aedd05d03f95e1dba8af408uniswap-v20xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x2e44f3f609ff5aa4819b323fd74690f07c3607c4WETHPin0xec3da02cc2b1e9e105e234fe0004a87e414957f3ee82eb5d04e367869d33c801-4080d46b25c9ca7d077643ee2146c01bc4c2025-03-25 08:54:46.2122025-03-25 08:54:46.212
    16
    		221226792025-03-25 08:18:47.0000x31f42a1fcabc55f139fc36a3483433daa5de7f87ee683df2a17731d37a07e2cc0x088890dc0xf4cfa195eea846aaee451ab48fe0378e13b03a570x80a64c6d7f12c47b7c66c5b4e20e72bc1fcd5d9e0x493512c955a75c012568c0dfb1521635964b7faaWETH-FETHSwap500000000000000000.05102.6341953867178436404195386.717843640x80a64c6d7f12c47b7c66c5b4e20e72bc1fcd5d9e0xf4cfa195eea846aaee451ab48fe0378e13b03a57361uniswap-v20xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20xd6e811e35e3f2c2102d1eaabf1826cd44431be59WETHFETH0x31f42a1fcabc55f139fc36a3483433daa5de7f87ee683df2a17731d37a07e2cc-36199c0aa105219a7ec49ebfe079f5d2a752025-03-25 08:54:46.2122025-03-25 08:54:46.212
    17
    		221226792025-03-25 08:18:47.0000x9ea2f13c05ec22e9c3ab82eddd760af57abf780fbd137f305fa5e562c33c42440x42b0b77c0x37d4cf6d679c47d49cf7b8396351c2609397a8000x87870bca3f3fd6335c3f4ce8392d69350b4fa4e20x56534741cd8b152df6d48adf7ac51f75169a83b2WBTC-USDT 500 10 UNI-V3 LPSwap60544359956054.4359956054.4470027380.070027386070.740xe592427a0aece92de3edee1f18e0157c058615640x6a000f20005980200259b80c5102003040001068276uniswap-v30xdac17f958d2ee523a2206206994597c13d831ec70x2260fac5e5542a773aa44fbcfedf7c193bc2c599USDTWBTC0x9ea2f13c05ec22e9c3ab82eddd760af57abf780fbd137f305fa5e562c33c4244-276765c065761400b5554c74fd511843cdc2025-03-25 08:54:46.2122025-03-25 08:54:46.212
    18
    		221226792025-03-25 08:18:47.0000xa02d63ec375076d06c23ff84ca7f4d48cfb6f19affdd41ed7be43985cb6683840x78e111f60x76dd32063b2899a59f6e15dbc474a160cc9227510xa69babef1ca67a37ffaf7a485dfff3382056e78c0xc7bbec68d12a0d1830360f8ec58fa599ba1b0e9bWETH-USDT 100 1 UNI-V3 LPSwap40261058729651400004.0261058738263.782766629608276.662968276.660xa69babef1ca67a37ffaf7a485dfff3382056e78c0xa69babef1ca67a37ffaf7a485dfff3382056e78c351uniswap-v30xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20xdac17f958d2ee523a2206206994597c13d831ec7WETHUSDT0xa02d63ec375076d06c23ff84ca7f4d48cfb6f19affdd41ed7be43985cb668384-351873af080f4c1df930cfc55df0d36be662025-03-25 08:54:46.2122025-03-25 08:54:46.212
    19
    		221226792025-03-25 08:18:47.0000xd1ac68c4a7ac32402ceed8b4e97ea0ec5ac382360ea8271afeb6d50a722f8a130x3a5712990xabe88e9d00045ea784f9e9986e26a2a6053b3e4d0x3a10dc1a145da500d5fba38b9ec49c8ff11a981f0x8009048dfbe3a7f8ae7d216b84e873f90f39f5acGAV-WETHSwap22081224671627402208122.467162741693730918385750000.1693730918347.640x3a10dc1a145da500d5fba38b9ec49c8ff11a981f0x3a10dc1a145da500d5fba38b9ec49c8ff11a981f314uniswap-v20x19785e1cae5f72e835bb5a3123065824d149acd10xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2GAVWETH0xd1ac68c4a7ac32402ceed8b4e97ea0ec5ac382360ea8271afeb6d50a722f8a13-31459738fa1b2b32356113ba82ce2db6bf02025-03-25 08:54:46.2122025-03-25 08:54:46.212
    20
    		221226792025-03-25 08:18:47.0000x7f3ed0b3585cbb439c56ca68502420db2c2974cb9aeacaac3acd0ac2df1d23b80x608060400x8d564be86df01ef7ec1b2dadd1cc39eee23edbab0x5fa464cefe8901d66c09b85d5fcdc55b3738c688TOKE-WETHSwap4136471421930010000.4136471422849.023.5958099934171e+213595.809993417869.310xf7ca73fb04abc558944615dbc6ae6f56e3b4c6e00xd4e7a6e2d03e4e48dfc27dd3f46df1c176647e38228uniswap-v20xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x2e9d63788249371f1dfc918a52f8d799f4a38c94WETHTOKE0x7f3ed0b3585cbb439c56ca68502420db2c2974cb9aeacaac3acd0ac2df1d23b8-22869b676fa556d6a2dc111d859c748abc02025-03-25 08:54:46.2122025-03-25 08:54:46.212
    100
    71KB
    2s