PREVIEW / etf_5min / 2021-11-02

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-11-02.parquet
  size:    1.8 MB
  rows:    84,967

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
2021-11-02 04:00:00	SPY	ETF	459.84	459.9	459.81	459.84	1800.0
2021-11-02 04:05:00	SPY	ETF	459.89	460.02	459.84	459.84	2200.0
2021-11-02 04:10:00	SPY	ETF	459.95	459.95	459.84	459.86	549.0
2021-11-02 04:15:00	SPY	ETF	459.85	459.85	459.85	459.85	101.0
2021-11-02 04:20:00	SPY	ETF	459.9	459.93	459.9	459.91	1400.0
2021-11-02 04:25:00	SPY	ETF	459.96	459.96	459.93	459.93	500.0
2021-11-02 04:30:00	SPY	ETF	459.97	460.05	459.97	460.05	600.0
2021-11-02 04:35:00	SPY	ETF	460.07	460.07	460.03	460.03	300.0
2021-11-02 04:40:00	SPY	ETF	460.03	460.03	460.03	460.03	100.0
2021-11-02 04:45:00	SPY	ETF	460.0	460.0	459.81	459.81	3098.0
2021-11-02 04:50:00	SPY	ETF	459.86	459.86	459.84	459.85	1100.0
2021-11-02 04:55:00	SPY	ETF	459.79	459.79	459.58	459.6	2499.0
2021-11-02 05:00:00	SPY	ETF	459.57	459.57	459.38	459.5	1900.0
2021-11-02 05:05:00	SPY	ETF	459.6	459.68	459.6	459.68	1100.0
2021-11-02 05:10:00	SPY	ETF	459.74	459.78	459.74	459.77	21224.0
2021-11-02 05:15:00	SPY	ETF	459.7	459.81	459.67	459.75	9953.0
2021-11-02 05:20:00	SPY	ETF	459.72	459.95	459.72	459.93	23799.0
2021-11-02 05:25:00	SPY	ETF	459.88	459.88	459.8	459.8	274.0
2021-11-02 05:30:00	SPY	ETF	459.87	459.87	459.78	459.78	4150.0
2021-11-02 05:40:00	SPY	ETF	459.62	459.62	459.62	459.62	200.0
2021-11-02 05:45:00	SPY	ETF	459.67	459.68	459.66	459.66	687.0
2021-11-02 05:50:00	SPY	ETF	459.7	459.7	459.7	459.7	100.0
2021-11-02 05:55:00	SPY	ETF	459.78	459.8	459.78	459.78	28980.0
2021-11-02 06:00:00	SPY	ETF	459.84	459.84	459.73	459.73	2500.0
2021-11-02 06:10:00	SPY	ETF	459.64	459.64	459.64	459.64	3200.0
2021-11-02 06:15:00	SPY	ETF	459.64	459.65	459.54	459.65	33521.0
2021-11-02 06:20:00	SPY	ETF	459.76	459.77	459.71	459.77	400.0
2021-11-02 06:25:00	SPY	ETF	459.81	459.82	459.81	459.81	1000.0
2021-11-02 06:35:00	SPY	ETF	459.9	459.9	459.8	459.82	1400.0
2021-11-02 06:40:00	SPY	ETF	459.86	459.94	459.85	459.9	1692.0
2021-11-02 06:45:00	SPY	ETF	459.94	459.95	459.92	459.95	11872.0
2021-11-02 06:50:00	SPY	ETF	459.97	459.97	459.97	459.97	100.0
2021-11-02 06:55:00	SPY	ETF	459.95	459.96	459.95	459.96	322.0
2021-11-02 07:00:00	SPY	ETF	460.13	460.13	460.08	460.08	5634.0
2021-11-02 07:05:00	SPY	ETF	460.04	460.05	459.9	459.95	3716.0
2021-11-02 07:10:00	SPY	ETF	459.96	460.08	459.95	460.03	4448.0
2021-11-02 07:15:00	SPY	ETF	460.02	460.04	459.9	460.04	3751.0
2021-11-02 07:20:00	SPY	ETF	460.05	460.12	460.03	460.03	40006.0
2021-11-02 07:25:00	SPY	ETF	460.04	460.04	459.99	460.03	5097.0
2021-11-02 07:30:00	SPY	ETF	460.0	460.29	460.0	460.29	5643.0
2021-11-02 07:35:00	SPY	ETF	460.27	460.36	460.27	460.3	5050.0
2021-11-02 07:40:00	SPY	ETF	460.3	460.3	460.26	460.28	2935.0
2021-11-02 07:45:00	SPY	ETF	460.29	460.29	460.21	460.25	3723.0
2021-11-02 07:50:00	SPY	ETF	460.22	460.22	460.11	460.17	8828.0
2021-11-02 07:55:00	SPY	ETF	460.16	460.19	460.14	460.16	1244.0
2021-11-02 08:00:00	SPY	ETF	460.15	460.385	459.6304	460.27	12362.0
2021-11-02 08:05:00	SPY	ETF	460.24	460.32	460.22	460.26	8327.0
2021-11-02 08:10:00	SPY	ETF	460.26	460.42	460.26	460.42	9453.0
2021-11-02 08:15:00	SPY	ETF	460.42	460.42	460.23	460.23	11480.0
2021-11-02 08:20:00	SPY	ETF	460.26	460.32	460.26	460.29	18442.0

> showing 50 of 84,967 rows — these rows as CSV

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