PREVIEW / etf_5min / 2017-05-22

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-22.parquet
  size:    1.2 MB
  rows:    52,552

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-05-22 04:00:00	SPY	ETF	238.37	238.48	238.32	238.47	3015.0
2017-05-22 04:05:00	SPY	ETF	238.46	238.46	238.36	238.44	4308.0
2017-05-22 04:10:00	SPY	ETF	238.44	238.44	238.44	238.44	300.0
2017-05-22 04:15:00	SPY	ETF	238.42	238.46	238.42	238.46	303.0
2017-05-22 04:20:00	SPY	ETF	238.42	238.42	238.42	238.42	1901.0
2017-05-22 04:30:00	SPY	ETF	238.57	238.57	238.54	238.57	7010.0
2017-05-22 04:35:00	SPY	ETF	238.56	238.56	238.56	238.56	200.0
2017-05-22 04:45:00	SPY	ETF	238.47	238.47	238.47	238.47	201.0
2017-05-22 05:05:00	SPY	ETF	238.49	238.49	238.49	238.49	100.0
2017-05-22 05:15:00	SPY	ETF	238.51	238.51	238.51	238.51	205.0
2017-05-22 05:20:00	SPY	ETF	238.42	238.42	238.38	238.38	9007.0
2017-05-22 05:25:00	SPY	ETF	238.37	238.38	238.37	238.38	1204.0
2017-05-22 05:30:00	SPY	ETF	238.34	238.34	238.26	238.26	954.0
2017-05-22 05:35:00	SPY	ETF	238.3	238.3	238.24	238.24	10505.0
2017-05-22 05:50:00	SPY	ETF	238.17	238.17	238.17	238.17	500.0
2017-05-22 05:55:00	SPY	ETF	238.22	238.32	238.22	238.32	2704.0
2017-05-22 06:00:00	SPY	ETF	238.32	238.37	238.3	238.37	2767.0
2017-05-22 06:05:00	SPY	ETF	238.41	238.44	238.4	238.44	8801.0
2017-05-22 06:15:00	SPY	ETF	238.38	238.39	238.38	238.39	11802.0
2017-05-22 06:20:00	SPY	ETF	238.39	238.4	238.39	238.4	2200.0
2017-05-22 06:25:00	SPY	ETF	238.4	238.4	238.37	238.37	1201.0
2017-05-22 06:30:00	SPY	ETF	238.35	238.36	238.29	238.29	1903.0
2017-05-22 06:35:00	SPY	ETF	238.26	238.32	238.26	238.32	753.0
2017-05-22 06:40:00	SPY	ETF	238.42	238.45	238.4	238.45	24524.0
2017-05-22 06:45:00	SPY	ETF	238.45	238.46	238.45	238.46	7000.0
2017-05-22 06:50:00	SPY	ETF	238.45	238.46	238.45	238.46	300.0
2017-05-22 06:55:00	SPY	ETF	238.45	238.52	238.45	238.5	24403.0
2017-05-22 07:00:00	SPY	ETF	238.47	238.55	238.45	238.55	8681.0
2017-05-22 07:05:00	SPY	ETF	238.54	238.54	238.54	238.54	2200.0
2017-05-22 07:10:00	SPY	ETF	238.55	238.55	238.47	238.51	30102.0
2017-05-22 07:15:00	SPY	ETF	238.51	238.55	238.5	238.54	12041.0
2017-05-22 07:20:00	SPY	ETF	238.54	238.55	238.53	238.55	41854.0
2017-05-22 07:25:00	SPY	ETF	238.53	238.55	238.53	238.55	4607.0
2017-05-22 07:30:00	SPY	ETF	238.54	238.55	238.5	238.55	19532.0
2017-05-22 07:35:00	SPY	ETF	238.55	238.65	238.55	238.61	12554.0
2017-05-22 07:40:00	SPY	ETF	238.61	238.66	238.61	238.62	45167.0
2017-05-22 07:45:00	SPY	ETF	238.62	238.62	238.6	238.61	11896.0
2017-05-22 07:50:00	SPY	ETF	238.61	238.61	238.58	238.58	2701.0
2017-05-22 07:55:00	SPY	ETF	238.58	238.63	238.58	238.63	21470.0
2017-05-22 08:00:00	SPY	ETF	238.63	238.66	238.5	238.65	65900.0
2017-05-22 08:05:00	SPY	ETF	238.65	238.66	238.6	238.6	26486.0
2017-05-22 08:10:00	SPY	ETF	238.6	238.61	238.55	238.56	16162.0
2017-05-22 08:15:00	SPY	ETF	238.58	238.58	238.51	238.53	21242.0
2017-05-22 08:20:00	SPY	ETF	238.54	238.67	238.54	238.61	25651.0
2017-05-22 08:25:00	SPY	ETF	238.61	238.64	238.55	238.64	22345.0
2017-05-22 08:30:00	SPY	ETF	238.64	238.64	238.6	238.6	4121.0
2017-05-22 08:35:00	SPY	ETF	238.59	238.59	238.57	238.57	18412.0
2017-05-22 08:40:00	SPY	ETF	238.57	238.61	238.56	238.61	12655.0
2017-05-22 08:45:00	SPY	ETF	238.61	238.63	238.59	238.63	12373.0
2017-05-22 08:50:00	SPY	ETF	238.62	238.66	238.61	238.66	11566.0

> showing 50 of 52,552 rows — these rows as CSV

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