zakkisyedUntitled Query


    SELECT
    TO_TIMESTAMP(
    d.block_timestamp / 1000000000
    ) AS block_timestamp,
    bl.height AS block_id,
    d.rune_e8,
    d.asset_e8,
    d.synth_e8,
    d.pool AS pool_name
    FROM thorchain.liquidity_actions
    INNER JOIN
    ON bl.timestamp = d.block_timestamp
    WHERE
    (
    d._FIVETRAN_DELETED IS NULL
    OR d._FIVETRAN_DELETED = FALSE
    )
    GROUP BY
    block_timestamp,
    block_id,
    rune_e8,
    asset_e8,
    synth_e8,
    pool_name
    Run a query to Download Data