PREVIEW / etf_5min / 2019-08-07

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-07.parquet
  size:    1.6 MB
  rows:    68,298

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-08-07 04:00:00	SPY	ETF	287.49	287.79	287.49	287.69	7655.0
2019-08-07 04:05:00	SPY	ETF	287.66	287.81	287.66	287.72	7316.0
2019-08-07 04:10:00	SPY	ETF	287.85	287.85	287.56	287.56	800.0
2019-08-07 04:15:00	SPY	ETF	287.59	287.64	287.59	287.64	1369.0
2019-08-07 04:20:00	SPY	ETF	287.59	287.59	287.46	287.46	2404.0
2019-08-07 04:25:00	SPY	ETF	287.63	287.63	287.56	287.56	600.0
2019-08-07 04:30:00	SPY	ETF	287.65	287.65	287.63	287.63	809.0
2019-08-07 04:35:00	SPY	ETF	287.63	288.03	287.63	288.03	4460.0
2019-08-07 04:40:00	SPY	ETF	288.07	288.22	288.06	288.06	2954.0
2019-08-07 04:45:00	SPY	ETF	288.06	288.11	288.06	288.11	700.0
2019-08-07 04:50:00	SPY	ETF	288.28	288.28	288.28	288.28	400.0
2019-08-07 04:55:00	SPY	ETF	288.08	288.11	288.08	288.11	440.0
2019-08-07 05:00:00	SPY	ETF	288.23	288.23	288.11	288.11	470.0
2019-08-07 05:05:00	SPY	ETF	288.06	288.08	288.06	288.08	1700.0
2019-08-07 05:10:00	SPY	ETF	287.96	287.96	287.96	287.96	510.0
2019-08-07 05:15:00	SPY	ETF	288.0	288.02	288.0	288.02	225.0
2019-08-07 05:20:00	SPY	ETF	288.01	288.01	288.0	288.0	2600.0
2019-08-07 05:25:00	SPY	ETF	288.01	288.11	288.01	288.11	5204.0
2019-08-07 05:30:00	SPY	ETF	288.2	288.2	288.18	288.18	800.0
2019-08-07 05:35:00	SPY	ETF	288.08	288.13	288.03	288.13	1050.0
2019-08-07 05:40:00	SPY	ETF	288.2	288.6	288.2	288.6	6019.0
2019-08-07 05:45:00	SPY	ETF	288.6	288.63	288.5	288.53	4715.0
2019-08-07 05:50:00	SPY	ETF	288.5	288.5	288.5	288.5	615.0
2019-08-07 05:55:00	SPY	ETF	288.43	288.48	288.43	288.43	1915.0
2019-08-07 06:00:00	SPY	ETF	288.43	288.47	288.37	288.43	4719.0
2019-08-07 06:05:00	SPY	ETF	288.44	288.53	288.44	288.48	2303.0
2019-08-07 06:15:00	SPY	ETF	288.42	288.42	288.22	288.22	14404.0
2019-08-07 06:20:00	SPY	ETF	288.25	288.42	288.25	288.42	3500.0
2019-08-07 06:25:00	SPY	ETF	288.28	288.28	288.25	288.25	10030.0
2019-08-07 06:30:00	SPY	ETF	288.4	288.4	288.4	288.4	100.0
2019-08-07 06:35:00	SPY	ETF	288.42	288.42	288.42	288.42	100.0
2019-08-07 06:40:00	SPY	ETF	288.46	288.47	288.25	288.25	8765.0
2019-08-07 06:45:00	SPY	ETF	288.32	288.35	288.32	288.35	800.0
2019-08-07 06:50:00	SPY	ETF	288.35	288.35	288.18	288.18	9334.0
2019-08-07 06:55:00	SPY	ETF	288.2	288.22	287.94	287.98	19115.0
2019-08-07 07:00:00	SPY	ETF	287.96	288.13	287.93	288.03	15655.0
2019-08-07 07:05:00	SPY	ETF	288.03	288.03	287.9	287.95	32814.0
2019-08-07 07:10:00	SPY	ETF	287.98	288.18	287.98	288.05	12980.0
2019-08-07 07:15:00	SPY	ETF	288.1	288.1	288.05	288.05	560.0
2019-08-07 07:20:00	SPY	ETF	288.1	288.19	287.8	287.98	22204.0
2019-08-07 07:25:00	SPY	ETF	287.92	287.93	287.82	287.91	75171.0
2019-08-07 07:30:00	SPY	ETF	287.91	287.94	287.78	287.85	65978.0
2019-08-07 07:35:00	SPY	ETF	287.86	287.93	287.78	287.84	50922.0
2019-08-07 07:40:00	SPY	ETF	287.79	287.92	287.74	287.83	37196.0
2019-08-07 07:45:00	SPY	ETF	287.81	287.81	287.38	287.41	105643.0
2019-08-07 07:50:00	SPY	ETF	287.48	287.56	287.48	287.56	3590.0
2019-08-07 07:55:00	SPY	ETF	287.47	287.5	287.27	287.32	36913.0
2019-08-07 08:00:00	SPY	ETF	287.86	288.1499	285.87	286.45	159061.0
2019-08-07 08:05:00	SPY	ETF	286.4	286.53	285.87	285.95	150643.0
2019-08-07 08:10:00	SPY	ETF	285.93	286.02	285.57	285.57	163703.0

> showing 50 of 68,298 rows — these rows as CSV

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