PREVIEW / etf_1min / 2023-10-31

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-10-31.parquet
  size:    4.8 MB
  rows:    272,365

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-10-31 04:00:00	SPY	ETF	414.7	414.85	414.7	414.74	7750.0
2023-10-31 04:01:00	SPY	ETF	414.71	414.71	414.71	414.71	200.0
2023-10-31 04:04:00	SPY	ETF	414.58	414.6	414.5	414.5	1688.0
2023-10-31 04:05:00	SPY	ETF	414.49	414.59	414.49	414.59	650.0
2023-10-31 04:06:00	SPY	ETF	414.47	414.52	414.47	414.52	225.0
2023-10-31 04:07:00	SPY	ETF	414.55	414.66	414.55	414.63	900.0
2023-10-31 04:08:00	SPY	ETF	414.63	414.63	414.6	414.6	2750.0
2023-10-31 04:09:00	SPY	ETF	414.7	414.72	414.66	414.66	2056.0
2023-10-31 04:10:00	SPY	ETF	414.58	414.62	414.58	414.62	375.0
2023-10-31 04:12:00	SPY	ETF	414.7	414.81	414.7	414.81	1125.0
2023-10-31 04:13:00	SPY	ETF	414.89	414.91	414.83	414.91	330.0
2023-10-31 04:14:00	SPY	ETF	414.93	414.97	414.93	414.97	630.0
2023-10-31 04:15:00	SPY	ETF	414.88	414.95	414.88	414.94	996.0
2023-10-31 04:16:00	SPY	ETF	414.98	415.04	414.98	415.04	1375.0
2023-10-31 04:17:00	SPY	ETF	415.08	415.09	414.92	414.94	1975.0
2023-10-31 04:18:00	SPY	ETF	415.05	415.05	414.92	414.94	900.0
2023-10-31 04:19:00	SPY	ETF	414.92	414.99	414.92	414.99	600.0
2023-10-31 04:20:00	SPY	ETF	415.02	415.02	414.98	414.99	500.0
2023-10-31 04:21:00	SPY	ETF	415.01	415.06	415.0	415.0	1261.0
2023-10-31 04:22:00	SPY	ETF	415.04	415.04	415.0	415.0	250.0
2023-10-31 04:23:00	SPY	ETF	415.12	415.15	415.12	415.15	550.0
2023-10-31 04:24:00	SPY	ETF	415.13	415.17	415.13	415.16	1025.0
2023-10-31 04:25:00	SPY	ETF	415.08	415.18	415.05	415.18	4925.0
2023-10-31 04:26:00	SPY	ETF	415.07	415.11	415.07	415.11	711.0
2023-10-31 04:27:00	SPY	ETF	415.19	415.19	415.16	415.17	875.0
2023-10-31 04:28:00	SPY	ETF	415.15	415.19	415.15	415.19	650.0
2023-10-31 04:29:00	SPY	ETF	415.23	415.38	415.23	415.31	1258.0
2023-10-31 04:30:00	SPY	ETF	415.29	415.34	415.26	415.26	450.0
2023-10-31 04:31:00	SPY	ETF	415.36	415.37	415.36	415.37	250.0
2023-10-31 04:32:00	SPY	ETF	415.27	415.32	415.26	415.32	1275.0
2023-10-31 04:33:00	SPY	ETF	415.3	415.31	415.28	415.31	5300.0
2023-10-31 04:34:00	SPY	ETF	415.29	415.29	415.29	415.29	300.0
2023-10-31 04:35:00	SPY	ETF	415.33	415.38	415.33	415.38	1016.0
2023-10-31 04:36:00	SPY	ETF	415.4	415.42	415.4	415.42	200.0
2023-10-31 04:38:00	SPY	ETF	415.6	415.62	415.6	415.62	1300.0
2023-10-31 04:39:00	SPY	ETF	415.64	415.64	415.64	415.64	500.0
2023-10-31 04:40:00	SPY	ETF	415.63	415.65	415.63	415.65	500.0
2023-10-31 04:41:00	SPY	ETF	415.69	415.69	415.69	415.69	800.0
2023-10-31 04:42:00	SPY	ETF	415.68	415.68	415.68	415.68	166.0
2023-10-31 04:44:00	SPY	ETF	415.72	415.76	415.72	415.75	300.0
2023-10-31 04:45:00	SPY	ETF	415.76	415.77	415.76	415.77	1300.0
2023-10-31 04:46:00	SPY	ETF	415.85	415.9	415.85	415.9	818.0
2023-10-31 04:47:00	SPY	ETF	415.91	415.92	415.91	415.92	334.0
2023-10-31 04:48:00	SPY	ETF	415.82	415.85	415.82	415.85	261.0
2023-10-31 04:49:00	SPY	ETF	415.73	415.73	415.73	415.73	100.0
2023-10-31 04:52:00	SPY	ETF	415.98	416.0	415.98	416.0	1612.0
2023-10-31 04:53:00	SPY	ETF	416.08	416.22	416.08	416.19	1272.0
2023-10-31 04:54:00	SPY	ETF	416.04	416.1	416.04	416.1	400.0
2023-10-31 04:55:00	SPY	ETF	416.09	416.09	416.04	416.04	600.0
2023-10-31 04:56:00	SPY	ETF	416.09	416.09	416.09	416.09	100.0

> showing 50 of 272,365 rows — these rows as CSV

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