crypto_quant/sql/query/sql_playground.sql

use okx;

select DISTINCT symbol from crypto_huge_volume
where symbol in ("QQQ", "TQQQ", "MSFT", "AAPL", "GOOG", "NVDA", "META", "AMZN", "TSLA", "AVGO") and bar="30m"
and window_size=120
group by symbol

select * from crypto_market_data
where symbol="PLTR" and bar="5m"
order by date_time_us


select * from crypto_market_data
where symbol = "BTC-USDT" and bar="1H" #and open between 114271 and 114272 # AND date_time > "2025-08-21"
order by date_time desc;

select count(1)  from crypto_market_data where
symbol in ("QQQ", "TQQQ", "MSFT", "AAPL", "GOOG", "NVDA", "META", "AMZN", "TSLA", "AVGO")

select count(1)   from crypto_huge_volume where
symbol in ("QQQ", "TQQQ", "MSFT", "AAPL", "GOOG", "NVDA", "META", "AMZN", "TSLA", "AVGO")


select symbol, bar, date_time, close, 
pct_chg, ma_cross, ma5, ma10, ma20, ma30, dif, dea, macd, kdj_k, kdj_d, kdj_k, kdj_pattern,
rsi_14, rsi_signal,
boll_upper, boll_middle, boll_lower, boll_pattern, boll_signal
from crypto_market_data
WHERE ma_cross in ("20下穿10", "10下穿5")
order by timestamp desc;

select symbol, bar, window_size, date_time, close, 
volume, volume_ratio, huge_volume, 
close_20_low, low_20_low, close_10_low, low_10_low,
close_80_high, close_90_high, high_80_high, high_90_high 
from crypto_huge_volume
WHERE symbol='BTC-USDT' and bar='5m' and window_size=120# and low_10_low=1
order by timestamp;

select * from crypto_huge_volume
WHERE symbol='BTC-USDT' and bar='5m' #and date_time > '2025-08-04 15:00:00'
order by timestamp DESC;


select * from crypto_trade_data
where symbol='XCH-USDT'
order by ts desc;

select count(1) from crypto_trade_data;

select * from crypto_huge_volume
WHERE symbol='XCH-USDT' and bar='5m' and window_size = 80 and date_time > '2025-07-26'
order by timestamp;

select * from crypto_huge_volume
WHERE symbol='XCH-USDT-SWAP' and bar='5m' and date_time > '2025-07-26'
order by timestamp desc;

select * from crypto_huge_volume
WHERE symbol='BTC-USDT' and bar='5m' 
order by timestamp desc
limit 10;


SHOW VARIABLES LIKE 'max_connections';