PREVIEW / etf_1hour / 2004-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-01.parquet
  size:    28 KB
  rows:    769

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-01 08:00:00	SPY	ETF	118.0	118.11	118.0	118.11	210700.0
2004-12-01 09:00:00	SPY	ETF	118.11	118.67	118.09	118.58	7183100.0
2004-12-01 10:00:00	SPY	ETF	118.59	119.2	118.41	118.94	9434700.0
2004-12-01 11:00:00	SPY	ETF	118.99	119.16	118.89	118.97	5721300.0
2004-12-01 12:00:00	SPY	ETF	118.97	119.31	118.94	119.17	5367600.0
2004-12-01 13:00:00	SPY	ETF	119.17	119.26	119.03	119.09	3141400.0
2004-12-01 14:00:00	SPY	ETF	119.09	119.3	118.99	119.28	4895200.0
2004-12-01 15:00:00	SPY	ETF	119.27	119.47	119.26	119.47	7781400.0
2004-12-01 16:00:00	SPY	ETF	119.48	119.5	119.23	119.24	2246100.0
2004-12-01 17:00:00	SPY	ETF	119.3	119.34	119.28	119.31	3700.0
2004-12-01 18:00:00	SPY	ETF	119.33	119.35	119.32	119.35	9700.0
2004-12-01 19:00:00	SPY	ETF	119.36	119.36	119.28	119.28	9300.0
2004-12-01 08:00:00	QQQ	ETF	39.22	39.33	39.17	39.31	429382.0
2004-12-01 09:00:00	QQQ	ETF	39.31	39.484	39.27	39.47	11905897.0
2004-12-01 10:00:00	QQQ	ETF	39.47	39.71	39.36	39.6699	26095022.0
2004-12-01 11:00:00	QQQ	ETF	39.66	39.83	39.64	39.751	13739443.0
2004-12-01 12:00:00	QQQ	ETF	39.75	39.86	39.72	39.817	10264964.0
2004-12-01 13:00:00	QQQ	ETF	39.8101	39.86	39.73	39.78	7372606.0
2004-12-01 14:00:00	QQQ	ETF	39.785	39.86	39.74	39.85	9034715.0
2004-12-01 15:00:00	QQQ	ETF	39.85	39.961	39.82	39.94	15816403.0
2004-12-01 16:00:00	QQQ	ETF	39.94	39.96	39.81	39.84	5674272.0
2004-12-01 17:00:00	QQQ	ETF	39.84	39.9	39.84	39.88	51003.0
2004-12-01 18:00:00	QQQ	ETF	39.88	39.89	39.87	39.89	25149.0
2004-12-01 08:00:00	IWM	ETF	63.55	63.57	63.535	63.535	12400.0
2004-12-01 09:00:00	IWM	ETF	63.535	63.84	63.34	63.805	2699200.0
2004-12-01 10:00:00	IWM	ETF	63.825	64.135	63.71	64.075	3728400.0
2004-12-01 11:00:00	IWM	ETF	64.07	64.28	64.025	64.17	2940800.0
2004-12-01 12:00:00	IWM	ETF	64.175	64.285	64.16	64.21	2039800.0
2004-12-01 13:00:00	IWM	ETF	64.21	64.275	64.1	64.15	803400.0
2004-12-01 14:00:00	IWM	ETF	64.16	64.275	64.1	64.265	1958600.0
2004-12-01 15:00:00	IWM	ETF	64.255	64.315	64.21	64.28	3579600.0
2004-12-01 16:00:00	IWM	ETF	64.29	64.3	64.03	64.055	484400.0
2004-12-01 17:00:00	IWM	ETF	64.065	64.065	64.055	64.055	2000.0
2004-12-01 19:00:00	IWM	ETF	64.125	64.125	64.07	64.07	2000.0
2004-12-01 08:00:00	DIA	ETF	104.54	104.56	104.5	104.56	5100.0
2004-12-01 09:00:00	DIA	ETF	104.56	105.13	104.56	105.05	1890600.0
2004-12-01 10:00:00	DIA	ETF	105.05	105.55	104.86	105.42	1673400.0
2004-12-01 11:00:00	DIA	ETF	105.4	105.65	105.38	105.47	619000.0
2004-12-01 12:00:00	DIA	ETF	105.46	105.69	105.38	105.5	797200.0
2004-12-01 13:00:00	DIA	ETF	105.51	105.6	105.4	105.45	420900.0
2004-12-01 14:00:00	DIA	ETF	105.46	105.69	105.42	105.67	1095200.0
2004-12-01 15:00:00	DIA	ETF	105.67	105.84	105.64	105.81	1532000.0
2004-12-01 16:00:00	DIA	ETF	105.82	105.86	105.65	105.66	344600.0
2004-12-01 17:00:00	DIA	ETF	105.67	105.74	105.67	105.73	700.0
2004-12-01 18:00:00	DIA	ETF	105.68	105.68	105.65	105.65	500.0
2004-12-01 09:00:00	GLD	ETF	45.28	45.35	45.28	45.35	359800.0
2004-12-01 10:00:00	GLD	ETF	45.37	45.45	45.26	45.36	431000.0
2004-12-01 11:00:00	GLD	ETF	45.37	45.44	45.28	45.41	329800.0
2004-12-01 12:00:00	GLD	ETF	45.41	45.59	45.4	45.52	337400.0
2004-12-01 13:00:00	GLD	ETF	45.5	45.5	45.39	45.45	200800.0

> showing 50 of 769 rows — these rows as CSV

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