PREVIEW / etf_1hour / 2003-05-29

all etf 1-hour files

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

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-29 08:00:00	SPY	ETF	95.86	96.11	95.82	96.03	196400.0
2003-05-29 09:00:00	SPY	ETF	96.05	96.52	95.7	96.42	5091700.0
2003-05-29 10:00:00	SPY	ETF	96.41	96.74	96.2	96.39	7783400.0
2003-05-29 11:00:00	SPY	ETF	96.37	96.66	96.32	96.55	3958000.0
2003-05-29 12:00:00	SPY	ETF	96.55	96.64	95.94	95.98	4832100.0
2003-05-29 13:00:00	SPY	ETF	95.98	96.06	95.27	95.5	8505200.0
2003-05-29 14:00:00	SPY	ETF	95.48	95.92	95.43	95.68	8095200.0
2003-05-29 15:00:00	SPY	ETF	95.62	95.68	95.08	95.37	8413100.0
2003-05-29 16:00:00	SPY	ETF	95.37	95.5	95.27	95.4	1508400.0
2003-05-29 17:00:00	SPY	ETF	95.46	96.55	95.32	95.42	140500.0
2003-05-29 18:00:00	SPY	ETF	95.42	95.45	95.39	95.45	18600.0
2003-05-29 19:00:00	SPY	ETF	95.45	95.49	95.45	95.49	2300.0
2003-05-29 08:00:00	QQQ	ETF	29.16	29.31	29.15	29.27	75500.0
2003-05-29 09:00:00	QQQ	ETF	29.27	29.46	29.16	29.43	8499300.0
2003-05-29 10:00:00	QQQ	ETF	29.45	29.77	29.32	29.63	21091500.0
2003-05-29 11:00:00	QQQ	ETF	29.63	29.78	29.62	29.75	10748000.0
2003-05-29 12:00:00	QQQ	ETF	29.74	29.8	29.45	29.5	11479400.0
2003-05-29 13:00:00	QQQ	ETF	29.5	29.53	29.22	29.43	16088000.0
2003-05-29 14:00:00	QQQ	ETF	29.43	29.59	29.4	29.46	9029800.0
2003-05-29 15:00:00	QQQ	ETF	29.48	29.48	29.25	29.33	11877100.0
2003-05-29 16:00:00	QQQ	ETF	29.32	29.36	29.26	29.3	1587900.0
2003-05-29 17:00:00	QQQ	ETF	29.29	29.37	29.26	29.3	435800.0
2003-05-29 18:00:00	QQQ	ETF	29.31	29.32	29.3	29.3	26100.0
2003-05-29 19:00:00	QQQ	ETF	29.3	29.35	29.3	29.35	5900.0
2003-05-29 09:00:00	IWM	ETF	43.185	43.285	43.05	43.285	542000.0
2003-05-29 10:00:00	IWM	ETF	43.275	43.485	43.225	43.365	556000.0
2003-05-29 11:00:00	IWM	ETF	43.345	43.425	43.335	43.405	193400.0
2003-05-29 12:00:00	IWM	ETF	43.415	43.415	43.185	43.205	173800.0
2003-05-29 13:00:00	IWM	ETF	43.185	43.185	42.875	42.93	653000.0
2003-05-29 14:00:00	IWM	ETF	42.935	43.09	42.92	43.02	316200.0
2003-05-29 15:00:00	IWM	ETF	43.0	43.18	42.88	43.18	543400.0
2003-05-29 16:00:00	IWM	ETF	43.18	43.315	43.18	43.245	339600.0
2003-05-29 08:00:00	DIA	ETF	88.2	88.48	88.2	88.34	19700.0
2003-05-29 09:00:00	DIA	ETF	88.34	88.74	88.01	88.7	1302200.0
2003-05-29 10:00:00	DIA	ETF	88.68	88.9	88.51	88.55	1487100.0
2003-05-29 11:00:00	DIA	ETF	88.56	88.75	88.48	88.63	592200.0
2003-05-29 12:00:00	DIA	ETF	88.63	88.67	88.05	88.11	764400.0
2003-05-29 13:00:00	DIA	ETF	88.05	88.14	87.4	87.64	1315100.0
2003-05-29 14:00:00	DIA	ETF	87.62	87.9	87.58	87.62	747300.0
2003-05-29 15:00:00	DIA	ETF	87.58	87.62	87.05	87.35	1648100.0
2003-05-29 16:00:00	DIA	ETF	87.35	87.46	87.3	87.4	74100.0
2003-05-29 17:00:00	DIA	ETF	87.44	87.45	87.31	87.43	2100.0
2003-05-29 18:00:00	DIA	ETF	87.48	87.48	87.43	87.45	6200.0
2003-05-29 19:00:00	DIA	ETF	87.44	87.47	87.4	87.4	2400.0
2003-05-29 09:00:00	TLT	ETF	94.3	94.45	94.19	94.3	84400.0
2003-05-29 10:00:00	TLT	ETF	94.35	94.44	94.18	94.31	102400.0
2003-05-29 11:00:00	TLT	ETF	94.31	94.45	94.31	94.43	35500.0
2003-05-29 12:00:00	TLT	ETF	94.5	94.78	94.5	94.78	64800.0
2003-05-29 13:00:00	TLT	ETF	94.68	94.75	94.5	94.5	64700.0
2003-05-29 14:00:00	TLT	ETF	94.51	94.79	94.47	94.79	63900.0

> showing 50 of 427 rows — these rows as CSV

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