PREVIEW / etf_5min / 2019-09-26

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-09-26.parquet
  size:    1.4 MB
  rows:    60,416

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-09-26 04:00:00	SPY	ETF	297.83	297.86	297.76	297.76	4770.0
2019-09-26 04:05:00	SPY	ETF	297.78	297.78	297.74	297.74	2100.0
2019-09-26 04:10:00	SPY	ETF	297.78	297.78	297.73	297.73	1100.0
2019-09-26 04:15:00	SPY	ETF	297.73	297.85	297.73	297.85	2234.0
2019-09-26 04:20:00	SPY	ETF	297.85	297.85	297.84	297.84	700.0
2019-09-26 04:25:00	SPY	ETF	297.83	297.83	297.83	297.83	300.0
2019-09-26 04:40:00	SPY	ETF	297.77	298.32	297.77	298.18	6211.0
2019-09-26 04:45:00	SPY	ETF	298.26	298.5	298.26	298.3	14896.0
2019-09-26 04:50:00	SPY	ETF	298.21	298.21	298.2	298.2	6000.0
2019-09-26 04:55:00	SPY	ETF	298.16	298.16	298.16	298.16	100.0
2019-09-26 05:00:00	SPY	ETF	298.2	298.23	298.2	298.23	1500.0
2019-09-26 05:05:00	SPY	ETF	298.23	298.25	298.23	298.25	1100.0
2019-09-26 05:10:00	SPY	ETF	298.28	298.28	298.28	298.28	102.0
2019-09-26 05:20:00	SPY	ETF	298.22	298.22	298.22	298.22	1250.0
2019-09-26 05:25:00	SPY	ETF	298.18	298.18	298.18	298.18	120.0
2019-09-26 05:30:00	SPY	ETF	298.18	298.18	298.18	298.18	1900.0
2019-09-26 05:35:00	SPY	ETF	298.23	298.23	298.23	298.23	2100.0
2019-09-26 05:40:00	SPY	ETF	298.15	298.15	298.15	298.15	600.0
2019-09-26 05:50:00	SPY	ETF	298.07	298.07	298.07	298.07	100.0
2019-09-26 05:55:00	SPY	ETF	298.07	298.07	298.07	298.07	300.0
2019-09-26 06:05:00	SPY	ETF	298.11	298.11	298.08	298.08	366.0
2019-09-26 06:10:00	SPY	ETF	298.1	298.15	298.1	298.15	800.0
2019-09-26 06:15:00	SPY	ETF	298.24	298.24	298.24	298.24	500.0
2019-09-26 06:25:00	SPY	ETF	298.15	298.15	298.15	298.15	100.0
2019-09-26 06:30:00	SPY	ETF	298.1	298.1	298.07	298.07	400.0
2019-09-26 06:35:00	SPY	ETF	298.07	298.07	298.0	298.02	2249.0
2019-09-26 06:40:00	SPY	ETF	298.04	298.1	298.04	298.1	324.0
2019-09-26 06:45:00	SPY	ETF	298.12	298.16	298.12	298.16	902.0
2019-09-26 07:00:00	SPY	ETF	298.1	298.1	298.05	298.07	4665.0
2019-09-26 07:05:00	SPY	ETF	298.04	298.1	298.03	298.1	2633.0
2019-09-26 07:10:00	SPY	ETF	298.1	298.14	298.07	298.14	2114.0
2019-09-26 07:15:00	SPY	ETF	298.12	298.17	298.12	298.17	22371.0
2019-09-26 07:20:00	SPY	ETF	298.17	298.2	298.15	298.18	2673.0
2019-09-26 07:25:00	SPY	ETF	298.18	298.31	298.18	298.28	4890.0
2019-09-26 07:30:00	SPY	ETF	298.25	298.3	298.22	298.22	8915.0
2019-09-26 07:35:00	SPY	ETF	298.25	298.25	298.2	298.2	23534.0
2019-09-26 07:40:00	SPY	ETF	298.21	298.26	298.21	298.26	12509.0
2019-09-26 07:45:00	SPY	ETF	298.24	298.34	298.24	298.32	8652.0
2019-09-26 07:50:00	SPY	ETF	298.33	298.34	298.26	298.34	3425.0
2019-09-26 07:55:00	SPY	ETF	298.3	298.32	298.3	298.32	1529.0
2019-09-26 08:00:00	SPY	ETF	298.1501	298.34	297.03	298.28	37059.0
2019-09-26 08:05:00	SPY	ETF	298.26	298.3	298.24	298.24	36698.0
2019-09-26 08:10:00	SPY	ETF	298.24	298.24	298.21	298.21	2180.0
2019-09-26 08:15:00	SPY	ETF	298.24	298.24	298.2	298.21	1146.0
2019-09-26 08:20:00	SPY	ETF	298.23	298.26	298.2	298.24	4546.0
2019-09-26 08:25:00	SPY	ETF	298.27	298.29	298.2	298.26	13646.0
2019-09-26 08:30:00	SPY	ETF	298.2	298.24	298.2	298.24	18193.0
2019-09-26 08:35:00	SPY	ETF	298.23	298.25	297.89	297.89	55272.0
2019-09-26 08:40:00	SPY	ETF	297.9	297.93	297.65	297.93	91443.0
2019-09-26 08:45:00	SPY	ETF	297.9	297.98	297.77	297.89	55834.0

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

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