PREVIEW / etf_1hour / 2016-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-26.parquet
  size:    247 KB
  rows:    7,899

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-02-26 04:00:00	SPY	ETF	196.5	197.26	196.5	197.26	58289.0
2016-02-26 05:00:00	SPY	ETF	197.29	197.45	197.1	197.21	84597.0
2016-02-26 06:00:00	SPY	ETF	197.18	197.18	196.55	196.57	339074.0
2016-02-26 07:00:00	SPY	ETF	196.64	196.75	196.29	196.41	505761.0
2016-02-26 08:00:00	SPY	ETF	196.72	197.15	195.46	196.66	1910436.0
2016-02-26 09:00:00	SPY	ETF	196.65	196.83	196.09	196.16	13747896.0
2016-02-26 10:00:00	SPY	ETF	196.16	196.43	195.52	196.4011	19711755.0
2016-02-26 11:00:00	SPY	ETF	196.4	196.49	195.535	195.83	14494168.0
2016-02-26 12:00:00	SPY	ETF	195.83	196.26	195.36	196.09	12798694.0
2016-02-26 13:00:00	SPY	ETF	196.08	196.219	195.26	195.49	12407200.0
2016-02-26 14:00:00	SPY	ETF	195.49	195.67	194.9	194.9901	11884366.0
2016-02-26 15:00:00	SPY	ETF	194.99	195.52	194.95	195.13	27799616.0
2016-02-26 16:00:00	SPY	ETF	195.13	195.5124	194.77	194.77	10023750.0
2016-02-26 17:00:00	SPY	ETF	194.78	195.1	194.77	194.8	559754.0
2016-02-26 18:00:00	SPY	ETF	194.85	194.88	194.8	194.8	26139.0
2016-02-26 19:00:00	SPY	ETF	194.78	194.87	194.76	194.87	15979.0
2016-02-26 04:00:00	QQQ	ETF	104.33	104.66	104.33	104.66	1760.0
2016-02-26 05:00:00	QQQ	ETF	104.75	104.76	104.64	104.64	15597.0
2016-02-26 06:00:00	QQQ	ETF	104.58	104.58	104.25	104.29	10150.0
2016-02-26 07:00:00	QQQ	ETF	104.31	104.31	104.16	104.2	39753.0
2016-02-26 08:00:00	QQQ	ETF	104.21	104.59	104.17	104.31	294201.0
2016-02-26 09:00:00	QQQ	ETF	104.31	104.43	103.9799	104.01	4589977.0
2016-02-26 10:00:00	QQQ	ETF	104.01	104.03	103.54	103.95	3888861.0
2016-02-26 11:00:00	QQQ	ETF	103.94	104.01	103.43	103.54	3412496.0
2016-02-26 12:00:00	QQQ	ETF	103.54	103.675	103.1835	103.58	2952520.0
2016-02-26 13:00:00	QQQ	ETF	103.58	103.73	103.28	103.43	2502709.0
2016-02-26 14:00:00	QQQ	ETF	103.43	103.62	103.19	103.2939	2809429.0
2016-02-26 15:00:00	QQQ	ETF	103.295	103.62	103.26	103.4	4836012.0
2016-02-26 16:00:00	QQQ	ETF	103.4	103.46	103.2	103.24	801610.0
2016-02-26 17:00:00	QQQ	ETF	103.35	103.36	103.28	103.28	7900.0
2016-02-26 18:00:00	QQQ	ETF	103.3	103.36	103.22	103.23	12992.0
2016-02-26 19:00:00	QQQ	ETF	103.23	103.25	103.19	103.23	5215.0
2016-02-26 04:00:00	IWM	ETF	102.89	103.56	102.89	103.56	7458.0
2016-02-26 05:00:00	IWM	ETF	103.53	103.56	103.52	103.53	11991.0
2016-02-26 06:00:00	IWM	ETF	103.46	103.5	103.41	103.5	2300.0
2016-02-26 07:00:00	IWM	ETF	103.34	103.34	103.06	103.13	33415.0
2016-02-26 08:00:00	IWM	ETF	103.14	103.41	103.09	103.17	202106.0
2016-02-26 09:00:00	IWM	ETF	103.13	103.37	102.85	103.12	3638496.0
2016-02-26 10:00:00	IWM	ETF	103.115	103.24	102.74	103.22	3490838.0
2016-02-26 11:00:00	IWM	ETF	103.22	103.47	102.97	103.285	3045255.0
2016-02-26 12:00:00	IWM	ETF	103.27	103.45	103.06	103.33	2081937.0
2016-02-26 13:00:00	IWM	ETF	103.32	103.42	102.93	103.03	3497748.0
2016-02-26 14:00:00	IWM	ETF	103.03	103.095	102.7	102.84	2717753.0
2016-02-26 15:00:00	IWM	ETF	102.84	103.27	102.83	103.17	4455519.0
2016-02-26 16:00:00	IWM	ETF	103.18	103.27	103.08	103.08	1717251.0
2016-02-26 17:00:00	IWM	ETF	103.05	103.19	103.05	103.19	305441.0
2016-02-26 19:00:00	IWM	ETF	103.01	103.05	103.01	103.05	200.0
2016-02-26 06:00:00	DIA	ETF	167.61	167.61	167.61	167.61	200.0
2016-02-26 07:00:00	DIA	ETF	167.64	167.64	167.61	167.61	400.0
2016-02-26 08:00:00	DIA	ETF	167.43	168.15	167.43	168.1	8218.0

> showing 50 of 7,899 rows — these rows as CSV

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