PREVIEW / etf_1hour / 2016-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-18.parquet
  size:    257 KB
  rows:    8,320

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-10-18 04:00:00	SPY	ETF	213.68	213.9	213.61	213.76	35361.0
2016-10-18 05:00:00	SPY	ETF	213.74	213.78	213.68	213.69	58540.0
2016-10-18 06:00:00	SPY	ETF	213.68	213.78	213.58	213.67	10320.0
2016-10-18 07:00:00	SPY	ETF	213.69	214.07	213.62	213.92	590321.0
2016-10-18 08:00:00	SPY	ETF	213.94	214.34	213.67	214.09	1291825.0
2016-10-18 09:00:00	SPY	ETF	214.1	214.29	213.53	213.6692	10665668.0
2016-10-18 10:00:00	SPY	ETF	213.665	214.24	213.27	213.665	9115109.0
2016-10-18 11:00:00	SPY	ETF	213.67	214.19	213.61	214.18	9626269.0
2016-10-18 12:00:00	SPY	ETF	214.175	214.31	213.91	213.97	6998427.0
2016-10-18 13:00:00	SPY	ETF	213.97	214.09	213.84	214.0001	5051607.0
2016-10-18 14:00:00	SPY	ETF	214.005	214.18	213.88	214.08	7798896.0
2016-10-18 15:00:00	SPY	ETF	214.08	214.1	213.67	213.69	14580998.0
2016-10-18 16:00:00	SPY	ETF	213.68	214.0	213.38	213.56	7187032.0
2016-10-18 17:00:00	SPY	ETF	213.58	213.71	213.52	213.58	234388.0
2016-10-18 18:00:00	SPY	ETF	213.57	213.65	213.52	213.6	75114.0
2016-10-18 19:00:00	SPY	ETF	213.6	213.65	213.6	213.65	19484.0
2016-10-18 04:00:00	QQQ	ETF	117.68	117.83	117.68	117.83	6765.0
2016-10-18 05:00:00	QQQ	ETF	117.73	117.8	117.72	117.72	52206.0
2016-10-18 06:00:00	QQQ	ETF	117.7	117.8	117.69	117.74	30812.0
2016-10-18 07:00:00	QQQ	ETF	117.73	117.95	117.72	117.93	346022.0
2016-10-18 08:00:00	QQQ	ETF	117.92	118.2	117.89	118.14	283649.0
2016-10-18 09:00:00	QQQ	ETF	118.14	118.25	117.94	118.05	2186820.0
2016-10-18 10:00:00	QQQ	ETF	118.05	118.11	117.8	118.08	2053538.0
2016-10-18 11:00:00	QQQ	ETF	118.08	118.35	118.065	118.345	2372935.0
2016-10-18 12:00:00	QQQ	ETF	118.35	118.41	118.24	118.3	1455372.0
2016-10-18 13:00:00	QQQ	ETF	118.299	118.33	118.19	118.265	1266421.0
2016-10-18 14:00:00	QQQ	ETF	118.2501	118.34	118.193	118.25	1256689.0
2016-10-18 15:00:00	QQQ	ETF	118.25	118.27	117.86	117.86	3632088.0
2016-10-18 16:00:00	QQQ	ETF	117.87	117.92	117.59	117.65	786824.0
2016-10-18 17:00:00	QQQ	ETF	117.64	117.73	117.5	117.6	50831.0
2016-10-18 18:00:00	QQQ	ETF	117.59	117.69	117.58	117.69	16188.0
2016-10-18 19:00:00	QQQ	ETF	117.64	117.69	117.64	117.64	2935.0
2016-10-18 04:00:00	IWM	ETF	121.12	121.34	121.12	121.34	544.0
2016-10-18 05:00:00	IWM	ETF	121.3	121.3	121.3	121.3	200.0
2016-10-18 06:00:00	IWM	ETF	121.25	121.35	121.25	121.35	310.0
2016-10-18 07:00:00	IWM	ETF	121.3	121.45	121.28	121.37	287695.0
2016-10-18 08:00:00	IWM	ETF	121.36	121.52	121.29	121.4	176922.0
2016-10-18 09:00:00	IWM	ETF	121.4	121.58	120.82	121.01	2485701.0
2016-10-18 10:00:00	IWM	ETF	121.02	121.05	120.66	120.92	3620908.0
2016-10-18 11:00:00	IWM	ETF	120.91	121.52	120.83	121.49	3379382.0
2016-10-18 12:00:00	IWM	ETF	121.49	121.535	121.32	121.38	973931.0
2016-10-18 13:00:00	IWM	ETF	121.38	121.47	121.24	121.33	1291754.0
2016-10-18 14:00:00	IWM	ETF	121.34	121.37	121.19	121.25	1228008.0
2016-10-18 15:00:00	IWM	ETF	121.255	121.27	120.92	120.93	3765881.0
2016-10-18 16:00:00	IWM	ETF	120.94	120.98	120.7	120.84	725910.0
2016-10-18 17:00:00	IWM	ETF	120.83	120.88	120.81	120.87	2800.0
2016-10-18 19:00:00	IWM	ETF	120.85	120.9	120.84	120.9	2073.0
2016-10-18 04:00:00	DIA	ETF	181.24	181.24	181.24	181.24	200.0
2016-10-18 07:00:00	DIA	ETF	181.54	181.72	181.54	181.72	5400.0
2016-10-18 08:00:00	DIA	ETF	181.71	181.96	181.55	181.88	6503.0

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

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