PREVIEW / etf_5min / 2024-07-24

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-07-24.parquet
  size:    2.4 MB
  rows:    118,455

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-07-24 04:00:00	SPY	ETF	549.9	550.06	549.82	550.02	4483.0
2024-07-24 04:05:00	SPY	ETF	549.99	550.02	549.93	549.93	1718.0
2024-07-24 04:10:00	SPY	ETF	549.97	549.98	549.6	549.63	1774.0
2024-07-24 04:15:00	SPY	ETF	549.53	549.8	549.27	549.41	6182.0
2024-07-24 04:20:00	SPY	ETF	549.39	549.6	549.36	549.4	1787.0
2024-07-24 04:25:00	SPY	ETF	549.36	549.39	549.21	549.21	2290.0
2024-07-24 04:30:00	SPY	ETF	549.22	549.41	549.22	549.35	973.0
2024-07-24 04:35:00	SPY	ETF	549.35	549.66	549.28	549.66	8740.0
2024-07-24 04:40:00	SPY	ETF	549.7	550.1	549.7	550.1	2905.0
2024-07-24 04:45:00	SPY	ETF	550.07	550.17	550.03	550.17	1782.0
2024-07-24 04:50:00	SPY	ETF	550.16	550.31	550.15	550.24	4653.0
2024-07-24 04:55:00	SPY	ETF	550.29	550.29	550.23	550.26	2541.0
2024-07-24 05:00:00	SPY	ETF	550.28	550.3	550.19	550.2	3425.0
2024-07-24 05:05:00	SPY	ETF	550.09	550.18	550.09	550.18	1083.0
2024-07-24 05:10:00	SPY	ETF	550.01	550.01	549.97	549.97	1100.0
2024-07-24 05:15:00	SPY	ETF	550.0	550.0	549.64	549.64	853.0
2024-07-24 05:20:00	SPY	ETF	549.65	549.68	549.61	549.67	826.0
2024-07-24 05:25:00	SPY	ETF	549.65	549.65	549.37	549.37	4137.0
2024-07-24 05:30:00	SPY	ETF	549.56	549.6	549.56	549.6	583.0
2024-07-24 05:35:00	SPY	ETF	549.71	549.71	549.58	549.58	1100.0
2024-07-24 05:40:00	SPY	ETF	549.47	549.49	549.47	549.49	330.0
2024-07-24 05:45:00	SPY	ETF	549.73	549.79	549.73	549.79	404.0
2024-07-24 05:50:00	SPY	ETF	549.69	549.79	549.69	549.79	393.0
2024-07-24 05:55:00	SPY	ETF	549.79	549.94	549.78	549.94	706.0
2024-07-24 06:00:00	SPY	ETF	549.87	549.95	549.83	549.95	2526.0
2024-07-24 06:05:00	SPY	ETF	550.0	550.05	549.99	550.05	5194.0
2024-07-24 06:10:00	SPY	ETF	549.96	550.1	549.96	550.1	10255.0
2024-07-24 06:15:00	SPY	ETF	550.13	550.13	550.02	550.1	15700.0
2024-07-24 06:20:00	SPY	ETF	550.21	550.3	550.21	550.3	3459.0
2024-07-24 06:25:00	SPY	ETF	550.35	550.46	550.22	550.24	4764.0
2024-07-24 06:30:00	SPY	ETF	550.11	550.11	550.02	550.02	456.0
2024-07-24 06:35:00	SPY	ETF	550.09	550.22	550.09	550.1	5409.0
2024-07-24 06:40:00	SPY	ETF	549.84	549.84	549.79	549.81	3835.0
2024-07-24 06:45:00	SPY	ETF	549.94	549.96	549.91	549.91	1250.0
2024-07-24 06:50:00	SPY	ETF	549.9	550.01	549.81	550.01	1030.0
2024-07-24 06:55:00	SPY	ETF	550.08	550.13	549.78	549.82	9810.0
2024-07-24 07:00:00	SPY	ETF	549.87	549.96	549.54	549.63	13982.0
2024-07-24 07:05:00	SPY	ETF	549.56	549.66	549.37	549.62	15479.0
2024-07-24 07:10:00	SPY	ETF	549.63	549.69	549.59	549.61	9337.0
2024-07-24 07:15:00	SPY	ETF	549.55	550.0	549.55	550.0	12068.0
2024-07-24 07:20:00	SPY	ETF	550.0	550.1	549.97	550.1	7095.0
2024-07-24 07:25:00	SPY	ETF	550.12	550.34	550.02	550.3	9177.0
2024-07-24 07:30:00	SPY	ETF	550.3	550.35	549.99	550.04	27035.0
2024-07-24 07:35:00	SPY	ETF	550.04	550.12	549.88	549.96	38828.0
2024-07-24 07:40:00	SPY	ETF	549.92	549.98	549.88	549.98	3483.0
2024-07-24 07:45:00	SPY	ETF	549.99	549.99	549.69	549.87	17498.0
2024-07-24 07:50:00	SPY	ETF	549.9	549.94	549.81	549.94	1250.0
2024-07-24 07:55:00	SPY	ETF	550.05	550.05	549.88	549.89	3553.0
2024-07-24 08:00:00	SPY	ETF	549.44	550.9	549.43	549.74	40550.0
2024-07-24 08:05:00	SPY	ETF	549.71	549.86	549.55	549.55	8418.0

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

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