WITH CTE_1 AS (

SELECT

block_timestamp AS time,

tx_hash AS hash,

EVENT_DATA['added_x_val'] / 1000000 AS added_wETH,

EVENT_DATA['added_y_val'] / 100000000 AS added_APT,

NULL AS removed_APT,

NULL AS removed_wETH,

NULL AS swapped_wETH,

NULL AS swapped_APT

FROM

aptos.core.fact_events

WHERE

EVENT_TYPE = '0x190d44266241744264b964a37b8f09863167a12d3e70cda39376cfb4e3561e12::liquidity_pool::LiquidityAddedEvent<0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH, 0x1::aptos_coin::AptosCoin, 0x190d44266241744264b964a37b8f09863167a12d3e70cda39376cfb4e3561e12::curves::Uncorrelated>'

AND BLOCK_TIMESTAMP BETWEEN '2022-01-01' AND '2022-11-10'

),

CTE_2 AS (

SELECT

block_timestamp AS time,

tx_hash AS hash,

NULL AS added_wETH,

NULL AS added_APT,

EVENT_DATA['returned_y_val'] / 100000000 AS removed_APT,

EVENT_DATA['returned_x_val'] / 1000000 AS removed_wETH,

NULL AS swapped_wETH,