PREVIEW / etf_30min / 2016-12-27

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-27.parquet
  size:    414 KB
  rows:    14,463

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-12-27 05:00:00	SPY	ETF	225.67	225.67	225.67	225.67	201.0
2016-12-27 05:30:00	SPY	ETF	225.61	225.61	225.61	225.61	100.0
2016-12-27 06:00:00	SPY	ETF	225.67	225.8	225.67	225.8	580.0
2016-12-27 06:30:00	SPY	ETF	225.89	225.89	225.89	225.89	499.0
2016-12-27 07:00:00	SPY	ETF	225.87	225.93	225.87	225.93	3402.0
2016-12-27 07:30:00	SPY	ETF	225.89	225.89	225.86	225.88	12046.0
2016-12-27 08:00:00	SPY	ETF	225.89	225.94	225.81	225.89	76332.0
2016-12-27 08:30:00	SPY	ETF	225.92	226.03	225.9	226.01	47376.0
2016-12-27 09:00:00	SPY	ETF	225.99	226.07	225.99	226.01	248832.0
2016-12-27 09:30:00	SPY	ETF	226.02	226.72	226.0	226.61	5514845.0
2016-12-27 10:00:00	SPY	ETF	226.62	226.73	226.56	226.6	2152373.0
2016-12-27 10:30:00	SPY	ETF	226.6	226.63	226.53	226.56	1732130.0
2016-12-27 11:00:00	SPY	ETF	226.56	226.62	226.38	226.4589	2069786.0
2016-12-27 11:30:00	SPY	ETF	226.46	226.53	226.29	226.36	2836049.0
2016-12-27 12:00:00	SPY	ETF	226.35	226.36	226.25	226.295	2035730.0
2016-12-27 12:30:00	SPY	ETF	226.3	226.3698	226.26	226.355	2011961.0
2016-12-27 13:00:00	SPY	ETF	226.35	226.41	226.32	226.3901	1584501.0
2016-12-27 13:30:00	SPY	ETF	226.4	226.61	226.35	226.401	1769134.0
2016-12-27 14:00:00	SPY	ETF	226.41	226.5	226.32	226.4601	1961847.0
2016-12-27 14:30:00	SPY	ETF	226.46	226.53	226.36	226.3673	2234306.0
2016-12-27 15:00:00	SPY	ETF	226.368	226.47	226.31	226.385	1701397.0
2016-12-27 15:30:00	SPY	ETF	226.385	226.39	226.14	226.24	6019980.0
2016-12-27 16:00:00	SPY	ETF	226.24	226.27	225.94	226.0	5088296.0
2016-12-27 16:30:00	SPY	ETF	226.0	226.27	225.88	225.97	1254354.0
2016-12-27 17:00:00	SPY	ETF	226.0	226.05	226.0	226.04	46886.0
2016-12-27 17:30:00	SPY	ETF	226.01	226.04	226.01	226.04	13630.0
2016-12-27 18:00:00	SPY	ETF	226.05	226.27	226.03	226.27	12885.0
2016-12-27 18:30:00	SPY	ETF	226.06	226.09	226.06	226.06	4235.0
2016-12-27 19:00:00	SPY	ETF	226.06	226.08	226.05	226.08	5890.0
2016-12-27 19:30:00	SPY	ETF	226.08	226.1	226.06	226.07	15757.0
2016-12-27 06:00:00	QQQ	ETF	120.34	120.34	120.34	120.34	300.0
2016-12-27 06:30:00	QQQ	ETF	120.36	120.36	120.36	120.36	1000.0
2016-12-27 07:00:00	QQQ	ETF	120.35	120.39	120.35	120.39	300.0
2016-12-27 08:00:00	QQQ	ETF	120.39	120.41	120.38	120.41	10665.0
2016-12-27 08:30:00	QQQ	ETF	120.4	120.46	120.4	120.46	25752.0
2016-12-27 09:00:00	QQQ	ETF	120.43	120.46	120.41	120.42	72950.0
2016-12-27 09:30:00	QQQ	ETF	120.44	121.5095	120.41	121.4	4275057.0
2016-12-27 10:00:00	QQQ	ETF	121.41	121.52	121.3103	121.34	2003292.0
2016-12-27 10:30:00	QQQ	ETF	121.34	121.36	121.24	121.28	548439.0
2016-12-27 11:00:00	QQQ	ETF	121.285	121.33	121.17	121.21	683003.0
2016-12-27 11:30:00	QQQ	ETF	121.2072	121.27	121.0	121.0312	822644.0
2016-12-27 12:00:00	QQQ	ETF	121.03	121.047	120.93	120.9865	540224.0
2016-12-27 12:30:00	QQQ	ETF	120.99	121.059	120.94	121.03	318231.0
2016-12-27 13:00:00	QQQ	ETF	121.035	121.11	120.981	121.1	549857.0
2016-12-27 13:30:00	QQQ	ETF	121.1	121.14	121.0	121.04	310116.0
2016-12-27 14:00:00	QQQ	ETF	121.05	121.11	120.98	121.07	291638.0
2016-12-27 14:30:00	QQQ	ETF	121.07	121.0761	120.97	120.98	461858.0
2016-12-27 15:00:00	QQQ	ETF	120.98	121.06	120.9627	121.01	306672.0
2016-12-27 15:30:00	QQQ	ETF	121.01	121.011	120.8	120.85	2053510.0
2016-12-27 16:00:00	QQQ	ETF	120.84	120.8606	120.7	120.7	550381.0

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

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