PREVIEW / etf_30min / 2017-02-22

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-22.parquet
  size:    432 KB
  rows:    14,887

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-02-22 04:00:00	SPY	ETF	236.27	236.35	236.15	236.2	10950.0
2017-02-22 04:30:00	SPY	ETF	236.22	236.22	236.12	236.17	6100.0
2017-02-22 05:00:00	SPY	ETF	236.17	236.23	236.05	236.05	4600.0
2017-02-22 05:30:00	SPY	ETF	236.05	236.05	235.81	235.85	9685.0
2017-02-22 06:00:00	SPY	ETF	235.92	236.05	235.9	235.93	7505.0
2017-02-22 06:30:00	SPY	ETF	235.92	236.01	235.78	235.78	23520.0
2017-02-22 07:00:00	SPY	ETF	235.77	235.88	235.76	235.85	29580.0
2017-02-22 07:30:00	SPY	ETF	235.83	235.88	235.8	235.83	58271.0
2017-02-22 08:00:00	SPY	ETF	235.83	236.03	235.78	235.98	109873.0
2017-02-22 08:30:00	SPY	ETF	235.98	236.01	235.89	236.0	164556.0
2017-02-22 09:00:00	SPY	ETF	236.0	236.03	235.88	236.01	492050.0
2017-02-22 09:30:00	SPY	ETF	236.02	236.16	235.83	235.99	5312635.0
2017-02-22 10:00:00	SPY	ETF	235.99	236.3384	235.97	236.299	4092278.0
2017-02-22 10:30:00	SPY	ETF	236.3	236.54	236.26	236.28	4298850.0
2017-02-22 11:00:00	SPY	ETF	236.275	236.31	236.04	236.22	3747411.0
2017-02-22 11:30:00	SPY	ETF	236.23	236.295	236.11	236.11	2678309.0
2017-02-22 12:00:00	SPY	ETF	236.11	236.3	236.07	236.245	2466939.0
2017-02-22 12:30:00	SPY	ETF	236.25	236.37	236.2185	236.36	1407476.0
2017-02-22 13:00:00	SPY	ETF	236.36	236.45	236.33	236.42	1876352.0
2017-02-22 13:30:00	SPY	ETF	236.42	236.49	236.39	236.43	1807760.0
2017-02-22 14:00:00	SPY	ETF	236.44	236.48	235.97	236.37	5219680.0
2017-02-22 14:30:00	SPY	ETF	236.37	236.37	236.1	236.175	3527268.0
2017-02-22 15:00:00	SPY	ETF	236.19	236.41	236.12	236.38	3169072.0
2017-02-22 15:30:00	SPY	ETF	236.38	236.42	236.17	236.3	12635663.0
2017-02-22 16:00:00	SPY	ETF	236.3	236.38	236.22	236.32	7723221.0
2017-02-22 16:30:00	SPY	ETF	236.32	236.46	236.3	236.46	234077.0
2017-02-22 17:00:00	SPY	ETF	236.42	236.45	236.39	236.4	123249.0
2017-02-22 17:30:00	SPY	ETF	236.4	236.41	236.28	236.38	59236.0
2017-02-22 18:00:00	SPY	ETF	236.4	236.45	236.29	236.29	81069.0
2017-02-22 18:30:00	SPY	ETF	236.28	236.32	236.26	236.32	27090.0
2017-02-22 19:00:00	SPY	ETF	236.3	236.34	236.26	236.34	6926.0
2017-02-22 19:30:00	SPY	ETF	236.32	236.32	236.17	236.21	33705.0
2017-02-22 04:00:00	QQQ	ETF	130.35	130.36	130.32	130.32	450.0
2017-02-22 04:30:00	QQQ	ETF	130.3	130.3	130.3	130.3	308.0
2017-02-22 05:00:00	QQQ	ETF	130.3	130.3	130.3	130.3	1000.0
2017-02-22 05:30:00	QQQ	ETF	130.19	130.22	130.19	130.2	10546.0
2017-02-22 06:00:00	QQQ	ETF	130.17	130.25	130.17	130.25	10270.0
2017-02-22 07:00:00	QQQ	ETF	130.16	130.16	130.16	130.16	1000.0
2017-02-22 07:30:00	QQQ	ETF	130.21	130.21	130.21	130.21	9000.0
2017-02-22 08:00:00	QQQ	ETF	130.2	130.29	130.19	130.27	66018.0
2017-02-22 08:30:00	QQQ	ETF	130.28	130.31	130.26	130.29	151096.0
2017-02-22 09:00:00	QQQ	ETF	130.3	130.34	130.27	130.33	39369.0
2017-02-22 09:30:00	QQQ	ETF	130.32	130.42	130.111	130.2	1453464.0
2017-02-22 10:00:00	QQQ	ETF	130.21	130.44	130.17	130.415	1302944.0
2017-02-22 10:30:00	QQQ	ETF	130.42	130.4734	130.33	130.36	901412.0
2017-02-22 11:00:00	QQQ	ETF	130.365	130.43	130.23	130.39	667791.0
2017-02-22 11:30:00	QQQ	ETF	130.38	130.45	130.35	130.35	569623.0
2017-02-22 12:00:00	QQQ	ETF	130.35	130.4865	130.34	130.465	342670.0
2017-02-22 12:30:00	QQQ	ETF	130.465	130.52	130.45	130.5169	505345.0
2017-02-22 13:00:00	QQQ	ETF	130.52	130.545	130.47	130.525	412584.0

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

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