PREVIEW / etf_30min / 2016-11-28

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-28.parquet
  size:    427 KB
  rows:    14,623

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-11-28 04:00:00	SPY	ETF	220.76	220.95	220.72	220.74	29528.0
2016-11-28 04:30:00	SPY	ETF	220.82	220.84	220.81	220.82	1317.0
2016-11-28 05:00:00	SPY	ETF	221.12	221.17	221.07	221.12	4117.0
2016-11-28 05:30:00	SPY	ETF	221.12	221.12	220.97	220.97	17030.0
2016-11-28 06:00:00	SPY	ETF	221.03	221.06	220.89	220.9	27912.0
2016-11-28 06:30:00	SPY	ETF	220.87	220.99	220.84	220.99	56540.0
2016-11-28 07:00:00	SPY	ETF	220.97	221.06	220.92	221.04	135299.0
2016-11-28 07:30:00	SPY	ETF	221.04	221.26	220.96	221.2	115376.0
2016-11-28 08:00:00	SPY	ETF	221.19	221.24	220.61	221.07	296975.0
2016-11-28 08:30:00	SPY	ETF	221.07	221.19	221.07	221.1	98753.0
2016-11-28 09:00:00	SPY	ETF	221.11	221.2	221.06	221.17	522533.0
2016-11-28 09:30:00	SPY	ETF	221.16	221.34	221.01	221.2	6255132.0
2016-11-28 10:00:00	SPY	ETF	221.2	221.29	221.02	221.17	3472890.0
2016-11-28 10:30:00	SPY	ETF	221.18	221.48	220.71	220.715	4886667.0
2016-11-28 11:00:00	SPY	ETF	220.71	220.95	220.66	220.8666	4335186.0
2016-11-28 11:30:00	SPY	ETF	220.86	221.0	220.74	220.96	3420586.0
2016-11-28 12:00:00	SPY	ETF	220.955	221.15	220.95	221.12	4093203.0
2016-11-28 12:30:00	SPY	ETF	221.12	221.38	221.1	221.2	2381251.0
2016-11-28 13:00:00	SPY	ETF	221.2065	221.2065	221.03	221.0799	1896604.0
2016-11-28 13:30:00	SPY	ETF	221.08	221.16	221.04	221.0854	1457492.0
2016-11-28 14:00:00	SPY	ETF	221.085	221.22	220.98	220.99	2794636.0
2016-11-28 14:30:00	SPY	ETF	220.985	221.06	220.87	220.94	4122922.0
2016-11-28 15:00:00	SPY	ETF	220.94	220.96	220.57	220.58	5039625.0
2016-11-28 15:30:00	SPY	ETF	220.58	220.69	220.36	220.54	18081302.0
2016-11-28 16:00:00	SPY	ETF	220.52	220.71	220.48	220.62	10210910.0
2016-11-28 16:30:00	SPY	ETF	220.62	220.67	220.5	220.53	826135.0
2016-11-28 17:00:00	SPY	ETF	220.52	220.56	220.48	220.53	167603.0
2016-11-28 17:30:00	SPY	ETF	220.53	220.53	220.48	220.52	7396.0
2016-11-28 18:00:00	SPY	ETF	220.52	220.52	220.41	220.46	26320.0
2016-11-28 18:30:00	SPY	ETF	220.52	220.52	220.46	220.46	2828.0
2016-11-28 19:00:00	SPY	ETF	220.5	220.5	220.5	220.5	2946.0
2016-11-28 19:30:00	SPY	ETF	220.49	220.5	220.45	220.5	9724.0
2016-11-28 04:00:00	QQQ	ETF	118.39	118.43	118.39	118.43	1381.0
2016-11-28 04:30:00	QQQ	ETF	118.43	118.43	118.43	118.43	200.0
2016-11-28 05:00:00	QQQ	ETF	118.61	118.64	118.61	118.64	3161.0
2016-11-28 05:30:00	QQQ	ETF	118.68	118.68	118.68	118.68	500.0
2016-11-28 06:00:00	QQQ	ETF	118.57	118.57	118.57	118.57	325.0
2016-11-28 06:30:00	QQQ	ETF	118.51	118.52	118.5	118.5	860.0
2016-11-28 07:00:00	QQQ	ETF	118.55	118.55	118.51	118.55	7349.0
2016-11-28 07:30:00	QQQ	ETF	118.66	118.67	118.66	118.66	900.0
2016-11-28 08:00:00	QQQ	ETF	118.65	118.65	118.57	118.61	21988.0
2016-11-28 08:30:00	QQQ	ETF	118.61	118.66	118.61	118.66	9944.0
2016-11-28 09:00:00	QQQ	ETF	118.65	118.68	118.6	118.63	29215.0
2016-11-28 09:30:00	QQQ	ETF	118.64	118.86	118.4101	118.84	1894812.0
2016-11-28 10:00:00	QQQ	ETF	118.83	118.91	118.67	118.895	891956.0
2016-11-28 10:30:00	QQQ	ETF	118.89	119.08	118.69	118.69	953992.0
2016-11-28 11:00:00	QQQ	ETF	118.6818	118.79	118.62	118.7157	548022.0
2016-11-28 11:30:00	QQQ	ETF	118.72	118.91	118.72	118.87	586953.0
2016-11-28 12:00:00	QQQ	ETF	118.87	118.95	118.8059	118.88	423300.0
2016-11-28 12:30:00	QQQ	ETF	118.8865	119.04	118.87	118.95	693722.0

> showing 50 of 14,623 rows — these rows as CSV

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