PREVIEW / etf_5min / 2023-06-02

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-02.parquet
  size:    2.1 MB
  rows:    99,852

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
2023-06-02 04:00:00	SPY	ETF	422.75	423.4	422.75	423.4	6143.0
2023-06-02 04:05:00	SPY	ETF	423.34	423.34	423.19	423.19	1607.0
2023-06-02 04:10:00	SPY	ETF	423.23	423.31	423.23	423.31	2202.0
2023-06-02 04:15:00	SPY	ETF	423.3	423.49	423.3	423.4	4122.0
2023-06-02 04:20:00	SPY	ETF	423.37	423.37	423.37	423.37	100.0
2023-06-02 04:25:00	SPY	ETF	423.32	423.4	423.32	423.4	1534.0
2023-06-02 04:30:00	SPY	ETF	423.3	423.46	423.3	423.46	6305.0
2023-06-02 04:35:00	SPY	ETF	423.44	423.44	423.34	423.43	748.0
2023-06-02 04:40:00	SPY	ETF	423.3	423.31	423.3	423.31	450.0
2023-06-02 04:45:00	SPY	ETF	423.31	423.31	423.23	423.23	600.0
2023-06-02 04:50:00	SPY	ETF	423.36	423.44	423.36	423.44	700.0
2023-06-02 04:55:00	SPY	ETF	423.48	423.54	423.48	423.54	1600.0
2023-06-02 05:00:00	SPY	ETF	423.45	423.51	423.45	423.51	690.0
2023-06-02 05:05:00	SPY	ETF	423.44	423.44	423.4	423.4	624.0
2023-06-02 05:10:00	SPY	ETF	423.57	423.82	423.57	423.82	516.0
2023-06-02 05:15:00	SPY	ETF	423.84	424.1	423.84	424.05	1726.0
2023-06-02 05:20:00	SPY	ETF	424.11	424.16	423.9	423.9	5950.0
2023-06-02 05:25:00	SPY	ETF	423.84	423.99	423.84	423.97	800.0
2023-06-02 05:30:00	SPY	ETF	424.0	424.07	423.97	423.99	6918.0
2023-06-02 05:35:00	SPY	ETF	423.94	424.0	423.87	423.99	12040.0
2023-06-02 05:40:00	SPY	ETF	423.86	423.86	423.73	423.73	713.0
2023-06-02 05:45:00	SPY	ETF	423.73	423.79	423.7	423.79	1513.0
2023-06-02 05:50:00	SPY	ETF	423.7	423.7	423.68	423.68	555.0
2023-06-02 05:55:00	SPY	ETF	423.69	423.78	423.69	423.77	6142.0
2023-06-02 06:00:00	SPY	ETF	423.8	423.8	423.69	423.69	44448.0
2023-06-02 06:05:00	SPY	ETF	423.79	423.86	423.69	423.86	7650.0
2023-06-02 06:10:00	SPY	ETF	423.85	423.91	423.79	423.91	6701.0
2023-06-02 06:15:00	SPY	ETF	424.03	424.04	424.0	424.04	400.0
2023-06-02 06:20:00	SPY	ETF	423.96	423.98	423.96	423.97	1730.0
2023-06-02 06:25:00	SPY	ETF	423.94	423.98	423.89	423.98	3791.0
2023-06-02 06:30:00	SPY	ETF	423.98	423.99	423.96	423.96	15150.0
2023-06-02 06:35:00	SPY	ETF	423.98	424.01	423.97	423.98	4443.0
2023-06-02 06:40:00	SPY	ETF	423.99	424.11	423.94	424.1	23398.0
2023-06-02 06:45:00	SPY	ETF	423.95	423.97	423.94	423.94	5599.0
2023-06-02 06:50:00	SPY	ETF	423.9	423.9	423.8	423.8	2809.0
2023-06-02 06:55:00	SPY	ETF	423.87	423.92	423.85	423.87	3725.0
2023-06-02 07:00:00	SPY	ETF	423.87	423.96	423.84	423.89	19638.0
2023-06-02 07:05:00	SPY	ETF	423.92	423.97	423.9	423.9	6125.0
2023-06-02 07:10:00	SPY	ETF	423.91	424.14	423.86	424.14	20763.0
2023-06-02 07:15:00	SPY	ETF	424.11	424.21	424.04	424.04	4738.0
2023-06-02 07:20:00	SPY	ETF	424.09	424.1	424.01	424.09	16997.0
2023-06-02 07:25:00	SPY	ETF	424.03	424.17	424.03	424.16	5485.0
2023-06-02 07:30:00	SPY	ETF	424.13	424.25	424.07	424.12	8584.0
2023-06-02 07:35:00	SPY	ETF	424.12	424.12	423.92	423.98	20068.0
2023-06-02 07:40:00	SPY	ETF	424.0	424.03	423.77	423.775	17975.0
2023-06-02 07:45:00	SPY	ETF	423.75	423.91	423.73	423.91	6102.0
2023-06-02 07:50:00	SPY	ETF	423.88	423.95	423.88	423.91	37396.0
2023-06-02 07:55:00	SPY	ETF	423.92	423.93	423.78	423.8	25680.0
2023-06-02 08:00:00	SPY	ETF	423.8891	424.2	422.47	423.88	100241.0
2023-06-02 08:05:00	SPY	ETF	423.86	423.92	423.74	423.819	19155.0

> showing 50 of 99,852 rows — these rows as CSV

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