PREVIEW / etf_30min / 2016-12-23

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-23.parquet
  size:    399 KB
  rows:    13,917

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-12-23 04:00:00	SPY	ETF	225.58	225.7	225.58	225.68	3902.0
2016-12-23 04:30:00	SPY	ETF	225.73	225.73	225.68	225.71	1311.0
2016-12-23 05:00:00	SPY	ETF	225.67	225.73	225.67	225.73	1204.0
2016-12-23 05:30:00	SPY	ETF	225.69	225.69	225.69	225.69	300.0
2016-12-23 06:00:00	SPY	ETF	225.69	225.69	225.69	225.69	400.0
2016-12-23 06:30:00	SPY	ETF	225.62	225.62	225.59	225.59	2702.0
2016-12-23 07:00:00	SPY	ETF	225.61	225.63	225.44	225.44	17211.0
2016-12-23 07:30:00	SPY	ETF	225.44	225.47	225.34	225.47	41569.0
2016-12-23 08:00:00	SPY	ETF	225.61	225.63	225.36	225.46	46247.0
2016-12-23 08:30:00	SPY	ETF	225.44	225.48	225.4	225.43	41632.0
2016-12-23 09:00:00	SPY	ETF	225.43	225.46	225.31	225.43	173429.0
2016-12-23 09:30:00	SPY	ETF	225.43	225.59	225.36	225.525	3756541.0
2016-12-23 10:00:00	SPY	ETF	225.529	225.62	225.43	225.4445	2739469.0
2016-12-23 10:30:00	SPY	ETF	225.445	225.535	225.33	225.4197	2671739.0
2016-12-23 11:00:00	SPY	ETF	225.415	225.45	225.21	225.39	1447460.0
2016-12-23 11:30:00	SPY	ETF	225.39	225.44	225.33	225.4	779219.0
2016-12-23 12:00:00	SPY	ETF	225.4	225.46	225.36	225.4325	906318.0
2016-12-23 12:30:00	SPY	ETF	225.43	225.48	225.35	225.355	761672.0
2016-12-23 13:00:00	SPY	ETF	225.36	225.42	225.32	225.4159	1415093.0
2016-12-23 13:30:00	SPY	ETF	225.42	225.47	225.405	225.44	2045459.0
2016-12-23 14:00:00	SPY	ETF	225.43	225.5	225.4	225.435	1877946.0
2016-12-23 14:30:00	SPY	ETF	225.44	225.5	225.43	225.5	1441301.0
2016-12-23 15:00:00	SPY	ETF	225.5	225.55	225.45	225.46	3335256.0
2016-12-23 15:30:00	SPY	ETF	225.465	225.72	225.46	225.69	6041990.0
2016-12-23 16:00:00	SPY	ETF	225.69	225.83	225.4788	225.73	6162963.0
2016-12-23 16:30:00	SPY	ETF	225.72	225.74	225.65	225.67	171076.0
2016-12-23 17:00:00	SPY	ETF	225.66	225.7	225.65	225.65	12197.0
2016-12-23 17:30:00	SPY	ETF	225.68	225.68	225.59	225.59	16818.0
2016-12-23 18:00:00	SPY	ETF	225.64	225.64	225.58	225.62	7482.0
2016-12-23 18:30:00	SPY	ETF	225.62	225.63	225.61	225.63	2929.0
2016-12-23 19:00:00	SPY	ETF	225.63	225.64	225.63	225.64	2485.0
2016-12-23 19:30:00	SPY	ETF	225.64	225.66	225.64	225.66	2121.0
2016-12-23 06:00:00	QQQ	ETF	120.08	120.08	120.06	120.06	400.0
2016-12-23 06:30:00	QQQ	ETF	120.02	120.02	120.02	120.02	619.0
2016-12-23 07:00:00	QQQ	ETF	120.04	120.05	120.03	120.03	700.0
2016-12-23 07:30:00	QQQ	ETF	119.93	120.0	119.9	120.0	71902.0
2016-12-23 08:00:00	QQQ	ETF	120.02	120.02	120.0	120.0	4600.0
2016-12-23 08:30:00	QQQ	ETF	119.99	120.05	119.98	119.98	8516.0
2016-12-23 09:00:00	QQQ	ETF	119.98	120.02	119.86	119.97	50490.0
2016-12-23 09:30:00	QQQ	ETF	119.96	120.24	119.92	120.13	1556334.0
2016-12-23 10:00:00	QQQ	ETF	120.13	120.23	120.01	120.0103	1067730.0
2016-12-23 10:30:00	QQQ	ETF	120.01	120.0757	119.9018	119.94	603777.0
2016-12-23 11:00:00	QQQ	ETF	119.945	119.995	119.81	119.9	445436.0
2016-12-23 11:30:00	QQQ	ETF	119.8919	119.97	119.85	119.9544	266215.0
2016-12-23 12:00:00	QQQ	ETF	119.955	120.0969	119.955	120.07	209546.0
2016-12-23 12:30:00	QQQ	ETF	120.07	120.1	119.99	120.0	211709.0
2016-12-23 13:00:00	QQQ	ETF	120.0	120.1	120.0	120.0699	274452.0
2016-12-23 13:30:00	QQQ	ETF	120.07	120.09	120.01	120.04	181444.0
2016-12-23 14:00:00	QQQ	ETF	120.029	120.11	120.01	120.0658	203512.0
2016-12-23 14:30:00	QQQ	ETF	120.06	120.08	120.03	120.0701	212929.0

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

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