PREVIEW / etf_1hour / 2013-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-24.parquet
  size:    202 KB
  rows:    6,241

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
2013-01-24 04:00:00	SPY	ETF	148.92	149.19	148.92	149.17	45366.0
2013-01-24 05:00:00	SPY	ETF	149.1	149.22	149.1	149.12	19200.0
2013-01-24 06:00:00	SPY	ETF	149.11	149.16	149.02	149.07	59800.0
2013-01-24 07:00:00	SPY	ETF	149.09	149.24	149.04	149.11	215400.0
2013-01-24 08:00:00	SPY	ETF	149.1	149.46	149.03	149.36	1387221.0
2013-01-24 09:00:00	SPY	ETF	149.35	149.78	149.12	149.75	15853153.0
2013-01-24 10:00:00	SPY	ETF	149.75	150.07	149.72	149.85	16690627.0
2013-01-24 11:00:00	SPY	ETF	149.85	150.14	149.85	149.94	15984152.0
2013-01-24 12:00:00	SPY	ETF	149.931	149.98	149.33	149.351	16953925.0
2013-01-24 13:00:00	SPY	ETF	149.35	149.48	149.01	149.14	18719382.0
2013-01-24 14:00:00	SPY	ETF	149.14	149.45	149.04	149.37	13344397.0
2013-01-24 15:00:00	SPY	ETF	149.37	149.74	149.32	149.38	20577231.0
2013-01-24 16:00:00	SPY	ETF	149.39	149.9664	149.24	149.24	24359674.0
2013-01-24 17:00:00	SPY	ETF	149.26	149.27	149.17	149.21	203047.0
2013-01-24 18:00:00	SPY	ETF	149.2	149.28	149.16	149.21	75461.0
2013-01-24 19:00:00	SPY	ETF	149.23	149.25	149.09	149.24	192836.0
2013-01-24 04:00:00	QQQ	ETF	66.73	66.81	66.73	66.81	6600.0
2013-01-24 05:00:00	QQQ	ETF	66.8	66.85	66.8	66.8	6304.0
2013-01-24 06:00:00	QQQ	ETF	66.8	66.83	66.73	66.73	13575.0
2013-01-24 07:00:00	QQQ	ETF	66.74	66.85	66.72	66.82	552953.0
2013-01-24 08:00:00	QQQ	ETF	66.81	66.83	66.65	66.73	670416.0
2013-01-24 09:00:00	QQQ	ETF	66.72	67.11	66.62	67.08	8311875.0
2013-01-24 10:00:00	QQQ	ETF	67.07	67.25	67.01	67.12	5450911.0
2013-01-24 11:00:00	QQQ	ETF	67.12	67.28	67.11	67.19	3727029.0
2013-01-24 12:00:00	QQQ	ETF	67.1899	67.2	66.8	66.82	4374585.0
2013-01-24 13:00:00	QQQ	ETF	66.81	66.875	66.58	66.62	5090476.0
2013-01-24 14:00:00	QQQ	ETF	66.62	66.76	66.56	66.73	3586657.0
2013-01-24 15:00:00	QQQ	ETF	66.72	66.899	66.64	66.66	6595346.0
2013-01-24 16:00:00	QQQ	ETF	66.66	66.79	66.53	66.55	2278593.0
2013-01-24 17:00:00	QQQ	ETF	66.56	66.59	66.53	66.55	45206.0
2013-01-24 18:00:00	QQQ	ETF	66.58	66.61	66.58	66.6	7800.0
2013-01-24 19:00:00	QQQ	ETF	66.58	66.59	66.55	66.57	6003.0
2013-01-24 07:00:00	IWM	ETF	89.04	89.04	88.95	88.97	9700.0
2013-01-24 08:00:00	IWM	ETF	88.95	89.15	88.89	89.15	587401.0
2013-01-24 09:00:00	IWM	ETF	89.14	89.695	89.08	89.64	4687692.0
2013-01-24 10:00:00	IWM	ETF	89.65	89.77	89.54	89.6	4173371.0
2013-01-24 11:00:00	IWM	ETF	89.6	89.85	89.6	89.72	4094881.0
2013-01-24 12:00:00	IWM	ETF	89.7199	89.74	89.12	89.1599	4952407.0
2013-01-24 13:00:00	IWM	ETF	89.1596	89.41	88.93	89.0103	6607748.0
2013-01-24 14:00:00	IWM	ETF	89.02	89.2425	88.93	89.1667	2676890.0
2013-01-24 15:00:00	IWM	ETF	89.16	89.48	89.11	89.28	7808674.0
2013-01-24 16:00:00	IWM	ETF	89.29	89.46	89.28	89.31	987854.0
2013-01-24 17:00:00	IWM	ETF	89.3	89.3	89.24	89.29	8751.0
2013-01-24 18:00:00	IWM	ETF	89.23	89.23	89.23	89.23	300.0
2013-01-24 19:00:00	IWM	ETF	89.26	89.26	89.21	89.26	3379.0
2013-01-24 04:00:00	DIA	ETF	137.54	137.54	137.54	137.54	100.0
2013-01-24 07:00:00	DIA	ETF	137.62	137.62	137.62	137.62	100.0
2013-01-24 08:00:00	DIA	ETF	137.57	137.77	137.53	137.68	64893.0
2013-01-24 09:00:00	DIA	ETF	137.69	138.06	137.57	138.05	1099619.0
2013-01-24 10:00:00	DIA	ETF	138.05	138.32	138.02	138.25	1145050.0

> showing 50 of 6,241 rows — these rows as CSV

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