PREVIEW / etf_5min / 2024-10-04

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-10-04.parquet
  size:    2.4 MB
  rows:    118,055

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-10-04 04:00:00	SPY	ETF	568.73	568.93	568.72	568.72	508.0
2024-10-04 04:05:00	SPY	ETF	568.76	568.76	568.32	568.32	806.0
2024-10-04 04:10:00	SPY	ETF	568.19	568.31	568.18	568.2	3272.0
2024-10-04 04:15:00	SPY	ETF	568.26	568.26	568.24	568.24	428.0
2024-10-04 04:20:00	SPY	ETF	568.39	568.73	568.39	568.59	1557.0
2024-10-04 04:25:00	SPY	ETF	568.53	568.55	568.53	568.55	364.0
2024-10-04 04:30:00	SPY	ETF	568.53	568.53	568.35	568.4	1320.0
2024-10-04 04:35:00	SPY	ETF	568.41	568.51	568.4	568.51	846.0
2024-10-04 04:45:00	SPY	ETF	568.68	568.68	568.3	568.3	1304.0
2024-10-04 04:50:00	SPY	ETF	568.44	568.5	568.42	568.42	763.0
2024-10-04 04:55:00	SPY	ETF	568.23	568.23	568.15	568.21	927.0
2024-10-04 05:00:00	SPY	ETF	568.23	568.34	568.13	568.27	1316.0
2024-10-04 05:05:00	SPY	ETF	568.42	568.52	568.42	568.52	796.0
2024-10-04 05:10:00	SPY	ETF	568.45	568.45	568.34	568.39	2555.0
2024-10-04 05:15:00	SPY	ETF	568.27	568.3	568.27	568.28	1300.0
2024-10-04 05:25:00	SPY	ETF	568.3	568.38	568.22	568.38	873.0
2024-10-04 05:30:00	SPY	ETF	568.41	568.57	568.39	568.57	2346.0
2024-10-04 05:35:00	SPY	ETF	568.5	568.5	568.5	568.5	100.0
2024-10-04 05:40:00	SPY	ETF	568.48	568.57	568.47	568.57	732.0
2024-10-04 05:50:00	SPY	ETF	568.7	568.77	568.7	568.77	513.0
2024-10-04 05:55:00	SPY	ETF	568.75	568.9	568.75	568.9	1387.0
2024-10-04 06:00:00	SPY	ETF	569.12	569.15	569.1	569.15	829.0
2024-10-04 06:05:00	SPY	ETF	569.1	569.1	569.1	569.1	100.0
2024-10-04 06:10:00	SPY	ETF	569.28	569.31	569.25	569.31	1360.0
2024-10-04 06:15:00	SPY	ETF	569.28	569.49	569.28	569.49	1257.0
2024-10-04 06:20:00	SPY	ETF	569.37	569.37	569.23	569.23	400.0
2024-10-04 06:25:00	SPY	ETF	569.23	569.26	569.23	569.26	707.0
2024-10-04 06:30:00	SPY	ETF	569.32	569.39	569.32	569.39	6630.0
2024-10-04 06:35:00	SPY	ETF	569.34	569.65	569.34	569.56	7452.0
2024-10-04 06:40:00	SPY	ETF	569.55	569.55	569.52	569.52	2600.0
2024-10-04 06:45:00	SPY	ETF	569.26	569.26	569.26	569.26	200.0
2024-10-04 06:50:00	SPY	ETF	569.25	569.25	569.25	569.25	118.0
2024-10-04 06:55:00	SPY	ETF	569.25	569.25	569.15	569.16	862.0
2024-10-04 07:00:00	SPY	ETF	569.15	569.43	569.02	569.43	4788.0
2024-10-04 07:05:00	SPY	ETF	569.38	569.38	569.25	569.38	2454.0
2024-10-04 07:10:00	SPY	ETF	569.4	569.44	569.38	569.4	6435.0
2024-10-04 07:15:00	SPY	ETF	569.39	569.78	569.37	569.64	15734.0
2024-10-04 07:20:00	SPY	ETF	569.581	569.76	569.56	569.76	13623.0
2024-10-04 07:25:00	SPY	ETF	569.76	569.76	569.65	569.65	3045.0
2024-10-04 07:30:00	SPY	ETF	569.7	569.84	569.58	569.66	13774.0
2024-10-04 07:35:00	SPY	ETF	569.63	569.63	569.42	569.57	15154.0
2024-10-04 07:40:00	SPY	ETF	569.59	569.66	569.47	569.5	10034.0
2024-10-04 07:45:00	SPY	ETF	569.51	569.63	569.48	569.63	12887.0
2024-10-04 07:50:00	SPY	ETF	569.58	569.73	569.495	569.54	5193.0
2024-10-04 07:55:00	SPY	ETF	569.52	569.62	569.4	569.6	15683.0
2024-10-04 08:00:00	SPY	ETF	569.42	569.84	567.55	569.53	42149.0
2024-10-04 08:05:00	SPY	ETF	569.53	569.57	569.3	569.39	21370.0
2024-10-04 08:10:00	SPY	ETF	569.36	569.53	569.34	569.52	10597.0
2024-10-04 08:15:00	SPY	ETF	569.53	569.66	569.4304	569.66	5467.0
2024-10-04 08:20:00	SPY	ETF	569.65	569.7906	569.3775	569.67	30403.0

> showing 50 of 118,055 rows — these rows as CSV

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