PREVIEW / etf_5min / 2024-03-27

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-03-27.parquet
  size:    2.2 MB
  rows:    109,104

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-03-27 04:00:00	SPY	ETF	520.32	520.45	520.32	520.38	5609.0
2024-03-27 04:05:00	SPY	ETF	520.45	520.49	520.3	520.47	6503.0
2024-03-27 04:10:00	SPY	ETF	520.53	520.56	520.35	520.35	3305.0
2024-03-27 04:15:00	SPY	ETF	520.4	520.63	520.4	520.63	4032.0
2024-03-27 04:20:00	SPY	ETF	520.61	520.68	520.58	520.67	2000.0
2024-03-27 04:25:00	SPY	ETF	520.7	520.79	520.66	520.66	4385.0
2024-03-27 04:30:00	SPY	ETF	520.72	520.76	520.69	520.69	1800.0
2024-03-27 04:35:00	SPY	ETF	520.67	520.67	520.57	520.61	3093.0
2024-03-27 04:40:00	SPY	ETF	520.63	520.7	520.63	520.7	1300.0
2024-03-27 04:45:00	SPY	ETF	520.68	520.74	520.67	520.71	2255.0
2024-03-27 04:50:00	SPY	ETF	520.75	520.77	520.75	520.77	1499.0
2024-03-27 04:55:00	SPY	ETF	520.86	520.86	520.66	520.66	397.0
2024-03-27 05:00:00	SPY	ETF	520.82	520.89	520.82	520.89	550.0
2024-03-27 05:05:00	SPY	ETF	520.89	520.89	520.84	520.84	300.0
2024-03-27 05:10:00	SPY	ETF	520.94	520.94	520.83	520.85	1598.0
2024-03-27 05:15:00	SPY	ETF	520.81	520.85	520.8	520.8	750.0
2024-03-27 05:20:00	SPY	ETF	520.77	520.77	520.77	520.77	100.0
2024-03-27 05:25:00	SPY	ETF	520.72	520.72	520.72	520.72	176.0
2024-03-27 05:35:00	SPY	ETF	520.62	520.62	520.51	520.54	1800.0
2024-03-27 05:40:00	SPY	ETF	520.6	520.76	520.6	520.72	400.0
2024-03-27 05:45:00	SPY	ETF	520.9	520.92	520.8	520.8	2450.0
2024-03-27 05:50:00	SPY	ETF	520.81	520.94	520.81	520.9	800.0
2024-03-27 05:55:00	SPY	ETF	520.87	520.87	520.87	520.87	300.0
2024-03-27 06:00:00	SPY	ETF	520.94	520.95	520.94	520.95	1300.0
2024-03-27 06:05:00	SPY	ETF	520.91	520.91	520.75	520.75	1000.0
2024-03-27 06:10:00	SPY	ETF	520.75	520.78	520.75	520.77	700.0
2024-03-27 06:15:00	SPY	ETF	520.81	521.0	520.81	520.95	6400.0
2024-03-27 06:20:00	SPY	ETF	521.02	521.19	521.02	521.19	8488.0
2024-03-27 06:25:00	SPY	ETF	521.15	521.15	521.13	521.13	700.0
2024-03-27 06:30:00	SPY	ETF	521.15	521.23	521.15	521.23	731.0
2024-03-27 06:35:00	SPY	ETF	521.24	521.26	521.2	521.26	6335.0
2024-03-27 06:40:00	SPY	ETF	521.19	521.19	521.14	521.14	2886.0
2024-03-27 06:45:00	SPY	ETF	521.17	521.3	521.17	521.3	2842.0
2024-03-27 06:50:00	SPY	ETF	521.3	521.36	521.24	521.24	3028.0
2024-03-27 06:55:00	SPY	ETF	521.27	521.28	521.27	521.27	2000.0
2024-03-27 07:00:00	SPY	ETF	521.24	521.29	520.36	521.06	166229.0
2024-03-27 07:05:00	SPY	ETF	521.05	521.09	521.01	521.05	17390.0
2024-03-27 07:10:00	SPY	ETF	521.05	521.13	521.03	521.071	15072.0
2024-03-27 07:15:00	SPY	ETF	521.07	521.19	521.01	521.1	13090.0
2024-03-27 07:20:00	SPY	ETF	521.11	521.14	521.11	521.14	4300.0
2024-03-27 07:25:00	SPY	ETF	521.15	521.19	521.11	521.17	5550.0
2024-03-27 07:30:00	SPY	ETF	521.19	521.25	521.18	521.22	25188.0
2024-03-27 07:35:00	SPY	ETF	521.22	521.23	521.09	521.1	26331.0
2024-03-27 07:40:00	SPY	ETF	521.111	521.111	521.01	521.051	1922.0
2024-03-27 07:45:00	SPY	ETF	521.031	521.09	521.02	521.09	3677.0
2024-03-27 07:50:00	SPY	ETF	521.04	521.04	520.95	520.98	3860.0
2024-03-27 07:55:00	SPY	ETF	520.92	520.95	520.86	520.91	19434.0
2024-03-27 08:00:00	SPY	ETF	520.93	521.31	520.3	520.75	103384.0
2024-03-27 08:05:00	SPY	ETF	520.76	520.95	520.76	520.89	11267.0
2024-03-27 08:10:00	SPY	ETF	520.9	521.01	520.87	520.88	27507.0

> showing 50 of 109,104 rows — these rows as CSV

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