PREVIEW / etf_30min / 2016-11-07

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-07.parquet
  size:    426 KB
  rows:    14,433

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-07 04:00:00	SPY	ETF	209.86	211.61	209.86	211.61	34217.0
2016-11-07 04:30:00	SPY	ETF	211.6	211.66	211.53	211.54	30457.0
2016-11-07 05:00:00	SPY	ETF	211.54	211.54	211.28	211.29	38760.0
2016-11-07 05:30:00	SPY	ETF	211.31	211.52	211.3	211.44	24885.0
2016-11-07 06:00:00	SPY	ETF	211.48	211.51	211.27	211.33	70158.0
2016-11-07 06:30:00	SPY	ETF	211.35	211.38	211.26	211.3	115019.0
2016-11-07 07:00:00	SPY	ETF	211.29	211.31	211.1	211.11	340904.0
2016-11-07 07:30:00	SPY	ETF	211.11	211.37	211.11	211.27	401402.0
2016-11-07 08:00:00	SPY	ETF	211.27	211.4	211.12	211.39	514341.0
2016-11-07 08:30:00	SPY	ETF	211.39	211.47	211.39	211.42	262306.0
2016-11-07 09:00:00	SPY	ETF	211.41	211.54	211.4	211.45	925114.0
2016-11-07 09:30:00	SPY	ETF	211.45	211.85	211.3	211.7589	12171911.0
2016-11-07 10:00:00	SPY	ETF	211.76	211.9	211.71	211.855	5690058.0
2016-11-07 10:30:00	SPY	ETF	211.855	212.365	211.84	212.34	7098120.0
2016-11-07 11:00:00	SPY	ETF	212.34	212.57	212.32	212.45	5743131.0
2016-11-07 11:30:00	SPY	ETF	212.45	212.79	212.45	212.78	7045071.0
2016-11-07 12:00:00	SPY	ETF	212.775	212.91	212.75	212.835	7018029.0
2016-11-07 12:30:00	SPY	ETF	212.84	212.88	212.64	212.775	3712470.0
2016-11-07 13:00:00	SPY	ETF	212.7758	212.86	212.665	212.73	3659948.0
2016-11-07 13:30:00	SPY	ETF	212.7211	212.94	212.715	212.89	2953189.0
2016-11-07 14:00:00	SPY	ETF	212.89	212.93	212.76	212.84	4608983.0
2016-11-07 14:30:00	SPY	ETF	212.84	212.9	212.46	212.57	6336139.0
2016-11-07 15:00:00	SPY	ETF	212.57	212.68	212.41	212.58	6749680.0
2016-11-07 15:30:00	SPY	ETF	212.58	213.19	212.39	213.1	19772940.0
2016-11-07 16:00:00	SPY	ETF	213.12	213.49	213.05	213.35	9188422.0
2016-11-07 16:30:00	SPY	ETF	213.36	213.52	213.15	213.46	1706885.0
2016-11-07 17:00:00	SPY	ETF	213.45	213.45	213.15	213.43	243360.0
2016-11-07 17:30:00	SPY	ETF	213.41	213.43	213.36	213.37	72096.0
2016-11-07 18:00:00	SPY	ETF	213.36	213.42	213.31	213.34	150858.0
2016-11-07 18:30:00	SPY	ETF	213.35	213.37	213.22	213.26	74546.0
2016-11-07 19:00:00	SPY	ETF	213.25	213.25	213.12	213.14	56769.0
2016-11-07 19:30:00	SPY	ETF	213.15	213.2	213.07	213.19	57541.0
2016-11-07 04:00:00	QQQ	ETF	115.35	115.6	115.32	115.6	3468.0
2016-11-07 04:30:00	QQQ	ETF	115.6	115.6	115.53	115.57	12514.0
2016-11-07 05:00:00	QQQ	ETF	115.5	115.5	115.49	115.5	5371.0
2016-11-07 05:30:00	QQQ	ETF	115.43	115.46	115.43	115.46	1549.0
2016-11-07 06:00:00	QQQ	ETF	115.49	115.5	115.44	115.44	4679.0
2016-11-07 06:30:00	QQQ	ETF	115.47	115.47	115.35	115.36	60246.0
2016-11-07 07:00:00	QQQ	ETF	115.36	115.38	115.3	115.31	57489.0
2016-11-07 07:30:00	QQQ	ETF	115.27	115.39	115.27	115.38	11078.0
2016-11-07 08:00:00	QQQ	ETF	115.37	115.45	115.27	115.43	159323.0
2016-11-07 08:30:00	QQQ	ETF	115.42	115.48	115.4	115.41	93997.0
2016-11-07 09:00:00	QQQ	ETF	115.43	115.47	115.36	115.44	391074.0
2016-11-07 09:30:00	QQQ	ETF	115.44	115.61	115.3	115.5737	2824335.0
2016-11-07 10:00:00	QQQ	ETF	115.58	115.74	115.57	115.7382	1648619.0
2016-11-07 10:30:00	QQQ	ETF	115.7345	116.078	115.71	116.078	1390578.0
2016-11-07 11:00:00	QQQ	ETF	116.08	116.29	116.08	116.23	1406625.0
2016-11-07 11:30:00	QQQ	ETF	116.24	116.4	116.24	116.36	1460966.0
2016-11-07 12:00:00	QQQ	ETF	116.37	116.4599	116.27	116.33	1260230.0
2016-11-07 12:30:00	QQQ	ETF	116.34	116.36	116.23	116.32	977928.0

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

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