PREVIEW / etf_1hour / 2016-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-26.parquet
  size:    252 KB
  rows:    8,023

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-26 04:00:00	SPY	ETF	217.87	217.91	217.8	217.8	1102.0
2016-08-26 05:00:00	SPY	ETF	217.86	217.96	217.8	217.92	2457.0
2016-08-26 06:00:00	SPY	ETF	217.93	217.95	217.76	217.76	5822.0
2016-08-26 07:00:00	SPY	ETF	217.75	217.82	217.72	217.76	91488.0
2016-08-26 08:00:00	SPY	ETF	217.73	217.95	217.65	217.85	266743.0
2016-08-26 09:00:00	SPY	ETF	217.84	218.54	217.8	218.118	7621492.0
2016-08-26 10:00:00	SPY	ETF	218.11	219.12	217.5	218.665	25182511.0
2016-08-26 11:00:00	SPY	ETF	218.66	218.8	217.38	217.58	16791646.0
2016-08-26 12:00:00	SPY	ETF	217.57	217.57	216.57	217.18	20070218.0
2016-08-26 13:00:00	SPY	ETF	217.17	217.35	216.6051	216.75	8625340.0
2016-08-26 14:00:00	SPY	ETF	216.75	217.0	216.25	216.65	13499431.0
2016-08-26 15:00:00	SPY	ETF	216.65	217.52	216.55	217.25	22771323.0
2016-08-26 16:00:00	SPY	ETF	217.26	217.39	217.1665	217.25	5789320.0
2016-08-26 17:00:00	SPY	ETF	217.19	218.1	217.15	217.23	292205.0
2016-08-26 18:00:00	SPY	ETF	217.23	217.23	217.05	217.16	81544.0
2016-08-26 19:00:00	SPY	ETF	217.19	217.23	217.16	217.16	12998.0
2016-08-26 04:00:00	QQQ	ETF	116.67	116.67	116.62	116.62	249.0
2016-08-26 05:00:00	QQQ	ETF	116.61	116.61	116.61	116.61	340.0
2016-08-26 07:00:00	QQQ	ETF	116.61	116.65	116.6	116.61	90081.0
2016-08-26 08:00:00	QQQ	ETF	116.59	116.65	116.53	116.59	49903.0
2016-08-26 09:00:00	QQQ	ETF	116.59	117.15	116.53	116.859	2069366.0
2016-08-26 10:00:00	QQQ	ETF	116.85	117.54	116.4801	117.2864	5141330.0
2016-08-26 11:00:00	QQQ	ETF	117.29	117.4	116.62	116.7193	2914293.0
2016-08-26 12:00:00	QQQ	ETF	116.71	116.71	116.08	116.51	4034454.0
2016-08-26 13:00:00	QQQ	ETF	116.513	116.62	116.23	116.3	1346780.0
2016-08-26 14:00:00	QQQ	ETF	116.3	116.48	116.1	116.34	1980211.0
2016-08-26 15:00:00	QQQ	ETF	116.34	116.86	116.29	116.75	3749363.0
2016-08-26 16:00:00	QQQ	ETF	116.77	116.82	116.6859	116.74	849080.0
2016-08-26 17:00:00	QQQ	ETF	116.64	116.78	116.64	116.78	10349.0
2016-08-26 18:00:00	QQQ	ETF	116.76	116.76	116.74	116.74	650.0
2016-08-26 19:00:00	QQQ	ETF	116.73	116.78	116.68	116.68	5539.0
2016-08-26 07:00:00	IWM	ETF	123.36	123.39	123.33	123.33	69098.0
2016-08-26 08:00:00	IWM	ETF	123.36	123.42	123.25	123.4	24235.0
2016-08-26 09:00:00	IWM	ETF	123.35	123.83	123.32	123.66	1862261.0
2016-08-26 10:00:00	IWM	ETF	123.62	124.41	123.291	123.86	5774741.0
2016-08-26 11:00:00	IWM	ETF	123.86	124.09	123.211	123.3	3294915.0
2016-08-26 12:00:00	IWM	ETF	123.29	123.29	122.64	123.03	3264398.0
2016-08-26 13:00:00	IWM	ETF	123.02	123.13	122.5	122.5701	1631661.0
2016-08-26 14:00:00	IWM	ETF	122.57	122.74	122.3	122.58	2393526.0
2016-08-26 15:00:00	IWM	ETF	122.57	123.18	122.52	123.05	5561745.0
2016-08-26 16:00:00	IWM	ETF	123.06	123.24	123.05	123.15	515574.0
2016-08-26 17:00:00	IWM	ETF	123.17	123.2	123.17	123.2	2365.0
2016-08-26 18:00:00	IWM	ETF	123.2	123.2	123.15	123.15	12000.0
2016-08-26 19:00:00	IWM	ETF	123.22	123.22	123.22	123.22	1000.0
2016-08-26 09:00:00	DIA	ETF	184.54	185.17	184.54	184.78	245269.0
2016-08-26 10:00:00	DIA	ETF	184.79	185.54	184.33	185.201	722973.0
2016-08-26 11:00:00	DIA	ETF	185.19	185.22	183.88	184.05	507128.0
2016-08-26 12:00:00	DIA	ETF	184.0489	184.0499	183.27	183.79	534130.0
2016-08-26 13:00:00	DIA	ETF	183.77	183.9	183.355	183.5	206063.0
2016-08-26 14:00:00	DIA	ETF	183.48	183.64	183.14	183.48	354555.0

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

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