PREVIEW / etf_1min / 2017-04-05

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-04-05.parquet
  size:    2.9 MB
  rows:    150,622

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-05 04:03:00	SPY	ETF	235.24	235.24	235.24	235.24	175.0
2017-04-05 04:08:00	SPY	ETF	235.2	235.2	235.2	235.2	200.0
2017-04-05 04:27:00	SPY	ETF	235.32	235.32	235.32	235.32	500.0
2017-04-05 04:28:00	SPY	ETF	235.32	235.32	235.32	235.32	1300.0
2017-04-05 04:30:00	SPY	ETF	235.28	235.28	235.28	235.28	250.0
2017-04-05 04:34:00	SPY	ETF	235.27	235.27	235.25	235.25	703.0
2017-04-05 04:35:00	SPY	ETF	235.3	235.3	235.3	235.3	4002.0
2017-04-05 04:38:00	SPY	ETF	235.28	235.28	235.28	235.28	1100.0
2017-04-05 04:41:00	SPY	ETF	235.25	235.25	235.25	235.25	201.0
2017-04-05 04:43:00	SPY	ETF	235.2	235.2	235.2	235.2	303.0
2017-04-05 04:48:00	SPY	ETF	235.23	235.23	235.23	235.23	800.0
2017-04-05 05:04:00	SPY	ETF	235.34	235.34	235.34	235.34	200.0
2017-04-05 05:08:00	SPY	ETF	235.37	235.41	235.37	235.41	1902.0
2017-04-05 05:11:00	SPY	ETF	235.5	235.5	235.5	235.5	2503.0
2017-04-05 05:12:00	SPY	ETF	235.51	235.51	235.51	235.51	5000.0
2017-04-05 05:13:00	SPY	ETF	235.48	235.5	235.48	235.5	996.0
2017-04-05 05:15:00	SPY	ETF	235.51	235.51	235.51	235.51	300.0
2017-04-05 05:17:00	SPY	ETF	235.5	235.5	235.5	235.5	498.0
2017-04-05 05:18:00	SPY	ETF	235.52	235.52	235.52	235.52	201.0
2017-04-05 05:22:00	SPY	ETF	235.54	235.54	235.54	235.54	101.0
2017-04-05 05:26:00	SPY	ETF	235.52	235.52	235.52	235.52	8000.0
2017-04-05 05:30:00	SPY	ETF	235.51	235.51	235.51	235.51	400.0
2017-04-05 05:36:00	SPY	ETF	235.53	235.53	235.53	235.53	1200.0
2017-04-05 05:38:00	SPY	ETF	235.51	235.51	235.51	235.51	701.0
2017-04-05 05:52:00	SPY	ETF	235.47	235.47	235.47	235.47	103.0
2017-04-05 06:08:00	SPY	ETF	235.42	235.45	235.41	235.45	56301.0
2017-04-05 06:09:00	SPY	ETF	235.42	235.42	235.42	235.42	400.0
2017-04-05 06:10:00	SPY	ETF	235.45	235.45	235.45	235.45	7300.0
2017-04-05 06:15:00	SPY	ETF	235.45	235.45	235.45	235.45	300.0
2017-04-05 06:16:00	SPY	ETF	235.45	235.45	235.45	235.45	29702.0
2017-04-05 06:17:00	SPY	ETF	235.46	235.46	235.46	235.46	2500.0
2017-04-05 06:20:00	SPY	ETF	235.46	235.46	235.42	235.45	9602.0
2017-04-05 06:21:00	SPY	ETF	235.45	235.45	235.45	235.45	1200.0
2017-04-05 06:23:00	SPY	ETF	235.47	235.47	235.47	235.47	4800.0
2017-04-05 06:25:00	SPY	ETF	235.45	235.45	235.43	235.43	5701.0
2017-04-05 06:27:00	SPY	ETF	235.45	235.45	235.45	235.45	1197.0
2017-04-05 06:28:00	SPY	ETF	235.42	235.42	235.42	235.42	301.0
2017-04-05 06:33:00	SPY	ETF	235.44	235.44	235.44	235.44	500.0
2017-04-05 06:34:00	SPY	ETF	235.44	235.44	235.44	235.44	300.0
2017-04-05 06:37:00	SPY	ETF	235.44	235.44	235.4	235.4	506.0
2017-04-05 06:42:00	SPY	ETF	235.45	235.45	235.45	235.45	401.0
2017-04-05 06:45:00	SPY	ETF	235.5	235.5	235.5	235.5	1403.0
2017-04-05 06:50:00	SPY	ETF	235.54	235.54	235.54	235.54	201.0
2017-04-05 06:55:00	SPY	ETF	235.51	235.51	235.47	235.47	34101.0
2017-04-05 06:59:00	SPY	ETF	235.45	235.45	235.45	235.45	100.0
2017-04-05 07:00:00	SPY	ETF	235.45	235.46	235.45	235.46	4700.0
2017-04-05 07:02:00	SPY	ETF	235.45	235.45	235.42	235.42	5672.0
2017-04-05 07:03:00	SPY	ETF	235.4	235.4	235.4	235.4	300.0
2017-04-05 07:04:00	SPY	ETF	235.4	235.4	235.38	235.38	30572.0
2017-04-05 07:05:00	SPY	ETF	235.37	235.37	235.34	235.34	1470.0

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

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