PREVIEW / etf_1min / 2017-01-11

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-11.parquet
  size:    2.9 MB
  rows:    153,561

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-01-11 04:00:00	SPY	ETF	226.15	226.28	226.09	226.09	557.0
2017-01-11 04:06:00	SPY	ETF	226.17	226.17	226.17	226.17	300.0
2017-01-11 04:07:00	SPY	ETF	226.12	226.14	226.12	226.14	750.0
2017-01-11 04:11:00	SPY	ETF	226.09	226.09	226.09	226.09	210.0
2017-01-11 04:15:00	SPY	ETF	226.11	226.11	226.11	226.11	300.0
2017-01-11 04:16:00	SPY	ETF	226.06	226.06	226.06	226.06	500.0
2017-01-11 04:19:00	SPY	ETF	226.18	226.22	226.17	226.22	6403.0
2017-01-11 04:20:00	SPY	ETF	226.21	226.21	226.21	226.21	800.0
2017-01-11 04:22:00	SPY	ETF	226.21	226.21	226.2	226.2	2205.0
2017-01-11 04:23:00	SPY	ETF	226.25	226.26	226.25	226.25	3009.0
2017-01-11 04:24:00	SPY	ETF	226.3	226.3	226.3	226.3	304.0
2017-01-11 04:26:00	SPY	ETF	226.33	226.33	226.33	226.33	400.0
2017-01-11 04:27:00	SPY	ETF	226.33	226.33	226.33	226.33	500.0
2017-01-11 04:31:00	SPY	ETF	226.3	226.31	226.3	226.31	800.0
2017-01-11 04:32:00	SPY	ETF	226.31	226.31	226.31	226.31	501.0
2017-01-11 04:33:00	SPY	ETF	226.3	226.3	226.3	226.3	300.0
2017-01-11 04:35:00	SPY	ETF	226.27	226.29	226.27	226.29	8301.0
2017-01-11 04:40:00	SPY	ETF	226.4	226.4	226.39	226.39	2006.0
2017-01-11 04:42:00	SPY	ETF	226.36	226.36	226.36	226.36	2376.0
2017-01-11 04:45:00	SPY	ETF	226.32	226.32	226.32	226.32	500.0
2017-01-11 04:47:00	SPY	ETF	226.33	226.34	226.33	226.34	1700.0
2017-01-11 04:48:00	SPY	ETF	226.36	226.36	226.36	226.36	402.0
2017-01-11 04:50:00	SPY	ETF	226.36	226.36	226.36	226.36	101.0
2017-01-11 04:54:00	SPY	ETF	226.36	226.36	226.36	226.36	399.0
2017-01-11 04:55:00	SPY	ETF	226.36	226.36	226.36	226.36	101.0
2017-01-11 04:56:00	SPY	ETF	226.38	226.45	226.38	226.45	1006.0
2017-01-11 04:58:00	SPY	ETF	226.52	226.52	226.52	226.52	409.0
2017-01-11 05:14:00	SPY	ETF	226.51	226.51	226.51	226.51	402.0
2017-01-11 05:18:00	SPY	ETF	226.46	226.46	226.46	226.46	1902.0
2017-01-11 05:31:00	SPY	ETF	226.49	226.49	226.49	226.49	400.0
2017-01-11 05:33:00	SPY	ETF	226.42	226.44	226.42	226.44	1801.0
2017-01-11 05:35:00	SPY	ETF	226.44	226.44	226.44	226.44	400.0
2017-01-11 05:42:00	SPY	ETF	226.49	226.49	226.49	226.49	302.0
2017-01-11 05:57:00	SPY	ETF	226.48	226.48	226.48	226.48	200.0
2017-01-11 06:06:00	SPY	ETF	226.46	226.47	226.46	226.47	1503.0
2017-01-11 06:11:00	SPY	ETF	226.48	226.48	226.48	226.48	500.0
2017-01-11 06:12:00	SPY	ETF	226.46	226.46	226.46	226.46	271.0
2017-01-11 06:13:00	SPY	ETF	226.46	226.46	226.46	226.46	1050.0
2017-01-11 06:14:00	SPY	ETF	226.46	226.48	226.46	226.48	300.0
2017-01-11 06:15:00	SPY	ETF	226.41	226.41	226.41	226.41	308.0
2017-01-11 06:16:00	SPY	ETF	226.44	226.44	226.44	226.44	900.0
2017-01-11 06:24:00	SPY	ETF	226.41	226.41	226.41	226.41	201.0
2017-01-11 06:34:00	SPY	ETF	226.44	226.44	226.44	226.44	300.0
2017-01-11 06:42:00	SPY	ETF	226.39	226.39	226.39	226.39	5003.0
2017-01-11 06:43:00	SPY	ETF	226.36	226.36	226.36	226.36	5556.0
2017-01-11 06:47:00	SPY	ETF	226.36	226.36	226.36	226.36	201.0
2017-01-11 06:55:00	SPY	ETF	226.5	226.5	226.5	226.5	552.0
2017-01-11 06:59:00	SPY	ETF	226.53	226.53	226.53	226.53	202.0
2017-01-11 07:01:00	SPY	ETF	226.48	226.48	226.48	226.48	501.0
2017-01-11 07:02:00	SPY	ETF	226.51	226.51	226.51	226.51	500.0

> showing 50 of 153,561 rows — these rows as CSV

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