PREVIEW / etf_5min / 2017-06-05

all etf 5-min files

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

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-06-05 04:00:00	SPY	ETF	243.97	244.0	243.97	244.0	5923.0
2017-06-05 04:10:00	SPY	ETF	244.0	244.09	244.0	244.09	500.0
2017-06-05 04:20:00	SPY	ETF	244.03	244.03	243.98	243.98	3520.0
2017-06-05 04:25:00	SPY	ETF	243.93	243.96	243.93	243.96	2800.0
2017-06-05 04:35:00	SPY	ETF	244.01	244.01	244.01	244.01	2000.0
2017-06-05 04:40:00	SPY	ETF	244.05	244.05	244.05	244.05	1000.0
2017-06-05 05:10:00	SPY	ETF	244.05	244.05	244.05	244.05	300.0
2017-06-05 05:15:00	SPY	ETF	244.08	244.08	244.08	244.08	200.0
2017-06-05 05:20:00	SPY	ETF	244.12	244.12	244.12	244.12	100.0
2017-06-05 05:25:00	SPY	ETF	244.15	244.15	244.07	244.07	1400.0
2017-06-05 05:30:00	SPY	ETF	244.08	244.08	244.05	244.05	400.0
2017-06-05 05:35:00	SPY	ETF	244.05	244.05	244.05	244.05	300.0
2017-06-05 05:55:00	SPY	ETF	244.05	244.05	244.02	244.02	300.0
2017-06-05 06:05:00	SPY	ETF	244.03	244.03	244.03	244.03	400.0
2017-06-05 06:30:00	SPY	ETF	244.05	244.05	244.04	244.04	600.0
2017-06-05 06:40:00	SPY	ETF	244.04	244.04	244.0	244.0	15038.0
2017-06-05 06:50:00	SPY	ETF	243.96	243.96	243.96	243.96	800.0
2017-06-05 06:55:00	SPY	ETF	243.92	243.96	243.92	243.95	900.0
2017-06-05 07:00:00	SPY	ETF	243.93	243.94	243.9	243.91	16110.0
2017-06-05 07:05:00	SPY	ETF	243.91	243.91	243.84	243.91	39203.0
2017-06-05 07:10:00	SPY	ETF	243.91	243.93	243.9	243.93	11453.0
2017-06-05 07:15:00	SPY	ETF	243.99	243.99	243.95	243.95	2000.0
2017-06-05 07:20:00	SPY	ETF	244.0	244.01	244.0	244.01	6200.0
2017-06-05 07:25:00	SPY	ETF	243.95	243.95	243.88	243.91	18810.0
2017-06-05 07:30:00	SPY	ETF	243.94	243.94	243.94	243.94	500.0
2017-06-05 07:35:00	SPY	ETF	243.88	243.88	243.88	243.88	5000.0
2017-06-05 07:45:00	SPY	ETF	243.91	243.91	243.9	243.91	10304.0
2017-06-05 07:50:00	SPY	ETF	243.9	243.91	243.9	243.9	4400.0
2017-06-05 07:55:00	SPY	ETF	243.89	243.91	243.89	243.91	1450.0
2017-06-05 08:00:00	SPY	ETF	243.88	243.92	243.87	243.87	11382.0
2017-06-05 08:05:00	SPY	ETF	243.87	243.89	243.86	243.89	3350.0
2017-06-05 08:10:00	SPY	ETF	243.87	243.91	243.87	243.91	8650.0
2017-06-05 08:15:00	SPY	ETF	243.89	243.91	243.89	243.9	3548.0
2017-06-05 08:20:00	SPY	ETF	243.94	243.94	243.92	243.92	1500.0
2017-06-05 08:25:00	SPY	ETF	243.94	243.94	243.92	243.93	8949.0
2017-06-05 08:30:00	SPY	ETF	243.94	243.96	243.94	243.96	8707.0
2017-06-05 08:35:00	SPY	ETF	243.96	243.96	243.94	243.95	7113.0
2017-06-05 08:40:00	SPY	ETF	243.95	243.95	243.88	243.93	22873.0
2017-06-05 08:45:00	SPY	ETF	243.96	243.96	243.96	243.96	100.0
2017-06-05 08:50:00	SPY	ETF	243.94	243.94	243.92	243.92	4875.0
2017-06-05 08:55:00	SPY	ETF	243.91	243.92	243.91	243.91	4110.0
2017-06-05 09:00:00	SPY	ETF	243.91	243.93	243.89	243.92	9792.0
2017-06-05 09:05:00	SPY	ETF	243.92	243.96	243.92	243.96	19557.0
2017-06-05 09:10:00	SPY	ETF	243.95	244.0	243.95	243.99	67313.0
2017-06-05 09:15:00	SPY	ETF	244.0	244.0	243.98	243.98	46714.0
2017-06-05 09:20:00	SPY	ETF	243.97	244.0	243.97	243.98	52176.0
2017-06-05 09:25:00	SPY	ETF	243.99	244.02	243.97	243.98	117156.0
2017-06-05 09:30:00	SPY	ETF	243.97	244.05	243.83	243.87	1378521.0
2017-06-05 09:35:00	SPY	ETF	243.87	243.96	243.82	243.86	636004.0
2017-06-05 09:40:00	SPY	ETF	243.87	243.89	243.76	243.82	684362.0

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

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