PREVIEW / etf_5min / 2023-01-09

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-09.parquet
  size:    2.1 MB
  rows:    101,577

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-01-09 04:00:00	SPY	ETF	388.37	388.82	388.37	388.82	4732.0
2023-01-09 04:05:00	SPY	ETF	388.9	388.9	388.73	388.73	3986.0
2023-01-09 04:10:00	SPY	ETF	388.89	389.0	388.89	388.9	500.0
2023-01-09 04:15:00	SPY	ETF	388.94	389.18	388.94	389.18	1687.0
2023-01-09 04:20:00	SPY	ETF	389.25	389.29	389.19	389.23	3500.0
2023-01-09 04:25:00	SPY	ETF	389.46	389.55	389.28	389.32	3705.0
2023-01-09 04:30:00	SPY	ETF	389.34	389.48	389.29	389.4	2200.0
2023-01-09 04:35:00	SPY	ETF	389.37	389.54	389.37	389.5	5900.0
2023-01-09 04:40:00	SPY	ETF	389.5	389.78	389.5	389.78	834.0
2023-01-09 04:45:00	SPY	ETF	389.79	389.8	389.63	389.73	11400.0
2023-01-09 04:50:00	SPY	ETF	389.58	389.58	389.44	389.44	2900.0
2023-01-09 04:55:00	SPY	ETF	389.4	389.4	389.4	389.4	600.0
2023-01-09 05:00:00	SPY	ETF	389.35	389.35	389.31	389.34	2098.0
2023-01-09 05:05:00	SPY	ETF	389.35	389.5	389.33	389.47	7277.0
2023-01-09 05:10:00	SPY	ETF	389.45	389.69	389.45	389.66	4346.0
2023-01-09 05:15:00	SPY	ETF	389.55	389.8	389.51	389.8	4561.0
2023-01-09 05:20:00	SPY	ETF	389.78	389.88	389.78	389.8	2175.0
2023-01-09 05:25:00	SPY	ETF	389.77	389.9	389.7	389.72	2422.0
2023-01-09 05:30:00	SPY	ETF	389.74	389.74	389.45	389.49	8341.0
2023-01-09 05:35:00	SPY	ETF	389.55	389.55	389.39	389.41	829.0
2023-01-09 05:45:00	SPY	ETF	389.49	389.5	389.49	389.5	1600.0
2023-01-09 05:50:00	SPY	ETF	389.44	389.5	389.44	389.5	499.0
2023-01-09 05:55:00	SPY	ETF	389.68	389.68	389.68	389.68	140.0
2023-01-09 06:00:00	SPY	ETF	389.65	389.8	389.65	389.8	300.0
2023-01-09 06:05:00	SPY	ETF	389.55	389.63	389.55	389.55	850.0
2023-01-09 06:10:00	SPY	ETF	389.5	389.62	389.48	389.62	750.0
2023-01-09 06:15:00	SPY	ETF	389.58	389.63	389.5	389.5	8100.0
2023-01-09 06:20:00	SPY	ETF	389.28	389.32	389.28	389.32	249.0
2023-01-09 06:25:00	SPY	ETF	389.33	389.41	389.33	389.4	4201.0
2023-01-09 06:30:00	SPY	ETF	389.32	389.32	389.32	389.32	100.0
2023-01-09 06:35:00	SPY	ETF	389.45	389.5	389.37	389.37	2416.0
2023-01-09 06:40:00	SPY	ETF	389.35	389.44	389.3	389.44	1720.0
2023-01-09 06:45:00	SPY	ETF	389.4	389.4	389.32	389.4	1326.0
2023-01-09 06:50:00	SPY	ETF	389.37	389.46	389.37	389.46	1000.0
2023-01-09 06:55:00	SPY	ETF	389.47	389.47	389.22	389.31	4514.0
2023-01-09 07:00:00	SPY	ETF	389.3	389.63	389.3	389.62	13929.0
2023-01-09 07:05:00	SPY	ETF	389.57	389.62	389.54	389.61	21940.0
2023-01-09 07:10:00	SPY	ETF	389.59	389.73	389.55	389.61	43729.0
2023-01-09 07:15:00	SPY	ETF	389.61	389.65	389.5	389.58	49839.0
2023-01-09 07:20:00	SPY	ETF	389.52	389.64	389.46	389.53	13706.0
2023-01-09 07:25:00	SPY	ETF	389.54	389.56	389.51	389.52	964.0
2023-01-09 07:30:00	SPY	ETF	389.57	390.03	389.57	389.83	12276.0
2023-01-09 07:35:00	SPY	ETF	389.87	390.05	389.87	389.95	12537.0
2023-01-09 07:40:00	SPY	ETF	389.93	389.93	389.72	389.79	16781.0
2023-01-09 07:45:00	SPY	ETF	389.78	389.9	389.69	389.69	4883.0
2023-01-09 07:50:00	SPY	ETF	389.71	389.71	389.54	389.63	11045.0
2023-01-09 07:55:00	SPY	ETF	389.69	389.72	389.63	389.65	100137.0
2023-01-09 08:00:00	SPY	ETF	389.5	390.05	388.5	389.31	35765.0
2023-01-09 08:05:00	SPY	ETF	389.3	389.33	389.07	389.16	21875.0
2023-01-09 08:10:00	SPY	ETF	389.15	389.3	389.15	389.2	13189.0

> showing 50 of 101,577 rows — these rows as CSV

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