Testing | Multipartite

Updated 2025-05-14

-- Use this network version check by selecting the lines and running them, without checking for a separate query tab. Don't delete this section.

SELECT reftable.block_timestamp, block_id, version

FROM (thorchain.core.fact_network_version_events AS reftable INNER JOIN thorchain.core.dim_block

ON reftable.dim_block_id = dim_block.dim_block_id)

ORDER BY block_id DESC

SELECT block_id, reftable.*

FROM (thorchain.defi.fact_refund_events AS reftable INNER JOIN thorchain.core.dim_block

ON reftable.dim_block_id = dim_block.dim_block_id)

ORDER BY block_id DESC

LIMIT 1

SELECT block_id, reftable.block_timestamp,

rune_e8 / NULLIF(asset_e8, 0) AS rune_per_asset,

asset_e8, rune_e8, synth_e8,

ABS(rune_per_asset - 14629) AS target_distance

FROM (thorchain.defi.fact_block_pool_depths AS reftable INNER JOIN thorchain.core.dim_block

ON reftable.dim_block_id = dim_block.dim_block_id)

WHERE pool_name = 'BTC.BTC'

AND target_distance <= 10000

AND DATE(reftable.block_timestamp) BETWEEN '2024-08-30' AND '2024-09-01'

QUALIFY target_distance = MIN(target_distance) OVER(PARTITION BY DATE(reftable.block_timestamp))

ORDER BY block_id DESC

LIMIT 50

WITH

fees AS (

SELECT DATE(block_timestamp) AS date,

Last run: about 1 month ago

153B

flipside