PREVIEW / etf_5min / 2023-05-04

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-04.parquet
  size:    2.0 MB
  rows:    97,986

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-05-04 04:00:00	SPY	ETF	408.73	408.77	408.33	408.69	13385.0
2023-05-04 04:05:00	SPY	ETF	408.55	408.55	408.27	408.28	13787.0
2023-05-04 04:10:00	SPY	ETF	408.15	408.22	408.07	408.22	3015.0
2023-05-04 04:15:00	SPY	ETF	408.31	408.6	408.24	408.6	4107.0
2023-05-04 04:20:00	SPY	ETF	408.68	408.68	408.3	408.39	1100.0
2023-05-04 04:25:00	SPY	ETF	408.36	408.4	408.35	408.35	1333.0
2023-05-04 04:30:00	SPY	ETF	408.27	408.27	408.11	408.12	5000.0
2023-05-04 04:35:00	SPY	ETF	408.31	408.32	407.95	407.95	3486.0
2023-05-04 04:40:00	SPY	ETF	408.2	408.3	408.2	408.3	870.0
2023-05-04 04:45:00	SPY	ETF	408.21	408.21	408.13	408.15	4525.0
2023-05-04 04:50:00	SPY	ETF	408.06	408.2	408.06	408.14	4355.0
2023-05-04 04:55:00	SPY	ETF	408.09	408.09	407.85	407.92	1516.0
2023-05-04 05:00:00	SPY	ETF	408.2	408.33	408.2	408.33	1632.0
2023-05-04 05:05:00	SPY	ETF	408.17	408.17	408.06	408.1	4121.0
2023-05-04 05:10:00	SPY	ETF	407.98	407.98	407.98	407.98	100.0
2023-05-04 05:15:00	SPY	ETF	407.87	407.87	407.82	407.82	1821.0
2023-05-04 05:20:00	SPY	ETF	407.96	407.96	407.86	407.86	2000.0
2023-05-04 05:25:00	SPY	ETF	407.97	408.06	407.97	408.02	1663.0
2023-05-04 05:30:00	SPY	ETF	408.0	408.0	407.85	407.85	351.0
2023-05-04 05:35:00	SPY	ETF	408.02	408.04	408.01	408.04	2000.0
2023-05-04 05:40:00	SPY	ETF	408.03	408.17	408.03	408.09	1600.0
2023-05-04 05:45:00	SPY	ETF	407.95	407.95	407.57	407.57	3750.0
2023-05-04 05:50:00	SPY	ETF	407.71	407.77	407.52	407.62	3100.0
2023-05-04 05:55:00	SPY	ETF	407.61	407.69	407.61	407.69	5500.0
2023-05-04 06:00:00	SPY	ETF	407.65	407.75	407.29	407.29	4456.0
2023-05-04 06:05:00	SPY	ETF	407.2	407.3	407.08	407.08	7029.0
2023-05-04 06:10:00	SPY	ETF	407.27	407.37	407.2	407.36	10001.0
2023-05-04 06:15:00	SPY	ETF	407.4	407.5	407.4	407.5	2725.0
2023-05-04 06:20:00	SPY	ETF	407.45	407.9	407.45	407.79	5200.0
2023-05-04 06:25:00	SPY	ETF	407.77	407.8	407.75	407.77	11625.0
2023-05-04 06:30:00	SPY	ETF	407.7	407.75	407.7	407.7	514.0
2023-05-04 06:35:00	SPY	ETF	407.8	407.8	407.5	407.5	12426.0
2023-05-04 06:40:00	SPY	ETF	407.42	407.42	407.21	407.21	16873.0
2023-05-04 06:45:00	SPY	ETF	407.22	407.22	406.99	406.99	15039.0
2023-05-04 06:50:00	SPY	ETF	406.84	407.08	406.74	406.85	70600.0
2023-05-04 06:55:00	SPY	ETF	406.89	407.06	406.89	407.03	6800.0
2023-05-04 07:00:00	SPY	ETF	407.11	407.11	406.95	407.0	15888.0
2023-05-04 07:05:00	SPY	ETF	407.01	407.01	406.72	406.75	7262.0
2023-05-04 07:10:00	SPY	ETF	406.68	406.82	406.61	406.8	26798.0
2023-05-04 07:15:00	SPY	ETF	406.8	406.85	406.53	406.64	91076.0
2023-05-04 07:20:00	SPY	ETF	406.64	406.78	406.55	406.77	20368.0
2023-05-04 07:25:00	SPY	ETF	406.77	406.96	406.62	406.91	32550.0
2023-05-04 07:30:00	SPY	ETF	406.93	407.06	406.85	407.06	14965.0
2023-05-04 07:35:00	SPY	ETF	406.99	407.18	406.97	407.13	11135.0
2023-05-04 07:40:00	SPY	ETF	407.1	407.1	406.7	406.81	29442.0
2023-05-04 07:45:00	SPY	ETF	406.79	407.16	406.78	407.04	9918.0
2023-05-04 07:50:00	SPY	ETF	407.06	407.1	406.82	406.9	21287.0
2023-05-04 07:55:00	SPY	ETF	406.77	406.86	406.76	406.84	26179.0
2023-05-04 08:00:00	SPY	ETF	406.84	409.06	406.39	406.67	111470.0
2023-05-04 08:05:00	SPY	ETF	406.67	406.71	406.47	406.65	39166.0

> showing 50 of 97,986 rows — these rows as CSV

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