PREVIEW / etf_5min / 2023-10-05

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-10-05.parquet
  size:    2.0 MB
  rows:    98,545

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-05 04:00:00	SPY	ETF	424.06	424.56	423.75	424.55	8993.0
2023-10-05 04:05:00	SPY	ETF	424.45	424.45	424.31	424.34	1248.0
2023-10-05 04:10:00	SPY	ETF	424.5	424.5	424.48	424.5	1100.0
2023-10-05 04:15:00	SPY	ETF	424.31	424.64	424.3	424.56	3393.0
2023-10-05 04:20:00	SPY	ETF	424.5	424.76	424.5	424.74	4984.0
2023-10-05 04:25:00	SPY	ETF	424.75	424.75	424.59	424.75	1600.0
2023-10-05 04:30:00	SPY	ETF	424.55	424.82	424.55	424.8	1408.0
2023-10-05 04:35:00	SPY	ETF	424.62	424.67	424.62	424.67	815.0
2023-10-05 04:40:00	SPY	ETF	424.5	424.5	424.42	424.42	200.0
2023-10-05 04:45:00	SPY	ETF	424.3	424.3	424.12	424.12	484.0
2023-10-05 04:50:00	SPY	ETF	424.02	424.1	423.78	423.78	1190.0
2023-10-05 04:55:00	SPY	ETF	423.75	423.75	423.66	423.71	564.0
2023-10-05 05:00:00	SPY	ETF	423.6	423.6	423.55	423.55	1736.0
2023-10-05 05:05:00	SPY	ETF	423.47	423.57	423.43	423.57	1200.0
2023-10-05 05:10:00	SPY	ETF	423.74	423.74	423.74	423.74	100.0
2023-10-05 05:15:00	SPY	ETF	423.32	423.32	423.22	423.22	815.0
2023-10-05 05:20:00	SPY	ETF	423.34	423.62	423.32	423.49	1144.0
2023-10-05 05:25:00	SPY	ETF	423.37	423.37	423.37	423.37	188.0
2023-10-05 05:30:00	SPY	ETF	423.55	423.55	423.54	423.54	1009.0
2023-10-05 05:35:00	SPY	ETF	423.41	423.43	423.38	423.43	660.0
2023-10-05 05:40:00	SPY	ETF	423.26	423.26	423.21	423.26	2327.0
2023-10-05 05:45:00	SPY	ETF	423.39	423.39	423.33	423.33	720.0
2023-10-05 05:50:00	SPY	ETF	423.5	423.5	423.5	423.5	135.0
2023-10-05 05:55:00	SPY	ETF	423.65	423.68	423.6	423.6	2920.0
2023-10-05 06:00:00	SPY	ETF	423.47	423.47	423.47	423.47	500.0
2023-10-05 06:05:00	SPY	ETF	423.71	423.74	423.71	423.72	500.0
2023-10-05 06:10:00	SPY	ETF	423.87	424.08	423.87	424.08	1728.0
2023-10-05 06:15:00	SPY	ETF	424.08	424.08	424.04	424.04	1161.0
2023-10-05 06:20:00	SPY	ETF	423.9	423.92	423.89	423.92	1648.0
2023-10-05 06:25:00	SPY	ETF	423.99	424.25	423.99	424.13	2973.0
2023-10-05 06:30:00	SPY	ETF	424.18	424.3	424.18	424.3	3422.0
2023-10-05 06:35:00	SPY	ETF	424.37	424.65	424.37	424.6	1906.0
2023-10-05 06:40:00	SPY	ETF	424.48	424.48	424.48	424.48	300.0
2023-10-05 06:45:00	SPY	ETF	424.47	424.47	424.29	424.3	4495.0
2023-10-05 06:50:00	SPY	ETF	424.18	424.26	424.18	424.26	10100.0
2023-10-05 06:55:00	SPY	ETF	424.25	424.53	424.25	424.53	3455.0
2023-10-05 07:00:00	SPY	ETF	424.48	424.73	424.44	424.59	10346.0
2023-10-05 07:05:00	SPY	ETF	424.39	424.39	424.17	424.22	8369.0
2023-10-05 07:10:00	SPY	ETF	424.22	424.37	424.2	424.27	22629.0
2023-10-05 07:15:00	SPY	ETF	424.24	424.32	424.0	424.04	19807.0
2023-10-05 07:20:00	SPY	ETF	424.01	424.42	424.01	424.4	50363.0
2023-10-05 07:25:00	SPY	ETF	424.37	424.52	424.34	424.52	28669.0
2023-10-05 07:30:00	SPY	ETF	424.5	424.77	424.5	424.57	20794.0
2023-10-05 07:35:00	SPY	ETF	424.57	424.9	424.53	424.79	18882.0
2023-10-05 07:40:00	SPY	ETF	424.79	425.05	424.78	425.03	31554.0
2023-10-05 07:45:00	SPY	ETF	424.98	425.11	424.94	425.11	21301.0
2023-10-05 07:50:00	SPY	ETF	425.07	425.07	424.82	424.9	12899.0
2023-10-05 07:55:00	SPY	ETF	424.92	425.1	424.92	425.05	15887.0
2023-10-05 08:00:00	SPY	ETF	424.93	425.39	423.73	425.39	43777.0
2023-10-05 08:05:00	SPY	ETF	425.4	425.45	425.07	425.12	28983.0

> showing 50 of 98,545 rows — these rows as CSV

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