PREVIEW / etf_1hour / 2016-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-22.parquet
  size:    253 KB
  rows:    8,169

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-08-22 04:00:00	SPY	ETF	218.66	218.83	218.66	218.75	7844.0
2016-08-22 05:00:00	SPY	ETF	218.78	218.86	218.53	218.58	9351.0
2016-08-22 06:00:00	SPY	ETF	218.56	218.56	218.13	218.13	23916.0
2016-08-22 07:00:00	SPY	ETF	218.16	218.18	218.06	218.14	113317.0
2016-08-22 08:00:00	SPY	ETF	218.15	218.35	218.08	218.23	316902.0
2016-08-22 09:00:00	SPY	ETF	218.22	218.3	217.83	218.1	8441706.0
2016-08-22 10:00:00	SPY	ETF	218.105	218.74	217.93	218.59	8791206.0
2016-08-22 11:00:00	SPY	ETF	218.6	218.69	217.97	218.2	7707539.0
2016-08-22 12:00:00	SPY	ETF	218.2	218.8	218.04	218.47	6305976.0
2016-08-22 13:00:00	SPY	ETF	218.4608	218.56	218.0	218.4399	6482544.0
2016-08-22 14:00:00	SPY	ETF	218.44	218.61	218.23	218.369	6741345.0
2016-08-22 15:00:00	SPY	ETF	218.36	218.57	218.36	218.5	10779351.0
2016-08-22 16:00:00	SPY	ETF	218.51	218.62	218.4358	218.6	4611179.0
2016-08-22 17:00:00	SPY	ETF	218.58	218.58	218.54	218.54	10627.0
2016-08-22 18:00:00	SPY	ETF	218.53	218.56	218.49	218.52	24345.0
2016-08-22 19:00:00	SPY	ETF	218.5	218.5	218.42	218.47	24514.0
2016-08-22 04:00:00	QQQ	ETF	117.4	117.47	117.4	117.46	6607.0
2016-08-22 05:00:00	QQQ	ETF	117.51	117.51	117.29	117.3	5400.0
2016-08-22 06:00:00	QQQ	ETF	117.26	117.26	117.04	117.04	22748.0
2016-08-22 07:00:00	QQQ	ETF	117.04	117.08	117.0	117.06	67720.0
2016-08-22 08:00:00	QQQ	ETF	117.04	117.16	117.04	117.11	56682.0
2016-08-22 09:00:00	QQQ	ETF	117.12	117.19	116.87	117.1393	1559761.0
2016-08-22 10:00:00	QQQ	ETF	117.12	117.55	117.021	117.38	2307973.0
2016-08-22 11:00:00	QQQ	ETF	117.38	117.44	116.92	117.05	1945108.0
2016-08-22 12:00:00	QQQ	ETF	117.05	117.4195	116.97	117.26	1458283.0
2016-08-22 13:00:00	QQQ	ETF	117.26	117.34	116.9341	117.25	1913313.0
2016-08-22 14:00:00	QQQ	ETF	117.25	117.33	117.07	117.18	1173675.0
2016-08-22 15:00:00	QQQ	ETF	117.18	117.34	117.18	117.325	2341424.0
2016-08-22 16:00:00	QQQ	ETF	117.34	117.44	117.2014	117.43	489619.0
2016-08-22 17:00:00	QQQ	ETF	117.43	117.43	117.38	117.43	2107.0
2016-08-22 18:00:00	QQQ	ETF	117.38	117.38	117.38	117.38	794.0
2016-08-22 19:00:00	QQQ	ETF	117.37	117.37	117.31	117.31	2115.0
2016-08-22 06:00:00	IWM	ETF	122.66	122.66	122.66	122.66	150.0
2016-08-22 07:00:00	IWM	ETF	122.57	122.59	122.47	122.52	9519.0
2016-08-22 08:00:00	IWM	ETF	122.54	122.69	122.51	122.58	9034.0
2016-08-22 09:00:00	IWM	ETF	122.64	122.68	122.33	122.59	2263272.0
2016-08-22 10:00:00	IWM	ETF	122.59	123.34	122.51	123.19	3342673.0
2016-08-22 11:00:00	IWM	ETF	123.2	123.26	122.43	122.69	3243464.0
2016-08-22 12:00:00	IWM	ETF	122.685	123.115	122.57	122.96	1853650.0
2016-08-22 13:00:00	IWM	ETF	122.95	123.13	122.645	123.0442	1590462.0
2016-08-22 14:00:00	IWM	ETF	123.0438	123.15	122.92	122.995	1265827.0
2016-08-22 15:00:00	IWM	ETF	123.0	123.21	122.98	123.2	1931085.0
2016-08-22 16:00:00	IWM	ETF	123.2	123.29	123.13	123.19	561437.0
2016-08-22 17:00:00	IWM	ETF	123.15	123.16	123.15	123.16	1245.0
2016-08-22 18:00:00	IWM	ETF	123.25	123.25	123.25	123.25	250.0
2016-08-22 08:00:00	DIA	ETF	184.94	184.95	184.94	184.95	7000.0
2016-08-22 09:00:00	DIA	ETF	184.91	184.98	184.46	184.75	808381.0
2016-08-22 10:00:00	DIA	ETF	184.77	185.5119	184.6	185.31	636261.0
2016-08-22 11:00:00	DIA	ETF	185.32	185.41	184.7	184.92	548327.0
2016-08-22 12:00:00	DIA	ETF	184.91	185.44	184.78	185.19	236805.0

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

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