PREVIEW / etf_30min / 2000-08-01

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-08-01.parquet
  size:    11 KB
  rows:    252

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-08-01 09:30:00	SPY	ETF	143.625	143.9375	143.125	143.5938	675600.0
2000-08-01 10:00:00	SPY	ETF	143.5312	143.9688	143.125	143.5938	275800.0
2000-08-01 10:30:00	SPY	ETF	143.5938	143.9375	143.4062	143.9375	175500.0
2000-08-01 11:00:00	SPY	ETF	143.875	144.0938	143.7188	143.9062	337700.0
2000-08-01 11:30:00	SPY	ETF	143.875	144.25	143.7188	143.9062	333000.0
2000-08-01 12:00:00	SPY	ETF	143.8438	144.0	143.5312	144.0	152700.0
2000-08-01 12:30:00	SPY	ETF	143.875	144.0625	143.7188	143.9688	145300.0
2000-08-01 13:00:00	SPY	ETF	143.8438	144.0	143.6875	144.0	162400.0
2000-08-01 13:30:00	SPY	ETF	143.9688	144.1562	143.7812	144.1562	37500.0
2000-08-01 14:00:00	SPY	ETF	144.0938	144.7188	144.0938	144.375	391900.0
2000-08-01 14:30:00	SPY	ETF	144.375	144.5	144.0312	144.125	200800.0
2000-08-01 15:00:00	SPY	ETF	144.0625	144.0625	143.625	143.7812	475700.0
2000-08-01 15:30:00	SPY	ETF	143.875	144.3438	143.75	144.0	337600.0
2000-08-01 16:00:00	SPY	ETF	143.9688	143.9688	143.625	143.875	216800.0
2000-08-01 16:30:00	SPY	ETF	143.875	143.875	143.875	143.875	500.0
2000-08-01 09:30:00	QQQ	ETF	89.8125	89.9688	88.5	88.9375	2864800.0
2000-08-01 10:00:00	QQQ	ETF	88.9375	89.25	88.25	88.625	1911900.0
2000-08-01 10:30:00	QQQ	ETF	88.75	89.0625	88.3125	88.9688	1229200.0
2000-08-01 11:00:00	QQQ	ETF	89.0	89.5	88.5938	89.3125	1018100.0
2000-08-01 11:30:00	QQQ	ETF	89.375	89.5	88.75	88.9375	905400.0
2000-08-01 12:00:00	QQQ	ETF	88.9375	89.1562	88.6562	89.0938	499500.0
2000-08-01 12:30:00	QQQ	ETF	89.0938	89.25	88.75	88.75	423200.0
2000-08-01 13:00:00	QQQ	ETF	88.75	88.8438	88.4375	88.8125	545000.0
2000-08-01 13:30:00	QQQ	ETF	88.8125	89.0312	88.5938	89.0	481300.0
2000-08-01 14:00:00	QQQ	ETF	89.0312	89.5625	89.0	89.125	877000.0
2000-08-01 14:30:00	QQQ	ETF	89.125	89.1875	88.25	88.25	854300.0
2000-08-01 15:00:00	QQQ	ETF	88.25	88.4375	87.6875	88.0	2104500.0
2000-08-01 15:30:00	QQQ	ETF	88.0	88.375	87.6875	87.9688	1385400.0
2000-08-01 16:00:00	QQQ	ETF	88.0	88.5	87.875	88.4062	576100.0
2000-08-01 16:30:00	QQQ	ETF	88.25	88.4375	88.125	88.4375	1300.0
2000-08-01 17:00:00	QQQ	ETF	87.75	87.75	87.75	87.75	400.0
2000-08-01 18:00:00	QQQ	ETF	88.0	88.25	88.0	88.25	1500.0
2000-08-01 09:30:00	IWM	ETF	49.875	49.9375	49.875	49.9375	65400.0
2000-08-01 10:00:00	IWM	ETF	49.9375	49.9375	49.9375	49.9375	200.0
2000-08-01 10:30:00	IWM	ETF	50.0	50.0312	49.9375	50.0	81800.0
2000-08-01 11:00:00	IWM	ETF	50.0	50.0469	50.0	50.0469	4400.0
2000-08-01 11:30:00	IWM	ETF	50.0625	50.0625	50.0625	50.0625	13800.0
2000-08-01 12:00:00	IWM	ETF	50.0312	50.0312	50.0312	50.0312	19200.0
2000-08-01 13:30:00	IWM	ETF	50.0	50.0	49.875	49.875	20800.0
2000-08-01 14:00:00	IWM	ETF	49.9688	50.0625	49.9688	50.0625	50400.0
2000-08-01 15:00:00	IWM	ETF	49.8906	49.8906	49.7344	49.7812	2600.0
2000-08-01 15:30:00	IWM	ETF	49.8125	49.9219	49.6406	49.9219	4800.0
2000-08-01 09:30:00	DIA	ETF	105.5312	105.5938	105.0938	105.5938	70400.0
2000-08-01 10:00:00	DIA	ETF	105.3125	105.8125	105.0312	105.4688	85200.0
2000-08-01 10:30:00	DIA	ETF	105.4688	105.7188	105.3125	105.7188	12500.0
2000-08-01 11:00:00	DIA	ETF	105.75	105.75	105.375	105.4688	8200.0
2000-08-01 11:30:00	DIA	ETF	105.4688	105.5938	105.4062	105.5938	1700.0
2000-08-01 12:00:00	DIA	ETF	105.3125	105.5312	105.2812	105.5312	9100.0
2000-08-01 12:30:00	DIA	ETF	105.5625	105.5938	105.5625	105.5938	1400.0
2000-08-01 13:00:00	DIA	ETF	105.5312	105.6875	105.5	105.6875	15900.0

> showing 50 of 252 rows — these rows as CSV

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