PREVIEW / etf_1hour / 2003-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-23.parquet
  size:    17 KB
  rows:    402

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-04-23 08:00:00	SPY	ETF	91.76	91.81	91.49	91.51	42100.0
2003-04-23 09:00:00	SPY	ETF	91.46	91.85	91.4	91.76	5922200.0
2003-04-23 10:00:00	SPY	ETF	91.77	91.87	91.24	91.66	8274300.0
2003-04-23 11:00:00	SPY	ETF	91.66	91.88	91.45	91.86	3943500.0
2003-04-23 12:00:00	SPY	ETF	91.85	92.3	91.75	92.23	5808100.0
2003-04-23 13:00:00	SPY	ETF	92.24	92.3	91.64	91.72	4242500.0
2003-04-23 14:00:00	SPY	ETF	91.72	92.2	91.54	92.09	4645300.0
2003-04-23 15:00:00	SPY	ETF	92.12	92.33	91.92	92.2	5711200.0
2003-04-23 16:00:00	SPY	ETF	92.19	92.35	92.1	92.16	1932700.0
2003-04-23 17:00:00	SPY	ETF	92.17	92.18	92.05	92.05	58700.0
2003-04-23 18:00:00	SPY	ETF	92.08	92.08	92.03	92.03	3600.0
2003-04-23 19:00:00	SPY	ETF	92.04	92.13	92.0	92.06	3500.0
2003-04-23 08:00:00	QQQ	ETF	27.56	27.59	27.5	27.5	180200.0
2003-04-23 09:00:00	QQQ	ETF	27.51	27.53	27.31	27.49	11160400.0
2003-04-23 10:00:00	QQQ	ETF	27.49	27.57	27.26	27.49	12401900.0
2003-04-23 11:00:00	QQQ	ETF	27.5	27.6	27.4	27.59	8763500.0
2003-04-23 12:00:00	QQQ	ETF	27.59	27.75	27.57	27.72	6243600.0
2003-04-23 13:00:00	QQQ	ETF	27.72	27.73	27.38	27.46	7713700.0
2003-04-23 14:00:00	QQQ	ETF	27.47	27.65	27.41	27.62	6689000.0
2003-04-23 15:00:00	QQQ	ETF	27.62	27.71	27.54	27.65	8884500.0
2003-04-23 16:00:00	QQQ	ETF	27.67	27.7	27.55	27.66	1532900.0
2003-04-23 17:00:00	QQQ	ETF	27.66	27.68	27.58	27.6	248300.0
2003-04-23 18:00:00	QQQ	ETF	27.62	27.62	27.56	27.58	17200.0
2003-04-23 19:00:00	QQQ	ETF	27.6	27.62	27.58	27.61	10700.0
2003-04-23 09:00:00	IWM	ETF	38.975	39.19	38.975	39.19	524200.0
2003-04-23 10:00:00	IWM	ETF	39.075	39.15	38.985	39.085	405000.0
2003-04-23 11:00:00	IWM	ETF	39.075	39.145	39.02	39.145	313200.0
2003-04-23 12:00:00	IWM	ETF	39.125	39.25	39.125	39.23	146000.0
2003-04-23 13:00:00	IWM	ETF	39.215	39.245	39.07	39.12	312200.0
2003-04-23 14:00:00	IWM	ETF	39.09	39.4	39.085	39.325	175400.0
2003-04-23 15:00:00	IWM	ETF	39.29	39.42	39.28	39.315	147600.0
2003-04-23 16:00:00	IWM	ETF	39.315	39.4	39.315	39.365	124400.0
2003-04-23 08:00:00	DIA	ETF	85.22	85.22	85.06	85.06	8000.0
2003-04-23 09:00:00	DIA	ETF	84.98	85.2	84.85	85.1	955600.0
2003-04-23 10:00:00	DIA	ETF	85.08	85.12	84.58	84.88	1266800.0
2003-04-23 11:00:00	DIA	ETF	84.88	84.99	84.71	84.96	634400.0
2003-04-23 12:00:00	DIA	ETF	84.96	85.42	84.87	85.37	733900.0
2003-04-23 13:00:00	DIA	ETF	85.35	85.37	84.81	84.95	802700.0
2003-04-23 14:00:00	DIA	ETF	84.92	85.28	84.73	85.21	786900.0
2003-04-23 15:00:00	DIA	ETF	85.19	85.37	85.05	85.27	921000.0
2003-04-23 16:00:00	DIA	ETF	85.25	85.4	85.13	85.18	183100.0
2003-04-23 17:00:00	DIA	ETF	85.22	85.22	85.1	85.1	2500.0
2003-04-23 18:00:00	DIA	ETF	85.1	85.1	85.01	85.02	3700.0
2003-04-23 19:00:00	DIA	ETF	85.1	85.14	85.1	85.14	2100.0
2003-04-23 09:00:00	TLT	ETF	87.78	87.78	87.6	87.6	1200.0
2003-04-23 10:00:00	TLT	ETF	87.67	87.94	87.67	87.94	6400.0
2003-04-23 11:00:00	TLT	ETF	87.86	87.86	87.75	87.84	3000.0
2003-04-23 12:00:00	TLT	ETF	87.78	87.78	87.66	87.66	2000.0
2003-04-23 13:00:00	TLT	ETF	87.72	87.99	87.72	87.99	1900.0
2003-04-23 14:00:00	TLT	ETF	87.97	87.98	87.86	87.9	2800.0

> showing 50 of 402 rows — these rows as CSV

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