PREVIEW / etf_5min / 2017-10-27

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-10-27.parquet
  size:    1.3 MB
  rows:    55,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
2017-10-27 04:00:00	SPY	ETF	256.35	256.56	256.35	256.56	5749.0
2017-10-27 04:05:00	SPY	ETF	256.35	256.35	256.35	256.35	300.0
2017-10-27 04:20:00	SPY	ETF	256.34	256.4	256.34	256.4	500.0
2017-10-27 04:25:00	SPY	ETF	256.36	256.36	256.36	256.36	195.0
2017-10-27 04:50:00	SPY	ETF	256.44	256.44	256.44	256.44	3000.0
2017-10-27 04:55:00	SPY	ETF	256.48	256.48	256.48	256.48	2500.0
2017-10-27 05:00:00	SPY	ETF	256.53	256.53	256.53	256.53	100.0
2017-10-27 05:05:00	SPY	ETF	256.6	256.6	256.6	256.6	500.0
2017-10-27 05:10:00	SPY	ETF	256.62	256.62	256.62	256.62	100.0
2017-10-27 05:35:00	SPY	ETF	256.65	256.76	256.65	256.73	1410.0
2017-10-27 05:50:00	SPY	ETF	256.7	256.7	256.7	256.7	100.0
2017-10-27 05:55:00	SPY	ETF	256.67	256.67	256.67	256.67	7000.0
2017-10-27 06:00:00	SPY	ETF	256.7	256.7	256.7	256.7	825.0
2017-10-27 06:15:00	SPY	ETF	256.62	256.62	256.62	256.62	100.0
2017-10-27 06:20:00	SPY	ETF	256.58	256.58	256.58	256.58	800.0
2017-10-27 06:30:00	SPY	ETF	256.54	256.54	256.54	256.54	202.0
2017-10-27 06:40:00	SPY	ETF	256.55	256.55	256.55	256.55	100.0
2017-10-27 06:45:00	SPY	ETF	256.6	256.6	256.6	256.6	100.0
2017-10-27 06:50:00	SPY	ETF	256.6	256.62	256.59	256.62	1850.0
2017-10-27 06:55:00	SPY	ETF	256.62	256.65	256.62	256.65	2015.0
2017-10-27 07:00:00	SPY	ETF	256.62	256.69	256.62	256.67	28865.0
2017-10-27 07:05:00	SPY	ETF	256.67	256.67	256.65	256.65	1200.0
2017-10-27 07:10:00	SPY	ETF	256.67	256.67	256.65	256.67	6100.0
2017-10-27 07:15:00	SPY	ETF	256.62	256.63	256.62	256.63	450.0
2017-10-27 07:20:00	SPY	ETF	256.6	256.6	256.6	256.6	850.0
2017-10-27 07:25:00	SPY	ETF	256.59	256.6	256.57	256.57	1550.0
2017-10-27 07:30:00	SPY	ETF	256.58	256.59	256.57	256.57	25551.0
2017-10-27 07:35:00	SPY	ETF	256.55	256.57	256.55	256.57	742.0
2017-10-27 07:40:00	SPY	ETF	256.55	256.59	256.55	256.59	7279.0
2017-10-27 07:45:00	SPY	ETF	256.61	256.62	256.56	256.59	16501.0
2017-10-27 07:50:00	SPY	ETF	256.57	256.57	256.56	256.56	2300.0
2017-10-27 07:55:00	SPY	ETF	256.56	256.58	256.55	256.56	33947.0
2017-10-27 08:00:00	SPY	ETF	256.57	256.62	256.55	256.57	63228.0
2017-10-27 08:05:00	SPY	ETF	256.58	256.59	256.17	256.52	98700.0
2017-10-27 08:10:00	SPY	ETF	256.54	256.55	256.5	256.5	23614.0
2017-10-27 08:15:00	SPY	ETF	256.48	256.5	256.48	256.5	32714.0
2017-10-27 08:20:00	SPY	ETF	256.5	256.51	256.43	256.43	18042.0
2017-10-27 08:25:00	SPY	ETF	256.45	256.46	256.44	256.44	11935.0
2017-10-27 08:30:00	SPY	ETF	256.46	256.56	256.38	256.39	75666.0
2017-10-27 08:35:00	SPY	ETF	256.39	256.49	256.39	256.48	23720.0
2017-10-27 08:40:00	SPY	ETF	256.48	256.52	256.48	256.52	27496.0
2017-10-27 08:45:00	SPY	ETF	256.53	256.55	256.45	256.53	37555.0
2017-10-27 08:50:00	SPY	ETF	256.53	256.56	256.51	256.53	37607.0
2017-10-27 08:55:00	SPY	ETF	256.52	256.54	256.5	256.5	31877.0
2017-10-27 09:00:00	SPY	ETF	256.5	256.58	256.49	256.56	93204.0
2017-10-27 09:05:00	SPY	ETF	256.56	256.56	256.53	256.54	10611.0
2017-10-27 09:10:00	SPY	ETF	256.55	256.56	256.54	256.56	11119.0
2017-10-27 09:15:00	SPY	ETF	256.56	256.57	256.55	256.55	6655.0
2017-10-27 09:20:00	SPY	ETF	256.55	256.65	256.55	256.61	66776.0
2017-10-27 09:25:00	SPY	ETF	256.62	256.64	256.43	256.52	162457.0

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

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