PREVIEW / etf_1min / 2023-07-05

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-07-05.parquet
  size:    4.5 MB
  rows:    259,766

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-07-05 04:00:00	SPY	ETF	442.93	443.31	442.77	442.8	4857.0
2023-07-05 04:01:00	SPY	ETF	442.76	442.78	442.76	442.78	6051.0
2023-07-05 04:02:00	SPY	ETF	442.81	442.81	442.81	442.81	180.0
2023-07-05 04:03:00	SPY	ETF	442.71	442.81	442.71	442.81	1024.0
2023-07-05 04:04:00	SPY	ETF	442.8	442.91	442.79	442.91	1945.0
2023-07-05 04:05:00	SPY	ETF	442.96	442.96	442.93	442.95	766.0
2023-07-05 04:06:00	SPY	ETF	442.93	442.95	442.85	442.85	2809.0
2023-07-05 04:07:00	SPY	ETF	442.87	442.87	442.87	442.87	225.0
2023-07-05 04:08:00	SPY	ETF	442.84	442.86	442.84	442.86	3109.0
2023-07-05 04:09:00	SPY	ETF	442.89	442.98	442.89	442.98	805.0
2023-07-05 04:11:00	SPY	ETF	442.83	442.83	442.83	442.83	159.0
2023-07-05 04:13:00	SPY	ETF	442.79	442.79	442.76	442.76	950.0
2023-07-05 04:14:00	SPY	ETF	442.79	442.79	442.79	442.79	500.0
2023-07-05 04:16:00	SPY	ETF	442.86	442.87	442.86	442.87	289.0
2023-07-05 04:17:00	SPY	ETF	442.92	442.93	442.92	442.93	540.0
2023-07-05 04:19:00	SPY	ETF	443.02	443.05	443.02	443.05	264.0
2023-07-05 04:20:00	SPY	ETF	443.06	443.06	443.06	443.06	233.0
2023-07-05 04:27:00	SPY	ETF	443.04	443.04	443.04	443.04	100.0
2023-07-05 04:29:00	SPY	ETF	443.01	443.01	442.99	442.99	700.0
2023-07-05 04:32:00	SPY	ETF	442.94	442.94	442.94	442.94	708.0
2023-07-05 04:34:00	SPY	ETF	442.88	442.9	442.88	442.88	625.0
2023-07-05 04:38:00	SPY	ETF	442.88	442.88	442.88	442.88	400.0
2023-07-05 04:40:00	SPY	ETF	442.72	442.72	442.72	442.72	110.0
2023-07-05 04:43:00	SPY	ETF	442.76	442.76	442.76	442.76	300.0
2023-07-05 04:46:00	SPY	ETF	442.77	442.78	442.75	442.75	754.0
2023-07-05 04:50:00	SPY	ETF	442.77	442.77	442.77	442.77	233.0
2023-07-05 04:52:00	SPY	ETF	442.8	442.8	442.8	442.8	105.0
2023-07-05 04:55:00	SPY	ETF	442.71	442.71	442.71	442.71	100.0
2023-07-05 04:56:00	SPY	ETF	442.7	442.7	442.69	442.7	1233.0
2023-07-05 05:05:00	SPY	ETF	442.75	442.75	442.74	442.74	800.0
2023-07-05 05:07:00	SPY	ETF	442.75	442.75	442.74	442.74	600.0
2023-07-05 05:08:00	SPY	ETF	442.74	442.74	442.74	442.74	686.0
2023-07-05 05:09:00	SPY	ETF	442.7	442.7	442.59	442.59	860.0
2023-07-05 05:10:00	SPY	ETF	442.6	442.6	442.6	442.6	200.0
2023-07-05 05:11:00	SPY	ETF	442.58	442.58	442.51	442.54	2181.0
2023-07-05 05:12:00	SPY	ETF	442.5	442.5	442.49	442.49	584.0
2023-07-05 05:16:00	SPY	ETF	442.52	442.52	442.52	442.52	136.0
2023-07-05 05:17:00	SPY	ETF	442.52	442.52	442.52	442.52	100.0
2023-07-05 05:20:00	SPY	ETF	442.54	442.54	442.54	442.54	100.0
2023-07-05 05:22:00	SPY	ETF	442.45	442.46	442.37	442.37	5900.0
2023-07-05 05:23:00	SPY	ETF	442.31	442.33	442.31	442.31	1002.0
2023-07-05 05:24:00	SPY	ETF	442.3	442.3	442.3	442.3	647.0
2023-07-05 05:25:00	SPY	ETF	442.28	442.28	442.28	442.28	700.0
2023-07-05 05:26:00	SPY	ETF	442.3	442.3	442.3	442.3	100.0
2023-07-05 05:27:00	SPY	ETF	442.26	442.26	442.26	442.26	253.0
2023-07-05 05:29:00	SPY	ETF	442.26	442.26	442.23	442.23	1149.0
2023-07-05 05:30:00	SPY	ETF	442.2	442.2	442.2	442.2	1200.0
2023-07-05 05:31:00	SPY	ETF	442.12	442.12	442.02	442.02	3298.0
2023-07-05 05:33:00	SPY	ETF	441.97	442.01	441.97	442.01	1067.0
2023-07-05 05:35:00	SPY	ETF	441.99	441.99	441.99	441.99	271.0

> showing 50 of 259,766 rows — these rows as CSV

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