PREVIEW / etf_1hour / 2001-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-05.parquet
  size:    12 KB
  rows:    251

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:00: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.48	2925000.0
2001-09-05 11:00:00	SPY	ETF	113.48	113.58	112.91	113.17	1745100.0
2001-09-05 12:00:00	SPY	ETF	113.18	113.28	112.64	112.65	1206100.0
2001-09-05 13:00:00	SPY	ETF	112.64	112.88	111.95	112.81	4494500.0
2001-09-05 14:00:00	SPY	ETF	112.88	114.15	112.61	113.61	3653300.0
2001-09-05 15:00:00	SPY	ETF	113.62	113.96	113.06	113.6	3165500.0
2001-09-05 16:00:00	SPY	ETF	113.65	113.74	113.58	113.65	807600.0
2001-09-05 17:00:00	SPY	ETF	113.7	113.86	113.7	113.86	800.0
2001-09-05 09:00: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.38	11166200.0
2001-09-05 11:00:00	QQQ	ETF	35.37	35.42	34.95	35.04	8411100.0
2001-09-05 12:00:00	QQQ	ETF	35.05	35.08	34.61	34.62	6870000.0
2001-09-05 13:00:00	QQQ	ETF	34.61	34.85	34.15	34.79	14781900.0
2001-09-05 14:00:00	QQQ	ETF	34.79	35.84	34.61	35.27	19262200.0
2001-09-05 15:00:00	QQQ	ETF	35.27	35.5	34.89	35.28	15667500.0
2001-09-05 16:00:00	QQQ	ETF	35.3	35.43	34.18	35.28	1252000.0
2001-09-05 17:00:00	QQQ	ETF	35.31	35.35	35.2	35.2	40200.0
2001-09-05 18:00:00	QQQ	ETF	35.32	35.4	35.27	35.36	13500.0
2001-09-05 09:00: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.16	46.315	15200.0
2001-09-05 11:00:00	IWM	ETF	46.315	46.37	46.055	46.325	10400.0
2001-09-05 12:00:00	IWM	ETF	46.25	46.25	46.0	46.1	214000.0
2001-09-05 13:00:00	IWM	ETF	46.065	46.065	45.7	45.99	39800.0
2001-09-05 14:00:00	IWM	ETF	46.095	46.305	46.0	46.295	25400.0
2001-09-05 15:00:00	IWM	ETF	46.15	46.225	45.905	46.14	42000.0
2001-09-05 16:00:00	IWM	ETF	46.175	46.175	46.175	46.175	600.0
2001-09-05 09:00: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.24	651300.0
2001-09-05 11:00:00	DIA	ETF	100.26	100.42	99.86	100.0	437200.0
2001-09-05 12:00:00	DIA	ETF	100.0	100.14	99.68	99.68	530700.0
2001-09-05 13:00:00	DIA	ETF	99.66	99.87	99.01	99.86	1113300.0
2001-09-05 14:00:00	DIA	ETF	99.89	100.95	99.63	100.38	1522200.0
2001-09-05 15:00:00	DIA	ETF	100.36	100.71	99.9	100.46	1064600.0
2001-09-05 16:00:00	DIA	ETF	100.47	100.56	100.43	100.44	227000.0

> showing 35 of 251 rows — these rows as CSV

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