PREVIEW / etf_5min / 2019-05-09

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-05-09.parquet
  size:    1.5 MB
  rows:    63,600

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-05-09 04:00:00	SPY	ETF	285.93	286.2	285.93	286.14	8827.0
2019-05-09 04:05:00	SPY	ETF	286.12	286.12	285.95	285.95	5021.0
2019-05-09 04:10:00	SPY	ETF	285.87	285.91	285.76	285.76	3862.0
2019-05-09 04:15:00	SPY	ETF	285.68	285.83	285.68	285.83	750.0
2019-05-09 04:20:00	SPY	ETF	285.68	285.68	285.56	285.59	23000.0
2019-05-09 04:25:00	SPY	ETF	285.78	285.86	285.78	285.83	2212.0
2019-05-09 04:30:00	SPY	ETF	285.94	286.03	285.91	286.03	1800.0
2019-05-09 04:35:00	SPY	ETF	285.99	286.01	285.95	285.96	935.0
2019-05-09 04:40:00	SPY	ETF	285.99	285.99	285.99	285.99	300.0
2019-05-09 04:45:00	SPY	ETF	286.03	286.11	286.03	286.06	931.0
2019-05-09 04:50:00	SPY	ETF	286.03	286.11	286.03	286.11	708.0
2019-05-09 04:55:00	SPY	ETF	286.13	286.13	286.13	286.13	325.0
2019-05-09 05:05:00	SPY	ETF	286.23	286.23	286.21	286.21	550.0
2019-05-09 05:10:00	SPY	ETF	286.26	286.26	286.26	286.26	126.0
2019-05-09 05:15:00	SPY	ETF	286.24	286.28	286.24	286.28	750.0
2019-05-09 05:20:00	SPY	ETF	286.25	286.31	286.25	286.31	1100.0
2019-05-09 05:25:00	SPY	ETF	286.25	286.25	286.2	286.2	1750.0
2019-05-09 05:30:00	SPY	ETF	286.1	286.13	286.0	286.13	3505.0
2019-05-09 05:35:00	SPY	ETF	286.05	286.06	286.05	286.05	600.0
2019-05-09 05:40:00	SPY	ETF	286.04	286.07	286.04	286.07	4300.0
2019-05-09 05:45:00	SPY	ETF	286.1	286.1	285.93	286.03	1876.0
2019-05-09 05:50:00	SPY	ETF	286.15	286.2	286.06	286.13	1981.0
2019-05-09 05:55:00	SPY	ETF	286.15	286.25	286.14	286.14	5700.0
2019-05-09 06:00:00	SPY	ETF	286.13	286.13	286.12	286.12	1300.0
2019-05-09 06:05:00	SPY	ETF	286.04	286.04	286.0	286.03	4790.0
2019-05-09 06:10:00	SPY	ETF	286.02	286.08	286.0	286.0	2005.0
2019-05-09 06:15:00	SPY	ETF	286.0	286.06	286.0	286.0	2313.0
2019-05-09 06:20:00	SPY	ETF	286.0	286.0	285.91	285.91	6431.0
2019-05-09 06:25:00	SPY	ETF	285.92	286.12	285.92	286.12	4301.0
2019-05-09 06:30:00	SPY	ETF	286.16	286.28	286.12	286.23	6480.0
2019-05-09 06:35:00	SPY	ETF	286.22	286.26	286.22	286.25	4300.0
2019-05-09 06:40:00	SPY	ETF	286.31	286.36	286.3	286.36	7802.0
2019-05-09 06:45:00	SPY	ETF	286.38	286.42	286.38	286.42	3100.0
2019-05-09 06:50:00	SPY	ETF	286.43	286.56	286.41	286.5	13257.0
2019-05-09 06:55:00	SPY	ETF	286.49	286.52	286.43	286.5	37120.0
2019-05-09 07:00:00	SPY	ETF	286.52	286.56	286.43	286.5	80563.0
2019-05-09 07:05:00	SPY	ETF	286.53	286.56	286.5	286.53	28766.0
2019-05-09 07:10:00	SPY	ETF	286.54	286.55	286.48	286.5	10016.0
2019-05-09 07:15:00	SPY	ETF	286.51	286.51	286.36	286.5	28190.0
2019-05-09 07:20:00	SPY	ETF	286.52	286.55	286.5	286.53	23054.0
2019-05-09 07:25:00	SPY	ETF	286.56	286.65	286.41	286.42	40056.0
2019-05-09 07:30:00	SPY	ETF	286.4	286.47	286.35	286.41	11077.0
2019-05-09 07:35:00	SPY	ETF	286.4	286.4	286.27	286.37	23426.0
2019-05-09 07:40:00	SPY	ETF	286.35	286.45	286.35	286.39	8720.0
2019-05-09 07:45:00	SPY	ETF	286.43	286.55	286.43	286.49	17086.0
2019-05-09 07:50:00	SPY	ETF	286.48	286.6	286.48	286.55	26029.0
2019-05-09 07:55:00	SPY	ETF	286.52	286.52	286.22	286.24	26751.0
2019-05-09 08:00:00	SPY	ETF	286.31	287.05	285.51	286.24	128305.0
2019-05-09 08:05:00	SPY	ETF	286.25	287.5403	286.21	286.2501	151614.0
2019-05-09 08:10:00	SPY	ETF	286.22	286.29	286.04	286.05	86561.0

> showing 50 of 63,600 rows — these rows as CSV

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