PREVIEW / etf_1hour / 2003-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-28.parquet
  size:    17 KB
  rows:    415

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-05-28 08:00:00	SPY	ETF	95.98	96.05	95.77	95.85	146700.0
2003-05-28 09:00:00	SPY	ETF	95.85	96.14	95.59	96.14	4118600.0
2003-05-28 10:00:00	SPY	ETF	96.13	96.17	95.43	96.1	7625200.0
2003-05-28 11:00:00	SPY	ETF	96.12	96.47	96.03	96.4	5607000.0
2003-05-28 12:00:00	SPY	ETF	96.37	96.4	95.83	95.9	3243800.0
2003-05-28 13:00:00	SPY	ETF	95.9	96.04	95.63	95.78	3344800.0
2003-05-28 14:00:00	SPY	ETF	95.78	96.01	95.53	95.73	4050400.0
2003-05-28 15:00:00	SPY	ETF	95.74	96.1	95.73	95.82	3407900.0
2003-05-28 16:00:00	SPY	ETF	95.81	95.83	95.61	95.65	1417800.0
2003-05-28 17:00:00	SPY	ETF	95.63	95.65	95.55	95.59	118500.0
2003-05-28 18:00:00	SPY	ETF	95.56	95.62	95.56	95.62	2600.0
2003-05-28 19:00:00	SPY	ETF	95.64	95.65	95.58	95.58	2200.0
2003-05-28 08:00:00	QQQ	ETF	29.34	29.39	29.27	29.31	268900.0
2003-05-28 09:00:00	QQQ	ETF	29.29	29.32	29.11	29.27	11707800.0
2003-05-28 10:00:00	QQQ	ETF	29.28	29.29	28.96	29.28	14483700.0
2003-05-28 11:00:00	QQQ	ETF	29.28	29.4	29.24	29.35	9858000.0
2003-05-28 12:00:00	QQQ	ETF	29.35	29.36	29.11	29.16	6703500.0
2003-05-28 13:00:00	QQQ	ETF	29.15	29.19	29.02	29.11	7590200.0
2003-05-28 14:00:00	QQQ	ETF	29.1	29.21	29.04	29.14	7584900.0
2003-05-28 15:00:00	QQQ	ETF	29.12	29.29	29.12	29.17	10311900.0
2003-05-28 16:00:00	QQQ	ETF	29.17	29.2	29.11	29.15	1684000.0
2003-05-28 17:00:00	QQQ	ETF	29.15	29.15	29.07	29.11	306900.0
2003-05-28 18:00:00	QQQ	ETF	29.11	29.12	29.08	29.1	66100.0
2003-05-28 19:00:00	QQQ	ETF	29.09	29.15	29.09	29.15	16000.0
2003-05-28 09:00:00	IWM	ETF	42.8	43.1	42.8	43.03	414600.0
2003-05-28 10:00:00	IWM	ETF	43.025	43.025	42.805	42.955	385200.0
2003-05-28 11:00:00	IWM	ETF	42.97	43.075	42.93	43.035	53600.0
2003-05-28 12:00:00	IWM	ETF	43.03	43.04	42.95	42.96	82400.0
2003-05-28 13:00:00	IWM	ETF	42.965	42.985	42.87	42.895	216200.0
2003-05-28 14:00:00	IWM	ETF	42.895	42.955	42.84	42.905	106600.0
2003-05-28 15:00:00	IWM	ETF	42.915	43.06	42.915	42.995	290600.0
2003-05-28 16:00:00	IWM	ETF	42.985	42.985	42.925	42.945	51400.0
2003-05-28 08:00:00	DIA	ETF	88.44	88.45	88.02	88.17	25900.0
2003-05-28 09:00:00	DIA	ETF	88.21	88.48	88.02	88.46	1064700.0
2003-05-28 10:00:00	DIA	ETF	88.43	88.54	87.91	88.47	1339400.0
2003-05-28 11:00:00	DIA	ETF	88.5	88.75	88.33	88.69	729600.0
2003-05-28 12:00:00	DIA	ETF	88.7	88.71	88.16	88.25	604800.0
2003-05-28 13:00:00	DIA	ETF	88.21	88.32	88.0	88.12	647700.0
2003-05-28 14:00:00	DIA	ETF	88.09	88.26	87.94	88.06	546100.0
2003-05-28 15:00:00	DIA	ETF	88.06	88.36	88.03	88.15	639700.0
2003-05-28 16:00:00	DIA	ETF	88.11	88.15	87.97	87.99	80900.0
2003-05-28 17:00:00	DIA	ETF	87.98	87.98	87.91	87.92	2700.0
2003-05-28 18:00:00	DIA	ETF	87.95	87.97	87.95	87.97	700.0
2003-05-28 19:00:00	DIA	ETF	87.92	87.92	87.92	87.92	100.0
2003-05-28 09:00:00	TLT	ETF	93.9	93.95	93.65	93.66	175300.0
2003-05-28 10:00:00	TLT	ETF	93.7	93.86	93.32	93.4	226500.0
2003-05-28 11:00:00	TLT	ETF	93.4	93.57	93.31	93.41	94100.0
2003-05-28 12:00:00	TLT	ETF	93.47	93.8	93.4	93.73	48400.0
2003-05-28 13:00:00	TLT	ETF	93.8	94.07	93.8	93.97	71900.0
2003-05-28 14:00:00	TLT	ETF	94.03	94.03	93.91	93.99	43400.0

> showing 50 of 415 rows — these rows as CSV

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