PREVIEW / etf_1hour / 2014-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-25.parquet
  size:    216 KB
  rows:    6,792

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-25 04:00:00	SPY	ETF	185.38	185.74	185.38	185.48	7225.0
2014-03-25 05:00:00	SPY	ETF	185.46	185.8	185.46	185.76	19774.0
2014-03-25 06:00:00	SPY	ETF	185.74	185.8	185.64	185.75	53340.0
2014-03-25 07:00:00	SPY	ETF	185.78	186.12	185.68	186.0	254680.0
2014-03-25 08:00:00	SPY	ETF	186.01	186.34	185.98	186.3	549679.0
2014-03-25 09:00:00	SPY	ETF	186.28	186.76	186.19	186.58	12712052.0
2014-03-25 10:00:00	SPY	ETF	186.59	186.94	185.65	185.76	21657071.0
2014-03-25 11:00:00	SPY	ETF	185.755	186.14	185.34	185.63	14023146.0
2014-03-25 12:00:00	SPY	ETF	185.625	186.07	185.27	185.97	10828294.0
2014-03-25 13:00:00	SPY	ETF	185.97	186.54	185.88	186.335	12157962.0
2014-03-25 14:00:00	SPY	ETF	186.33	186.56	186.1	186.2	9074642.0
2014-03-25 15:00:00	SPY	ETF	186.2	186.55	186.14	186.34	16466142.0
2014-03-25 16:00:00	SPY	ETF	186.34	186.45	186.2701	186.37	3779625.0
2014-03-25 17:00:00	SPY	ETF	186.37	186.44	186.369	186.43	216324.0
2014-03-25 18:00:00	SPY	ETF	186.41	186.58	186.35	186.57	238607.0
2014-03-25 19:00:00	SPY	ETF	186.57	186.68	186.57	186.68	156528.0
2014-03-25 04:00:00	QQQ	ETF	88.21	88.42	88.21	88.33	22874.0
2014-03-25 05:00:00	QQQ	ETF	88.36	88.43	88.36	88.43	2900.0
2014-03-25 06:00:00	QQQ	ETF	88.4	88.44	88.38	88.44	2900.0
2014-03-25 07:00:00	QQQ	ETF	88.4	88.54	88.38	88.54	18960.0
2014-03-25 08:00:00	QQQ	ETF	88.53	88.68	88.37	88.67	96072.0
2014-03-25 09:00:00	QQQ	ETF	88.65	89.03	88.59	89.0	5269759.0
2014-03-25 10:00:00	QQQ	ETF	89.01	89.25	88.13	88.22	9893260.0
2014-03-25 11:00:00	QQQ	ETF	88.22	88.53	87.8	87.979	6235284.0
2014-03-25 12:00:00	QQQ	ETF	87.97	88.39	87.7701	88.31	6493159.0
2014-03-25 13:00:00	QQQ	ETF	88.31	88.66	88.2144	88.49	3662996.0
2014-03-25 14:00:00	QQQ	ETF	88.5	88.66	88.34	88.43	2646090.0
2014-03-25 15:00:00	QQQ	ETF	88.435	88.65	88.37	88.52	5104310.0
2014-03-25 16:00:00	QQQ	ETF	88.51	88.6	88.3016	88.57	1632020.0
2014-03-25 17:00:00	QQQ	ETF	88.57	88.6	88.51	88.58	147275.0
2014-03-25 18:00:00	QQQ	ETF	88.56	88.64	88.55	88.64	41450.0
2014-03-25 19:00:00	QQQ	ETF	88.64	88.71	88.64	88.71	9958.0
2014-03-25 05:00:00	IWM	ETF	117.05	117.05	117.05	117.05	2000.0
2014-03-25 06:00:00	IWM	ETF	117.0	117.0	117.0	117.0	200.0
2014-03-25 07:00:00	IWM	ETF	117.05	117.39	117.05	117.34	111070.0
2014-03-25 08:00:00	IWM	ETF	117.31	117.6	117.31	117.55	246212.0
2014-03-25 09:00:00	IWM	ETF	117.54	118.25	117.48	117.8	6246120.0
2014-03-25 10:00:00	IWM	ETF	117.8	118.31	116.97	117.06	8541403.0
2014-03-25 11:00:00	IWM	ETF	117.06	117.36	116.32	116.57	6482410.0
2014-03-25 12:00:00	IWM	ETF	116.57	116.9	116.14	116.77	6491752.0
2014-03-25 13:00:00	IWM	ETF	116.76	117.28	116.69	117.0	3504540.0
2014-03-25 14:00:00	IWM	ETF	117.005	117.315	116.7	116.77	3780985.0
2014-03-25 15:00:00	IWM	ETF	116.77	117.09	116.715	116.92	5133470.0
2014-03-25 16:00:00	IWM	ETF	116.92	116.94	116.7559	116.83	1142288.0
2014-03-25 17:00:00	IWM	ETF	116.87	116.93	116.84	116.84	68100.0
2014-03-25 18:00:00	IWM	ETF	116.98	117.0	116.84	117.0	11428.0
2014-03-25 19:00:00	IWM	ETF	117.03	117.1	117.03	117.1	5650.0
2014-03-25 04:00:00	DIA	ETF	162.39	162.39	162.39	162.39	200.0
2014-03-25 07:00:00	DIA	ETF	163.0	163.0	163.0	163.0	100.0
2014-03-25 08:00:00	DIA	ETF	163.28	163.33	163.05	163.33	908.0

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

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