PREVIEW / etf_5min / 2017-05-23

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-23.parquet
  size:    1.2 MB
  rows:    53,056

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-23 04:00:00	SPY	ETF	239.8	239.96	239.8	239.84	1730.0
2017-05-23 04:05:00	SPY	ETF	239.89	240.04	239.89	240.02	12309.0
2017-05-23 04:10:00	SPY	ETF	240.02	240.02	240.02	240.02	8100.0
2017-05-23 04:15:00	SPY	ETF	239.9	239.95	239.9	239.95	500.0
2017-05-23 04:20:00	SPY	ETF	239.95	239.95	239.95	239.95	100.0
2017-05-23 04:25:00	SPY	ETF	240.05	240.05	240.05	240.05	170.0
2017-05-23 04:35:00	SPY	ETF	239.9	239.92	239.89	239.9	500.0
2017-05-23 04:40:00	SPY	ETF	239.86	239.86	239.86	239.86	300.0
2017-05-23 04:50:00	SPY	ETF	239.86	239.87	239.86	239.87	500.0
2017-05-23 04:55:00	SPY	ETF	239.86	239.9	239.86	239.9	3100.0
2017-05-23 05:00:00	SPY	ETF	239.91	239.91	239.91	239.91	100.0
2017-05-23 05:05:00	SPY	ETF	239.91	239.91	239.86	239.86	3700.0
2017-05-23 05:10:00	SPY	ETF	239.89	239.9	239.88	239.88	1600.0
2017-05-23 05:15:00	SPY	ETF	239.89	239.89	239.86	239.86	400.0
2017-05-23 05:30:00	SPY	ETF	239.9	239.9	239.83	239.83	1150.0
2017-05-23 05:35:00	SPY	ETF	239.83	239.83	239.83	239.83	700.0
2017-05-23 05:40:00	SPY	ETF	239.83	239.83	239.83	239.83	200.0
2017-05-23 05:45:00	SPY	ETF	239.83	239.83	239.83	239.83	300.0
2017-05-23 05:50:00	SPY	ETF	239.78	239.78	239.76	239.76	540.0
2017-05-23 06:10:00	SPY	ETF	239.85	239.85	239.85	239.85	300.0
2017-05-23 06:20:00	SPY	ETF	239.8	239.8	239.8	239.8	600.0
2017-05-23 06:25:00	SPY	ETF	239.8	239.8	239.8	239.8	100.0
2017-05-23 06:30:00	SPY	ETF	239.83	239.85	239.83	239.85	5500.0
2017-05-23 06:40:00	SPY	ETF	239.87	239.87	239.87	239.87	800.0
2017-05-23 06:45:00	SPY	ETF	239.85	239.85	239.85	239.85	1000.0
2017-05-23 06:50:00	SPY	ETF	239.87	239.87	239.87	239.87	100.0
2017-05-23 06:55:00	SPY	ETF	239.87	239.9	239.83	239.9	53690.0
2017-05-23 07:00:00	SPY	ETF	239.9	239.9	239.85	239.87	43270.0
2017-05-23 07:05:00	SPY	ETF	239.87	239.88	239.87	239.87	2189.0
2017-05-23 07:10:00	SPY	ETF	239.87	239.9	239.87	239.88	7988.0
2017-05-23 07:15:00	SPY	ETF	239.87	239.94	239.87	239.9	23538.0
2017-05-23 07:20:00	SPY	ETF	239.93	239.94	239.93	239.93	2707.0
2017-05-23 07:25:00	SPY	ETF	239.93	240.01	239.93	240.01	11090.0
2017-05-23 07:30:00	SPY	ETF	240.0	240.01	239.95	239.95	49232.0
2017-05-23 07:35:00	SPY	ETF	239.94	239.96	239.94	239.96	10100.0
2017-05-23 07:40:00	SPY	ETF	239.96	240.05	239.96	240.02	42608.0
2017-05-23 07:45:00	SPY	ETF	240.02	240.06	240.02	240.03	111250.0
2017-05-23 07:50:00	SPY	ETF	240.03	240.03	239.95	239.95	13886.0
2017-05-23 07:55:00	SPY	ETF	239.95	239.95	239.92	239.92	24238.0
2017-05-23 08:00:00	SPY	ETF	239.92	240.03	239.88	239.88	46320.0
2017-05-23 08:05:00	SPY	ETF	239.88	239.91	239.85	239.91	12270.0
2017-05-23 08:10:00	SPY	ETF	239.91	239.93	239.91	239.93	8909.0
2017-05-23 08:15:00	SPY	ETF	239.92	239.92	239.85	239.86	27480.0
2017-05-23 08:20:00	SPY	ETF	239.87	239.91	239.87	239.91	3329.0
2017-05-23 08:25:00	SPY	ETF	239.92	239.95	239.91	239.95	6565.0
2017-05-23 08:30:00	SPY	ETF	239.95	239.95	239.91	239.92	5401.0
2017-05-23 08:35:00	SPY	ETF	239.93	239.95	239.93	239.95	5808.0
2017-05-23 08:40:00	SPY	ETF	239.94	239.97	239.93	239.96	14420.0
2017-05-23 08:45:00	SPY	ETF	239.96	239.96	239.91	239.94	13603.0
2017-05-23 08:50:00	SPY	ETF	239.93	239.93	239.89	239.9	31080.0

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

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