PREVIEW / etf_5min / 2017-05-04

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-04.parquet
  size:    1.3 MB
  rows:    54,531

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-04 04:00:00	SPY	ETF	238.6	238.8	238.6	238.75	3333.0
2017-05-04 04:05:00	SPY	ETF	238.8	238.86	238.8	238.86	1800.0
2017-05-04 04:10:00	SPY	ETF	238.88	238.88	238.88	238.88	1010.0
2017-05-04 04:15:00	SPY	ETF	238.85	238.85	238.85	238.85	2400.0
2017-05-04 04:20:00	SPY	ETF	238.84	238.86	238.8	238.81	3000.0
2017-05-04 04:25:00	SPY	ETF	238.86	238.86	238.86	238.86	2000.0
2017-05-04 04:30:00	SPY	ETF	238.9	238.9	238.9	238.9	1410.0
2017-05-04 04:35:00	SPY	ETF	238.9	238.9	238.85	238.87	3200.0
2017-05-04 04:40:00	SPY	ETF	238.87	238.91	238.87	238.91	8103.0
2017-05-04 04:45:00	SPY	ETF	238.91	238.91	238.91	238.91	400.0
2017-05-04 04:50:00	SPY	ETF	238.91	238.91	238.91	238.91	1000.0
2017-05-04 04:55:00	SPY	ETF	238.91	238.91	238.9	238.9	2300.0
2017-05-04 05:00:00	SPY	ETF	238.89	238.95	238.89	238.95	903.0
2017-05-04 05:05:00	SPY	ETF	239.0	239.12	239.0	239.1	4049.0
2017-05-04 05:15:00	SPY	ETF	239.15	239.15	239.08	239.08	4033.0
2017-05-04 05:20:00	SPY	ETF	239.08	239.09	239.08	239.08	4000.0
2017-05-04 05:25:00	SPY	ETF	239.09	239.13	239.09	239.13	2703.0
2017-05-04 05:30:00	SPY	ETF	239.12	239.14	239.12	239.14	2100.0
2017-05-04 05:35:00	SPY	ETF	239.14	239.14	239.05	239.05	3102.0
2017-05-04 05:40:00	SPY	ETF	239.07	239.07	239.06	239.06	4001.0
2017-05-04 05:50:00	SPY	ETF	239.13	239.13	239.13	239.13	890.0
2017-05-04 05:55:00	SPY	ETF	239.11	239.11	239.11	239.11	1100.0
2017-05-04 06:00:00	SPY	ETF	239.11	239.11	239.11	239.11	300.0
2017-05-04 06:05:00	SPY	ETF	239.12	239.12	239.06	239.06	5901.0
2017-05-04 06:10:00	SPY	ETF	239.08	239.08	239.08	239.08	39052.0
2017-05-04 06:15:00	SPY	ETF	239.13	239.13	239.13	239.13	100.0
2017-05-04 06:25:00	SPY	ETF	239.11	239.11	239.11	239.11	1000.0
2017-05-04 06:30:00	SPY	ETF	239.14	239.14	239.14	239.14	300.0
2017-05-04 06:35:00	SPY	ETF	239.14	239.15	239.12	239.14	805.0
2017-05-04 06:45:00	SPY	ETF	239.05	239.06	239.05	239.05	10101.0
2017-05-04 06:50:00	SPY	ETF	239.06	239.08	239.05	239.08	1860.0
2017-05-04 06:55:00	SPY	ETF	239.08	239.11	239.05	239.08	1102.0
2017-05-04 07:00:00	SPY	ETF	239.12	239.18	239.12	239.15	17505.0
2017-05-04 07:05:00	SPY	ETF	239.17	239.25	239.17	239.2	65925.0
2017-05-04 07:10:00	SPY	ETF	239.2	239.2	239.18	239.18	6300.0
2017-05-04 07:15:00	SPY	ETF	239.19	239.19	239.14	239.16	12397.0
2017-05-04 07:20:00	SPY	ETF	239.16	239.2	239.16	239.16	5908.0
2017-05-04 07:25:00	SPY	ETF	239.16	239.19	239.14	239.14	17920.0
2017-05-04 07:30:00	SPY	ETF	239.15	239.16	239.13	239.15	13824.0
2017-05-04 07:35:00	SPY	ETF	239.13	239.15	239.13	239.15	1500.0
2017-05-04 07:40:00	SPY	ETF	239.15	239.16	239.14	239.16	7039.0
2017-05-04 07:45:00	SPY	ETF	239.16	239.16	239.11	239.13	14524.0
2017-05-04 07:50:00	SPY	ETF	239.1	239.13	239.08	239.13	21116.0
2017-05-04 07:55:00	SPY	ETF	239.12	239.12	239.1	239.12	2125.0
2017-05-04 08:00:00	SPY	ETF	239.16	239.21	239.09	239.1	51403.0
2017-05-04 08:05:00	SPY	ETF	239.09	239.09	239.04	239.06	100063.0
2017-05-04 08:10:00	SPY	ETF	239.05	239.06	239.0	239.0	26531.0
2017-05-04 08:15:00	SPY	ETF	239.01	239.08	239.0	239.01	53688.0
2017-05-04 08:20:00	SPY	ETF	239.01	239.05	239.0	239.03	33702.0
2017-05-04 08:25:00	SPY	ETF	239.06	239.09	239.06	239.07	20543.0

> showing 50 of 54,531 rows — these rows as CSV

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