flipside

    grateful-orange
    datavortexgrateful-orange
    Updated 2025-04-17
    select distinct contract_address, pool_name
    from ethereum.defi.ez_dex_swaps
    where pool_name ILIKE '%SOIL%'
    --IN ('SOIL-USDT 10000 200 UNI-V3 LP', 'SOIL-USDT 500 10 UNI-V3 LP', 'SOIL-USDT 3000 60 UNI-V3 LP')



    --where tx_hash = '0x56b959eda2fcf7c4142e5367f40e051e7fbf5f142ac54c0958a1e71dc8b214e5'

    --0x56b959eda2fcf7c4142e5367f40e051e7fbf5f142ac54c0958a1e71dc8b214e5

    --0x43c73b90e0c2a355784dcf0da12f477729b31e77
    --0xc2132d05d31c914a87c6611c10748aeb04b58e8f tether usdt

    --ETHEREUM 0x54991328ab43c7d5d31c19d1b9fa048e77b5cd16
    /*
    POOL_NAME
    1
    SOIL-USDT 500 10 UNI-V3 LP

    SOIL-USDT 10000 200 UNI-V3 LP

    SOIL-USDT 3000 60 UNI-V3 LP

    */
    Last run: about 2 months ago
    CONTRACT_ADDRESS
    POOL_NAME
    1
    		0xf5e0b11c958aadd0c60b0d9ffa0e7ddedcb98e5bSOIL-WETH
    2
    		0xd3c13fe95a2982001e4d4d5b54d9407449856fdbSOIL-WETH
    3
    		0xda5ce45793dc20505c61efeede032c997b464d12WETH-SOIL
    4
    		0xfd8ff9f1a4a3a12cc56991121be0998b047d70abWETH-GASOIL
    5
    		0x7090cc8dfa04b0bbac6520063c9c1ea677c368a0SOIL-WETH 10000 200 UNI-V3 LP
    6
    		0xff1328b621207e5166ed37ac47ee9df01986ec1cWETH-XISOIL
    7
    		0x5ff072a1277c81b9ed88a0988090cc0c8d7a342aSOIL-WETH
    7
    438B
    3s