PREVIEW / etf_1hour / 2014-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-18.parquet
  size:    220 KB
  rows:    7,033

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-09-18 04:00:00	SPY	ETF	200.48	201.21	200.48	201.16	9240.0
2014-09-18 05:00:00	SPY	ETF	201.32	201.58	201.21	201.55	6296.0
2014-09-18 06:00:00	SPY	ETF	201.5	201.7	201.42	201.55	183805.0
2014-09-18 07:00:00	SPY	ETF	201.48	201.64	201.37	201.37	348955.0
2014-09-18 08:00:00	SPY	ETF	201.37	201.56	201.22	201.3	840464.0
2014-09-18 09:00:00	SPY	ETF	201.3	201.51	201.1	201.45	10062448.0
2014-09-18 10:00:00	SPY	ETF	201.445	201.8	201.23	201.57	13914988.0
2014-09-18 11:00:00	SPY	ETF	201.56	201.73	201.37	201.45	10111002.0
2014-09-18 12:00:00	SPY	ETF	201.46	201.665	201.4599	201.6027	4684926.0
2014-09-18 13:00:00	SPY	ETF	201.6	201.66	201.44	201.51	7060797.0
2014-09-18 14:00:00	SPY	ETF	201.52	201.71	201.47	201.49	7974264.0
2014-09-18 15:00:00	SPY	ETF	201.49	201.85	201.45	201.77	20783258.0
2014-09-18 16:00:00	SPY	ETF	201.78	202.05	201.4114	201.99	8413354.0
2014-09-18 17:00:00	SPY	ETF	201.99	202.08	201.92	201.96	1214585.0
2014-09-18 18:00:00	SPY	ETF	201.96	202.27	201.9	202.18	383134.0
2014-09-18 19:00:00	SPY	ETF	202.16	202.22	202.08	202.1	143112.0
2014-09-18 04:00:00	QQQ	ETF	99.65	99.74	99.64	99.74	3000.0
2014-09-18 05:00:00	QQQ	ETF	99.9	99.9	99.9	99.9	500.0
2014-09-18 06:00:00	QQQ	ETF	99.89	99.99	99.89	99.94	33007.0
2014-09-18 07:00:00	QQQ	ETF	99.91	99.98	99.87	99.87	50100.0
2014-09-18 08:00:00	QQQ	ETF	99.85	99.89	99.8	99.86	115847.0
2014-09-18 09:00:00	QQQ	ETF	99.85	100.02	99.73	99.99	4205251.0
2014-09-18 10:00:00	QQQ	ETF	99.991	100.2	99.951	100.05	5066908.0
2014-09-18 11:00:00	QQQ	ETF	100.04	100.1	99.95	99.98	1948749.0
2014-09-18 12:00:00	QQQ	ETF	99.98	100.16	99.97	100.1232	1929077.0
2014-09-18 13:00:00	QQQ	ETF	100.1206	100.185	100.07	100.1	1719109.0
2014-09-18 14:00:00	QQQ	ETF	100.11	100.26	100.09	100.11	3265462.0
2014-09-18 15:00:00	QQQ	ETF	100.11	100.285	100.08	100.28	4928095.0
2014-09-18 16:00:00	QQQ	ETF	100.28	100.37	100.0969	100.36	1801358.0
2014-09-18 17:00:00	QQQ	ETF	100.35	100.36	100.26	100.3	189317.0
2014-09-18 18:00:00	QQQ	ETF	100.32	100.51	100.28	100.47	58391.0
2014-09-18 19:00:00	QQQ	ETF	100.46	100.48	100.44	100.44	17738.0
2014-09-18 05:00:00	IWM	ETF	115.3	115.3	115.3	115.3	200.0
2014-09-18 06:00:00	IWM	ETF	115.5	115.65	115.5	115.61	39000.0
2014-09-18 07:00:00	IWM	ETF	115.61	115.64	115.47	115.48	31695.0
2014-09-18 08:00:00	IWM	ETF	115.48	115.5	115.21	115.21	40304.0
2014-09-18 09:00:00	IWM	ETF	115.26	115.37	114.96	115.24	2938531.0
2014-09-18 10:00:00	IWM	ETF	115.25	115.53	114.99	115.29	5236079.0
2014-09-18 11:00:00	IWM	ETF	115.28	115.445	115.16	115.26	1545074.0
2014-09-18 12:00:00	IWM	ETF	115.26	115.43	115.21	115.32	996151.0
2014-09-18 13:00:00	IWM	ETF	115.33	115.405	115.17	115.225	1208684.0
2014-09-18 14:00:00	IWM	ETF	115.21	115.36	114.96	114.96	2191251.0
2014-09-18 15:00:00	IWM	ETF	114.96	115.41	114.91	115.41	4068172.0
2014-09-18 16:00:00	IWM	ETF	115.41	115.56	115.1258	115.56	1574647.0
2014-09-18 17:00:00	IWM	ETF	115.55	115.62	115.54	115.58	72300.0
2014-09-18 18:00:00	IWM	ETF	115.58	115.58	115.43	115.57	6746.0
2014-09-18 19:00:00	IWM	ETF	115.55	115.55	115.47	115.47	2950.0
2014-09-18 07:00:00	DIA	ETF	172.1	172.1	171.93	171.93	775.0
2014-09-18 08:00:00	DIA	ETF	171.91	171.91	171.91	171.91	1000.0
2014-09-18 09:00:00	DIA	ETF	171.95	172.28	171.9	172.24	807050.0

> showing 50 of 7,033 rows — these rows as CSV

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