PREVIEW / etf_5min / 2023-10-19

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-10-19.parquet
  size:    2.1 MB
  rows:    102,518

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
2023-10-19 04:00:00	SPY	ETF	429.0	429.12	428.83	428.86	10417.0
2023-10-19 04:05:00	SPY	ETF	428.98	429.23	428.9	429.03	9269.0
2023-10-19 04:10:00	SPY	ETF	429.07	429.07	428.88	428.91	1651.0
2023-10-19 04:15:00	SPY	ETF	428.81	429.26	428.81	429.2	3075.0
2023-10-19 04:20:00	SPY	ETF	429.19	429.23	429.0	429.04	3600.0
2023-10-19 04:25:00	SPY	ETF	429.13	429.36	429.11	429.31	4650.0
2023-10-19 04:30:00	SPY	ETF	429.19	429.34	429.15	429.23	12115.0
2023-10-19 04:35:00	SPY	ETF	429.26	429.37	429.19	429.19	2550.0
2023-10-19 04:40:00	SPY	ETF	428.93	429.43	428.93	429.4	4405.0
2023-10-19 04:45:00	SPY	ETF	429.31	429.31	429.03	429.05	2368.0
2023-10-19 04:50:00	SPY	ETF	429.05	429.1	429.0	429.0	20567.0
2023-10-19 04:55:00	SPY	ETF	429.1	429.2	429.02	429.02	5400.0
2023-10-19 05:00:00	SPY	ETF	429.0	429.0	428.89	428.95	2850.0
2023-10-19 05:05:00	SPY	ETF	429.06	429.23	429.05	429.23	3230.0
2023-10-19 05:10:00	SPY	ETF	429.38	429.42	429.38	429.42	300.0
2023-10-19 05:15:00	SPY	ETF	429.37	429.37	429.2	429.2	1160.0
2023-10-19 05:20:00	SPY	ETF	429.35	429.35	429.19	429.19	1466.0
2023-10-19 05:25:00	SPY	ETF	429.32	429.36	429.29	429.36	2200.0
2023-10-19 05:30:00	SPY	ETF	429.39	429.86	429.39	429.74	12100.0
2023-10-19 05:35:00	SPY	ETF	429.77	429.87	429.77	429.86	1500.0
2023-10-19 05:40:00	SPY	ETF	429.84	429.95	429.84	429.87	4397.0
2023-10-19 05:45:00	SPY	ETF	429.89	430.0	429.77	429.77	6395.0
2023-10-19 05:50:00	SPY	ETF	429.86	430.07	429.86	430.0	7200.0
2023-10-19 05:55:00	SPY	ETF	430.03	430.21	430.03	430.18	13764.0
2023-10-19 06:00:00	SPY	ETF	430.12	430.19	430.04	430.19	5150.0
2023-10-19 06:05:00	SPY	ETF	430.23	430.36	430.2	430.31	2520.0
2023-10-19 06:10:00	SPY	ETF	430.24	430.24	430.13	430.18	1875.0
2023-10-19 06:15:00	SPY	ETF	430.26	430.35	430.26	430.29	400.0
2023-10-19 06:20:00	SPY	ETF	430.38	430.39	430.38	430.39	200.0
2023-10-19 06:25:00	SPY	ETF	430.37	430.43	430.32	430.43	2405.0
2023-10-19 06:30:00	SPY	ETF	430.53	430.71	430.53	430.66	7390.0
2023-10-19 06:35:00	SPY	ETF	430.64	430.65	430.59	430.64	853.0
2023-10-19 06:40:00	SPY	ETF	430.74	430.92	430.74	430.89	10720.0
2023-10-19 06:45:00	SPY	ETF	430.89	430.97	430.72	430.78	5837.0
2023-10-19 06:50:00	SPY	ETF	430.71	430.75	430.62	430.7	5683.0
2023-10-19 06:55:00	SPY	ETF	430.72	430.87	430.72	430.87	794.0
2023-10-19 07:00:00	SPY	ETF	430.84	430.91	430.5	430.5	52163.0
2023-10-19 07:05:00	SPY	ETF	430.47	430.47	430.16	430.23	28214.0
2023-10-19 07:10:00	SPY	ETF	430.25	430.39	430.15	430.15	19124.0
2023-10-19 07:15:00	SPY	ETF	430.24	430.29	430.04	430.04	12670.0
2023-10-19 07:20:00	SPY	ETF	430.03	430.1	430.0	430.0	17644.0
2023-10-19 07:25:00	SPY	ETF	430.0	430.01	429.91	429.98	22537.0
2023-10-19 07:30:00	SPY	ETF	430.029	430.029	429.73	429.73	25932.0
2023-10-19 07:35:00	SPY	ETF	429.75	429.79	429.61	429.73	18524.0
2023-10-19 07:40:00	SPY	ETF	429.75	430.03	429.68	429.68	28170.0
2023-10-19 07:45:00	SPY	ETF	429.69	429.96	429.66	429.88	15555.0
2023-10-19 07:50:00	SPY	ETF	429.9	429.95	429.76	429.78	12945.0
2023-10-19 07:55:00	SPY	ETF	429.73	429.9	429.63	429.86	19980.0
2023-10-19 08:00:00	SPY	ETF	430.47	430.91	428.62	429.74	72031.0
2023-10-19 08:05:00	SPY	ETF	429.79	429.95	429.7	429.78	34764.0

> showing 50 of 102,518 rows — these rows as CSV

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