PREVIEW / etf_5min / 2017-03-23

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-23.parquet
  size:    1.2 MB
  rows:    53,160

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-03-23 04:00:00	SPY	ETF	234.25	234.25	234.25	234.25	100.0
2017-03-23 04:05:00	SPY	ETF	234.21	234.21	234.21	234.21	100.0
2017-03-23 04:20:00	SPY	ETF	234.15	234.15	234.15	234.15	403.0
2017-03-23 04:30:00	SPY	ETF	234.17	234.17	234.17	234.17	685.0
2017-03-23 04:35:00	SPY	ETF	234.0	234.0	234.0	234.0	2800.0
2017-03-23 04:40:00	SPY	ETF	234.16	234.16	234.13	234.13	550.0
2017-03-23 04:45:00	SPY	ETF	234.12	234.12	234.12	234.12	101.0
2017-03-23 05:00:00	SPY	ETF	234.12	234.14	234.12	234.14	1610.0
2017-03-23 05:10:00	SPY	ETF	234.09	234.17	234.09	234.17	14013.0
2017-03-23 05:15:00	SPY	ETF	234.22	234.24	234.18	234.18	5456.0
2017-03-23 05:20:00	SPY	ETF	234.28	234.35	234.28	234.35	743.0
2017-03-23 05:25:00	SPY	ETF	234.35	234.35	234.35	234.35	102.0
2017-03-23 05:30:00	SPY	ETF	234.37	234.38	234.37	234.38	3900.0
2017-03-23 05:40:00	SPY	ETF	234.3	234.3	234.3	234.3	1000.0
2017-03-23 05:55:00	SPY	ETF	234.2	234.2	234.2	234.2	2002.0
2017-03-23 06:05:00	SPY	ETF	234.29	234.29	234.29	234.29	200.0
2017-03-23 06:15:00	SPY	ETF	234.19	234.19	234.19	234.19	500.0
2017-03-23 06:20:00	SPY	ETF	234.17	234.17	234.17	234.17	100.0
2017-03-23 06:25:00	SPY	ETF	234.19	234.19	234.17	234.17	3152.0
2017-03-23 06:45:00	SPY	ETF	234.39	234.39	234.39	234.39	332.0
2017-03-23 06:50:00	SPY	ETF	234.4	234.42	234.4	234.42	3504.0
2017-03-23 06:55:00	SPY	ETF	234.46	234.5	234.46	234.5	2214.0
2017-03-23 07:00:00	SPY	ETF	234.51	234.57	234.51	234.56	648.0
2017-03-23 07:05:00	SPY	ETF	234.53	234.58	234.52	234.52	7214.0
2017-03-23 07:10:00	SPY	ETF	234.53	234.54	234.41	234.47	6206.0
2017-03-23 07:15:00	SPY	ETF	234.5	234.51	234.49	234.5	13400.0
2017-03-23 07:20:00	SPY	ETF	234.49	234.49	234.46	234.48	2257.0
2017-03-23 07:25:00	SPY	ETF	234.46	234.48	234.41	234.48	5062.0
2017-03-23 07:30:00	SPY	ETF	234.48	234.48	234.41	234.41	2203.0
2017-03-23 07:35:00	SPY	ETF	234.41	234.48	234.41	234.48	7691.0
2017-03-23 07:40:00	SPY	ETF	234.5	234.51	234.46	234.46	2732.0
2017-03-23 07:45:00	SPY	ETF	234.46	234.46	234.37	234.38	10405.0
2017-03-23 07:50:00	SPY	ETF	234.39	234.4	234.39	234.4	2702.0
2017-03-23 07:55:00	SPY	ETF	234.44	234.46	234.44	234.46	10800.0
2017-03-23 08:00:00	SPY	ETF	234.51	234.58	234.43	234.52	25065.0
2017-03-23 08:05:00	SPY	ETF	234.53	234.57	234.48	234.52	17621.0
2017-03-23 08:10:00	SPY	ETF	234.51	234.53	234.45	234.48	13527.0
2017-03-23 08:15:00	SPY	ETF	234.45	234.45	234.4	234.4	21588.0
2017-03-23 08:20:00	SPY	ETF	234.41	234.48	234.4	234.48	52382.0
2017-03-23 08:25:00	SPY	ETF	234.47	234.52	234.47	234.52	57434.0
2017-03-23 08:30:00	SPY	ETF	234.5	234.5	234.4	234.48	36869.0
2017-03-23 08:35:00	SPY	ETF	234.46	234.48	234.34	234.37	93610.0
2017-03-23 08:40:00	SPY	ETF	234.38	234.42	234.31	234.37	17665.0
2017-03-23 08:45:00	SPY	ETF	234.28	234.37	234.28	234.34	44563.0
2017-03-23 08:50:00	SPY	ETF	234.32	234.41	234.3	234.38	93899.0
2017-03-23 08:55:00	SPY	ETF	234.38	234.38	234.12	234.19	122781.0
2017-03-23 09:00:00	SPY	ETF	234.18	234.19	233.89	233.98	218613.0
2017-03-23 09:05:00	SPY	ETF	233.98	234.28	233.87	234.03	213454.0
2017-03-23 09:10:00	SPY	ETF	234.01	234.28	233.99	234.05	527069.0
2017-03-23 09:15:00	SPY	ETF	234.06	234.07	233.93	234.04	61245.0

> showing 50 of 53,160 rows — these rows as CSV

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