PREVIEW / etf_1hour / 2004-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-17.parquet
  size:    24 KB
  rows:    683

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
2004-09-17 08:00:00	SPY	ETF	112.97	113.05	112.88	112.95	117300.0
2004-09-17 09:00:00	SPY	ETF	112.96	113.09	112.81	112.87	4958900.0
2004-09-17 10:00:00	SPY	ETF	112.87	113.36	112.69	113.3	8245200.0
2004-09-17 11:00:00	SPY	ETF	113.3	113.32	113.09	113.13	3679700.0
2004-09-17 12:00:00	SPY	ETF	113.13	113.24	113.02	113.16	1713500.0
2004-09-17 13:00:00	SPY	ETF	113.15	113.17	112.87	113.01	2890900.0
2004-09-17 14:00:00	SPY	ETF	113.02	113.27	112.9	113.21	2877600.0
2004-09-17 15:00:00	SPY	ETF	113.22	113.24	112.96	113.11	3645500.0
2004-09-17 16:00:00	SPY	ETF	113.11	113.15	112.98	113.1	1867100.0
2004-09-17 17:00:00	SPY	ETF	113.12	113.15	113.12	113.15	191100.0
2004-09-17 18:00:00	SPY	ETF	113.08	113.14	113.08	113.14	900.0
2004-09-17 08:00:00	QQQ	ETF	35.36	35.42	35.33	35.38	179700.0
2004-09-17 09:00:00	QQQ	ETF	35.38	35.42	35.18	35.223	13196000.0
2004-09-17 10:00:00	QQQ	ETF	35.222	35.52	35.16	35.49	18355100.0
2004-09-17 11:00:00	QQQ	ETF	35.49	35.492	35.35	35.43	10174100.0
2004-09-17 12:00:00	QQQ	ETF	35.429	35.44	35.37	35.391	4759400.0
2004-09-17 13:00:00	QQQ	ETF	35.39	35.41	35.3	35.36	6484900.0
2004-09-17 14:00:00	QQQ	ETF	35.369	35.5	35.34	35.46	8344500.0
2004-09-17 15:00:00	QQQ	ETF	35.45	35.48	35.37	35.45	16580600.0
2004-09-17 16:00:00	QQQ	ETF	35.45	35.49	35.398	35.43	4239900.0
2004-09-17 17:00:00	QQQ	ETF	35.43	35.45	35.43	35.43	29400.0
2004-09-17 18:00:00	QQQ	ETF	35.43	35.43	35.43	35.43	5300.0
2004-09-17 08:00:00	IWM	ETF	57.48	57.49	57.48	57.49	1600.0
2004-09-17 09:00:00	IWM	ETF	57.445	57.445	56.885	56.89	1611600.0
2004-09-17 10:00:00	IWM	ETF	56.89	57.29	56.775	57.265	3117800.0
2004-09-17 11:00:00	IWM	ETF	57.265	57.305	57.16	57.255	958800.0
2004-09-17 12:00:00	IWM	ETF	57.26	57.29	57.18	57.18	1514600.0
2004-09-17 13:00:00	IWM	ETF	57.15	57.255	57.07	57.225	1514000.0
2004-09-17 14:00:00	IWM	ETF	57.225	57.27	57.06	57.22	1010800.0
2004-09-17 15:00:00	IWM	ETF	57.24	57.25	57.07	57.11	1645200.0
2004-09-17 16:00:00	IWM	ETF	57.115	57.215	57.05	57.05	638200.0
2004-09-17 18:00:00	IWM	ETF	57.325	57.325	57.325	57.325	1400.0
2004-09-17 08:00:00	DIA	ETF	102.89	102.91	102.8	102.86	3900.0
2004-09-17 09:00:00	DIA	ETF	102.9	102.99	102.76	102.84	854300.0
2004-09-17 10:00:00	DIA	ETF	102.84	103.3	102.69	103.24	1080300.0
2004-09-17 11:00:00	DIA	ETF	103.27	103.28	103.02	103.06	362500.0
2004-09-17 12:00:00	DIA	ETF	103.06	103.14	102.96	103.06	187100.0
2004-09-17 13:00:00	DIA	ETF	103.04	103.08	102.82	102.89	612000.0
2004-09-17 14:00:00	DIA	ETF	102.89	103.06	102.76	103.01	330800.0
2004-09-17 15:00:00	DIA	ETF	103.03	103.04	102.82	103.0	780900.0
2004-09-17 16:00:00	DIA	ETF	103.0	103.03	102.95	103.01	96000.0
2004-09-17 17:00:00	DIA	ETF	103.01	103.01	103.01	103.01	100.0
2004-09-17 18:00:00	DIA	ETF	103.0	103.0	103.0	103.0	200.0
2004-09-17 19:00:00	DIA	ETF	103.0	103.0	103.0	103.0	100.0
2004-09-17 08:00:00	TLT	ETF	88.42	88.42	88.29	88.29	3900.0
2004-09-17 09:00:00	TLT	ETF	88.3	88.39	88.08	88.08	47400.0
2004-09-17 10:00:00	TLT	ETF	88.13	88.18	87.96	87.96	43100.0
2004-09-17 11:00:00	TLT	ETF	87.95	88.06	87.91	88.04	318600.0
2004-09-17 12:00:00	TLT	ETF	88.07	88.11	88.0	88.06	10500.0
2004-09-17 13:00:00	TLT	ETF	88.06	88.09	88.01	88.09	33200.0

> showing 50 of 683 rows — these rows as CSV

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