PREVIEW / etf_5min / 2023-09-21

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-09-21.parquet
  size:    2.1 MB
  rows:    102,007

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-09-21 04:00:00	SPY	ETF	437.73	437.85	437.61	437.61	5620.0
2023-09-21 04:05:00	SPY	ETF	437.7	437.71	437.63	437.7	5300.0
2023-09-21 04:10:00	SPY	ETF	437.65	437.65	437.48	437.48	4600.0
2023-09-21 04:15:00	SPY	ETF	437.35	437.36	437.18	437.21	4950.0
2023-09-21 04:20:00	SPY	ETF	437.23	437.3	437.23	437.3	2025.0
2023-09-21 04:25:00	SPY	ETF	437.4	437.5	437.4	437.5	1325.0
2023-09-21 04:30:00	SPY	ETF	437.46	437.46	437.18	437.3	4502.0
2023-09-21 04:35:00	SPY	ETF	437.15	437.2	436.99	437.01	9252.0
2023-09-21 04:40:00	SPY	ETF	437.01	437.05	436.93	437.0	4869.0
2023-09-21 04:45:00	SPY	ETF	437.06	437.08	436.98	437.08	1775.0
2023-09-21 04:50:00	SPY	ETF	437.09	437.09	436.84	436.85	2600.0
2023-09-21 04:55:00	SPY	ETF	436.81	437.03	436.81	437.03	15968.0
2023-09-21 05:00:00	SPY	ETF	437.01	437.08	437.01	437.08	500.0
2023-09-21 05:05:00	SPY	ETF	437.23	437.23	437.16	437.16	601.0
2023-09-21 05:10:00	SPY	ETF	436.9	437.01	436.88	436.89	6200.0
2023-09-21 05:15:00	SPY	ETF	436.98	436.98	436.96	436.96	2585.0
2023-09-21 05:20:00	SPY	ETF	436.85	436.98	436.82	436.95	2146.0
2023-09-21 05:25:00	SPY	ETF	437.01	437.01	436.94	436.94	315.0
2023-09-21 05:30:00	SPY	ETF	436.96	437.06	436.79	436.81	5375.0
2023-09-21 05:35:00	SPY	ETF	436.98	436.98	436.815	436.84	3800.0
2023-09-21 05:40:00	SPY	ETF	436.9	436.9	436.81	436.81	3725.0
2023-09-21 05:45:00	SPY	ETF	436.77	436.77	436.62	436.68	4890.0
2023-09-21 05:50:00	SPY	ETF	436.68	436.68	436.62	436.64	4662.0
2023-09-21 05:55:00	SPY	ETF	436.58	436.58	436.44	436.48	4528.0
2023-09-21 06:00:00	SPY	ETF	436.53	436.53	436.38	436.39	3281.0
2023-09-21 06:05:00	SPY	ETF	436.38	436.41	436.1	436.15	17754.0
2023-09-21 06:10:00	SPY	ETF	436.2	436.31	436.13	436.31	6887.0
2023-09-21 06:15:00	SPY	ETF	436.27	436.27	436.0	436.08	22577.0
2023-09-21 06:20:00	SPY	ETF	436.17	436.19	436.01	436.02	4095.0
2023-09-21 06:25:00	SPY	ETF	436.03	436.11	436.0	436.05	6268.0
2023-09-21 06:30:00	SPY	ETF	436.06	436.13	435.99	436.08	2200.0
2023-09-21 06:35:00	SPY	ETF	436.03	436.03	435.86	435.92	4424.0
2023-09-21 06:40:00	SPY	ETF	436.01	436.02	435.95	435.95	6335.0
2023-09-21 06:45:00	SPY	ETF	435.94	436.05	435.9	435.9	14412.0
2023-09-21 06:50:00	SPY	ETF	435.94	436.09	435.87	436.09	7616.0
2023-09-21 06:55:00	SPY	ETF	436.1	436.23	436.09	436.13	12114.0
2023-09-21 07:00:00	SPY	ETF	436.09	436.3	435.91	435.91	15959.0
2023-09-21 07:05:00	SPY	ETF	436.04	436.04	435.69	435.75	23022.0
2023-09-21 07:10:00	SPY	ETF	435.75	435.84	435.42	435.47	25445.0
2023-09-21 07:15:00	SPY	ETF	435.47	435.53	435.3	435.36	32047.0
2023-09-21 07:20:00	SPY	ETF	435.36	435.43	435.27	435.33	110684.0
2023-09-21 07:25:00	SPY	ETF	435.26	435.45	435.25	435.34	20889.0
2023-09-21 07:30:00	SPY	ETF	435.3	435.4	435.23	435.34	12835.0
2023-09-21 07:35:00	SPY	ETF	435.38	435.52	435.35	435.36	15308.0
2023-09-21 07:40:00	SPY	ETF	435.39	435.53	435.39	435.53	14475.0
2023-09-21 07:45:00	SPY	ETF	435.56	435.68	435.48	435.5	35713.0
2023-09-21 07:50:00	SPY	ETF	435.57	435.6	435.26	435.32	20484.0
2023-09-21 07:55:00	SPY	ETF	435.35	435.35	435.18	435.31	42957.0
2023-09-21 08:00:00	SPY	ETF	436.1481	437.79	435.21	435.32	154926.0
2023-09-21 08:05:00	SPY	ETF	435.37	435.39	435.06	435.14	80961.0

> showing 50 of 102,007 rows — these rows as CSV

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