PREVIEW / etf_5min / 2023-10-23

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-10-23.parquet
  size:    2.1 MB
  rows:    103,436

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-23 04:00:00	SPY	ETF	420.42	420.44	420.15	420.2	24606.0
2023-10-23 04:05:00	SPY	ETF	420.27	420.84	420.27	420.8	7728.0
2023-10-23 04:10:00	SPY	ETF	420.79	420.99	420.7	420.92	3157.0
2023-10-23 04:15:00	SPY	ETF	420.89	421.13	420.89	421.09	3094.0
2023-10-23 04:20:00	SPY	ETF	421.11	421.11	420.87	421.02	1538.0
2023-10-23 04:25:00	SPY	ETF	420.94	420.97	420.9	420.9	3514.0
2023-10-23 04:30:00	SPY	ETF	420.9	420.9	420.58	420.7	2075.0
2023-10-23 04:35:00	SPY	ETF	420.69	420.87	420.5	420.87	6131.0
2023-10-23 04:40:00	SPY	ETF	420.84	420.87	420.77	420.77	1200.0
2023-10-23 04:45:00	SPY	ETF	420.69	421.02	420.69	420.94	869.0
2023-10-23 04:50:00	SPY	ETF	420.65	420.65	420.58	420.58	2100.0
2023-10-23 04:55:00	SPY	ETF	420.78	420.81	420.5	420.52	5064.0
2023-10-23 05:00:00	SPY	ETF	420.57	420.57	420.06	420.06	4585.0
2023-10-23 05:05:00	SPY	ETF	420.15	420.17	419.82	419.92	8687.0
2023-10-23 05:10:00	SPY	ETF	419.89	419.89	419.58	419.61	10468.0
2023-10-23 05:15:00	SPY	ETF	419.67	420.06	419.66	419.94	7558.0
2023-10-23 05:20:00	SPY	ETF	419.98	419.98	419.76	419.76	5795.0
2023-10-23 05:25:00	SPY	ETF	419.74	419.75	419.26	419.26	6680.0
2023-10-23 05:30:00	SPY	ETF	419.24	419.24	418.57	418.63	20517.0
2023-10-23 05:35:00	SPY	ETF	418.74	418.78	418.4	418.4	8077.0
2023-10-23 05:40:00	SPY	ETF	418.37	418.56	418.3	418.55	12189.0
2023-10-23 05:45:00	SPY	ETF	418.4	418.4	418.1	418.17	5172.0
2023-10-23 05:50:00	SPY	ETF	418.23	418.47	418.23	418.47	9925.0
2023-10-23 05:55:00	SPY	ETF	418.43	418.53	418.1	418.19	17602.0
2023-10-23 06:00:00	SPY	ETF	418.2	418.58	418.16	418.58	17975.0
2023-10-23 06:05:00	SPY	ETF	418.67	418.72	418.51	418.7	10870.0
2023-10-23 06:10:00	SPY	ETF	418.55	418.61	418.5	418.55	2780.0
2023-10-23 06:15:00	SPY	ETF	418.5	418.83	418.5	418.55	3120.0
2023-10-23 06:20:00	SPY	ETF	418.55	418.64	418.52	418.6	2625.0
2023-10-23 06:25:00	SPY	ETF	418.64	418.64	418.57	418.6	1300.0
2023-10-23 06:30:00	SPY	ETF	418.57	418.67	418.57	418.67	904.0
2023-10-23 06:35:00	SPY	ETF	418.66	418.9	418.66	418.9	5244.0
2023-10-23 06:40:00	SPY	ETF	418.84	418.98	418.69	418.97	4561.0
2023-10-23 06:45:00	SPY	ETF	418.99	419.09	418.98	418.99	2052.0
2023-10-23 06:50:00	SPY	ETF	419.04	419.04	418.98	418.98	415.0
2023-10-23 06:55:00	SPY	ETF	419.0	419.13	418.91	419.13	6896.0
2023-10-23 07:00:00	SPY	ETF	419.16	419.26	418.9	418.93	16522.0
2023-10-23 07:05:00	SPY	ETF	419.13	419.17	418.92	418.92	7125.0
2023-10-23 07:10:00	SPY	ETF	418.95	419.22	418.95	419.07	4278.0
2023-10-23 07:15:00	SPY	ETF	419.13	419.31	419.13	419.25	4198.0
2023-10-23 07:20:00	SPY	ETF	419.27	419.27	419.08	419.13	15903.0
2023-10-23 07:25:00	SPY	ETF	419.09	419.28	418.99	419.11	10100.0
2023-10-23 07:30:00	SPY	ETF	419.23	419.23	419.0	419.23	2691.0
2023-10-23 07:35:00	SPY	ETF	419.15	419.71	419.14	419.71	24536.0
2023-10-23 07:40:00	SPY	ETF	419.67	419.94	419.6	419.93	22358.0
2023-10-23 07:45:00	SPY	ETF	419.93	419.93	419.74	419.75	17307.0
2023-10-23 07:50:00	SPY	ETF	419.68	419.76	419.66	419.69	10530.0
2023-10-23 07:55:00	SPY	ETF	419.72	419.73	419.26	419.46	38286.0
2023-10-23 08:00:00	SPY	ETF	419.1501	422.38	418.1796	419.21	93787.0
2023-10-23 08:05:00	SPY	ETF	419.22	419.3	418.99	419.05	33392.0

> showing 50 of 103,436 rows — these rows as CSV

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