PREVIEW / etf_1hour / 2016-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-10.parquet
  size:    252 KB
  rows:    8,082

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-10 04:00:00	SPY	ETF	186.58	187.2	186.51	187.04	121559.0
2016-02-10 05:00:00	SPY	ETF	187.1	187.62	187.04	187.36	90068.0
2016-02-10 06:00:00	SPY	ETF	187.39	187.54	187.02	187.19	159574.0
2016-02-10 07:00:00	SPY	ETF	187.24	187.73	187.11	187.62	523905.0
2016-02-10 08:00:00	SPY	ETF	186.695	187.73	186.5	186.99	3350095.0
2016-02-10 09:00:00	SPY	ETF	187.0	187.2	186.0738	187.1	17371400.0
2016-02-10 10:00:00	SPY	ETF	187.1	188.34	186.52	186.74	29633492.0
2016-02-10 11:00:00	SPY	ETF	186.75	187.16	185.86	186.68	24737190.0
2016-02-10 12:00:00	SPY	ETF	186.68	187.7	186.27	187.551	13429368.0
2016-02-10 13:00:00	SPY	ETF	187.55	187.716	186.62	186.77	13733283.0
2016-02-10 14:00:00	SPY	ETF	186.79	187.275	186.2	186.38	10757329.0
2016-02-10 15:00:00	SPY	ETF	186.38	187.08	185.12	185.29	27598410.0
2016-02-10 16:00:00	SPY	ETF	185.27	185.43	184.79	184.83	5241431.0
2016-02-10 17:00:00	SPY	ETF	184.82	185.0	184.75	184.78	286826.0
2016-02-10 18:00:00	SPY	ETF	184.92	185.27	184.45	184.49	322488.0
2016-02-10 19:00:00	SPY	ETF	184.51	184.81	183.9	183.93	263303.0
2016-02-10 04:00:00	QQQ	ETF	97.08	97.56	97.01	97.56	13086.0
2016-02-10 05:00:00	QQQ	ETF	97.58	97.89	97.58	97.72	4500.0
2016-02-10 06:00:00	QQQ	ETF	97.81	97.81	97.57	97.65	12356.0
2016-02-10 07:00:00	QQQ	ETF	97.63	97.93	97.54	97.93	237322.0
2016-02-10 08:00:00	QQQ	ETF	97.91	98.01	97.5	97.66	710931.0
2016-02-10 09:00:00	QQQ	ETF	97.57	97.98	97.03	97.95	7324335.0
2016-02-10 10:00:00	QQQ	ETF	97.94	98.69	97.52	97.61	10844980.0
2016-02-10 11:00:00	QQQ	ETF	97.61	97.99	97.1686	97.62	6479121.0
2016-02-10 12:00:00	QQQ	ETF	97.64	98.28	97.42	98.23	3622665.0
2016-02-10 13:00:00	QQQ	ETF	98.24	98.403	97.66	97.81	3564721.0
2016-02-10 14:00:00	QQQ	ETF	97.82	98.15	97.3	97.4089	3519032.0
2016-02-10 15:00:00	QQQ	ETF	97.43	97.91	96.62	96.71	10267232.0
2016-02-10 16:00:00	QQQ	ETF	96.71	97.11	96.53	96.77	1866327.0
2016-02-10 17:00:00	QQQ	ETF	96.78	96.93	96.74	96.93	28613.0
2016-02-10 18:00:00	QQQ	ETF	96.82	97.0	96.53	96.55	35314.0
2016-02-10 19:00:00	QQQ	ETF	96.55	96.72	96.27	96.28	44882.0
2016-02-10 04:00:00	IWM	ETF	96.39	96.73	96.39	96.65	4861.0
2016-02-10 05:00:00	IWM	ETF	96.74	96.91	96.74	96.91	2520.0
2016-02-10 06:00:00	IWM	ETF	96.87	96.87	96.63	96.71	6300.0
2016-02-10 07:00:00	IWM	ETF	96.73	97.05	96.65	96.86	53804.0
2016-02-10 08:00:00	IWM	ETF	96.69	96.93	96.37	96.5	573372.0
2016-02-10 09:00:00	IWM	ETF	96.52	97.04	96.09	96.9	4719569.0
2016-02-10 10:00:00	IWM	ETF	96.89	97.92	96.64	96.72	7652571.0
2016-02-10 11:00:00	IWM	ETF	96.76	97.09	96.29	96.825	5644361.0
2016-02-10 12:00:00	IWM	ETF	96.83	97.52	96.57	97.48	3299628.0
2016-02-10 13:00:00	IWM	ETF	97.47	97.52	96.93	97.0339	2596489.0
2016-02-10 14:00:00	IWM	ETF	97.0399	97.26	96.28	96.47	4043375.0
2016-02-10 15:00:00	IWM	ETF	96.48	96.88	95.675	95.79	9274151.0
2016-02-10 16:00:00	IWM	ETF	95.79	95.85	95.45	95.49	1182625.0
2016-02-10 17:00:00	IWM	ETF	95.51	95.7	95.5	95.55	26492.0
2016-02-10 18:00:00	IWM	ETF	95.65	95.76	95.49	95.52	67878.0
2016-02-10 19:00:00	IWM	ETF	95.52	95.65	95.01	95.01	8389.0
2016-02-10 04:00:00	DIA	ETF	161.45	161.45	161.45	161.45	100.0
2016-02-10 05:00:00	DIA	ETF	161.83	161.83	161.83	161.83	100.0

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

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