PREVIEW / etf_5min / 2023-11-07

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-11-07.parquet
  size:    2.1 MB
  rows:    101,674

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-11-07 04:00:00	SPY	ETF	434.96	434.99	434.92	434.92	2385.0
2023-11-07 04:05:00	SPY	ETF	435.0	435.0	435.0	435.0	200.0
2023-11-07 04:10:00	SPY	ETF	434.9	434.93	434.8	434.8	2535.0
2023-11-07 04:15:00	SPY	ETF	434.81	434.81	434.67	434.72	1437.0
2023-11-07 04:20:00	SPY	ETF	434.58	434.6	434.58	434.6	988.0
2023-11-07 04:25:00	SPY	ETF	434.6	434.64	434.6	434.64	600.0
2023-11-07 04:30:00	SPY	ETF	434.61	434.63	434.59	434.63	1901.0
2023-11-07 04:35:00	SPY	ETF	434.7	434.8	434.7	434.8	908.0
2023-11-07 04:40:00	SPY	ETF	434.6	434.6	434.56	434.56	1600.0
2023-11-07 04:45:00	SPY	ETF	434.59	434.59	434.59	434.59	200.0
2023-11-07 04:50:00	SPY	ETF	434.52	434.52	434.49	434.51	2058.0
2023-11-07 04:55:00	SPY	ETF	434.52	434.52	434.52	434.52	200.0
2023-11-07 05:00:00	SPY	ETF	434.44	434.48	434.44	434.48	940.0
2023-11-07 05:05:00	SPY	ETF	434.41	434.43	434.41	434.43	200.0
2023-11-07 05:10:00	SPY	ETF	434.58	434.58	434.54	434.54	1432.0
2023-11-07 05:15:00	SPY	ETF	434.68	434.74	434.64	434.74	4195.0
2023-11-07 05:20:00	SPY	ETF	434.73	434.8	434.67	434.8	1118.0
2023-11-07 05:25:00	SPY	ETF	434.85	434.96	434.85	434.96	2180.0
2023-11-07 05:30:00	SPY	ETF	434.98	434.98	434.85	434.85	1000.0
2023-11-07 05:35:00	SPY	ETF	434.81	434.81	434.76	434.76	500.0
2023-11-07 05:45:00	SPY	ETF	434.78	434.9	434.78	434.9	700.0
2023-11-07 05:50:00	SPY	ETF	434.85	434.85	434.73	434.73	869.0
2023-11-07 05:55:00	SPY	ETF	434.83	434.83	434.73	434.73	813.0
2023-11-07 06:05:00	SPY	ETF	434.71	434.72	434.61	434.63	811.0
2023-11-07 06:10:00	SPY	ETF	434.61	434.61	434.61	434.61	700.0
2023-11-07 06:15:00	SPY	ETF	434.53	434.54	434.5	434.54	2093.0
2023-11-07 06:20:00	SPY	ETF	434.57	434.59	434.57	434.59	575.0
2023-11-07 06:25:00	SPY	ETF	434.55	434.55	434.44	434.44	21234.0
2023-11-07 06:30:00	SPY	ETF	434.44	434.44	434.32	434.35	81047.0
2023-11-07 06:35:00	SPY	ETF	434.3	434.3	434.0	434.0	3700.0
2023-11-07 06:40:00	SPY	ETF	434.11	434.14	433.94	433.94	1397.0
2023-11-07 06:45:00	SPY	ETF	434.12	434.18	434.12	434.15	3215.0
2023-11-07 06:50:00	SPY	ETF	434.13	434.22	434.09	434.22	23809.0
2023-11-07 06:55:00	SPY	ETF	434.25	434.36	434.25	434.36	14819.0
2023-11-07 07:00:00	SPY	ETF	434.4	434.5	434.36	434.5	17398.0
2023-11-07 07:05:00	SPY	ETF	434.56	434.58	434.38	434.48	18949.0
2023-11-07 07:10:00	SPY	ETF	434.5	434.61	434.5	434.58	2193.0
2023-11-07 07:15:00	SPY	ETF	434.6	434.77	434.59	434.76	14021.0
2023-11-07 07:20:00	SPY	ETF	434.75	434.76	434.6	434.6	32999.0
2023-11-07 07:25:00	SPY	ETF	434.65	434.69	434.56	434.56	6386.0
2023-11-07 07:30:00	SPY	ETF	434.57	434.71	434.57	434.58	11099.0
2023-11-07 07:35:00	SPY	ETF	434.55	434.57	434.43	434.44	7839.0
2023-11-07 07:40:00	SPY	ETF	434.46	434.49	434.34	434.49	12566.0
2023-11-07 07:45:00	SPY	ETF	434.5	434.61	434.43	434.61	114335.0
2023-11-07 07:50:00	SPY	ETF	434.6	434.6	434.48	434.53	4404.0
2023-11-07 07:55:00	SPY	ETF	434.54	434.76	434.54	434.76	11367.0
2023-11-07 08:00:00	SPY	ETF	434.6	435.0	434.15	434.74	53221.0
2023-11-07 08:05:00	SPY	ETF	434.75	435.2	434.67	435.15	45974.0
2023-11-07 08:10:00	SPY	ETF	435.17	435.17	434.94	434.96	54836.0
2023-11-07 08:15:00	SPY	ETF	434.96	435.06	434.87	435.06	12947.0

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

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