WITH refresh AS (

-- this is using our solana tables so the tagging algo knows this is a solana dashboard

SELECT MAX(block_timestamp) AS refresh_time

FROM solana.core.fact_transactions

), t0 AS (

-- mayan

SELECT livequery.live.udf_api(

'https://api.flipsidecrypto.com/api/v2/queries/aad1cbb0-7c1b-4a00-96fb-e54dcdbb8275/data/latest'

):data AS data, 'Mayan' AS bridge

UNION

-- liquid staking

SELECT livequery.live.udf_api(

'https://api.flipsidecrypto.com/api/v2/queries/616f95ad-e6cc-4b2d-91d1-31aa58c23e96/data/latest'

):data AS data, 'deBridge' AS bridge

UNION

-- liquid staking

SELECT livequery.live.udf_api(

'https://api.flipsidecrypto.com/api/v2/queries/a7924e6d-7edb-47a2-8bb9-bced7b0e533f/data/latest'

):data AS data, 'Allbridge' AS bridge

), t1 AS (

SELECT bridge

, d.value:DATE AS date

, d.value:N_TX AS n_tx

, d.value:VOLUME AS volume

-- , d.value:CUMU_N_TX AS cumu_n_tx

-- , d.value:CUMU_VOLUME AS cumu_volume

FROM t0

, LATERAL FLATTEN(

input => data

) d

WHERE date >= CURRENT_DATE - 7

SELECT *

, SUM(n_tx) OVER (PARTITION BY bridge ORDER BY date) AS cumu_n_tx