PREVIEW / etf_30min / 2017-06-19

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-19.parquet
  size:    431 KB
  rows:    14,883

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-19 04:00:00	SPY	ETF	243.2	243.42	243.2	243.37	6020.0
2017-06-19 04:30:00	SPY	ETF	243.3	243.35	243.3	243.35	1600.0
2017-06-19 05:00:00	SPY	ETF	243.35	243.35	243.35	243.35	100.0
2017-06-19 05:30:00	SPY	ETF	243.44	243.46	243.31	243.33	4902.0
2017-06-19 06:00:00	SPY	ETF	243.33	243.33	243.3	243.3	1150.0
2017-06-19 06:30:00	SPY	ETF	243.31	243.35	243.31	243.35	2810.0
2017-06-19 07:00:00	SPY	ETF	243.4	243.46	243.39	243.46	37987.0
2017-06-19 07:30:00	SPY	ETF	243.44	243.52	243.42	243.47	133252.0
2017-06-19 08:00:00	SPY	ETF	243.49	243.56	243.36	243.4	116366.0
2017-06-19 08:30:00	SPY	ETF	243.42	243.55	243.38	243.49	228472.0
2017-06-19 09:00:00	SPY	ETF	243.48	243.62	243.44	243.58	252308.0
2017-06-19 09:30:00	SPY	ETF	243.59	243.9	243.48	243.89	6120233.0
2017-06-19 10:00:00	SPY	ETF	243.89	244.39	243.86	244.36	5265878.0
2017-06-19 10:30:00	SPY	ETF	244.36	244.58	244.19	244.19	3737776.0
2017-06-19 11:00:00	SPY	ETF	244.19	244.3	244.07	244.16	3423154.0
2017-06-19 11:30:00	SPY	ETF	244.16	244.34	244.15	244.29	1780020.0
2017-06-19 12:00:00	SPY	ETF	244.29	244.47	244.29	244.43	1501202.0
2017-06-19 12:30:00	SPY	ETF	244.43	244.47	244.28	244.42	1658550.0
2017-06-19 13:00:00	SPY	ETF	244.42	244.53	244.42	244.52	2488857.0
2017-06-19 13:30:00	SPY	ETF	244.51	244.67	244.42	244.43	5070619.0
2017-06-19 14:00:00	SPY	ETF	244.425	244.47	244.225	244.28	3568449.0
2017-06-19 14:30:00	SPY	ETF	244.285	244.39	244.15	244.2375	3156482.0
2017-06-19 15:00:00	SPY	ETF	244.24	244.43	244.23	244.41	2900228.0
2017-06-19 15:30:00	SPY	ETF	244.4199	244.73	244.365	244.64	9521504.0
2017-06-19 16:00:00	SPY	ETF	244.64	244.7	244.31	244.36	10697881.0
2017-06-19 16:30:00	SPY	ETF	244.36	244.6818	244.293	244.38	1787821.0
2017-06-19 17:00:00	SPY	ETF	244.38	244.4	244.37	244.37	162392.0
2017-06-19 17:30:00	SPY	ETF	244.38	244.41	244.37	244.39	18896.0
2017-06-19 18:00:00	SPY	ETF	244.39	244.46	244.39	244.44	198899.0
2017-06-19 18:30:00	SPY	ETF	244.44	244.5	244.44	244.5	33715.0
2017-06-19 19:00:00	SPY	ETF	244.48	244.48	244.42	244.44	12250.0
2017-06-19 19:30:00	SPY	ETF	244.47	244.55	244.47	244.52	28868.0
2017-06-19 04:00:00	QQQ	ETF	138.87	139.15	138.87	139.04	6488.0
2017-06-19 04:30:00	QQQ	ETF	139.09	139.1	139.06	139.06	6600.0
2017-06-19 05:00:00	QQQ	ETF	139.13	139.13	139.13	139.13	300.0
2017-06-19 05:30:00	QQQ	ETF	139.28	139.28	139.04	139.07	6218.0
2017-06-19 06:00:00	QQQ	ETF	139.05	139.05	139.02	139.03	1947.0
2017-06-19 06:30:00	QQQ	ETF	139.1	139.1	139.1	139.1	200.0
2017-06-19 07:00:00	QQQ	ETF	139.1	139.15	139.08	139.13	26300.0
2017-06-19 07:30:00	QQQ	ETF	139.15	139.27	139.14	139.26	106370.0
2017-06-19 08:00:00	QQQ	ETF	139.26	139.49	139.18	139.35	343801.0
2017-06-19 08:30:00	QQQ	ETF	139.35	139.4	139.24	139.39	219536.0
2017-06-19 09:00:00	QQQ	ETF	139.38	139.48	139.34	139.46	313977.0
2017-06-19 09:30:00	QQQ	ETF	139.45	139.91	139.28	139.82	5664955.0
2017-06-19 10:00:00	QQQ	ETF	139.82	140.3369	139.82	140.25	4676462.0
2017-06-19 10:30:00	QQQ	ETF	140.26	140.38	140.061	140.15	2123325.0
2017-06-19 11:00:00	QQQ	ETF	140.1439	140.24	140.09	140.1569	1082910.0
2017-06-19 11:30:00	QQQ	ETF	140.15	140.21	140.08	140.11	1059866.0
2017-06-19 12:00:00	QQQ	ETF	140.11	140.19	140.0	140.18	1292316.0
2017-06-19 12:30:00	QQQ	ETF	140.19	140.23	140.08	140.19	654801.0

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

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