flipside

    farmer from exchange
    Sandeshfarmer from exchange
    Updated 2024-02-19
    with from_exchange as (
    select DISTINCT avax_to_address from avalanche.core.ez_avax_transfers
    where 1=1
    and avax_from_address = lower('0x406C22b8740ae955b04fD11c2061E053807E2A69')
    -- and block_timestamp::date > '2024-01-26'
    ),
    swap_transactions as
    (
    select * from avalanche.defi.ez_dex_swaps
    where 1=1
    and platform in ('sushiswap','uniswap-v3')
    and symbol_in='USDC'
    and symbol_out='WAVAX'
    -- and tx_hash=lower('0x1facdc4e059a02126908a584187e990f7405a9a18a2c33c8dcc238861de21841')
    -- and origin_from_address=lower('0x052387bdbe1cae1d50557ac9078ee5e3ae67de48')
    and origin_from_address in ( select avax_to_address from from_exchange)
    limit 500
    )
    -- select * from avalanche.core.fact_transactions
    -- where tx_hash=lower('0x1facdc4e059a02126908a584187e990f7405a9a18a2c33c8dcc238861de21841')

    select st.*, ft.nonce from swap_transactions st
    inner join avalanche.core.fact_transactions ft
    on st.tx_hash=ft.tx_hash
    -- where st.tx_hash=lower('0x1facdc4e059a02126908a584187e990f7405a9a18a2c33c8dcc238861de21841')
    -- and ft.nonce=2
    Last run: about 1 year 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
    NONCE
    1
    		409869772024-01-29 13:28:40.0000x3c114bf88db927d49c03990c8615a72750789cea52dd77a7f142aa9e692c1ba40x2646478b0xcaf6b60d90c6f4799bcd1111b5131b5251ef49c50x8f54301f315c56c112d492d9443047d4745dbe9e0x6539bf462f73ff9497054ba261c195da8639ed61WAVAX-USDCSwap1021485610.21485610.212944409736909050000.294440973710.20x8f54301f315c56c112d492d9443047d4745dbe9e0x8f54301f315c56c112d492d9443047d4745dbe9e10sushiswap0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x3c114bf88db927d49c03990c8615a72750789cea52dd77a7f142aa9e692c1ba4-10747ce67029eb968449e940da5025ae2f2024-01-31 02:39:09.0452024-01-31 02:39:09.0452
    2
    		409869362024-01-29 13:27:21.0000xb3e9e1bb2951a452a63781822d77adc551229dfcdd600538df9b2145b533444e0x2646478b0x7453f9cb3aa4503b4adf05830e00f65fc3d18f830x8f54301f315c56c112d492d9443047d4745dbe9e0x6539bf462f73ff9497054ba261c195da8639ed61WAVAX-USDCSwap1018610410.18610410.182922496439780870000.29224964410.120x8f54301f315c56c112d492d9443047d4745dbe9e0x8f54301f315c56c112d492d9443047d4745dbe9e8sushiswap0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0xb3e9e1bb2951a452a63781822d77adc551229dfcdd600538df9b2145b533444e-887fd8b08aec7b2a5000c5c81a2d63f1d2024-01-31 02:39:09.0452024-01-31 02:39:09.0452
    3
    		409869102024-01-29 13:26:29.0000x0c72912337a4364fa45e37a31e728f8578fc1ad2b8b1f324f9a6b4c561d222db0x3593564c0x11344a601c2ea5c90d706dfb1936dceeb6fe9d880x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1022111210.22111210.212947438068574330000.294743806910.210x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d2927uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x0c72912337a4364fa45e37a31e728f8578fc1ad2b8b1f324f9a6b4c561d222db-72098160480cf8542e5e8db53a530dacf2024-01-31 02:39:09.0452024-01-31 02:39:09.0452
    4
    		409869492024-01-29 13:27:47.0000x55c52f8112ace24d2c0bf51e55c2644faf6cf79b7227e376668923ed270516d60x2646478b0xa666c403e2a2c0660be6ddaabc1a52e488e5d0310x8f54301f315c56c112d492d9443047d4745dbe9e0x6539bf462f73ff9497054ba261c195da8639ed61WAVAX-USDCSwap1018143710.18143710.172908444206794360000.290844420710.070x8f54301f315c56c112d492d9443047d4745dbe9e0x8f54301f315c56c112d492d9443047d4745dbe9e28sushiswap0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x55c52f8112ace24d2c0bf51e55c2644faf6cf79b7227e376668923ed270516d6-28b49acd6e0b858e2c9783e7e51404f9de2024-01-31 02:39:09.0452024-01-31 02:39:09.0452
    5
    		409868692024-01-29 13:25:06.0000xed09f91770d0a75078e5a8b96815a499f32af8c2d1bb207325802af1698073cf0x3593564c0xb8d2794083b5e0fd286f2fc33aae86eee55f9cb40x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1022401910.22401910.222952757636847450000.295275763710.230x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d2926uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0xed09f91770d0a75078e5a8b96815a499f32af8c2d1bb207325802af1698073cf-6d1bd1a68fdd83a7876c9b32d60e236032024-01-31 02:39:09.0452024-01-31 02:39:09.0452
    6
    		409868882024-01-29 13:25:45.0000x3989d87c3361db19bdfe7ca9efeeb4d0c0bdc94471a5045f713ce815ec67a1860x3593564c0x7e652a45a3d872c911688a04c508a04d58b8ba650x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1018178810.18178810.172938867364940240000.293886736510.180x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d29214uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x3989d87c3361db19bdfe7ca9efeeb4d0c0bdc94471a5045f713ce815ec67a186-14a0d5b32898e45c758a0130abb61e752c2024-01-31 02:39:09.0452024-01-31 02:39:09.0452
    7
    		409869142024-01-29 13:26:37.0000x371f0ca77e969292c2151a2ffab8a20127027d7782fd92078d32dc0be79e61480x3593564c0x6584919385e070ec4c7a2c97e0c45d072aa5ac2d0x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1022108810.22108810.212947406442707210000.294740644310.210x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d29212uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x371f0ca77e969292c2151a2ffab8a20127027d7782fd92078d32dc0be79e6148-12e2a479b045f5584cd45e51adaf72a8762024-01-31 02:39:09.0452024-01-31 02:39:09.0452
    8
    		409439692024-01-28 12:48:32.0000x586d80cc3a3147124bb0438af584530fb639eafbf71f5b2e1b060a51eddd15180x3593564c0x347cf526db2ad15aeb0ccad3ea51cc1cd77687d30x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1017879410.17879410.172849771013265220000.284977101310.230x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d2924uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x586d80cc3a3147124bb0438af584530fb639eafbf71f5b2e1b060a51eddd1518-439631bd9cdd385c581a7e1866bc2a7db2024-01-30 02:38:43.2052024-01-30 02:38:43.2052
    9
    		409439722024-01-28 12:48:38.0000x4ed5ad68d094125a3b0e594f0988d64baf1c7848e0b8018226f7431e3b5614860x3593564c0x507bd94ba4c33921899135498792724e53219ac40x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1022426310.22426310.222862480277879560000.286248027810.280x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d29219uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x4ed5ad68d094125a3b0e594f0988d64baf1c7848e0b8018226f7431e3b561486-198bd41a38d8ede92b9c346be250f211172024-01-30 02:38:43.2052024-01-30 02:38:43.2052
    10
    		409439552024-01-28 12:48:04.0000x8a91aa7071c9dd3f31cf9c479fe583d06fa67b5ab949dfaea1cda050852fe95a0x3593564c0xbddc260081cc3aa71ffeae1527f3bafe0958cba20x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1023566610.23566610.232868137651289930000.286813765110.30x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d29216uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x8a91aa7071c9dd3f31cf9c479fe583d06fa67b5ab949dfaea1cda050852fe95a-16b148388fc7b336c6f8875a3e25d9e8012024-01-30 02:38:43.2052024-01-30 02:38:43.2052
    11
    		410027852024-01-29 22:29:25.0000x81bd493a692ac27202bb1ce4f4d07fc34b9fade1858f2a86ed2b97c4191eaad80x3593564c0xbbb130fceda59c2080495e1ffc14902296872c580x82635af6146972cd6601161c4472ffe97237d2920x0e663593657b064e1bae76d28625df5d0ebd4421WAVAX-USDC 3000 60 UNI-V3 LPSwap1020573710.20573710.22826159660558590000.282615966110.220x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d29213uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x81bd493a692ac27202bb1ce4f4d07fc34b9fade1858f2a86ed2b97c4191eaad8-13e65986b0935ff8fa5ad519327878a2dc2024-01-31 11:39:08.8392024-01-31 11:39:08.8392
    12
    		410027842024-01-29 22:29:23.0000xe8431980cbac62cbd392e67467981b50ac8b06689ae0545adf836daad899fee70x3593564c0x67ffe606ced6f60bd5077d1e124256702cde0c720x82635af6146972cd6601161c4472ffe97237d2920x0e663593657b064e1bae76d28625df5d0ebd4421WAVAX-USDC 3000 60 UNI-V3 LPSwap1016811810.16811810.162818064998970620000.281806499910.190x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d2923uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0xe8431980cbac62cbd392e67467981b50ac8b06689ae0545adf836daad899fee7-385386e2e04c70bdc7e35c7381f1ef3002024-01-31 11:39:08.8392024-01-31 11:39:08.8392
    13
    		408794482024-01-26 23:51:12.0000x94545af61699107ae3cf00c19cb697c1c0dcac63c7cbf1fe54570c80b654ae6c0x3593564c0xd9c41ef9834d5ad119563d99dec170eb3b3ce7e00x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1017433210.17433210.173152078938977940000.315207893910.170x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d29213uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x94545af61699107ae3cf00c19cb697c1c0dcac63c7cbf1fe54570c80b654ae6c-13f47cd98e94425a3b8ff1dff8b9c8dfe32024-01-28 13:38:40.6052024-01-28 13:38:40.6052
    14
    		410178622024-01-30 07:16:42.0000xc6ddf48e9a1ecf68083d69e36178adf2517f55d3627c79755f16969d6e75895d0x3593564c0x8ce5e1857c7c03d263206a8a0dae36ab0de4a61b0x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1012569510.12569510.142835142265721400000.283514226610.140x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d29217uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0xc6ddf48e9a1ecf68083d69e36178adf2517f55d3627c79755f16969d6e75895d-1733382fb4d85acd01144cf4eb5be39ef12024-01-31 20:38:47.2952024-01-31 20:38:47.2952
    15
    		410178632024-01-30 07:16:44.0000x302a7c9519ee5d28681e0b3a3f5932e2cd31031322b6ae1919dcb9dd82ee3edb0x3593564c0xc3bf29d4053123fec71150be8b37fb8827715fef0x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1013709210.13709210.152838314456101670000.283831445610.150x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d29211uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x302a7c9519ee5d28681e0b3a3f5932e2cd31031322b6ae1919dcb9dd82ee3edb-11f43dc701b65e53e6409045b7cc95f1872024-01-31 20:38:47.2952024-01-31 20:38:47.2952
    16
    		410178932024-01-30 07:17:42.0000x0a6c28922b0b1c38e0449b7d57fd46cc77894db89c1eb2b3448222ba3f9c6dac0x2646478b0xaf1cb06c24d19c6a1c420763df72f7bed3c64e830x8f54301f315c56c112d492d9443047d4745dbe9e0x6539bf462f73ff9497054ba261c195da8639ed61WAVAX-USDCSwap1010583110.10583110.122805946290186320000.28059462910.030x8f54301f315c56c112d492d9443047d4745dbe9e0x8f54301f315c56c112d492d9443047d4745dbe9e19sushiswap0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x0a6c28922b0b1c38e0449b7d57fd46cc77894db89c1eb2b3448222ba3f9c6dac-19faef6ea82de7f3e49b5893eedfce1c952024-01-31 20:38:47.2952024-01-31 20:38:47.2952
    17
    		410178402024-01-30 07:15:55.0000xe2ea0a7da221845a6f0edafb65d038e026b83ac710c5d2726e96ee69afa2acc60x3593564c0x835c1cf859cb3266b543739d0c51c17aab14fd9c0x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1012889110.12889110.142841994143113970000.284199414310.160x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d2923uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0xe2ea0a7da221845a6f0edafb65d038e026b83ac710c5d2726e96ee69afa2acc6-3279cbab6928f2c08f4565857e3f73e342024-01-31 20:38:47.2952024-01-31 20:38:47.2952
    18
    		410178582024-01-30 07:16:33.0000x60dfe146dab62a97f40c44e03e24094692490a5e860dea09208b1225518fa64c0x3593564c0xdde9656deaea6856b219982b4707e141c8c074cb0x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1013138610.13138610.142838087993286060000.283808799310.150x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d29220uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x60dfe146dab62a97f40c44e03e24094692490a5e860dea09208b1225518fa64c-2082b2e4bcc0f74489950729e9fdb1452a2024-01-31 20:38:47.2952024-01-31 20:38:47.2952
    19
    		410188532024-01-30 07:51:15.0000x4cbc796858cce1f6cb15f921d6a647a44a66b5d548eb91a88bdf52cf2c22f3000x2646478b0xa9f3e493c2939b209f78064a724c1c90226979b80x8f54301f315c56c112d492d9443047d4745dbe9e0x6539bf462f73ff9497054ba261c195da8639ed61WAVAX-USDCSwap1011909610.11909610.132794163437998790000.27941634389.990x8f54301f315c56c112d492d9443047d4745dbe9e0x8f54301f315c56c112d492d9443047d4745dbe9e39sushiswap0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x4cbc796858cce1f6cb15f921d6a647a44a66b5d548eb91a88bdf52cf2c22f300-39e36b82d68374c3c8c709c4af5e6d08312024-01-31 21:39:13.6882024-01-31 21:39:13.6882
    20
    		410188112024-01-30 07:49:43.0000x626748fcc292110215d350a96d9370d2c1ff119f9dd79e4ce0c5c55d5714c6970x3593564c0x249649bb1a4d3b4a761718a0fde003f539836e1d0x82635af6146972cd6601161c4472ffe97237d2920xfae3f424a0a47706811521e3ee268f00cfb5c45eWAVAX-USDC 500 10 UNI-V3 LPSwap1013848510.13848510.152836379210926240000.283637921110.140x82635af6146972cd6601161c4472ffe97237d2920x82635af6146972cd6601161c4472ffe97237d29211uniswap-v30xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7USDCWAVAX0x626748fcc292110215d350a96d9370d2c1ff119f9dd79e4ce0c5c55d5714c697-117243fdbd018d9633b16e9263e25da8e32024-01-31 21:39:13.6882024-01-31 21:39:13.6882
    ...
    193
    136KB
    6s