PREVIEW / etf_5min / 2017-09-14

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-14.parquet
  size:    1.2 MB
  rows:    52,156

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-09-14 04:05:00	SPY	ETF	249.98	250.0	249.98	250.0	1100.0
2017-09-14 04:10:00	SPY	ETF	249.95	249.98	249.95	249.98	3000.0
2017-09-14 04:15:00	SPY	ETF	249.97	249.97	249.97	249.97	4000.0
2017-09-14 04:20:00	SPY	ETF	250.01	250.02	250.01	250.02	200.0
2017-09-14 04:25:00	SPY	ETF	250.03	250.05	250.03	250.05	300.0
2017-09-14 04:30:00	SPY	ETF	250.04	250.04	250.04	250.04	320.0
2017-09-14 04:40:00	SPY	ETF	250.06	250.06	250.05	250.05	1700.0
2017-09-14 04:45:00	SPY	ETF	250.07	250.07	250.07	250.07	200.0
2017-09-14 04:50:00	SPY	ETF	250.04	250.04	250.04	250.04	500.0
2017-09-14 04:55:00	SPY	ETF	250.08	250.08	250.08	250.08	400.0
2017-09-14 05:00:00	SPY	ETF	250.05	250.05	250.05	250.05	700.0
2017-09-14 05:05:00	SPY	ETF	250.02	250.02	250.02	250.02	300.0
2017-09-14 05:20:00	SPY	ETF	250.08	250.08	250.05	250.05	4140.0
2017-09-14 05:30:00	SPY	ETF	250.03	250.03	250.03	250.03	900.0
2017-09-14 05:35:00	SPY	ETF	250.08	250.08	250.08	250.08	200.0
2017-09-14 05:40:00	SPY	ETF	250.06	250.06	250.06	250.06	300.0
2017-09-14 05:45:00	SPY	ETF	250.05	250.05	250.05	250.05	100.0
2017-09-14 05:55:00	SPY	ETF	250.08	250.08	250.08	250.08	200.0
2017-09-14 06:00:00	SPY	ETF	250.09	250.12	250.09	250.12	400.0
2017-09-14 06:05:00	SPY	ETF	250.08	250.08	250.08	250.08	100.0
2017-09-14 06:10:00	SPY	ETF	250.08	250.08	250.08	250.08	100.0
2017-09-14 06:15:00	SPY	ETF	250.08	250.08	250.08	250.08	200.0
2017-09-14 06:20:00	SPY	ETF	250.08	250.08	250.08	250.08	200.0
2017-09-14 06:35:00	SPY	ETF	250.01	250.01	250.01	250.01	100.0
2017-09-14 06:40:00	SPY	ETF	250.07	250.07	250.07	250.07	200.0
2017-09-14 06:45:00	SPY	ETF	250.04	250.04	250.04	250.04	400.0
2017-09-14 06:50:00	SPY	ETF	250.05	250.05	250.05	250.05	300.0
2017-09-14 06:55:00	SPY	ETF	250.05	250.05	250.03	250.03	1181.0
2017-09-14 07:00:00	SPY	ETF	250.04	250.04	250.0	250.0	4110.0
2017-09-14 07:05:00	SPY	ETF	250.07	250.07	250.07	250.07	200.0
2017-09-14 07:10:00	SPY	ETF	250.07	250.1	250.07	250.1	26362.0
2017-09-14 07:15:00	SPY	ETF	250.09	250.09	250.09	250.09	4900.0
2017-09-14 07:20:00	SPY	ETF	250.06	250.06	250.02	250.05	1261.0
2017-09-14 07:25:00	SPY	ETF	250.02	250.02	249.98	249.98	35601.0
2017-09-14 07:30:00	SPY	ETF	249.99	250.0	249.98	250.0	11000.0
2017-09-14 07:35:00	SPY	ETF	250.03	250.07	250.03	250.07	8423.0
2017-09-14 07:40:00	SPY	ETF	250.07	250.07	250.03	250.04	34100.0
2017-09-14 07:45:00	SPY	ETF	250.02	250.05	250.02	250.05	9569.0
2017-09-14 07:50:00	SPY	ETF	250.07	250.08	250.03	250.08	21614.0
2017-09-14 07:55:00	SPY	ETF	250.03	250.05	250.03	250.05	28097.0
2017-09-14 08:00:00	SPY	ETF	250.02	250.09	250.01	250.01	95951.0
2017-09-14 08:05:00	SPY	ETF	250.01	250.01	250.0	250.01	11100.0
2017-09-14 08:10:00	SPY	ETF	249.99	249.99	249.9	249.92	27775.0
2017-09-14 08:15:00	SPY	ETF	249.94	249.95	249.9	249.95	24500.0
2017-09-14 08:20:00	SPY	ETF	249.93	249.98	249.78	249.78	86947.0
2017-09-14 08:25:00	SPY	ETF	249.78	249.8	249.65	249.65	233620.0
2017-09-14 08:30:00	SPY	ETF	249.65	249.74	249.54	249.63	621768.0
2017-09-14 08:35:00	SPY	ETF	249.64	249.73	249.62	249.63	27949.0
2017-09-14 08:40:00	SPY	ETF	249.65	249.66	249.45	249.52	242979.0
2017-09-14 08:45:00	SPY	ETF	249.52	249.57	249.51	249.52	22720.0

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

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