PREVIEW / etf_5min / 2023-07-25

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-25.parquet
  size:    2.0 MB
  rows:    97,943

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-25 04:00:00	SPY	ETF	454.41	454.51	454.41	454.49	2452.0
2023-07-25 04:05:00	SPY	ETF	454.43	454.47	454.34	454.47	1859.0
2023-07-25 04:10:00	SPY	ETF	454.55	454.67	454.55	454.63	5349.0
2023-07-25 04:15:00	SPY	ETF	454.75	454.9	454.67	454.9	1172.0
2023-07-25 04:20:00	SPY	ETF	454.92	455.05	454.92	455.0	13565.0
2023-07-25 04:25:00	SPY	ETF	454.97	455.04	454.97	455.04	5390.0
2023-07-25 04:30:00	SPY	ETF	455.05	455.09	455.03	455.09	16450.0
2023-07-25 04:35:00	SPY	ETF	455.09	455.16	455.07	455.11	2829.0
2023-07-25 04:40:00	SPY	ETF	455.2	455.2	455.04	455.09	2495.0
2023-07-25 04:45:00	SPY	ETF	455.12	455.12	455.06	455.06	2314.0
2023-07-25 04:50:00	SPY	ETF	455.14	455.14	455.11	455.11	1128.0
2023-07-25 04:55:00	SPY	ETF	455.06	455.07	455.06	455.07	1358.0
2023-07-25 05:00:00	SPY	ETF	454.99	455.01	454.99	455.0	1100.0
2023-07-25 05:05:00	SPY	ETF	455.0	455.0	454.98	454.98	1479.0
2023-07-25 05:10:00	SPY	ETF	454.93	454.93	454.83	454.83	2040.0
2023-07-25 05:15:00	SPY	ETF	454.85	454.92	454.82	454.92	1370.0
2023-07-25 05:20:00	SPY	ETF	454.88	454.88	454.88	454.88	100.0
2023-07-25 05:35:00	SPY	ETF	454.79	454.8	454.79	454.8	385.0
2023-07-25 05:40:00	SPY	ETF	454.9	454.9	454.9	454.9	500.0
2023-07-25 05:45:00	SPY	ETF	454.89	454.91	454.88	454.88	1112.0
2023-07-25 05:50:00	SPY	ETF	454.88	454.89	454.88	454.88	610.0
2023-07-25 05:55:00	SPY	ETF	454.92	454.92	454.89	454.89	225.0
2023-07-25 06:00:00	SPY	ETF	454.88	454.88	454.88	454.88	100.0
2023-07-25 06:05:00	SPY	ETF	454.75	454.75	454.75	454.75	100.0
2023-07-25 06:10:00	SPY	ETF	454.72	454.72	454.46	454.46	918.0
2023-07-25 06:15:00	SPY	ETF	454.45	454.57	454.45	454.57	546.0
2023-07-25 06:25:00	SPY	ETF	454.54	454.54	454.52	454.52	800.0
2023-07-25 06:30:00	SPY	ETF	454.53	454.59	454.52	454.52	3065.0
2023-07-25 06:35:00	SPY	ETF	454.44	454.6	454.44	454.6	898.0
2023-07-25 06:40:00	SPY	ETF	454.61	454.63	454.61	454.63	785.0
2023-07-25 06:45:00	SPY	ETF	454.68	454.7	454.61	454.61	3660.0
2023-07-25 06:50:00	SPY	ETF	454.68	454.68	454.66	454.66	1042.0
2023-07-25 06:55:00	SPY	ETF	454.68	454.68	454.62	454.65	4811.0
2023-07-25 07:00:00	SPY	ETF	454.65	454.8	454.65	454.8	2400.0
2023-07-25 07:05:00	SPY	ETF	454.8	454.83	454.79	454.83	10033.0
2023-07-25 07:10:00	SPY	ETF	454.82	454.85	454.8	454.8	5428.0
2023-07-25 07:15:00	SPY	ETF	454.82	454.85	454.82	454.85	2100.0
2023-07-25 07:20:00	SPY	ETF	454.84	454.85	454.81	454.83	6316.0
2023-07-25 07:25:00	SPY	ETF	454.85	454.92	454.85	454.92	1700.0
2023-07-25 07:30:00	SPY	ETF	454.85	454.85	454.75	454.75	7423.0
2023-07-25 07:35:00	SPY	ETF	454.75	454.75	454.68	454.72	3613.0
2023-07-25 07:40:00	SPY	ETF	454.73	454.73	454.64	454.64	2800.0
2023-07-25 07:45:00	SPY	ETF	454.7	454.7	454.65	454.65	350.0
2023-07-25 07:50:00	SPY	ETF	454.65	454.73	454.65	454.67	600.0
2023-07-25 07:55:00	SPY	ETF	454.83	454.83	454.77	454.77	2025.0
2023-07-25 08:00:00	SPY	ETF	454.8191	455.1796	454.18	454.89	37743.0
2023-07-25 08:05:00	SPY	ETF	454.83	454.9	454.79	454.84	13056.0
2023-07-25 08:10:00	SPY	ETF	454.8	454.8	454.7	454.76	3130.0
2023-07-25 08:15:00	SPY	ETF	454.72	454.72	454.55	454.55	8680.0
2023-07-25 08:20:00	SPY	ETF	454.57	454.57	454.35	454.3999	10803.0

> showing 50 of 97,943 rows — these rows as CSV

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