PREVIEW / etf_1hour / 2004-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-22.parquet
  size:    28 KB
  rows:    802

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-12-22 08:00:00	SPY	ETF	120.52	120.6	120.46	120.46	125500.0
2004-12-22 09:00:00	SPY	ETF	120.47	120.59	120.32	120.42	3503600.0
2004-12-22 10:00:00	SPY	ETF	120.43	121.08	120.37	120.93	6496900.0
2004-12-22 11:00:00	SPY	ETF	120.92	120.98	120.7	120.83	4929000.0
2004-12-22 12:00:00	SPY	ETF	120.83	120.92	120.72	120.9	2684700.0
2004-12-22 13:00:00	SPY	ETF	120.89	120.9	120.55	120.61	2368800.0
2004-12-22 14:00:00	SPY	ETF	120.61	120.78	120.51	120.69	2708900.0
2004-12-22 15:00:00	SPY	ETF	120.68	120.93	120.66	120.91	4084200.0
2004-12-22 16:00:00	SPY	ETF	120.91	120.96	120.66	120.71	3851300.0
2004-12-22 17:00:00	SPY	ETF	120.71	120.74	120.71	120.72	11600.0
2004-12-22 18:00:00	SPY	ETF	120.75	120.77	120.75	120.77	1900.0
2004-12-22 19:00:00	SPY	ETF	120.72	120.72	120.69	120.69	900.0
2004-12-22 08:00:00	QQQ	ETF	39.65	39.7	39.56	39.57	267738.0
2004-12-22 09:00:00	QQQ	ETF	39.57	39.673	39.517	39.569	11654762.0
2004-12-22 10:00:00	QQQ	ETF	39.57	39.93	39.488	39.831	20918725.0
2004-12-22 11:00:00	QQQ	ETF	39.84	39.88	39.68	39.724	11181247.0
2004-12-22 12:00:00	QQQ	ETF	39.724	39.76	39.64	39.729	3682765.0
2004-12-22 13:00:00	QQQ	ETF	39.72	39.73	39.596	39.619	4255370.0
2004-12-22 14:00:00	QQQ	ETF	39.61	39.7	39.61	39.66	7656241.0
2004-12-22 15:00:00	QQQ	ETF	39.667	39.77	39.66	39.75	10842960.0
2004-12-22 16:00:00	QQQ	ETF	39.73	39.75	39.6	39.64	2645394.0
2004-12-22 17:00:00	QQQ	ETF	39.64	39.68	39.63	39.65	269023.0
2004-12-22 18:00:00	QQQ	ETF	39.65	39.653	39.63	39.65	8609.0
2004-12-22 08:00:00	IWM	ETF	64.54	64.54	64.54	64.54	2000.0
2004-12-22 09:00:00	IWM	ETF	64.51	64.72	64.44	64.655	1102400.0
2004-12-22 10:00:00	IWM	ETF	64.655	64.925	64.595	64.875	1748800.0
2004-12-22 11:00:00	IWM	ETF	64.875	64.91	64.645	64.705	810600.0
2004-12-22 12:00:00	IWM	ETF	64.71	64.81	64.675	64.8	635800.0
2004-12-22 13:00:00	IWM	ETF	64.8	64.83	64.725	64.73	286800.0
2004-12-22 14:00:00	IWM	ETF	64.73	64.845	64.72	64.765	399000.0
2004-12-22 15:00:00	IWM	ETF	64.765	64.84	64.725	64.82	1477200.0
2004-12-22 16:00:00	IWM	ETF	64.8	64.805	64.63	64.7	274000.0
2004-12-22 17:00:00	IWM	ETF	64.7744	64.7744	64.7744	64.7744	8800.0
2004-12-22 18:00:00	IWM	ETF	64.69	64.69	64.69	64.69	400.0
2004-12-22 08:00:00	DIA	ETF	107.5	107.5	107.47	107.49	2700.0
2004-12-22 09:00:00	DIA	ETF	107.43	107.53	107.3	107.45	982800.0
2004-12-22 10:00:00	DIA	ETF	107.45	108.13	107.42	107.99	1812400.0
2004-12-22 11:00:00	DIA	ETF	108.0	108.04	107.82	107.93	751500.0
2004-12-22 12:00:00	DIA	ETF	107.92	107.98	107.86	107.94	332300.0
2004-12-22 13:00:00	DIA	ETF	107.97	107.97	107.7	107.76	599300.0
2004-12-22 14:00:00	DIA	ETF	107.78	107.91	107.74	107.87	656600.0
2004-12-22 15:00:00	DIA	ETF	107.87	108.09	107.87	108.08	1197700.0
2004-12-22 16:00:00	DIA	ETF	108.08	108.19	107.92	107.96	139300.0
2004-12-22 17:00:00	DIA	ETF	107.99	107.99	107.99	107.99	300.0
2004-12-22 18:00:00	DIA	ETF	107.99	107.99	107.99	107.99	300.0
2004-12-22 19:00:00	DIA	ETF	107.97	107.97	107.97	107.97	400.0
2004-12-22 09:00:00	GLD	ETF	44.2	44.23	44.12	44.15	117400.0
2004-12-22 10:00:00	GLD	ETF	44.15	44.15	44.02	44.1	258500.0
2004-12-22 11:00:00	GLD	ETF	44.09	44.11	44.03	44.07	116800.0
2004-12-22 12:00:00	GLD	ETF	44.08	44.08	43.89	43.96	936300.0

> showing 50 of 802 rows — these rows as CSV

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