PREVIEW / etf_5min / 2019-06-20

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-06-20.parquet
  size:    1.5 MB
  rows:    66,734

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-06-20 04:00:00	SPY	ETF	295.02	295.14	295.02	295.14	4157.0
2019-06-20 04:05:00	SPY	ETF	295.09	295.18	295.08	295.18	8600.0
2019-06-20 04:10:00	SPY	ETF	295.14	295.22	295.12	295.22	5777.0
2019-06-20 04:15:00	SPY	ETF	295.18	295.18	295.09	295.14	2000.0
2019-06-20 04:20:00	SPY	ETF	295.22	295.22	295.19	295.19	540.0
2019-06-20 04:25:00	SPY	ETF	295.2	295.31	295.2	295.3	5626.0
2019-06-20 04:30:00	SPY	ETF	295.34	295.52	295.34	295.52	1940.0
2019-06-20 04:35:00	SPY	ETF	295.59	295.6	295.57	295.57	3170.0
2019-06-20 04:40:00	SPY	ETF	295.51	295.6	295.51	295.59	1050.0
2019-06-20 04:45:00	SPY	ETF	295.62	295.65	295.62	295.64	901.0
2019-06-20 04:50:00	SPY	ETF	295.64	295.68	295.56	295.56	3500.0
2019-06-20 04:55:00	SPY	ETF	295.57	295.6	295.57	295.59	500.0
2019-06-20 05:00:00	SPY	ETF	295.61	295.61	295.61	295.61	300.0
2019-06-20 05:10:00	SPY	ETF	295.77	295.77	295.77	295.77	116.0
2019-06-20 05:15:00	SPY	ETF	295.74	295.8	295.74	295.8	235.0
2019-06-20 05:20:00	SPY	ETF	295.79	295.79	295.74	295.74	1825.0
2019-06-20 05:25:00	SPY	ETF	295.76	295.89	295.76	295.89	4525.0
2019-06-20 05:30:00	SPY	ETF	295.86	295.98	295.86	295.98	3065.0
2019-06-20 05:35:00	SPY	ETF	295.98	295.99	295.88	295.91	3422.0
2019-06-20 05:40:00	SPY	ETF	295.91	295.92	295.89	295.92	3087.0
2019-06-20 05:45:00	SPY	ETF	295.92	295.93	295.87	295.9	1060.0
2019-06-20 05:50:00	SPY	ETF	295.91	295.91	295.87	295.9	606.0
2019-06-20 05:55:00	SPY	ETF	295.95	295.95	295.94	295.94	1500.0
2019-06-20 06:00:00	SPY	ETF	295.94	295.94	295.92	295.92	952.0
2019-06-20 06:05:00	SPY	ETF	295.89	295.9	295.86	295.9	1346.0
2019-06-20 06:10:00	SPY	ETF	295.9	295.9	295.9	295.9	200.0
2019-06-20 06:15:00	SPY	ETF	295.91	295.91	295.85	295.85	12000.0
2019-06-20 06:20:00	SPY	ETF	295.86	295.87	295.86	295.87	773.0
2019-06-20 06:25:00	SPY	ETF	295.93	295.93	295.86	295.86	3132.0
2019-06-20 06:30:00	SPY	ETF	295.86	295.86	295.76	295.76	3600.0
2019-06-20 06:35:00	SPY	ETF	295.77	295.79	295.76	295.77	4795.0
2019-06-20 06:40:00	SPY	ETF	295.75	295.76	295.73	295.76	34755.0
2019-06-20 06:45:00	SPY	ETF	295.78	295.79	295.72	295.72	28220.0
2019-06-20 06:50:00	SPY	ETF	295.75	295.77	295.75	295.77	770.0
2019-06-20 06:55:00	SPY	ETF	295.79	295.8	295.7	295.7	6625.0
2019-06-20 07:00:00	SPY	ETF	295.67	295.78	295.66	295.75	15895.0
2019-06-20 07:05:00	SPY	ETF	295.78	295.79	295.75	295.75	4582.0
2019-06-20 07:10:00	SPY	ETF	295.75	295.81	295.75	295.75	8044.0
2019-06-20 07:15:00	SPY	ETF	295.73	295.79	295.7	295.78	23414.0
2019-06-20 07:20:00	SPY	ETF	295.74	295.88	295.72	295.88	3116.0
2019-06-20 07:25:00	SPY	ETF	295.9	295.91	295.85	295.88	8267.0
2019-06-20 07:30:00	SPY	ETF	295.9	295.94	295.9	295.92	3404.0
2019-06-20 07:35:00	SPY	ETF	295.93	296.08	295.93	296.04	99092.0
2019-06-20 07:40:00	SPY	ETF	296.06	296.18	296.06	296.18	154226.0
2019-06-20 07:45:00	SPY	ETF	296.18	296.18	296.1	296.1	39627.0
2019-06-20 07:50:00	SPY	ETF	296.07	296.08	296.04	296.06	27283.0
2019-06-20 07:55:00	SPY	ETF	296.06	296.08	296.02	296.05	41095.0
2019-06-20 08:00:00	SPY	ETF	295.96	296.1799	294.47	296.1	90738.0
2019-06-20 08:05:00	SPY	ETF	296.08	296.11	296.0	296.04	70849.0
2019-06-20 08:10:00	SPY	ETF	296.04	296.12	296.02	296.1	54962.0

> showing 50 of 66,734 rows — these rows as CSV

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