PREVIEW / etf_1hour / 2012-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-22.parquet
  size:    188 KB
  rows:    5,806

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
2012-10-22 04:00:00	SPY	ETF	143.01	143.46	143.01	143.46	4470.0
2012-10-22 05:00:00	SPY	ETF	143.48	143.65	143.48	143.6	19325.0
2012-10-22 06:00:00	SPY	ETF	143.56	143.64	143.47	143.48	140691.0
2012-10-22 07:00:00	SPY	ETF	143.53	143.61	143.28	143.34	269827.0
2012-10-22 08:00:00	SPY	ETF	143.34	143.62	143.11	143.17	1149981.0
2012-10-22 09:00:00	SPY	ETF	143.18	143.47	143.02	143.31	14912480.0
2012-10-22 10:00:00	SPY	ETF	143.32	143.67	143.13	143.25	17546755.0
2012-10-22 11:00:00	SPY	ETF	143.24	143.33	142.81	143.18	14299025.0
2012-10-22 12:00:00	SPY	ETF	143.185	143.25	142.925	142.98	8403546.0
2012-10-22 13:00:00	SPY	ETF	142.985	143.07	142.28	142.529	17027930.0
2012-10-22 14:00:00	SPY	ETF	142.53	142.77	142.45	142.549	14221164.0
2012-10-22 15:00:00	SPY	ETF	142.54	143.56	142.39	143.43	26427890.0
2012-10-22 16:00:00	SPY	ETF	143.44	143.85	142.29	143.8	5605715.0
2012-10-22 17:00:00	SPY	ETF	143.8	143.83	143.73	143.76	194812.0
2012-10-22 18:00:00	SPY	ETF	143.76	143.77	143.71	143.75	54221.0
2012-10-22 19:00:00	SPY	ETF	143.74	143.9	143.7	143.89	127299.0
2012-10-22 04:00:00	QQQ	ETF	65.71	65.88	65.71	65.88	2200.0
2012-10-22 05:00:00	QQQ	ETF	65.87	65.94	65.87	65.94	5500.0
2012-10-22 06:00:00	QQQ	ETF	65.88	65.9	65.88	65.89	1400.0
2012-10-22 07:00:00	QQQ	ETF	65.88	65.92	65.76	65.8	78986.0
2012-10-22 08:00:00	QQQ	ETF	65.78	65.83	65.65	65.66	237834.0
2012-10-22 09:00:00	QQQ	ETF	65.67	65.9	65.61	65.84	4891951.0
2012-10-22 10:00:00	QQQ	ETF	65.845	66.04	65.73	65.78	5215394.0
2012-10-22 11:00:00	QQQ	ETF	65.77	65.94	65.63	65.8601	3274735.0
2012-10-22 12:00:00	QQQ	ETF	65.865	65.91	65.745	65.8101	2458618.0
2012-10-22 13:00:00	QQQ	ETF	65.82	65.87	65.5	65.65	4246742.0
2012-10-22 14:00:00	QQQ	ETF	65.6508	65.82	65.61	65.71	2808838.0
2012-10-22 15:00:00	QQQ	ETF	65.72	66.19	65.63	66.05	5823560.0
2012-10-22 16:00:00	QQQ	ETF	66.05	66.22	65.7826	66.21	944063.0
2012-10-22 17:00:00	QQQ	ETF	66.2	66.22	66.11	66.145	39630.0
2012-10-22 18:00:00	QQQ	ETF	66.17	66.2	66.145	66.19	50256.0
2012-10-22 19:00:00	QQQ	ETF	66.18	66.25	66.17	66.22	61455.0
2012-10-22 07:00:00	IWM	ETF	81.89	81.89	81.74	81.74	11190.0
2012-10-22 08:00:00	IWM	ETF	81.74	81.74	81.56	81.59	84612.0
2012-10-22 09:00:00	IWM	ETF	81.61	81.95	81.57	81.76	3930367.0
2012-10-22 10:00:00	IWM	ETF	81.77	81.97	81.64	81.75	3868315.0
2012-10-22 11:00:00	IWM	ETF	81.75	81.845	81.49	81.77	3448862.0
2012-10-22 12:00:00	IWM	ETF	81.77	81.88	81.64	81.73	1460769.0
2012-10-22 13:00:00	IWM	ETF	81.73	81.81	81.35	81.42	4353628.0
2012-10-22 14:00:00	IWM	ETF	81.4208	81.64	81.38	81.48	2082824.0
2012-10-22 15:00:00	IWM	ETF	81.485	81.87	81.37	81.8332	5566004.0
2012-10-22 16:00:00	IWM	ETF	81.85	82.2	81.6371	82.17	854577.0
2012-10-22 17:00:00	IWM	ETF	82.17	82.55	82.1	82.15	31002.0
2012-10-22 18:00:00	IWM	ETF	82.15	82.19	82.12	82.19	2260.0
2012-10-22 19:00:00	IWM	ETF	82.17	82.25	82.17	82.25	8048.0
2012-10-22 07:00:00	DIA	ETF	133.28	133.34	133.1	133.1	2900.0
2012-10-22 08:00:00	DIA	ETF	133.34	133.34	133.0	133.05	2500.0
2012-10-22 09:00:00	DIA	ETF	132.97	133.09	132.69	133.0399	857212.0
2012-10-22 10:00:00	DIA	ETF	133.04	133.39	132.88	133.01	627067.0
2012-10-22 11:00:00	DIA	ETF	133.0	133.09	132.65	132.96	551623.0

> showing 50 of 5,806 rows — these rows as CSV

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