Query editor
-- special thanks to @messari https://dune.com/messari for catching a bugWITH sds_price AS (SELECT DISTINCTtime,last_value(price) OVER (PARTITION BY time ORDER BY evt_block_time ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS priceFROM(SELECT "current" / 1e27 AS price,evt_block_time,date_trunc('day', evt_block_time) AS timeFROM chainlink_optimism.AccessControlledOffchainAggregator_evt_AnswerUpdatedWHERE contract_address = (0x0D5642c6329adB3246c13D78B429a9FB1965a0d8))), cratio AS (SELECT cratio,time,coalesce( lead(time) over ( ORDER BY time ),now() ) AS time_endFROM(SELECT 1e18 / (newRatio) AS cratio,evt_block_time AS timeFROM synthetix_optimism.SystemSettings_evt_IssuanceRatioUpdated--kaleb broke the chartwhere evt_block_time < timestamp'2024-04-23 03:26')), maxIssueSynth AS (SELECT call_tx_hashFROM synthetix_optimism.SNX_call_issueMaxSynthsUNION ALLSELECT call_tx_hashFROM synthetix_optimism.SNX_call_issueMaxSynthsOnBehalf), sds_bal_L2 AS (SELECT DISTINCTtime,last_value(total_SDS) OVER (PARTITION BY time ORDER BY evt_block_time ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS total_SDSFROM(SELECT SUM(amount) over ( ORDER BY evt_block_time ) / 1e18 AS total_SDS,date_trunc('day',evt_block_time) AS time,evt_block_timeFROM(SELECT cast(amount as double) as amount,evt_block_timeFROM synthetix_optimism.SynthetixDebtShare_evt_MintUNION ALLSELECT cast(amount as double) * -1 as amount,evt_block_timeFROM synthetix_optimism.SynthetixDebtShare_evt_Burn))), sds_bal_L1 AS (