PREVIEW / etf_1min / 2024-07-01

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-07-01.parquet
  size:    5.3 MB
  rows:    302,307

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
2024-07-01 04:00:00	SPY	ETF	544.85	544.95	544.77	544.95	5096.0
2024-07-01 04:01:00	SPY	ETF	544.97	545.0	544.97	545.0	998.0
2024-07-01 04:02:00	SPY	ETF	544.94	544.94	544.91	544.91	244.0
2024-07-01 04:03:00	SPY	ETF	544.97	544.97	544.97	544.97	100.0
2024-07-01 04:04:00	SPY	ETF	544.79	544.79	544.79	544.79	1000.0
2024-07-01 04:05:00	SPY	ETF	545.05	545.11	545.05	545.11	200.0
2024-07-01 04:07:00	SPY	ETF	545.26	545.26	545.15	545.15	900.0
2024-07-01 04:08:00	SPY	ETF	545.19	545.26	545.18	545.25	4140.0
2024-07-01 04:09:00	SPY	ETF	545.31	545.31	545.31	545.31	269.0
2024-07-01 04:12:00	SPY	ETF	545.05	545.05	545.05	545.05	100.0
2024-07-01 04:13:00	SPY	ETF	545.15	545.15	545.15	545.15	183.0
2024-07-01 04:14:00	SPY	ETF	545.12	545.12	545.12	545.12	100.0
2024-07-01 04:15:00	SPY	ETF	545.1	545.1	545.1	545.1	4900.0
2024-07-01 04:16:00	SPY	ETF	545.06	545.06	545.06	545.06	100.0
2024-07-01 04:18:00	SPY	ETF	545.1	545.11	545.1	545.11	200.0
2024-07-01 04:19:00	SPY	ETF	545.28	545.28	545.28	545.28	1198.0
2024-07-01 04:21:00	SPY	ETF	545.33	545.33	545.3	545.31	510.0
2024-07-01 04:22:00	SPY	ETF	545.3	545.3	545.29	545.29	700.0
2024-07-01 04:25:00	SPY	ETF	545.26	545.27	545.26	545.27	1000.0
2024-07-01 04:27:00	SPY	ETF	545.26	545.35	545.26	545.35	700.0
2024-07-01 04:32:00	SPY	ETF	545.48	545.48	545.32	545.32	867.0
2024-07-01 04:35:00	SPY	ETF	545.2	545.2	545.16	545.16	671.0
2024-07-01 04:36:00	SPY	ETF	545.12	545.12	545.08	545.09	1000.0
2024-07-01 04:37:00	SPY	ETF	544.94	544.94	544.9	544.9	625.0
2024-07-01 04:38:00	SPY	ETF	544.77	544.77	544.77	544.77	300.0
2024-07-01 04:39:00	SPY	ETF	544.85	544.85	544.71	544.71	1844.0
2024-07-01 04:40:00	SPY	ETF	544.66	544.66	544.54	544.54	2350.0
2024-07-01 04:41:00	SPY	ETF	544.45	544.52	544.45	544.51	411.0
2024-07-01 04:43:00	SPY	ETF	544.58	544.59	544.58	544.59	500.0
2024-07-01 04:44:00	SPY	ETF	544.54	544.55	544.5	544.5	713.0
2024-07-01 04:45:00	SPY	ETF	544.69	544.69	544.68	544.68	300.0
2024-07-01 04:46:00	SPY	ETF	544.74	544.84	544.7	544.84	500.0
2024-07-01 04:47:00	SPY	ETF	544.84	544.91	544.76	544.83	1300.0
2024-07-01 04:48:00	SPY	ETF	544.81	544.81	544.71	544.71	467.0
2024-07-01 04:49:00	SPY	ETF	544.75	544.75	544.75	544.75	250.0
2024-07-01 04:51:00	SPY	ETF	544.79	544.79	544.79	544.79	109.0
2024-07-01 04:52:00	SPY	ETF	544.81	544.81	544.81	544.81	400.0
2024-07-01 04:57:00	SPY	ETF	544.7	544.7	544.7	544.7	400.0
2024-07-01 04:58:00	SPY	ETF	544.72	544.72	544.72	544.72	300.0
2024-07-01 04:59:00	SPY	ETF	544.63	544.63	544.62	544.63	900.0
2024-07-01 05:00:00	SPY	ETF	544.52	544.57	544.52	544.57	488.0
2024-07-01 05:01:00	SPY	ETF	544.49	544.49	544.49	544.49	225.0
2024-07-01 05:03:00	SPY	ETF	544.49	544.49	544.4	544.4	316.0
2024-07-01 05:06:00	SPY	ETF	544.59	544.59	544.59	544.59	100.0
2024-07-01 05:07:00	SPY	ETF	544.48	544.48	544.48	544.48	115.0
2024-07-01 05:08:00	SPY	ETF	544.23	544.25	544.23	544.24	315.0
2024-07-01 05:09:00	SPY	ETF	544.23	544.26	544.23	544.26	500.0
2024-07-01 05:10:00	SPY	ETF	544.28	544.28	544.28	544.28	400.0
2024-07-01 05:11:00	SPY	ETF	544.22	544.23	544.22	544.22	743.0
2024-07-01 05:12:00	SPY	ETF	544.23	544.23	544.21	544.21	209.0

> showing 50 of 302,307 rows — these rows as CSV

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