BLOCK_ID_TABLE.SWAP_BLOCK_ID AS "SWAP_BLOCK_ID",

BLOCK_ID_TABLE_PRICE.PRICE_BLOCK_ID_B AS "PRICE_BLOCK_ID",

(ETH_MINTED.TO_AMOUNT - ETHB_BURNED.FROM_AMOUNT) AS "SWAP_PROFIT",

((ETHB_PRICES.ETHB_PRICE / ETH_PRICES.ETH_PRICE) - 1) * 100 AS "ETHBtoETH",

ETH_PRICES.ETH_PRICE,

ETH_PRICES.ETH_RUNE_PRICE,

ETHB_PRICES.ETHB_PRICE,

ETHB_PRICES.ETHB_RUNE_PRICE,

ETH_MINTED.TO_ASSET,

ETH_MINTED.TO_AMOUNT,

ETH_MINTED.TO_AMOUNT_USD,

ETH_MINTED.ETH_SWAP_SLIP_BP

(SELECT

DIM_BLOCK_ID,

TX_ID AS "ETHB_TX_ID",

FROM_ASSET,

FROM_AMOUNT,

FROM_AMOUNT_USD,

SWAP_SLIP_BP AS "ETHB_SWAP_SLIP_BP"

FROM thorchain.core.fact_swaps

WHERE FROM_ASSET = 'BNB/ETH-1C9'

AND BLOCK_TIMESTAMP > '2023-02-01') AS "ETHB_BURNED"

INNER JOIN

(SELECT

DIM_BLOCK_ID AS "DIM_BLOCK_ID_B"

,BLOCK_ID AS "SWAP_BLOCK_ID"

,(BLOCK_ID - 1) AS "PRICE_BLOCK_ID"

FROM thorchain.core.dim_block

WHERE BLOCK_TIMESTAMP > '2023-02-01') "BLOCK_ID_TABLE"

ON ETHB_BURNED.DIM_BLOCK_ID = BLOCK_ID_TABLE.DIM_BLOCK_ID_B

INNER JOIN

(SELECT

DIM_BLOCK_ID AS "DIM_BLOCK_ID_PRICE"

,BLOCK_ID AS "PRICE_BLOCK_ID_B"