PREVIEW / etf_30min / 2017-11-29

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-29.parquet
  size:    460 KB
  rows:    15,765

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
2017-11-29 04:00:00	SPY	ETF	262.75	262.79	262.75	262.79	400.0
2017-11-29 04:30:00	SPY	ETF	262.88	262.9	262.86	262.86	4119.0
2017-11-29 05:00:00	SPY	ETF	262.88	262.88	262.79	262.84	3052.0
2017-11-29 05:30:00	SPY	ETF	262.88	262.98	262.87	262.98	8610.0
2017-11-29 06:00:00	SPY	ETF	262.94	263.12	262.94	263.12	11799.0
2017-11-29 06:30:00	SPY	ETF	263.13	263.15	263.12	263.12	7595.0
2017-11-29 07:00:00	SPY	ETF	263.12	263.16	263.11	263.15	89847.0
2017-11-29 07:30:00	SPY	ETF	263.15	263.15	263.04	263.05	69687.0
2017-11-29 08:00:00	SPY	ETF	263.09	263.13	263.0	263.04	93737.0
2017-11-29 08:30:00	SPY	ETF	263.02	263.05	262.87	263.04	312675.0
2017-11-29 09:00:00	SPY	ETF	263.04	263.09	262.99	263.04	242233.0
2017-11-29 09:30:00	SPY	ETF	263.02	263.63	262.96	263.51	7773122.0
2017-11-29 10:00:00	SPY	ETF	263.5101	263.52	262.72	262.8947	7199062.0
2017-11-29 10:30:00	SPY	ETF	262.89	263.28	262.72	262.85	4679998.0
2017-11-29 11:00:00	SPY	ETF	262.85	262.96	262.48	262.698	4653442.0
2017-11-29 11:30:00	SPY	ETF	262.69	262.8	262.28	262.31	5852786.0
2017-11-29 12:00:00	SPY	ETF	262.31	262.68	262.2	262.55	6487017.0
2017-11-29 12:30:00	SPY	ETF	262.55	262.84	262.43	262.715	6515923.0
2017-11-29 13:00:00	SPY	ETF	262.715	262.8166	262.49	262.77	2176340.0
2017-11-29 13:30:00	SPY	ETF	262.765	262.8	262.4	262.4751	4437719.0
2017-11-29 14:00:00	SPY	ETF	262.47	262.78	262.47	262.69	4277095.0
2017-11-29 14:30:00	SPY	ETF	262.69	262.75	262.48	262.58	2894289.0
2017-11-29 15:00:00	SPY	ETF	262.585	262.64	262.365	262.6075	3819463.0
2017-11-29 15:30:00	SPY	ETF	262.605	262.88	262.53	262.73	8083949.0
2017-11-29 16:00:00	SPY	ETF	262.73	262.7981	262.63	262.75	5120010.0
2017-11-29 16:30:00	SPY	ETF	262.73	262.75	262.54	262.73	343675.0
2017-11-29 17:00:00	SPY	ETF	262.72	262.8	262.69	262.73	196379.0
2017-11-29 17:30:00	SPY	ETF	262.72	262.78	262.72	262.74	498033.0
2017-11-29 18:00:00	SPY	ETF	262.74	262.84	262.71	262.72	97752.0
2017-11-29 18:30:00	SPY	ETF	262.74	262.74	262.63	262.64	14931.0
2017-11-29 19:00:00	SPY	ETF	262.64	262.67	262.51	262.6	121354.0
2017-11-29 19:30:00	SPY	ETF	262.62	262.62	262.51	262.57	54621.0
2017-11-29 04:00:00	QQQ	ETF	156.45	156.45	156.28	156.39	69900.0
2017-11-29 04:30:00	QQQ	ETF	156.45	156.45	156.45	156.45	500.0
2017-11-29 05:00:00	QQQ	ETF	156.39	156.45	156.39	156.45	5500.0
2017-11-29 05:30:00	QQQ	ETF	156.48	156.5	156.46	156.5	1900.0
2017-11-29 06:00:00	QQQ	ETF	156.56	156.6	156.56	156.6	1200.0
2017-11-29 06:30:00	QQQ	ETF	156.65	156.65	156.6	156.6	10700.0
2017-11-29 07:00:00	QQQ	ETF	156.61	156.64	156.58	156.59	44077.0
2017-11-29 07:30:00	QQQ	ETF	156.58	156.62	156.53	156.55	25059.0
2017-11-29 08:00:00	QQQ	ETF	156.61	156.61	156.5	156.52	36454.0
2017-11-29 08:30:00	QQQ	ETF	156.48	156.48	156.31	156.46	118944.0
2017-11-29 09:00:00	QQQ	ETF	156.46	156.5	156.38	156.41	149676.0
2017-11-29 09:30:00	QQQ	ETF	156.42	156.45	155.51	155.53	6156561.0
2017-11-29 10:00:00	QQQ	ETF	155.53	155.66	154.04	154.43	11044067.0
2017-11-29 10:30:00	QQQ	ETF	154.43	154.82	153.95	154.06	6015112.0
2017-11-29 11:00:00	QQQ	ETF	154.05	154.3448	153.72	153.95	4853170.0
2017-11-29 11:30:00	QQQ	ETF	153.94	154.0853	153.31	153.34	4831818.0
2017-11-29 12:00:00	QQQ	ETF	153.34	153.9	153.12	153.8	5539519.0
2017-11-29 12:30:00	QQQ	ETF	153.795	154.206	153.7201	153.92	3781053.0

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

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