PREVIEW / etf_1hour / 2014-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-12.parquet
  size:    217 KB
  rows:    6,978

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
2014-05-12 04:00:00	SPY	ETF	188.2	188.22	188.19	188.19	3151.0
2014-05-12 05:00:00	SPY	ETF	188.23	188.34	188.14	188.34	15385.0
2014-05-12 06:00:00	SPY	ETF	188.34	188.68	188.27	188.68	63013.0
2014-05-12 07:00:00	SPY	ETF	188.69	188.73	188.54	188.56	154134.0
2014-05-12 08:00:00	SPY	ETF	188.55	188.73	188.41	188.62	276552.0
2014-05-12 09:00:00	SPY	ETF	188.61	189.39	188.57	189.33	14215156.0
2014-05-12 10:00:00	SPY	ETF	189.34	189.53	189.24	189.32	14592340.0
2014-05-12 11:00:00	SPY	ETF	189.32	189.55	189.3	189.4301	7212620.0
2014-05-12 12:00:00	SPY	ETF	189.43	189.65	189.39	189.41	4621620.0
2014-05-12 13:00:00	SPY	ETF	189.41	189.65	189.38	189.61	7629984.0
2014-05-12 14:00:00	SPY	ETF	189.6073	189.755	189.48	189.74	7458326.0
2014-05-12 15:00:00	SPY	ETF	189.73	189.88	189.63	189.78	16127200.0
2014-05-12 16:00:00	SPY	ETF	189.77	189.92	187.9992	189.91	7797231.0
2014-05-12 17:00:00	SPY	ETF	189.91	189.95	189.9	189.92	2046234.0
2014-05-12 18:00:00	SPY	ETF	189.92	189.92	189.8	189.89	32068.0
2014-05-12 19:00:00	SPY	ETF	189.9	189.97	189.9	189.96	35146.0
2014-05-12 04:00:00	QQQ	ETF	86.92	86.98	86.92	86.98	5490.0
2014-05-12 06:00:00	QQQ	ETF	87.0	87.27	87.0	87.27	12250.0
2014-05-12 07:00:00	QQQ	ETF	87.28	87.33	87.22	87.22	56530.0
2014-05-12 08:00:00	QQQ	ETF	87.22	87.25	87.18	87.24	101218.0
2014-05-12 09:00:00	QQQ	ETF	87.25	87.83	87.23	87.83	6499796.0
2014-05-12 10:00:00	QQQ	ETF	87.83	88.03	87.74	87.95	6581387.0
2014-05-12 11:00:00	QQQ	ETF	87.94	88.01	87.872	87.93	3502738.0
2014-05-12 12:00:00	QQQ	ETF	87.93	88.12	87.92	87.9601	2199224.0
2014-05-12 13:00:00	QQQ	ETF	87.96	88.06	87.9335	88.035	1499149.0
2014-05-12 14:00:00	QQQ	ETF	88.04	88.18	87.95	88.16	2799793.0
2014-05-12 15:00:00	QQQ	ETF	88.1643	88.26	88.13	88.21	6181519.0
2014-05-12 16:00:00	QQQ	ETF	88.21	88.27	86.8387	88.26	2075545.0
2014-05-12 17:00:00	QQQ	ETF	88.28	88.34	88.28	88.34	27850.0
2014-05-12 18:00:00	QQQ	ETF	88.34	88.34	88.22	88.28	13258.0
2014-05-12 19:00:00	QQQ	ETF	88.29	88.33	88.28	88.31	12130.0
2014-05-12 05:00:00	IWM	ETF	110.34	110.41	110.34	110.41	750.0
2014-05-12 06:00:00	IWM	ETF	110.5	110.65	110.5	110.65	500.0
2014-05-12 07:00:00	IWM	ETF	110.65	110.7	110.55	110.55	68860.0
2014-05-12 08:00:00	IWM	ETF	110.62	110.68	110.49	110.58	429465.0
2014-05-12 09:00:00	IWM	ETF	110.59	111.77	110.51	111.77	8478498.0
2014-05-12 10:00:00	IWM	ETF	111.78	112.65	111.73	112.27	13759258.0
2014-05-12 11:00:00	IWM	ETF	112.26	112.55	112.19	112.27	4891191.0
2014-05-12 12:00:00	IWM	ETF	112.26	112.48	112.14	112.27	4118190.0
2014-05-12 13:00:00	IWM	ETF	112.27	112.54	112.2	112.49	2874747.0
2014-05-12 14:00:00	IWM	ETF	112.5	112.985	112.36	112.96	5678453.0
2014-05-12 15:00:00	IWM	ETF	112.96	113.035	112.49	112.49	12338876.0
2014-05-12 16:00:00	IWM	ETF	112.5	112.8294	112.4	112.51	9967210.0
2014-05-12 17:00:00	IWM	ETF	112.53	112.64	112.52	112.58	44907.0
2014-05-12 18:00:00	IWM	ETF	112.58	112.58	112.5	112.5	425.0
2014-05-12 19:00:00	IWM	ETF	112.62	112.65	112.6	112.65	2540.0
2014-05-12 06:00:00	DIA	ETF	165.98	165.98	165.98	165.98	100.0
2014-05-12 07:00:00	DIA	ETF	166.15	166.19	166.13	166.13	700.0
2014-05-12 08:00:00	DIA	ETF	166.12	166.38	166.06	166.12	2400.0
2014-05-12 09:00:00	DIA	ETF	166.19	166.83	166.18	166.74	943609.0

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

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