PREVIEW / etf_1hour / 2016-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-17.parquet
  size:    255 KB
  rows:    8,189

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-17 04:00:00	SPY	ETF	218.11	218.11	217.82	218.03	10775.0
2016-08-17 05:00:00	SPY	ETF	217.97	218.19	217.97	218.19	4916.0
2016-08-17 06:00:00	SPY	ETF	218.13	218.15	218.02	218.02	9264.0
2016-08-17 07:00:00	SPY	ETF	218.0	218.22	217.96	218.18	163410.0
2016-08-17 08:00:00	SPY	ETF	217.99	218.22	217.99	218.14	103546.0
2016-08-17 09:00:00	SPY	ETF	218.16	218.17	217.35	217.36	7765285.0
2016-08-17 10:00:00	SPY	ETF	217.35	217.56	217.3	217.41	9998456.0
2016-08-17 11:00:00	SPY	ETF	217.41	217.529	217.02	217.08	6789893.0
2016-08-17 12:00:00	SPY	ETF	217.08	217.86	217.08	217.78	6245326.0
2016-08-17 13:00:00	SPY	ETF	217.79	218.12	217.66	217.7501	6956756.0
2016-08-17 14:00:00	SPY	ETF	217.76	218.4	217.38	218.19	16135438.0
2016-08-17 15:00:00	SPY	ETF	218.195	218.53	217.96	218.37	12847746.0
2016-08-17 16:00:00	SPY	ETF	218.36	218.62	218.33	218.55	4240921.0
2016-08-17 17:00:00	SPY	ETF	218.55	218.57	218.46	218.5	197293.0
2016-08-17 18:00:00	SPY	ETF	218.53	218.58	218.43	218.43	125691.0
2016-08-17 19:00:00	SPY	ETF	218.49	218.49	218.36	218.42	474598.0
2016-08-17 04:00:00	QQQ	ETF	117.05	117.05	116.81	117.03	2600.0
2016-08-17 05:00:00	QQQ	ETF	117.14	117.15	117.14	117.15	3497.0
2016-08-17 07:00:00	QQQ	ETF	117.04	117.23	117.03	117.22	132283.0
2016-08-17 08:00:00	QQQ	ETF	117.23	117.23	117.04	117.19	28961.0
2016-08-17 09:00:00	QQQ	ETF	117.22	117.22	116.68	116.74	1976368.0
2016-08-17 10:00:00	QQQ	ETF	116.74	116.8	116.6	116.69	1672080.0
2016-08-17 11:00:00	QQQ	ETF	116.69	116.78	116.43	116.45	1391301.0
2016-08-17 12:00:00	QQQ	ETF	116.44	117.02	116.44	116.98	1299839.0
2016-08-17 13:00:00	QQQ	ETF	116.98	117.17	116.89	116.93	1603366.0
2016-08-17 14:00:00	QQQ	ETF	116.92	117.3	116.65	117.15	2515520.0
2016-08-17 15:00:00	QQQ	ETF	117.15	117.29	116.96	117.23	1813946.0
2016-08-17 16:00:00	QQQ	ETF	117.27	117.32	117.19	117.3	522018.0
2016-08-17 17:00:00	QQQ	ETF	117.29	117.31	117.27	117.27	1731.0
2016-08-17 18:00:00	QQQ	ETF	117.33	117.33	117.25	117.25	4977.0
2016-08-17 19:00:00	QQQ	ETF	117.25	117.26	117.21	117.25	6599.0
2016-08-17 05:00:00	IWM	ETF	122.4	122.4	122.4	122.4	100.0
2016-08-17 07:00:00	IWM	ETF	122.35	122.53	122.35	122.52	107030.0
2016-08-17 08:00:00	IWM	ETF	122.53	122.53	122.42	122.48	39373.0
2016-08-17 09:00:00	IWM	ETF	122.5	122.53	121.75	121.76	2417136.0
2016-08-17 10:00:00	IWM	ETF	121.75	122.02	121.67	121.72	2399490.0
2016-08-17 11:00:00	IWM	ETF	121.72	121.87	121.33	121.4001	2187663.0
2016-08-17 12:00:00	IWM	ETF	121.4	122.14	121.36	122.07	2179324.0
2016-08-17 13:00:00	IWM	ETF	122.07	122.16	121.74	121.76	1516218.0
2016-08-17 14:00:00	IWM	ETF	121.769	122.21	121.5	121.98	3203832.0
2016-08-17 15:00:00	IWM	ETF	122.01	122.09	121.65	122.05	3291975.0
2016-08-17 16:00:00	IWM	ETF	122.055	122.16	121.98	122.11	1215325.0
2016-08-17 17:00:00	IWM	ETF	122.13	122.17	122.13	122.15	712.0
2016-08-17 19:00:00	IWM	ETF	122.11	122.12	122.09	122.11	2400.0
2016-08-17 09:00:00	DIA	ETF	185.73	185.83	185.25	185.25	265215.0
2016-08-17 10:00:00	DIA	ETF	185.24	185.52	185.23	185.44	343376.0
2016-08-17 11:00:00	DIA	ETF	185.4142	185.49	185.1	185.1001	251524.0
2016-08-17 12:00:00	DIA	ETF	185.1	185.7648	185.09	185.72	336009.0
2016-08-17 13:00:00	DIA	ETF	185.72	186.0715	185.62	185.8	545635.0
2016-08-17 14:00:00	DIA	ETF	185.83	186.225	185.51	186.03	499151.0

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

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