PREVIEW / etf_1hour / 2016-02-29

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-29.parquet
  size:    249 KB
  rows:    7,958

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
2016-02-29 04:00:00	SPY	ETF	193.91	193.94	193.45	193.6	57876.0
2016-02-29 05:00:00	SPY	ETF	193.75	194.64	193.75	193.97	58316.0
2016-02-29 06:00:00	SPY	ETF	193.97	194.66	193.78	194.53	170544.0
2016-02-29 07:00:00	SPY	ETF	194.51	194.91	194.35	194.58	193910.0
2016-02-29 08:00:00	SPY	ETF	194.53	195.39	193.9989	195.29	1597496.0
2016-02-29 09:00:00	SPY	ETF	195.29	195.38	194.71	195.1092	9786700.0
2016-02-29 10:00:00	SPY	ETF	195.1	195.39	194.72	195.31	12377364.0
2016-02-29 11:00:00	SPY	ETF	195.31	196.23	195.31	195.93	12299160.0
2016-02-29 12:00:00	SPY	ETF	195.93	196.03	195.54	195.82	8751635.0
2016-02-29 13:00:00	SPY	ETF	195.82	195.88	195.3	195.52	6977174.0
2016-02-29 14:00:00	SPY	ETF	195.52	195.55	194.3	194.38	21341961.0
2016-02-29 15:00:00	SPY	ETF	194.38	194.3992	193.44	193.48	33052951.0
2016-02-29 16:00:00	SPY	ETF	193.48	195.1652	193.32	193.5	15464170.0
2016-02-29 17:00:00	SPY	ETF	193.51	195.755	193.44	193.48	783433.0
2016-02-29 18:00:00	SPY	ETF	193.48	193.96	193.38	193.81	327522.0
2016-02-29 19:00:00	SPY	ETF	193.81	193.93	193.24	193.24	160595.0
2016-02-29 04:00:00	QQQ	ETF	102.34	102.44	102.29	102.3	1601.0
2016-02-29 05:00:00	QQQ	ETF	102.37	102.8	102.37	102.54	8608.0
2016-02-29 06:00:00	QQQ	ETF	102.65	102.95	102.47	102.95	6297.0
2016-02-29 07:00:00	QQQ	ETF	102.85	103.16	102.85	103.01	24610.0
2016-02-29 08:00:00	QQQ	ETF	102.97	103.43	102.96	103.4	113467.0
2016-02-29 09:00:00	QQQ	ETF	103.4	103.73	103.19	103.58	3513373.0
2016-02-29 10:00:00	QQQ	ETF	103.58	103.73	103.34	103.6599	3906512.0
2016-02-29 11:00:00	QQQ	ETF	103.66	104.1	103.58	103.99	2485005.0
2016-02-29 12:00:00	QQQ	ETF	103.98	104.06	103.75	103.94	1475391.0
2016-02-29 13:00:00	QQQ	ETF	103.95	103.97	103.51	103.61	1304306.0
2016-02-29 14:00:00	QQQ	ETF	103.61	103.63	102.965	103.0601	3483026.0
2016-02-29 15:00:00	QQQ	ETF	103.06	103.06	102.53	102.54	7686425.0
2016-02-29 16:00:00	QQQ	ETF	102.55	102.73	102.48	102.57	1132332.0
2016-02-29 17:00:00	QQQ	ETF	102.6	102.63	102.56	102.56	15522.0
2016-02-29 18:00:00	QQQ	ETF	102.57	102.84	102.48	102.79	47479.0
2016-02-29 19:00:00	QQQ	ETF	102.84	102.84	102.5	102.5	49177.0
2016-02-29 04:00:00	IWM	ETF	102.34	102.37	102.24	102.37	12200.0
2016-02-29 05:00:00	IWM	ETF	102.72	102.8	102.57	102.63	11340.0
2016-02-29 06:00:00	IWM	ETF	102.52	102.87	102.52	102.85	730.0
2016-02-29 07:00:00	IWM	ETF	102.83	103.07	102.83	102.92	11603.0
2016-02-29 08:00:00	IWM	ETF	102.96	103.24	102.88	103.22	30491.0
2016-02-29 09:00:00	IWM	ETF	103.22	103.45	103.0	103.25	3069240.0
2016-02-29 10:00:00	IWM	ETF	103.25	103.7	103.11	103.69	3733829.0
2016-02-29 11:00:00	IWM	ETF	103.69	104.03	103.65	103.88	2824364.0
2016-02-29 12:00:00	IWM	ETF	103.88	103.98	103.73	103.86	2192763.0
2016-02-29 13:00:00	IWM	ETF	103.87	103.91	103.571	103.7	1781475.0
2016-02-29 14:00:00	IWM	ETF	103.7	103.72	103.065	103.14	2989522.0
2016-02-29 15:00:00	IWM	ETF	103.1301	103.17	102.74	102.76	8921588.0
2016-02-29 16:00:00	IWM	ETF	102.76	103.589	102.71	102.88	4377255.0
2016-02-29 17:00:00	IWM	ETF	102.87	102.89	102.87	102.89	3700.0
2016-02-29 18:00:00	IWM	ETF	102.95	102.99	102.95	102.99	800.0
2016-02-29 19:00:00	IWM	ETF	102.91	102.95	102.73	102.74	4798.0
2016-02-29 07:00:00	DIA	ETF	165.85	165.86	165.85	165.86	1000.0
2016-02-29 08:00:00	DIA	ETF	165.96	166.32	165.85	166.3	4005.0

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

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