Query editor
WITHliquidium_tx AS (SELECTCAST(tx_id AS VARCHAR) AS tx_id,start_date,borrower_taproot,lender_taproot,borrower_segwit,lender_segwit,principal_amount_sats,collateraltype,slug,floor_price,'MANUAL_FIXED' AS typeFROM dune.liquidiumfi.dataset_liquidium_v2UNION ALLSELECTCAST(tx_id AS VARCHAR) AS tx_id,start_date,borrower_taproot,lender_taproot,borrower_segwit,lender_segwit,principal_amount_sats,collateraltype,slug,CAST(floor_price AS DOUBLE) AS floor_price,typeFROM dune.liquidiumfi.dataset_liquidium_v3UNION ALLSELECTDISTINCT tx_id,start_date,borrower_taproot,lender_taproot,borrower_segwit,lender_segwit,principal_amount_sats,collateraltype,slug,floor_price,typeFROM dune.liquidiumfi.liquidium_tx3_live),transactions AS (SELECTDISTINCT t.id AS hash,t.block_time,CAST(lt.principal_amount_sats AS DOUBLE)/100000000 AS amount,lt.borrower_taproot,lt.lender_taproot,lt.borrower_segwit,lt.lender_segwit,lt.collateraltype,lt.slug,lt.floor_price,lt.type -- bring in `type`FROM bitcoin.transactions tJOIN liquidium_tx lt ON lt.tx_id = CAST(t.id AS VARCHAR)WHERE