PREVIEW / etf_5min / 2023-11-02

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-11-02.parquet
  size:    2.2 MB
  rows:    106,198

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-11-02 04:00:00	SPY	ETF	423.94	423.94	423.8	423.91	4189.0
2023-11-02 04:05:00	SPY	ETF	423.89	423.99	423.85	423.93	2198.0
2023-11-02 04:10:00	SPY	ETF	423.89	423.93	423.89	423.93	232.0
2023-11-02 04:15:00	SPY	ETF	424.0	424.21	424.0	424.21	6459.0
2023-11-02 04:20:00	SPY	ETF	424.38	424.72	424.38	424.69	16879.0
2023-11-02 04:25:00	SPY	ETF	424.67	424.71	424.6	424.69	5600.0
2023-11-02 04:30:00	SPY	ETF	424.65	424.66	424.54	424.54	1200.0
2023-11-02 04:35:00	SPY	ETF	424.52	424.63	424.48	424.63	1060.0
2023-11-02 04:40:00	SPY	ETF	424.67	424.76	424.65	424.75	2699.0
2023-11-02 04:45:00	SPY	ETF	424.68	424.78	424.67	424.78	1017.0
2023-11-02 04:50:00	SPY	ETF	424.8	425.0	424.8	425.0	6727.0
2023-11-02 04:55:00	SPY	ETF	424.91	424.92	424.75	424.75	871.0
2023-11-02 05:00:00	SPY	ETF	424.84	424.97	424.84	424.89	667.0
2023-11-02 05:05:00	SPY	ETF	424.93	424.95	424.89	424.94	1781.0
2023-11-02 05:10:00	SPY	ETF	424.9	425.01	424.85	424.89	24340.0
2023-11-02 05:15:00	SPY	ETF	424.9	425.05	424.88	424.98	62296.0
2023-11-02 05:20:00	SPY	ETF	424.94	425.02	424.94	425.02	3990.0
2023-11-02 05:25:00	SPY	ETF	425.0	425.11	424.97	425.1	28481.0
2023-11-02 05:30:00	SPY	ETF	425.1	425.23	425.02	425.05	15592.0
2023-11-02 05:35:00	SPY	ETF	425.09	425.09	425.01	425.01	10489.0
2023-11-02 05:40:00	SPY	ETF	425.05	425.12	424.85	424.88	1899.0
2023-11-02 05:45:00	SPY	ETF	424.93	424.96	424.91	424.94	5999.0
2023-11-02 05:50:00	SPY	ETF	425.0	425.0	424.94	424.95	400.0
2023-11-02 05:55:00	SPY	ETF	425.05	425.05	424.9	424.95	59080.0
2023-11-02 06:00:00	SPY	ETF	424.95	424.95	424.81	424.81	61121.0
2023-11-02 06:05:00	SPY	ETF	424.79	424.86	424.72	424.8	58462.0
2023-11-02 06:10:00	SPY	ETF	424.76	424.76	424.61	424.63	64960.0
2023-11-02 06:15:00	SPY	ETF	424.71	424.77	424.7	424.76	46400.0
2023-11-02 06:20:00	SPY	ETF	424.75	424.8	424.74	424.8	2026.0
2023-11-02 06:25:00	SPY	ETF	424.75	424.75	424.7	424.71	900.0
2023-11-02 06:30:00	SPY	ETF	424.66	424.77	424.63	424.75	6540.0
2023-11-02 06:35:00	SPY	ETF	424.68	424.72	424.6	424.65	4050.0
2023-11-02 06:40:00	SPY	ETF	424.65	424.95	424.65	424.9	13892.0
2023-11-02 06:45:00	SPY	ETF	424.93	424.96	424.86	424.91	6148.0
2023-11-02 06:50:00	SPY	ETF	424.97	425.01	424.93	425.01	2224.0
2023-11-02 06:55:00	SPY	ETF	425.01	425.06	425.0	425.0	1967.0
2023-11-02 07:00:00	SPY	ETF	424.9	425.06	424.88	425.06	7525.0
2023-11-02 07:05:00	SPY	ETF	425.1	425.1	424.91	424.99	4275.0
2023-11-02 07:10:00	SPY	ETF	425.08	425.08	425.0	425.02	1509.0
2023-11-02 07:15:00	SPY	ETF	425.08	425.17	425.01	425.01	25277.0
2023-11-02 07:20:00	SPY	ETF	425.0	425.06	424.97	425.03	6156.0
2023-11-02 07:25:00	SPY	ETF	425.01	425.09	424.95	425.09	16982.0
2023-11-02 07:30:00	SPY	ETF	425.1	425.14	424.95	425.0	18613.0
2023-11-02 07:35:00	SPY	ETF	425.0	425.16	425.0	425.13	23650.0
2023-11-02 07:40:00	SPY	ETF	425.13	425.29	425.13	425.21	46836.0
2023-11-02 07:45:00	SPY	ETF	425.23	425.41	425.23	425.32	38747.0
2023-11-02 07:50:00	SPY	ETF	425.32	425.33	425.17	425.26	20477.0
2023-11-02 07:55:00	SPY	ETF	425.22	425.25	425.17	425.23	6917.0
2023-11-02 08:00:00	SPY	ETF	424.94	425.4001	423.52	425.16	51434.0
2023-11-02 08:05:00	SPY	ETF	425.3	425.68	425.3	425.68	51784.0

> showing 50 of 106,198 rows — these rows as CSV

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