PREVIEW / etf_1min / 2017-01-27

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-27.parquet
  size:    2.7 MB
  rows:    140,493

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-27 04:02:00	SPY	ETF	229.55	229.55	229.55	229.55	104.0
2017-01-27 04:04:00	SPY	ETF	229.49	229.49	229.49	229.49	301.0
2017-01-27 04:05:00	SPY	ETF	229.5	229.5	229.5	229.5	301.0
2017-01-27 04:15:00	SPY	ETF	229.42	229.42	229.42	229.42	1201.0
2017-01-27 04:17:00	SPY	ETF	229.45	229.45	229.45	229.45	1000.0
2017-01-27 04:19:00	SPY	ETF	229.45	229.45	229.45	229.45	301.0
2017-01-27 04:21:00	SPY	ETF	229.43	229.43	229.43	229.43	100.0
2017-01-27 04:22:00	SPY	ETF	229.45	229.46	229.45	229.46	1200.0
2017-01-27 04:26:00	SPY	ETF	229.46	229.46	229.46	229.46	301.0
2017-01-27 04:37:00	SPY	ETF	229.46	229.46	229.46	229.46	303.0
2017-01-27 04:46:00	SPY	ETF	229.39	229.39	229.39	229.39	203.0
2017-01-27 04:56:00	SPY	ETF	229.28	229.28	229.28	229.28	300.0
2017-01-27 05:01:00	SPY	ETF	229.27	229.27	229.27	229.27	153.0
2017-01-27 05:02:00	SPY	ETF	229.25	229.25	229.18	229.18	405.0
2017-01-27 05:03:00	SPY	ETF	229.26	229.26	229.26	229.26	300.0
2017-01-27 05:08:00	SPY	ETF	229.29	229.29	229.29	229.29	200.0
2017-01-27 05:10:00	SPY	ETF	229.28	229.28	229.28	229.28	100.0
2017-01-27 05:18:00	SPY	ETF	229.23	229.23	229.23	229.23	800.0
2017-01-27 05:24:00	SPY	ETF	229.28	229.28	229.28	229.28	301.0
2017-01-27 05:35:00	SPY	ETF	229.33	229.33	229.33	229.33	300.0
2017-01-27 05:36:00	SPY	ETF	229.33	229.33	229.33	229.33	300.0
2017-01-27 05:39:00	SPY	ETF	229.33	229.33	229.33	229.33	300.0
2017-01-27 05:43:00	SPY	ETF	229.36	229.36	229.36	229.36	1000.0
2017-01-27 05:44:00	SPY	ETF	229.38	229.38	229.38	229.38	1401.0
2017-01-27 05:45:00	SPY	ETF	229.36	229.36	229.36	229.36	900.0
2017-01-27 05:47:00	SPY	ETF	229.36	229.36	229.36	229.36	402.0
2017-01-27 05:51:00	SPY	ETF	229.34	229.34	229.34	229.34	200.0
2017-01-27 06:00:00	SPY	ETF	229.38	229.38	229.38	229.38	100.0
2017-01-27 06:01:00	SPY	ETF	229.38	229.38	229.38	229.38	100.0
2017-01-27 06:02:00	SPY	ETF	229.36	229.38	229.36	229.37	1101.0
2017-01-27 06:05:00	SPY	ETF	229.4	229.4	229.4	229.4	203.0
2017-01-27 06:06:00	SPY	ETF	229.4	229.46	229.4	229.46	1304.0
2017-01-27 06:10:00	SPY	ETF	229.41	229.41	229.41	229.41	100.0
2017-01-27 06:18:00	SPY	ETF	229.34	229.34	229.34	229.34	402.0
2017-01-27 06:22:00	SPY	ETF	229.36	229.38	229.36	229.38	401.0
2017-01-27 06:24:00	SPY	ETF	229.41	229.41	229.41	229.41	302.0
2017-01-27 06:34:00	SPY	ETF	229.44	229.44	229.44	229.44	301.0
2017-01-27 06:42:00	SPY	ETF	229.38	229.38	229.38	229.38	201.0
2017-01-27 06:46:00	SPY	ETF	229.36	229.36	229.36	229.36	300.0
2017-01-27 06:47:00	SPY	ETF	229.32	229.32	229.32	229.32	100.0
2017-01-27 06:53:00	SPY	ETF	229.36	229.36	229.36	229.36	300.0
2017-01-27 07:02:00	SPY	ETF	229.34	229.34	229.34	229.34	2000.0
2017-01-27 07:06:00	SPY	ETF	229.31	229.31	229.27	229.27	35000.0
2017-01-27 07:08:00	SPY	ETF	229.35	229.35	229.32	229.32	2502.0
2017-01-27 07:10:00	SPY	ETF	229.32	229.32	229.32	229.32	200.0
2017-01-27 07:11:00	SPY	ETF	229.38	229.38	229.38	229.38	301.0
2017-01-27 07:12:00	SPY	ETF	229.38	229.38	229.38	229.38	300.0
2017-01-27 07:13:00	SPY	ETF	229.37	229.37	229.37	229.37	500.0
2017-01-27 07:14:00	SPY	ETF	229.37	229.38	229.37	229.38	1400.0
2017-01-27 07:16:00	SPY	ETF	229.38	229.42	229.37	229.42	2170.0

> showing 50 of 140,493 rows — these rows as CSV

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