PREVIEW / etf_30min / 2016-11-09

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-09.parquet
  size:    472 KB
  rows:    15,839

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-09 04:00:00	SPY	ETF	210.14	211.38	209.57	209.85	362238.0
2016-11-09 04:30:00	SPY	ETF	209.82	210.89	209.7	210.22	330531.0
2016-11-09 05:00:00	SPY	ETF	210.19	210.8	209.31	210.09	325666.0
2016-11-09 05:30:00	SPY	ETF	210.13	210.61	209.68	210.0	392019.0
2016-11-09 06:00:00	SPY	ETF	210.0	210.0	208.54	208.76	630940.0
2016-11-09 06:30:00	SPY	ETF	208.75	209.53	208.31	209.49	1335702.0
2016-11-09 07:00:00	SPY	ETF	209.48	210.39	209.4	210.2	2172356.0
2016-11-09 07:30:00	SPY	ETF	210.18	211.55	210.1	211.44	3270110.0
2016-11-09 08:00:00	SPY	ETF	211.44	215.6	203.35	210.73	8574919.0
2016-11-09 08:30:00	SPY	ETF	210.72	211.52	210.51	211.5	2444360.0
2016-11-09 09:00:00	SPY	ETF	211.53	212.42	205.4	212.39	4919718.0
2016-11-09 09:30:00	SPY	ETF	212.37	214.63	212.34	214.43	54303029.0
2016-11-09 10:00:00	SPY	ETF	214.43	214.45	213.04	213.56	21471810.0
2016-11-09 10:30:00	SPY	ETF	213.55	213.96	213.04	213.82	14722261.0
2016-11-09 11:00:00	SPY	ETF	213.8	215.08	213.79	215.07	15107672.0
2016-11-09 11:30:00	SPY	ETF	215.065	216.45	215.06	215.99	18773851.0
2016-11-09 12:00:00	SPY	ETF	215.995	216.1	215.08	215.5	10105769.0
2016-11-09 12:30:00	SPY	ETF	215.5	216.03	214.87	215.96	8045440.0
2016-11-09 13:00:00	SPY	ETF	215.961	216.25	215.21	215.3999	10195540.0
2016-11-09 13:30:00	SPY	ETF	215.4	216.21	215.31	215.8372	7713177.0
2016-11-09 14:00:00	SPY	ETF	215.835	216.34	215.73	216.1301	8380754.0
2016-11-09 14:30:00	SPY	ETF	216.13	216.915	216.11	216.45	10897066.0
2016-11-09 15:00:00	SPY	ETF	216.445	217.1	216.44	216.87	10961417.0
2016-11-09 15:30:00	SPY	ETF	216.87	216.9192	216.04	216.41	27194060.0
2016-11-09 16:00:00	SPY	ETF	216.43	216.7	214.46	216.59	11329165.0
2016-11-09 16:30:00	SPY	ETF	216.59	216.6	215.72	216.53	2494447.0
2016-11-09 17:00:00	SPY	ETF	216.53	216.54	216.44	216.5	203302.0
2016-11-09 17:30:00	SPY	ETF	216.5	216.52	216.45	216.45	75726.0
2016-11-09 18:00:00	SPY	ETF	216.44	216.44	216.02	216.08	150263.0
2016-11-09 18:30:00	SPY	ETF	216.06	216.2	216.03	216.17	35522.0
2016-11-09 19:00:00	SPY	ETF	216.2	216.22	216.05	216.16	56054.0
2016-11-09 19:30:00	SPY	ETF	216.17	216.69	216.15	216.5	149273.0
2016-11-09 04:00:00	QQQ	ETF	114.5	115.0	113.83	114.04	73471.0
2016-11-09 04:30:00	QQQ	ETF	114.02	114.93	114.02	114.71	36401.0
2016-11-09 05:00:00	QQQ	ETF	114.47	114.49	114.25	114.46	8675.0
2016-11-09 05:30:00	QQQ	ETF	114.68	114.91	114.43	114.51	7777.0
2016-11-09 06:00:00	QQQ	ETF	114.58	114.58	113.64	113.79	72826.0
2016-11-09 06:30:00	QQQ	ETF	113.78	114.11	113.58	114.1	26035.0
2016-11-09 07:00:00	QQQ	ETF	114.29	114.8	114.23	114.52	108236.0
2016-11-09 07:30:00	QQQ	ETF	114.7	115.25	114.67	115.23	744440.0
2016-11-09 08:00:00	QQQ	ETF	115.26	115.48	111.7	114.76	799888.0
2016-11-09 08:30:00	QQQ	ETF	114.75	115.12	114.7	115.12	489174.0
2016-11-09 09:00:00	QQQ	ETF	115.11	115.74	115.09	115.71	1971227.0
2016-11-09 09:30:00	QQQ	ETF	115.71	117.16	115.6	116.88	12810103.0
2016-11-09 10:00:00	QQQ	ETF	116.88	116.89	115.92	116.24	5298068.0
2016-11-09 10:30:00	QQQ	ETF	116.23	116.525	115.82	116.42	3873302.0
2016-11-09 11:00:00	QQQ	ETF	116.41	117.02	116.41	117.02	2868126.0
2016-11-09 11:30:00	QQQ	ETF	117.02	117.82	117.01	117.42	4003640.0
2016-11-09 12:00:00	QQQ	ETF	117.43	117.53	116.88	117.28	2314114.0
2016-11-09 12:30:00	QQQ	ETF	117.28	117.625	117.17	117.59	1689855.0

> showing 50 of 15,839 rows — these rows as CSV

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