PREVIEW / etf_5min / 2020-07-01

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-07-01.parquet
  size:    1.6 MB
  rows:    74,888

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
2020-07-01 04:00:00	SPY	ETF	308.74	308.89	308.74	308.89	4558.0
2020-07-01 04:05:00	SPY	ETF	308.97	309.02	308.94	308.98	12140.0
2020-07-01 04:10:00	SPY	ETF	309.04	309.12	309.04	309.08	4778.0
2020-07-01 04:15:00	SPY	ETF	309.0	309.0	308.6	308.6	2558.0
2020-07-01 04:25:00	SPY	ETF	308.6	308.6	308.5	308.5	740.0
2020-07-01 04:30:00	SPY	ETF	308.7	308.7	308.63	308.65	751.0
2020-07-01 04:45:00	SPY	ETF	308.61	308.61	308.61	308.61	105.0
2020-07-01 04:50:00	SPY	ETF	308.6	308.68	308.6	308.68	200.0
2020-07-01 04:55:00	SPY	ETF	308.68	308.8	308.68	308.75	1533.0
2020-07-01 05:00:00	SPY	ETF	308.88	308.9	308.86	308.9	791.0
2020-07-01 05:05:00	SPY	ETF	308.94	309.0	308.93	309.0	1420.0
2020-07-01 05:10:00	SPY	ETF	309.05	309.1	309.03	309.05	1560.0
2020-07-01 05:15:00	SPY	ETF	309.03	309.08	309.03	309.08	765.0
2020-07-01 05:20:00	SPY	ETF	309.08	309.15	309.08	309.1	3512.0
2020-07-01 05:25:00	SPY	ETF	309.05	309.34	309.05	309.34	2928.0
2020-07-01 05:30:00	SPY	ETF	309.36	309.37	309.06	309.1	1511.0
2020-07-01 05:35:00	SPY	ETF	309.0	309.02	308.85	309.02	2124.0
2020-07-01 05:40:00	SPY	ETF	308.9	308.9	308.3	308.35	8081.0
2020-07-01 05:45:00	SPY	ETF	308.37	308.37	307.94	308.2	13120.0
2020-07-01 05:50:00	SPY	ETF	308.18	308.41	308.18	308.41	4652.0
2020-07-01 05:55:00	SPY	ETF	308.41	308.41	308.15	308.15	10974.0
2020-07-01 06:00:00	SPY	ETF	307.98	308.21	307.98	308.17	9141.0
2020-07-01 06:05:00	SPY	ETF	308.24	308.58	308.23	308.54	7556.0
2020-07-01 06:10:00	SPY	ETF	308.55	308.58	308.44	308.44	1453.0
2020-07-01 06:15:00	SPY	ETF	308.36	308.63	308.36	308.62	2153.0
2020-07-01 06:20:00	SPY	ETF	308.62	308.62	308.58	308.58	751.0
2020-07-01 06:25:00	SPY	ETF	308.43	308.43	308.28	308.35	1513.0
2020-07-01 06:30:00	SPY	ETF	308.28	308.4	308.28	308.36	1151.0
2020-07-01 06:35:00	SPY	ETF	308.48	308.48	307.52	307.82	20680.0
2020-07-01 06:40:00	SPY	ETF	307.81	307.83	307.53	307.73	20830.0
2020-07-01 06:45:00	SPY	ETF	307.73	307.83	307.67	307.78	23390.0
2020-07-01 06:50:00	SPY	ETF	307.78	307.8	307.17	307.17	54021.0
2020-07-01 06:55:00	SPY	ETF	307.19	307.44	307.16	307.44	25642.0
2020-07-01 07:00:00	SPY	ETF	307.45	307.48	306.75	306.84	83740.0
2020-07-01 07:05:00	SPY	ETF	306.86	306.96	306.73	306.91	73821.0
2020-07-01 07:10:00	SPY	ETF	306.9	307.25	306.9	307.15	17907.0
2020-07-01 07:15:00	SPY	ETF	307.17	307.42	307.17	307.25	23583.0
2020-07-01 07:20:00	SPY	ETF	307.17	307.31	307.15	307.22	15158.0
2020-07-01 07:25:00	SPY	ETF	307.2	307.27	307.05	307.26	51152.0
2020-07-01 07:30:00	SPY	ETF	307.19	307.24	306.48	306.51	92256.0
2020-07-01 07:35:00	SPY	ETF	306.51	306.65	306.42	306.65	46950.0
2020-07-01 07:40:00	SPY	ETF	306.61	306.81	306.5	306.79	72362.0
2020-07-01 07:45:00	SPY	ETF	306.78	306.86	306.69	306.71	47256.0
2020-07-01 07:50:00	SPY	ETF	306.68	307.18	306.67	307.18	91109.0
2020-07-01 07:55:00	SPY	ETF	307.13	307.19	307.02	307.15	44662.0
2020-07-01 08:00:00	SPY	ETF	307.1	308.98	306.48	307.17	99377.0
2020-07-01 08:05:00	SPY	ETF	307.1	307.16	307.0	307.11	28126.0
2020-07-01 08:10:00	SPY	ETF	307.06	307.36	307.0	307.3	58673.0
2020-07-01 08:15:00	SPY	ETF	307.22	307.31	307.09	307.27	132911.0
2020-07-01 08:20:00	SPY	ETF	307.24	308.36	307.24	307.69	150691.0

> showing 50 of 74,888 rows — these rows as CSV

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