PREVIEW / etf_5min / 2023-06-20

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-20.parquet
  size:    2.0 MB
  rows:    99,245

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-06-20 04:00:00	SPY	ETF	438.66	438.7	438.44	438.48	14277.0
2023-06-20 04:05:00	SPY	ETF	438.41	438.48	438.36	438.4	8634.0
2023-06-20 04:10:00	SPY	ETF	438.33	438.33	438.13	438.13	2918.0
2023-06-20 04:15:00	SPY	ETF	438.22	438.22	438.12	438.15	2721.0
2023-06-20 04:20:00	SPY	ETF	438.05	438.16	438.05	438.08	5569.0
2023-06-20 04:25:00	SPY	ETF	438.0	438.0	437.83	437.84	3500.0
2023-06-20 04:30:00	SPY	ETF	437.8	437.83	437.55	437.55	4346.0
2023-06-20 04:35:00	SPY	ETF	437.59	437.61	437.4	437.61	3785.0
2023-06-20 04:40:00	SPY	ETF	437.6	437.81	437.6	437.7	9620.0
2023-06-20 04:45:00	SPY	ETF	437.63	437.63	437.49	437.49	606.0
2023-06-20 04:50:00	SPY	ETF	437.41	437.41	437.22	437.22	6439.0
2023-06-20 04:55:00	SPY	ETF	437.29	437.39	437.2	437.33	3055.0
2023-06-20 05:00:00	SPY	ETF	437.29	437.37	437.29	437.37	952.0
2023-06-20 05:05:00	SPY	ETF	437.33	437.36	437.26	437.28	5292.0
2023-06-20 05:10:00	SPY	ETF	437.34	437.4	437.34	437.4	2611.0
2023-06-20 05:15:00	SPY	ETF	437.45	437.47	437.3	437.41	8306.0
2023-06-20 05:20:00	SPY	ETF	437.41	437.48	437.41	437.47	2209.0
2023-06-20 05:25:00	SPY	ETF	437.42	437.42	437.22	437.31	3988.0
2023-06-20 05:30:00	SPY	ETF	437.29	437.32	437.26	437.3	3863.0
2023-06-20 05:35:00	SPY	ETF	437.33	437.4	437.33	437.4	535.0
2023-06-20 05:40:00	SPY	ETF	437.41	437.46	437.32	437.43	1050.0
2023-06-20 05:45:00	SPY	ETF	437.48	437.48	437.48	437.48	258.0
2023-06-20 05:50:00	SPY	ETF	437.46	437.53	437.46	437.53	525.0
2023-06-20 05:55:00	SPY	ETF	437.56	437.56	437.56	437.56	100.0
2023-06-20 06:00:00	SPY	ETF	437.5	437.56	437.49	437.56	400.0
2023-06-20 06:05:00	SPY	ETF	437.57	437.75	437.55	437.75	105043.0
2023-06-20 06:10:00	SPY	ETF	437.76	437.78	437.7	437.78	3453.0
2023-06-20 06:15:00	SPY	ETF	437.68	437.68	437.57	437.6	1544.0
2023-06-20 06:20:00	SPY	ETF	437.63	437.63	437.62	437.62	439.0
2023-06-20 06:30:00	SPY	ETF	437.6	437.6	437.6	437.6	453.0
2023-06-20 06:35:00	SPY	ETF	437.54	437.59	437.46	437.57	3377.0
2023-06-20 06:40:00	SPY	ETF	437.6	437.65	437.6	437.63	3818.0
2023-06-20 06:45:00	SPY	ETF	437.67	437.67	437.6	437.6	1679.0
2023-06-20 06:50:00	SPY	ETF	437.66	437.74	437.66	437.74	1633.0
2023-06-20 06:55:00	SPY	ETF	437.72	437.81	437.72	437.81	2470.0
2023-06-20 07:00:00	SPY	ETF	437.84	437.95	437.79	437.95	11516.0
2023-06-20 07:05:00	SPY	ETF	437.9	437.94	437.88	437.94	6576.0
2023-06-20 07:10:00	SPY	ETF	437.96	437.96	437.8	437.8	5554.0
2023-06-20 07:15:00	SPY	ETF	437.81	437.9	437.72	437.88	28292.0
2023-06-20 07:20:00	SPY	ETF	437.85	437.88	437.84	437.85	8307.0
2023-06-20 07:25:00	SPY	ETF	437.83	437.86	437.79	437.79	7088.0
2023-06-20 07:30:00	SPY	ETF	437.96	437.96	437.6	437.71	12404.0
2023-06-20 07:35:00	SPY	ETF	437.73	437.81	437.71	437.81	1799.0
2023-06-20 07:40:00	SPY	ETF	437.89	438.0	437.87	438.0	6680.0
2023-06-20 07:45:00	SPY	ETF	437.98	437.98	437.83	437.83	2494.0
2023-06-20 07:50:00	SPY	ETF	437.92	438.12	437.87	438.08	13680.0
2023-06-20 07:55:00	SPY	ETF	438.07	438.12	437.96	438.0	18054.0
2023-06-20 08:00:00	SPY	ETF	437.9101	438.76	437.71	438.04	47384.0
2023-06-20 08:05:00	SPY	ETF	438.04	438.13	438.04	438.1	11242.0
2023-06-20 08:10:00	SPY	ETF	438.09	438.32	438.07	438.07	58926.0

> showing 50 of 99,245 rows — these rows as CSV

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