Query editor
SELECT date_trunc('month', evt_block_time),sum(eth) AS ethFROM(SELECT evt_block_time,loanPrincipalAmount / CASEWHEN loanERC20Denomination = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' THEN 1e18WHEN loanERC20Denomination = '0x6b175474e89094c44da98b954eedeac495271d0f' THEN 1e18 * priceWHEN loanERC20Denomination = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 1e6 * priceEND AS ethFROM nftfi_ethereum.NFTfi_evt_LoanStartedINNER JOIN prices.usd p ON date_trunc('minute', evt_block_time) = MINUTEAND p.contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'AND MINUTE > '2020-05-15'UNION ALL SELECT evt_block_time,get_json_object(loanTerms, '$.loanPrincipalAmount') / CASEWHEN get_json_object(loanTerms, '$.loanERC20Denomination') = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' THEN 1e18WHEN get_json_object(loanTerms, '$.loanERC20Denomination') = '0x6b175474e89094c44da98b954eedeac495271d0f' THEN 1e18 * priceWHEN get_json_object(loanTerms, '$.loanERC20Denomination') = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 1e6 * priceEND AS ethFROM nftfi_ethereum.DirectLoanFixedOffer_evt_LoanStartedINNER JOIN prices.usd p ON date_trunc('minute', evt_block_time) = MINUTEAND p.contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'AND MINUTE > '2022-03-30'UNION ALL SELECT evt_block_time,get_json_object(loanTerms, '$.loanPrincipalAmount') / CASEWHEN get_json_object(loanTerms, '$.loanERC20Denomination') = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' THEN 1e18WHEN get_json_object(loanTerms, '$.loanERC20Denomination') = '0x6b175474e89094c44da98b954eedeac495271d0f' THEN 1e18 * priceWHEN get_json_object(loanTerms, '$.loanERC20Denomination') = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 1e6 * priceEND AS ethFROM nftfi_ethereum.DirectLoanFixedOfferRedeploy_evt_LoanStartedINNER JOIN prices.usd p ON date_trunc('minute', evt_block_time) = MINUTEAND p.contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'AND MINUTE > '2022-10-18'UNION ALL SELECT evt_block_time,get_json_object(loanTerms, '$.loanPrincipalAmount') / CASEWHEN get_json_object(loanTerms, '$.loanERC20Denomination') = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' THEN 1e18WHEN get_json_object(loanTerms, '$.loanERC20Denomination') = '0x6b175474e89094c44da98b954eedeac495271d0f' THEN 1e18 * priceWHEN get_json_object(loanTerms, '$.loanERC20Denomination') = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 1e6 * priceEND AS ethFROM nftfi_ethereum.DirectLoanFixedCollectionOffer_evt_LoanStartedINNER JOIN prices.usd p ON date_trunc('minute', evt_block_time) = MINUTEAND p.contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'AND MINUTE > '2022-11-09') aGROUP BY 1