PREVIEW / etf_30min / 2016-09-02

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-02.parquet
  size:    394 KB
  rows:    13,437

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-09-02 04:00:00	SPY	ETF	217.25	217.3	217.2	217.26	2826.0
2016-09-02 04:30:00	SPY	ETF	217.3	217.33	217.18	217.24	6112.0
2016-09-02 05:00:00	SPY	ETF	217.27	217.45	217.27	217.43	13712.0
2016-09-02 05:30:00	SPY	ETF	217.4	217.43	217.33	217.38	4107.0
2016-09-02 06:00:00	SPY	ETF	217.37	217.37	217.27	217.27	2198.0
2016-09-02 06:30:00	SPY	ETF	217.33	217.44	217.33	217.4	4843.0
2016-09-02 07:00:00	SPY	ETF	217.39	217.44	217.31	217.32	46329.0
2016-09-02 07:30:00	SPY	ETF	217.32	217.33	217.15	217.21	78426.0
2016-09-02 08:00:00	SPY	ETF	217.21	217.37	216.97	217.1	579986.0
2016-09-02 08:30:00	SPY	ETF	217.11	218.03	217.1	217.97	2355064.0
2016-09-02 09:00:00	SPY	ETF	217.97	218.42	217.91	218.41	1213502.0
2016-09-02 09:30:00	SPY	ETF	218.39	218.85	218.26	218.73	12669242.0
2016-09-02 10:00:00	SPY	ETF	218.74	218.87	218.291	218.57	8198396.0
2016-09-02 10:30:00	SPY	ETF	218.58	218.6	218.33	218.37	4061716.0
2016-09-02 11:00:00	SPY	ETF	218.38	218.64	218.23	218.255	4626030.0
2016-09-02 11:30:00	SPY	ETF	218.255	218.3963	218.17	218.35	3320929.0
2016-09-02 12:00:00	SPY	ETF	218.35	218.39	217.8	217.94	4257003.0
2016-09-02 12:30:00	SPY	ETF	217.94	218.21	217.92	218.08	2520740.0
2016-09-02 13:00:00	SPY	ETF	218.07	218.17	217.98	218.0465	2479545.0
2016-09-02 13:30:00	SPY	ETF	218.04	218.06	217.7	217.85	3362097.0
2016-09-02 14:00:00	SPY	ETF	217.85	218.18	217.82	218.105	3856864.0
2016-09-02 14:30:00	SPY	ETF	218.11	218.28	218.04	218.27	3100414.0
2016-09-02 15:00:00	SPY	ETF	218.26	218.45	218.19	218.36	5285733.0
2016-09-02 15:30:00	SPY	ETF	218.36	218.44	218.19	218.37	11480393.0
2016-09-02 16:00:00	SPY	ETF	218.37	218.4	218.3	218.35	3801812.0
2016-09-02 16:30:00	SPY	ETF	218.35	218.43	218.32	218.43	326041.0
2016-09-02 17:00:00	SPY	ETF	218.42	218.49	218.33	218.45	162625.0
2016-09-02 17:30:00	SPY	ETF	218.47	218.54	218.44	218.54	78991.0
2016-09-02 18:00:00	SPY	ETF	218.52	218.52	218.46	218.49	17677.0
2016-09-02 18:30:00	SPY	ETF	218.49	218.52	218.39	218.39	54662.0
2016-09-02 19:00:00	SPY	ETF	218.4	218.4	218.36	218.36	31522.0
2016-09-02 19:30:00	SPY	ETF	218.35	218.43	218.33	218.34	7753.0
2016-09-02 04:30:00	QQQ	ETF	116.74	116.8	116.74	116.8	11300.0
2016-09-02 05:00:00	QQQ	ETF	116.8	116.8	116.8	116.8	100.0
2016-09-02 05:30:00	QQQ	ETF	116.79	116.79	116.79	116.79	10000.0
2016-09-02 07:00:00	QQQ	ETF	116.78	116.81	116.78	116.81	3300.0
2016-09-02 07:30:00	QQQ	ETF	116.75	116.75	116.75	116.75	100.0
2016-09-02 08:00:00	QQQ	ETF	116.78	116.79	116.61	116.75	236655.0
2016-09-02 08:30:00	QQQ	ETF	116.68	117.15	116.68	117.12	402025.0
2016-09-02 09:00:00	QQQ	ETF	117.14	117.33	117.07	117.33	241458.0
2016-09-02 09:30:00	QQQ	ETF	117.32	117.5	117.12	117.46	3272231.0
2016-09-02 10:00:00	QQQ	ETF	117.47	117.56	117.325	117.43	1972819.0
2016-09-02 10:30:00	QQQ	ETF	117.43	117.45	117.28	117.3	1151121.0
2016-09-02 11:00:00	QQQ	ETF	117.31	117.42	117.12	117.13	1235227.0
2016-09-02 11:30:00	QQQ	ETF	117.13	117.21	117.08	117.17	644065.0
2016-09-02 12:00:00	QQQ	ETF	117.17	117.19	116.81	116.91	1112323.0
2016-09-02 12:30:00	QQQ	ETF	116.91	117.02	116.87	116.93	772488.0
2016-09-02 13:00:00	QQQ	ETF	116.93	116.96	116.81	116.8465	649384.0
2016-09-02 13:30:00	QQQ	ETF	116.85	116.85	116.68	116.76	914781.0
2016-09-02 14:00:00	QQQ	ETF	116.76	116.9565	116.74	116.91	575220.0

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

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