PREVIEW / etf_30min / 2016-11-18

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-18.parquet
  size:    420 KB
  rows:    14,363

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-18 04:00:00	SPY	ETF	218.5	218.5	218.2	218.34	41915.0
2016-11-18 04:30:00	SPY	ETF	218.42	218.51	218.35	218.51	9612.0
2016-11-18 05:00:00	SPY	ETF	218.53	218.53	218.45	218.46	5307.0
2016-11-18 05:30:00	SPY	ETF	218.48	218.53	218.45	218.5	6765.0
2016-11-18 06:00:00	SPY	ETF	218.52	218.63	218.52	218.63	6436.0
2016-11-18 06:30:00	SPY	ETF	218.63	218.63	218.52	218.61	21860.0
2016-11-18 07:00:00	SPY	ETF	218.67	218.95	218.67	218.92	64264.0
2016-11-18 07:30:00	SPY	ETF	218.92	219.19	218.92	219.14	82741.0
2016-11-18 08:00:00	SPY	ETF	218.68	219.17	218.67	218.84	147992.0
2016-11-18 08:30:00	SPY	ETF	218.86	219.02	218.86	218.95	119553.0
2016-11-18 09:00:00	SPY	ETF	218.98	219.18	218.86	219.06	1083497.0
2016-11-18 09:30:00	SPY	ETF	219.07	219.27	218.8101	218.85	10744367.0
2016-11-18 10:00:00	SPY	ETF	218.86	219.09	218.735	218.84	5000092.0
2016-11-18 10:30:00	SPY	ETF	218.845	218.88	218.36	218.44	10996747.0
2016-11-18 11:00:00	SPY	ETF	218.44	218.8881	218.29	218.54	10264073.0
2016-11-18 11:30:00	SPY	ETF	218.54	218.55	218.32	218.37	4056058.0
2016-11-18 12:00:00	SPY	ETF	218.36	218.49	218.33	218.455	2867701.0
2016-11-18 12:30:00	SPY	ETF	218.45	218.61	218.39	218.5989	2203637.0
2016-11-18 13:00:00	SPY	ETF	218.5989	218.69	218.53	218.62	3143474.0
2016-11-18 13:30:00	SPY	ETF	218.63	218.75	218.58	218.58	4618039.0
2016-11-18 14:00:00	SPY	ETF	218.58	218.65	218.45	218.4874	3394268.0
2016-11-18 14:30:00	SPY	ETF	218.4897	218.61	218.43	218.49	2709799.0
2016-11-18 15:00:00	SPY	ETF	218.5	218.775	218.44	218.7304	3777281.0
2016-11-18 15:30:00	SPY	ETF	218.73	218.79	218.29	218.52	10935168.0
2016-11-18 16:00:00	SPY	ETF	218.52	218.6205	218.41	218.54	6792819.0
2016-11-18 16:30:00	SPY	ETF	218.54	218.57	218.4608	218.56	1599587.0
2016-11-18 17:00:00	SPY	ETF	218.56	218.62	218.51	218.6	93937.0
2016-11-18 17:30:00	SPY	ETF	218.57	218.71	218.54	218.65	33657.0
2016-11-18 18:00:00	SPY	ETF	218.68	218.68	218.58	218.62	38603.0
2016-11-18 18:30:00	SPY	ETF	218.61	218.62	218.55	218.55	12638.0
2016-11-18 19:00:00	SPY	ETF	218.55	218.59	218.55	218.56	3809.0
2016-11-18 19:30:00	SPY	ETF	218.59	218.59	218.57	218.59	17374.0
2016-11-18 04:00:00	QQQ	ETF	117.67	117.67	117.55	117.59	2475.0
2016-11-18 04:30:00	QQQ	ETF	117.61	117.61	117.61	117.61	100.0
2016-11-18 05:00:00	QQQ	ETF	117.65	117.65	117.65	117.65	100.0
2016-11-18 05:30:00	QQQ	ETF	117.71	117.75	117.71	117.75	1200.0
2016-11-18 07:00:00	QQQ	ETF	117.75	117.89	117.75	117.88	11500.0
2016-11-18 07:30:00	QQQ	ETF	117.98	118.03	117.95	117.99	11899.0
2016-11-18 08:00:00	QQQ	ETF	117.95	117.96	117.75	117.79	16658.0
2016-11-18 08:30:00	QQQ	ETF	117.83	117.87	117.81	117.87	12507.0
2016-11-18 09:00:00	QQQ	ETF	117.88	117.97	117.79	117.82	170206.0
2016-11-18 09:30:00	QQQ	ETF	117.83	118.1	117.6807	117.6807	2266097.0
2016-11-18 10:00:00	QQQ	ETF	117.6849	117.84	117.49	117.67	1031407.0
2016-11-18 10:30:00	QQQ	ETF	117.67	117.69	117.21	117.36	1659231.0
2016-11-18 11:00:00	QQQ	ETF	117.36	117.45	117.27	117.38	722604.0
2016-11-18 11:30:00	QQQ	ETF	117.37	117.45	117.29	117.35	1182117.0
2016-11-18 12:00:00	QQQ	ETF	117.34	117.43	117.33	117.39	759851.0
2016-11-18 12:30:00	QQQ	ETF	117.39	117.56	117.355	117.56	459251.0
2016-11-18 13:00:00	QQQ	ETF	117.56	117.58	117.445	117.45	387264.0
2016-11-18 13:30:00	QQQ	ETF	117.4427	117.55	117.38	117.3999	484148.0

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

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