PREVIEW / etf_30min / 2000-05-25

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-05-25.parquet
  size:    10 KB
  rows:    200

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2000-05-25 09:30:00	SPY	ETF	140.6875	141.8125	140.375	141.3125	1526900.0
2000-05-25 10:00:00	SPY	ETF	141.4062	141.5	140.8438	141.0	806400.0
2000-05-25 10:30:00	SPY	ETF	141.0	141.375	140.8438	141.125	206000.0
2000-05-25 11:00:00	SPY	ETF	141.0625	141.4062	141.0312	141.1562	280900.0
2000-05-25 11:30:00	SPY	ETF	141.0312	141.0625	140.625	140.9375	209500.0
2000-05-25 12:00:00	SPY	ETF	140.9688	141.3125	140.875	141.1875	47200.0
2000-05-25 12:30:00	SPY	ETF	141.1875	141.375	140.875	140.875	153600.0
2000-05-25 13:00:00	SPY	ETF	140.875	141.4375	140.8438	141.3125	117200.0
2000-05-25 13:30:00	SPY	ETF	141.25	141.4688	140.5	140.5625	287100.0
2000-05-25 14:00:00	SPY	ETF	140.5	140.5312	140.0625	140.4062	334600.0
2000-05-25 14:30:00	SPY	ETF	140.2188	140.4062	139.0625	139.1562	591100.0
2000-05-25 15:00:00	SPY	ETF	139.1562	139.2812	138.0	138.375	1303100.0
2000-05-25 15:30:00	SPY	ETF	138.5	139.125	137.7188	138.875	906800.0
2000-05-25 16:00:00	SPY	ETF	138.6875	139.0938	138.2188	138.2188	989100.0
2000-05-25 16:30:00	SPY	ETF	138.6875	138.6875	137.8438	137.8438	200200.0
2000-05-25 09:30:00	QQQ	ETF	80.25	82.25	80.0	81.5312	5835400.0
2000-05-25 10:00:00	QQQ	ETF	81.625	82.0	81.0625	81.75	2751800.0
2000-05-25 10:30:00	QQQ	ETF	81.8125	81.875	81.1875	81.375	1104700.0
2000-05-25 11:00:00	QQQ	ETF	81.4375	81.75	81.25	81.375	651100.0
2000-05-25 11:30:00	QQQ	ETF	81.375	81.4375	80.25	80.9062	1602700.0
2000-05-25 12:00:00	QQQ	ETF	80.9375	81.4375	80.875	81.25	797900.0
2000-05-25 12:30:00	QQQ	ETF	81.25	81.5	81.0	81.0	1258200.0
2000-05-25 13:00:00	QQQ	ETF	81.0	82.0625	80.9375	81.9375	1595200.0
2000-05-25 13:30:00	QQQ	ETF	81.8125	82.0	81.125	81.25	1410100.0
2000-05-25 14:00:00	QQQ	ETF	81.0625	81.3438	80.4375	80.75	1617000.0
2000-05-25 14:30:00	QQQ	ETF	80.875	80.875	79.1875	79.1875	2421300.0
2000-05-25 15:00:00	QQQ	ETF	79.1875	79.5	77.625	78.2188	4613300.0
2000-05-25 15:30:00	QQQ	ETF	78.0	78.75	76.5	77.5625	3197500.0
2000-05-25 16:00:00	QQQ	ETF	77.5	78.0	77.4062	77.8125	658200.0
2000-05-25 16:30:00	QQQ	ETF	77.6875	77.6875	77.5	77.5	2200.0
2000-05-25 17:00:00	QQQ	ETF	77.5	77.5	77.5	77.5	1000.0
2000-05-25 17:30:00	QQQ	ETF	77.625	77.625	77.625	77.625	200.0
2000-05-25 18:00:00	QQQ	ETF	77.25	77.75	77.25	77.75	1000.0
2000-05-25 09:30:00	DIA	ETF	105.7188	105.8125	104.7812	105.4688	174400.0
2000-05-25 10:00:00	DIA	ETF	105.4062	105.4062	104.9062	105.0	98500.0
2000-05-25 10:30:00	DIA	ETF	105.0	105.3125	104.8125	104.8125	18000.0
2000-05-25 11:00:00	DIA	ETF	104.8125	105.2188	104.8125	105.1875	10000.0
2000-05-25 11:30:00	DIA	ETF	105.0	105.0312	104.6875	104.7188	14200.0
2000-05-25 12:00:00	DIA	ETF	105.0625	105.0938	104.8438	105.0938	114100.0
2000-05-25 12:30:00	DIA	ETF	105.1875	105.25	104.9688	104.9688	9000.0
2000-05-25 13:00:00	DIA	ETF	104.875	105.3125	104.875	105.25	74500.0
2000-05-25 13:30:00	DIA	ETF	105.2812	105.2812	104.5625	104.625	32000.0
2000-05-25 14:00:00	DIA	ETF	104.5625	104.5938	104.1562	104.25	50700.0
2000-05-25 14:30:00	DIA	ETF	104.25	104.4375	103.3438	103.4062	119100.0
2000-05-25 15:00:00	DIA	ETF	103.625	103.625	102.75	103.0625	272800.0
2000-05-25 15:30:00	DIA	ETF	103.0625	103.5625	102.5625	103.2812	188800.0
2000-05-25 16:00:00	DIA	ETF	103.25	103.5	103.125	103.5	23500.0

> showing 47 of 200 rows — these rows as CSV

> unlock the full archive -- $79 one-time