PREVIEW / etf_5min / 2024-07-22

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-07-22.parquet
  size:    2.3 MB
  rows:    115,117

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-22 04:00:00	SPY	ETF	550.51	550.79	550.5	550.55	5340.0
2024-07-22 04:05:00	SPY	ETF	550.66	550.78	550.58	550.78	3201.0
2024-07-22 04:10:00	SPY	ETF	550.89	550.89	550.89	550.89	100.0
2024-07-22 04:15:00	SPY	ETF	550.95	550.98	550.78	550.94	21589.0
2024-07-22 04:20:00	SPY	ETF	550.88	551.0	550.88	551.0	843.0
2024-07-22 04:25:00	SPY	ETF	551.0	551.07	550.8	551.07	22460.0
2024-07-22 04:30:00	SPY	ETF	550.99	550.99	550.97	550.97	10896.0
2024-07-22 04:35:00	SPY	ETF	551.1	551.1	551.1	551.1	100.0
2024-07-22 04:40:00	SPY	ETF	551.19	551.34	551.17	551.27	2322.0
2024-07-22 04:45:00	SPY	ETF	551.25	551.27	551.25	551.25	4756.0
2024-07-22 04:50:00	SPY	ETF	551.25	551.25	551.25	551.25	5190.0
2024-07-22 04:55:00	SPY	ETF	551.03	551.03	550.9	550.92	20400.0
2024-07-22 05:00:00	SPY	ETF	550.84	551.05	550.82	550.96	9209.0
2024-07-22 05:05:00	SPY	ETF	551.03	551.12	551.01	551.12	2928.0
2024-07-22 05:10:00	SPY	ETF	551.05	551.05	550.94	551.03	600.0
2024-07-22 05:20:00	SPY	ETF	551.03	551.11	551.01	551.07	1837.0
2024-07-22 05:25:00	SPY	ETF	551.16	551.25	551.16	551.25	16615.0
2024-07-22 05:30:00	SPY	ETF	551.25	551.29	551.25	551.29	13787.0
2024-07-22 05:35:00	SPY	ETF	551.33	551.34	551.29	551.29	10695.0
2024-07-22 05:40:00	SPY	ETF	551.19	551.19	551.19	551.19	400.0
2024-07-22 05:45:00	SPY	ETF	551.2	551.2	551.2	551.2	1000.0
2024-07-22 05:50:00	SPY	ETF	551.32	551.37	551.32	551.35	569.0
2024-07-22 05:55:00	SPY	ETF	551.4	551.56	551.4	551.56	1400.0
2024-07-22 06:00:00	SPY	ETF	551.57	551.57	551.55	551.55	700.0
2024-07-22 06:05:00	SPY	ETF	551.63	551.65	551.63	551.65	600.0
2024-07-22 06:10:00	SPY	ETF	551.63	551.63	551.35	551.36	400.0
2024-07-22 06:15:00	SPY	ETF	551.45	551.7	551.45	551.66	1025.0
2024-07-22 06:20:00	SPY	ETF	551.79	551.79	551.79	551.79	110.0
2024-07-22 06:25:00	SPY	ETF	551.7	551.77	551.7	551.77	1182.0
2024-07-22 06:30:00	SPY	ETF	551.78	551.79	551.62	551.67	1730.0
2024-07-22 06:35:00	SPY	ETF	551.9	552.07	551.77	551.94	5340.0
2024-07-22 06:40:00	SPY	ETF	551.99	552.09	551.93	552.09	1200.0
2024-07-22 06:45:00	SPY	ETF	552.0	552.0	551.98	551.99	1990.0
2024-07-22 06:50:00	SPY	ETF	552.04	552.06	552.02	552.06	946.0
2024-07-22 06:55:00	SPY	ETF	552.07	552.09	552.02	552.09	18900.0
2024-07-22 07:00:00	SPY	ETF	552.09	552.15	551.4	551.94	185361.0
2024-07-22 07:05:00	SPY	ETF	551.95	552.1	551.88	551.89	16150.0
2024-07-22 07:10:00	SPY	ETF	551.89	551.94	551.83	551.84	52115.0
2024-07-22 07:15:00	SPY	ETF	551.85	551.98	551.81	551.88	2100.0
2024-07-22 07:20:00	SPY	ETF	551.82	551.82	551.66	551.71	4539.0
2024-07-22 07:25:00	SPY	ETF	551.68	551.73	551.68	551.71	2363.0
2024-07-22 07:30:00	SPY	ETF	551.73	551.9	551.7	551.88	21305.0
2024-07-22 07:35:00	SPY	ETF	551.9	552.0	551.87	551.95	13271.0
2024-07-22 07:40:00	SPY	ETF	552.0	552.19	552.0	552.16	22245.0
2024-07-22 07:45:00	SPY	ETF	552.14	552.23	552.03	552.08	13420.0
2024-07-22 07:50:00	SPY	ETF	552.08	552.11	552.0	552.05	26479.0
2024-07-22 07:55:00	SPY	ETF	552.07	552.11	552.07	552.07	1618.0
2024-07-22 08:00:00	SPY	ETF	552.0916	552.48	550.17	552.39	49246.0
2024-07-22 08:05:00	SPY	ETF	550.24	552.45	550.24	552.38	36107.0
2024-07-22 08:10:00	SPY	ETF	552.32	552.4	552.24	552.4	12138.0

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

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