PREVIEW / etf_1min / 2023-01-19

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-01-19.parquet
  size:    4.7 MB
  rows:    265,288

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-19 04:00:00	SPY	ETF	390.22	390.49	390.11	390.4	15146.0
2023-01-19 04:01:00	SPY	ETF	390.25	390.25	390.25	390.25	100.0
2023-01-19 04:02:00	SPY	ETF	390.31	390.31	390.31	390.31	100.0
2023-01-19 04:03:00	SPY	ETF	390.5	390.5	390.44	390.45	2130.0
2023-01-19 04:04:00	SPY	ETF	390.4	390.4	390.4	390.4	100.0
2023-01-19 04:05:00	SPY	ETF	390.32	390.32	390.29	390.3	1079.0
2023-01-19 04:06:00	SPY	ETF	390.4	390.4	390.36	390.36	200.0
2023-01-19 04:07:00	SPY	ETF	390.41	390.45	390.4	390.45	1300.0
2023-01-19 04:08:00	SPY	ETF	390.42	390.42	390.42	390.42	100.0
2023-01-19 04:09:00	SPY	ETF	390.32	390.32	390.27	390.3	5200.0
2023-01-19 04:11:00	SPY	ETF	390.44	390.46	390.44	390.46	5225.0
2023-01-19 04:12:00	SPY	ETF	390.58	390.59	390.58	390.59	2800.0
2023-01-19 04:13:00	SPY	ETF	390.6	390.62	390.59	390.6	7019.0
2023-01-19 04:15:00	SPY	ETF	390.61	390.61	390.55	390.55	1317.0
2023-01-19 04:16:00	SPY	ETF	390.51	390.51	390.51	390.51	137.0
2023-01-19 04:18:00	SPY	ETF	390.49	390.53	390.49	390.49	460.0
2023-01-19 04:19:00	SPY	ETF	390.41	390.41	390.23	390.23	895.0
2023-01-19 04:20:00	SPY	ETF	390.22	390.22	390.17	390.18	6556.0
2023-01-19 04:22:00	SPY	ETF	390.25	390.25	390.25	390.25	300.0
2023-01-19 04:23:00	SPY	ETF	390.3	390.3	390.2	390.2	310.0
2023-01-19 04:24:00	SPY	ETF	390.2	390.2	390.2	390.2	100.0
2023-01-19 04:25:00	SPY	ETF	390.11	390.11	390.11	390.11	300.0
2023-01-19 04:26:00	SPY	ETF	390.14	390.14	390.05	390.05	1200.0
2023-01-19 04:27:00	SPY	ETF	390.18	390.18	390.18	390.18	100.0
2023-01-19 04:28:00	SPY	ETF	390.14	390.17	390.04	390.05	1200.0
2023-01-19 04:29:00	SPY	ETF	390.04	390.04	390.04	390.04	206.0
2023-01-19 04:30:00	SPY	ETF	390.05	390.19	390.05	390.19	575.0
2023-01-19 04:31:00	SPY	ETF	390.08	390.12	390.08	390.08	1200.0
2023-01-19 04:32:00	SPY	ETF	390.15	390.15	390.15	390.15	100.0
2023-01-19 04:34:00	SPY	ETF	390.1	390.1	390.1	390.1	100.0
2023-01-19 04:35:00	SPY	ETF	390.04	390.04	389.97	389.97	2236.0
2023-01-19 04:37:00	SPY	ETF	389.98	389.98	389.96	389.98	500.0
2023-01-19 04:39:00	SPY	ETF	389.92	390.0	389.92	390.0	641.0
2023-01-19 04:40:00	SPY	ETF	389.91	389.94	389.91	389.94	564.0
2023-01-19 04:41:00	SPY	ETF	389.92	389.92	389.91	389.91	200.0
2023-01-19 04:42:00	SPY	ETF	389.91	389.91	389.87	389.87	383.0
2023-01-19 04:43:00	SPY	ETF	389.95	389.97	389.91	389.91	13100.0
2023-01-19 04:44:00	SPY	ETF	389.85	390.0	389.85	390.0	520.0
2023-01-19 04:45:00	SPY	ETF	389.93	389.94	389.93	389.94	290.0
2023-01-19 04:46:00	SPY	ETF	389.9	389.9	389.9	389.9	227.0
2023-01-19 04:47:00	SPY	ETF	389.84	389.85	389.84	389.85	365.0
2023-01-19 04:48:00	SPY	ETF	389.83	389.84	389.83	389.84	350.0
2023-01-19 04:49:00	SPY	ETF	389.9	389.97	389.9	389.97	5200.0
2023-01-19 04:50:00	SPY	ETF	390.0	390.0	390.0	390.0	400.0
2023-01-19 04:52:00	SPY	ETF	389.93	389.93	389.93	389.93	100.0
2023-01-19 04:54:00	SPY	ETF	389.82	389.83	389.82	389.83	200.0
2023-01-19 04:55:00	SPY	ETF	389.96	389.96	389.96	389.96	100.0
2023-01-19 04:58:00	SPY	ETF	389.93	389.97	389.93	389.93	424.0
2023-01-19 04:59:00	SPY	ETF	389.97	389.97	389.95	389.95	1317.0
2023-01-19 05:00:00	SPY	ETF	389.96	390.01	389.96	390.01	600.0

> showing 50 of 265,288 rows — these rows as CSV

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