PREVIEW / etf_30min / 2017-02-01

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-01.parquet
  size:    442 KB
  rows:    14,983

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-01 04:00:00	SPY	ETF	227.9	228.0	227.9	228.0	300.0
2017-02-01 04:30:00	SPY	ETF	228.0	228.08	227.96	228.08	5218.0
2017-02-01 05:00:00	SPY	ETF	228.06	228.15	228.02	228.15	13260.0
2017-02-01 05:30:00	SPY	ETF	228.14	228.14	228.0	228.06	3604.0
2017-02-01 06:00:00	SPY	ETF	228.02	228.08	228.02	228.05	6301.0
2017-02-01 06:30:00	SPY	ETF	228.04	228.04	227.94	227.96	13787.0
2017-02-01 07:00:00	SPY	ETF	228.02	228.09	227.99	228.03	50587.0
2017-02-01 07:30:00	SPY	ETF	228.03	228.11	228.0	228.1	79096.0
2017-02-01 08:00:00	SPY	ETF	228.09	228.26	227.97	228.19	222990.0
2017-02-01 08:30:00	SPY	ETF	228.21	228.28	227.53	228.15	314618.0
2017-02-01 09:00:00	SPY	ETF	228.18	228.33	228.1	228.27	408985.0
2017-02-01 09:30:00	SPY	ETF	228.255	228.59	228.17	228.19	6960375.0
2017-02-01 10:00:00	SPY	ETF	228.23	228.35	227.745	227.85	5150120.0
2017-02-01 10:30:00	SPY	ETF	227.85	227.9	227.15	227.25	6588397.0
2017-02-01 11:00:00	SPY	ETF	227.26	227.53	227.15	227.24	4465396.0
2017-02-01 11:30:00	SPY	ETF	227.24	227.36	226.94	227.2	4894914.0
2017-02-01 12:00:00	SPY	ETF	227.21	227.36	227.125	227.305	2101110.0
2017-02-01 12:30:00	SPY	ETF	227.3	227.5	227.3	227.3999	2206883.0
2017-02-01 13:00:00	SPY	ETF	227.396	227.59	227.33	227.37	1920565.0
2017-02-01 13:30:00	SPY	ETF	227.375	227.49	227.1	227.26	3436114.0
2017-02-01 14:00:00	SPY	ETF	227.25	227.9	227.02	227.7608	9446724.0
2017-02-01 14:30:00	SPY	ETF	227.78	227.8	227.14	227.36	6149979.0
2017-02-01 15:00:00	SPY	ETF	227.365	227.7	227.35	227.67	3818193.0
2017-02-01 15:30:00	SPY	ETF	227.67	227.86	227.55	227.64	10759728.0
2017-02-01 16:00:00	SPY	ETF	227.64	227.75	227.55	227.57	8367554.0
2017-02-01 16:30:00	SPY	ETF	227.58	227.66	227.56	227.6	213124.0
2017-02-01 17:00:00	SPY	ETF	227.56	227.63	227.48	227.58	130213.0
2017-02-01 17:30:00	SPY	ETF	227.56	227.6	227.55	227.59	38826.0
2017-02-01 18:00:00	SPY	ETF	227.6	227.63	227.4	227.41	86178.0
2017-02-01 18:30:00	SPY	ETF	227.38	227.43	227.31	227.41	20153.0
2017-02-01 19:00:00	SPY	ETF	227.39	227.41	227.22	227.22	37442.0
2017-02-01 19:30:00	SPY	ETF	227.23	227.28	227.11	227.12	37568.0
2017-02-01 04:00:00	QQQ	ETF	125.14	125.14	125.14	125.14	1200.0
2017-02-01 04:30:00	QQQ	ETF	125.15	125.15	125.15	125.15	100.0
2017-02-01 05:00:00	QQQ	ETF	125.23	125.23	125.23	125.23	250.0
2017-02-01 06:00:00	QQQ	ETF	125.18	125.22	125.18	125.21	799.0
2017-02-01 06:30:00	QQQ	ETF	125.21	125.21	125.15	125.15	969.0
2017-02-01 07:00:00	QQQ	ETF	125.23	125.27	125.21	125.24	11543.0
2017-02-01 07:30:00	QQQ	ETF	125.23	125.31	125.23	125.3	7396.0
2017-02-01 08:00:00	QQQ	ETF	125.28	125.41	125.28	125.35	71087.0
2017-02-01 08:30:00	QQQ	ETF	125.36	125.4	124.57	125.35	62689.0
2017-02-01 09:00:00	QQQ	ETF	125.35	125.48	125.33	125.42	273837.0
2017-02-01 09:30:00	QQQ	ETF	125.42	125.68	125.36	125.38	3019500.0
2017-02-01 10:00:00	QQQ	ETF	125.39	125.5	125.09	125.22	1536510.0
2017-02-01 10:30:00	QQQ	ETF	125.22	125.3	124.91	124.95	1310244.0
2017-02-01 11:00:00	QQQ	ETF	124.9449	125.13	124.92	124.95	817339.0
2017-02-01 11:30:00	QQQ	ETF	124.96	125.04	124.86	125.009	926714.0
2017-02-01 12:00:00	QQQ	ETF	125.01	125.14	125.01	125.14	981449.0
2017-02-01 12:30:00	QQQ	ETF	125.15	125.29	125.15	125.22	797660.0
2017-02-01 13:00:00	QQQ	ETF	125.23	125.335	125.19	125.22	610809.0

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

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