PREVIEW / etf_1hour / 2017-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-21.parquet
  size:    281 KB
  rows:    9,197

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
2017-02-21 04:00:00	SPY	ETF	235.2	235.49	235.2	235.45	8795.0
2017-02-21 05:00:00	SPY	ETF	235.45	235.55	235.45	235.55	14344.0
2017-02-21 06:00:00	SPY	ETF	235.54	235.61	235.49	235.5	81136.0
2017-02-21 07:00:00	SPY	ETF	235.52	235.64	235.51	235.52	120038.0
2017-02-21 08:00:00	SPY	ETF	235.62	235.62	235.39	235.49	268205.0
2017-02-21 09:00:00	SPY	ETF	235.5	236.17	235.09	236.1	7902577.0
2017-02-21 10:00:00	SPY	ETF	236.1	236.65	236.07	236.4	12106961.0
2017-02-21 11:00:00	SPY	ETF	236.41	236.44	235.81	236.1	9652235.0
2017-02-21 12:00:00	SPY	ETF	236.095	236.28	236.06	236.11	5318836.0
2017-02-21 13:00:00	SPY	ETF	236.11	236.23	235.95	236.075	5487923.0
2017-02-21 14:00:00	SPY	ETF	236.08	236.46	236.015	236.365	7315574.0
2017-02-21 15:00:00	SPY	ETF	236.37	236.69	236.32	236.45	17643115.0
2017-02-21 16:00:00	SPY	ETF	236.45	236.5886	236.07	236.25	18118722.0
2017-02-21 17:00:00	SPY	ETF	236.24	236.28	236.19	236.2	2069082.0
2017-02-21 18:00:00	SPY	ETF	236.21	236.25	236.16	236.25	65090.0
2017-02-21 19:00:00	SPY	ETF	236.21	236.27	236.15	236.27	48474.0
2017-02-21 04:00:00	QQQ	ETF	130.05	130.15	130.05	130.14	2200.0
2017-02-21 05:00:00	QQQ	ETF	130.17	130.25	130.17	130.25	15200.0
2017-02-21 06:00:00	QQQ	ETF	130.19	130.2	130.16	130.2	5800.0
2017-02-21 07:00:00	QQQ	ETF	130.21	130.21	130.11	130.13	79077.0
2017-02-21 08:00:00	QQQ	ETF	130.12	130.2	130.06	130.08	66918.0
2017-02-21 09:00:00	QQQ	ETF	130.08	130.37	129.81	130.29	2065141.0
2017-02-21 10:00:00	QQQ	ETF	130.29	130.52	130.23	130.38	2538784.0
2017-02-21 11:00:00	QQQ	ETF	130.37	130.395	130.06	130.18	1420560.0
2017-02-21 12:00:00	QQQ	ETF	130.19	130.23	130.08	130.16	1459738.0
2017-02-21 13:00:00	QQQ	ETF	130.16	130.255	130.09	130.18	654887.0
2017-02-21 14:00:00	QQQ	ETF	130.17	130.3557	130.14	130.32	821614.0
2017-02-21 15:00:00	QQQ	ETF	130.325	130.53	130.3	130.46	2719795.0
2017-02-21 16:00:00	QQQ	ETF	130.46	130.46	130.23	130.32	423788.0
2017-02-21 17:00:00	QQQ	ETF	130.32	130.32	130.25	130.25	7615.0
2017-02-21 18:00:00	QQQ	ETF	130.3	130.35	130.3	130.3	3900.0
2017-02-21 19:00:00	QQQ	ETF	130.33	130.38	130.3	130.36	6599.0
2017-02-21 04:00:00	IWM	ETF	139.25	139.25	139.11	139.11	15100.0
2017-02-21 05:00:00	IWM	ETF	139.33	139.33	139.29	139.31	1910.0
2017-02-21 06:00:00	IWM	ETF	139.33	139.33	139.25	139.25	2664.0
2017-02-21 07:00:00	IWM	ETF	139.33	139.41	139.31	139.31	74306.0
2017-02-21 08:00:00	IWM	ETF	139.33	139.38	139.24	139.37	22915.0
2017-02-21 09:00:00	IWM	ETF	139.36	140.22	139.11	140.07	2679954.0
2017-02-21 10:00:00	IWM	ETF	140.08	140.32	139.73	139.75	3009841.0
2017-02-21 11:00:00	IWM	ETF	139.74	139.915	139.44	139.76	2054878.0
2017-02-21 12:00:00	IWM	ETF	139.77	139.89	139.66	139.67	1091375.0
2017-02-21 13:00:00	IWM	ETF	139.67	139.74	139.5401	139.68	989747.0
2017-02-21 14:00:00	IWM	ETF	139.6788	140.05	139.62	139.93	1627692.0
2017-02-21 15:00:00	IWM	ETF	139.92	140.27	139.87	140.18	3878712.0
2017-02-21 16:00:00	IWM	ETF	140.2	140.2	139.91	140.04	3125146.0
2017-02-21 17:00:00	IWM	ETF	140.08	140.08	139.93	139.93	400.0
2017-02-21 18:00:00	IWM	ETF	140.0	140.0	140.0	140.0	157.0
2017-02-21 19:00:00	IWM	ETF	140.01	140.02	140.0	140.02	1114.0
2017-02-21 04:00:00	DIA	ETF	206.17	206.17	206.17	206.17	200.0
2017-02-21 06:00:00	DIA	ETF	206.37	206.37	206.37	206.37	203.0

> showing 50 of 9,197 rows — these rows as CSV

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