Query editor
WITHnftfi as (SELECT'nftfi' as loan_type,contract_address,borrower,lender,CAST(loanId as VARCHAR) as loan_id,CAST(loanLiquidationDate as double) as liquidation_date,CAST(loanMaturityDate as double) as maturity_date,loanPrincipalAmount as loan_amount,nftCollateralContract as collateral_contract,CAST(nftCollateralId as VARCHAR) as collateral_id,evt_block_number,evt_block_time,evt_index,evt_tx_hashFROMnftfi_ethereum.NFTfi_evt_LoanLiquidated),directloanfixedcollectionoffer_v2_3_loan_liquid as (SELECT'DirectLoanFixedCollectionOffer_v2.3' as loan_type,contract_address,borrower,lender,CAST(loanId as VARCHAR) as loan_id,CAST(loanLiquidationDate as double) as liquidation_date,CAST(loanMaturityDate as double) as maturity_date,loanPrincipalAmount as loan_amount,nftCollateralContract as collateral_contract,CAST(nftCollateralId as VARCHAR) as collateral_id,evt_block_number,evt_block_time,evt_index,evt_tx_hashFROMnftfi_ethereum.DirectLoanFixedCollectionOffer_v2_3_evt_LoanLiquidated),directloanfixedoffer_v2_3_loan_liquid as (SELECT'DirectLoanFixedOffer_v2.3' as loan_type,contract_address,borrower,lender,CAST(loanId as VARCHAR) as loan_id,CAST(loanLiquidationDate as double) as liquidation_date,CAST(loanMaturityDate as double) as maturity_date,loanPrincipalAmount as loan_amount,nftCollateralContract as collateral_contract,CAST(nftCollateralId as VARCHAR) as collateral_id,evt_block_number,evt_block_time,evt_index,evt_tx_hash