PREVIEW / etf_30min / 2016-07-29

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-29.parquet
  size:    400 KB
  rows:    13,446

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-07-29 04:00:00	SPY	ETF	216.42	216.72	216.37	216.51	12322.0
2016-07-29 04:30:00	SPY	ETF	216.53	216.58	216.48	216.55	4945.0
2016-07-29 05:00:00	SPY	ETF	216.53	216.53	216.41	216.5	4351.0
2016-07-29 05:30:00	SPY	ETF	216.43	216.63	216.43	216.6	2426.0
2016-07-29 06:00:00	SPY	ETF	216.6	216.68	216.59	216.67	6905.0
2016-07-29 06:30:00	SPY	ETF	216.64	216.7	216.46	216.53	58056.0
2016-07-29 07:00:00	SPY	ETF	216.57	216.57	216.47	216.56	40822.0
2016-07-29 07:30:00	SPY	ETF	216.57	216.6	216.46	216.57	85163.0
2016-07-29 08:00:00	SPY	ETF	216.58	216.92	216.45	216.55	139993.0
2016-07-29 08:30:00	SPY	ETF	216.5	216.53	216.2	216.5	861934.0
2016-07-29 09:00:00	SPY	ETF	216.5	216.62	216.44	216.45	421487.0
2016-07-29 09:30:00	SPY	ETF	216.46	216.86	216.36	216.48	7573130.0
2016-07-29 10:00:00	SPY	ETF	216.49	216.56	216.13	216.4	6020269.0
2016-07-29 10:30:00	SPY	ETF	216.4	217.09	216.37	216.95	6313408.0
2016-07-29 11:00:00	SPY	ETF	216.9489	217.32	216.945	217.15	4779661.0
2016-07-29 11:30:00	SPY	ETF	217.15	217.44	217.13	217.345	4290228.0
2016-07-29 12:00:00	SPY	ETF	217.35	217.54	217.21	217.2282	2854091.0
2016-07-29 12:30:00	SPY	ETF	217.23	217.34	217.03	217.11	3580134.0
2016-07-29 13:00:00	SPY	ETF	217.12	217.245	217.0293	217.245	2164168.0
2016-07-29 13:30:00	SPY	ETF	217.2442	217.34	217.13	217.3	2164091.0
2016-07-29 14:00:00	SPY	ETF	217.3	217.41	217.24	217.3965	3326493.0
2016-07-29 14:30:00	SPY	ETF	217.39	217.395	217.02	217.19	3545988.0
2016-07-29 15:00:00	SPY	ETF	217.19	217.23	216.94	217.02	5687813.0
2016-07-29 15:30:00	SPY	ETF	217.025	217.48	216.975	217.14	13896940.0
2016-07-29 16:00:00	SPY	ETF	217.12	217.47	217.11	217.45	8543551.0
2016-07-29 16:30:00	SPY	ETF	217.45	217.5	217.38	217.48	535101.0
2016-07-29 17:00:00	SPY	ETF	217.48	217.49	217.12	217.43	111925.0
2016-07-29 17:30:00	SPY	ETF	217.45	217.5	217.12	217.42	145880.0
2016-07-29 18:00:00	SPY	ETF	217.42	217.5	217.42	217.49	41572.0
2016-07-29 18:30:00	SPY	ETF	217.5	217.5	217.43	217.45	3702.0
2016-07-29 19:00:00	SPY	ETF	217.44	217.55	217.43	217.43	6090.0
2016-07-29 19:30:00	SPY	ETF	217.46	217.46	217.41	217.43	13834.0
2016-07-29 04:00:00	QQQ	ETF	115.04	115.15	115.03	115.04	12597.0
2016-07-29 05:00:00	QQQ	ETF	115.06	115.06	115.06	115.06	100.0
2016-07-29 06:30:00	QQQ	ETF	115.1	115.1	115.1	115.1	200.0
2016-07-29 07:00:00	QQQ	ETF	115.12	115.17	115.09	115.17	37430.0
2016-07-29 07:30:00	QQQ	ETF	115.17	115.19	115.15	115.15	3449.0
2016-07-29 08:00:00	QQQ	ETF	115.12	115.26	115.12	115.22	51149.0
2016-07-29 08:30:00	QQQ	ETF	115.17	115.23	115.12	115.23	131283.0
2016-07-29 09:00:00	QQQ	ETF	115.23	115.29	115.21	115.25	134417.0
2016-07-29 09:30:00	QQQ	ETF	115.24	115.4	115.08	115.1	2553747.0
2016-07-29 10:00:00	QQQ	ETF	115.1	115.15	114.87	115.145	1492932.0
2016-07-29 10:30:00	QQQ	ETF	115.15	115.36	115.1	115.3	1372865.0
2016-07-29 11:00:00	QQQ	ETF	115.31	115.46	115.3	115.37	1173843.0
2016-07-29 11:30:00	QQQ	ETF	115.365	115.52	115.365	115.45	1004837.0
2016-07-29 12:00:00	QQQ	ETF	115.44	115.54	115.34	115.35	795310.0
2016-07-29 12:30:00	QQQ	ETF	115.36	115.42	115.22	115.25	687794.0
2016-07-29 13:00:00	QQQ	ETF	115.26	115.34	115.225	115.3367	655816.0
2016-07-29 13:30:00	QQQ	ETF	115.34	115.38	115.255	115.331	605267.0
2016-07-29 14:00:00	QQQ	ETF	115.331	115.35	115.275	115.3	599447.0

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

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