PREVIEW / etf_1hour / 2003-05-05

all etf 1-hour files

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

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-05 08:00:00	SPY	ETF	93.57	93.63	93.51	93.61	59700.0
2003-05-05 09:00:00	SPY	ETF	93.62	93.7	93.13	93.42	5464500.0
2003-05-05 10:00:00	SPY	ETF	93.42	93.78	92.87	92.89	8272000.0
2003-05-05 11:00:00	SPY	ETF	92.96	93.23	92.77	93.16	4872800.0
2003-05-05 12:00:00	SPY	ETF	93.17	93.45	93.02	93.36	1804800.0
2003-05-05 13:00:00	SPY	ETF	93.34	93.59	93.24	93.34	2011600.0
2003-05-05 14:00:00	SPY	ETF	93.32	93.35	92.85	92.85	3729200.0
2003-05-05 15:00:00	SPY	ETF	92.86	93.24	92.82	92.96	3738000.0
2003-05-05 16:00:00	SPY	ETF	92.94	93.09	92.92	93.01	1051300.0
2003-05-05 17:00:00	SPY	ETF	93.0	93.0	92.95	92.97	11900.0
2003-05-05 18:00:00	SPY	ETF	92.97	92.99	92.9	92.9	10800.0
2003-05-05 08:00:00	QQQ	ETF	28.41	28.44	28.39	28.41	93800.0
2003-05-05 09:00:00	QQQ	ETF	28.4	28.45	28.17	28.38	11657800.0
2003-05-05 10:00:00	QQQ	ETF	28.39	28.67	28.3	28.38	22684500.0
2003-05-05 11:00:00	QQQ	ETF	28.39	28.56	28.29	28.5	8394700.0
2003-05-05 12:00:00	QQQ	ETF	28.47	28.61	28.41	28.56	3950700.0
2003-05-05 13:00:00	QQQ	ETF	28.58	28.71	28.49	28.51	5721000.0
2003-05-05 14:00:00	QQQ	ETF	28.52	28.52	28.23	28.25	7367700.0
2003-05-05 15:00:00	QQQ	ETF	28.25	28.45	28.21	28.24	8921300.0
2003-05-05 16:00:00	QQQ	ETF	28.24	28.39	28.22	28.24	884000.0
2003-05-05 17:00:00	QQQ	ETF	28.24	28.26	28.23	28.24	149700.0
2003-05-05 18:00:00	QQQ	ETF	28.24	28.26	28.22	28.24	56700.0
2003-05-05 19:00:00	QQQ	ETF	28.24	28.26	28.23	28.25	9700.0
2003-05-05 09:00:00	IWM	ETF	40.765	40.92	40.725	40.885	295200.0
2003-05-05 10:00:00	IWM	ETF	40.8	40.915	40.65	40.65	607000.0
2003-05-05 11:00:00	IWM	ETF	40.685	40.775	40.63	40.755	329800.0
2003-05-05 12:00:00	IWM	ETF	40.77	40.84	40.725	40.81	319000.0
2003-05-05 13:00:00	IWM	ETF	40.81	40.87	40.795	40.8	608400.0
2003-05-05 14:00:00	IWM	ETF	40.795	40.81	40.715	40.715	363000.0
2003-05-05 15:00:00	IWM	ETF	40.735	40.89	40.71	40.83	404800.0
2003-05-05 16:00:00	IWM	ETF	40.81	40.915	40.64	40.86	533600.0
2003-05-05 08:00:00	DIA	ETF	86.12	86.18	86.01	86.08	12600.0
2003-05-05 09:00:00	DIA	ETF	86.08	86.2	85.55	85.77	1268200.0
2003-05-05 10:00:00	DIA	ETF	85.74	86.19	85.2	85.35	1720100.0
2003-05-05 11:00:00	DIA	ETF	85.35	85.64	85.22	85.54	1010000.0
2003-05-05 12:00:00	DIA	ETF	85.55	85.81	85.4	85.73	583800.0
2003-05-05 13:00:00	DIA	ETF	85.71	85.98	85.59	85.67	660000.0
2003-05-05 14:00:00	DIA	ETF	85.68	85.7	85.25	85.25	738400.0
2003-05-05 15:00:00	DIA	ETF	85.25	85.62	85.22	85.38	899300.0
2003-05-05 16:00:00	DIA	ETF	85.37	85.6	85.34	85.5	79400.0
2003-05-05 17:00:00	DIA	ETF	85.47	85.52	85.47	85.52	3000.0
2003-05-05 18:00:00	DIA	ETF	85.51	85.52	85.5	85.52	5900.0
2003-05-05 19:00:00	DIA	ETF	85.49	85.49	85.49	85.49	200.0
2003-05-05 09:00:00	TLT	ETF	88.33	88.39	88.33	88.34	11800.0
2003-05-05 10:00:00	TLT	ETF	88.28	88.39	88.26	88.35	2400.0
2003-05-05 11:00:00	TLT	ETF	88.4	88.55	88.4	88.45	12500.0
2003-05-05 12:00:00	TLT	ETF	88.46	88.52	88.4	88.5	18300.0
2003-05-05 13:00:00	TLT	ETF	88.42	88.52	88.4	88.4	700.0
2003-05-05 14:00:00	TLT	ETF	88.5	88.75	88.48	88.75	6600.0
2003-05-05 15:00:00	TLT	ETF	88.82	88.86	88.82	88.86	1800.0

> showing 50 of 414 rows — these rows as CSV

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