PREVIEW / etf_30min / 2016-08-17

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-17.parquet
  size:    400 KB
  rows:    13,563

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-17 04:00:00	SPY	ETF	218.11	218.11	217.82	217.89	8740.0
2016-08-17 04:30:00	SPY	ETF	217.89	218.06	217.89	218.03	2035.0
2016-08-17 05:00:00	SPY	ETF	217.97	218.13	217.97	218.13	603.0
2016-08-17 05:30:00	SPY	ETF	218.08	218.19	218.08	218.19	4313.0
2016-08-17 06:00:00	SPY	ETF	218.13	218.15	218.08	218.08	2804.0
2016-08-17 06:30:00	SPY	ETF	218.06	218.13	218.02	218.02	6460.0
2016-08-17 07:00:00	SPY	ETF	218.0	218.02	217.96	218.02	39832.0
2016-08-17 07:30:00	SPY	ETF	218.02	218.22	218.02	218.18	123578.0
2016-08-17 08:00:00	SPY	ETF	217.99	218.22	217.99	218.09	80180.0
2016-08-17 08:30:00	SPY	ETF	218.09	218.15	218.08	218.14	23366.0
2016-08-17 09:00:00	SPY	ETF	218.16	218.17	217.99	218.01	336172.0
2016-08-17 09:30:00	SPY	ETF	218.0	218.08	217.35	217.36	7429113.0
2016-08-17 10:00:00	SPY	ETF	217.35	217.47	217.3	217.4	5210680.0
2016-08-17 10:30:00	SPY	ETF	217.41	217.56	217.31	217.41	4787776.0
2016-08-17 11:00:00	SPY	ETF	217.41	217.529	217.16	217.21	3372352.0
2016-08-17 11:30:00	SPY	ETF	217.205	217.25	217.02	217.08	3417541.0
2016-08-17 12:00:00	SPY	ETF	217.08	217.42	217.08	217.381	1857191.0
2016-08-17 12:30:00	SPY	ETF	217.38	217.86	217.35	217.78	4388135.0
2016-08-17 13:00:00	SPY	ETF	217.79	217.82	217.66	217.74	2368189.0
2016-08-17 13:30:00	SPY	ETF	217.74	218.12	217.715	217.7501	4588567.0
2016-08-17 14:00:00	SPY	ETF	217.76	218.4	217.38	218.18	11697841.0
2016-08-17 14:30:00	SPY	ETF	218.19	218.28	217.93	218.19	4437597.0
2016-08-17 15:00:00	SPY	ETF	218.195	218.31	217.96	218.28	4849184.0
2016-08-17 15:30:00	SPY	ETF	218.275	218.53	218.24	218.37	7998562.0
2016-08-17 16:00:00	SPY	ETF	218.36	218.55	218.33	218.43	3028562.0
2016-08-17 16:30:00	SPY	ETF	218.45	218.62	218.37	218.55	1212359.0
2016-08-17 17:00:00	SPY	ETF	218.55	218.57	218.5	218.53	64207.0
2016-08-17 17:30:00	SPY	ETF	218.53	218.53	218.46	218.5	133086.0
2016-08-17 18:00:00	SPY	ETF	218.53	218.58	218.48	218.51	108167.0
2016-08-17 18:30:00	SPY	ETF	218.51	218.52	218.43	218.43	17524.0
2016-08-17 19:00:00	SPY	ETF	218.49	218.49	218.45	218.45	6111.0
2016-08-17 19:30:00	SPY	ETF	218.45	218.45	218.36	218.42	468487.0
2016-08-17 04:00:00	QQQ	ETF	117.05	117.05	116.81	116.88	2400.0
2016-08-17 04:30:00	QQQ	ETF	116.94	117.03	116.94	117.03	200.0
2016-08-17 05:30:00	QQQ	ETF	117.14	117.15	117.14	117.15	3497.0
2016-08-17 07:00:00	QQQ	ETF	117.04	117.08	117.03	117.08	9999.0
2016-08-17 07:30:00	QQQ	ETF	117.11	117.23	117.11	117.22	122284.0
2016-08-17 08:00:00	QQQ	ETF	117.23	117.23	117.04	117.17	14261.0
2016-08-17 08:30:00	QQQ	ETF	117.21	117.22	117.19	117.19	14700.0
2016-08-17 09:00:00	QQQ	ETF	117.22	117.22	117.06	117.09	135394.0
2016-08-17 09:30:00	QQQ	ETF	117.08	117.14	116.68	116.74	1840974.0
2016-08-17 10:00:00	QQQ	ETF	116.74	116.775	116.6	116.72	927976.0
2016-08-17 10:30:00	QQQ	ETF	116.72	116.8	116.65	116.69	744104.0
2016-08-17 11:00:00	QQQ	ETF	116.69	116.78	116.54	116.585	603975.0
2016-08-17 11:30:00	QQQ	ETF	116.58	116.58	116.43	116.45	787326.0
2016-08-17 12:00:00	QQQ	ETF	116.44	116.6	116.44	116.5999	371018.0
2016-08-17 12:30:00	QQQ	ETF	116.6	117.02	116.58	116.98	928821.0
2016-08-17 13:00:00	QQQ	ETF	116.98	117.0	116.89	116.945	713656.0
2016-08-17 13:30:00	QQQ	ETF	116.94	117.17	116.91	116.93	889710.0
2016-08-17 14:00:00	QQQ	ETF	116.92	117.3	116.65	117.16	1972098.0

> showing 50 of 13,563 rows — these rows as CSV

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