PREVIEW / etf_1min / 2017-04-21

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-04-21.parquet
  size:    2.6 MB
  rows:    137,366

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-04-21 04:00:00	SPY	ETF	235.45	235.45	235.45	235.45	154.0
2017-04-21 04:24:00	SPY	ETF	235.54	235.54	235.54	235.54	200.0
2017-04-21 04:31:00	SPY	ETF	235.44	235.44	235.44	235.44	401.0
2017-04-21 04:40:00	SPY	ETF	235.46	235.46	235.46	235.46	100.0
2017-04-21 04:44:00	SPY	ETF	235.43	235.43	235.43	235.43	500.0
2017-04-21 04:47:00	SPY	ETF	235.36	235.36	235.36	235.36	100.0
2017-04-21 04:50:00	SPY	ETF	235.45	235.45	235.45	235.45	100.0
2017-04-21 05:04:00	SPY	ETF	235.35	235.35	235.35	235.35	100.0
2017-04-21 05:10:00	SPY	ETF	235.32	235.32	235.32	235.32	203.0
2017-04-21 05:42:00	SPY	ETF	235.37	235.37	235.37	235.37	302.0
2017-04-21 05:43:00	SPY	ETF	235.36	235.36	235.36	235.36	1000.0
2017-04-21 05:51:00	SPY	ETF	235.47	235.47	235.47	235.47	102.0
2017-04-21 05:54:00	SPY	ETF	235.46	235.46	235.46	235.46	200.0
2017-04-21 06:03:00	SPY	ETF	235.46	235.46	235.45	235.45	200.0
2017-04-21 06:08:00	SPY	ETF	235.43	235.43	235.39	235.39	500.0
2017-04-21 06:19:00	SPY	ETF	235.42	235.42	235.42	235.42	200.0
2017-04-21 06:28:00	SPY	ETF	235.47	235.47	235.47	235.47	100.0
2017-04-21 06:31:00	SPY	ETF	235.4	235.4	235.39	235.39	200.0
2017-04-21 06:32:00	SPY	ETF	235.38	235.38	235.31	235.31	2153.0
2017-04-21 06:35:00	SPY	ETF	235.4	235.4	235.4	235.4	101.0
2017-04-21 06:47:00	SPY	ETF	235.4	235.4	235.4	235.4	2500.0
2017-04-21 06:54:00	SPY	ETF	235.4	235.4	235.4	235.4	100.0
2017-04-21 06:58:00	SPY	ETF	235.44	235.44	235.44	235.44	100.0
2017-04-21 07:03:00	SPY	ETF	235.48	235.49	235.48	235.49	302.0
2017-04-21 07:05:00	SPY	ETF	235.53	235.53	235.53	235.53	4050.0
2017-04-21 07:06:00	SPY	ETF	235.55	235.57	235.54	235.57	1721.0
2017-04-21 07:07:00	SPY	ETF	235.57	235.57	235.51	235.51	2387.0
2017-04-21 07:10:00	SPY	ETF	235.56	235.57	235.56	235.57	3500.0
2017-04-21 07:11:00	SPY	ETF	235.57	235.61	235.57	235.6	1201.0
2017-04-21 07:12:00	SPY	ETF	235.59	235.59	235.59	235.59	300.0
2017-04-21 07:13:00	SPY	ETF	235.58	235.58	235.57	235.57	800.0
2017-04-21 07:15:00	SPY	ETF	235.6	235.6	235.6	235.6	169.0
2017-04-21 07:16:00	SPY	ETF	235.59	235.59	235.58	235.58	338.0
2017-04-21 07:17:00	SPY	ETF	235.57	235.57	235.5	235.5	1285.0
2017-04-21 07:18:00	SPY	ETF	235.52	235.52	235.52	235.52	1769.0
2017-04-21 07:19:00	SPY	ETF	235.52	235.52	235.52	235.52	100.0
2017-04-21 07:20:00	SPY	ETF	235.57	235.57	235.55	235.55	607.0
2017-04-21 07:21:00	SPY	ETF	235.54	235.54	235.54	235.54	369.0
2017-04-21 07:22:00	SPY	ETF	235.55	235.55	235.53	235.53	508.0
2017-04-21 07:23:00	SPY	ETF	235.53	235.53	235.53	235.53	385.0
2017-04-21 07:24:00	SPY	ETF	235.52	235.52	235.52	235.52	769.0
2017-04-21 07:26:00	SPY	ETF	235.49	235.49	235.49	235.49	275.0
2017-04-21 07:28:00	SPY	ETF	235.55	235.55	235.53	235.53	838.0
2017-04-21 07:29:00	SPY	ETF	235.53	235.54	235.53	235.54	369.0
2017-04-21 07:32:00	SPY	ETF	235.54	235.54	235.54	235.54	201.0
2017-04-21 07:35:00	SPY	ETF	235.55	235.55	235.55	235.55	300.0
2017-04-21 07:37:00	SPY	ETF	235.52	235.52	235.52	235.52	102.0
2017-04-21 07:42:00	SPY	ETF	235.52	235.52	235.52	235.52	524.0
2017-04-21 07:43:00	SPY	ETF	235.52	235.52	235.51	235.51	543.0
2017-04-21 07:44:00	SPY	ETF	235.5	235.5	235.5	235.5	100.0

> showing 50 of 137,366 rows — these rows as CSV

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