PREVIEW / etf_1hour / 2016-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-02.parquet
  size:    264 KB
  rows:    8,495

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-11-02 04:00:00	SPY	ETF	210.41	210.41	210.07	210.28	26455.0
2016-11-02 05:00:00	SPY	ETF	210.25	210.61	210.22	210.61	9423.0
2016-11-02 06:00:00	SPY	ETF	210.61	210.61	210.32	210.5	25667.0
2016-11-02 07:00:00	SPY	ETF	210.44	210.92	210.44	210.77	413613.0
2016-11-02 08:00:00	SPY	ETF	210.55	210.87	210.25	210.63	1191176.0
2016-11-02 09:00:00	SPY	ETF	210.67	211.02	210.43	210.89	9907427.0
2016-11-02 10:00:00	SPY	ETF	210.88	211.1	210.12	210.2	15867072.0
2016-11-02 11:00:00	SPY	ETF	210.19	210.72	210.16	210.3354	7891511.0
2016-11-02 12:00:00	SPY	ETF	210.33	210.53	210.18	210.41	6127258.0
2016-11-02 13:00:00	SPY	ETF	210.4	210.5	209.69	209.98	10438717.0
2016-11-02 14:00:00	SPY	ETF	209.98	210.8416	209.23	209.9225	21428997.0
2016-11-02 15:00:00	SPY	ETF	209.92	210.4	209.6	209.7	18821309.0
2016-11-02 16:00:00	SPY	ETF	209.7	213.12	209.35	209.5	8843639.0
2016-11-02 17:00:00	SPY	ETF	209.52	209.54	209.06	209.2	299884.0
2016-11-02 18:00:00	SPY	ETF	209.19	209.5	209.19	209.38	362460.0
2016-11-02 19:00:00	SPY	ETF	209.4	209.74	209.4	209.64	157254.0
2016-11-02 04:00:00	QQQ	ETF	115.71	115.71	115.65	115.65	3400.0
2016-11-02 05:00:00	QQQ	ETF	115.75	115.79	115.75	115.79	300.0
2016-11-02 06:00:00	QQQ	ETF	115.79	115.82	115.79	115.82	1600.0
2016-11-02 07:00:00	QQQ	ETF	115.9	116.1	115.9	116.05	113246.0
2016-11-02 08:00:00	QQQ	ETF	116.05	116.09	115.9	116.05	117679.0
2016-11-02 09:00:00	QQQ	ETF	116.1	116.24	115.89	116.16	1906208.0
2016-11-02 10:00:00	QQQ	ETF	116.15	116.3	115.71	115.74	2706644.0
2016-11-02 11:00:00	QQQ	ETF	115.74	116.115	115.73	115.81	1899749.0
2016-11-02 12:00:00	QQQ	ETF	115.8	115.8773	115.57	115.65	1647982.0
2016-11-02 13:00:00	QQQ	ETF	115.64	115.72	115.16	115.35	2648070.0
2016-11-02 14:00:00	QQQ	ETF	115.38	115.7242	114.89	115.28	4500265.0
2016-11-02 15:00:00	QQQ	ETF	115.29	115.53	115.11	115.16	4857215.0
2016-11-02 16:00:00	QQQ	ETF	115.16	115.37	114.85	115.13	1145503.0
2016-11-02 17:00:00	QQQ	ETF	115.17	115.2	114.42	114.49	414101.0
2016-11-02 18:00:00	QQQ	ETF	114.51	114.78	114.51	114.67	164991.0
2016-11-02 19:00:00	QQQ	ETF	114.66	114.86	114.66	114.81	17322.0
2016-11-02 04:00:00	IWM	ETF	116.54	116.54	116.54	116.54	250.0
2016-11-02 05:00:00	IWM	ETF	116.66	116.68	116.66	116.68	200.0
2016-11-02 06:00:00	IWM	ETF	116.66	116.69	116.62	116.69	761.0
2016-11-02 07:00:00	IWM	ETF	116.8	116.99	116.8	116.92	59900.0
2016-11-02 08:00:00	IWM	ETF	116.94	116.99	116.67	116.85	51909.0
2016-11-02 09:00:00	IWM	ETF	116.86	117.0	116.61	116.91	2301131.0
2016-11-02 10:00:00	IWM	ETF	116.91	116.93	116.435	116.47	2934506.0
2016-11-02 11:00:00	IWM	ETF	116.48	116.78	116.22	116.29	2045651.0
2016-11-02 12:00:00	IWM	ETF	116.29	116.43	116.07	116.16	2407555.0
2016-11-02 13:00:00	IWM	ETF	116.16	116.24	115.63	115.89	3707347.0
2016-11-02 14:00:00	IWM	ETF	115.88	116.24	115.39	115.94	5547910.0
2016-11-02 15:00:00	IWM	ETF	115.94	116.08	115.58	115.59	4646584.0
2016-11-02 16:00:00	IWM	ETF	115.59	115.6	115.3	115.4	1347268.0
2016-11-02 17:00:00	IWM	ETF	115.39	115.41	115.0	115.06	18912.0
2016-11-02 18:00:00	IWM	ETF	115.35	115.56	115.15	115.15	3429.0
2016-11-02 19:00:00	IWM	ETF	115.2	115.45	115.2	115.44	17134.0
2016-11-02 08:00:00	DIA	ETF	179.78	179.86	179.44	179.68	3400.0
2016-11-02 09:00:00	DIA	ETF	179.73	180.09	179.497	180.03	303929.0

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

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