PREVIEW / etf_1min / 2017-01-05

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-05.parquet
  size:    3.1 MB
  rows:    159,867

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-05 04:00:00	SPY	ETF	226.3	226.3	226.1	226.1	3840.0
2017-01-05 04:02:00	SPY	ETF	226.27	226.27	226.27	226.27	100.0
2017-01-05 04:05:00	SPY	ETF	226.26	226.26	226.26	226.26	756.0
2017-01-05 04:12:00	SPY	ETF	226.31	226.31	226.31	226.31	500.0
2017-01-05 04:13:00	SPY	ETF	226.31	226.31	226.31	226.31	1100.0
2017-01-05 04:14:00	SPY	ETF	226.31	226.31	226.31	226.31	3000.0
2017-01-05 04:16:00	SPY	ETF	226.28	226.28	226.28	226.28	500.0
2017-01-05 04:17:00	SPY	ETF	226.31	226.33	226.31	226.33	501.0
2017-01-05 04:18:00	SPY	ETF	226.32	226.35	226.32	226.35	501.0
2017-01-05 04:20:00	SPY	ETF	226.31	226.31	226.31	226.31	501.0
2017-01-05 04:21:00	SPY	ETF	226.32	226.32	226.32	226.32	300.0
2017-01-05 04:29:00	SPY	ETF	226.36	226.36	226.36	226.36	300.0
2017-01-05 04:30:00	SPY	ETF	226.38	226.38	226.38	226.38	602.0
2017-01-05 04:31:00	SPY	ETF	226.37	226.37	226.36	226.36	1100.0
2017-01-05 04:32:00	SPY	ETF	226.36	226.36	226.36	226.36	900.0
2017-01-05 04:34:00	SPY	ETF	226.37	226.37	226.35	226.36	3701.0
2017-01-05 04:39:00	SPY	ETF	226.38	226.38	226.38	226.38	300.0
2017-01-05 04:41:00	SPY	ETF	226.35	226.35	226.35	226.35	800.0
2017-01-05 04:47:00	SPY	ETF	226.35	226.35	226.35	226.35	700.0
2017-01-05 04:48:00	SPY	ETF	226.35	226.35	226.35	226.35	300.0
2017-01-05 04:52:00	SPY	ETF	226.38	226.38	226.38	226.38	100.0
2017-01-05 04:57:00	SPY	ETF	226.43	226.43	226.43	226.43	600.0
2017-01-05 04:58:00	SPY	ETF	226.43	226.43	226.43	226.43	900.0
2017-01-05 04:59:00	SPY	ETF	226.44	226.44	226.44	226.44	200.0
2017-01-05 05:01:00	SPY	ETF	226.42	226.42	226.42	226.42	500.0
2017-01-05 05:04:00	SPY	ETF	226.42	226.42	226.42	226.42	1400.0
2017-01-05 05:05:00	SPY	ETF	226.46	226.46	226.44	226.46	1400.0
2017-01-05 05:06:00	SPY	ETF	226.45	226.45	226.45	226.45	200.0
2017-01-05 05:11:00	SPY	ETF	226.42	226.42	226.42	226.42	1400.0
2017-01-05 05:13:00	SPY	ETF	226.42	226.42	226.42	226.42	1600.0
2017-01-05 05:15:00	SPY	ETF	226.42	226.42	226.42	226.42	600.0
2017-01-05 05:17:00	SPY	ETF	226.42	226.42	226.42	226.42	2200.0
2017-01-05 05:26:00	SPY	ETF	226.23	226.25	226.23	226.25	503.0
2017-01-05 05:32:00	SPY	ETF	226.23	226.23	226.23	226.23	1600.0
2017-01-05 05:34:00	SPY	ETF	226.2	226.2	226.2	226.2	500.0
2017-01-05 05:36:00	SPY	ETF	226.19	226.19	226.19	226.19	400.0
2017-01-05 05:39:00	SPY	ETF	226.2	226.21	226.2	226.21	800.0
2017-01-05 05:40:00	SPY	ETF	226.21	226.21	226.19	226.19	2804.0
2017-01-05 05:42:00	SPY	ETF	226.15	226.16	226.15	226.16	1000.0
2017-01-05 05:52:00	SPY	ETF	226.28	226.28	226.28	226.28	200.0
2017-01-05 05:54:00	SPY	ETF	226.34	226.37	226.34	226.37	305.0
2017-01-05 05:55:00	SPY	ETF	226.4	226.42	226.4	226.42	1107.0
2017-01-05 06:07:00	SPY	ETF	226.4	226.4	226.4	226.4	341.0
2017-01-05 06:08:00	SPY	ETF	226.4	226.4	226.4	226.4	500.0
2017-01-05 06:11:00	SPY	ETF	226.38	226.38	226.38	226.38	400.0
2017-01-05 06:12:00	SPY	ETF	226.38	226.38	226.38	226.38	400.0
2017-01-05 06:13:00	SPY	ETF	226.38	226.38	226.35	226.36	4203.0
2017-01-05 06:16:00	SPY	ETF	226.38	226.38	226.38	226.38	3000.0
2017-01-05 06:17:00	SPY	ETF	226.38	226.38	226.38	226.38	3000.0
2017-01-05 06:20:00	SPY	ETF	226.35	226.35	226.35	226.35	301.0

> showing 50 of 159,867 rows — these rows as CSV

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