PREVIEW / etf_5min / 2023-07-05

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-05.parquet
  size:    2.0 MB
  rows:    98,350

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-07-05 04:00:00	SPY	ETF	442.93	443.31	442.71	442.91	14057.0
2023-07-05 04:05:00	SPY	ETF	442.96	442.98	442.84	442.98	7714.0
2023-07-05 04:10:00	SPY	ETF	442.83	442.83	442.76	442.79	1609.0
2023-07-05 04:15:00	SPY	ETF	442.86	443.05	442.86	443.05	1093.0
2023-07-05 04:20:00	SPY	ETF	443.06	443.06	443.06	443.06	233.0
2023-07-05 04:25:00	SPY	ETF	443.04	443.04	442.99	442.99	800.0
2023-07-05 04:30:00	SPY	ETF	442.94	442.94	442.88	442.88	1333.0
2023-07-05 04:35:00	SPY	ETF	442.88	442.88	442.88	442.88	400.0
2023-07-05 04:40:00	SPY	ETF	442.72	442.76	442.72	442.76	410.0
2023-07-05 04:45:00	SPY	ETF	442.77	442.78	442.75	442.75	754.0
2023-07-05 04:50:00	SPY	ETF	442.77	442.8	442.77	442.8	338.0
2023-07-05 04:55:00	SPY	ETF	442.71	442.71	442.69	442.7	1333.0
2023-07-05 05:05:00	SPY	ETF	442.75	442.75	442.59	442.59	2946.0
2023-07-05 05:10:00	SPY	ETF	442.6	442.6	442.49	442.49	2965.0
2023-07-05 05:15:00	SPY	ETF	442.52	442.52	442.52	442.52	236.0
2023-07-05 05:20:00	SPY	ETF	442.54	442.54	442.3	442.3	7649.0
2023-07-05 05:25:00	SPY	ETF	442.28	442.3	442.23	442.23	2202.0
2023-07-05 05:30:00	SPY	ETF	442.2	442.2	441.97	442.01	5565.0
2023-07-05 05:35:00	SPY	ETF	441.99	441.99	441.76	441.79	4716.0
2023-07-05 05:40:00	SPY	ETF	441.7	441.7	441.59	441.59	4900.0
2023-07-05 05:45:00	SPY	ETF	441.76	441.9	441.76	441.9	1622.0
2023-07-05 05:50:00	SPY	ETF	441.89	441.89	441.85	441.85	2367.0
2023-07-05 05:55:00	SPY	ETF	441.84	441.94	441.84	441.91	1399.0
2023-07-05 06:00:00	SPY	ETF	441.94	441.94	441.88	441.88	1122.0
2023-07-05 06:05:00	SPY	ETF	441.93	441.93	441.86	441.89	1448.0
2023-07-05 06:10:00	SPY	ETF	441.88	441.89	441.87	441.89	700.0
2023-07-05 06:15:00	SPY	ETF	442.0	442.1	441.98	442.1	859.0
2023-07-05 06:20:00	SPY	ETF	442.13	442.13	442.13	442.13	2784.0
2023-07-05 06:25:00	SPY	ETF	442.14	442.14	442.1	442.1	950.0
2023-07-05 06:30:00	SPY	ETF	442.2	442.29	442.2	442.27	1389.0
2023-07-05 06:35:00	SPY	ETF	442.18	442.24	442.15	442.24	893.0
2023-07-05 06:40:00	SPY	ETF	442.21	442.31	442.14	442.27	8817.0
2023-07-05 06:45:00	SPY	ETF	442.2	442.2	442.18	442.19	3006.0
2023-07-05 06:50:00	SPY	ETF	442.23	442.26	442.23	442.26	700.0
2023-07-05 06:55:00	SPY	ETF	442.25	442.25	442.19	442.19	1630.0
2023-07-05 07:00:00	SPY	ETF	442.21	442.22	442.08	442.08	5627.0
2023-07-05 07:05:00	SPY	ETF	442.06	442.06	441.98	441.99	26472.0
2023-07-05 07:10:00	SPY	ETF	441.98	441.98	441.92	441.92	2150.0
2023-07-05 07:15:00	SPY	ETF	442.0	442.14	441.97	442.105	3873.0
2023-07-05 07:20:00	SPY	ETF	442.11	442.11	441.97	441.97	7250.0
2023-07-05 07:25:00	SPY	ETF	441.96	441.96	441.85	441.93	6096.0
2023-07-05 07:30:00	SPY	ETF	441.89	442.01	441.89	441.94	9982.0
2023-07-05 07:35:00	SPY	ETF	441.91	441.96	441.86	441.96	5561.0
2023-07-05 07:40:00	SPY	ETF	441.92	442.06	441.92	441.95	6145.0
2023-07-05 07:45:00	SPY	ETF	441.94	441.98	441.91	441.95	28036.0
2023-07-05 07:50:00	SPY	ETF	441.95	441.95	441.86	441.87	3472.0
2023-07-05 07:55:00	SPY	ETF	441.87	442.0	441.69	441.69	35002.0
2023-07-05 08:00:00	SPY	ETF	442.19	443.65	441.52	441.53	59658.0
2023-07-05 08:05:00	SPY	ETF	441.51	441.62	441.48	441.51	34302.0
2023-07-05 08:10:00	SPY	ETF	441.56	441.68	441.44	441.67	83066.0

> showing 50 of 98,350 rows — these rows as CSV

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