PREVIEW / etf_1hour / 2008-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-15.parquet
  size:    115 KB
  rows:    3,652

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
2008-07-15 04:00:00	SPY	ETF	121.89	121.9	121.81	121.81	1500.0
2008-07-15 05:00:00	SPY	ETF	121.83	121.83	121.65	121.65	1300.0
2008-07-15 06:00:00	SPY	ETF	121.58	121.65	121.04	121.17	1321400.0
2008-07-15 07:00:00	SPY	ETF	121.19	121.47	121.14	121.4	1760665.0
2008-07-15 08:00:00	SPY	ETF	121.4	121.7	121.06	121.69	7940197.0
2008-07-15 09:00:00	SPY	ETF	121.68	122.0	120.97	121.09	43810372.0
2008-07-15 10:00:00	SPY	ETF	121.1	121.3	120.02	121.0699	99410813.0
2008-07-15 11:00:00	SPY	ETF	121.065	122.37	121.06	122.11	101631480.0
2008-07-15 12:00:00	SPY	ETF	122.11	122.89	121.69	122.71	63781823.0
2008-07-15 13:00:00	SPY	ETF	122.72	123.35	122.05	122.58	51008219.0
2008-07-15 14:00:00	SPY	ETF	122.58	123.44	122.1	122.95	39857850.0
2008-07-15 15:00:00	SPY	ETF	122.95	123.49	121.41	121.45	70835481.0
2008-07-15 16:00:00	SPY	ETF	121.39	122.8119	120.46	121.29	15558050.0
2008-07-15 17:00:00	SPY	ETF	121.29	121.31	121.1	121.1	1216879.0
2008-07-15 18:00:00	SPY	ETF	121.11	121.22	120.99	121.22	66970.0
2008-07-15 19:00:00	SPY	ETF	121.2	121.4	121.2	121.4	36892.0
2008-07-15 04:00:00	QQQ	ETF	43.9	43.9	43.84	43.85	2700.0
2008-07-15 05:00:00	QQQ	ETF	43.85	43.85	43.81	43.81	2100.0
2008-07-15 06:00:00	QQQ	ETF	43.81	43.81	43.58	43.67	12000.0
2008-07-15 07:00:00	QQQ	ETF	43.7	43.8	43.68	43.77	364703.0
2008-07-15 08:00:00	QQQ	ETF	43.78	44.0	43.72	43.98	2673901.0
2008-07-15 09:00:00	QQQ	ETF	43.98	44.09	43.63	43.768	27405629.0
2008-07-15 10:00:00	QQQ	ETF	43.76	43.83	43.3	43.71	55619626.0
2008-07-15 11:00:00	QQQ	ETF	43.72	44.3	43.6	44.14	60121387.0
2008-07-15 12:00:00	QQQ	ETF	44.15	44.62	44.04	44.52	37803948.0
2008-07-15 13:00:00	QQQ	ETF	44.5204	44.72	44.25	44.5	27056071.0
2008-07-15 14:00:00	QQQ	ETF	44.4901	44.79	44.33	44.719	21670752.0
2008-07-15 15:00:00	QQQ	ETF	44.71	44.93	44.22	44.22	35035201.0
2008-07-15 16:00:00	QQQ	ETF	44.22	44.64	43.89	44.3	8269579.0
2008-07-15 17:00:00	QQQ	ETF	44.29	44.33	44.26	44.27	61050.0
2008-07-15 18:00:00	QQQ	ETF	44.25	44.3	44.21	44.29	84602.0
2008-07-15 19:00:00	QQQ	ETF	44.31	44.36	44.3	44.35	32771.0
2008-07-15 06:00:00	IWM	ETF	65.6	65.6	65.34	65.34	20300.0
2008-07-15 07:00:00	IWM	ETF	65.47	65.48	65.36	65.43	69978.0
2008-07-15 08:00:00	IWM	ETF	65.6	65.6	65.24	65.54	624534.0
2008-07-15 09:00:00	IWM	ETF	65.55	65.68	65.16	65.21	14449105.0
2008-07-15 10:00:00	IWM	ETF	65.21	65.54	64.52	65.42	24699978.0
2008-07-15 11:00:00	IWM	ETF	65.42	66.4	65.42	66.28	27228505.0
2008-07-15 12:00:00	IWM	ETF	66.28	66.89	66.1	66.84	18306623.0
2008-07-15 13:00:00	IWM	ETF	66.84	67.11	66.24	66.66	14692530.0
2008-07-15 14:00:00	IWM	ETF	66.65	67.09	66.38	66.99	12725558.0
2008-07-15 15:00:00	IWM	ETF	66.99	67.28	65.9	65.9	25057326.0
2008-07-15 16:00:00	IWM	ETF	65.93	66.22	65.76	65.93	1906757.0
2008-07-15 17:00:00	IWM	ETF	65.98	65.98	65.82	65.92	57812.0
2008-07-15 18:00:00	IWM	ETF	65.92	65.92	65.83	65.83	900.0
2008-07-15 05:00:00	DIA	ETF	110.0	110.0	109.89	109.89	800.0
2008-07-15 06:00:00	DIA	ETF	109.41	109.41	109.05	109.05	900.0
2008-07-15 07:00:00	DIA	ETF	109.15	109.35	109.1	109.29	15056.0
2008-07-15 08:00:00	DIA	ETF	109.31	109.56	109.13	109.56	240778.0
2008-07-15 09:00:00	DIA	ETF	109.57	110.02	109.08	109.14	3757079.0

> showing 50 of 3,652 rows — these rows as CSV

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