PREVIEW / etf_30min / 2016-08-10

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-10.parquet
  size:    390 KB
  rows:    13,262

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-10 04:00:00	SPY	ETF	218.1	218.37	218.1	218.3	2580.0
2016-08-10 04:30:00	SPY	ETF	218.32	218.4	218.32	218.4	103100.0
2016-08-10 05:00:00	SPY	ETF	218.44	218.55	218.42	218.53	51900.0
2016-08-10 05:30:00	SPY	ETF	218.5	218.5	218.28	218.28	2648.0
2016-08-10 06:00:00	SPY	ETF	218.28	218.35	218.28	218.32	2895.0
2016-08-10 06:30:00	SPY	ETF	218.34	218.38	218.27	218.27	13467.0
2016-08-10 07:00:00	SPY	ETF	218.25	218.5	218.25	218.49	21300.0
2016-08-10 07:30:00	SPY	ETF	218.48	218.53	218.35	218.37	47752.0
2016-08-10 08:00:00	SPY	ETF	218.38	218.48	218.37	218.48	76690.0
2016-08-10 08:30:00	SPY	ETF	218.48	218.51	218.4	218.47	120446.0
2016-08-10 09:00:00	SPY	ETF	218.47	218.52	218.29	218.3	308774.0
2016-08-10 09:30:00	SPY	ETF	218.31	218.4038	217.94	217.94	6306184.0
2016-08-10 10:00:00	SPY	ETF	217.94	218.25	217.9	218.08	4025208.0
2016-08-10 10:30:00	SPY	ETF	218.08	218.219	217.94	218.04	2913396.0
2016-08-10 11:00:00	SPY	ETF	218.031	218.19	217.5	217.56	6922233.0
2016-08-10 11:30:00	SPY	ETF	217.56	217.6	217.43	217.52	2884618.0
2016-08-10 12:00:00	SPY	ETF	217.52	217.78	217.45	217.695	2464165.0
2016-08-10 12:30:00	SPY	ETF	217.69	217.8199	217.63	217.8199	1857793.0
2016-08-10 13:00:00	SPY	ETF	217.8199	217.825	217.56	217.645	2112499.0
2016-08-10 13:30:00	SPY	ETF	217.65	217.77	217.54	217.591	2306333.0
2016-08-10 14:00:00	SPY	ETF	217.592	217.74	217.23	217.32	3797754.0
2016-08-10 14:30:00	SPY	ETF	217.33	217.42	217.23	217.345	2869846.0
2016-08-10 15:00:00	SPY	ETF	217.34	217.73	217.26	217.57	3874662.0
2016-08-10 15:30:00	SPY	ETF	217.57	217.64	217.33	217.64	7074226.0
2016-08-10 16:00:00	SPY	ETF	217.64	218.2149	217.62	217.68	4614189.0
2016-08-10 16:30:00	SPY	ETF	217.68	217.72	217.591	217.7	503276.0
2016-08-10 17:00:00	SPY	ETF	217.64	217.7	217.61	217.68	197618.0
2016-08-10 17:30:00	SPY	ETF	217.69	217.69	217.62	217.62	48245.0
2016-08-10 18:00:00	SPY	ETF	217.63	217.64	217.43	217.49	92090.0
2016-08-10 18:30:00	SPY	ETF	217.49	217.54	217.47	217.48	19510.0
2016-08-10 19:00:00	SPY	ETF	217.55	217.59	217.5	217.59	8001.0
2016-08-10 19:30:00	SPY	ETF	217.59	217.62	217.52	217.56	14338.0
2016-08-10 04:00:00	QQQ	ETF	116.95	116.97	116.95	116.97	200.0
2016-08-10 05:00:00	QQQ	ETF	117.03	117.1	117.03	117.1	200.0
2016-08-10 05:30:00	QQQ	ETF	116.95	116.95	116.94	116.94	4500.0
2016-08-10 06:30:00	QQQ	ETF	116.96	116.96	116.95	116.96	700.0
2016-08-10 07:00:00	QQQ	ETF	116.94	117.07	116.94	117.07	6051.0
2016-08-10 07:30:00	QQQ	ETF	117.08	117.09	116.99	116.99	60843.0
2016-08-10 08:00:00	QQQ	ETF	117.02	117.08	117.0	117.08	6007.0
2016-08-10 08:30:00	QQQ	ETF	117.04	117.08	117.03	117.05	10485.0
2016-08-10 09:00:00	QQQ	ETF	117.08	117.08	116.95	116.96	41269.0
2016-08-10 09:30:00	QQQ	ETF	116.96	117.02	116.74	116.74	1016723.0
2016-08-10 10:00:00	QQQ	ETF	116.75	116.99	116.75	116.8	878218.0
2016-08-10 10:30:00	QQQ	ETF	116.79	116.86	116.71	116.765	1742523.0
2016-08-10 11:00:00	QQQ	ETF	116.765	116.84	116.41	116.46	1850051.0
2016-08-10 11:30:00	QQQ	ETF	116.46	116.4674	116.31	116.4458	541182.0
2016-08-10 12:00:00	QQQ	ETF	116.44	116.62	116.4299	116.565	362453.0
2016-08-10 12:30:00	QQQ	ETF	116.561	116.71	116.56	116.69	274985.0
2016-08-10 13:00:00	QQQ	ETF	116.7	116.71	116.58	116.63	1175554.0
2016-08-10 13:30:00	QQQ	ETF	116.62	116.68	116.56	116.59	287070.0

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

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