PREVIEW / etf_1hour / 2014-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-13.parquet
  size:    211 KB
  rows:    6,800

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-13 04:00:00	SPY	ETF	190.01	190.21	190.01	190.21	6853.0
2014-05-13 05:00:00	SPY	ETF	190.18	190.18	190.0	190.0	11572.0
2014-05-13 06:00:00	SPY	ETF	189.95	190.19	189.95	190.12	42374.0
2014-05-13 07:00:00	SPY	ETF	190.11	190.24	190.1	190.17	161746.0
2014-05-13 08:00:00	SPY	ETF	190.13	190.23	189.23	189.97	791082.0
2014-05-13 09:00:00	SPY	ETF	189.97	190.29	189.84	189.9946	12181132.0
2014-05-13 10:00:00	SPY	ETF	190.01	190.42	189.96	190.21	10611084.0
2014-05-13 11:00:00	SPY	ETF	190.205	190.25	189.81	189.905	9396690.0
2014-05-13 12:00:00	SPY	ETF	189.9043	190.115	189.82	190.015	5495859.0
2014-05-13 13:00:00	SPY	ETF	190.01	190.07	189.81	189.92	5095012.0
2014-05-13 14:00:00	SPY	ETF	189.92	190.09	189.88	190.025	4730861.0
2014-05-13 15:00:00	SPY	ETF	190.025	190.06	189.77	189.95	14438090.0
2014-05-13 16:00:00	SPY	ETF	189.95	190.05	189.9384	190.02	3126417.0
2014-05-13 17:00:00	SPY	ETF	190.02	190.05	189.98	190.03	222353.0
2014-05-13 18:00:00	SPY	ETF	190.0	190.0	189.95	189.97	26135.0
2014-05-13 19:00:00	SPY	ETF	189.96	190.03	189.96	189.99	20860.0
2014-05-13 04:00:00	QQQ	ETF	88.4	88.4	88.4	88.4	1200.0
2014-05-13 05:00:00	QQQ	ETF	88.31	88.31	88.29	88.29	1700.0
2014-05-13 06:00:00	QQQ	ETF	88.34	88.34	88.33	88.33	400.0
2014-05-13 07:00:00	QQQ	ETF	88.35	88.46	88.35	88.44	67520.0
2014-05-13 08:00:00	QQQ	ETF	88.44	88.46	88.24	88.3	161083.0
2014-05-13 09:00:00	QQQ	ETF	88.3	88.5201	88.12	88.26	6303960.0
2014-05-13 10:00:00	QQQ	ETF	88.27	88.61	88.24	88.48	4552433.0
2014-05-13 11:00:00	QQQ	ETF	88.485	88.51	88.12	88.23	4010918.0
2014-05-13 12:00:00	QQQ	ETF	88.23	88.35	88.15	88.3	2628504.0
2014-05-13 13:00:00	QQQ	ETF	88.3	88.37	88.17	88.2501	1783218.0
2014-05-13 14:00:00	QQQ	ETF	88.255	88.4149	88.21	88.3715	1474287.0
2014-05-13 15:00:00	QQQ	ETF	88.37	88.39	88.17	88.28	3185314.0
2014-05-13 16:00:00	QQQ	ETF	88.28	88.3525	88.21	88.25	4192290.0
2014-05-13 17:00:00	QQQ	ETF	88.25	88.26	88.23	88.23	14400.0
2014-05-13 18:00:00	QQQ	ETF	88.25	88.25	88.2	88.2	9230.0
2014-05-13 19:00:00	QQQ	ETF	88.24	88.24	88.24	88.24	4400.0
2014-05-13 06:00:00	IWM	ETF	112.75	112.75	112.7	112.7	300.0
2014-05-13 07:00:00	IWM	ETF	112.73	112.81	112.65	112.74	72469.0
2014-05-13 08:00:00	IWM	ETF	112.85	112.85	112.28	112.39	355528.0
2014-05-13 09:00:00	IWM	ETF	112.38	112.77	112.22	112.3	5773529.0
2014-05-13 10:00:00	IWM	ETF	112.31	112.85	112.17	112.34	4989731.0
2014-05-13 11:00:00	IWM	ETF	112.35	112.42	111.47	111.64	6165252.0
2014-05-13 12:00:00	IWM	ETF	111.63	111.96	111.5	111.81	3318024.0
2014-05-13 13:00:00	IWM	ETF	111.82	112.0	111.51	111.64	3146055.0
2014-05-13 14:00:00	IWM	ETF	111.63	111.96	111.5701	111.699	2614990.0
2014-05-13 15:00:00	IWM	ETF	111.69	111.8	111.34	111.44	6270997.0
2014-05-13 16:00:00	IWM	ETF	111.44	112.09	111.3	111.35	9023107.0
2014-05-13 17:00:00	IWM	ETF	111.35	111.42	111.35	111.35	13925.0
2014-05-13 18:00:00	IWM	ETF	111.33	111.35	111.33	111.35	2900.0
2014-05-13 19:00:00	IWM	ETF	111.35	111.36	111.33	111.35	3700.0
2014-05-13 07:00:00	DIA	ETF	167.23	167.23	167.23	167.23	100.0
2014-05-13 08:00:00	DIA	ETF	167.23	167.25	166.97	167.05	5929.0
2014-05-13 09:00:00	DIA	ETF	167.06	167.23	166.98	167.13	1534276.0
2014-05-13 10:00:00	DIA	ETF	167.16	167.29	167.1	167.14	459793.0

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

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