PREVIEW / etf_5min / 2017-02-24

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-02-24.parquet
  size:    1.3 MB
  rows:    55,367

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-02-24 04:10:00	SPY	ETF	236.17	236.17	236.17	236.17	150.0
2017-02-24 04:30:00	SPY	ETF	236.15	236.15	236.15	236.15	100.0
2017-02-24 04:35:00	SPY	ETF	236.15	236.15	236.15	236.15	241.0
2017-02-24 04:40:00	SPY	ETF	236.2	236.2	236.2	236.2	100.0
2017-02-24 04:45:00	SPY	ETF	236.3	236.3	236.3	236.3	130.0
2017-02-24 05:10:00	SPY	ETF	236.22	236.22	236.22	236.22	953.0
2017-02-24 05:15:00	SPY	ETF	236.2	236.21	236.19	236.19	10201.0
2017-02-24 05:30:00	SPY	ETF	236.07	236.07	235.96	235.96	1243.0
2017-02-24 05:35:00	SPY	ETF	235.93	235.93	235.92	235.93	4201.0
2017-02-24 05:40:00	SPY	ETF	235.96	235.96	235.96	235.96	2000.0
2017-02-24 05:45:00	SPY	ETF	235.88	235.88	235.82	235.88	3270.0
2017-02-24 05:50:00	SPY	ETF	235.93	235.95	235.93	235.95	999.0
2017-02-24 05:55:00	SPY	ETF	235.94	235.98	235.93	235.98	1501.0
2017-02-24 06:00:00	SPY	ETF	235.95	235.95	235.95	235.95	202.0
2017-02-24 06:05:00	SPY	ETF	235.85	235.85	235.81	235.85	1455.0
2017-02-24 06:10:00	SPY	ETF	235.83	235.83	235.77	235.8	3031.0
2017-02-24 06:15:00	SPY	ETF	235.83	235.83	235.72	235.75	1706.0
2017-02-24 06:20:00	SPY	ETF	235.71	235.71	235.61	235.66	2738.0
2017-02-24 06:25:00	SPY	ETF	235.59	235.66	235.59	235.66	48853.0
2017-02-24 06:30:00	SPY	ETF	235.65	235.73	235.64	235.73	15804.0
2017-02-24 06:35:00	SPY	ETF	235.7	235.7	235.68	235.68	2004.0
2017-02-24 06:40:00	SPY	ETF	235.68	235.68	235.65	235.65	86606.0
2017-02-24 06:45:00	SPY	ETF	235.65	235.65	235.5	235.5	96852.0
2017-02-24 06:50:00	SPY	ETF	235.5	235.5	235.38	235.44	210417.0
2017-02-24 06:55:00	SPY	ETF	235.43	235.43	235.32	235.35	111037.0
2017-02-24 07:00:00	SPY	ETF	235.4	235.48	235.37	235.44	29988.0
2017-02-24 07:05:00	SPY	ETF	235.48	235.53	235.45	235.52	68583.0
2017-02-24 07:10:00	SPY	ETF	235.52	235.57	235.51	235.57	3072.0
2017-02-24 07:15:00	SPY	ETF	235.56	235.63	235.53	235.53	13670.0
2017-02-24 07:20:00	SPY	ETF	235.5	235.52	235.46	235.5	41208.0
2017-02-24 07:25:00	SPY	ETF	235.49	235.56	235.49	235.54	36701.0
2017-02-24 07:30:00	SPY	ETF	235.53	235.61	235.5	235.57	26289.0
2017-02-24 07:35:00	SPY	ETF	235.56	235.61	235.56	235.61	4542.0
2017-02-24 07:40:00	SPY	ETF	235.58	235.58	235.54	235.54	2949.0
2017-02-24 07:45:00	SPY	ETF	235.52	235.53	235.5	235.51	55002.0
2017-02-24 07:50:00	SPY	ETF	235.51	235.51	235.48	235.51	15301.0
2017-02-24 07:55:00	SPY	ETF	235.51	235.51	235.35	235.35	81642.0
2017-02-24 08:00:00	SPY	ETF	235.52	235.6	235.3503	235.44	132025.0
2017-02-24 08:05:00	SPY	ETF	235.45	235.47	235.4	235.45	37854.0
2017-02-24 08:10:00	SPY	ETF	235.45	235.49	235.37	235.38	31843.0
2017-02-24 08:15:00	SPY	ETF	235.38	235.4	235.31	235.4	38524.0
2017-02-24 08:20:00	SPY	ETF	235.38	235.41	235.32	235.39	191854.0
2017-02-24 08:25:00	SPY	ETF	235.4	235.46	235.39	235.44	91519.0
2017-02-24 08:30:00	SPY	ETF	235.45	235.53	235.45	235.5	89210.0
2017-02-24 08:35:00	SPY	ETF	235.52	235.53	235.47	235.47	18769.0
2017-02-24 08:40:00	SPY	ETF	235.5	235.54	235.47	235.54	46321.0
2017-02-24 08:45:00	SPY	ETF	235.53	235.53	235.4	235.4	32341.0
2017-02-24 08:50:00	SPY	ETF	235.4	235.48	235.35	235.47	39004.0
2017-02-24 08:55:00	SPY	ETF	235.47	235.47	235.38	235.4	54105.0
2017-02-24 09:00:00	SPY	ETF	235.41	235.44	235.21	235.31	231132.0

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

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