PREVIEW / etf_5min / 2017-03-27

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-27.parquet
  size:    1.3 MB
  rows:    55,116

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-27 04:00:00	SPY	ETF	232.1	232.14	231.82	231.96	14398.0
2017-03-27 04:05:00	SPY	ETF	232.04	232.04	232.04	232.04	475.0
2017-03-27 04:10:00	SPY	ETF	232.03	232.03	231.95	231.98	2578.0
2017-03-27 04:15:00	SPY	ETF	231.98	232.09	231.98	232.09	623.0
2017-03-27 04:20:00	SPY	ETF	232.18	232.3	232.18	232.3	2460.0
2017-03-27 04:25:00	SPY	ETF	232.3	232.3	232.28	232.28	1898.0
2017-03-27 04:30:00	SPY	ETF	232.25	232.25	232.25	232.25	102.0
2017-03-27 04:35:00	SPY	ETF	232.34	232.34	232.34	232.34	405.0
2017-03-27 04:40:00	SPY	ETF	232.32	232.33	232.32	232.32	5484.0
2017-03-27 04:45:00	SPY	ETF	232.33	232.35	232.33	232.35	1114.0
2017-03-27 04:50:00	SPY	ETF	232.32	232.32	232.29	232.29	649.0
2017-03-27 04:55:00	SPY	ETF	232.28	232.28	232.28	232.28	100.0
2017-03-27 05:00:00	SPY	ETF	232.25	232.25	232.25	232.25	400.0
2017-03-27 05:05:00	SPY	ETF	232.28	232.28	232.28	232.28	467.0
2017-03-27 05:25:00	SPY	ETF	232.4	232.44	232.4	232.44	1721.0
2017-03-27 05:30:00	SPY	ETF	232.42	232.42	232.42	232.42	150.0
2017-03-27 05:35:00	SPY	ETF	232.41	232.41	232.41	232.41	100.0
2017-03-27 05:40:00	SPY	ETF	232.4	232.4	232.4	232.4	211.0
2017-03-27 05:50:00	SPY	ETF	232.34	232.34	232.27	232.33	8900.0
2017-03-27 05:55:00	SPY	ETF	232.3	232.3	232.25	232.25	630.0
2017-03-27 06:00:00	SPY	ETF	232.27	232.27	232.2	232.2	2374.0
2017-03-27 06:05:00	SPY	ETF	232.2	232.22	232.16	232.22	6102.0
2017-03-27 06:10:00	SPY	ETF	232.23	232.23	232.21	232.21	497.0
2017-03-27 06:15:00	SPY	ETF	232.24	232.24	232.17	232.24	3141.0
2017-03-27 06:20:00	SPY	ETF	232.22	232.24	232.22	232.24	600.0
2017-03-27 06:25:00	SPY	ETF	232.26	232.26	232.26	232.26	700.0
2017-03-27 06:30:00	SPY	ETF	232.27	232.27	232.25	232.25	500.0
2017-03-27 06:35:00	SPY	ETF	232.28	232.28	232.26	232.26	201.0
2017-03-27 06:40:00	SPY	ETF	232.27	232.27	232.23	232.23	890.0
2017-03-27 06:45:00	SPY	ETF	232.25	232.3	232.25	232.3	10754.0
2017-03-27 06:50:00	SPY	ETF	232.35	232.42	232.35	232.4	5064.0
2017-03-27 06:55:00	SPY	ETF	232.41	232.41	232.32	232.36	12792.0
2017-03-27 07:00:00	SPY	ETF	232.42	232.5	232.39	232.5	12595.0
2017-03-27 07:05:00	SPY	ETF	232.49	232.52	232.45	232.45	31905.0
2017-03-27 07:10:00	SPY	ETF	232.48	232.5	232.45	232.48	30116.0
2017-03-27 07:15:00	SPY	ETF	232.48	232.49	232.42	232.46	8534.0
2017-03-27 07:20:00	SPY	ETF	232.45	232.51	232.43	232.43	20553.0
2017-03-27 07:25:00	SPY	ETF	232.43	232.47	232.38	232.42	22972.0
2017-03-27 07:30:00	SPY	ETF	232.41	232.46	232.4	232.45	21225.0
2017-03-27 07:35:00	SPY	ETF	232.43	232.46	232.4	232.4	30974.0
2017-03-27 07:40:00	SPY	ETF	232.38	232.46	232.37	232.46	31520.0
2017-03-27 07:45:00	SPY	ETF	232.49	232.55	232.49	232.54	18302.0
2017-03-27 07:50:00	SPY	ETF	232.51	232.51	232.41	232.44	7220.0
2017-03-27 07:55:00	SPY	ETF	232.42	232.45	232.3	232.34	56991.0
2017-03-27 08:00:00	SPY	ETF	232.34	232.52	232.3	232.42	302577.0
2017-03-27 08:05:00	SPY	ETF	232.41	232.41	232.19	232.21	196376.0
2017-03-27 08:10:00	SPY	ETF	232.21	232.24	232.12	232.18	213131.0
2017-03-27 08:15:00	SPY	ETF	232.24	232.37	232.24	232.34	35856.0
2017-03-27 08:20:00	SPY	ETF	232.33	232.36	232.26	232.29	15456.0
2017-03-27 08:25:00	SPY	ETF	232.28	232.3	232.18	232.18	43571.0

> showing 50 of 55,116 rows — these rows as CSV

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