PREVIEW / etf_1min / 2023-01-13

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-01-13.parquet
  size:    4.6 MB
  rows:    262,543

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-13 04:00:00	SPY	ETF	396.92	396.92	396.79	396.81	4850.0
2023-01-13 04:01:00	SPY	ETF	396.79	396.82	396.69	396.69	3300.0
2023-01-13 04:02:00	SPY	ETF	396.67	396.77	396.67	396.77	1500.0
2023-01-13 04:03:00	SPY	ETF	396.89	396.94	396.89	396.91	6249.0
2023-01-13 04:04:00	SPY	ETF	396.96	396.99	396.92	396.99	865.0
2023-01-13 04:05:00	SPY	ETF	397.06	397.07	397.02	397.07	594.0
2023-01-13 04:06:00	SPY	ETF	397.05	397.05	397.01	397.04	2100.0
2023-01-13 04:07:00	SPY	ETF	397.08	397.08	397.08	397.08	500.0
2023-01-13 04:08:00	SPY	ETF	397.04	397.04	397.04	397.04	100.0
2023-01-13 04:09:00	SPY	ETF	397.04	397.09	397.04	397.09	410.0
2023-01-13 04:12:00	SPY	ETF	397.11	397.11	397.11	397.11	228.0
2023-01-13 04:13:00	SPY	ETF	397.17	397.17	397.17	397.17	300.0
2023-01-13 04:14:00	SPY	ETF	397.2	397.2	397.17	397.17	637.0
2023-01-13 04:16:00	SPY	ETF	397.18	397.18	397.16	397.17	594.0
2023-01-13 04:18:00	SPY	ETF	397.03	397.03	396.99	396.99	923.0
2023-01-13 04:19:00	SPY	ETF	396.93	396.94	396.89	396.89	2198.0
2023-01-13 04:20:00	SPY	ETF	396.97	396.97	396.97	396.97	185.0
2023-01-13 04:21:00	SPY	ETF	396.98	396.98	396.91	396.91	221.0
2023-01-13 04:23:00	SPY	ETF	396.81	396.81	396.8	396.8	344.0
2023-01-13 04:24:00	SPY	ETF	396.84	396.84	396.83	396.83	346.0
2023-01-13 04:28:00	SPY	ETF	396.68	396.68	396.68	396.68	100.0
2023-01-13 04:29:00	SPY	ETF	396.55	396.55	396.5	396.5	250.0
2023-01-13 04:30:00	SPY	ETF	396.51	396.51	396.51	396.51	689.0
2023-01-13 04:31:00	SPY	ETF	396.66	396.66	396.64	396.64	400.0
2023-01-13 04:32:00	SPY	ETF	396.67	396.67	396.67	396.67	600.0
2023-01-13 04:33:00	SPY	ETF	396.67	396.73	396.67	396.73	500.0
2023-01-13 04:34:00	SPY	ETF	396.69	396.69	396.69	396.69	201.0
2023-01-13 04:36:00	SPY	ETF	396.79	396.79	396.79	396.79	100.0
2023-01-13 04:40:00	SPY	ETF	396.61	396.61	396.6	396.61	1668.0
2023-01-13 04:41:00	SPY	ETF	396.68	396.68	396.68	396.68	500.0
2023-01-13 04:43:00	SPY	ETF	396.86	396.86	396.86	396.86	200.0
2023-01-13 04:45:00	SPY	ETF	396.84	396.84	396.84	396.84	130.0
2023-01-13 04:46:00	SPY	ETF	396.93	396.93	396.93	396.93	300.0
2023-01-13 04:50:00	SPY	ETF	396.85	396.85	396.78	396.78	744.0
2023-01-13 04:53:00	SPY	ETF	396.95	396.95	396.95	396.95	100.0
2023-01-13 04:54:00	SPY	ETF	397.2	397.22	397.15	397.17	6300.0
2023-01-13 04:55:00	SPY	ETF	397.11	397.22	397.1	397.17	2811.0
2023-01-13 04:56:00	SPY	ETF	397.16	397.23	397.16	397.2	2447.0
2023-01-13 04:57:00	SPY	ETF	397.22	397.23	397.15	397.19	2531.0
2023-01-13 04:58:00	SPY	ETF	397.22	397.22	397.16	397.18	2700.0
2023-01-13 04:59:00	SPY	ETF	397.14	397.16	397.05	397.05	1700.0
2023-01-13 05:00:00	SPY	ETF	397.06	397.07	397.03	397.04	2212.0
2023-01-13 05:01:00	SPY	ETF	397.0	397.0	397.0	397.0	500.0
2023-01-13 05:03:00	SPY	ETF	397.0	397.0	396.99	396.99	400.0
2023-01-13 05:05:00	SPY	ETF	397.08	397.09	397.08	397.09	200.0
2023-01-13 05:06:00	SPY	ETF	397.08	397.09	397.04	397.04	1115.0
2023-01-13 05:08:00	SPY	ETF	397.01	397.01	397.0	397.0	1700.0
2023-01-13 05:10:00	SPY	ETF	397.07	397.07	397.07	397.07	700.0
2023-01-13 05:11:00	SPY	ETF	397.14	397.16	397.14	397.16	520.0
2023-01-13 05:14:00	SPY	ETF	397.23	397.23	397.23	397.23	100.0

> showing 50 of 262,543 rows — these rows as CSV

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