PREVIEW / etf_30min / 2016-11-04

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-04.parquet
  size:    412 KB
  rows:    13,918

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-04 04:00:00	SPY	ETF	209.0	209.1	208.75	208.75	2523.0
2016-11-04 04:30:00	SPY	ETF	208.87	208.97	208.82	208.97	2501.0
2016-11-04 05:00:00	SPY	ETF	208.72	208.75	208.55	208.55	3528.0
2016-11-04 05:30:00	SPY	ETF	208.75	209.0	208.74	208.74	7252.0
2016-11-04 06:00:00	SPY	ETF	208.78	208.78	208.66	208.7	10160.0
2016-11-04 06:30:00	SPY	ETF	208.65	208.89	208.63	208.78	13528.0
2016-11-04 07:00:00	SPY	ETF	208.75	208.85	208.67	208.72	30272.0
2016-11-04 07:30:00	SPY	ETF	208.74	208.85	208.69	208.8	100398.0
2016-11-04 08:00:00	SPY	ETF	208.82	209.03	208.68	208.91	428292.0
2016-11-04 08:30:00	SPY	ETF	208.94	209.32	208.5	209.14	907566.0
2016-11-04 09:00:00	SPY	ETF	209.15	209.16	208.86	208.93	822233.0
2016-11-04 09:30:00	SPY	ETF	208.91	209.25	208.38	208.51	10777507.0
2016-11-04 10:00:00	SPY	ETF	208.58	209.19	208.4792	209.0975	8121546.0
2016-11-04 10:30:00	SPY	ETF	209.08	209.4399	208.98	209.27	7403184.0
2016-11-04 11:00:00	SPY	ETF	209.27	209.7	209.22	209.61	8284416.0
2016-11-04 11:30:00	SPY	ETF	209.61	209.635	209.23	209.41	7287935.0
2016-11-04 12:00:00	SPY	ETF	209.415	209.89	209.4	209.79	5338584.0
2016-11-04 12:30:00	SPY	ETF	209.79	209.83	209.62	209.775	4069523.0
2016-11-04 13:00:00	SPY	ETF	209.78	209.88	209.61	209.63	4722756.0
2016-11-04 13:30:00	SPY	ETF	209.63	209.85	209.59	209.71	2417874.0
2016-11-04 14:00:00	SPY	ETF	209.715	209.75	209.54	209.64	2103127.0
2016-11-04 14:30:00	SPY	ETF	209.64	209.65	209.14	209.21	5869689.0
2016-11-04 15:00:00	SPY	ETF	209.21	209.21	208.8	208.96	6959052.0
2016-11-04 15:30:00	SPY	ETF	208.965	208.985	208.405	208.52	20851103.0
2016-11-04 16:00:00	SPY	ETF	208.52	209.5959	208.4	208.44	7904982.0
2016-11-04 16:30:00	SPY	ETF	208.45	208.67	208.38	208.66	540386.0
2016-11-04 17:00:00	SPY	ETF	208.64	208.67	208.55	208.63	121194.0
2016-11-04 17:30:00	SPY	ETF	208.55	208.65	208.11	208.15	1509127.0
2016-11-04 18:00:00	SPY	ETF	208.14	208.36	208.12	208.35	40814.0
2016-11-04 18:30:00	SPY	ETF	208.34	208.39	208.31	208.32	13252.0
2016-11-04 19:00:00	SPY	ETF	208.32	208.43	208.3	208.38	31918.0
2016-11-04 19:30:00	SPY	ETF	208.35	208.44	208.33	208.44	36747.0
2016-11-04 04:00:00	QQQ	ETF	113.95	113.95	113.95	113.95	400.0
2016-11-04 04:30:00	QQQ	ETF	113.95	113.95	113.95	113.95	280.0
2016-11-04 05:30:00	QQQ	ETF	114.04	114.04	114.04	114.04	1000.0
2016-11-04 06:30:00	QQQ	ETF	113.88	113.88	113.88	113.88	174.0
2016-11-04 07:00:00	QQQ	ETF	113.9	113.95	113.9	113.94	11768.0
2016-11-04 07:30:00	QQQ	ETF	113.96	114.03	113.96	114.03	22767.0
2016-11-04 08:00:00	QQQ	ETF	114.04	114.1	113.94	114.0	26748.0
2016-11-04 08:30:00	QQQ	ETF	114.03	114.19	113.87	114.14	103054.0
2016-11-04 09:00:00	QQQ	ETF	114.06	114.08	113.63	113.71	299513.0
2016-11-04 09:30:00	QQQ	ETF	113.72	114.26	113.45	113.69	6193462.0
2016-11-04 10:00:00	QQQ	ETF	113.7	114.2399	113.6608	114.1992	2309082.0
2016-11-04 10:30:00	QQQ	ETF	114.19	114.34	114.109	114.22	2102504.0
2016-11-04 11:00:00	QQQ	ETF	114.23	114.45	114.185	114.42	1141744.0
2016-11-04 11:30:00	QQQ	ETF	114.42	114.425	114.12	114.26	1205200.0
2016-11-04 12:00:00	QQQ	ETF	114.25	114.47	114.25	114.39	864304.0
2016-11-04 12:30:00	QQQ	ETF	114.3925	114.51	114.3	114.5	771116.0
2016-11-04 13:00:00	QQQ	ETF	114.51	114.54	114.33	114.35	745392.0
2016-11-04 13:30:00	QQQ	ETF	114.35	114.5	114.33	114.38	645950.0

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

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