PREVIEW / etf_30min / 2001-09-05

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-09-05.parquet
  size:    16 KB
  rows:    387

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-09-05 09:30:00	SPY	ETF	113.7	114.19	112.57	113.95	2429700.0
2001-09-05 10:00:00	SPY	ETF	113.91	113.91	112.9	113.35	1536700.0
2001-09-05 10:30:00	SPY	ETF	113.38	113.73	113.04	113.48	1388300.0
2001-09-05 11:00:00	SPY	ETF	113.48	113.58	112.91	113.1	1062300.0
2001-09-05 11:30:00	SPY	ETF	113.15	113.57	113.08	113.17	682800.0
2001-09-05 12:00:00	SPY	ETF	113.18	113.28	112.99	113.11	453600.0
2001-09-05 12:30:00	SPY	ETF	113.11	113.11	112.64	112.65	752500.0
2001-09-05 13:00:00	SPY	ETF	112.64	112.75	111.95	112.29	2557500.0
2001-09-05 13:30:00	SPY	ETF	112.25	112.88	112.15	112.81	1937000.0
2001-09-05 14:00:00	SPY	ETF	112.88	113.2	112.73	112.78	1523600.0
2001-09-05 14:30:00	SPY	ETF	112.77	114.15	112.61	113.61	2129700.0
2001-09-05 15:00:00	SPY	ETF	113.62	113.96	113.22	113.59	1524900.0
2001-09-05 15:30:00	SPY	ETF	113.62	113.72	113.06	113.6	1640600.0
2001-09-05 16:00:00	SPY	ETF	113.65	113.74	113.58	113.65	807600.0
2001-09-05 17:30:00	SPY	ETF	113.7	113.86	113.7	113.86	800.0
2001-09-05 09:30:00	QQQ	ETF	35.49	35.91	35.16	35.82	13840100.0
2001-09-05 10:00:00	QQQ	ETF	35.72	35.9	35.07	35.34	6332800.0
2001-09-05 10:30:00	QQQ	ETF	35.31	35.55	35.09	35.38	4833400.0
2001-09-05 11:00:00	QQQ	ETF	35.37	35.42	34.95	35.07	5554000.0
2001-09-05 11:30:00	QQQ	ETF	35.09	35.28	34.97	35.04	2857100.0
2001-09-05 12:00:00	QQQ	ETF	35.05	35.08	34.87	34.93	2928300.0
2001-09-05 12:30:00	QQQ	ETF	34.92	34.95	34.61	34.62	3941700.0
2001-09-05 13:00:00	QQQ	ETF	34.61	34.75	34.15	34.43	8677900.0
2001-09-05 13:30:00	QQQ	ETF	34.42	34.85	34.31	34.79	6104000.0
2001-09-05 14:00:00	QQQ	ETF	34.79	35.08	34.66	34.7	6106700.0
2001-09-05 14:30:00	QQQ	ETF	34.69	35.84	34.61	35.27	13155500.0
2001-09-05 15:00:00	QQQ	ETF	35.27	35.5	34.94	35.26	8181000.0
2001-09-05 15:30:00	QQQ	ETF	35.23	35.3	34.89	35.28	7486500.0
2001-09-05 16:00:00	QQQ	ETF	35.3	35.43	34.25	35.28	1064200.0
2001-09-05 16:30:00	QQQ	ETF	35.25	35.34	34.18	35.28	187800.0
2001-09-05 17:00:00	QQQ	ETF	35.31	35.34	35.2	35.29	24000.0
2001-09-05 17:30:00	QQQ	ETF	35.31	35.35	35.2	35.2	16200.0
2001-09-05 18:00:00	QQQ	ETF	35.32	35.4	35.27	35.36	13500.0
2001-09-05 09:30:00	IWM	ETF	46.6	46.675	46.3	46.65	15600.0
2001-09-05 10:00:00	IWM	ETF	46.505	46.545	46.29	46.4	8400.0
2001-09-05 10:30:00	IWM	ETF	46.4	46.42	46.16	46.315	6800.0
2001-09-05 11:00:00	IWM	ETF	46.315	46.34	46.2	46.2	4200.0
2001-09-05 11:30:00	IWM	ETF	46.055	46.37	46.055	46.325	6200.0
2001-09-05 12:00:00	IWM	ETF	46.25	46.25	46.175	46.175	3600.0
2001-09-05 12:30:00	IWM	ETF	46.145	46.145	46.0	46.1	210400.0
2001-09-05 13:00:00	IWM	ETF	46.065	46.065	45.7	45.85	3000.0
2001-09-05 13:30:00	IWM	ETF	45.85	45.99	45.85	45.99	36800.0
2001-09-05 14:00:00	IWM	ETF	46.095	46.15	46.0	46.0	10400.0
2001-09-05 14:30:00	IWM	ETF	46.125	46.305	46.12	46.295	15000.0
2001-09-05 15:00:00	IWM	ETF	46.15	46.225	46.025	46.055	3800.0
2001-09-05 15:30:00	IWM	ETF	46.125	46.14	45.905	46.14	38200.0
2001-09-05 16:00:00	IWM	ETF	46.175	46.175	46.175	46.175	600.0
2001-09-05 09:30:00	DIA	ETF	100.0	100.86	99.28	100.7	1297400.0
2001-09-05 10:00:00	DIA	ETF	100.71	100.71	99.68	100.18	416800.0
2001-09-05 10:30:00	DIA	ETF	100.22	100.46	99.85	100.24	234500.0

> showing 50 of 387 rows — these rows as CSV

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