PREVIEW / etf_5min / 2017-12-19

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-12-19.parquet
  size:    1.3 MB
  rows:    57,874

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-12-19 04:00:00	SPY	ETF	268.51	268.51	268.41	268.41	2630.0
2017-12-19 04:05:00	SPY	ETF	268.55	268.55	268.54	268.54	13600.0
2017-12-19 04:30:00	SPY	ETF	268.57	268.57	268.57	268.57	200.0
2017-12-19 04:35:00	SPY	ETF	268.57	268.57	268.57	268.57	288.0
2017-12-19 04:45:00	SPY	ETF	268.46	268.46	268.46	268.46	6000.0
2017-12-19 04:50:00	SPY	ETF	268.46	268.46	268.46	268.46	2000.0
2017-12-19 05:00:00	SPY	ETF	268.46	268.46	268.46	268.46	4000.0
2017-12-19 05:10:00	SPY	ETF	268.45	268.45	268.45	268.45	500.0
2017-12-19 05:15:00	SPY	ETF	268.45	268.45	268.45	268.45	800.0
2017-12-19 05:35:00	SPY	ETF	268.46	268.46	268.46	268.46	4701.0
2017-12-19 05:40:00	SPY	ETF	268.49	268.49	268.49	268.49	1000.0
2017-12-19 05:45:00	SPY	ETF	268.46	268.46	268.46	268.46	300.0
2017-12-19 05:50:00	SPY	ETF	268.42	268.42	268.4	268.42	16500.0
2017-12-19 05:55:00	SPY	ETF	268.43	268.49	268.43	268.49	1501.0
2017-12-19 06:00:00	SPY	ETF	268.48	268.48	268.48	268.48	119.0
2017-12-19 06:05:00	SPY	ETF	268.42	268.42	268.42	268.42	1003.0
2017-12-19 06:10:00	SPY	ETF	268.41	268.41	268.41	268.41	300.0
2017-12-19 06:15:00	SPY	ETF	268.36	268.39	268.35	268.35	4865.0
2017-12-19 06:20:00	SPY	ETF	268.36	268.39	268.36	268.39	1000.0
2017-12-19 06:25:00	SPY	ETF	268.42	268.42	268.41	268.41	1006.0
2017-12-19 06:30:00	SPY	ETF	268.41	268.41	268.4	268.4	1900.0
2017-12-19 06:35:00	SPY	ETF	268.41	268.45	268.41	268.45	2002.0
2017-12-19 06:40:00	SPY	ETF	268.39	268.42	268.39	268.42	2503.0
2017-12-19 06:45:00	SPY	ETF	268.39	268.39	268.39	268.39	1100.0
2017-12-19 06:50:00	SPY	ETF	268.35	268.35	268.35	268.35	502.0
2017-12-19 06:55:00	SPY	ETF	268.39	268.39	268.39	268.39	500.0
2017-12-19 07:00:00	SPY	ETF	268.44	268.44	268.4	268.41	1009.0
2017-12-19 07:05:00	SPY	ETF	268.41	268.41	268.39	268.4	2823.0
2017-12-19 07:10:00	SPY	ETF	268.39	268.45	268.35	268.45	200502.0
2017-12-19 07:15:00	SPY	ETF	268.41	268.41	268.41	268.41	500.0
2017-12-19 07:20:00	SPY	ETF	268.44	268.44	268.38	268.38	4098.0
2017-12-19 07:25:00	SPY	ETF	268.43	268.43	268.38	268.39	3850.0
2017-12-19 07:30:00	SPY	ETF	268.39	268.39	268.38	268.38	2700.0
2017-12-19 07:35:00	SPY	ETF	268.42	268.42	268.41	268.41	1301.0
2017-12-19 07:40:00	SPY	ETF	268.41	268.44	268.38	268.44	12562.0
2017-12-19 07:45:00	SPY	ETF	268.45	268.48	268.45	268.48	2146.0
2017-12-19 07:50:00	SPY	ETF	268.49	268.5	268.49	268.5	11599.0
2017-12-19 07:55:00	SPY	ETF	268.52	268.52	268.49	268.5	25847.0
2017-12-19 08:00:00	SPY	ETF	268.48	268.54	268.38	268.54	37880.0
2017-12-19 08:05:00	SPY	ETF	268.54	268.55	268.54	268.55	8248.0
2017-12-19 08:10:00	SPY	ETF	268.55	268.56	268.54	268.55	46861.0
2017-12-19 08:15:00	SPY	ETF	268.55	268.56	268.55	268.56	3900.0
2017-12-19 08:20:00	SPY	ETF	268.56	268.57	268.54	268.57	6014.0
2017-12-19 08:25:00	SPY	ETF	268.54	268.54	268.5	268.54	4383.0
2017-12-19 08:30:00	SPY	ETF	268.53	268.58	268.51	268.56	2762.0
2017-12-19 08:35:00	SPY	ETF	268.57	268.57	268.49	268.5	54811.0
2017-12-19 08:40:00	SPY	ETF	268.51	268.51	268.48	268.51	20332.0
2017-12-19 08:45:00	SPY	ETF	268.51	268.52	268.47	268.5	18784.0
2017-12-19 08:50:00	SPY	ETF	268.49	268.51	268.49	268.5	7675.0
2017-12-19 08:55:00	SPY	ETF	268.49	268.52	268.45	268.47	26240.0

> showing 50 of 57,874 rows — these rows as CSV

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