PREVIEW / etf_1hour / 2014-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-03.parquet
  size:    225 KB
  rows:    7,151

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-03 04:00:00	SPY	ETF	185.1	185.1	184.6	184.6	66880.0
2014-03-03 05:00:00	SPY	ETF	184.74	184.87	184.46	184.52	149519.0
2014-03-03 06:00:00	SPY	ETF	184.5	184.5	184.1	184.19	328063.0
2014-03-03 07:00:00	SPY	ETF	184.17	184.8	184.09	184.77	1272790.0
2014-03-03 08:00:00	SPY	ETF	184.76	184.95	184.18	184.69	3623421.0
2014-03-03 09:00:00	SPY	ETF	184.69	186.29	184.41	185.15	21162158.0
2014-03-03 10:00:00	SPY	ETF	185.17	185.45	184.47	185.06	27146905.0
2014-03-03 11:00:00	SPY	ETF	185.065	185.1	184.05	184.05	20086649.0
2014-03-03 12:00:00	SPY	ETF	184.06	184.54	183.75	184.465	21501811.0
2014-03-03 13:00:00	SPY	ETF	184.46	185.015	184.4401	184.89	12417524.0
2014-03-03 14:00:00	SPY	ETF	184.8905	185.22	184.56	184.95	14260504.0
2014-03-03 15:00:00	SPY	ETF	184.93	184.96	184.33	184.93	28554949.0
2014-03-03 16:00:00	SPY	ETF	184.95	186.2766	184.3575	184.9	14141738.0
2014-03-03 17:00:00	SPY	ETF	184.91	184.94	184.86	184.93	41065.0
2014-03-03 18:00:00	SPY	ETF	184.93	185.02	184.9	185.01	98866.0
2014-03-03 19:00:00	SPY	ETF	185.0	185.14	184.98	185.11	200452.0
2014-03-03 04:00:00	QQQ	ETF	89.68	89.68	89.49	89.53	8916.0
2014-03-03 05:00:00	QQQ	ETF	89.55	89.61	89.4	89.41	31700.0
2014-03-03 06:00:00	QQQ	ETF	89.36	89.37	89.29	89.3	281773.0
2014-03-03 07:00:00	QQQ	ETF	89.28	89.56	89.26	89.54	128646.0
2014-03-03 08:00:00	QQQ	ETF	89.54	89.63	89.28	89.51	479795.0
2014-03-03 09:00:00	QQQ	ETF	89.51	89.86	89.27	89.7899	6516356.0
2014-03-03 10:00:00	QQQ	ETF	89.79	89.91	89.285	89.71	7796338.0
2014-03-03 11:00:00	QQQ	ETF	89.715	89.72	89.081	89.081	4213491.0
2014-03-03 12:00:00	QQQ	ETF	89.09	89.31	88.87	89.28	5141383.0
2014-03-03 13:00:00	QQQ	ETF	89.281	89.5099	89.28	89.46	2078703.0
2014-03-03 14:00:00	QQQ	ETF	89.46	89.76	89.38	89.6	2687506.0
2014-03-03 15:00:00	QQQ	ETF	89.59	89.65	89.28	89.65	5192941.0
2014-03-03 16:00:00	QQQ	ETF	89.66	90.3153	89.0811	89.69	1482684.0
2014-03-03 17:00:00	QQQ	ETF	89.68	90.3153	89.62	89.62	259949.0
2014-03-03 18:00:00	QQQ	ETF	89.7	89.72	89.68	89.71	4805.0
2014-03-03 19:00:00	QQQ	ETF	89.73	89.78	89.71	89.74	55835.0
2014-03-03 04:00:00	IWM	ETF	116.38	116.39	116.1	116.21	2450.0
2014-03-03 05:00:00	IWM	ETF	116.22	116.22	116.16	116.18	25600.0
2014-03-03 06:00:00	IWM	ETF	116.05	116.05	115.74	115.96	10650.0
2014-03-03 07:00:00	IWM	ETF	115.5	116.26	115.5	116.25	130409.0
2014-03-03 08:00:00	IWM	ETF	116.23	116.37	116.02	116.26	354338.0
2014-03-03 09:00:00	IWM	ETF	116.27	117.52	116.19	116.592	6372153.0
2014-03-03 10:00:00	IWM	ETF	116.6	116.78	115.93	116.38	10619368.0
2014-03-03 11:00:00	IWM	ETF	116.39	116.43	115.78	115.78	5528973.0
2014-03-03 12:00:00	IWM	ETF	115.78	116.43	115.58	116.4	5734860.0
2014-03-03 13:00:00	IWM	ETF	116.39	117.04	116.385	116.91	4028182.0
2014-03-03 14:00:00	IWM	ETF	116.92	117.26	116.65	116.98	4973530.0
2014-03-03 15:00:00	IWM	ETF	116.99	117.085	116.63	116.89	6424040.0
2014-03-03 16:00:00	IWM	ETF	116.9	117.5231	116.25	116.91	980642.0
2014-03-03 17:00:00	IWM	ETF	116.9	116.9	116.9	116.9	250.0
2014-03-03 18:00:00	IWM	ETF	116.92	116.97	116.9	116.9	1669.0
2014-03-03 19:00:00	IWM	ETF	116.95	116.99	116.95	116.98	4550.0
2014-03-03 05:00:00	DIA	ETF	162.8	162.8	161.75	161.75	6000.0
2014-03-03 06:00:00	DIA	ETF	161.69	161.73	161.45	161.5	31780.0

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

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