PREVIEW / etf_5min / 2017-11-16

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-11-16.parquet
  size:    1.3 MB
  rows:    55,348

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-16 04:00:00	SPY	ETF	257.15	257.3	257.1	257.3	3962.0
2017-11-16 04:10:00	SPY	ETF	257.3	257.3	257.28	257.28	300.0
2017-11-16 04:15:00	SPY	ETF	257.24	257.43	257.24	257.43	1700.0
2017-11-16 04:20:00	SPY	ETF	257.42	257.56	257.42	257.47	850.0
2017-11-16 04:25:00	SPY	ETF	257.44	257.44	257.38	257.44	1525.0
2017-11-16 04:30:00	SPY	ETF	257.44	257.44	257.44	257.44	320.0
2017-11-16 04:35:00	SPY	ETF	257.46	257.57	257.46	257.57	1587.0
2017-11-16 04:40:00	SPY	ETF	257.53	257.53	257.53	257.53	325.0
2017-11-16 04:45:00	SPY	ETF	257.4	257.4	257.4	257.4	100.0
2017-11-16 04:50:00	SPY	ETF	257.42	257.45	257.42	257.45	33900.0
2017-11-16 04:55:00	SPY	ETF	257.45	257.45	257.45	257.45	300.0
2017-11-16 05:00:00	SPY	ETF	257.48	257.6	257.48	257.6	2578.0
2017-11-16 05:10:00	SPY	ETF	257.62	257.62	257.6	257.6	300.0
2017-11-16 05:20:00	SPY	ETF	257.61	257.61	257.61	257.61	100.0
2017-11-16 05:30:00	SPY	ETF	257.51	257.53	257.48	257.48	1400.0
2017-11-16 05:35:00	SPY	ETF	257.45	257.45	257.45	257.45	800.0
2017-11-16 05:40:00	SPY	ETF	257.5	257.5	257.48	257.48	3217.0
2017-11-16 05:45:00	SPY	ETF	257.5	257.5	257.41	257.41	2215.0
2017-11-16 05:50:00	SPY	ETF	257.47	257.47	257.44	257.45	2100.0
2017-11-16 05:55:00	SPY	ETF	257.47	257.48	257.47	257.48	5200.0
2017-11-16 06:00:00	SPY	ETF	257.46	257.46	257.4	257.44	5301.0
2017-11-16 06:05:00	SPY	ETF	257.45	257.45	257.4	257.4	1600.0
2017-11-16 06:10:00	SPY	ETF	257.43	257.43	257.43	257.43	250.0
2017-11-16 06:15:00	SPY	ETF	257.42	257.5	257.42	257.5	1100.0
2017-11-16 06:20:00	SPY	ETF	257.48	257.48	257.41	257.45	4900.0
2017-11-16 06:25:00	SPY	ETF	257.38	257.38	257.38	257.38	1000.0
2017-11-16 06:30:00	SPY	ETF	257.44	257.47	257.44	257.46	1600.0
2017-11-16 06:35:00	SPY	ETF	257.47	257.47	257.45	257.45	545.0
2017-11-16 06:40:00	SPY	ETF	257.42	257.42	257.42	257.42	200.0
2017-11-16 06:45:00	SPY	ETF	257.37	257.37	257.35	257.35	1613.0
2017-11-16 06:50:00	SPY	ETF	257.4	257.41	257.4	257.41	1000.0
2017-11-16 06:55:00	SPY	ETF	257.36	257.36	257.36	257.36	600.0
2017-11-16 07:00:00	SPY	ETF	257.39	257.42	257.38	257.41	45968.0
2017-11-16 07:05:00	SPY	ETF	257.38	257.4	257.34	257.37	64230.0
2017-11-16 07:10:00	SPY	ETF	257.4	257.49	257.4	257.49	64947.0
2017-11-16 07:15:00	SPY	ETF	257.49	257.55	257.47	257.47	24500.0
2017-11-16 07:20:00	SPY	ETF	257.48	257.5	257.46	257.48	3500.0
2017-11-16 07:25:00	SPY	ETF	257.48	257.48	257.45	257.45	6658.0
2017-11-16 07:30:00	SPY	ETF	257.46	257.46	257.44	257.44	22550.0
2017-11-16 07:35:00	SPY	ETF	257.45	257.5	257.44	257.49	15990.0
2017-11-16 07:40:00	SPY	ETF	257.45	257.46	257.45	257.46	691.0
2017-11-16 07:45:00	SPY	ETF	257.41	257.46	257.4	257.46	9309.0
2017-11-16 07:50:00	SPY	ETF	257.45	257.48	257.42	257.42	7600.0
2017-11-16 07:55:00	SPY	ETF	257.48	257.51	257.47	257.48	16476.0
2017-11-16 08:00:00	SPY	ETF	257.42	257.48	257.36	257.48	10166.0
2017-11-16 08:05:00	SPY	ETF	257.42	257.59	257.42	257.58	285429.0
2017-11-16 08:10:00	SPY	ETF	257.56	257.57	257.44	257.44	17310.0
2017-11-16 08:15:00	SPY	ETF	257.43	257.45	257.43	257.44	1450.0
2017-11-16 08:20:00	SPY	ETF	257.43	257.44	257.41	257.44	15248.0
2017-11-16 08:25:00	SPY	ETF	257.46	257.46	257.44	257.44	21970.0

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

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