PREVIEW / etf_30min / 2000-09-28

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-09-28.parquet
  size:    12 KB
  rows:    283

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-09-28 09:30:00	SPY	ETF	143.1875	143.4375	142.9062	143.0	631800.0
2000-09-28 10:00:00	SPY	ETF	143.0	144.0312	142.875	143.9688	895500.0
2000-09-28 10:30:00	SPY	ETF	144.0	144.8125	143.7188	144.7812	574100.0
2000-09-28 11:00:00	SPY	ETF	144.75	144.8125	144.375	144.5	631500.0
2000-09-28 11:30:00	SPY	ETF	144.5312	145.3438	144.4062	145.3125	606300.0
2000-09-28 12:00:00	SPY	ETF	145.25	145.5625	145.0938	145.375	333700.0
2000-09-28 12:30:00	SPY	ETF	145.375	145.4375	145.125	145.25	73000.0
2000-09-28 13:00:00	SPY	ETF	145.125	145.4688	145.0	145.4062	176000.0
2000-09-28 13:30:00	SPY	ETF	145.1875	145.7188	145.1875	145.5625	195500.0
2000-09-28 14:00:00	SPY	ETF	145.5625	145.9375	145.4375	145.8438	297000.0
2000-09-28 14:30:00	SPY	ETF	145.8438	146.25	145.6562	146.0625	515100.0
2000-09-28 15:00:00	SPY	ETF	146.0938	146.3125	145.875	146.2188	597300.0
2000-09-28 15:30:00	SPY	ETF	146.3125	146.3125	145.8438	146.1875	931300.0
2000-09-28 16:00:00	SPY	ETF	146.2188	146.2188	145.0312	145.0312	475000.0
2000-09-28 17:30:00	SPY	ETF	145.125	145.125	145.0	145.0	2500.0
2000-09-28 09:30:00	QQQ	ETF	88.7188	89.9375	88.7188	89.0	3755500.0
2000-09-28 10:00:00	QQQ	ETF	88.875	90.1875	88.75	90.0	2964000.0
2000-09-28 10:30:00	QQQ	ETF	90.0	90.75	89.5	90.625	2372000.0
2000-09-28 11:00:00	QQQ	ETF	90.6875	90.75	90.1875	90.25	1770000.0
2000-09-28 11:30:00	QQQ	ETF	90.3438	91.75	90.25	91.6875	2200300.0
2000-09-28 12:00:00	QQQ	ETF	91.6875	92.3438	91.4375	92.0625	2246500.0
2000-09-28 12:30:00	QQQ	ETF	92.125	92.125	91.5625	91.625	1366200.0
2000-09-28 13:00:00	QQQ	ETF	91.5625	92.125	91.375	91.8125	1272200.0
2000-09-28 13:30:00	QQQ	ETF	91.875	92.2812	91.5625	92.0938	1170800.0
2000-09-28 14:00:00	QQQ	ETF	92.125	92.2188	91.5938	92.0	1300800.0
2000-09-28 14:30:00	QQQ	ETF	91.9375	92.625	91.6875	92.5	1577300.0
2000-09-28 15:00:00	QQQ	ETF	92.4688	92.9688	92.1875	92.9375	1804500.0
2000-09-28 15:30:00	QQQ	ETF	92.9375	93.0	92.375	92.75	2628000.0
2000-09-28 16:00:00	QQQ	ETF	92.8125	92.8125	92.375	92.5	521600.0
2000-09-28 16:30:00	QQQ	ETF	92.75	93.0	91.0	91.5625	139000.0
2000-09-28 17:00:00	QQQ	ETF	91.3125	91.8125	91.0	91.1875	51400.0
2000-09-28 17:30:00	QQQ	ETF	91.375	91.5	90.875	91.0	16700.0
2000-09-28 18:00:00	QQQ	ETF	91.375	91.875	91.0625	91.5625	8100.0
2000-09-28 09:30:00	IWM	ETF	50.8125	51.0312	50.8125	50.8125	26400.0
2000-09-28 10:00:00	IWM	ETF	50.7812	51.0312	50.7812	50.9062	11000.0
2000-09-28 10:30:00	IWM	ETF	51.0	51.0	50.9062	50.9062	800.0
2000-09-28 11:00:00	IWM	ETF	51.1875	51.2188	51.1562	51.1875	14000.0
2000-09-28 11:30:00	IWM	ETF	51.3438	51.4688	51.3438	51.4688	30400.0
2000-09-28 12:00:00	IWM	ETF	51.5625	51.6719	51.4531	51.6719	22400.0
2000-09-28 13:00:00	IWM	ETF	51.5156	51.6562	51.5156	51.6562	2400.0
2000-09-28 13:30:00	IWM	ETF	51.8438	51.8438	51.8438	51.8438	2000.0
2000-09-28 14:00:00	IWM	ETF	51.8281	51.8281	51.8281	51.8281	200.0
2000-09-28 14:30:00	IWM	ETF	51.8438	51.8438	51.8438	51.8438	2000.0
2000-09-28 15:00:00	IWM	ETF	52.0	52.0	52.0	52.0	400.0
2000-09-28 15:30:00	IWM	ETF	52.1562	52.1562	52.1406	52.1406	2400.0
2000-09-28 16:00:00	IWM	ETF	52.0625	52.0625	52.0625	52.0625	1000.0
2000-09-28 09:30:00	DIA	ETF	106.375	106.6562	106.3125	106.375	102900.0
2000-09-28 10:00:00	DIA	ETF	106.375	107.125	106.3438	107.125	240300.0
2000-09-28 10:30:00	DIA	ETF	107.0	107.5625	106.9375	107.5	96300.0
2000-09-28 11:00:00	DIA	ETF	107.5	107.625	107.25	107.4375	39900.0

> showing 50 of 283 rows — these rows as CSV

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