PREVIEW / etf_1hour / 2014-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-27.parquet
  size:    211 KB
  rows:    6,715

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-27 04:00:00	SPY	ETF	195.2	195.29	195.11	195.29	1407.0
2014-06-27 05:00:00	SPY	ETF	195.04	195.04	195.01	195.01	1625.0
2014-06-27 06:00:00	SPY	ETF	195.0	195.08	194.8	194.91	47352.0
2014-06-27 07:00:00	SPY	ETF	194.91	195.0	194.86	194.99	154360.0
2014-06-27 08:00:00	SPY	ETF	194.97	195.05	194.85	194.89	187502.0
2014-06-27 09:00:00	SPY	ETF	194.9	195.37	194.76	195.25	9283543.0
2014-06-27 10:00:00	SPY	ETF	195.24	195.43	195.0	195.33	8066182.0
2014-06-27 11:00:00	SPY	ETF	195.34	195.51	195.26	195.42	4802884.0
2014-06-27 12:00:00	SPY	ETF	195.42	195.45	195.22	195.295	3512810.0
2014-06-27 13:00:00	SPY	ETF	195.295	195.295	194.885	195.125	6086006.0
2014-06-27 14:00:00	SPY	ETF	195.14	195.39	195.08	195.08	4279744.0
2014-06-27 15:00:00	SPY	ETF	195.085	195.88	195.08	195.8	21129525.0
2014-06-27 16:00:00	SPY	ETF	195.82	195.9	195.59	195.64	12107399.0
2014-06-27 17:00:00	SPY	ETF	195.64	195.81	195.62	195.77	282697.0
2014-06-27 18:00:00	SPY	ETF	195.77	195.77	195.62	195.74	113921.0
2014-06-27 19:00:00	SPY	ETF	195.7	195.72	195.67	195.7	7765.0
2014-06-27 04:00:00	QQQ	ETF	93.23	93.23	93.23	93.23	100.0
2014-06-27 06:00:00	QQQ	ETF	93.2	93.2	93.2	93.2	100.0
2014-06-27 08:00:00	QQQ	ETF	93.21	93.21	93.12	93.16	57652.0
2014-06-27 09:00:00	QQQ	ETF	93.17	93.47	93.13	93.36	3405433.0
2014-06-27 10:00:00	QQQ	ETF	93.36	93.43	93.22	93.35	2166031.0
2014-06-27 11:00:00	QQQ	ETF	93.36	93.51	93.36	93.48	1762361.0
2014-06-27 12:00:00	QQQ	ETF	93.49	93.5	93.41	93.48	1218722.0
2014-06-27 13:00:00	QQQ	ETF	93.47	93.48	93.22	93.41	3614626.0
2014-06-27 14:00:00	QQQ	ETF	93.408	93.6	93.39	93.45	1911598.0
2014-06-27 15:00:00	QQQ	ETF	93.4456	93.765	93.44	93.73	5963474.0
2014-06-27 16:00:00	QQQ	ETF	93.72	93.8	93.4	93.65	1736565.0
2014-06-27 17:00:00	QQQ	ETF	93.65	93.78	93.63	93.75	230570.0
2014-06-27 18:00:00	QQQ	ETF	93.73	93.75	93.68	93.68	3000.0
2014-06-27 19:00:00	QQQ	ETF	93.73	93.73	93.66	93.68	3578.0
2014-06-27 07:00:00	IWM	ETF	117.16	117.17	117.16	117.17	3000.0
2014-06-27 08:00:00	IWM	ETF	117.2	117.2	117.06	117.11	23092.0
2014-06-27 09:00:00	IWM	ETF	117.1	117.77	116.99	117.55	2731133.0
2014-06-27 10:00:00	IWM	ETF	117.54	118.05	117.35	118.005	4021524.0
2014-06-27 11:00:00	IWM	ETF	118.01	118.18	117.95	118.045	3342702.0
2014-06-27 12:00:00	IWM	ETF	118.05	118.09	117.965	118.035	1112746.0
2014-06-27 13:00:00	IWM	ETF	118.03	118.035	117.57	117.84	2352652.0
2014-06-27 14:00:00	IWM	ETF	117.84	118.18	117.82	117.91	3207801.0
2014-06-27 15:00:00	IWM	ETF	117.91	118.51	117.82	118.34	11106267.0
2014-06-27 16:00:00	IWM	ETF	118.34	118.4521	117.69	118.08	3683021.0
2014-06-27 17:00:00	IWM	ETF	118.09	118.34	118.09	118.34	1122190.0
2014-06-27 18:00:00	IWM	ETF	118.34	118.34	118.34	118.34	13466.0
2014-06-27 07:00:00	DIA	ETF	167.75	167.75	167.75	167.75	1000.0
2014-06-27 08:00:00	DIA	ETF	167.75	167.8	167.75	167.8	3500.0
2014-06-27 09:00:00	DIA	ETF	167.66	168.02	167.59	167.8301	466296.0
2014-06-27 10:00:00	DIA	ETF	167.845	167.96	167.57	167.86	309478.0
2014-06-27 11:00:00	DIA	ETF	167.87	167.95	167.77	167.83	191303.0
2014-06-27 12:00:00	DIA	ETF	167.84	167.86	167.7	167.73	153776.0
2014-06-27 13:00:00	DIA	ETF	167.72	167.725	167.34	167.5	444754.0
2014-06-27 14:00:00	DIA	ETF	167.5	167.84	167.495	167.55	451203.0

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

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