PREVIEW / etf_30min / 2001-01-19

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-19.parquet
  size:    12 KB
  rows:    316

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
2001-01-19 09:30:00	SPY	ETF	136.1875	136.1875	134.6875	134.75	1604400.0
2001-01-19 10:00:00	SPY	ETF	134.875	135.0	133.875	134.4062	1096100.0
2001-01-19 10:30:00	SPY	ETF	134.4062	134.625	133.875	134.25	482000.0
2001-01-19 11:00:00	SPY	ETF	134.1875	134.7188	134.0312	134.125	459600.0
2001-01-19 11:30:00	SPY	ETF	134.1875	134.7812	134.0	134.75	359500.0
2001-01-19 12:00:00	SPY	ETF	134.7812	134.8125	134.25	134.3438	159400.0
2001-01-19 12:30:00	SPY	ETF	134.4375	134.6875	134.1562	134.3438	559400.0
2001-01-19 13:00:00	SPY	ETF	134.3125	134.8125	134.1562	134.4375	120500.0
2001-01-19 13:30:00	SPY	ETF	134.375	134.9688	134.375	134.8125	125900.0
2001-01-19 14:00:00	SPY	ETF	134.75	134.9688	134.5	134.9688	473400.0
2001-01-19 14:30:00	SPY	ETF	134.875	135.25	134.4688	134.4688	308000.0
2001-01-19 15:00:00	SPY	ETF	134.5	134.6875	134.0625	134.3125	780800.0
2001-01-19 15:30:00	SPY	ETF	134.375	134.6562	134.25	134.4688	522900.0
2001-01-19 16:00:00	SPY	ETF	134.4062	134.5	134.0312	134.375	389100.0
2001-01-19 16:30:00	SPY	ETF	134.0312	134.0312	134.0312	134.0312	700.0
2001-01-19 17:30:00	SPY	ETF	134.75	136.0	134.75	136.0	500.0
2001-01-19 09:30:00	QQQ	ETF	68.125	68.3125	66.75	66.75	12542100.0
2001-01-19 10:00:00	QQQ	ETF	66.7812	67.0	65.5625	66.3125	8287600.0
2001-01-19 10:30:00	QQQ	ETF	66.3125	66.875	66.0938	66.4062	6224600.0
2001-01-19 11:00:00	QQQ	ETF	66.4375	66.875	66.0625	66.2188	2538000.0
2001-01-19 11:30:00	QQQ	ETF	66.25	66.75	65.9062	66.625	3094700.0
2001-01-19 12:00:00	QQQ	ETF	66.6875	66.7188	66.0625	66.3438	1331700.0
2001-01-19 12:30:00	QQQ	ETF	66.375	66.5938	66.25	66.4062	1758500.0
2001-01-19 13:00:00	QQQ	ETF	66.4062	66.9062	66.3125	66.625	1971100.0
2001-01-19 13:30:00	QQQ	ETF	66.625	67.1875	66.5	67.0	2708500.0
2001-01-19 14:00:00	QQQ	ETF	66.9375	67.375	66.75	67.3125	1964800.0
2001-01-19 14:30:00	QQQ	ETF	67.25	67.5312	66.5312	66.5312	3156300.0
2001-01-19 15:00:00	QQQ	ETF	66.5	66.7812	66.0	66.0625	3339600.0
2001-01-19 15:30:00	QQQ	ETF	66.1875	66.5	66.0	66.3438	3697300.0
2001-01-19 16:00:00	QQQ	ETF	66.3438	66.5938	65.7812	66.3125	1199300.0
2001-01-19 16:30:00	QQQ	ETF	66.375	66.375	66.125	66.3125	40700.0
2001-01-19 17:00:00	QQQ	ETF	66.25	66.4375	66.25	66.375	7500.0
2001-01-19 17:30:00	QQQ	ETF	66.4375	66.4375	66.25	66.375	6200.0
2001-01-19 18:00:00	QQQ	ETF	66.4375	66.4375	66.0	66.3125	12100.0
2001-01-19 09:30:00	IWM	ETF	49.9062	49.9062	49.0938	49.0938	67600.0
2001-01-19 10:00:00	IWM	ETF	49.0625	49.0625	48.8125	48.8438	36000.0
2001-01-19 10:30:00	IWM	ETF	49.0	49.0625	48.9844	49.0	12400.0
2001-01-19 11:00:00	IWM	ETF	48.9844	49.0625	48.875	49.0312	91800.0
2001-01-19 11:30:00	IWM	ETF	49.0469	49.0469	48.875	49.0312	62200.0
2001-01-19 12:00:00	IWM	ETF	49.0312	49.0312	48.7812	48.875	14000.0
2001-01-19 12:30:00	IWM	ETF	48.9062	48.9062	48.7188	48.7188	21400.0
2001-01-19 13:00:00	IWM	ETF	48.8438	48.9531	48.7188	48.9531	6800.0
2001-01-19 13:30:00	IWM	ETF	48.9375	49.0625	48.9375	49.0625	54200.0
2001-01-19 14:00:00	IWM	ETF	48.9688	49.0312	48.9375	49.0156	11600.0
2001-01-19 14:30:00	IWM	ETF	49.0	49.1562	48.7812	48.7812	35400.0
2001-01-19 15:00:00	IWM	ETF	48.75	48.8438	48.7188	48.8438	2600.0
2001-01-19 15:30:00	IWM	ETF	48.75	48.8125	48.625	48.75	137000.0
2001-01-19 16:00:00	IWM	ETF	48.625	48.625	48.3906	48.625	32200.0
2001-01-19 09:30:00	DIA	ETF	107.125	107.125	106.125	106.25	196000.0
2001-01-19 10:00:00	DIA	ETF	106.25	106.5938	105.7188	106.0625	91300.0

> showing 50 of 316 rows — these rows as CSV

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