PREVIEW / etf_1hour / 2003-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-23.parquet
  size:    17 KB
  rows:    433

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-09-23 08:00:00	SPY	ETF	102.78	102.94	102.66	102.66	91300.0
2003-09-23 09:00:00	SPY	ETF	102.65	102.91	102.43	102.84	4383900.0
2003-09-23 10:00:00	SPY	ETF	102.82	103.0	102.58	102.6	4299800.0
2003-09-23 11:00:00	SPY	ETF	102.59	102.64	102.36	102.6	5383300.0
2003-09-23 12:00:00	SPY	ETF	102.6	102.79	102.58	102.67	1750600.0
2003-09-23 13:00:00	SPY	ETF	102.67	102.94	102.58	102.78	2964300.0
2003-09-23 14:00:00	SPY	ETF	102.77	103.02	102.68	102.98	2539400.0
2003-09-23 15:00:00	SPY	ETF	102.99	103.29	102.99	103.09	4047500.0
2003-09-23 16:00:00	SPY	ETF	103.1	103.1	102.94	103.01	1816400.0
2003-09-23 17:00:00	SPY	ETF	103.02	103.03	102.94	102.98	27600.0
2003-09-23 18:00:00	SPY	ETF	102.95	103.0	102.95	102.99	500.0
2003-09-23 19:00:00	SPY	ETF	102.97	103.0	102.97	103.0	900.0
2003-09-23 08:00:00	QQQ	ETF	33.99	34.08	33.97	34.0	216200.0
2003-09-23 09:00:00	QQQ	ETF	34.0	34.23	33.91	34.16	9358000.0
2003-09-23 10:00:00	QQQ	ETF	34.15	34.33	34.12	34.17	12150600.0
2003-09-23 11:00:00	QQQ	ETF	34.17	34.21	33.97	34.09	10705900.0
2003-09-23 12:00:00	QQQ	ETF	34.086	34.21	34.07	34.19	5016700.0
2003-09-23 13:00:00	QQQ	ETF	34.18	34.33	34.12	34.22	6175300.0
2003-09-23 14:00:00	QQQ	ETF	34.22	34.4	34.19	34.38	7560800.0
2003-09-23 15:00:00	QQQ	ETF	34.37	34.56	34.35	34.469	13781100.0
2003-09-23 16:00:00	QQQ	ETF	34.46	34.57	34.44	34.569	2683200.0
2003-09-23 17:00:00	QQQ	ETF	34.56	34.569	34.49	34.5	90600.0
2003-09-23 18:00:00	QQQ	ETF	34.5	34.52	34.49	34.5	7400.0
2003-09-23 19:00:00	QQQ	ETF	34.5	34.55	34.49	34.53	18100.0
2003-09-23 09:00:00	IWM	ETF	51.15	51.475	51.15	51.45	857000.0
2003-09-23 10:00:00	IWM	ETF	51.47	51.695	51.455	51.495	778600.0
2003-09-23 11:00:00	IWM	ETF	51.495	51.525	51.355	51.425	774800.0
2003-09-23 12:00:00	IWM	ETF	51.44	51.525	51.425	51.475	184400.0
2003-09-23 13:00:00	IWM	ETF	51.46	51.6	51.46	51.58	510400.0
2003-09-23 14:00:00	IWM	ETF	51.565	51.74	51.5	51.74	385600.0
2003-09-23 15:00:00	IWM	ETF	51.745	51.785	51.66	51.72	587800.0
2003-09-23 16:00:00	IWM	ETF	51.74	51.775	51.74	51.765	118600.0
2003-09-23 18:00:00	IWM	ETF	51.845	51.845	51.845	51.845	200.0
2003-09-23 08:00:00	DIA	ETF	95.8	95.8	95.74	95.74	2200.0
2003-09-23 09:00:00	DIA	ETF	95.57	95.85	95.4	95.75	566100.0
2003-09-23 10:00:00	DIA	ETF	95.71	95.88	95.46	95.47	1060900.0
2003-09-23 11:00:00	DIA	ETF	95.46	95.48	95.16	95.38	1185800.0
2003-09-23 12:00:00	DIA	ETF	95.38	95.6	95.35	95.53	350700.0
2003-09-23 13:00:00	DIA	ETF	95.47	95.7	95.41	95.51	244100.0
2003-09-23 14:00:00	DIA	ETF	95.51	95.76	95.45	95.68	454200.0
2003-09-23 15:00:00	DIA	ETF	95.69	95.97	95.69	95.81	671800.0
2003-09-23 16:00:00	DIA	ETF	95.8	95.81	95.73	95.78	201900.0
2003-09-23 17:00:00	DIA	ETF	95.78	95.78	95.75	95.75	1400.0
2003-09-23 18:00:00	DIA	ETF	95.7	95.7	95.62	95.62	2100.0
2003-09-23 09:00:00	TLT	ETF	84.88	84.95	84.7	84.71	73900.0
2003-09-23 10:00:00	TLT	ETF	84.73	85.016	84.64	85.016	39900.0
2003-09-23 11:00:00	TLT	ETF	85.0	85.163	84.97	85.041	132000.0
2003-09-23 12:00:00	TLT	ETF	85.05	85.15	84.9	84.9	55500.0
2003-09-23 13:00:00	TLT	ETF	84.992	85.29	84.95	85.16	74000.0
2003-09-23 14:00:00	TLT	ETF	85.19	85.47	85.122	85.4	94800.0

> showing 50 of 433 rows — these rows as CSV

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