PREVIEW / etf_5min / 2016-06-29

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-06-29.parquet
  size:    1.2 MB
  rows:    53,880

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
2016-06-29 04:00:00	SPY	ETF	203.82	203.99	203.82	203.99	6379.0
2016-06-29 04:05:00	SPY	ETF	204.0	204.05	204.0	204.05	1251.0
2016-06-29 04:10:00	SPY	ETF	204.04	204.15	204.04	204.15	2279.0
2016-06-29 04:15:00	SPY	ETF	204.12	204.15	204.04	204.04	12252.0
2016-06-29 04:20:00	SPY	ETF	204.17	204.24	204.17	204.22	3267.0
2016-06-29 04:25:00	SPY	ETF	204.1	204.1	204.06	204.08	2578.0
2016-06-29 04:30:00	SPY	ETF	204.12	204.12	203.99	203.99	511.0
2016-06-29 04:35:00	SPY	ETF	203.98	204.07	203.94	204.07	1407.0
2016-06-29 04:40:00	SPY	ETF	204.13	204.21	204.13	204.2	9749.0
2016-06-29 04:45:00	SPY	ETF	204.26	204.34	204.23	204.34	23024.0
2016-06-29 04:50:00	SPY	ETF	204.33	204.33	204.29	204.29	905.0
2016-06-29 04:55:00	SPY	ETF	204.19	204.2	204.19	204.2	2053.0
2016-06-29 05:00:00	SPY	ETF	204.3	204.3	204.17	204.17	902.0
2016-06-29 05:05:00	SPY	ETF	204.24	204.27	204.2	204.2	1278.0
2016-06-29 05:15:00	SPY	ETF	204.17	204.17	204.17	204.17	304.0
2016-06-29 05:20:00	SPY	ETF	204.16	204.2	204.16	204.2	781.0
2016-06-29 05:25:00	SPY	ETF	204.25	204.25	204.19	204.22	1397.0
2016-06-29 05:30:00	SPY	ETF	204.24	204.3	204.24	204.26	12007.0
2016-06-29 05:35:00	SPY	ETF	204.24	204.24	204.16	204.22	11521.0
2016-06-29 05:40:00	SPY	ETF	204.2	204.32	204.2	204.32	1933.0
2016-06-29 05:45:00	SPY	ETF	204.38	204.38	204.35	204.35	862.0
2016-06-29 05:50:00	SPY	ETF	204.36	204.36	204.36	204.36	100.0
2016-06-29 05:55:00	SPY	ETF	204.32	204.32	204.3	204.3	2221.0
2016-06-29 06:00:00	SPY	ETF	204.4	204.8	204.4	204.76	22635.0
2016-06-29 06:05:00	SPY	ETF	204.79	204.79	204.69	204.73	10824.0
2016-06-29 06:10:00	SPY	ETF	204.7	204.7	204.59	204.59	4145.0
2016-06-29 06:15:00	SPY	ETF	204.62	204.75	204.62	204.75	2827.0
2016-06-29 06:20:00	SPY	ETF	204.72	204.8	204.72	204.74	12294.0
2016-06-29 06:25:00	SPY	ETF	204.74	204.75	204.7	204.7	4241.0
2016-06-29 06:30:00	SPY	ETF	204.7	204.73	204.62	204.62	10883.0
2016-06-29 06:35:00	SPY	ETF	204.6	204.64	204.59	204.59	11766.0
2016-06-29 06:40:00	SPY	ETF	204.63	204.63	204.54	204.54	32456.0
2016-06-29 06:45:00	SPY	ETF	204.55	204.56	204.51	204.51	1912.0
2016-06-29 06:50:00	SPY	ETF	204.47	204.47	204.47	204.47	262.0
2016-06-29 06:55:00	SPY	ETF	204.47	204.57	204.47	204.52	4108.0
2016-06-29 07:00:00	SPY	ETF	204.53	204.6	204.5	204.6	15603.0
2016-06-29 07:05:00	SPY	ETF	204.59	204.65	204.59	204.64	44948.0
2016-06-29 07:10:00	SPY	ETF	204.65	204.67	204.63	204.67	19801.0
2016-06-29 07:15:00	SPY	ETF	204.61	204.64	204.33	204.33	24793.0
2016-06-29 07:20:00	SPY	ETF	204.33	204.42	204.29	204.42	32428.0
2016-06-29 07:25:00	SPY	ETF	204.41	204.44	204.35	204.35	26000.0
2016-06-29 07:30:00	SPY	ETF	204.36	204.49	204.36	204.41	89278.0
2016-06-29 07:35:00	SPY	ETF	204.39	204.39	204.27	204.29	32839.0
2016-06-29 07:40:00	SPY	ETF	204.3	204.3	204.24	204.29	30686.0
2016-06-29 07:45:00	SPY	ETF	204.29	204.44	204.29	204.35	40844.0
2016-06-29 07:50:00	SPY	ETF	204.35	204.54	204.3	204.5	86592.0
2016-06-29 07:55:00	SPY	ETF	204.53	204.65	204.51	204.65	41374.0
2016-06-29 08:00:00	SPY	ETF	204.64	204.67	203.22	204.61	211283.0
2016-06-29 08:05:00	SPY	ETF	203.88	204.62	203.88	204.58	100575.0
2016-06-29 08:10:00	SPY	ETF	204.59	204.65	204.58	204.6	75501.0

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

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