PREVIEW / etf_5min / 2017-11-17

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-11-17.parquet
  size:    1.2 MB
  rows:    53,681

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-11-17 04:00:00	SPY	ETF	258.22	258.25	258.22	258.25	1254.0
2017-11-17 04:05:00	SPY	ETF	258.21	258.22	258.21	258.22	500.0
2017-11-17 04:10:00	SPY	ETF	258.21	258.23	258.15	258.23	1700.0
2017-11-17 04:15:00	SPY	ETF	258.2	258.2	258.14	258.14	350.0
2017-11-17 04:25:00	SPY	ETF	258.2	258.2	258.2	258.2	100.0
2017-11-17 04:30:00	SPY	ETF	258.2	258.2	258.2	258.2	300.0
2017-11-17 04:35:00	SPY	ETF	258.2	258.2	258.2	258.2	100.0
2017-11-17 04:40:00	SPY	ETF	258.21	258.22	258.21	258.22	400.0
2017-11-17 04:45:00	SPY	ETF	258.18	258.18	258.18	258.18	1000.0
2017-11-17 04:55:00	SPY	ETF	258.22	258.22	258.2	258.2	1000.0
2017-11-17 05:00:00	SPY	ETF	258.2	258.2	258.2	258.2	200.0
2017-11-17 05:05:00	SPY	ETF	258.2	258.2	258.2	258.2	100.0
2017-11-17 05:20:00	SPY	ETF	258.21	258.21	258.17	258.17	400.0
2017-11-17 05:25:00	SPY	ETF	258.15	258.15	258.15	258.15	300.0
2017-11-17 05:30:00	SPY	ETF	258.15	258.18	258.15	258.18	600.0
2017-11-17 05:35:00	SPY	ETF	258.21	258.21	258.21	258.21	100.0
2017-11-17 05:40:00	SPY	ETF	258.18	258.18	258.15	258.15	2050.0
2017-11-17 05:50:00	SPY	ETF	258.15	258.15	258.04	258.04	3650.0
2017-11-17 05:55:00	SPY	ETF	258.28	258.31	258.28	258.3	3100.0
2017-11-17 06:00:00	SPY	ETF	258.28	258.28	258.28	258.28	800.0
2017-11-17 06:05:00	SPY	ETF	258.28	258.28	258.25	258.26	1500.0
2017-11-17 06:10:00	SPY	ETF	258.31	258.31	258.29	258.29	2900.0
2017-11-17 06:15:00	SPY	ETF	258.27	258.27	258.27	258.27	1000.0
2017-11-17 06:20:00	SPY	ETF	258.3	258.3	258.3	258.3	1000.0
2017-11-17 06:30:00	SPY	ETF	258.32	258.35	258.32	258.34	1150.0
2017-11-17 06:35:00	SPY	ETF	258.34	258.34	258.34	258.34	200.0
2017-11-17 06:40:00	SPY	ETF	258.39	258.4	258.39	258.4	1300.0
2017-11-17 06:45:00	SPY	ETF	258.4	258.44	258.4	258.42	3420.0
2017-11-17 06:55:00	SPY	ETF	258.44	258.45	258.44	258.45	10000.0
2017-11-17 07:00:00	SPY	ETF	258.45	258.49	258.43	258.45	13390.0
2017-11-17 07:05:00	SPY	ETF	258.47	258.55	258.47	258.51	37500.0
2017-11-17 07:10:00	SPY	ETF	258.51	258.53	258.51	258.53	2150.0
2017-11-17 07:15:00	SPY	ETF	258.51	258.55	258.5	258.54	5269.0
2017-11-17 07:20:00	SPY	ETF	258.54	258.55	258.53	258.53	2000.0
2017-11-17 07:25:00	SPY	ETF	258.53	258.53	258.52	258.52	10620.0
2017-11-17 07:30:00	SPY	ETF	258.5	258.51	258.5	258.5	18501.0
2017-11-17 07:35:00	SPY	ETF	258.51	258.51	258.5	258.51	8420.0
2017-11-17 07:40:00	SPY	ETF	258.51	258.52	258.49	258.5	32132.0
2017-11-17 07:45:00	SPY	ETF	258.5	258.61	258.5	258.61	6776.0
2017-11-17 07:50:00	SPY	ETF	258.61	258.66	258.6	258.66	17800.0
2017-11-17 07:55:00	SPY	ETF	258.63	258.65	258.62	258.64	7460.0
2017-11-17 08:00:00	SPY	ETF	258.51	258.62	258.48	258.54	28762.0
2017-11-17 08:05:00	SPY	ETF	258.54	258.6	258.54	258.6	10698.0
2017-11-17 08:10:00	SPY	ETF	258.6	258.62	258.57	258.57	6625.0
2017-11-17 08:15:00	SPY	ETF	258.58	258.58	258.56	258.57	46600.0
2017-11-17 08:20:00	SPY	ETF	258.58	258.59	258.56	258.58	146504.0
2017-11-17 08:25:00	SPY	ETF	258.57	258.57	258.5	258.54	17880.0
2017-11-17 08:30:00	SPY	ETF	258.55	258.55	258.53	258.55	15490.0
2017-11-17 08:35:00	SPY	ETF	258.53	258.54	258.49	258.5	20348.0
2017-11-17 08:40:00	SPY	ETF	258.49	258.5	258.45	258.45	39506.0

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

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