flipside

    TEst_VARIABLE_GET_JOIN_3_MEGA
    MajorM111TEst_VARIABLE_GET_JOIN_3_MEGA
    Updated 2024-02-10
    SELECT
    contract.*,
    pool.CREATION_BLOCK,
    pool.CREATION_TIME,
    pool.CREATION_TX,
    pool.PLATFORM,
    pool.FACTORY_ADDRESS,
    pool.POOL_ADDRESS,
    pool.POOL_NAME,
    pool.TOKENS,
    pool.SYMBOLS,
    logs.block_number,
    logs.block_timestamp,
    logs.tx_hash,
    logs.event_index,
    logs.contract_address,
    logs.contract_name,
    logs.event_name,
    logs.decoded_log,
    logs.full_decoded_log,
    logs.origin_function_signature,
    logs.origin_from_address,
    logs.origin_to_address,
    logs.topics,
    logs.data,
    logs.event_removed,
    logs.tx_status,
    logs.ez_decoded_event_logs_id
    FROM
    avalanche.core.dim_contracts contract
    JOIN
    avalanche.defi.dim_dex_liquidity_pools pool
    ON
    contract.ADDRESS = pool.TOKENS:token0::STRING
    OR contract.ADDRESS = pool.TOKENS:token1::STRING
    JOIN
    Last run: about 1 year ago
    ADDRESS
    SYMBOL
    NAME
    DECIMALS
    CREATED_BLOCK_NUMBER
    CREATED_BLOCK_TIMESTAMP
    CREATED_TX_HASH
    CREATOR_ADDRESS
    DIM_CONTRACTS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    CREATION_BLOCK
    CREATION_TIME
    CREATION_TX
    PLATFORM
    FACTORY_ADDRESS
    POOL_ADDRESS
    POOL_NAME
    TOKENS
    SYMBOLS
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    EVENT_INDEX
    CONTRACT_ADDRESS
    CONTRACT_NAME
    EVENT_NAME
    DECODED_LOG
    FULL_DECODED_LOG
    ORIGIN_FUNCTION_SIGNATURE
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    TOPICS
    DATA
    EVENT_REMOVED
    TX_STATUS
    EZ_DECODED_EVENT_LOGS_ID
    1
    		0x3d582641e5da170450abc5d76f4f22a1f251148aSONIC🦔PepeSonic10Inu💨18409758202024-01-29 07:06:03.0000x932cb02d07a798c78b2141d0f7d020ddde964b829662f3604b3ec388fed6de4e0x387faebda85eb0d7da5fd776ee2c5dabe7f614213fddaa976ebf294ed68badfbbbbe4c1c2024-01-29 07:19:51.5762024-01-30 07:48:44.345409758862024-01-29 07:08:15.0000x3f422bf3ad29d217dd33d5a223186ee6debe700465239b4255b2a8ddf6abad28trader-joe-v10x9ad6c38be94206ca50bb0d90783181662f0cfa100x33d8ba869b17068c36143d176c14e773c37c642cSONIC-WAVAX
    {"token0":"0x3d582641e5da170450abc5d76f4f22a1f251148a","token1":"0xb31f6...
    {"token0":"SONIC","token1":"WAVAX"}
    		409938592024-01-29 17:23:19.0000xd00346e57b5f420d23d77f598566182f90d4362f442ee37884298a6dc5ab355e130x33d8ba869b17068c36143d176c14e773c37c642cJoe LP TokenSwap
    {"amount0In":0,"amount0Out":"22181190953490139987137321","amount1In":"49...
    {"address":"0x33D8bA869b17068C36143d176C14e773c37c642c","data":[{"decode...
    		0xa2a1623d0x6489d1f557458aea3c21e6f9fb955b83bbabb0bd0x60ae616a2155ee3d9a68541ba4544862310933d4
    ["0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822","0...
    0x0000000000000000000000000000000000000000000000000000000000000000000000...
    		falseSUCCESS58554ee77217ef5175374f2783467d11
    2
    		0x3d582641e5da170450abc5d76f4f22a1f251148aSONIC🦔PepeSonic10Inu💨18409758202024-01-29 07:06:03.0000x932cb02d07a798c78b2141d0f7d020ddde964b829662f3604b3ec388fed6de4e0x387faebda85eb0d7da5fd776ee2c5dabe7f614213fddaa976ebf294ed68badfbbbbe4c1c2024-01-29 07:19:51.5762024-01-30 07:48:44.345409758862024-01-29 07:08:15.0000x3f422bf3ad29d217dd33d5a223186ee6debe700465239b4255b2a8ddf6abad28trader-joe-v10x9ad6c38be94206ca50bb0d90783181662f0cfa100x33d8ba869b17068c36143d176c14e773c37c642cSONIC-WAVAX
    {"token0":"0x3d582641e5da170450abc5d76f4f22a1f251148a","token1":"0xb31f6...
    {"token0":"SONIC","token1":"WAVAX"}
    		409954722024-01-29 18:18:34.0000x24c80ca7e5fa206937593b97ab5e6a6093b2679f55b1932e3e153d0a2169a50e200x33d8ba869b17068c36143d176c14e773c37c642cJoe LP TokenSwap
    {"amount0In":"24374840577832549512000008","amount0Out":0,"amount1In":0,"...
    {"address":"0x33D8bA869b17068C36143d176C14e773c37c642c","data":[{"decode...
    		0x676528d10x3cae29bac00df18d6f56ecc6b17405bedb6a2ad20x60ae616a2155ee3d9a68541ba4544862310933d4
    ["0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822","0...
    0x000000000000000000000000000000000000000000142992c163727c03323208000000...
    		falseSUCCESSdf02948086980f2d28542aa9755788f4
    3
    		0x3d582641e5da170450abc5d76f4f22a1f251148aSONIC🦔PepeSonic10Inu💨18409758202024-01-29 07:06:03.0000x932cb02d07a798c78b2141d0f7d020ddde964b829662f3604b3ec388fed6de4e0x387faebda85eb0d7da5fd776ee2c5dabe7f614213fddaa976ebf294ed68badfbbbbe4c1c2024-01-29 07:19:51.5762024-01-30 07:48:44.345409758862024-01-29 07:08:15.0000x3f422bf3ad29d217dd33d5a223186ee6debe700465239b4255b2a8ddf6abad28trader-joe-v10x9ad6c38be94206ca50bb0d90783181662f0cfa100x33d8ba869b17068c36143d176c14e773c37c642cSONIC-WAVAX
    {"token0":"0x3d582641e5da170450abc5d76f4f22a1f251148a","token1":"0xb31f6...
    {"token0":"SONIC","token1":"WAVAX"}
    		409941232024-01-29 17:32:17.0000x874885e88a4d0c6662534fe892f898c7b7a6acb9460a304a76055112c7714c8f40x33d8ba869b17068c36143d176c14e773c37c642cJoe LP TokenSwap
    {"amount0In":"11709305642836233240405113","amount0Out":0,"amount1In":0,"...
    {"address":"0x33D8bA869b17068C36143d176C14e773c37c642c","data":[{"decode...
    		0x676528d10x8df9ad2bd52fc5da7a6440ff206d658bfaa6730f0x60ae616a2155ee3d9a68541ba4544862310933d4
    ["0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822","0...
    0x00000000000000000000000000000000000000000009af8abb168f67dd4f6479000000...
    		falseSUCCESSd204581ad4be8d244c203af6724a6b91
    4
    		0x3d582641e5da170450abc5d76f4f22a1f251148aSONIC🦔PepeSonic10Inu💨18409758202024-01-29 07:06:03.0000x932cb02d07a798c78b2141d0f7d020ddde964b829662f3604b3ec388fed6de4e0x387faebda85eb0d7da5fd776ee2c5dabe7f614213fddaa976ebf294ed68badfbbbbe4c1c2024-01-29 07:19:51.5762024-01-30 07:48:44.345409758862024-01-29 07:08:15.0000x3f422bf3ad29d217dd33d5a223186ee6debe700465239b4255b2a8ddf6abad28trader-joe-v10x9ad6c38be94206ca50bb0d90783181662f0cfa100x33d8ba869b17068c36143d176c14e773c37c642cSONIC-WAVAX
    {"token0":"0x3d582641e5da170450abc5d76f4f22a1f251148a","token1":"0xb31f6...
    {"token0":"SONIC","token1":"WAVAX"}
    		409940442024-01-29 17:29:36.0000x455b948f2682e5884a0d2705ed7d4ae8864d211912cc69aa7332e81b6b72a0a560x33d8ba869b17068c36143d176c14e773c37c642cJoe LP TokenSync
    {"reserve0":"3850554643898978730420050728","reserve1":"88413525757290923...
    {"address":"0x33D8bA869b17068C36143d176C14e773c37c642c","data":[{"decode...
    		0xa2a1623d0xf4f0f201fd8a0f2b25307be062f715db542687600x60ae616a2155ee3d9a68541ba4544862310933d4
    ["0x1c411e9a96e071241c2f21f7726b17ae89e3cab4c78be50e062b03a9fffbbad1"]
    0x00000000000000000000000000000000000000000c711aa9826cb18cefbd9b28000000...
    		falseSUCCESSd604ec1fea80cc9b862db057f5844ccd
    5
    		0x3d582641e5da170450abc5d76f4f22a1f251148aSONIC🦔PepeSonic10Inu💨18409758202024-01-29 07:06:03.0000x932cb02d07a798c78b2141d0f7d020ddde964b829662f3604b3ec388fed6de4e0x387faebda85eb0d7da5fd776ee2c5dabe7f614213fddaa976ebf294ed68badfbbbbe4c1c2024-01-29 07:19:51.5762024-01-30 07:48:44.345409758862024-01-29 07:08:15.0000x3f422bf3ad29d217dd33d5a223186ee6debe700465239b4255b2a8ddf6abad28trader-joe-v10x9ad6c38be94206ca50bb0d90783181662f0cfa100x33d8ba869b17068c36143d176c14e773c37c642cSONIC-WAVAX
    {"token0":"0x3d582641e5da170450abc5d76f4f22a1f251148a","token1":"0xb31f6...
    {"token0":"SONIC","token1":"WAVAX"}
    		409943522024-01-29 17:40:07.0000xcb558c8ce61c4e52557564fe566ee7c25e1b019a55b40c065b65cf89eb9c0cd7150x33d8ba869b17068c36143d176c14e773c37c642cJoe LP TokenSwap
    {"amount0In":"9622164159446876728482991","amount0Out":0,"amount1In":0,"a...
    {"address":"0x33D8bA869b17068C36143d176C14e773c37c642c","data":[{"decode...
    		0x676528d10x1ebdc45da565f30c85bb81796244f03cdc761cd00x60ae616a2155ee3d9a68541ba4544862310933d4
    ["0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822","0...
    0x00000000000000000000000000000000000000000007f5929074ee4bbdc25caf000000...
    		falseSUCCESS5967c164353d707a800464693bb51546
    6
    		0x3d582641e5da170450abc5d76f4f22a1f251148aSONIC🦔PepeSonic10Inu💨18409758202024-01-29 07:06:03.0000x932cb02d07a798c78b2141d0f7d020ddde964b829662f3604b3ec388fed6de4e0x387faebda85eb0d7da5fd776ee2c5dabe7f614213fddaa976ebf294ed68badfbbbbe4c1c2024-01-29 07:19:51.5762024-01-30 07:48:44.345409758862024-01-29 07:08:15.0000x3f422bf3ad29d217dd33d5a223186ee6debe700465239b4255b2a8ddf6abad28trader-joe-v10x9ad6c38be94206ca50bb0d90783181662f0cfa100x33d8ba869b17068c36143d176c14e773c37c642cSONIC-WAVAX
    {"token0":"0x3d582641e5da170450abc5d76f4f22a1f251148a","token1":"0xb31f6...
    {"token0":"SONIC","token1":"WAVAX"}
    		409939102024-01-29 17:25:01.0000xf41b96c5c577d31b84cfef9a8c79026a53156fa74e5c7f5f2716cc037806edbe190x33d8ba869b17068c36143d176c14e773c37c642cJoe LP TokenSync
    {"reserve0":"3884707523691204446623809397","reserve1":"87632615757290923...
    {"address":"0x33D8bA869b17068C36143d176C14e773c37c642c","data":[{"decode...
    		0xa2a1623d0x6ecf84f3ec747cf91452641f5331ca1e07929a720x60ae616a2155ee3d9a68541ba4544862310933d4
    ["0x1c411e9a96e071241c2f21f7726b17ae89e3cab4c78be50e062b03a9fffbbad1"]
    0x00000000000000000000000000000000000000000c8d5ad0d534f68bad5abf75000000...
    		falseSUCCESS0f302d933597a560ab2f6fec1e16d2c7
    7
    		0x3d582641e5da170450abc5d76f4f22a1f251148aSONIC🦔PepeSonic10Inu💨18409758202024-01-29 07:06:03.0000x932cb02d07a798c78b2141d0f7d020ddde964b829662f3604b3ec388fed6de4e0x387faebda85eb0d7da5fd776ee2c5dabe7f614213fddaa976ebf294ed68badfbbbbe4c1c2024-01-29 07:19:51.5762024-01-30 07:48:44.345409758862024-01-29 07:08:15.0000x3f422bf3ad29d217dd33d5a223186ee6debe700465239b4255b2a8ddf6abad28trader-joe-v10x9ad6c38be94206ca50bb0d90783181662f0cfa100x33d8ba869b17068c36143d176c14e773c37c642cSONIC-WAVAX
    {"token0":"0x3d582641e5da170450abc5d76f4f22a1f251148a","token1":"0xb31f6...
    {"token0":"SONIC","token1":"WAVAX"}
    		409954512024-01-29 18:17:52.0000xf2d5c5e44af87c675755b8d1cea2fb3696eaef77fbbc23532ad4fb9feb23268c30x33d8ba869b17068c36143d176c14e773c37c642cJoe LP TokenSync
    {"reserve0":"3730252257853647860131439005","reserve1":"91371356680496016...
    {"address":"0x33D8bA869b17068C36143d176C14e773c37c642c","data":[{"decode...
    		0xa2a1623d0x945ca8e9283e8415e42d2dbc811c28c5c8507f4d0x60ae616a2155ee3d9a68541ba4544862310933d4
    ["0x1c411e9a96e071241c2f21f7726b17ae89e3cab4c78be50e062b03a9fffbbad1"]
    0x00000000000000000000000000000000000000000c0d97a4181d1baabd4c219d000000...
    		falseSUCCESS53403728df4df728c532d27d7eafa576
    8
    		0x3d582641e5da170450abc5d76f4f22a1f251148aSONIC🦔PepeSonic10Inu💨18409758202024-01-29 07:06:03.0000x932cb02d07a798c78b2141d0f7d020ddde964b829662f3604b3ec388fed6de4e0x387faebda85eb0d7da5fd776ee2c5dabe7f614213fddaa976ebf294ed68badfbbbbe4c1c2024-01-29 07:19:51.5762024-01-30 07:48:44.345409758862024-01-29 07:08:15.0000x3f422bf3ad29d217dd33d5a223186ee6debe700465239b4255b2a8ddf6abad28trader-joe-v10x9ad6c38be94206ca50bb0d90783181662f0cfa100x33d8ba869b17068c36143d176c14e773c37c642cSONIC-WAVAX
    {"token0":"0x3d582641e5da170450abc5d76f4f22a1f251148a","token1":"0xb31f6...
    {"token0":"SONIC","token1":"WAVAX"}
    		409959282024-01-29 18:33:59.0000x43ba37d3fe44e5e3a690095cff7fb958782ede51bf651331c1a9836a4a1efee5150x33d8ba869b17068c36143d176c14e773c37c642cJoe LP TokenSync
    {"reserve0":"3654705380565546431769134010","reserve1":"93304763065746017...
    {"address":"0x33D8bA869b17068C36143d176C14e773c37c642c","data":[{"decode...
    		0x676528d10x8df8894fe38d6ae0ab436ee99f20d056b1609e4e0x60ae616a2155ee3d9a68541ba4544862310933d4
    ["0x1c411e9a96e071241c2f21f7726b17ae89e3cab4c78be50e062b03a9fffbbad1"]
    0x00000000000000000000000000000000000000000bcf19f7ab9101da4ea6c3ba000000...
    		falseSUCCESSab7faee280e5f140cbcef92b307a4119
    9
    		0x3d582641e5da170450abc5d76f4f22a1f251148aSONIC🦔PepeSonic10Inu💨18409758202024-01-29 07:06:03.0000x932cb02d07a798c78b2141d0f7d020ddde964b829662f3604b3ec388fed6de4e0x387faebda85eb0d7da5fd776ee2c5dabe7f614213fddaa976ebf294ed68badfbbbbe4c1c2024-01-29 07:19:51.5762024-01-30 07:48:44.345409758862024-01-29 07:08:15.0000x3f422bf3ad29d217dd33d5a223186ee6debe700465239b4255b2a8ddf6abad28trader-joe-v10x9ad6c38be94206ca50bb0d90783181662f0cfa100x33d8ba869b17068c36143d176c14e773c37c642cSONIC-WAVAX
    {"token0":"0x3d582641e5da170450abc5d76f4f22a1f251148a","token1":"0xb31f6...
    {"token0":"SONIC","token1":"WAVAX"}
    		409959662024-01-29 18:35:18.0000x75dbda0923ef4d98e88b9b24b9f0e1ead75ac4f88074202829ad65896c4f417680x33d8ba869b17068c36143d176c14e773c37c642cJoe LP TokenSync
    {"reserve0":"3617177787042605065573662955","reserve1":"94277973065746017...
    {"address":"0x33D8bA869b17068C36143d176C14e773c37c642c","data":[{"decode...
    		0x676528d10x942e14dba90982692b5e4b6cef79dedd4963c7100x60ae616a2155ee3d9a68541ba4544862310933d4
    ["0x1c411e9a96e071241c2f21f7726b17ae89e3cab4c78be50e062b03a9fffbbad1"]
    0x00000000000000000000000000000000000000000bb00f30bfb7969f1d3280eb000000...
    		falseSUCCESS00fece398d814cd30cb2c052b70c9520
    10
    		0x3d582641e5da170450abc5d76f4f22a1f251148aSONIC🦔PepeSonic10Inu💨18409758202024-01-29 07:06:03.0000x932cb02d07a798c78b2141d0f7d020ddde964b829662f3604b3ec388fed6de4e0x387faebda85eb0d7da5fd776ee2c5dabe7f614213fddaa976ebf294ed68badfbbbbe4c1c2024-01-29 07:19:51.5762024-01-30 07:48:44.345409758862024-01-29 07:08:15.0000x3f422bf3ad29d217dd33d5a223186ee6debe700465239b4255b2a8ddf6abad28trader-joe-v10x9ad6c38be94206ca50bb0d90783181662f0cfa100x33d8ba869b17068c36143d176c14e773c37c642cSONIC-WAVAX
    {"token0":"0x3d582641e5da170450abc5d76f4f22a1f251148a","token1":"0xb31f6...
    {"token0":"SONIC","token1":"WAVAX"}
    		409956612024-01-29 18:24:58.0000x1b2ec0e9322ec66bb6909987f29420cc45798432bb901cf62430a4e57e057b17140x33d8ba869b17068c36143d176c14e773c37c642cJoe LP TokenSync
    {"reserve0":"3664025917244945334812937092","reserve1":"93036246680496016...
    {"address":"0x33D8bA869b17068C36143d176C14e773c37c642c","data":[{"decode...
    		0xa2a1623d0x6b16d558da97a943d6c3e79ed310f98b3b8b63ef0x60ae616a2155ee3d9a68541ba4544862310933d4
    ["0x1c411e9a96e071241c2f21f7726b17ae89e3cab4c78be50e062b03a9fffbbad1"]
    0x00000000000000000000000000000000000000000bd6cfaaf9dbab659dbe0b84000000...
    		falseSUCCESS62c19e0c8d5906f59ffc4ffabba11fb2
    10
    18KB
    6s