PREVIEW / etf_1min / 2017-03-29

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-03-29.parquet
  size:    2.6 MB
  rows:    139,414

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-03-29 04:00:00	SPY	ETF	235.26	235.3	235.26	235.3	538.0
2017-03-29 04:02:00	SPY	ETF	235.43	235.43	235.43	235.43	100.0
2017-03-29 04:04:00	SPY	ETF	235.21	235.21	235.21	235.21	300.0
2017-03-29 04:12:00	SPY	ETF	235.24	235.24	235.24	235.24	132.0
2017-03-29 04:15:00	SPY	ETF	235.27	235.27	235.27	235.27	300.0
2017-03-29 04:52:00	SPY	ETF	235.07	235.07	235.07	235.07	202.0
2017-03-29 04:59:00	SPY	ETF	235.07	235.07	235.07	235.07	301.0
2017-03-29 05:03:00	SPY	ETF	235.03	235.03	235.03	235.03	124.0
2017-03-29 05:06:00	SPY	ETF	235.0	235.0	235.0	235.0	110.0
2017-03-29 05:07:00	SPY	ETF	235.02	235.04	235.02	235.04	1901.0
2017-03-29 05:08:00	SPY	ETF	235.05	235.08	235.05	235.08	303.0
2017-03-29 05:09:00	SPY	ETF	235.05	235.08	235.05	235.08	301.0
2017-03-29 05:16:00	SPY	ETF	235.08	235.08	235.08	235.08	100.0
2017-03-29 05:27:00	SPY	ETF	234.95	234.95	234.95	234.95	100.0
2017-03-29 05:31:00	SPY	ETF	235.0	235.0	235.0	235.0	500.0
2017-03-29 05:38:00	SPY	ETF	234.89	234.93	234.89	234.93	570.0
2017-03-29 05:42:00	SPY	ETF	234.93	234.93	234.93	234.93	500.0
2017-03-29 05:54:00	SPY	ETF	234.93	234.93	234.93	234.93	400.0
2017-03-29 05:55:00	SPY	ETF	234.93	234.93	234.93	234.93	400.0
2017-03-29 06:00:00	SPY	ETF	234.96	234.96	234.96	234.96	549.0
2017-03-29 06:09:00	SPY	ETF	234.89	234.89	234.87	234.87	304.0
2017-03-29 06:17:00	SPY	ETF	234.93	234.93	234.93	234.93	200.0
2017-03-29 06:23:00	SPY	ETF	234.9	234.9	234.9	234.9	100.0
2017-03-29 06:26:00	SPY	ETF	234.91	234.91	234.91	234.91	700.0
2017-03-29 06:27:00	SPY	ETF	234.91	234.91	234.91	234.91	414.0
2017-03-29 06:34:00	SPY	ETF	234.86	234.86	234.86	234.86	1700.0
2017-03-29 06:35:00	SPY	ETF	234.86	234.86	234.84	234.84	3000.0
2017-03-29 06:37:00	SPY	ETF	234.83	234.83	234.77	234.77	603.0
2017-03-29 06:38:00	SPY	ETF	234.83	234.83	234.83	234.83	300.0
2017-03-29 06:42:00	SPY	ETF	234.8	234.8	234.8	234.8	300.0
2017-03-29 06:44:00	SPY	ETF	234.84	234.84	234.84	234.84	10000.0
2017-03-29 06:46:00	SPY	ETF	234.84	234.84	234.84	234.84	200.0
2017-03-29 06:49:00	SPY	ETF	234.84	234.84	234.84	234.84	1000.0
2017-03-29 06:50:00	SPY	ETF	234.83	234.84	234.83	234.83	6350.0
2017-03-29 06:51:00	SPY	ETF	234.83	234.83	234.82	234.82	17700.0
2017-03-29 06:54:00	SPY	ETF	234.85	234.85	234.85	234.85	112.0
2017-03-29 06:55:00	SPY	ETF	234.88	234.88	234.88	234.88	600.0
2017-03-29 07:00:00	SPY	ETF	234.92	234.92	234.92	234.92	703.0
2017-03-29 07:01:00	SPY	ETF	234.92	234.92	234.87	234.91	4237.0
2017-03-29 07:02:00	SPY	ETF	234.91	234.91	234.91	234.91	100.0
2017-03-29 07:03:00	SPY	ETF	234.93	234.94	234.93	234.94	2700.0
2017-03-29 07:04:00	SPY	ETF	234.94	234.94	234.94	234.94	500.0
2017-03-29 07:05:00	SPY	ETF	234.94	234.94	234.93	234.93	1601.0
2017-03-29 07:14:00	SPY	ETF	234.98	234.99	234.98	234.99	2102.0
2017-03-29 07:15:00	SPY	ETF	234.99	234.99	234.99	234.99	301.0
2017-03-29 07:16:00	SPY	ETF	234.96	234.97	234.96	234.96	871.0
2017-03-29 07:18:00	SPY	ETF	234.97	234.97	234.97	234.97	300.0
2017-03-29 07:21:00	SPY	ETF	234.97	234.97	234.97	234.97	30001.0
2017-03-29 07:25:00	SPY	ETF	234.93	234.93	234.92	234.92	2233.0
2017-03-29 07:26:00	SPY	ETF	234.91	234.91	234.91	234.91	1000.0

> showing 50 of 139,414 rows — these rows as CSV

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