PREVIEW / etf_1hour / 2006-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-20.parquet
  size:    50 KB
  rows:    1,561

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
2006-07-20 05:00:00	SPY	ETF	126.0	126.0	126.0	126.0	2000.0
2006-07-20 06:00:00	SPY	ETF	126.05	126.05	125.95	125.95	90000.0
2006-07-20 07:00:00	SPY	ETF	125.95	126.04	125.86	125.95	349000.0
2006-07-20 08:00:00	SPY	ETF	125.95	126.2	125.86	126.09	3255800.0
2006-07-20 09:00:00	SPY	ETF	126.09	126.3	125.83	125.87	11182000.0
2006-07-20 10:00:00	SPY	ETF	125.85	126.06	125.66	126.05	22901300.0
2006-07-20 11:00:00	SPY	ETF	126.06	126.15	125.89	125.95	12196900.0
2006-07-20 12:00:00	SPY	ETF	125.94	125.98	125.68	125.85	10500200.0
2006-07-20 13:00:00	SPY	ETF	125.85	125.94	125.49	125.67	8873700.0
2006-07-20 14:00:00	SPY	ETF	125.65	125.93	125.27	125.31	17899800.0
2006-07-20 15:00:00	SPY	ETF	125.3	125.56	124.92	124.96	18847200.0
2006-07-20 16:00:00	SPY	ETF	124.97	125.27	124.68	125.24	3168600.0
2006-07-20 17:00:00	SPY	ETF	125.2	125.24	125.11	125.13	85300.0
2006-07-20 18:00:00	SPY	ETF	125.1	125.15	125.01	125.01	11900.0
2006-07-20 19:00:00	SPY	ETF	125.13	125.17	125.13	125.17	1800.0
2006-07-20 09:00:00	QQQ	ETF	36.74	36.8	36.55	36.55	21888900.0
2006-07-20 10:00:00	QQQ	ETF	36.55	36.62	36.38	36.55	30330200.0
2006-07-20 11:00:00	QQQ	ETF	36.56	36.62	36.48	36.54	9894200.0
2006-07-20 12:00:00	QQQ	ETF	36.53	36.54	36.29	36.39	19515300.0
2006-07-20 13:00:00	QQQ	ETF	36.4	36.43	36.17	36.25	12975000.0
2006-07-20 14:00:00	QQQ	ETF	36.25	36.38	36.17	36.27	21428600.0
2006-07-20 15:00:00	QQQ	ETF	36.27	36.34	36.04	36.06	19666200.0
2006-07-20 07:00:00	IWM	ETF	69.8	69.8	69.8	69.8	1000.0
2006-07-20 08:00:00	IWM	ETF	69.8	70.05	69.8	70.04	169700.0
2006-07-20 09:00:00	IWM	ETF	70.03	70.37	69.54	69.56	9505800.0
2006-07-20 10:00:00	IWM	ETF	69.58	69.6	69.06	69.4	16093300.0
2006-07-20 11:00:00	IWM	ETF	69.36	69.44	69.02	69.24	5248600.0
2006-07-20 12:00:00	IWM	ETF	69.24	69.24	68.72	68.9	7428200.0
2006-07-20 13:00:00	IWM	ETF	68.9	68.99	68.42	68.58	4847900.0
2006-07-20 14:00:00	IWM	ETF	68.59	69.07	68.26	68.32	8707200.0
2006-07-20 15:00:00	IWM	ETF	68.32	68.46	67.84	67.92	14053200.0
2006-07-20 16:00:00	IWM	ETF	67.91	68.29	67.65	68.0	3567400.0
2006-07-20 17:00:00	IWM	ETF	68.0	68.05	67.72	68.05	1645600.0
2006-07-20 18:00:00	IWM	ETF	67.95	67.99	67.91	67.91	11400.0
2006-07-20 07:00:00	DIA	ETF	110.26	110.26	110.26	110.26	100.0
2006-07-20 08:00:00	DIA	ETF	110.12	110.34	110.12	110.2	36400.0
2006-07-20 09:00:00	DIA	ETF	110.29	110.45	110.12	110.17	1764700.0
2006-07-20 10:00:00	DIA	ETF	110.17	110.236	109.85	110.22	1452000.0
2006-07-20 11:00:00	DIA	ETF	110.23	110.336	110.13	110.16	1314300.0
2006-07-20 12:00:00	DIA	ETF	110.15	110.27	109.89	110.03	522300.0
2006-07-20 13:00:00	DIA	ETF	110.03	110.11	109.66	109.84	456500.0
2006-07-20 14:00:00	DIA	ETF	109.84	110.07	109.47	109.48	1188400.0
2006-07-20 15:00:00	DIA	ETF	109.48	109.71	109.29	109.35	940900.0
2006-07-20 16:00:00	DIA	ETF	109.37	109.63	109.24	109.56	48500.0
2006-07-20 17:00:00	DIA	ETF	109.55	109.55	109.52	109.52	2000.0
2006-07-20 07:00:00	GLD	ETF	65.89	65.89	63.81	63.81	6400.0
2006-07-20 08:00:00	GLD	ETF	63.88	65.66	63.32	63.33	119900.0
2006-07-20 09:00:00	GLD	ETF	63.39	63.74	63.29	63.641	833600.0
2006-07-20 10:00:00	GLD	ETF	63.65	63.97	63.49	63.7	912200.0
2006-07-20 11:00:00	GLD	ETF	63.69	63.92	62.76	62.95	1085000.0

> showing 50 of 1,561 rows — these rows as CSV

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