PREVIEW / etf_30min / 2017-06-20

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-20.parquet
  size:    440 KB
  rows:    15,167

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
2017-06-20 04:00:00	SPY	ETF	244.54	244.54	244.45	244.45	510.0
2017-06-20 05:00:00	SPY	ETF	244.44	244.47	244.43	244.45	7500.0
2017-06-20 05:30:00	SPY	ETF	244.43	244.43	244.4	244.4	6600.0
2017-06-20 06:00:00	SPY	ETF	244.4	244.44	244.36	244.38	8697.0
2017-06-20 06:30:00	SPY	ETF	244.45	244.47	244.38	244.41	53100.0
2017-06-20 07:00:00	SPY	ETF	244.42	244.42	244.34	244.35	147722.0
2017-06-20 07:30:00	SPY	ETF	244.38	244.47	244.38	244.4	51822.0
2017-06-20 08:00:00	SPY	ETF	244.42	244.42	244.14	244.18	144306.0
2017-06-20 08:30:00	SPY	ETF	244.19	244.25	244.1	244.15	178431.0
2017-06-20 09:00:00	SPY	ETF	244.16	244.3	244.16	244.24	84375.0
2017-06-20 09:30:00	SPY	ETF	244.25	244.26	243.84	243.84	4556661.0
2017-06-20 10:00:00	SPY	ETF	243.85	244.1	243.75	243.87	3734867.0
2017-06-20 10:30:00	SPY	ETF	243.87	244.14	243.83	244.0699	2403257.0
2017-06-20 11:00:00	SPY	ETF	244.06	244.08	243.73	243.78	3207518.0
2017-06-20 11:30:00	SPY	ETF	243.78	243.91	243.71	243.7351	2161758.0
2017-06-20 12:00:00	SPY	ETF	243.74	243.85	243.35	243.43	2736516.0
2017-06-20 12:30:00	SPY	ETF	243.43	243.8	243.42	243.775	3271130.0
2017-06-20 13:00:00	SPY	ETF	243.775	243.85	243.64	243.68	2549352.0
2017-06-20 13:30:00	SPY	ETF	243.68	243.75	243.63	243.705	1285935.0
2017-06-20 14:00:00	SPY	ETF	243.705	243.8	243.44	243.48	3739259.0
2017-06-20 14:30:00	SPY	ETF	243.485	243.58	243.35	243.51	2148231.0
2017-06-20 15:00:00	SPY	ETF	243.515	243.72	243.38	243.53	2732242.0
2017-06-20 15:30:00	SPY	ETF	243.52	243.52	242.99	243.04	11038326.0
2017-06-20 16:00:00	SPY	ETF	243.04	243.7292	243.01	243.35	7257861.0
2017-06-20 16:30:00	SPY	ETF	243.34	243.37	243.2	243.22	192432.0
2017-06-20 17:00:00	SPY	ETF	243.22	243.5	243.15	243.15	270195.0
2017-06-20 17:30:00	SPY	ETF	243.01	243.2	243.01	243.16	271778.0
2017-06-20 18:00:00	SPY	ETF	243.18	243.26	243.04	243.22	356759.0
2017-06-20 18:30:00	SPY	ETF	243.22	243.23	243.18	243.18	5138.0
2017-06-20 19:00:00	SPY	ETF	243.19	243.24	243.19	243.24	7816.0
2017-06-20 19:30:00	SPY	ETF	243.2	243.24	243.18	243.24	8907.0
2017-06-20 04:00:00	QQQ	ETF	140.57	140.57	140.52	140.53	9286.0
2017-06-20 04:30:00	QQQ	ETF	140.51	140.52	140.44	140.44	3600.0
2017-06-20 05:00:00	QQQ	ETF	140.49	140.49	140.44	140.44	2598.0
2017-06-20 05:30:00	QQQ	ETF	140.43	140.43	140.41	140.41	5400.0
2017-06-20 06:00:00	QQQ	ETF	140.43	140.5	140.39	140.5	7200.0
2017-06-20 06:30:00	QQQ	ETF	140.5	140.51	140.49	140.51	4200.0
2017-06-20 07:00:00	QQQ	ETF	140.52	140.53	140.51	140.53	10450.0
2017-06-20 07:30:00	QQQ	ETF	140.51	140.58	140.5	140.58	26115.0
2017-06-20 08:00:00	QQQ	ETF	140.47	140.55	140.25	140.33	86643.0
2017-06-20 08:30:00	QQQ	ETF	140.33	140.34	140.12	140.15	60395.0
2017-06-20 09:00:00	QQQ	ETF	140.19	140.39	140.19	140.3	177679.0
2017-06-20 09:30:00	QQQ	ETF	140.32	140.4	140.0	140.08	3209823.0
2017-06-20 10:00:00	QQQ	ETF	140.09	140.36	139.87	140.1199	1980133.0
2017-06-20 10:30:00	QQQ	ETF	140.12	140.5	140.115	140.41	1807532.0
2017-06-20 11:00:00	QQQ	ETF	140.42	140.435	139.84	139.8793	1804653.0
2017-06-20 11:30:00	QQQ	ETF	139.88	140.07	139.74	139.91	1488367.0
2017-06-20 12:00:00	QQQ	ETF	139.93	140.08	139.55	139.62	2249579.0
2017-06-20 12:30:00	QQQ	ETF	139.615	139.85	139.596	139.84	1483781.0
2017-06-20 13:00:00	QQQ	ETF	139.83	140.01	139.83	139.87	1036291.0

> showing 50 of 15,167 rows — these rows as CSV

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