PREVIEW / etf_5min / 2019-10-22

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-10-22.parquet
  size:    1.4 MB
  rows:    60,656

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
2019-10-22 04:00:00	SPY	ETF	299.95	299.95	299.88	299.88	3070.0
2019-10-22 04:05:00	SPY	ETF	299.81	299.81	299.81	299.81	334.0
2019-10-22 04:10:00	SPY	ETF	299.74	299.74	299.74	299.74	200.0
2019-10-22 04:15:00	SPY	ETF	299.82	299.82	299.82	299.82	350.0
2019-10-22 04:20:00	SPY	ETF	299.8	299.8	299.77	299.77	610.0
2019-10-22 04:25:00	SPY	ETF	299.75	299.75	299.68	299.68	950.0
2019-10-22 04:30:00	SPY	ETF	299.7	299.7	299.61	299.61	3550.0
2019-10-22 04:35:00	SPY	ETF	299.61	299.65	299.55	299.65	3700.0
2019-10-22 04:40:00	SPY	ETF	299.68	299.81	299.68	299.81	4900.0
2019-10-22 04:45:00	SPY	ETF	299.83	299.83	299.83	299.83	100.0
2019-10-22 04:50:00	SPY	ETF	299.81	299.81	299.81	299.81	100.0
2019-10-22 04:55:00	SPY	ETF	299.85	299.85	299.85	299.85	200.0
2019-10-22 05:00:00	SPY	ETF	299.85	299.85	299.85	299.85	1070.0
2019-10-22 05:10:00	SPY	ETF	299.87	299.87	299.86	299.86	500.0
2019-10-22 05:15:00	SPY	ETF	299.89	299.89	299.89	299.89	100.0
2019-10-22 05:20:00	SPY	ETF	299.89	299.98	299.89	299.98	1020.0
2019-10-22 05:25:00	SPY	ETF	300.0	300.05	300.0	300.05	2300.0
2019-10-22 05:30:00	SPY	ETF	300.09	300.13	300.09	300.12	2800.0
2019-10-22 05:35:00	SPY	ETF	300.14	300.18	300.14	300.18	400.0
2019-10-22 05:40:00	SPY	ETF	300.1	300.1	300.09	300.09	496.0
2019-10-22 05:45:00	SPY	ETF	300.07	300.07	300.07	300.07	300.0
2019-10-22 05:50:00	SPY	ETF	300.15	300.19	300.14	300.15	2244.0
2019-10-22 06:00:00	SPY	ETF	300.2	300.22	300.15	300.15	750.0
2019-10-22 06:05:00	SPY	ETF	300.19	300.19	300.19	300.19	1000.0
2019-10-22 06:10:00	SPY	ETF	300.15	300.15	300.06	300.06	5450.0
2019-10-22 06:15:00	SPY	ETF	300.09	300.09	300.09	300.09	300.0
2019-10-22 06:20:00	SPY	ETF	300.07	300.07	300.04	300.04	1925.0
2019-10-22 06:25:00	SPY	ETF	300.07	300.07	300.05	300.07	2800.0
2019-10-22 06:30:00	SPY	ETF	300.05	300.05	299.98	299.98	3110.0
2019-10-22 06:35:00	SPY	ETF	300.05	300.12	300.05	300.12	1300.0
2019-10-22 06:40:00	SPY	ETF	300.1	300.14	300.1	300.1	706.0
2019-10-22 06:45:00	SPY	ETF	300.12	300.12	300.11	300.11	287.0
2019-10-22 06:50:00	SPY	ETF	300.09	300.09	300.05	300.05	1294.0
2019-10-22 06:55:00	SPY	ETF	300.1	300.2	300.1	300.2	9900.0
2019-10-22 07:00:00	SPY	ETF	300.25	300.3	300.23	300.26	37903.0
2019-10-22 07:05:00	SPY	ETF	300.25	300.28	300.25	300.25	17000.0
2019-10-22 07:10:00	SPY	ETF	300.24	300.31	300.24	300.31	12100.0
2019-10-22 07:15:00	SPY	ETF	300.25	300.26	300.24	300.25	4949.0
2019-10-22 07:20:00	SPY	ETF	300.25	300.25	300.24	300.25	1095.0
2019-10-22 07:25:00	SPY	ETF	300.2	300.28	300.18	300.26	2700.0
2019-10-22 07:30:00	SPY	ETF	300.28	300.37	300.28	300.37	3169.0
2019-10-22 07:35:00	SPY	ETF	300.3	300.46	300.3	300.46	17726.0
2019-10-22 07:40:00	SPY	ETF	300.46	300.49	300.43	300.49	13068.0
2019-10-22 07:45:00	SPY	ETF	300.48	300.48	300.4	300.42	9439.0
2019-10-22 07:50:00	SPY	ETF	300.46	300.49	300.44	300.44	10815.0
2019-10-22 07:55:00	SPY	ETF	300.45	300.48	300.4	300.48	22405.0
2019-10-22 08:00:00	SPY	ETF	300.2301	300.65	299.85	300.4799	15006.0
2019-10-22 08:05:00	SPY	ETF	300.43	300.43	300.27	300.38	47965.0
2019-10-22 08:10:00	SPY	ETF	300.37	300.46	300.0216	300.44	74874.0
2019-10-22 08:15:00	SPY	ETF	300.46	300.46	300.44	300.45	18710.0

> showing 50 of 60,656 rows — these rows as CSV

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