PREVIEW / etf_5min / 2023-11-17

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-11-17.parquet
  size:    2.1 MB
  rows:    100,664

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-17 04:00:00	SPY	ETF	451.12	451.27	450.98	451.27	6169.0
2023-11-17 04:05:00	SPY	ETF	451.24	451.46	451.22	451.31	5234.0
2023-11-17 04:10:00	SPY	ETF	451.34	451.48	451.31	451.46	3484.0
2023-11-17 04:15:00	SPY	ETF	451.53	451.53	451.32	451.32	22385.0
2023-11-17 04:20:00	SPY	ETF	451.38	451.38	451.09	451.09	4684.0
2023-11-17 04:25:00	SPY	ETF	451.1	451.11	450.94	451.11	5062.0
2023-11-17 04:30:00	SPY	ETF	451.07	451.2	451.07	451.09	3234.0
2023-11-17 04:35:00	SPY	ETF	451.15	451.19	451.09	451.09	1372.0
2023-11-17 04:40:00	SPY	ETF	451.12	451.14	451.12	451.14	400.0
2023-11-17 04:45:00	SPY	ETF	451.2	451.2	451.2	451.2	1906.0
2023-11-17 04:50:00	SPY	ETF	451.12	451.22	451.12	451.22	1927.0
2023-11-17 04:55:00	SPY	ETF	451.01	451.01	451.01	451.01	309.0
2023-11-17 05:00:00	SPY	ETF	451.0	451.19	451.0	451.19	688.0
2023-11-17 05:05:00	SPY	ETF	451.12	451.18	451.12	451.18	970.0
2023-11-17 05:10:00	SPY	ETF	451.31	451.31	451.31	451.31	564.0
2023-11-17 05:15:00	SPY	ETF	451.27	451.27	451.27	451.27	200.0
2023-11-17 05:20:00	SPY	ETF	451.31	451.31	451.31	451.31	200.0
2023-11-17 05:25:00	SPY	ETF	451.4	451.5	451.4	451.5	902.0
2023-11-17 05:30:00	SPY	ETF	451.46	451.46	451.46	451.46	100.0
2023-11-17 05:35:00	SPY	ETF	451.43	451.43	451.43	451.43	213.0
2023-11-17 05:40:00	SPY	ETF	451.47	451.47	451.47	451.47	838.0
2023-11-17 05:45:00	SPY	ETF	451.47	451.47	451.47	451.47	200.0
2023-11-17 05:50:00	SPY	ETF	451.55	451.62	451.54	451.62	1141.0
2023-11-17 05:55:00	SPY	ETF	451.47	451.49	451.47	451.49	200.0
2023-11-17 06:00:00	SPY	ETF	451.4	451.4	451.13	451.13	1374.0
2023-11-17 06:05:00	SPY	ETF	451.2	451.37	451.2	451.37	600.0
2023-11-17 06:10:00	SPY	ETF	451.36	451.4	451.3	451.3	782.0
2023-11-17 06:20:00	SPY	ETF	451.3	451.3	451.2	451.2	531.0
2023-11-17 06:25:00	SPY	ETF	451.21	451.21	451.21	451.21	1300.0
2023-11-17 06:30:00	SPY	ETF	451.26	451.26	451.26	451.26	129.0
2023-11-17 06:35:00	SPY	ETF	451.2	451.24	451.18	451.24	1354.0
2023-11-17 06:40:00	SPY	ETF	451.11	451.11	451.01	451.06	1746.0
2023-11-17 06:50:00	SPY	ETF	451.19	451.31	451.19	451.3	888.0
2023-11-17 06:55:00	SPY	ETF	451.26	451.35	451.26	451.3	702.0
2023-11-17 07:00:00	SPY	ETF	451.31	451.48	451.27	451.48	16097.0
2023-11-17 07:05:00	SPY	ETF	451.49	451.49	451.46	451.46	230.0
2023-11-17 07:10:00	SPY	ETF	451.24	451.24	451.2	451.22	1100.0
2023-11-17 07:15:00	SPY	ETF	451.22	451.31	451.18	451.25	6560.0
2023-11-17 07:20:00	SPY	ETF	451.31	451.31	451.15	451.22	2121.0
2023-11-17 07:25:00	SPY	ETF	451.25	451.33	451.24	451.33	25598.0
2023-11-17 07:30:00	SPY	ETF	451.35	451.48	451.35	451.4	59011.0
2023-11-17 07:35:00	SPY	ETF	451.44	451.5	451.44	451.49	2644.0
2023-11-17 07:40:00	SPY	ETF	451.51	451.67	451.51	451.62	9402.0
2023-11-17 07:45:00	SPY	ETF	451.66	451.66	451.5	451.5	41789.0
2023-11-17 07:50:00	SPY	ETF	451.55	451.55	451.49	451.49	5340.0
2023-11-17 07:55:00	SPY	ETF	451.5	451.5	451.33	451.35	10579.0
2023-11-17 08:00:00	SPY	ETF	451.2614	451.66	450.45	451.61	66954.0
2023-11-17 08:05:00	SPY	ETF	451.63	451.78	451.62	451.78	20161.0
2023-11-17 08:10:00	SPY	ETF	451.78	451.9	451.72	451.84	19391.0
2023-11-17 08:15:00	SPY	ETF	451.82	451.82	451.7	451.71	10201.0

> showing 50 of 100,664 rows — these rows as CSV

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