PREVIEW / etf_5min / 2017-06-06

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-06-06.parquet
  size:    1.2 MB
  rows:    53,563

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-06-06 04:00:00	SPY	ETF	243.73	243.73	243.63	243.63	4693.0
2017-06-06 04:05:00	SPY	ETF	243.68	243.68	243.63	243.64	600.0
2017-06-06 04:10:00	SPY	ETF	243.63	243.63	243.63	243.63	1200.0
2017-06-06 04:15:00	SPY	ETF	243.51	243.53	243.51	243.53	40400.0
2017-06-06 04:20:00	SPY	ETF	243.52	243.52	243.5	243.5	460.0
2017-06-06 04:30:00	SPY	ETF	243.55	243.55	243.55	243.55	500.0
2017-06-06 04:35:00	SPY	ETF	243.6	243.6	243.6	243.6	300.0
2017-06-06 04:40:00	SPY	ETF	243.68	243.68	243.68	243.68	260.0
2017-06-06 04:50:00	SPY	ETF	243.69	243.69	243.69	243.69	300.0
2017-06-06 04:55:00	SPY	ETF	243.65	243.65	243.65	243.65	300.0
2017-06-06 05:00:00	SPY	ETF	243.65	243.67	243.59	243.59	1500.0
2017-06-06 05:10:00	SPY	ETF	243.6	243.6	243.55	243.55	1210.0
2017-06-06 05:30:00	SPY	ETF	243.6	243.6	243.6	243.6	300.0
2017-06-06 05:40:00	SPY	ETF	243.56	243.56	243.55	243.55	591.0
2017-06-06 05:45:00	SPY	ETF	243.6	243.6	243.6	243.6	400.0
2017-06-06 05:55:00	SPY	ETF	243.61	243.61	243.57	243.57	600.0
2017-06-06 06:10:00	SPY	ETF	243.52	243.55	243.52	243.52	800.0
2017-06-06 06:15:00	SPY	ETF	243.54	243.57	243.54	243.57	930.0
2017-06-06 06:25:00	SPY	ETF	243.5	243.5	243.5	243.5	200.0
2017-06-06 06:30:00	SPY	ETF	243.48	243.48	243.48	243.48	500.0
2017-06-06 06:35:00	SPY	ETF	243.44	243.44	243.43	243.43	400.0
2017-06-06 06:40:00	SPY	ETF	243.5	243.5	243.42	243.42	2100.0
2017-06-06 06:45:00	SPY	ETF	243.4	243.4	243.4	243.4	1035.0
2017-06-06 06:50:00	SPY	ETF	243.4	243.42	243.38	243.42	50600.0
2017-06-06 06:55:00	SPY	ETF	243.42	243.42	243.4	243.4	1200.0
2017-06-06 07:00:00	SPY	ETF	243.42	243.43	243.4	243.4	32179.0
2017-06-06 07:05:00	SPY	ETF	243.41	243.41	243.35	243.35	37069.0
2017-06-06 07:10:00	SPY	ETF	243.35	243.4	243.35	243.38	62503.0
2017-06-06 07:15:00	SPY	ETF	243.36	243.36	243.22	243.25	22843.0
2017-06-06 07:20:00	SPY	ETF	243.28	243.28	243.13	243.13	32661.0
2017-06-06 07:25:00	SPY	ETF	243.13	243.17	243.13	243.15	37250.0
2017-06-06 07:30:00	SPY	ETF	243.14	243.14	243.1	243.1	12378.0
2017-06-06 07:35:00	SPY	ETF	243.11	243.11	243.05	243.11	17222.0
2017-06-06 07:40:00	SPY	ETF	243.11	243.16	243.11	243.16	15969.0
2017-06-06 07:45:00	SPY	ETF	243.15	243.18	243.15	243.17	4438.0
2017-06-06 07:50:00	SPY	ETF	243.18	243.24	243.18	243.24	8938.0
2017-06-06 07:55:00	SPY	ETF	243.22	243.24	243.22	243.24	16985.0
2017-06-06 08:00:00	SPY	ETF	243.1	243.42	243.07	243.17	61374.0
2017-06-06 08:05:00	SPY	ETF	243.17	243.23	243.17	243.23	10834.0
2017-06-06 08:10:00	SPY	ETF	243.22	243.24	243.2	243.24	3764.0
2017-06-06 08:15:00	SPY	ETF	243.24	243.28	243.22	243.23	22241.0
2017-06-06 08:20:00	SPY	ETF	243.23	243.26	243.21	243.24	56062.0
2017-06-06 08:25:00	SPY	ETF	243.23	243.24	243.23	243.24	2200.0
2017-06-06 08:30:00	SPY	ETF	243.24	243.31	243.22	243.31	57215.0
2017-06-06 08:35:00	SPY	ETF	243.32	243.32	243.27	243.27	7496.0
2017-06-06 08:40:00	SPY	ETF	243.27	243.29	243.27	243.28	9600.0
2017-06-06 08:45:00	SPY	ETF	243.25	243.29	243.23	243.29	40243.0
2017-06-06 08:50:00	SPY	ETF	243.29	243.3	243.28	243.29	8000.0
2017-06-06 08:55:00	SPY	ETF	243.29	243.3	243.28	243.3	3876.0
2017-06-06 09:00:00	SPY	ETF	243.29	243.3	243.25	243.28	22231.0

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

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