PREVIEW / etf_1hour / 2014-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-26.parquet
  size:    220 KB
  rows:    6,889

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-03-26 04:00:00	SPY	ETF	186.4	186.55	186.4	186.54	8970.0
2014-03-26 05:00:00	SPY	ETF	186.58	186.82	186.52	186.68	32628.0
2014-03-26 06:00:00	SPY	ETF	186.73	187.0	186.67	187.0	21283.0
2014-03-26 07:00:00	SPY	ETF	186.99	187.08	186.94	187.04	109073.0
2014-03-26 08:00:00	SPY	ETF	187.02	187.21	186.94	187.11	796660.0
2014-03-26 09:00:00	SPY	ETF	187.1	187.34	186.8	186.9	14397032.0
2014-03-26 10:00:00	SPY	ETF	186.9	187.14	186.48	186.54	15351841.0
2014-03-26 11:00:00	SPY	ETF	186.535	186.98	186.42	186.7	8992763.0
2014-03-26 12:00:00	SPY	ETF	186.709	186.81	186.39	186.76	9554322.0
2014-03-26 13:00:00	SPY	ETF	186.77	186.79	185.54	185.88	17099062.0
2014-03-26 14:00:00	SPY	ETF	185.88	186.07	185.42	186.02	15605584.0
2014-03-26 15:00:00	SPY	ETF	186.02	186.09	184.95	184.96	23136266.0
2014-03-26 16:00:00	SPY	ETF	184.96	186.31	184.66	184.93	11091582.0
2014-03-26 17:00:00	SPY	ETF	184.92	185.07	184.88	184.97	2319000.0
2014-03-26 18:00:00	SPY	ETF	184.97	185.01	184.79	184.79	111998.0
2014-03-26 19:00:00	SPY	ETF	184.8	185.0	184.8	184.99	76908.0
2014-03-26 04:00:00	QQQ	ETF	88.61	88.69	88.61	88.69	3113.0
2014-03-26 05:00:00	QQQ	ETF	88.75	88.75	88.75	88.75	500.0
2014-03-26 06:00:00	QQQ	ETF	88.84	88.96	88.84	88.96	14600.0
2014-03-26 07:00:00	QQQ	ETF	88.97	89.02	88.89	88.97	54420.0
2014-03-26 08:00:00	QQQ	ETF	88.97	89.1	88.94	89.03	180677.0
2014-03-26 09:00:00	QQQ	ETF	89.05	89.15	88.67	88.89	5826773.0
2014-03-26 10:00:00	QQQ	ETF	88.88	89.03	88.425	88.44	5066190.0
2014-03-26 11:00:00	QQQ	ETF	88.44	88.769	88.33	88.49	3984126.0
2014-03-26 12:00:00	QQQ	ETF	88.49	88.53	88.24	88.48	3125354.0
2014-03-26 13:00:00	QQQ	ETF	88.47	88.495	87.73	87.97	5569032.0
2014-03-26 14:00:00	QQQ	ETF	87.97	88.13	87.61	88.0999	5285438.0
2014-03-26 15:00:00	QQQ	ETF	88.095	88.14	87.36	87.38	8344250.0
2014-03-26 16:00:00	QQQ	ETF	87.38	88.5047	87.29	87.4	2350355.0
2014-03-26 17:00:00	QQQ	ETF	87.37	87.48	87.37	87.46	288949.0
2014-03-26 18:00:00	QQQ	ETF	87.45	87.45	87.36	87.36	42500.0
2014-03-26 19:00:00	QQQ	ETF	87.38	87.42	87.36	87.42	39940.0
2014-03-26 06:00:00	IWM	ETF	117.24	117.52	117.24	117.52	10900.0
2014-03-26 07:00:00	IWM	ETF	117.51	117.64	117.51	117.64	68459.0
2014-03-26 08:00:00	IWM	ETF	117.6	117.93	117.6	117.75	364236.0
2014-03-26 09:00:00	IWM	ETF	117.82	117.87	116.78	116.86	8903851.0
2014-03-26 10:00:00	IWM	ETF	116.865	117.22	116.26	116.29	7471574.0
2014-03-26 11:00:00	IWM	ETF	116.3	116.68	116.095	116.34	4480290.0
2014-03-26 12:00:00	IWM	ETF	116.34	116.43	115.99	116.35	4337765.0
2014-03-26 13:00:00	IWM	ETF	116.34	116.36	114.99	115.44	11886158.0
2014-03-26 14:00:00	IWM	ETF	115.4401	115.69	115.04	115.63	10029513.0
2014-03-26 15:00:00	IWM	ETF	115.625	115.68	114.65	114.67	12317712.0
2014-03-26 16:00:00	IWM	ETF	114.67	114.77	114.39	114.72	2674616.0
2014-03-26 17:00:00	IWM	ETF	114.72	114.84	114.71	114.74	26859.0
2014-03-26 18:00:00	IWM	ETF	114.82	114.82	114.75	114.82	2800.0
2014-03-26 19:00:00	IWM	ETF	114.68	114.82	114.68	114.72	3521.0
2014-03-26 08:00:00	DIA	ETF	164.0	164.3	164.0	164.1	6411.0
2014-03-26 09:00:00	DIA	ETF	164.14	164.33	163.74	163.83	850452.0
2014-03-26 10:00:00	DIA	ETF	163.81	164.04	163.45	163.51	734357.0
2014-03-26 11:00:00	DIA	ETF	163.51	163.85	163.4	163.61	452603.0

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

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