Query editor
WITH ptoken_events_list (tx_day, block_time, trader, amount, bucket, liquidity_index, borrow_index) AS (SELECTDATE_TRUNC('day', ptoken_events.block_time) AS tx_day,ptoken_events.block_time,sender AS trader,CASE WHEN action = 'Mint'THEN amountELSE -amountEND AS amount,buckets_arbitrum.address,CASEWHEN bucket_indexes.liquidityIndex IS NULLTHEN 1e27ELSE bucket_indexes.liquidityIndexEND AS liquidity_index,CASEWHEN bucket_indexes.variableBorrowIndex IS NULLTHEN 1e27ELSE bucket_indexes.variableBorrowIndexEND AS borrow_indexFROM query_3710584 AS ptoken_eventsLEFT JOIN query_3707092 AS bucket_indexesON bucket_indexes.tx_hash = ptoken_events.tx_hashLEFT JOIN query_3705030 AS ptokensON ptokens.address = ptoken_events.contract_addressLEFT JOIN query_3223575 AS buckets_arbitrumON buckets_arbitrum.borrowed_asset_address = ptokens.underline_asset_addressUNIONSELECT"day" AS tx_day,time AS block_time,0x0000000000000000000000000000000000000000 AS trader,0 AS amount,address AS bucket,1e27 AS liquidity_index,1e27 AS borrow_indexFROM query_3093463 AS time_series, query_3223575 AS buckets_arbitrum),debt_events_list (tx_day, block_time, trader, amount, bucket, liquidity_index, borrow_index) AS (SELECTDATE_TRUNC('day', debt_events.block_time) AS tx_day,debt_events.block_time,sender AS trader,CASE WHEN action = 'Mint'THEN amountELSE -amountEND AS amount,buckets_arbitrum.address,CASEWHEN bucket_indexes.liquidityIndex IS NULLTHEN 1e27ELSE bucket_indexes.liquidityIndexEND AS liquidity_index,CASEWHEN bucket_indexes.variableBorrowIndex IS NULLTHEN 1e27ELSE bucket_indexes.variableBorrowIndexEND AS borrow_indexFROM query_3711039 AS debt_eventsLEFT JOIN query_3707092 AS bucket_indexes