PREVIEW / etf_1hour / 2003-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-03-28.parquet
  size:    15 KB
  rows:    361

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
2003-03-28 08:00:00	SPY	ETF	86.78	86.78	86.53	86.53	59100.0
2003-03-28 09:00:00	SPY	ETF	86.53	86.82	86.28	86.62	6064800.0
2003-03-28 10:00:00	SPY	ETF	86.64	87.05	86.4	86.92	5158000.0
2003-03-28 11:00:00	SPY	ETF	86.95	87.28	86.86	86.9	3541800.0
2003-03-28 12:00:00	SPY	ETF	86.9	86.99	86.52	86.69	2490000.0
2003-03-28 13:00:00	SPY	ETF	86.68	86.92	86.54	86.65	2824900.0
2003-03-28 14:00:00	SPY	ETF	86.67	86.84	86.25	86.56	4627700.0
2003-03-28 15:00:00	SPY	ETF	86.55	86.75	86.38	86.59	3829300.0
2003-03-28 16:00:00	SPY	ETF	86.59	86.73	86.41	86.48	1749100.0
2003-03-28 17:00:00	SPY	ETF	86.49	86.65	86.3	86.32	34200.0
2003-03-28 18:00:00	SPY	ETF	86.34	86.45	86.26	86.32	6400.0
2003-03-28 19:00:00	SPY	ETF	86.33	86.37	86.3	86.3	3400.0
2003-03-28 08:00:00	QQQ	ETF	26.26	26.26	26.18	26.19	72400.0
2003-03-28 09:00:00	QQQ	ETF	26.18	26.34	26.09	26.25	5752200.0
2003-03-28 10:00:00	QQQ	ETF	26.24	26.38	26.12	26.35	6090900.0
2003-03-28 11:00:00	QQQ	ETF	26.33	26.43	26.23	26.25	4607100.0
2003-03-28 12:00:00	QQQ	ETF	26.26	26.3	26.13	26.17	3670400.0
2003-03-28 13:00:00	QQQ	ETF	26.18	26.23	26.14	26.18	3380900.0
2003-03-28 14:00:00	QQQ	ETF	26.18	26.25	25.95	26.06	9223000.0
2003-03-28 15:00:00	QQQ	ETF	26.06	26.15	25.98	26.03	7277100.0
2003-03-28 16:00:00	QQQ	ETF	26.03	26.34	25.93	26.0	1838300.0
2003-03-28 17:00:00	QQQ	ETF	26.02	26.07	25.98	25.98	67800.0
2003-03-28 18:00:00	QQQ	ETF	26.0	26.03	25.97	25.99	18200.0
2003-03-28 19:00:00	QQQ	ETF	26.0	26.0	25.92	25.97	17900.0
2003-03-28 09:00:00	IWM	ETF	36.595	36.815	36.595	36.735	258400.0
2003-03-28 10:00:00	IWM	ETF	36.775	36.84	36.63	36.825	506800.0
2003-03-28 11:00:00	IWM	ETF	36.845	36.945	36.8	36.85	550200.0
2003-03-28 12:00:00	IWM	ETF	36.885	36.885	36.765	36.795	127600.0
2003-03-28 13:00:00	IWM	ETF	36.795	36.845	36.76	36.81	142600.0
2003-03-28 14:00:00	IWM	ETF	36.81	36.845	36.67	36.765	231800.0
2003-03-28 15:00:00	IWM	ETF	36.755	36.825	36.7	36.755	264600.0
2003-03-28 16:00:00	IWM	ETF	36.73	36.805	36.725	36.75	13200.0
2003-03-28 08:00:00	DIA	ETF	81.6	81.7	81.6	81.64	5200.0
2003-03-28 09:00:00	DIA	ETF	81.58	81.8	81.4	81.55	1129700.0
2003-03-28 10:00:00	DIA	ETF	81.52	81.99	81.4	81.85	1192100.0
2003-03-28 11:00:00	DIA	ETF	81.84	82.15	81.8	81.82	854300.0
2003-03-28 12:00:00	DIA	ETF	81.82	81.89	81.48	81.59	525900.0
2003-03-28 13:00:00	DIA	ETF	81.61	81.78	81.46	81.55	408200.0
2003-03-28 14:00:00	DIA	ETF	81.55	81.72	81.2	81.47	754300.0
2003-03-28 15:00:00	DIA	ETF	81.46	81.63	81.3	81.55	1024900.0
2003-03-28 16:00:00	DIA	ETF	81.52	81.72	81.51	81.58	103400.0
2003-03-28 17:00:00	DIA	ETF	81.5	81.57	81.41	81.41	7100.0
2003-03-28 18:00:00	DIA	ETF	81.35	81.35	81.31	81.31	300.0
2003-03-28 19:00:00	DIA	ETF	81.31	81.32	81.29	81.32	1200.0
2003-03-28 09:00:00	TLT	ETF	87.92	88.04	87.8	87.85	46600.0
2003-03-28 10:00:00	TLT	ETF	87.95	88.01	87.8	87.9	56700.0
2003-03-28 11:00:00	TLT	ETF	87.9	87.99	87.85	87.93	74300.0
2003-03-28 12:00:00	TLT	ETF	88.08	88.08	87.81	87.87	26600.0
2003-03-28 13:00:00	TLT	ETF	87.89	87.89	87.73	87.8	4100.0
2003-03-28 14:00:00	TLT	ETF	87.8	87.88	87.78	87.88	27700.0

> showing 50 of 361 rows — these rows as CSV

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