PREVIEW / etf_1hour / 2016-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-12.parquet
  size:    248 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-05-12 04:00:00	SPY	ETF	206.87	207.13	206.77	207.13	9746.0
2016-05-12 05:00:00	SPY	ETF	207.21	207.63	207.05	207.55	31679.0
2016-05-12 06:00:00	SPY	ETF	207.56	207.58	207.28	207.5	184596.0
2016-05-12 07:00:00	SPY	ETF	207.5	207.75	207.34	207.7	313969.0
2016-05-12 08:00:00	SPY	ETF	207.7	207.73	206.7	207.42	1169864.0
2016-05-12 09:00:00	SPY	ETF	207.42	207.4899	206.62	206.63	10106314.0
2016-05-12 10:00:00	SPY	ETF	206.63	206.98	206.16	206.35	13256482.0
2016-05-12 11:00:00	SPY	ETF	206.34	206.39	205.5	205.53	11984044.0
2016-05-12 12:00:00	SPY	ETF	205.53	206.1	205.37	206.095	9385995.0
2016-05-12 13:00:00	SPY	ETF	206.1	206.34	205.66	206.3	7367025.0
2016-05-12 14:00:00	SPY	ETF	206.3	207.18	206.29	206.955	12255663.0
2016-05-12 15:00:00	SPY	ETF	206.96	207.05	206.28	206.56	16319015.0
2016-05-12 16:00:00	SPY	ETF	206.57	206.59	205.5159	206.51	4773478.0
2016-05-12 17:00:00	SPY	ETF	206.51	206.54	206.47	206.51	136803.0
2016-05-12 18:00:00	SPY	ETF	206.48	206.48	206.36	206.42	71626.0
2016-05-12 19:00:00	SPY	ETF	206.42	206.55	206.41	206.55	149556.0
2016-05-12 04:00:00	QQQ	ETF	106.46	106.75	106.46	106.75	1396.0
2016-05-12 05:00:00	QQQ	ETF	106.73	106.91	106.73	106.91	1398.0
2016-05-12 07:00:00	QQQ	ETF	106.89	106.92	106.81	106.92	27878.0
2016-05-12 08:00:00	QQQ	ETF	106.85	106.9	106.71	106.72	84499.0
2016-05-12 09:00:00	QQQ	ETF	106.69	106.74	106.03	106.035	3867016.0
2016-05-12 10:00:00	QQQ	ETF	106.04	106.25	105.65	105.72	4884898.0
2016-05-12 11:00:00	QQQ	ETF	105.71	105.76	105.17	105.26	3697598.0
2016-05-12 12:00:00	QQQ	ETF	105.2525	105.58	105.14	105.5793	2620473.0
2016-05-12 13:00:00	QQQ	ETF	105.58	105.77	105.2907	105.75	2213261.0
2016-05-12 14:00:00	QQQ	ETF	105.752	106.44	105.752	106.29	2928891.0
2016-05-12 15:00:00	QQQ	ETF	106.28	106.325	105.78	105.9	3615241.0
2016-05-12 16:00:00	QQQ	ETF	105.91	105.93	105.7249	105.87	465515.0
2016-05-12 17:00:00	QQQ	ETF	105.9	105.92	105.85	105.85	6911.0
2016-05-12 18:00:00	QQQ	ETF	105.85	105.87	105.8	105.81	27518.0
2016-05-12 19:00:00	QQQ	ETF	105.83	105.91	105.83	105.9	22348.0
2016-05-12 05:00:00	IWM	ETF	111.26	111.26	111.21	111.21	1300.0
2016-05-12 06:00:00	IWM	ETF	111.38	111.39	111.38	111.38	5425.0
2016-05-12 07:00:00	IWM	ETF	111.29	111.47	111.29	111.47	36040.0
2016-05-12 08:00:00	IWM	ETF	111.47	111.47	111.26	111.26	118213.0
2016-05-12 09:00:00	IWM	ETF	111.28	111.49	110.93	110.94	2590402.0
2016-05-12 10:00:00	IWM	ETF	110.935	111.22	110.44	110.58	2945516.0
2016-05-12 11:00:00	IWM	ETF	110.57	110.59	109.94	110.01	4864121.0
2016-05-12 12:00:00	IWM	ETF	110.0	110.14	109.7	109.99	3916159.0
2016-05-12 13:00:00	IWM	ETF	109.99	110.02	109.498	109.99	4497397.0
2016-05-12 14:00:00	IWM	ETF	109.99	110.67	109.95	110.52	4582256.0
2016-05-12 15:00:00	IWM	ETF	110.51	110.545	110.25	110.37	5091843.0
2016-05-12 16:00:00	IWM	ETF	110.35	110.3708	110.12	110.22	1263861.0
2016-05-12 17:00:00	IWM	ETF	110.21	110.24	110.18	110.21	9723.0
2016-05-12 18:00:00	IWM	ETF	110.24	110.24	110.19	110.19	500.0
2016-05-12 19:00:00	IWM	ETF	110.19	110.22	110.19	110.22	4300.0
2016-05-12 04:00:00	DIA	ETF	177.6	177.64	177.6	177.64	400.0
2016-05-12 07:00:00	DIA	ETF	178.11	178.11	178.0	178.0	3000.0
2016-05-12 08:00:00	DIA	ETF	178.1	178.1	177.9	177.9	4226.0
2016-05-12 09:00:00	DIA	ETF	177.92	178.12	177.48	177.49	397851.0

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

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