PREVIEW / etf_1min / 2017-05-02

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-05-02.parquet
  size:    2.7 MB
  rows:    142,034

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-05-02 04:12:00	SPY	ETF	238.5	238.5	238.5	238.5	300.0
2017-05-02 04:24:00	SPY	ETF	238.62	238.62	238.62	238.62	304.0
2017-05-02 04:28:00	SPY	ETF	238.56	238.56	238.56	238.56	100.0
2017-05-02 04:34:00	SPY	ETF	238.58	238.58	238.58	238.58	400.0
2017-05-02 04:47:00	SPY	ETF	238.56	238.56	238.56	238.56	300.0
2017-05-02 04:49:00	SPY	ETF	238.58	238.58	238.58	238.58	300.0
2017-05-02 04:56:00	SPY	ETF	238.56	238.56	238.51	238.51	301.0
2017-05-02 05:01:00	SPY	ETF	238.56	238.56	238.56	238.56	400.0
2017-05-02 05:05:00	SPY	ETF	238.56	238.56	238.56	238.56	100.0
2017-05-02 05:07:00	SPY	ETF	238.58	238.58	238.58	238.58	600.0
2017-05-02 05:08:00	SPY	ETF	238.58	238.58	238.58	238.58	100.0
2017-05-02 05:10:00	SPY	ETF	238.6	238.6	238.54	238.54	800.0
2017-05-02 05:17:00	SPY	ETF	238.58	238.58	238.58	238.58	200.0
2017-05-02 05:25:00	SPY	ETF	238.63	238.63	238.63	238.63	100.0
2017-05-02 05:27:00	SPY	ETF	238.62	238.62	238.62	238.62	100.0
2017-05-02 05:30:00	SPY	ETF	238.66	238.66	238.66	238.66	475.0
2017-05-02 05:32:00	SPY	ETF	238.68	238.68	238.68	238.68	300.0
2017-05-02 05:33:00	SPY	ETF	238.68	238.68	238.68	238.68	4400.0
2017-05-02 05:42:00	SPY	ETF	238.68	238.68	238.68	238.68	150.0
2017-05-02 05:43:00	SPY	ETF	238.71	238.71	238.71	238.71	400.0
2017-05-02 05:44:00	SPY	ETF	238.71	238.71	238.71	238.71	400.0
2017-05-02 05:45:00	SPY	ETF	238.68	238.68	238.68	238.68	300.0
2017-05-02 05:47:00	SPY	ETF	238.7	238.7	238.68	238.68	200.0
2017-05-02 05:51:00	SPY	ETF	238.66	238.66	238.66	238.66	300.0
2017-05-02 05:53:00	SPY	ETF	238.75	238.75	238.75	238.75	1000.0
2017-05-02 05:54:00	SPY	ETF	238.74	238.74	238.74	238.74	100.0
2017-05-02 05:59:00	SPY	ETF	238.71	238.71	238.71	238.71	200.0
2017-05-02 06:00:00	SPY	ETF	238.74	238.74	238.74	238.74	200.0
2017-05-02 06:18:00	SPY	ETF	238.66	238.66	238.66	238.66	100.0
2017-05-02 06:20:00	SPY	ETF	238.6	238.6	238.6	238.6	400.0
2017-05-02 06:21:00	SPY	ETF	238.54	238.54	238.54	238.54	100.0
2017-05-02 06:30:00	SPY	ETF	238.58	238.58	238.58	238.58	1000.0
2017-05-02 06:36:00	SPY	ETF	238.6	238.6	238.6	238.6	1000.0
2017-05-02 06:37:00	SPY	ETF	238.6	238.6	238.6	238.6	3000.0
2017-05-02 06:44:00	SPY	ETF	238.61	238.61	238.61	238.61	300.0
2017-05-02 06:48:00	SPY	ETF	238.6	238.6	238.6	238.6	600.0
2017-05-02 06:49:00	SPY	ETF	238.6	238.61	238.58	238.61	37000.0
2017-05-02 06:50:00	SPY	ETF	238.61	238.61	238.61	238.61	200.0
2017-05-02 06:52:00	SPY	ETF	238.6	238.6	238.6	238.6	300.0
2017-05-02 06:56:00	SPY	ETF	238.6	238.64	238.6	238.62	18000.0
2017-05-02 06:57:00	SPY	ETF	238.63	238.63	238.63	238.63	300.0
2017-05-02 07:03:00	SPY	ETF	238.63	238.63	238.63	238.63	4000.0
2017-05-02 07:04:00	SPY	ETF	238.62	238.62	238.6	238.6	2000.0
2017-05-02 07:06:00	SPY	ETF	238.6	238.62	238.6	238.62	2800.0
2017-05-02 07:09:00	SPY	ETF	238.66	238.66	238.66	238.66	400.0
2017-05-02 07:10:00	SPY	ETF	238.66	238.66	238.66	238.66	300.0
2017-05-02 07:16:00	SPY	ETF	238.65	238.65	238.62	238.62	800.0
2017-05-02 07:17:00	SPY	ETF	238.66	238.66	238.66	238.66	5900.0
2017-05-02 07:18:00	SPY	ETF	238.66	238.66	238.66	238.66	400.0
2017-05-02 07:25:00	SPY	ETF	238.63	238.63	238.63	238.63	500.0

> showing 50 of 142,034 rows — these rows as CSV

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