PREVIEW / etf_1hour / 2014-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-17.parquet
  size:    216 KB
  rows:    6,872

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-06-17 04:00:00	SPY	ETF	194.75	194.85	194.75	194.85	400.0
2014-06-17 05:00:00	SPY	ETF	194.66	194.8	194.6	194.6	16780.0
2014-06-17 06:00:00	SPY	ETF	194.56	194.6	194.32	194.33	77181.0
2014-06-17 07:00:00	SPY	ETF	194.32	194.63	194.32	194.53	200664.0
2014-06-17 08:00:00	SPY	ETF	194.52	194.65	193.76	193.94	1379406.0
2014-06-17 09:00:00	SPY	ETF	193.91	194.47	193.81	194.36	9779866.0
2014-06-17 10:00:00	SPY	ETF	194.37	194.74	194.0489	194.24	13266804.0
2014-06-17 11:00:00	SPY	ETF	194.24	194.58	194.03	194.57	6488874.0
2014-06-17 12:00:00	SPY	ETF	194.56	194.84	194.49	194.76	5450237.0
2014-06-17 13:00:00	SPY	ETF	194.77	194.91	194.58	194.85	7676840.0
2014-06-17 14:00:00	SPY	ETF	194.855	194.97	194.66	194.9	8384704.0
2014-06-17 15:00:00	SPY	ETF	194.9	194.95	194.68	194.82	19140270.0
2014-06-17 16:00:00	SPY	ETF	194.81	194.83	194.3437	194.83	7259734.0
2014-06-17 17:00:00	SPY	ETF	194.82	194.83	194.74	194.76	34877.0
2014-06-17 18:00:00	SPY	ETF	194.77	194.82	194.76	194.79	26216.0
2014-06-17 19:00:00	SPY	ETF	194.82	194.82	194.74	194.75	30723.0
2014-06-17 04:00:00	QQQ	ETF	92.65	92.7	92.65	92.7	400.0
2014-06-17 05:00:00	QQQ	ETF	92.56	92.56	92.56	92.56	2000.0
2014-06-17 06:00:00	QQQ	ETF	92.5	92.54	92.5	92.53	9111.0
2014-06-17 07:00:00	QQQ	ETF	92.58	92.66	92.57	92.57	62400.0
2014-06-17 08:00:00	QQQ	ETF	92.57	92.59	92.22	92.32	229329.0
2014-06-17 09:00:00	QQQ	ETF	92.31	92.58	92.18	92.545	3670906.0
2014-06-17 10:00:00	QQQ	ETF	92.55	92.7	92.33	92.42	3953994.0
2014-06-17 11:00:00	QQQ	ETF	92.41	92.52	92.21	92.5	2262969.0
2014-06-17 12:00:00	QQQ	ETF	92.5	92.62	92.46	92.57	1074548.0
2014-06-17 13:00:00	QQQ	ETF	92.57	92.67	92.47	92.61	1532812.0
2014-06-17 14:00:00	QQQ	ETF	92.6299	92.68	92.52	92.641	1200571.0
2014-06-17 15:00:00	QQQ	ETF	92.65	92.66	92.44	92.45	3415705.0
2014-06-17 16:00:00	QQQ	ETF	92.45	92.46	92.39	92.46	385588.0
2014-06-17 17:00:00	QQQ	ETF	92.44	92.44	92.44	92.44	200.0
2014-06-17 18:00:00	QQQ	ETF	92.45	92.47	92.45	92.47	862.0
2014-06-17 19:00:00	QQQ	ETF	92.46	92.46	92.44	92.44	6225.0
2014-06-17 04:00:00	IWM	ETF	116.55	116.58	116.55	116.58	300.0
2014-06-17 06:00:00	IWM	ETF	116.2	116.29	116.2	116.25	2260.0
2014-06-17 07:00:00	IWM	ETF	116.25	116.55	116.25	116.44	39280.0
2014-06-17 08:00:00	IWM	ETF	116.44	116.61	115.87	116.02	288750.0
2014-06-17 09:00:00	IWM	ETF	115.99	116.9	115.78	116.82	5747658.0
2014-06-17 10:00:00	IWM	ETF	116.82	117.25	116.45	116.74	10120618.0
2014-06-17 11:00:00	IWM	ETF	116.735	117.26	116.53	117.23	4964263.0
2014-06-17 12:00:00	IWM	ETF	117.22	117.39	117.08	117.3	3807006.0
2014-06-17 13:00:00	IWM	ETF	117.3	117.45	117.11	117.27	4008878.0
2014-06-17 14:00:00	IWM	ETF	117.2701	117.32	117.06	117.24	3573140.0
2014-06-17 15:00:00	IWM	ETF	117.24	117.26	116.92	116.99	8487450.0
2014-06-17 16:00:00	IWM	ETF	116.98	117.08	116.775	116.92	3802289.0
2014-06-17 17:00:00	IWM	ETF	116.94	116.99	116.92	116.95	37812.0
2014-06-17 18:00:00	IWM	ETF	116.91	116.91	116.91	116.91	100.0
2014-06-17 19:00:00	IWM	ETF	116.91	117.03	116.88	116.88	300.0
2014-06-17 04:00:00	DIA	ETF	168.17	168.17	168.17	168.17	100.0
2014-06-17 06:00:00	DIA	ETF	168.0	168.0	167.91	167.91	300.0
2014-06-17 07:00:00	DIA	ETF	167.73	167.73	167.7	167.73	5000.0

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

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