PREVIEW / etf_1hour / 2016-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-29.parquet
  size:    264 KB
  rows:    8,392

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-06-29 04:00:00	SPY	ETF	203.82	204.34	203.82	204.2	65655.0
2016-06-29 05:00:00	SPY	ETF	204.3	204.38	204.16	204.3	33306.0
2016-06-29 06:00:00	SPY	ETF	204.4	204.8	204.4	204.52	118353.0
2016-06-29 07:00:00	SPY	ETF	204.53	204.67	204.24	204.65	485186.0
2016-06-29 08:00:00	SPY	ETF	204.64	204.99	203.22	204.88	1511349.0
2016-06-29 09:00:00	SPY	ETF	204.86	205.24	204.6	205.0	17652187.0
2016-06-29 10:00:00	SPY	ETF	205.0	205.74	204.91	205.575	20658741.0
2016-06-29 11:00:00	SPY	ETF	205.58	206.245	205.575	206.12	14521078.0
2016-06-29 12:00:00	SPY	ETF	206.11	206.43	206.02	206.07	11694732.0
2016-06-29 13:00:00	SPY	ETF	206.08	206.26	205.8845	206.2468	7744734.0
2016-06-29 14:00:00	SPY	ETF	206.25	206.73	206.2	206.63	14752313.0
2016-06-29 15:00:00	SPY	ETF	206.63	206.93	206.43	206.67	32235038.0
2016-06-29 16:00:00	SPY	ETF	206.68	207.93	206.64	207.84	11351980.0
2016-06-29 17:00:00	SPY	ETF	207.82	208.4866	206.4866	207.57	1049212.0
2016-06-29 18:00:00	SPY	ETF	207.56	207.7	207.39	207.39	263396.0
2016-06-29 19:00:00	SPY	ETF	207.4	207.42	207.16	207.26	238545.0
2016-06-29 04:00:00	QQQ	ETF	104.96	105.08	104.95	105.08	2442.0
2016-06-29 05:00:00	QQQ	ETF	105.01	105.01	104.95	104.99	1900.0
2016-06-29 06:00:00	QQQ	ETF	105.17	105.33	105.17	105.22	7113.0
2016-06-29 07:00:00	QQQ	ETF	105.17	105.26	105.05	105.25	42393.0
2016-06-29 08:00:00	QQQ	ETF	105.25	105.34	105.05	105.31	263862.0
2016-06-29 09:00:00	QQQ	ETF	105.27	105.735	105.18	105.63	3932664.0
2016-06-29 10:00:00	QQQ	ETF	105.63	105.8599	105.51	105.66	6998615.0
2016-06-29 11:00:00	QQQ	ETF	105.66	106.17	105.66	106.14	3462288.0
2016-06-29 12:00:00	QQQ	ETF	106.1268	106.32	106.08	106.12	2806981.0
2016-06-29 13:00:00	QQQ	ETF	106.12	106.26	106.03	106.25	1431630.0
2016-06-29 14:00:00	QQQ	ETF	106.24	106.47	106.22	106.4	2791907.0
2016-06-29 15:00:00	QQQ	ETF	106.4	106.53	106.18	106.29	5597493.0
2016-06-29 16:00:00	QQQ	ETF	106.29	106.82	106.28	106.81	1348243.0
2016-06-29 17:00:00	QQQ	ETF	106.82	106.86	106.57	106.66	19643.0
2016-06-29 18:00:00	QQQ	ETF	106.73	106.75	106.65	106.65	83234.0
2016-06-29 19:00:00	QQQ	ETF	106.64	106.65	106.51	106.55	13764.0
2016-06-29 04:00:00	IWM	ETF	111.18	111.24	111.18	111.24	10098.0
2016-06-29 06:00:00	IWM	ETF	111.5	111.67	111.5	111.59	530.0
2016-06-29 07:00:00	IWM	ETF	111.54	111.65	111.42	111.62	51405.0
2016-06-29 08:00:00	IWM	ETF	111.66	111.81	111.57	111.76	142530.0
2016-06-29 09:00:00	IWM	ETF	111.71	112.18	111.53	112.0	4150095.0
2016-06-29 10:00:00	IWM	ETF	111.99	112.19	111.75	112.07	3974821.0
2016-06-29 11:00:00	IWM	ETF	112.07	112.74	112.06	112.55	4621929.0
2016-06-29 12:00:00	IWM	ETF	112.55	112.65	112.28	112.29	2683387.0
2016-06-29 13:00:00	IWM	ETF	112.29	112.7	112.15	112.65	2872819.0
2016-06-29 14:00:00	IWM	ETF	112.66	113.05	112.62	112.91	3612172.0
2016-06-29 15:00:00	IWM	ETF	112.91	113.05	112.74	112.89	5219118.0
2016-06-29 16:00:00	IWM	ETF	112.91	113.4	112.84	113.4	1230245.0
2016-06-29 17:00:00	IWM	ETF	113.41	113.41	113.06	113.12	37451.0
2016-06-29 18:00:00	IWM	ETF	113.16	113.16	113.16	113.16	400.0
2016-06-29 19:00:00	IWM	ETF	113.2	113.2	113.09	113.09	3150.0
2016-06-29 04:00:00	DIA	ETF	174.0	174.0	174.0	174.0	155.0
2016-06-29 05:00:00	DIA	ETF	174.49	174.49	174.49	174.49	499.0
2016-06-29 06:00:00	DIA	ETF	174.65	174.93	174.65	174.85	1200.0

> showing 50 of 8,392 rows — these rows as CSV

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