PREVIEW / etf_30min / 2016-11-02

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-02.parquet
  size:    416 KB
  rows:    14,177

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.08	210.23	23927.0
2016-11-02 04:30:00	SPY	ETF	210.12	210.28	210.07	210.28	2528.0
2016-11-02 05:00:00	SPY	ETF	210.25	210.31	210.25	210.31	1994.0
2016-11-02 05:30:00	SPY	ETF	210.22	210.61	210.22	210.61	7429.0
2016-11-02 06:00:00	SPY	ETF	210.61	210.61	210.33	210.33	14436.0
2016-11-02 06:30:00	SPY	ETF	210.37	210.5	210.32	210.5	11231.0
2016-11-02 07:00:00	SPY	ETF	210.44	210.92	210.44	210.81	318357.0
2016-11-02 07:30:00	SPY	ETF	210.78	210.87	210.66	210.77	95256.0
2016-11-02 08:00:00	SPY	ETF	210.55	210.87	210.25	210.65	350244.0
2016-11-02 08:30:00	SPY	ETF	210.66	210.73	210.32	210.63	840932.0
2016-11-02 09:00:00	SPY	ETF	210.67	210.79	210.6	210.67	604797.0
2016-11-02 09:30:00	SPY	ETF	210.65	211.02	210.43	210.89	9302630.0
2016-11-02 10:00:00	SPY	ETF	210.88	211.1	210.43	210.625	6316849.0
2016-11-02 10:30:00	SPY	ETF	210.63	210.64	210.12	210.2	9550223.0
2016-11-02 11:00:00	SPY	ETF	210.19	210.72	210.16	210.537	4412309.0
2016-11-02 11:30:00	SPY	ETF	210.53	210.58	210.215	210.3354	3479202.0
2016-11-02 12:00:00	SPY	ETF	210.33	210.53	210.2	210.34	3517009.0
2016-11-02 12:30:00	SPY	ETF	210.35	210.43	210.18	210.41	2610249.0
2016-11-02 13:00:00	SPY	ETF	210.4	210.5	209.69	209.9	4983371.0
2016-11-02 13:30:00	SPY	ETF	209.89	210.225	209.75	209.98	5455346.0
2016-11-02 14:00:00	SPY	ETF	209.98	210.8416	209.23	210.16	13939860.0
2016-11-02 14:30:00	SPY	ETF	210.16	210.43	209.79	209.9225	7489137.0
2016-11-02 15:00:00	SPY	ETF	209.92	210.4	209.82	210.33	6796610.0
2016-11-02 15:30:00	SPY	ETF	210.32	210.37	209.6	209.7	12024699.0
2016-11-02 16:00:00	SPY	ETF	209.7	209.88	209.35	209.81	7834365.0
2016-11-02 16:30:00	SPY	ETF	209.8	213.12	209.44	209.5	1009274.0
2016-11-02 17:00:00	SPY	ETF	209.52	209.54	209.24	209.3	153714.0
2016-11-02 17:30:00	SPY	ETF	209.28	209.28	209.06	209.2	146170.0
2016-11-02 18:00:00	SPY	ETF	209.19	209.5	209.19	209.35	335640.0
2016-11-02 18:30:00	SPY	ETF	209.34	209.38	209.33	209.38	26820.0
2016-11-02 19:00:00	SPY	ETF	209.4	209.63	209.4	209.62	87321.0
2016-11-02 19:30:00	SPY	ETF	209.63	209.74	209.62	209.64	69933.0
2016-11-02 04:00:00	QQQ	ETF	115.71	115.71	115.65	115.65	1200.0
2016-11-02 04:30:00	QQQ	ETF	115.67	115.67	115.65	115.65	2200.0
2016-11-02 05:00:00	QQQ	ETF	115.75	115.75	115.75	115.75	200.0
2016-11-02 05:30:00	QQQ	ETF	115.79	115.79	115.79	115.79	100.0
2016-11-02 06:00:00	QQQ	ETF	115.79	115.79	115.79	115.79	1000.0
2016-11-02 06:30:00	QQQ	ETF	115.82	115.82	115.82	115.82	600.0
2016-11-02 07:00:00	QQQ	ETF	115.9	116.1	115.9	116.06	60142.0
2016-11-02 07:30:00	QQQ	ETF	116.03	116.09	116.02	116.05	53104.0
2016-11-02 08:00:00	QQQ	ETF	116.05	116.09	116.03	116.03	19517.0
2016-11-02 08:30:00	QQQ	ETF	116.03	116.05	115.9	116.05	98162.0
2016-11-02 09:00:00	QQQ	ETF	116.1	116.12	116.02	116.06	88364.0
2016-11-02 09:30:00	QQQ	ETF	116.05	116.24	115.89	116.16	1817844.0
2016-11-02 10:00:00	QQQ	ETF	116.15	116.3	115.88	115.9881	1084361.0
2016-11-02 10:30:00	QQQ	ETF	115.985	115.99	115.71	115.74	1622283.0
2016-11-02 11:00:00	QQQ	ETF	115.74	116.115	115.73	116.04	1005210.0
2016-11-02 11:30:00	QQQ	ETF	116.03	116.03	115.7677	115.81	894539.0
2016-11-02 12:00:00	QQQ	ETF	115.8	115.8773	115.63	115.7	952015.0
2016-11-02 12:30:00	QQQ	ETF	115.71	115.725	115.57	115.65	695967.0

> showing 50 of 14,177 rows — these rows as CSV

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