PREVIEW / etf_30min / 2016-08-26

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-26.parquet
  size:    400 KB
  rows:    13,331

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-26 04:00:00	SPY	ETF	217.87	217.91	217.87	217.91	400.0
2016-08-26 04:30:00	SPY	ETF	217.83	217.83	217.8	217.8	702.0
2016-08-26 05:00:00	SPY	ETF	217.86	217.86	217.8	217.8	1304.0
2016-08-26 05:30:00	SPY	ETF	217.9	217.96	217.9	217.92	1153.0
2016-08-26 06:00:00	SPY	ETF	217.93	217.95	217.78	217.78	3317.0
2016-08-26 06:30:00	SPY	ETF	217.82	217.83	217.76	217.76	2505.0
2016-08-26 07:00:00	SPY	ETF	217.75	217.8	217.72	217.76	7084.0
2016-08-26 07:30:00	SPY	ETF	217.81	217.82	217.72	217.76	84404.0
2016-08-26 08:00:00	SPY	ETF	217.73	217.95	217.65	217.65	85135.0
2016-08-26 08:30:00	SPY	ETF	217.66	217.94	217.65	217.85	181608.0
2016-08-26 09:00:00	SPY	ETF	217.84	217.98	217.8	217.92	313834.0
2016-08-26 09:30:00	SPY	ETF	217.92	218.54	217.8799	218.118	7307658.0
2016-08-26 10:00:00	SPY	ETF	218.11	219.12	217.5	218.95	16662159.0
2016-08-26 10:30:00	SPY	ETF	218.96	218.99	218.5	218.665	8520352.0
2016-08-26 11:00:00	SPY	ETF	218.66	218.8	218.47	218.76	6303117.0
2016-08-26 11:30:00	SPY	ETF	218.75	218.77	217.38	217.58	10488529.0
2016-08-26 12:00:00	SPY	ETF	217.57	217.57	216.57	216.95	12988023.0
2016-08-26 12:30:00	SPY	ETF	216.95	217.24	216.78	217.18	7082195.0
2016-08-26 13:00:00	SPY	ETF	217.17	217.35	216.82	217.03	4619823.0
2016-08-26 13:30:00	SPY	ETF	217.03	217.07	216.6051	216.75	4005517.0
2016-08-26 14:00:00	SPY	ETF	216.75	217.0	216.28	216.4	7812362.0
2016-08-26 14:30:00	SPY	ETF	216.4	216.68	216.25	216.65	5687069.0
2016-08-26 15:00:00	SPY	ETF	216.65	217.2601	216.55	217.17	7551714.0
2016-08-26 15:30:00	SPY	ETF	217.17	217.52	217.11	217.25	15219609.0
2016-08-26 16:00:00	SPY	ETF	217.26	217.38	217.1665	217.34	4999534.0
2016-08-26 16:30:00	SPY	ETF	217.35	217.39	217.18	217.25	789786.0
2016-08-26 17:00:00	SPY	ETF	217.19	218.1	217.15	217.25	254174.0
2016-08-26 17:30:00	SPY	ETF	217.27	217.31	217.23	217.23	38031.0
2016-08-26 18:00:00	SPY	ETF	217.23	217.23	217.05	217.16	74335.0
2016-08-26 18:30:00	SPY	ETF	217.16	217.23	217.15	217.16	7209.0
2016-08-26 19:00:00	SPY	ETF	217.19	217.23	217.16	217.22	2800.0
2016-08-26 19:30:00	SPY	ETF	217.2	217.23	217.16	217.16	10198.0
2016-08-26 04:00:00	QQQ	ETF	116.67	116.67	116.67	116.67	100.0
2016-08-26 04:30:00	QQQ	ETF	116.62	116.62	116.62	116.62	149.0
2016-08-26 05:00:00	QQQ	ETF	116.61	116.61	116.61	116.61	340.0
2016-08-26 07:00:00	QQQ	ETF	116.61	116.61	116.6	116.61	9100.0
2016-08-26 07:30:00	QQQ	ETF	116.6	116.65	116.6	116.61	80981.0
2016-08-26 08:00:00	QQQ	ETF	116.59	116.62	116.55	116.55	21516.0
2016-08-26 08:30:00	QQQ	ETF	116.55	116.65	116.53	116.59	28387.0
2016-08-26 09:00:00	QQQ	ETF	116.59	116.66	116.53	116.66	45975.0
2016-08-26 09:30:00	QQQ	ETF	116.66	117.15	116.64	116.859	2023391.0
2016-08-26 10:00:00	QQQ	ETF	116.85	117.54	116.4801	117.47	3733242.0
2016-08-26 10:30:00	QQQ	ETF	117.48	117.49	117.19	117.2864	1408088.0
2016-08-26 11:00:00	QQQ	ETF	117.29	117.4	117.13	117.38	968371.0
2016-08-26 11:30:00	QQQ	ETF	117.38	117.4	116.62	116.7193	1945922.0
2016-08-26 12:00:00	QQQ	ETF	116.71	116.71	116.08	116.32	3069849.0
2016-08-26 12:30:00	QQQ	ETF	116.31	116.53	116.2	116.51	964605.0
2016-08-26 13:00:00	QQQ	ETF	116.513	116.62	116.35	116.45	801518.0
2016-08-26 13:30:00	QQQ	ETF	116.455	116.5	116.23	116.3	545262.0
2016-08-26 14:00:00	QQQ	ETF	116.3	116.48	116.1	116.18	1326377.0

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

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