PREVIEW / etf_30min / 2001-01-31

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-31.parquet
  size:    14 KB
  rows:    339

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-31 09:30:00	SPY	ETF	137.4	137.88	137.4	137.78	1345400.0
2001-01-31 10:00:00	SPY	ETF	137.79	137.99	137.58	137.99	327800.0
2001-01-31 10:30:00	SPY	ETF	137.97	138.24	137.81	138.17	772300.0
2001-01-31 11:00:00	SPY	ETF	138.07	138.19	137.79	137.84	359200.0
2001-01-31 11:30:00	SPY	ETF	137.79	138.0	137.75	137.76	162700.0
2001-01-31 12:00:00	SPY	ETF	137.86	137.93	137.55	137.87	271100.0
2001-01-31 12:30:00	SPY	ETF	137.88	137.94	137.76	137.86	118400.0
2001-01-31 13:00:00	SPY	ETF	137.88	137.92	137.71	137.85	229600.0
2001-01-31 13:30:00	SPY	ETF	137.78	138.7	137.76	138.2	569500.0
2001-01-31 14:00:00	SPY	ETF	138.13	138.5	137.3	137.3	1991200.0
2001-01-31 14:30:00	SPY	ETF	137.3	137.98	137.0	137.73	705200.0
2001-01-31 15:00:00	SPY	ETF	137.79	137.79	137.07	137.16	803200.0
2001-01-31 15:30:00	SPY	ETF	137.3	137.35	136.6	137.06	1240600.0
2001-01-31 16:00:00	SPY	ETF	137.22	137.3	136.95	136.95	701900.0
2001-01-31 16:30:00	SPY	ETF	137.0	137.1	136.7	136.7	20000.0
2001-01-31 09:30:00	QQQ	ETF	67.25	67.45	66.8	67.4	3519100.0
2001-01-31 10:00:00	QQQ	ETF	67.44	67.75	67.24	67.67	4789200.0
2001-01-31 10:30:00	QQQ	ETF	67.68	67.8	67.41	67.58	1972000.0
2001-01-31 11:00:00	QQQ	ETF	67.6	67.68	67.16	67.2	1910500.0
2001-01-31 11:30:00	QQQ	ETF	67.2	67.25	66.87	66.89	3146000.0
2001-01-31 12:00:00	QQQ	ETF	66.94	67.1	66.65	66.97	2601200.0
2001-01-31 12:30:00	QQQ	ETF	66.97	67.25	66.8	67.03	1528400.0
2001-01-31 13:00:00	QQQ	ETF	67.0	67.09	66.81	66.94	1432500.0
2001-01-31 13:30:00	QQQ	ETF	66.93	67.3	66.89	67.21	3215600.0
2001-01-31 14:00:00	QQQ	ETF	67.2	68.0	65.8	66.5	12363900.0
2001-01-31 14:30:00	QQQ	ETF	66.47	66.9	65.85	66.38	7053600.0
2001-01-31 15:00:00	QQQ	ETF	66.32	66.52	65.48	65.55	5322400.0
2001-01-31 15:30:00	QQQ	ETF	65.62	65.65	64.62	64.9	7033200.0
2001-01-31 16:00:00	QQQ	ETF	64.65	65.29	64.3	64.45	1426900.0
2001-01-31 16:30:00	QQQ	ETF	64.5	64.6	64.24	64.3	101700.0
2001-01-31 17:00:00	QQQ	ETF	64.3	64.5	64.25	64.3	14200.0
2001-01-31 17:30:00	QQQ	ETF	64.25	64.3	64.0	64.25	12000.0
2001-01-31 18:00:00	QQQ	ETF	64.3	64.5	64.15	64.35	26900.0
2001-01-31 09:30:00	IWM	ETF	51.225	51.4	51.15	51.4	16200.0
2001-01-31 10:00:00	IWM	ETF	51.4	51.525	51.33	51.35	6200.0
2001-01-31 10:30:00	IWM	ETF	51.3	51.495	51.3	51.495	120800.0
2001-01-31 11:00:00	IWM	ETF	51.375	51.42	51.25	51.345	17200.0
2001-01-31 11:30:00	IWM	ETF	51.325	51.4	51.15	51.375	20400.0
2001-01-31 12:00:00	IWM	ETF	51.375	51.375	51.2	51.3	11200.0
2001-01-31 12:30:00	IWM	ETF	51.395	51.395	51.35	51.35	3000.0
2001-01-31 13:00:00	IWM	ETF	51.35	51.375	51.25	51.375	105800.0
2001-01-31 13:30:00	IWM	ETF	51.35	51.4	51.1	51.15	123400.0
2001-01-31 14:00:00	IWM	ETF	51.175	51.42	50.925	50.925	117000.0
2001-01-31 14:30:00	IWM	ETF	50.925	51.125	50.835	51.075	153000.0
2001-01-31 15:00:00	IWM	ETF	50.95	51.19	50.8	50.8	92000.0
2001-01-31 15:30:00	IWM	ETF	50.8	50.8	50.5	50.525	81400.0
2001-01-31 16:00:00	IWM	ETF	50.45	50.5	50.45	50.5	21000.0
2001-01-31 09:30:00	DIA	ETF	109.0	109.16	108.8	108.99	135900.0
2001-01-31 10:00:00	DIA	ETF	109.01	109.19	108.81	109.19	175900.0
2001-01-31 10:30:00	DIA	ETF	109.19	109.49	109.05	109.41	82400.0

> showing 50 of 339 rows — these rows as CSV

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