PREVIEW / etf_5min / 2017-10-17

all etf 5-min files

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

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-17 04:10:00	SPY	ETF	255.22	255.26	255.22	255.26	1100.0
2017-10-17 04:15:00	SPY	ETF	255.22	255.22	255.22	255.22	400.0
2017-10-17 04:20:00	SPY	ETF	255.19	255.19	255.19	255.19	300.0
2017-10-17 04:30:00	SPY	ETF	255.25	255.25	255.25	255.25	100.0
2017-10-17 04:35:00	SPY	ETF	255.24	255.24	255.24	255.24	300.0
2017-10-17 04:45:00	SPY	ETF	255.27	255.27	255.25	255.25	700.0
2017-10-17 04:50:00	SPY	ETF	255.27	255.27	255.27	255.27	100.0
2017-10-17 04:55:00	SPY	ETF	255.27	255.27	255.24	255.24	700.0
2017-10-17 05:05:00	SPY	ETF	255.22	255.22	255.22	255.22	300.0
2017-10-17 05:10:00	SPY	ETF	255.22	255.22	255.22	255.22	600.0
2017-10-17 05:20:00	SPY	ETF	255.29	255.29	255.29	255.29	300.0
2017-10-17 05:30:00	SPY	ETF	255.32	255.32	255.32	255.32	500.0
2017-10-17 05:35:00	SPY	ETF	255.32	255.32	255.32	255.32	400.0
2017-10-17 05:40:00	SPY	ETF	255.32	255.32	255.32	255.32	120.0
2017-10-17 05:50:00	SPY	ETF	255.29	255.29	255.29	255.29	400.0
2017-10-17 06:00:00	SPY	ETF	255.32	255.32	255.29	255.29	220.0
2017-10-17 06:10:00	SPY	ETF	255.3	255.3	255.3	255.3	800.0
2017-10-17 06:15:00	SPY	ETF	255.3	255.3	255.27	255.27	300.0
2017-10-17 06:35:00	SPY	ETF	255.24	255.24	255.24	255.24	1320.0
2017-10-17 06:45:00	SPY	ETF	255.24	255.32	255.24	255.29	1684.0
2017-10-17 06:50:00	SPY	ETF	255.27	255.31	255.27	255.31	9400.0
2017-10-17 06:55:00	SPY	ETF	255.31	255.31	255.29	255.29	9300.0
2017-10-17 07:00:00	SPY	ETF	255.3	255.31	255.3	255.3	22360.0
2017-10-17 07:05:00	SPY	ETF	255.3	255.34	255.3	255.34	14104.0
2017-10-17 07:10:00	SPY	ETF	255.3	255.34	255.3	255.34	400.0
2017-10-17 07:15:00	SPY	ETF	255.32	255.34	255.29	255.29	17601.0
2017-10-17 07:20:00	SPY	ETF	255.29	255.29	255.29	255.29	300.0
2017-10-17 07:25:00	SPY	ETF	255.36	255.36	255.36	255.36	2200.0
2017-10-17 07:30:00	SPY	ETF	255.39	255.39	255.35	255.36	27203.0
2017-10-17 07:35:00	SPY	ETF	255.35	255.35	255.35	255.35	601.0
2017-10-17 07:40:00	SPY	ETF	255.36	255.38	255.36	255.38	3101.0
2017-10-17 07:45:00	SPY	ETF	255.36	255.36	255.34	255.35	19594.0
2017-10-17 07:50:00	SPY	ETF	255.36	255.36	255.35	255.35	5000.0
2017-10-17 07:55:00	SPY	ETF	255.36	255.36	255.36	255.36	200.0
2017-10-17 08:00:00	SPY	ETF	255.36	255.38	255.36	255.38	11475.0
2017-10-17 08:05:00	SPY	ETF	255.37	255.38	255.36	255.38	14407.0
2017-10-17 08:10:00	SPY	ETF	255.37	255.38	255.36	255.36	17350.0
2017-10-17 08:15:00	SPY	ETF	255.33	255.34	255.3	255.3	5864.0
2017-10-17 08:20:00	SPY	ETF	255.3	255.31	255.28	255.31	17348.0
2017-10-17 08:25:00	SPY	ETF	255.32	255.33	255.31	255.31	3852.0
2017-10-17 08:30:00	SPY	ETF	255.28	255.32	255.25	255.27	71642.0
2017-10-17 08:35:00	SPY	ETF	255.29	255.31	255.25	255.3	37132.0
2017-10-17 08:40:00	SPY	ETF	255.32	255.33	255.29	255.31	30411.0
2017-10-17 08:45:00	SPY	ETF	255.33	255.34	255.29	255.33	14720.0
2017-10-17 08:50:00	SPY	ETF	255.34	255.34	255.32	255.33	13800.0
2017-10-17 08:55:00	SPY	ETF	255.31	255.31	255.29	255.3	4502.0
2017-10-17 09:00:00	SPY	ETF	255.3	255.3	255.26	255.3	3801.0
2017-10-17 09:05:00	SPY	ETF	255.31	255.32	255.27	255.28	15754.0
2017-10-17 09:10:00	SPY	ETF	255.26	255.26	255.22	255.22	4206.0
2017-10-17 09:15:00	SPY	ETF	255.21	255.22	255.18	255.2	37526.0

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

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