PREVIEW / etf_1hour / 2014-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-05.parquet
  size:    234 KB
  rows:    7,424

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-12-05 04:00:00	SPY	ETF	207.95	207.95	207.95	207.95	150.0
2014-12-05 05:00:00	SPY	ETF	207.85	207.94	207.85	207.91	1900.0
2014-12-05 06:00:00	SPY	ETF	207.95	208.01	207.89	207.98	31604.0
2014-12-05 07:00:00	SPY	ETF	207.96	208.05	207.88	207.95	286001.0
2014-12-05 08:00:00	SPY	ETF	207.95	208.28	207.46	207.79	5066189.0
2014-12-05 09:00:00	SPY	ETF	207.79	208.17	207.55	208.07	11701240.0
2014-12-05 10:00:00	SPY	ETF	208.06	208.24	207.78	207.91	11956287.0
2014-12-05 11:00:00	SPY	ETF	207.915	208.47	207.915	208.34	9320562.0
2014-12-05 12:00:00	SPY	ETF	208.33	208.43	208.2332	208.34	6534666.0
2014-12-05 13:00:00	SPY	ETF	208.33	208.39	208.13	208.2235	7020923.0
2014-12-05 14:00:00	SPY	ETF	208.22	208.25	207.84	207.9	7627605.0
2014-12-05 15:00:00	SPY	ETF	207.9	208.08	207.55	208.0	19647143.0
2014-12-05 16:00:00	SPY	ETF	208.02	208.22	208.0	208.009	10161980.0
2014-12-05 17:00:00	SPY	ETF	208.22	208.24	208.06	208.06	154536.0
2014-12-05 18:00:00	SPY	ETF	208.071	208.18	208.071	208.15	5875.0
2014-12-05 19:00:00	SPY	ETF	208.16	208.16	208.11	208.13	15360.0
2014-12-05 05:00:00	QQQ	ETF	105.52	105.52	105.52	105.52	1000.0
2014-12-05 06:00:00	QQQ	ETF	105.57	105.57	105.57	105.57	800.0
2014-12-05 07:00:00	QQQ	ETF	105.57	105.58	105.52	105.55	57000.0
2014-12-05 08:00:00	QQQ	ETF	105.54	105.72	105.35	105.47	473756.0
2014-12-05 09:00:00	QQQ	ETF	105.47	105.7	105.28	105.52	4856773.0
2014-12-05 10:00:00	QQQ	ETF	105.52	105.62	105.31	105.4	4330627.0
2014-12-05 11:00:00	QQQ	ETF	105.39	105.585	105.39	105.52	2314912.0
2014-12-05 12:00:00	QQQ	ETF	105.52	105.61	105.4932	105.525	1390037.0
2014-12-05 13:00:00	QQQ	ETF	105.52	105.52	105.34	105.47	1982687.0
2014-12-05 14:00:00	QQQ	ETF	105.47	105.51	105.3399	105.38	1770984.0
2014-12-05 15:00:00	QQQ	ETF	105.375	105.469	105.145	105.37	4296286.0
2014-12-05 16:00:00	QQQ	ETF	105.38	105.4708	105.2318	105.44	1212327.0
2014-12-05 17:00:00	QQQ	ETF	105.43	105.43	105.39	105.42	2750.0
2014-12-05 18:00:00	QQQ	ETF	105.43	105.44	105.43	105.44	7500.0
2014-12-05 19:00:00	QQQ	ETF	105.41	105.44	105.41	105.44	1700.0
2014-12-05 07:00:00	IWM	ETF	117.14	117.14	117.14	117.14	5000.0
2014-12-05 08:00:00	IWM	ETF	117.11	117.6	116.78	117.37	1379983.0
2014-12-05 09:00:00	IWM	ETF	117.39	117.86	116.96	117.63	4971589.0
2014-12-05 10:00:00	IWM	ETF	117.62	117.79	117.28	117.53	4204086.0
2014-12-05 11:00:00	IWM	ETF	117.53	117.94	117.5299	117.72	2366058.0
2014-12-05 12:00:00	IWM	ETF	117.72	117.98	117.65	117.7099	1461447.0
2014-12-05 13:00:00	IWM	ETF	117.71	117.76	117.56	117.6001	1694432.0
2014-12-05 14:00:00	IWM	ETF	117.6066	117.77	117.4201	117.52	2064909.0
2014-12-05 15:00:00	IWM	ETF	117.51	117.715	117.23	117.7	5517606.0
2014-12-05 16:00:00	IWM	ETF	117.69	117.8	117.6451	117.8	1002742.0
2014-12-05 17:00:00	IWM	ETF	117.85	117.85	117.8	117.8	6940.0
2014-12-05 18:00:00	IWM	ETF	117.7	117.7	117.7	117.7	100.0
2014-12-05 08:00:00	DIA	ETF	179.17	179.35	179.0	179.2	3450.0
2014-12-05 09:00:00	DIA	ETF	179.29	179.38	178.99	179.28	604398.0
2014-12-05 10:00:00	DIA	ETF	179.27	179.55	179.11	179.42	922285.0
2014-12-05 11:00:00	DIA	ETF	179.42	179.82	179.3901	179.75	567754.0
2014-12-05 12:00:00	DIA	ETF	179.75	179.79	179.64	179.7	326861.0
2014-12-05 13:00:00	DIA	ETF	179.71	179.78	179.55	179.63	328157.0
2014-12-05 14:00:00	DIA	ETF	179.605	179.62	179.38	179.4	265572.0

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

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