Baselight
SELECT 
    d.date,
    COALESCE(CASE WHEN d.close > d.open * 1.05 THEN ((d.close - d.open) / d.open) * 100 END, 0) AS dax_percentage_change,
    COALESCE(CASE WHEN n.close > n.open * 1.05 THEN ((n.close - n.open) / n.open) * 100 END, 0) AS nasdaq_percentage_change,
    COALESCE(CASE WHEN c.close > c.open * 1.05 THEN ((c.close - c.open) / c.open) * 100 END, 0) AS cac_percentage_change,
    COALESCE(CASE WHEN dj.n__close > dj.n__open * 1.05 THEN ((dj.n__close - dj.n__open) / dj.n__open) * 100 END, 0) AS dow_jones_percentage_change,
    COALESCE(CASE WHEN f.close > f.open * 1.05 THEN ((f.close - f.open) / f.open) * 100 END, 0) AS ftse_percentage_change,
    COALESCE(CASE WHEN hs.close > hs.open * 1.05 THEN ((hs.close - hs.open) / hs.open) * 100 END, 0) AS hang_seng_percentage_change,
    COALESCE(CASE WHEN k.close > k.open * 1.05 THEN ((k.close - k.open) / k.open) * 100 END, 0) AS kospi_percentage_change,
    COALESCE(CASE WHEN nf.close > nf.open * 1.05 THEN ((nf.close - nf.open) / nf.open) * 100 END, 0) AS nifty50_percentage_change,
    COALESCE(CASE WHEN nk.close > nk.open * 1.05 THEN ((nk.close - nk.open) / nk.open) * 100 END, 0) AS nikkei225_percentage_change,
    COALESCE(CASE WHEN s.close > s.open * 1.05 THEN ((s.close - s.open) / s.open) * 100 END, 0) AS sse_percentage_change
FROM "@kaggle.rohitktiwari04_top_10_stock_indices.dax" d
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.nasdaq" n ON d.date = n.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.cac" c ON d.date = c.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.dow_jones" dj ON d.date = dj.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.ftse" f ON d.date = f.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.hang_seng" hs ON d.date = hs.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.kospi" k ON d.date = k.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.nifty50" nf ON d.date = nf.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.nikkei_225" nk ON d.date = nk.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.sse" s ON d.date = s.date
WHERE NOT (
    COALESCE(CASE WHEN d.close > d.open * 1.05 THEN ((d.close - d.open) / d.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN n.close > n.open * 1.05 THEN ((n.close - n.open) / n.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN c.close > c.open * 1.05 THEN ((c.close - c.open) / c.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN dj.n__close > dj.n__open * 1.05 THEN ((dj.n__close - dj.n__open) / dj.n__open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN f.close > f.open * 1.05 THEN ((f.close - f.open) / f.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN hs.close > hs.open * 1.05 THEN ((hs.close - hs.open) / hs.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN k.close > k.open * 1.05 THEN ((k.close - k.open) / k.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN nf.close > nf.open * 1.05 THEN ((nf.close - nf.open) / nf.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN nk.close > nk.open * 1.05 THEN ((nk.close - nk.open) / nk.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN s.close > s.open * 1.05 THEN ((s.close - s.open) / s.open) * 100 END, 0) = 0
)
ORDER BY d.date ASC
datedax_percentage_changenasdaq_percentage_changecac_percentage_changedow_jones_percentage_changeftse_percentage_changehang_seng_percentage_changekospi_percentage_changenifty50_percentage_changenikkei225_percentage_changesse_percentage_change
2007-01-15 00:00:000000000005.061177208058424
2007-02-28 00:00:000000000005.356479791463791
2007-03-19 00:00:000000000005.243448404989412
2007-06-05 00:00:000000000005.685840161110278
2007-07-06 00:00:000000000005.042748805657371
2007-10-09 00:00:0000000005.22651384397466700
2007-10-23 00:00:0000000005.56188457457959300
2008-01-22 00:00:00006.5514577669140150000000
2008-01-23 00:00:0000000006.12578107392895400
2008-01-25 00:00:0000000006.917514354160400
2008-02-04 00:00:000000000005.824363224617972
2008-02-14 00:00:0000000005.20461717412809200
2008-03-25 00:00:0000000005.6467727865882700
2008-03-28 00:00:000000000005.964494172638894
2008-04-07 00:00:000000000005.297673055022397
2008-04-23 00:00:000000000005.195653313385328
2008-06-18 00:00:000000000006.086786145898727
2008-07-02 00:00:0000000005.08433359455437300
2008-07-23 00:00:0000000005.4183153845170200
2008-08-20 00:00:000000000008.180039144681993
2008-09-19 00:00:0000000005.05964038113186100
2008-09-30 00:00:00000006.61533331897318360000
2008-10-13 00:00:009.0570521710072346.3213435672271705.81201243917643107.62726170812047206.65465047882787100
2008-10-14 00:00:000000000012.3648578585374140
2008-10-28 00:00:0011.7856460647937636.26384976719997807.896901203930194012.9249239149961628.97747713961875806.6996683407409226.008453367145672
2008-10-29 00:00:007.81188077107165200000006.0760725256123450
2008-10-30 00:00:00000007.901915486397767009.1907673737579430
2008-10-31 00:00:0000000007.02073380409599800
2008-11-03 00:00:0000000005.49144664107636700
2008-11-04 00:00:005.164748695841391000000000
2008-11-07 00:00:00000007.3105799433628857.600893045403747000
2008-11-10 00:00:0000000005.884032829409207505.189682360626917
2008-11-13 00:00:0006.22995012337029706.177466978961004000000
2008-11-19 00:00:000000000006.7813259820455025
2008-11-21 00:00:000005.417738235452099507.1468830707527027.9581378445386575.47657611344594300
2008-11-24 00:00:009.27656004419354707.1832623386004340000000
2008-11-26 00:00:0006.30650754987391705.005649404797000000
2008-12-03 00:00:0005.39183311344875300000000
2008-12-05 00:00:0005.77323357715191800000000
2008-12-08 00:00:00000005.1849762606400686.1109469778740335000
2008-12-10 00:00:0000000005.11720757825435900
2009-03-04 00:00:000000000005.850430167669019
2009-03-10 00:00:0005.3788029508990585.72550155762775955.796233700574759000000
2009-03-23 00:00:000006.822268777690005000000
2009-05-04 00:00:0000000005.03924027565549400
2009-05-18 00:00:00000000017.69598348398687200
2011-11-03 00:00:005.10371802240296805.1290116533678140000000
2011-11-30 00:00:006.05499337877290605.4302348757194260000000
2015-06-30 00:00:000000000006.750308812202861
2015-07-09 00:00:000000000008.066414517783983
2015-09-09 00:00:00000000005.7009316748384840
2015-09-16 00:00:000000000005.14426963886155
2016-02-15 00:00:00000000005.0772619841609260
2020-03-13 00:00:000005.51474436397494606.72129452382376509.30652007541495200
2020-03-20 00:00:0000000005.56464206011199400
2020-03-24 00:00:000000005.66257134593762405.1460154647195020
2020-03-25 00:00:0000000007.5331404611737115.9621724712981750
2020-03-26 00:00:000005.048308256142276000000
2020-11-09 00:00:00005.9441068477641780000000

Share link

Anyone who has the link will be able to view this.