flipside

    test.
    datavortextest.
    Updated 2025-02-12
    WITH swap_data AS (
    SELECT
    tx_hash,
    contract_name,
    contract_address,
    SPLIT_PART(contract_name, ' - ', 1) AS clean_name1,
    SPLIT_PART(contract_name, ' - ', 2) AS clean_name2,
    decoded_log:_amount0In::FLOAT AS amount_1_raw,
    decoded_log:_amount1In::FLOAT AS amount_2_raw,
    DATE_TRUNC('day', block_timestamp) AS swap_date,
    CASE
    WHEN decoded_log:_amount0In = 0 THEN SPLIT_PART(contract_name, ' - ', 2)
    ELSE SPLIT_PART(contract_name, ' - ', 1)
    END AS final_token,
    CASE
    WHEN decoded_log:_amount0In = 0 THEN decoded_log:_amount1In
    ELSE decoded_log:_amount0In
    END AS final_amount_raw
    FROM ronin.core.ez_decoded_event_logs
    WHERE event_name = 'Swap'
    ),

    pool_data AS (
    SELECT
    POOL_ADDRESS,
    POOL_NAME,
    BASE_TOKEN_NAME,
    BASE_TOKEN_SYMBOL,
    BASE_TOKEN_DECIMALS,
    BASE_TOKEN_PRICE_USD,
    QUOTE_TOKEN_NAME,
    QUOTE_TOKEN_SYMBOL,
    QUOTE_TOKEN_DECIMALS,
    QUOTE_TOKEN_PRICE_USD
    FROM $query('4422053b-e73b-4bd7-a6f2-fade06098f13')
    )
    Last run: 3 months ago
    TX_HASH
    CONTRACT_NAME
    CONTRACT_ADDRESS
    CLEAN_NAME1
    CLEAN_NAME2
    AMOUNT_1_RAW
    AMOUNT_2_RAW
    FINAL_TOKEN
    FINAL_AMOUNT_RAW
    FINAL_AMOUNT_ADJUSTED
    FINAL_AMOUNT_USD
    1
    		0x01a5e9ba506b0bd365a5dc6d1d0a7a8e50b32e7adcc575bb8b3e10f636e2a9a6PIXEL - Wrapped Ronin0xb30b54b9a36188d33eeb34b29eaa38d12511e997PIXELWrapped Ronin350000000000000000000PIXEL
    35000000000000000000
    		352.274496446
    2
    		0x18b685101d786ac73dc1d34b53effef0911af17f1dd94269c6fe56a5ff55c616Axie Infinity Shard - Wrapped Ronin0x32d1dbb6a4275133cc49f1c61653be3998ada4ffAxie Infinity ShardWrapped Ronin275012224385784000Axie Infinity Shard
    27501222438578431
    		0.027501222440.1185929216
    3
    		0x82053bab4c520209bccd60b21a08172575cce4dfda97959acfc177e0a291e58eSmooth Love Potion - Wrapped Ronin0x8f1c5eda143fa3d1bea8b4e92f33562014d30e0dSmooth Love PotionWrapped Ronin7500000Smooth Love Potion
    750000
    		7500001783.01258025
    4
    		0x4ee58bcce422274204bdb23b0f510945b794e2811bc29461271780b6d6f5720cRonin USD Coin - Ronin Wrapped Ether0xa7964991f339668107e2b6a6f6b8e8b74aa9d017Ronin USD CoinRonin Wrapped Ether01075181413771000000Ronin Wrapped Ether
    1075181413771000080
    		1.0751814142823.189852652
    5
    		0x4c7e1d727296016195cba851c64ab8ac5f676775847860bc3b18f14acd834037PIXEL - Wrapped Ronin0xb30b54b9a36188d33eeb34b29eaa38d12511e997PIXELWrapped Ronin2620000000000000000000PIXEL
    262000000000000000000
    		26217.026230538
    6
    		0x882b8f854179033f545af6e1b8092cc6e823c31af5d16699a08ccb95d15a13a9Axie Infinity Shard - Wrapped Ronin0x32d1dbb6a4275133cc49f1c61653be3998ada4ffAxie Infinity ShardWrapped Ronin3171487418786900000000Axie Infinity Shard
    317148741878690349056
    		317.1487418791367.633600687
    7
    		0x838aea46061a8355e5071a555d08a3e67c51f216fe8994635e8959541f4b379fPaper Hands Zyori - Wrapped Ronin0xb6cbda11526243c05bcb4c6bcd73f31b317050e4Paper Hands ZyoriWrapped Ronin7.407e+210Paper Hands Zyori
    7407000000000000000000
    		74070.1693917735
    8
    		0xc0dbf5de7f66e2f2179189e3a60367dc2ab8988a594219e6707dece41c9a50b8USD Coin - Wrapped Ronin0x4f7687affc10857fccd0938ecda0947de7ad3812USD CoinWrapped Ronin01971597692281720000Wrapped Ronin
    1971597692281719703
    		1.9715976922.272717142
    9
    		0x4a9bc955151c392e2e2dfbe553b38cfd846d4caf5541f8c1c1cbd2128995ab6fSmooth Love Potion - Wrapped Ronin0x8f1c5eda143fa3d1bea8b4e92f33562014d30e0dSmooth Love PotionWrapped Ronin51290Smooth Love Potion
    5129
    		512912.193428699
    10
    		0x076caf9bf21555a31ece630185ca989aa9e575c7d1456a65d8f64c329c5cb2e0USD Coin - Wrapped Ronin0x4f7687affc10857fccd0938ecda0947de7ad3812USD CoinWrapped Ronin0151000000000000000000Wrapped Ronin
    151000000000000000000
    		151174.062025848
    11
    		0x463f6b320fd07bc1207a1fb2ce02aff185bc89eb3fba60097058f64b347549a5CuteAsianGirl - Wrapped Ronin0x0f10e689be56c1b86bcbc0bfe90a21ca6d0eccc4CuteAsianGirlWrapped Ronin1.35717352074611e+230CuteAsianGirl
    135717352074610702478864
    		135717.352074611387.658562536
    12
    		0x33cad6662fbe0bbe05ce03a50e59eda815942a016660421e6cce8e035b019b20Smooth Love Potion - Wrapped Ronin0x8f1c5eda143fa3d1bea8b4e92f33562014d30e0dSmooth Love PotionWrapped Ronin0146690783414156000Wrapped Ronin
    146690783414156004
    		0.14669078340.1695589091
    13
    		0xfee6e561674ba71da7048a8414d2b9db145cea2ce972c2c612611aa9751f7be4Axie Infinity Shard - Wrapped Ronin0x32d1dbb6a4275133cc49f1c61653be3998ada4ffAxie Infinity ShardWrapped Ronin807122747360902000Axie Infinity Shard
    80712274736090210
    		0.080712274740.3480537815
    14
    		0x89854a4b0e9e0901ad4f137d02f537c1e0e3781ef80ec5756e83a75297bd4bc4Axie Infinity Shard - Wrapped Ronin0x32d1dbb6a4275133cc49f1c61653be3998ada4ffAxie Infinity ShardWrapped Ronin6942736361281630000Axie Infinity Shard
    694273636128163257
    		0.69427363612.993901055
    15
    		0x2b198045970050063bcd79a648835c5c84180a70e9fabec77402aeb08fefdf75Koku The Shikoku - Wrapped Ronin0x87df085e1dbfc6232f6ab29542bbc3874e91de55Koku The ShikokuWrapped Ronin020000000000000000000Wrapped Ronin
    20000000000000000000
    		2023.19317338
    16
    		0xb6143b6bdec46c85053d84ccaef569369e2a12f6142b9ad8c8c739aadb8365ceAxie Infinity Shard - Wrapped Ronin0x32d1dbb6a4275133cc49f1c61653be3998ada4ffAxie Infinity ShardWrapped Ronin1000000000000000000Axie Infinity Shard
    100000000000000000
    		0.10.4312278184
    17
    		0x0e805b5b3209d4e82d796d82c862d092a3a3c7f564145a57b693efd0217d073dRonin Wrapped Ether - Wrapped Ronin0x2ecb08f87f075b5769fe543d0e52e40140575ea7Ronin Wrapped EtherWrapped Ronin03325536210543510000Wrapped Ronin
    3325536210543510933
    		3.3255362113.855737689
    18
    		0xc87e6e28ddfca63a35d7fe9cbe06393aad49d6ad5e8f4f0c0316546652236bc0Ronin Wrapped Ether - Wrapped Ronin0x2ecb08f87f075b5769fe543d0e52e40140575ea7Ronin Wrapped EtherWrapped Ronin02954778047151720000Wrapped Ronin
    2954778047151721105
    		2.9547780473.425868298
    19
    		0x9fd0a65edbcd460490488d09b104594d3b91a066f0e6b62b7d9486e0ffeb7819COCK - Wrapped Ronin0x173fb0ae41bc1af80e1a4a065d0e9c6dc2e41b48COCKWrapped Ronin7.812e+210COCK
    7812000000000000000001
    		78129.953090782
    20
    		0xbce3925cce820c627fbd325668c8cf748d546977165b18e8921b851515ebc582USD Coin - Wrapped Ronin0x4f7687affc10857fccd0938ecda0947de7ad3812USD CoinWrapped Ronin35710350USD Coin
    3571035
    		3.5710353.584228689
    ...
    5000
    1MB
    4s