PREVIEW / etf_1hour / 2003-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-03-25.parquet
  size:    16 KB
  rows:    384

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-25 08:00:00	SPY	ETF	86.75	86.75	86.47	86.59	31700.0
2003-03-25 09:00:00	SPY	ETF	86.6	86.97	86.44	86.94	7431600.0
2003-03-25 10:00:00	SPY	ETF	86.96	87.28	86.47	87.23	8725600.0
2003-03-25 11:00:00	SPY	ETF	87.24	87.82	87.07	87.59	7757000.0
2003-03-25 12:00:00	SPY	ETF	87.6	88.09	87.6	87.95	6199000.0
2003-03-25 13:00:00	SPY	ETF	87.95	88.24	87.81	87.85	7049500.0
2003-03-25 14:00:00	SPY	ETF	87.83	88.2	87.3	87.35	7301300.0
2003-03-25 15:00:00	SPY	ETF	87.32	87.8	87.02	87.67	10236800.0
2003-03-25 16:00:00	SPY	ETF	87.7	87.73	87.43	87.6	1575300.0
2003-03-25 17:00:00	SPY	ETF	87.6	87.75	87.54	87.56	149700.0
2003-03-25 18:00:00	SPY	ETF	87.6	87.61	87.55	87.57	7100.0
2003-03-25 19:00:00	SPY	ETF	87.6	87.67	87.6	87.61	12900.0
2003-03-25 08:00:00	QQQ	ETF	26.16	26.17	26.09	26.1	75100.0
2003-03-25 09:00:00	QQQ	ETF	26.13	26.24	26.06	26.16	8846200.0
2003-03-25 10:00:00	QQQ	ETF	26.15	26.37	26.01	26.33	17047200.0
2003-03-25 11:00:00	QQQ	ETF	26.35	26.55	26.29	26.46	9788100.0
2003-03-25 12:00:00	QQQ	ETF	26.45	26.67	26.44	26.64	8888200.0
2003-03-25 13:00:00	QQQ	ETF	26.63	26.76	26.6	26.62	7206700.0
2003-03-25 14:00:00	QQQ	ETF	26.62	26.76	26.42	26.43	8138000.0
2003-03-25 15:00:00	QQQ	ETF	26.44	26.67	26.13	26.51	9688200.0
2003-03-25 16:00:00	QQQ	ETF	26.51	26.54	26.41	26.45	2272300.0
2003-03-25 17:00:00	QQQ	ETF	26.45	26.51	26.45	26.51	44200.0
2003-03-25 18:00:00	QQQ	ETF	26.5	26.53	26.49	26.5	37600.0
2003-03-25 19:00:00	QQQ	ETF	26.5	26.51	26.48	26.51	18500.0
2003-03-25 09:00:00	IWM	ETF	36.56	36.67	36.5	36.615	105600.0
2003-03-25 10:00:00	IWM	ETF	36.695	36.9	36.545	36.9	355800.0
2003-03-25 11:00:00	IWM	ETF	36.86	37.015	36.82	36.965	263800.0
2003-03-25 12:00:00	IWM	ETF	36.98	37.075	36.96	37.065	188800.0
2003-03-25 13:00:00	IWM	ETF	37.065	37.125	37.005	37.025	265000.0
2003-03-25 14:00:00	IWM	ETF	37.035	37.12	36.84	36.84	244000.0
2003-03-25 15:00:00	IWM	ETF	36.835	37.05	36.75	37.035	983200.0
2003-03-25 16:00:00	IWM	ETF	37.0	37.0	36.975	36.975	15800.0
2003-03-25 08:00:00	DIA	ETF	82.2	82.23	82.05	82.11	16000.0
2003-03-25 09:00:00	DIA	ETF	82.14	82.48	82.0	82.37	1391300.0
2003-03-25 10:00:00	DIA	ETF	82.43	82.59	81.85	82.54	1807700.0
2003-03-25 11:00:00	DIA	ETF	82.53	83.11	82.43	82.88	1749200.0
2003-03-25 12:00:00	DIA	ETF	82.83	83.35	82.83	83.25	1372900.0
2003-03-25 13:00:00	DIA	ETF	83.23	83.49	83.16	83.16	1255800.0
2003-03-25 14:00:00	DIA	ETF	83.22	83.47	82.61	82.66	1387000.0
2003-03-25 15:00:00	DIA	ETF	82.68	83.06	82.36	82.94	1900700.0
2003-03-25 16:00:00	DIA	ETF	82.93	82.98	82.77	82.88	150400.0
2003-03-25 17:00:00	DIA	ETF	82.84	82.9	82.77	82.77	1600.0
2003-03-25 18:00:00	DIA	ETF	82.87	82.9	82.81	82.9	10300.0
2003-03-25 19:00:00	DIA	ETF	82.94	82.94	82.93	82.94	700.0
2003-03-25 09:00:00	TLT	ETF	87.65	87.65	87.52	87.6	33800.0
2003-03-25 10:00:00	TLT	ETF	87.63	87.82	87.55	87.6	67600.0
2003-03-25 11:00:00	TLT	ETF	87.54	87.58	87.3	87.45	45800.0
2003-03-25 12:00:00	TLT	ETF	87.46	87.46	87.13	87.18	90300.0
2003-03-25 13:00:00	TLT	ETF	87.18	87.18	86.9	86.96	162800.0
2003-03-25 14:00:00	TLT	ETF	87.07	87.27	87.07	87.27	104400.0

> showing 50 of 384 rows — these rows as CSV

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