PREVIEW / etf_5min / 2019-09-27

all etf 5-min files

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

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-27 04:00:00	SPY	ETF	297.24	297.3	297.24	297.3	3300.0
2019-09-27 04:05:00	SPY	ETF	297.43	297.5	297.4	297.4	2712.0
2019-09-27 04:10:00	SPY	ETF	297.5	297.5	297.5	297.5	300.0
2019-09-27 04:20:00	SPY	ETF	297.53	297.6	297.53	297.55	900.0
2019-09-27 04:25:00	SPY	ETF	297.7	297.87	297.68	297.87	2942.0
2019-09-27 04:30:00	SPY	ETF	297.85	297.85	297.74	297.77	848.0
2019-09-27 04:35:00	SPY	ETF	297.79	297.79	297.65	297.65	1200.0
2019-09-27 04:40:00	SPY	ETF	297.64	297.77	297.64	297.75	3500.0
2019-09-27 04:45:00	SPY	ETF	297.77	297.79	297.74	297.75	1700.0
2019-09-27 04:50:00	SPY	ETF	297.77	297.84	297.77	297.84	802.0
2019-09-27 04:55:00	SPY	ETF	297.75	297.79	297.75	297.79	400.0
2019-09-27 05:00:00	SPY	ETF	297.65	297.69	297.65	297.65	501.0
2019-09-27 05:10:00	SPY	ETF	297.69	297.69	297.63	297.63	700.0
2019-09-27 05:15:00	SPY	ETF	297.57	297.57	297.54	297.56	500.0
2019-09-27 05:20:00	SPY	ETF	297.67	297.68	297.67	297.68	800.0
2019-09-27 05:25:00	SPY	ETF	297.63	297.67	297.63	297.67	300.0
2019-09-27 05:30:00	SPY	ETF	297.65	297.78	297.65	297.78	2330.0
2019-09-27 05:35:00	SPY	ETF	297.74	297.74	297.65	297.69	1000.0
2019-09-27 05:45:00	SPY	ETF	297.72	297.74	297.7	297.7	900.0
2019-09-27 05:50:00	SPY	ETF	297.75	297.84	297.75	297.84	1401.0
2019-09-27 05:55:00	SPY	ETF	297.85	297.87	297.8	297.8	400.0
2019-09-27 06:00:00	SPY	ETF	297.75	297.75	297.6	297.72	2415.0
2019-09-27 06:05:00	SPY	ETF	297.7	297.82	297.7	297.8	1900.0
2019-09-27 06:10:00	SPY	ETF	297.78	298.01	297.78	298.0	2614.0
2019-09-27 06:15:00	SPY	ETF	298.03	298.28	298.03	298.25	3090.0
2019-09-27 06:20:00	SPY	ETF	298.22	298.22	298.07	298.09	11765.0
2019-09-27 06:25:00	SPY	ETF	298.05	298.05	298.0	298.0	1230.0
2019-09-27 06:30:00	SPY	ETF	298.05	298.07	298.05	298.07	5000.0
2019-09-27 06:35:00	SPY	ETF	298.07	298.07	298.07	298.07	100.0
2019-09-27 06:40:00	SPY	ETF	298.05	298.05	297.98	297.98	1590.0
2019-09-27 06:45:00	SPY	ETF	297.93	298.1	297.9	298.1	4660.0
2019-09-27 06:50:00	SPY	ETF	297.92	297.92	297.92	297.92	800.0
2019-09-27 06:55:00	SPY	ETF	298.05	298.05	298.05	298.05	100.0
2019-09-27 07:00:00	SPY	ETF	298.05	298.07	297.93	297.93	7433.0
2019-09-27 07:05:00	SPY	ETF	297.93	298.02	297.92	298.02	11525.0
2019-09-27 07:10:00	SPY	ETF	298.0	298.05	298.0	298.0	17100.0
2019-09-27 07:15:00	SPY	ETF	298.04	298.07	298.03	298.05	29468.0
2019-09-27 07:20:00	SPY	ETF	298.03	298.05	298.0	298.0	6845.0
2019-09-27 07:25:00	SPY	ETF	297.93	297.95	297.9	297.95	1451.0
2019-09-27 07:30:00	SPY	ETF	297.93	297.94	297.85	297.91	737.0
2019-09-27 07:35:00	SPY	ETF	297.87	297.93	297.87	297.93	12440.0
2019-09-27 07:45:00	SPY	ETF	297.89	297.9	297.89	297.9	790.0
2019-09-27 07:50:00	SPY	ETF	297.93	297.98	297.88	297.88	11484.0
2019-09-27 07:55:00	SPY	ETF	297.86	297.93	297.86	297.9	14538.0
2019-09-27 08:00:00	SPY	ETF	297.9	298.03	296.75	297.95	30426.0
2019-09-27 08:05:00	SPY	ETF	297.95	298.07	297.95	298.05	16610.0
2019-09-27 08:10:00	SPY	ETF	298.02	298.02	297.85	297.85	10651.0
2019-09-27 08:15:00	SPY	ETF	297.84	297.85	297.76	297.79	10180.0
2019-09-27 08:20:00	SPY	ETF	297.78	297.79	297.7	297.79	11485.0
2019-09-27 08:25:00	SPY	ETF	297.76	297.83	297.75	297.75	17304.0

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

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