PREVIEW / etf_1min / 2017-09-29

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-29.parquet
  size:    2.6 MB
  rows:    137,690

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-09-29 04:02:00	SPY	ETF	250.23	250.23	250.23	250.23	200.0
2017-09-29 04:06:00	SPY	ETF	250.3	250.3	250.3	250.3	1500.0
2017-09-29 04:07:00	SPY	ETF	250.3	250.3	250.3	250.3	2500.0
2017-09-29 04:21:00	SPY	ETF	250.29	250.29	250.29	250.29	900.0
2017-09-29 04:22:00	SPY	ETF	250.32	250.32	250.32	250.32	1000.0
2017-09-29 04:28:00	SPY	ETF	250.29	250.29	250.29	250.29	900.0
2017-09-29 04:33:00	SPY	ETF	250.29	250.29	250.29	250.29	7500.0
2017-09-29 04:34:00	SPY	ETF	250.26	250.26	250.26	250.26	400.0
2017-09-29 04:35:00	SPY	ETF	250.26	250.26	250.26	250.26	1000.0
2017-09-29 04:38:00	SPY	ETF	250.29	250.29	250.29	250.29	100.0
2017-09-29 04:41:00	SPY	ETF	250.31	250.31	250.31	250.31	300.0
2017-09-29 04:49:00	SPY	ETF	250.26	250.26	250.26	250.26	800.0
2017-09-29 04:50:00	SPY	ETF	250.26	250.26	250.26	250.26	800.0
2017-09-29 04:51:00	SPY	ETF	250.27	250.27	250.27	250.27	100.0
2017-09-29 04:57:00	SPY	ETF	250.24	250.24	250.24	250.24	4050.0
2017-09-29 04:59:00	SPY	ETF	250.24	250.24	250.24	250.24	500.0
2017-09-29 05:03:00	SPY	ETF	250.29	250.29	250.29	250.29	1200.0
2017-09-29 05:14:00	SPY	ETF	250.26	250.26	250.26	250.26	100.0
2017-09-29 05:16:00	SPY	ETF	250.3	250.3	250.3	250.3	500.0
2017-09-29 05:19:00	SPY	ETF	250.24	250.24	250.24	250.24	300.0
2017-09-29 05:28:00	SPY	ETF	250.24	250.24	250.24	250.24	100.0
2017-09-29 05:30:00	SPY	ETF	250.24	250.24	250.24	250.24	500.0
2017-09-29 05:32:00	SPY	ETF	250.24	250.24	250.24	250.24	300.0
2017-09-29 05:33:00	SPY	ETF	250.24	250.24	250.24	250.24	500.0
2017-09-29 05:34:00	SPY	ETF	250.26	250.26	250.26	250.26	2900.0
2017-09-29 05:46:00	SPY	ETF	250.24	250.24	250.24	250.24	300.0
2017-09-29 05:47:00	SPY	ETF	250.24	250.24	250.24	250.24	800.0
2017-09-29 05:50:00	SPY	ETF	250.26	250.26	250.24	250.24	300.0
2017-09-29 05:51:00	SPY	ETF	250.28	250.28	250.28	250.28	100.0
2017-09-29 05:55:00	SPY	ETF	250.29	250.29	250.29	250.29	500.0
2017-09-29 06:01:00	SPY	ETF	250.29	250.29	250.29	250.29	500.0
2017-09-29 06:08:00	SPY	ETF	250.3	250.32	250.3	250.32	738.0
2017-09-29 06:15:00	SPY	ETF	250.31	250.31	250.31	250.31	100.0
2017-09-29 06:16:00	SPY	ETF	250.31	250.31	250.31	250.31	500.0
2017-09-29 06:18:00	SPY	ETF	250.32	250.32	250.32	250.32	1971.0
2017-09-29 06:22:00	SPY	ETF	250.33	250.33	250.33	250.33	100.0
2017-09-29 06:24:00	SPY	ETF	250.31	250.31	250.31	250.31	300.0
2017-09-29 06:25:00	SPY	ETF	250.31	250.31	250.31	250.31	500.0
2017-09-29 06:29:00	SPY	ETF	250.34	250.34	250.34	250.34	4100.0
2017-09-29 06:50:00	SPY	ETF	250.35	250.35	250.35	250.35	2300.0
2017-09-29 06:52:00	SPY	ETF	250.36	250.36	250.36	250.36	3970.0
2017-09-29 06:55:00	SPY	ETF	250.35	250.35	250.35	250.35	800.0
2017-09-29 06:58:00	SPY	ETF	250.36	250.36	250.36	250.36	1900.0
2017-09-29 07:00:00	SPY	ETF	250.34	250.34	250.33	250.33	620.0
2017-09-29 07:01:00	SPY	ETF	250.33	250.33	250.33	250.33	1020.0
2017-09-29 07:02:00	SPY	ETF	250.3	250.31	250.29	250.31	4304.0
2017-09-29 07:06:00	SPY	ETF	250.29	250.29	250.29	250.29	100.0
2017-09-29 07:07:00	SPY	ETF	250.29	250.29	250.29	250.29	100.0
2017-09-29 07:08:00	SPY	ETF	250.29	250.29	250.29	250.29	302.0
2017-09-29 07:09:00	SPY	ETF	250.32	250.32	250.29	250.29	2600.0

> showing 50 of 137,690 rows — these rows as CSV

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