PREVIEW / etf_1min / 2023-10-23

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-10-23.parquet
  size:    5.0 MB
  rows:    282,121

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-23 04:00:00	SPY	ETF	420.42	420.44	420.41	420.44	1600.0
2023-10-23 04:01:00	SPY	ETF	420.4	420.4	420.23	420.23	5924.0
2023-10-23 04:02:00	SPY	ETF	420.2	420.2	420.18	420.18	15379.0
2023-10-23 04:03:00	SPY	ETF	420.16	420.16	420.15	420.15	203.0
2023-10-23 04:04:00	SPY	ETF	420.26	420.26	420.2	420.2	1500.0
2023-10-23 04:05:00	SPY	ETF	420.27	420.57	420.27	420.54	1627.0
2023-10-23 04:06:00	SPY	ETF	420.74	420.75	420.72	420.74	879.0
2023-10-23 04:07:00	SPY	ETF	420.73	420.73	420.73	420.73	100.0
2023-10-23 04:08:00	SPY	ETF	420.76	420.84	420.76	420.8	5122.0
2023-10-23 04:11:00	SPY	ETF	420.79	420.79	420.7	420.7	1382.0
2023-10-23 04:12:00	SPY	ETF	420.94	420.99	420.93	420.99	425.0
2023-10-23 04:13:00	SPY	ETF	420.88	420.88	420.87	420.87	200.0
2023-10-23 04:14:00	SPY	ETF	420.97	420.97	420.92	420.92	1150.0
2023-10-23 04:15:00	SPY	ETF	420.89	420.94	420.89	420.94	650.0
2023-10-23 04:16:00	SPY	ETF	421.02	421.12	421.02	421.12	930.0
2023-10-23 04:17:00	SPY	ETF	421.13	421.13	421.13	421.13	100.0
2023-10-23 04:18:00	SPY	ETF	421.13	421.13	421.08	421.08	214.0
2023-10-23 04:19:00	SPY	ETF	421.09	421.09	421.09	421.09	1200.0
2023-10-23 04:20:00	SPY	ETF	421.11	421.11	420.98	420.98	600.0
2023-10-23 04:21:00	SPY	ETF	420.87	420.87	420.87	420.87	100.0
2023-10-23 04:23:00	SPY	ETF	421.06	421.06	421.06	421.06	150.0
2023-10-23 04:24:00	SPY	ETF	421.06	421.06	421.0	421.02	688.0
2023-10-23 04:26:00	SPY	ETF	420.94	420.94	420.94	420.94	100.0
2023-10-23 04:27:00	SPY	ETF	420.97	420.97	420.97	420.97	150.0
2023-10-23 04:28:00	SPY	ETF	420.91	420.91	420.91	420.91	1564.0
2023-10-23 04:29:00	SPY	ETF	420.93	420.94	420.9	420.9	1700.0
2023-10-23 04:30:00	SPY	ETF	420.9	420.9	420.9	420.9	200.0
2023-10-23 04:31:00	SPY	ETF	420.62	420.62	420.62	420.62	100.0
2023-10-23 04:32:00	SPY	ETF	420.58	420.58	420.58	420.58	200.0
2023-10-23 04:34:00	SPY	ETF	420.67	420.7	420.66	420.7	1575.0
2023-10-23 04:36:00	SPY	ETF	420.69	420.69	420.68	420.69	1600.0
2023-10-23 04:37:00	SPY	ETF	420.66	420.66	420.5	420.58	2600.0
2023-10-23 04:38:00	SPY	ETF	420.72	420.74	420.67	420.7	1782.0
2023-10-23 04:39:00	SPY	ETF	420.87	420.87	420.87	420.87	149.0
2023-10-23 04:40:00	SPY	ETF	420.84	420.84	420.84	420.84	150.0
2023-10-23 04:42:00	SPY	ETF	420.85	420.85	420.84	420.84	500.0
2023-10-23 04:43:00	SPY	ETF	420.87	420.87	420.87	420.87	300.0
2023-10-23 04:44:00	SPY	ETF	420.77	420.77	420.77	420.77	250.0
2023-10-23 04:45:00	SPY	ETF	420.69	420.74	420.69	420.74	400.0
2023-10-23 04:46:00	SPY	ETF	420.85	420.85	420.85	420.85	100.0
2023-10-23 04:48:00	SPY	ETF	421.02	421.02	421.02	421.02	245.0
2023-10-23 04:49:00	SPY	ETF	420.94	420.94	420.94	420.94	124.0
2023-10-23 04:53:00	SPY	ETF	420.65	420.65	420.58	420.58	2100.0
2023-10-23 04:56:00	SPY	ETF	420.78	420.81	420.78	420.81	302.0
2023-10-23 04:57:00	SPY	ETF	420.71	420.81	420.71	420.81	401.0
2023-10-23 04:58:00	SPY	ETF	420.79	420.79	420.57	420.57	2600.0
2023-10-23 04:59:00	SPY	ETF	420.56	420.56	420.5	420.52	1761.0
2023-10-23 05:00:00	SPY	ETF	420.57	420.57	420.36	420.36	223.0
2023-10-23 05:01:00	SPY	ETF	420.4	420.4	420.4	420.4	200.0
2023-10-23 05:02:00	SPY	ETF	420.23	420.23	420.15	420.23	2100.0

> showing 50 of 282,121 rows — these rows as CSV

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