PREVIEW / etf_30min / 2016-08-31

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-31.parquet
  size:    392 KB
  rows:    13,248

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-31 04:00:00	SPY	ETF	218.0	218.02	217.95	218.02	5156.0
2016-08-31 04:30:00	SPY	ETF	218.02	218.02	217.96	218.0	2006.0
2016-08-31 05:00:00	SPY	ETF	217.95	217.95	217.88	217.92	3803.0
2016-08-31 05:30:00	SPY	ETF	218.02	218.05	218.0	218.02	1504.0
2016-08-31 06:00:00	SPY	ETF	217.93	217.94	217.86	217.9	2192.0
2016-08-31 06:30:00	SPY	ETF	217.86	217.95	217.86	217.95	2092.0
2016-08-31 07:00:00	SPY	ETF	217.94	218.02	217.92	217.95	17719.0
2016-08-31 07:30:00	SPY	ETF	217.94	217.98	217.93	217.95	12662.0
2016-08-31 08:00:00	SPY	ETF	217.95	218.043	217.81	217.81	110642.0
2016-08-31 08:30:00	SPY	ETF	217.83	217.86	217.63	217.7	144563.0
2016-08-31 09:00:00	SPY	ETF	217.7	217.75	217.62	217.63	186091.0
2016-08-31 09:30:00	SPY	ETF	217.61	217.75	217.44	217.61	5578743.0
2016-08-31 10:00:00	SPY	ETF	217.615	217.73	217.41	217.52	3539359.0
2016-08-31 10:30:00	SPY	ETF	217.52	217.52	217.07	217.08	4560702.0
2016-08-31 11:00:00	SPY	ETF	217.08	217.23	216.975	217.225	3938935.0
2016-08-31 11:30:00	SPY	ETF	217.22	217.24	216.981	217.04	2479054.0
2016-08-31 12:00:00	SPY	ETF	217.045	217.045	216.5	216.635	6396115.0
2016-08-31 12:30:00	SPY	ETF	216.64	217.7	216.465	216.71	3997880.0
2016-08-31 13:00:00	SPY	ETF	216.715	216.85	216.53	216.82	3011940.0
2016-08-31 13:30:00	SPY	ETF	216.82	216.98	216.71	216.89	2843201.0
2016-08-31 14:00:00	SPY	ETF	216.9	217.27	216.87	217.17	5330809.0
2016-08-31 14:30:00	SPY	ETF	217.18	217.18	216.87	216.96	5338065.0
2016-08-31 15:00:00	SPY	ETF	216.96	217.48	216.94	217.4	6292602.0
2016-08-31 15:30:00	SPY	ETF	217.405	217.61	217.32	217.39	14981716.0
2016-08-31 16:00:00	SPY	ETF	217.38	217.63	217.33	217.54	12256868.0
2016-08-31 16:30:00	SPY	ETF	217.54	217.59	217.39	217.4	612807.0
2016-08-31 17:00:00	SPY	ETF	217.4	217.45	217.35	217.38	153939.0
2016-08-31 17:30:00	SPY	ETF	217.38	217.4	217.37	217.4	298464.0
2016-08-31 18:00:00	SPY	ETF	217.41	217.43	217.38	217.43	26347.0
2016-08-31 18:30:00	SPY	ETF	217.43	217.44	217.43	217.44	2991.0
2016-08-31 19:00:00	SPY	ETF	217.43	217.47	217.39	217.39	22891.0
2016-08-31 19:30:00	SPY	ETF	217.4	217.46	217.4	217.46	5961.0
2016-08-31 04:00:00	QQQ	ETF	116.49	116.49	116.48	116.48	1000.0
2016-08-31 05:00:00	QQQ	ETF	116.49	116.49	116.49	116.49	1900.0
2016-08-31 05:30:00	QQQ	ETF	116.53	116.53	116.53	116.53	100.0
2016-08-31 06:00:00	QQQ	ETF	116.48	116.48	116.48	116.48	500.0
2016-08-31 06:30:00	QQQ	ETF	116.44	116.44	116.44	116.44	700.0
2016-08-31 07:00:00	QQQ	ETF	116.5	116.57	116.5	116.55	36152.0
2016-08-31 07:30:00	QQQ	ETF	116.56	116.56	116.54	116.54	4569.0
2016-08-31 08:00:00	QQQ	ETF	116.54	116.54	116.48	116.48	5300.0
2016-08-31 08:30:00	QQQ	ETF	116.44	116.44	116.36	116.38	37916.0
2016-08-31 09:00:00	QQQ	ETF	116.39	116.44	116.35	116.39	124926.0
2016-08-31 09:30:00	QQQ	ETF	116.38	116.54	116.26	116.49	1627383.0
2016-08-31 10:00:00	QQQ	ETF	116.49	116.56	116.34	116.44	636798.0
2016-08-31 10:30:00	QQQ	ETF	116.43	116.44	116.21	116.32	575811.0
2016-08-31 11:00:00	QQQ	ETF	116.31	116.4299	116.24	116.42	690107.0
2016-08-31 11:30:00	QQQ	ETF	116.42	116.44	116.305	116.35	879353.0
2016-08-31 12:00:00	QQQ	ETF	116.35	116.35	115.95	116.0664	1627206.0
2016-08-31 12:30:00	QQQ	ETF	116.06	116.24	115.99	116.151	1071996.0
2016-08-31 13:00:00	QQQ	ETF	116.16	116.241	116.09	116.22	394700.0

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

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