PREVIEW / etf_5min / 2023-12-19

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-12-19.parquet
  size:    2.3 MB
  rows:    110,874

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-12-19 04:00:00	SPY	ETF	472.43	472.47	472.38	472.42	3773.0
2023-12-19 04:05:00	SPY	ETF	472.41	472.49	472.41	472.49	3509.0
2023-12-19 04:10:00	SPY	ETF	472.45	472.54	472.45	472.54	944.0
2023-12-19 04:15:00	SPY	ETF	472.55	472.55	472.55	472.55	100.0
2023-12-19 04:20:00	SPY	ETF	472.62	472.62	472.62	472.62	118.0
2023-12-19 04:25:00	SPY	ETF	472.55	472.57	472.55	472.57	900.0
2023-12-19 04:30:00	SPY	ETF	472.55	472.55	472.5	472.5	1038.0
2023-12-19 04:35:00	SPY	ETF	472.5	472.5	472.5	472.5	100.0
2023-12-19 04:40:00	SPY	ETF	472.5	472.5	472.5	472.5	500.0
2023-12-19 04:45:00	SPY	ETF	472.42	472.43	472.41	472.41	1545.0
2023-12-19 04:50:00	SPY	ETF	472.48	472.48	472.48	472.48	813.0
2023-12-19 04:55:00	SPY	ETF	472.44	472.44	472.44	472.44	900.0
2023-12-19 05:00:00	SPY	ETF	472.48	472.48	472.48	472.48	100.0
2023-12-19 05:10:00	SPY	ETF	472.41	472.47	472.41	472.47	1600.0
2023-12-19 05:15:00	SPY	ETF	472.39	472.39	472.39	472.39	100.0
2023-12-19 05:20:00	SPY	ETF	472.4	472.4	472.4	472.4	300.0
2023-12-19 05:30:00	SPY	ETF	472.4	472.4	472.4	472.4	400.0
2023-12-19 05:35:00	SPY	ETF	472.43	472.44	472.43	472.44	573.0
2023-12-19 05:50:00	SPY	ETF	472.49	472.49	472.49	472.49	709.0
2023-12-19 05:55:00	SPY	ETF	472.33	472.33	472.33	472.33	100.0
2023-12-19 06:05:00	SPY	ETF	472.42	472.42	472.42	472.42	100.0
2023-12-19 06:15:00	SPY	ETF	472.4	472.4	472.4	472.4	300.0
2023-12-19 06:20:00	SPY	ETF	472.4	472.42	472.4	472.41	1600.0
2023-12-19 06:25:00	SPY	ETF	472.46	472.59	472.46	472.59	7448.0
2023-12-19 06:30:00	SPY	ETF	472.51	472.56	472.5	472.56	1029.0
2023-12-19 06:35:00	SPY	ETF	472.51	472.51	472.51	472.51	500.0
2023-12-19 06:40:00	SPY	ETF	472.59	472.6	472.56	472.6	2800.0
2023-12-19 06:45:00	SPY	ETF	472.62	472.62	472.55	472.55	246.0
2023-12-19 06:50:00	SPY	ETF	472.58	472.65	472.56	472.62	11601.0
2023-12-19 06:55:00	SPY	ETF	472.62	472.62	472.53	472.54	1998.0
2023-12-19 07:00:00	SPY	ETF	472.5	472.53	472.5	472.52	2267.0
2023-12-19 07:05:00	SPY	ETF	472.54	472.54	472.5	472.5	481.0
2023-12-19 07:10:00	SPY	ETF	472.51	472.75	472.51	472.75	21143.0
2023-12-19 07:15:00	SPY	ETF	472.75	473.11	472.75	473.039	19800.0
2023-12-19 07:20:00	SPY	ETF	472.88	472.95	472.8	472.86	9413.0
2023-12-19 07:25:00	SPY	ETF	472.85	472.86	472.75	472.78	6503.0
2023-12-19 07:30:00	SPY	ETF	472.751	472.79	472.71	472.71	16438.0
2023-12-19 07:35:00	SPY	ETF	472.67	472.78	472.66	472.78	7599.0
2023-12-19 07:40:00	SPY	ETF	472.79	472.88	472.79	472.88	8405.0
2023-12-19 07:45:00	SPY	ETF	472.87	472.9	472.82	472.9	8698.0
2023-12-19 07:50:00	SPY	ETF	472.95	473.06	472.95	473.04	12606.0
2023-12-19 07:55:00	SPY	ETF	473.02	473.17	473.02	473.12	10184.0
2023-12-19 08:00:00	SPY	ETF	472.5206	473.19	472.13	473.09	103949.0
2023-12-19 08:05:00	SPY	ETF	473.0646	473.13	473.0646	473.11	3816.0
2023-12-19 08:10:00	SPY	ETF	473.12	473.205	473.09	473.16	15934.0
2023-12-19 08:15:00	SPY	ETF	473.16	473.22	473.14	473.17	7332.0
2023-12-19 08:20:00	SPY	ETF	473.185	473.215	473.09	473.09	9486.0
2023-12-19 08:25:00	SPY	ETF	473.1	473.19	473.06	473.19	9664.0
2023-12-19 08:30:00	SPY	ETF	473.06	473.13	472.83	472.9	50482.0
2023-12-19 08:35:00	SPY	ETF	472.94	473.03	472.89	472.93	12090.0

> showing 50 of 110,874 rows — these rows as CSV

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