PREVIEW / etf_1hour / 2001-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-12-05.parquet
  size:    14 KB
  rows:    297

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-12-05 09:00:00	SPY	ETF	115.61	116.3	115.58	116.17	3703500.0
2001-12-05 10:00:00	SPY	ETF	116.24	117.0	116.16	116.74	5489200.0
2001-12-05 11:00:00	SPY	ETF	116.74	117.16	116.64	116.95	2686100.0
2001-12-05 12:00:00	SPY	ETF	116.97	117.48	116.91	117.09	2706500.0
2001-12-05 13:00:00	SPY	ETF	117.1	117.34	116.91	117.06	1710500.0
2001-12-05 14:00:00	SPY	ETF	117.02	117.6	116.8	117.51	2837800.0
2001-12-05 15:00:00	SPY	ETF	117.55	118.0	117.47	117.64	4204800.0
2001-12-05 16:00:00	SPY	ETF	117.74	117.78	116.96	117.38	1800200.0
2001-12-05 17:00:00	SPY	ETF	117.35	117.43	117.35	117.43	2400.0
2001-12-05 09:00:00	QQQ	ETF	41.2	41.75	41.12	41.69	15910600.0
2001-12-05 10:00:00	QQQ	ETF	41.7	42.3	41.67	42.04	24682000.0
2001-12-05 11:00:00	QQQ	ETF	42.05	42.47	42.04	42.23	12902000.0
2001-12-05 12:00:00	QQQ	ETF	42.24	42.63	42.23	42.46	10605700.0
2001-12-05 13:00:00	QQQ	ETF	42.45	42.67	42.34	42.44	8611200.0
2001-12-05 14:00:00	QQQ	ETF	42.41	42.87	42.18	42.8	14511600.0
2001-12-05 15:00:00	QQQ	ETF	42.76	43.15	42.59	42.8	23071500.0
2001-12-05 16:00:00	QQQ	ETF	42.8	43.05	42.55	42.73	3903600.0
2001-12-05 17:00:00	QQQ	ETF	42.73	42.82	42.71	42.73	79300.0
2001-12-05 18:00:00	QQQ	ETF	42.75	42.79	42.71	42.72	43800.0
2001-12-05 09:00:00	IWM	ETF	47.05	47.35	46.9	47.35	75800.0
2001-12-05 10:00:00	IWM	ETF	47.325	47.645	47.275	47.565	66800.0
2001-12-05 11:00:00	IWM	ETF	47.54	47.62	47.38	47.595	42200.0
2001-12-05 12:00:00	IWM	ETF	47.62	47.82	47.6	47.745	127800.0
2001-12-05 13:00:00	IWM	ETF	47.79	47.82	47.625	47.7	5400.0
2001-12-05 14:00:00	IWM	ETF	47.55	47.875	47.55	47.85	18600.0
2001-12-05 15:00:00	IWM	ETF	47.85	47.99	47.645	47.775	213400.0
2001-12-05 16:00:00	IWM	ETF	47.775	47.795	47.575	47.575	43200.0
2001-12-05 09:00:00	DIA	ETF	99.73	100.14	99.6	100.05	516900.0
2001-12-05 10:00:00	DIA	ETF	100.03	100.88	100.03	100.62	680400.0
2001-12-05 11:00:00	DIA	ETF	100.62	100.98	100.55	100.8	459800.0
2001-12-05 12:00:00	DIA	ETF	100.79	101.25	100.78	100.94	302200.0
2001-12-05 13:00:00	DIA	ETF	100.94	101.08	100.75	100.84	138100.0
2001-12-05 14:00:00	DIA	ETF	100.8	101.5	100.66	101.5	293900.0
2001-12-05 15:00:00	DIA	ETF	101.4	101.7	101.37	101.48	471600.0
2001-12-05 16:00:00	DIA	ETF	101.48	101.55	101.2	101.3	74900.0
2001-12-05 17:00:00	DIA	ETF	101.18	101.18	101.18	101.18	200.0

> showing 36 of 297 rows — these rows as CSV

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