PREVIEW / etf_5min / 2024-08-22

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-08-22.parquet
  size:    2.3 MB
  rows:    110,952

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
2024-08-22 04:00:00	SPY	ETF	561.01	561.22	561.01	561.22	633.0
2024-08-22 04:05:00	SPY	ETF	561.17	561.17	560.97	560.97	200.0
2024-08-22 04:10:00	SPY	ETF	561.1	561.1	561.1	561.1	100.0
2024-08-22 04:15:00	SPY	ETF	561.16	561.25	561.16	561.25	772.0
2024-08-22 04:20:00	SPY	ETF	561.19	561.25	561.15	561.25	1389.0
2024-08-22 04:25:00	SPY	ETF	561.22	561.22	561.1	561.1	400.0
2024-08-22 04:30:00	SPY	ETF	561.34	561.35	561.34	561.35	553.0
2024-08-22 04:35:00	SPY	ETF	561.31	561.31	561.31	561.31	100.0
2024-08-22 04:40:00	SPY	ETF	561.33	561.33	561.33	561.33	100.0
2024-08-22 04:45:00	SPY	ETF	561.35	561.35	561.3	561.3	200.0
2024-08-22 04:50:00	SPY	ETF	561.25	561.32	561.25	561.32	322.0
2024-08-22 04:55:00	SPY	ETF	561.3	561.3	561.2	561.27	2834.0
2024-08-22 05:00:00	SPY	ETF	561.29	561.29	561.29	561.29	600.0
2024-08-22 05:05:00	SPY	ETF	561.42	561.42	561.42	561.42	530.0
2024-08-22 05:10:00	SPY	ETF	561.34	561.38	561.34	561.38	1300.0
2024-08-22 05:15:00	SPY	ETF	561.48	561.59	561.47	561.59	850.0
2024-08-22 05:20:00	SPY	ETF	561.64	561.64	561.47	561.47	704.0
2024-08-22 05:25:00	SPY	ETF	561.46	561.46	561.34	561.34	787.0
2024-08-22 05:30:00	SPY	ETF	561.38	561.43	561.38	561.38	1345.0
2024-08-22 05:35:00	SPY	ETF	561.32	561.32	561.31	561.31	578.0
2024-08-22 05:40:00	SPY	ETF	561.19	561.3	561.19	561.23	322.0
2024-08-22 05:45:00	SPY	ETF	561.3	561.31	561.28	561.31	333.0
2024-08-22 05:50:00	SPY	ETF	561.19	561.25	561.19	561.24	512.0
2024-08-22 05:55:00	SPY	ETF	561.13	561.13	561.11	561.11	1464.0
2024-08-22 06:00:00	SPY	ETF	561.14	561.14	561.14	561.14	100.0
2024-08-22 06:05:00	SPY	ETF	561.25	561.25	561.23	561.23	300.0
2024-08-22 06:15:00	SPY	ETF	561.5	561.5	561.5	561.5	200.0
2024-08-22 06:20:00	SPY	ETF	561.52	561.52	561.45	561.45	1893.0
2024-08-22 06:30:00	SPY	ETF	561.35	561.61	561.35	561.61	300.0
2024-08-22 06:35:00	SPY	ETF	561.54	561.66	561.54	561.66	800.0
2024-08-22 06:40:00	SPY	ETF	561.61	561.7	561.6	561.63	4546.0
2024-08-22 06:45:00	SPY	ETF	561.5	561.53	561.5	561.53	800.0
2024-08-22 06:50:00	SPY	ETF	561.63	561.63	561.63	561.63	102.0
2024-08-22 06:55:00	SPY	ETF	561.75	561.75	561.74	561.75	1197.0
2024-08-22 07:00:00	SPY	ETF	561.72	561.85	561.65	561.81	17658.0
2024-08-22 07:05:00	SPY	ETF	561.8	561.85	561.76	561.85	2073.0
2024-08-22 07:10:00	SPY	ETF	561.83	561.97	561.81	561.97	36252.0
2024-08-22 07:15:00	SPY	ETF	561.88	562.05	561.88	562.05	6126.0
2024-08-22 07:20:00	SPY	ETF	562.11	562.2	562.11	562.14	5830.0
2024-08-22 07:25:00	SPY	ETF	562.141	562.141	562.03	562.03	7967.0
2024-08-22 07:30:00	SPY	ETF	562.06	562.06	561.89	561.89	7821.0
2024-08-22 07:35:00	SPY	ETF	561.87	561.87	561.76	561.8	4200.0
2024-08-22 07:40:00	SPY	ETF	561.78	561.95	561.74	561.89	21186.0
2024-08-22 07:45:00	SPY	ETF	561.9	561.98	561.87	561.98	3751.0
2024-08-22 07:50:00	SPY	ETF	562.0	562.16	562.0	562.1	18248.0
2024-08-22 07:55:00	SPY	ETF	562.14	562.14	562.05	562.05	11819.0
2024-08-22 08:00:00	SPY	ETF	561.75	562.28	560.27	562.28	28638.0
2024-08-22 08:05:00	SPY	ETF	562.21	562.38	562.1002	562.1002	13502.0
2024-08-22 08:10:00	SPY	ETF	562.1	562.1	561.91	561.95	8447.0
2024-08-22 08:15:00	SPY	ETF	562.0	562.05	561.81	561.86	37503.0

> showing 50 of 110,952 rows — these rows as CSV

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