PREVIEW / etf_5min / 2024-09-27

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-09-27.parquet
  size:    2.4 MB
  rows:    115,940

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-09-27 04:00:00	SPY	ETF	571.44	571.72	571.4	571.72	1888.0
2024-09-27 04:05:00	SPY	ETF	571.57	571.77	571.53	571.77	3084.0
2024-09-27 04:10:00	SPY	ETF	571.66	571.84	571.64	571.71	2000.0
2024-09-27 04:15:00	SPY	ETF	571.85	571.85	571.69	571.69	200.0
2024-09-27 04:20:00	SPY	ETF	572.27	572.36	572.27	572.29	1094.0
2024-09-27 04:25:00	SPY	ETF	572.29	572.37	572.22	572.22	871.0
2024-09-27 04:30:00	SPY	ETF	572.33	572.52	572.33	572.52	1493.0
2024-09-27 04:35:00	SPY	ETF	572.44	572.44	572.32	572.39	1025.0
2024-09-27 04:40:00	SPY	ETF	572.36	572.36	572.08	572.08	850.0
2024-09-27 04:45:00	SPY	ETF	572.02	572.02	572.02	572.02	100.0
2024-09-27 04:50:00	SPY	ETF	572.03	572.17	572.03	572.17	353.0
2024-09-27 04:55:00	SPY	ETF	572.0	572.0	572.0	572.0	105.0
2024-09-27 05:05:00	SPY	ETF	572.07	572.15	572.07	572.15	200.0
2024-09-27 05:10:00	SPY	ETF	572.38	572.38	572.26	572.26	874.0
2024-09-27 05:15:00	SPY	ETF	572.31	572.5	572.3	572.5	1074.0
2024-09-27 05:20:00	SPY	ETF	572.54	572.54	572.31	572.31	1000.0
2024-09-27 05:25:00	SPY	ETF	572.18	572.19	572.18	572.19	4000.0
2024-09-27 05:30:00	SPY	ETF	572.0	572.0	571.85	571.85	1107.0
2024-09-27 05:35:00	SPY	ETF	572.07	572.07	572.07	572.07	140.0
2024-09-27 05:40:00	SPY	ETF	572.08	572.3	572.08	572.3	300.0
2024-09-27 05:45:00	SPY	ETF	572.42	572.42	572.28	572.28	349.0
2024-09-27 05:55:00	SPY	ETF	572.4	572.4	572.4	572.4	200.0
2024-09-27 06:00:00	SPY	ETF	572.37	572.37	572.2	572.2	400.0
2024-09-27 06:05:00	SPY	ETF	572.52	572.55	572.52	572.55	300.0
2024-09-27 06:15:00	SPY	ETF	572.31	572.31	572.31	572.31	150.0
2024-09-27 06:20:00	SPY	ETF	572.27	572.27	572.27	572.27	187.0
2024-09-27 06:25:00	SPY	ETF	572.23	572.23	572.23	572.23	500.0
2024-09-27 06:30:00	SPY	ETF	572.24	572.24	572.12	572.12	394.0
2024-09-27 06:35:00	SPY	ETF	572.17	572.17	572.17	572.17	100.0
2024-09-27 06:40:00	SPY	ETF	572.09	572.13	571.98	572.03	7197.0
2024-09-27 06:45:00	SPY	ETF	572.15	572.21	572.15	572.21	1473.0
2024-09-27 06:50:00	SPY	ETF	572.25	572.25	572.2	572.2	848.0
2024-09-27 06:55:00	SPY	ETF	572.1	572.11	572.06	572.11	686.0
2024-09-27 07:00:00	SPY	ETF	572.07	572.23	572.07	572.18	3189.0
2024-09-27 07:10:00	SPY	ETF	572.24	572.27	572.02	572.06	7098.0
2024-09-27 07:15:00	SPY	ETF	572.1	572.24	572.07	572.23	2107.0
2024-09-27 07:20:00	SPY	ETF	572.33	572.33	572.27	572.27	1899.0
2024-09-27 07:25:00	SPY	ETF	572.3	572.3	572.3	572.3	349.0
2024-09-27 07:30:00	SPY	ETF	572.43	572.5	572.43	572.49	509.0
2024-09-27 07:35:00	SPY	ETF	572.42	572.42	572.35	572.37	487.0
2024-09-27 07:40:00	SPY	ETF	572.31	572.43	572.31	572.43	1135.0
2024-09-27 07:45:00	SPY	ETF	572.5	572.55	572.46	572.53	8360.0
2024-09-27 07:50:00	SPY	ETF	572.56	572.59	572.47	572.59	7545.0
2024-09-27 07:55:00	SPY	ETF	572.64	572.71	572.61	572.64	3337.0
2024-09-27 08:00:00	SPY	ETF	572.0942	572.99	571.5	572.84	68507.0
2024-09-27 08:05:00	SPY	ETF	572.87	573.04	572.85	572.99	15060.0
2024-09-27 08:10:00	SPY	ETF	572.95	572.99	572.86	572.95	4682.0
2024-09-27 08:15:00	SPY	ETF	572.92	573.02	572.89	572.93	4074.0
2024-09-27 08:20:00	SPY	ETF	572.98	573.02	572.911	572.94	4513.0
2024-09-27 08:25:00	SPY	ETF	572.93	573.08	572.902	573.03	12574.0

> showing 50 of 115,940 rows — these rows as CSV

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