PREVIEW / etf_1hour / 2014-05-22

all etf 1-hour files

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

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-22 04:00:00	SPY	ETF	189.23	189.37	189.22	189.29	5446.0
2014-05-22 05:00:00	SPY	ETF	189.19	189.39	189.16	189.23	5750.0
2014-05-22 06:00:00	SPY	ETF	189.19	189.31	189.15	189.17	64886.0
2014-05-22 07:00:00	SPY	ETF	189.17	189.18	189.01	189.15	139220.0
2014-05-22 08:00:00	SPY	ETF	189.12	189.47	189.04	189.2	486680.0
2014-05-22 09:00:00	SPY	ETF	189.18	189.55	188.86	189.43	9993532.0
2014-05-22 10:00:00	SPY	ETF	189.45	189.7	189.12	189.62	10683981.0
2014-05-22 11:00:00	SPY	ETF	189.62	189.95	189.54	189.77	8985172.0
2014-05-22 12:00:00	SPY	ETF	189.77	189.83	189.64	189.67	7219005.0
2014-05-22 13:00:00	SPY	ETF	189.67	189.96	189.67	189.875	4103734.0
2014-05-22 14:00:00	SPY	ETF	189.87	189.98	189.83	189.975	4473587.0
2014-05-22 15:00:00	SPY	ETF	189.97	189.97	189.58	189.595	12754733.0
2014-05-22 16:00:00	SPY	ETF	189.59	189.77	189.4962	189.6	2174211.0
2014-05-22 17:00:00	SPY	ETF	189.61	189.64	189.57	189.63	15349.0
2014-05-22 18:00:00	SPY	ETF	189.6	189.64	189.59	189.64	16230.0
2014-05-22 19:00:00	SPY	ETF	189.64	189.64	189.6	189.63	13242.0
2014-05-22 04:00:00	QQQ	ETF	88.91	88.98	88.91	88.98	400.0
2014-05-22 05:00:00	QQQ	ETF	88.96	89.0	88.93	88.93	23771.0
2014-05-22 06:00:00	QQQ	ETF	88.87	88.95	88.87	88.93	4500.0
2014-05-22 07:00:00	QQQ	ETF	88.9	88.92	88.88	88.92	2700.0
2014-05-22 08:00:00	QQQ	ETF	88.92	89.01	88.89	88.92	169234.0
2014-05-22 09:00:00	QQQ	ETF	88.93	89.2	88.83	89.13	4199659.0
2014-05-22 10:00:00	QQQ	ETF	89.14	89.27	88.8	89.22	6838438.0
2014-05-22 11:00:00	QQQ	ETF	89.22	89.39	89.15	89.3	4135782.0
2014-05-22 12:00:00	QQQ	ETF	89.3	89.32	89.18	89.2099	1325717.0
2014-05-22 13:00:00	QQQ	ETF	89.21	89.435	89.2	89.38	2177718.0
2014-05-22 14:00:00	QQQ	ETF	89.39	89.48	89.37	89.475	1687432.0
2014-05-22 15:00:00	QQQ	ETF	89.47	89.47	89.22	89.22	5193530.0
2014-05-22 16:00:00	QQQ	ETF	89.22	89.24	89.18	89.21	1902968.0
2014-05-22 17:00:00	QQQ	ETF	89.21	89.24	89.19	89.24	3612.0
2014-05-22 18:00:00	QQQ	ETF	89.2	89.21	89.2	89.21	400.0
2014-05-22 19:00:00	QQQ	ETF	89.22	89.25	89.21	89.22	11010.0
2014-05-22 04:00:00	IWM	ETF	110.07	110.07	110.04	110.04	300.0
2014-05-22 05:00:00	IWM	ETF	110.06	110.06	110.06	110.06	500.0
2014-05-22 07:00:00	IWM	ETF	109.94	109.95	109.81	109.95	4000.0
2014-05-22 08:00:00	IWM	ETF	109.96	110.09	109.9	110.05	275878.0
2014-05-22 09:00:00	IWM	ETF	109.99	110.54	109.62	110.33	4945210.0
2014-05-22 10:00:00	IWM	ETF	110.329	110.75	109.8	110.69	7220112.0
2014-05-22 11:00:00	IWM	ETF	110.69	111.05	110.57	110.92	4228300.0
2014-05-22 12:00:00	IWM	ETF	110.91	110.955	110.6	110.64	2156563.0
2014-05-22 13:00:00	IWM	ETF	110.65	111.01	110.65	110.9	2103330.0
2014-05-22 14:00:00	IWM	ETF	110.89	111.04	110.83	111.02	1725923.0
2014-05-22 15:00:00	IWM	ETF	111.0201	111.025	110.65	110.75	7934459.0
2014-05-22 16:00:00	IWM	ETF	110.75	110.9367	110.3969	110.67	3650383.0
2014-05-22 17:00:00	IWM	ETF	110.65	110.65	110.6	110.61	100900.0
2014-05-22 18:00:00	IWM	ETF	110.65	110.65	110.65	110.65	250.0
2014-05-22 08:00:00	DIA	ETF	165.02	165.05	164.99	165.05	2270.0
2014-05-22 09:00:00	DIA	ETF	165.05	165.2799	164.6	165.16	609996.0
2014-05-22 10:00:00	DIA	ETF	165.15	165.36	164.92	165.3	454031.0
2014-05-22 11:00:00	DIA	ETF	165.29	165.38	165.17	165.2401	726696.0

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

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