PREVIEW / etf_1min / 2017-10-02

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-10-02.parquet
  size:    2.9 MB
  rows:    150,201

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-10-02 04:02:00	SPY	ETF	251.44	251.44	251.44	251.44	200.0
2017-10-02 04:04:00	SPY	ETF	251.47	251.47	251.45	251.45	600.0
2017-10-02 04:13:00	SPY	ETF	251.43	251.43	251.43	251.43	3000.0
2017-10-02 04:15:00	SPY	ETF	251.41	251.41	251.41	251.41	700.0
2017-10-02 04:16:00	SPY	ETF	251.43	251.43	251.43	251.43	3000.0
2017-10-02 04:19:00	SPY	ETF	251.43	251.43	251.43	251.43	3200.0
2017-10-02 04:25:00	SPY	ETF	251.44	251.44	251.43	251.43	4200.0
2017-10-02 04:28:00	SPY	ETF	251.48	251.48	251.48	251.48	3000.0
2017-10-02 04:45:00	SPY	ETF	251.46	251.46	251.46	251.46	100.0
2017-10-02 04:48:00	SPY	ETF	251.43	251.43	251.43	251.43	100.0
2017-10-02 04:52:00	SPY	ETF	251.45	251.45	251.45	251.45	170.0
2017-10-02 05:04:00	SPY	ETF	251.45	251.45	251.45	251.45	300.0
2017-10-02 05:14:00	SPY	ETF	251.48	251.48	251.48	251.48	102.0
2017-10-02 05:16:00	SPY	ETF	251.47	251.47	251.47	251.47	300.0
2017-10-02 05:24:00	SPY	ETF	251.48	251.48	251.48	251.48	100.0
2017-10-02 05:30:00	SPY	ETF	251.52	251.52	251.52	251.52	2269.0
2017-10-02 05:41:00	SPY	ETF	251.54	251.54	251.54	251.54	1000.0
2017-10-02 05:52:00	SPY	ETF	251.57	251.57	251.57	251.57	400.0
2017-10-02 05:53:00	SPY	ETF	251.56	251.56	251.56	251.56	2000.0
2017-10-02 05:54:00	SPY	ETF	251.56	251.56	251.52	251.52	700.0
2017-10-02 05:55:00	SPY	ETF	251.55	251.55	251.55	251.55	1000.0
2017-10-02 06:01:00	SPY	ETF	251.53	251.53	251.53	251.53	100.0
2017-10-02 06:06:00	SPY	ETF	251.49	251.49	251.49	251.49	700.0
2017-10-02 06:08:00	SPY	ETF	251.52	251.52	251.52	251.52	1500.0
2017-10-02 06:13:00	SPY	ETF	251.57	251.57	251.57	251.57	300.0
2017-10-02 06:14:00	SPY	ETF	251.58	251.58	251.58	251.58	300.0
2017-10-02 06:16:00	SPY	ETF	251.6	251.6	251.6	251.6	200.0
2017-10-02 06:17:00	SPY	ETF	251.62	251.62	251.58	251.58	3804.0
2017-10-02 06:27:00	SPY	ETF	251.62	251.62	251.62	251.62	200.0
2017-10-02 06:28:00	SPY	ETF	251.58	251.58	251.58	251.58	500.0
2017-10-02 06:29:00	SPY	ETF	251.62	251.62	251.62	251.62	900.0
2017-10-02 06:30:00	SPY	ETF	251.63	251.63	251.63	251.63	2520.0
2017-10-02 06:32:00	SPY	ETF	251.61	251.61	251.61	251.61	500.0
2017-10-02 06:33:00	SPY	ETF	251.62	251.62	251.62	251.62	5000.0
2017-10-02 06:34:00	SPY	ETF	251.6	251.6	251.6	251.6	500.0
2017-10-02 06:37:00	SPY	ETF	251.58	251.58	251.58	251.58	300.0
2017-10-02 06:38:00	SPY	ETF	251.6	251.6	251.6	251.6	300.0
2017-10-02 06:42:00	SPY	ETF	251.6	251.6	251.6	251.6	500.0
2017-10-02 06:43:00	SPY	ETF	251.63	251.63	251.63	251.63	380.0
2017-10-02 06:45:00	SPY	ETF	251.65	251.65	251.65	251.65	305.0
2017-10-02 06:47:00	SPY	ETF	251.63	251.63	251.63	251.63	500.0
2017-10-02 06:48:00	SPY	ETF	251.63	251.63	251.63	251.63	400.0
2017-10-02 06:56:00	SPY	ETF	251.68	251.68	251.68	251.68	472.0
2017-10-02 06:58:00	SPY	ETF	251.69	251.69	251.68	251.68	400.0
2017-10-02 07:00:00	SPY	ETF	251.68	251.7	251.68	251.7	600.0
2017-10-02 07:01:00	SPY	ETF	251.66	251.66	251.66	251.66	925.0
2017-10-02 07:02:00	SPY	ETF	251.66	251.66	251.66	251.66	300.0
2017-10-02 07:03:00	SPY	ETF	251.67	251.68	251.66	251.66	710.0
2017-10-02 07:04:00	SPY	ETF	251.68	251.68	251.66	251.66	890.0
2017-10-02 07:08:00	SPY	ETF	251.63	251.63	251.63	251.63	410.0

> showing 50 of 150,201 rows — these rows as CSV

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