PREVIEW / etf_5min / 2023-12-18

all etf 5-min files

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

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-18 04:00:00	SPY	ETF	470.61	470.62	470.41	470.46	6099.0
2023-12-18 04:05:00	SPY	ETF	470.46	470.61	470.46	470.61	400.0
2023-12-18 04:10:00	SPY	ETF	470.65	470.67	470.63	470.67	1251.0
2023-12-18 04:15:00	SPY	ETF	470.51	470.51	470.46	470.46	300.0
2023-12-18 04:20:00	SPY	ETF	470.45	470.57	470.45	470.52	814.0
2023-12-18 04:25:00	SPY	ETF	470.74	470.74	470.74	470.74	100.0
2023-12-18 04:30:00	SPY	ETF	470.76	470.76	470.66	470.73	1982.0
2023-12-18 04:45:00	SPY	ETF	470.74	470.74	470.33	470.67	15156.0
2023-12-18 04:50:00	SPY	ETF	470.72	470.72	470.72	470.72	100.0
2023-12-18 04:55:00	SPY	ETF	470.68	470.68	470.63	470.63	339.0
2023-12-18 05:05:00	SPY	ETF	470.61	470.61	470.54	470.6	3784.0
2023-12-18 05:10:00	SPY	ETF	470.54	470.54	470.53	470.54	2697.0
2023-12-18 05:20:00	SPY	ETF	470.72	470.8	470.72	470.8	400.0
2023-12-18 05:25:00	SPY	ETF	470.7	470.7	470.7	470.7	200.0
2023-12-18 05:30:00	SPY	ETF	470.78	470.88	470.78	470.88	300.0
2023-12-18 05:35:00	SPY	ETF	470.7	470.7	470.7	470.7	300.0
2023-12-18 05:40:00	SPY	ETF	470.55	470.55	470.55	470.55	100.0
2023-12-18 05:45:00	SPY	ETF	470.46	470.46	470.46	470.46	159.0
2023-12-18 05:50:00	SPY	ETF	470.55	470.56	470.55	470.56	600.0
2023-12-18 05:55:00	SPY	ETF	470.55	470.55	470.52	470.52	600.0
2023-12-18 06:00:00	SPY	ETF	470.47	470.47	470.47	470.47	300.0
2023-12-18 06:05:00	SPY	ETF	470.57	470.57	470.52	470.54	800.0
2023-12-18 06:10:00	SPY	ETF	470.49	470.49	470.49	470.49	100.0
2023-12-18 06:15:00	SPY	ETF	470.52	470.61	470.52	470.61	1020.0
2023-12-18 06:20:00	SPY	ETF	470.74	470.74	470.69	470.69	922.0
2023-12-18 06:25:00	SPY	ETF	470.69	470.69	470.45	470.45	453.0
2023-12-18 06:35:00	SPY	ETF	470.33	470.35	470.31	470.31	835.0
2023-12-18 06:40:00	SPY	ETF	470.36	470.36	470.22	470.22	1985.0
2023-12-18 06:45:00	SPY	ETF	470.22	470.26	470.15	470.15	2492.0
2023-12-18 06:50:00	SPY	ETF	470.2	470.29	470.2	470.29	900.0
2023-12-18 06:55:00	SPY	ETF	470.16	470.32	470.12	470.24	7607.0
2023-12-18 07:00:00	SPY	ETF	470.24	470.45	470.24	470.45	10145.0
2023-12-18 07:05:00	SPY	ETF	470.45	470.53	470.42	470.53	35981.0
2023-12-18 07:10:00	SPY	ETF	470.55	470.69	470.55	470.69	3322.0
2023-12-18 07:15:00	SPY	ETF	470.7	470.7	470.57	470.6	1377.0
2023-12-18 07:20:00	SPY	ETF	470.6	470.66	470.59	470.65	9291.0
2023-12-18 07:25:00	SPY	ETF	470.59	470.64	470.54	470.59	1010.0
2023-12-18 07:30:00	SPY	ETF	470.6	470.6	470.55	470.57	400.0
2023-12-18 07:35:00	SPY	ETF	470.53	470.56	470.53	470.54	8082.0
2023-12-18 07:40:00	SPY	ETF	470.57	470.57	470.55	470.55	3034.0
2023-12-18 07:45:00	SPY	ETF	470.529	470.529	470.45	470.45	2436.0
2023-12-18 07:50:00	SPY	ETF	470.53	470.54	470.471	470.52	1715.0
2023-12-18 07:55:00	SPY	ETF	470.55	470.75	470.55	470.75	3787.0
2023-12-18 08:00:00	SPY	ETF	470.2697	470.97	470.01	470.75	104505.0
2023-12-18 08:05:00	SPY	ETF	470.72	470.72	470.47	470.58	4484.0
2023-12-18 08:10:00	SPY	ETF	470.56	470.75	470.56	470.7	10350.0
2023-12-18 08:15:00	SPY	ETF	470.7	470.7	470.59	470.61	8644.0
2023-12-18 08:20:00	SPY	ETF	470.66	470.85	470.66	470.82	11317.0
2023-12-18 08:25:00	SPY	ETF	470.81	470.84	470.68	470.79	8758.0
2023-12-18 08:30:00	SPY	ETF	470.75	470.93	470.74	470.81	28845.0

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

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