PREVIEW / etf_30min / 2016-12-01

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-01.parquet
  size:    447 KB
  rows:    15,137

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-12-01 04:00:00	SPY	ETF	220.29	220.29	220.19	220.19	1273.0
2016-12-01 04:30:00	SPY	ETF	220.15	220.15	220.04	220.11	17460.0
2016-12-01 05:00:00	SPY	ETF	220.06	220.27	220.06	220.21	3918.0
2016-12-01 05:30:00	SPY	ETF	220.27	220.27	220.1	220.1	3248.0
2016-12-01 06:00:00	SPY	ETF	220.1	220.17	220.06	220.17	18501.0
2016-12-01 06:30:00	SPY	ETF	220.16	220.25	220.16	220.23	2000.0
2016-12-01 07:00:00	SPY	ETF	220.25	220.25	220.07	220.08	29928.0
2016-12-01 07:30:00	SPY	ETF	220.11	220.25	220.07	220.19	29858.0
2016-12-01 08:00:00	SPY	ETF	220.15	220.33	220.07	220.3	212853.0
2016-12-01 08:30:00	SPY	ETF	220.31	220.75	220.31	220.68	538137.0
2016-12-01 09:00:00	SPY	ETF	220.68	220.83	220.38	220.71	472141.0
2016-12-01 09:30:00	SPY	ETF	220.73	220.73	220.0	220.3328	9450382.0
2016-12-01 10:00:00	SPY	ETF	220.35	220.7075	220.14	220.245	6059899.0
2016-12-01 10:30:00	SPY	ETF	220.26	220.435	219.79	220.0062	6533782.0
2016-12-01 11:00:00	SPY	ETF	220.01	220.24	219.85	220.05	5534133.0
2016-12-01 11:30:00	SPY	ETF	220.05	220.39	220.0	220.18	4033632.0
2016-12-01 12:00:00	SPY	ETF	220.19	220.22	219.89	219.91	3835238.0
2016-12-01 12:30:00	SPY	ETF	219.9161	220.1	219.55	219.63	5154782.0
2016-12-01 13:00:00	SPY	ETF	219.63	219.63	219.29	219.415	3992793.0
2016-12-01 13:30:00	SPY	ETF	219.42	219.64	219.27	219.29	3539525.0
2016-12-01 14:00:00	SPY	ETF	219.3	219.73	219.29	219.45	3147119.0
2016-12-01 14:30:00	SPY	ETF	219.45	219.6571	219.4	219.58	2454645.0
2016-12-01 15:00:00	SPY	ETF	219.57	219.63	219.24	219.31	3907862.0
2016-12-01 15:30:00	SPY	ETF	219.31	220.11	219.15	219.52	12900328.0
2016-12-01 16:00:00	SPY	ETF	219.51	219.82	219.51	219.66	3418905.0
2016-12-01 16:30:00	SPY	ETF	219.68	219.71	219.57	219.69	421556.0
2016-12-01 17:00:00	SPY	ETF	219.62	219.63	219.55	219.55	118538.0
2016-12-01 17:30:00	SPY	ETF	219.57	219.59	219.54	219.59	21346.0
2016-12-01 18:00:00	SPY	ETF	219.56	219.57	219.37	219.51	89768.0
2016-12-01 18:30:00	SPY	ETF	219.48	219.5	219.45	219.5	18724.0
2016-12-01 19:00:00	SPY	ETF	219.52	219.65	219.52	219.62	28216.0
2016-12-01 19:30:00	SPY	ETF	219.62	219.68	219.55	219.55	16639.0
2016-12-01 04:30:00	QQQ	ETF	117.3	117.3	117.3	117.3	1000.0
2016-12-01 05:00:00	QQQ	ETF	117.32	117.32	117.32	117.32	500.0
2016-12-01 05:30:00	QQQ	ETF	117.44	117.44	117.35	117.36	2477.0
2016-12-01 06:00:00	QQQ	ETF	117.33	117.36	117.33	117.36	300.0
2016-12-01 06:30:00	QQQ	ETF	117.4	117.4	117.4	117.4	600.0
2016-12-01 07:00:00	QQQ	ETF	117.35	117.35	117.29	117.29	10998.0
2016-12-01 07:30:00	QQQ	ETF	117.29	117.42	117.29	117.4	10403.0
2016-12-01 08:00:00	QQQ	ETF	117.4	117.4	117.29	117.39	59889.0
2016-12-01 08:30:00	QQQ	ETF	117.4	117.61	117.4	117.56	53786.0
2016-12-01 09:00:00	QQQ	ETF	117.57	117.65	117.41	117.47	284092.0
2016-12-01 09:30:00	QQQ	ETF	117.46	117.47	116.565	116.78	4594765.0
2016-12-01 10:00:00	QQQ	ETF	116.79	117.16	116.4	116.4238	2871520.0
2016-12-01 10:30:00	QQQ	ETF	116.41	116.4193	115.57	115.9	4318195.0
2016-12-01 11:00:00	QQQ	ETF	115.9	116.24	115.81	116.09	3261166.0
2016-12-01 11:30:00	QQQ	ETF	116.09	116.2	115.88	115.955	1172912.0
2016-12-01 12:00:00	QQQ	ETF	115.955	115.98	115.6549	115.6844	1342640.0
2016-12-01 12:30:00	QQQ	ETF	115.69	115.895	115.53	115.61	1506260.0
2016-12-01 13:00:00	QQQ	ETF	115.605	115.61	115.3655	115.5135	2081676.0

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

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