PREVIEW / etf_30min / 2016-10-31

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-31.parquet
  size:    396 KB
  rows:    13,613

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-10-31 04:00:00	SPY	ETF	212.88	213.24	212.88	213.24	2943.0
2016-10-31 04:30:00	SPY	ETF	213.15	213.15	213.0	213.0	5626.0
2016-10-31 05:00:00	SPY	ETF	213.1	213.1	212.88	212.92	13040.0
2016-10-31 05:30:00	SPY	ETF	213.0	213.0	213.0	213.0	4000.0
2016-10-31 06:00:00	SPY	ETF	213.0	213.18	213.0	213.1	3803.0
2016-10-31 06:30:00	SPY	ETF	213.04	213.04	212.88	212.88	1753.0
2016-10-31 07:00:00	SPY	ETF	212.9	213.0	212.85	212.94	11057.0
2016-10-31 07:30:00	SPY	ETF	212.96	213.11	212.96	213.11	48621.0
2016-10-31 08:00:00	SPY	ETF	213.07	213.308	212.84	213.0	284837.0
2016-10-31 08:30:00	SPY	ETF	213.05	213.3	212.99	213.14	412114.0
2016-10-31 09:00:00	SPY	ETF	213.14	213.17	212.91	212.95	456177.0
2016-10-31 09:30:00	SPY	ETF	212.93	213.0	212.62	212.62	7457619.0
2016-10-31 10:00:00	SPY	ETF	212.63	212.91	212.57	212.9099	3155907.0
2016-10-31 10:30:00	SPY	ETF	212.91	212.93	212.43	212.66	4703813.0
2016-10-31 11:00:00	SPY	ETF	212.66	213.03	212.55	213.0189	3398726.0
2016-10-31 11:30:00	SPY	ETF	213.01	213.19	212.945	213.115	3536442.0
2016-10-31 12:00:00	SPY	ETF	213.11	213.17	212.78	212.965	2491070.0
2016-10-31 12:30:00	SPY	ETF	212.97	213.08	212.86	212.93	1758446.0
2016-10-31 13:00:00	SPY	ETF	212.93	212.98	212.73	212.7655	1984968.0
2016-10-31 13:30:00	SPY	ETF	212.76	212.9	212.66	212.68	1749522.0
2016-10-31 14:00:00	SPY	ETF	212.685	212.76	212.42	212.45	3040582.0
2016-10-31 14:30:00	SPY	ETF	212.44	212.6	212.36	212.515	3763833.0
2016-10-31 15:00:00	SPY	ETF	212.52	212.71	212.44	212.68	5520853.0
2016-10-31 15:30:00	SPY	ETF	212.68	212.78	212.39	212.51	9877386.0
2016-10-31 16:00:00	SPY	ETF	212.53	212.86	212.4	212.73	4097100.0
2016-10-31 16:30:00	SPY	ETF	212.73	212.84	212.73	212.77	479768.0
2016-10-31 17:00:00	SPY	ETF	212.74	212.78	212.55	212.7	190432.0
2016-10-31 17:30:00	SPY	ETF	212.73	212.78	212.7	212.78	32238.0
2016-10-31 18:00:00	SPY	ETF	212.78	212.83	212.55	212.76	495421.0
2016-10-31 18:30:00	SPY	ETF	212.76	212.78	212.7	212.7	33773.0
2016-10-31 19:00:00	SPY	ETF	212.72	212.8	212.7	212.76	14380.0
2016-10-31 19:30:00	SPY	ETF	212.79	212.79	212.7	212.71	31784.0
2016-10-31 04:00:00	QQQ	ETF	117.7	117.7	117.66	117.67	4178.0
2016-10-31 04:30:00	QQQ	ETF	117.65	117.65	117.59	117.59	1399.0
2016-10-31 05:00:00	QQQ	ETF	117.61	117.61	116.87	117.52	8096.0
2016-10-31 06:00:00	QQQ	ETF	117.57	117.61	117.57	117.61	800.0
2016-10-31 06:30:00	QQQ	ETF	117.61	117.61	117.47	117.47	1598.0
2016-10-31 07:00:00	QQQ	ETF	117.47	117.53	117.45	117.5	11348.0
2016-10-31 07:30:00	QQQ	ETF	117.5	117.58	117.5	117.57	15550.0
2016-10-31 08:00:00	QQQ	ETF	117.6	117.6	117.52	117.53	25950.0
2016-10-31 08:30:00	QQQ	ETF	117.55	117.7	117.54	117.64	41187.0
2016-10-31 09:00:00	QQQ	ETF	117.62	117.64	117.51	117.51	139869.0
2016-10-31 09:30:00	QQQ	ETF	117.53	117.53	117.18	117.18	2160332.0
2016-10-31 10:00:00	QQQ	ETF	117.18	117.4	117.16	117.35	1264889.0
2016-10-31 10:30:00	QQQ	ETF	117.36	117.37	117.04	117.22	1239853.0
2016-10-31 11:00:00	QQQ	ETF	117.22	117.37	117.11	117.36	900571.0
2016-10-31 11:30:00	QQQ	ETF	117.37	117.45	117.36	117.43	794342.0
2016-10-31 12:00:00	QQQ	ETF	117.434	117.48	117.285	117.37	663558.0
2016-10-31 12:30:00	QQQ	ETF	117.37	117.41	117.22	117.22	446857.0
2016-10-31 13:00:00	QQQ	ETF	117.22	117.25	117.13	117.14	430215.0

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

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