PREVIEW / etf_5min / 2023-01-31

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-31.parquet
  size:    2.0 MB
  rows:    98,903

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-01-31 04:00:00	SPY	ETF	399.95	400.0	399.71	399.71	5403.0
2023-01-31 04:05:00	SPY	ETF	399.74	399.78	399.58	399.7	4157.0
2023-01-31 04:10:00	SPY	ETF	399.72	399.78	399.62	399.62	3502.0
2023-01-31 04:15:00	SPY	ETF	399.6	399.6	399.21	399.21	9446.0
2023-01-31 04:20:00	SPY	ETF	399.27	399.55	399.27	399.55	2643.0
2023-01-31 04:25:00	SPY	ETF	399.55	399.55	399.5	399.51	2200.0
2023-01-31 04:30:00	SPY	ETF	399.44	399.57	399.42	399.45	2343.0
2023-01-31 04:35:00	SPY	ETF	399.43	399.63	399.43	399.5	3094.0
2023-01-31 04:40:00	SPY	ETF	399.5	399.62	399.45	399.62	2220.0
2023-01-31 04:45:00	SPY	ETF	399.63	399.71	399.59	399.71	1132.0
2023-01-31 04:50:00	SPY	ETF	399.51	399.51	399.43	399.43	1701.0
2023-01-31 04:55:00	SPY	ETF	399.48	399.5	399.48	399.5	400.0
2023-01-31 05:00:00	SPY	ETF	399.31	399.35	399.21	399.31	1375.0
2023-01-31 05:05:00	SPY	ETF	399.36	399.36	399.21	399.24	2059.0
2023-01-31 05:10:00	SPY	ETF	399.21	399.21	399.1	399.16	500.0
2023-01-31 05:15:00	SPY	ETF	399.31	399.45	399.28	399.41	2159.0
2023-01-31 05:20:00	SPY	ETF	399.47	399.47	399.31	399.32	354.0
2023-01-31 05:25:00	SPY	ETF	399.19	399.29	399.06	399.29	3072.0
2023-01-31 05:30:00	SPY	ETF	399.35	399.35	399.07	399.09	755.0
2023-01-31 05:35:00	SPY	ETF	399.08	399.08	398.88	398.88	3518.0
2023-01-31 05:40:00	SPY	ETF	398.95	398.95	398.9	398.9	4301.0
2023-01-31 05:45:00	SPY	ETF	399.02	399.26	399.02	399.24	904.0
2023-01-31 05:50:00	SPY	ETF	399.11	399.11	399.06	399.06	400.0
2023-01-31 05:55:00	SPY	ETF	399.13	399.13	398.7	398.75	6366.0
2023-01-31 06:00:00	SPY	ETF	398.7	398.91	398.57	398.91	4488.0
2023-01-31 06:05:00	SPY	ETF	398.9	398.94	398.86	398.86	5838.0
2023-01-31 06:10:00	SPY	ETF	398.86	398.87	398.68	398.69	5692.0
2023-01-31 06:15:00	SPY	ETF	398.69	398.92	398.69	398.9	18350.0
2023-01-31 06:20:00	SPY	ETF	398.79	398.79	398.65	398.68	17016.0
2023-01-31 06:25:00	SPY	ETF	398.62	398.62	398.5	398.52	5999.0
2023-01-31 06:30:00	SPY	ETF	398.48	398.48	398.25	398.29	16058.0
2023-01-31 06:35:00	SPY	ETF	398.39	398.91	398.39	398.91	15980.0
2023-01-31 06:40:00	SPY	ETF	398.82	399.18	398.82	399.18	9149.0
2023-01-31 06:45:00	SPY	ETF	399.24	399.29	399.05	399.14	4788.0
2023-01-31 06:50:00	SPY	ETF	399.2	399.25	399.19	399.24	3710.0
2023-01-31 06:55:00	SPY	ETF	399.3	399.32	399.2	399.22	3199.0
2023-01-31 07:00:00	SPY	ETF	399.3	399.69	399.25	399.55	35705.0
2023-01-31 07:05:00	SPY	ETF	399.53	399.58	399.28	399.28	19253.0
2023-01-31 07:10:00	SPY	ETF	399.3	399.6	399.3	399.58	8257.0
2023-01-31 07:15:00	SPY	ETF	399.53	399.59	399.44	399.44	834.0
2023-01-31 07:20:00	SPY	ETF	399.51	399.6	399.51	399.55	6696.0
2023-01-31 07:25:00	SPY	ETF	399.5	399.56	399.41	399.56	5902.0
2023-01-31 07:30:00	SPY	ETF	399.69	399.86	399.65	399.75	10388.0
2023-01-31 07:35:00	SPY	ETF	399.8	399.84	399.67	399.67	36453.0
2023-01-31 07:40:00	SPY	ETF	399.62	399.77	399.62	399.77	2531.0
2023-01-31 07:45:00	SPY	ETF	399.81	400.15	399.81	399.99	20378.0
2023-01-31 07:50:00	SPY	ETF	399.97	400.12	399.96	400.11	22399.0
2023-01-31 07:55:00	SPY	ETF	400.08	400.12	399.94	399.95	34823.0
2023-01-31 08:00:00	SPY	ETF	399.5	401.39	398.69	400.2	89997.0
2023-01-31 08:05:00	SPY	ETF	400.25	400.32	400.13	400.21	59688.0

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

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