PREVIEW / etf_1min / 2023-11-20

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-11-20.parquet
  size:    4.9 MB
  rows:    278,690

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-11-20 04:00:00	SPY	ETF	450.62	450.7	450.61	450.7	3468.0
2023-11-20 04:01:00	SPY	ETF	450.73	450.77	450.68	450.68	3250.0
2023-11-20 04:02:00	SPY	ETF	450.74	450.78	450.65	450.65	6640.0
2023-11-20 04:03:00	SPY	ETF	450.7	450.72	450.64	450.69	2668.0
2023-11-20 04:04:00	SPY	ETF	450.72	450.72	450.66	450.66	629.0
2023-11-20 04:05:00	SPY	ETF	450.65	450.74	450.65	450.74	2505.0
2023-11-20 04:06:00	SPY	ETF	450.75	450.75	450.63	450.67	550.0
2023-11-20 04:07:00	SPY	ETF	450.63	450.71	450.63	450.71	1097.0
2023-11-20 04:08:00	SPY	ETF	450.74	450.79	450.71	450.79	1761.0
2023-11-20 04:09:00	SPY	ETF	450.84	450.87	450.79	450.79	1447.0
2023-11-20 04:10:00	SPY	ETF	450.79	450.81	450.75	450.79	1125.0
2023-11-20 04:11:00	SPY	ETF	450.77	450.83	450.76	450.83	2065.0
2023-11-20 04:12:00	SPY	ETF	450.82	450.82	450.78	450.82	800.0
2023-11-20 04:13:00	SPY	ETF	450.85	450.9	450.83	450.9	1450.0
2023-11-20 04:14:00	SPY	ETF	450.93	450.93	450.87	450.87	624.0
2023-11-20 04:15:00	SPY	ETF	450.85	450.9	450.85	450.9	274.0
2023-11-20 04:16:00	SPY	ETF	450.93	450.93	450.87	450.92	477.0
2023-11-20 04:17:00	SPY	ETF	450.92	450.92	450.89	450.92	532.0
2023-11-20 04:18:00	SPY	ETF	450.89	451.0	450.89	451.0	1413.0
2023-11-20 04:19:00	SPY	ETF	450.99	451.06	450.99	451.03	800.0
2023-11-20 04:20:00	SPY	ETF	451.0	451.0	450.95	450.95	1395.0
2023-11-20 04:21:00	SPY	ETF	450.96	451.01	450.96	451.01	2525.0
2023-11-20 04:22:00	SPY	ETF	450.97	451.03	450.97	451.01	1425.0
2023-11-20 04:23:00	SPY	ETF	450.99	451.11	450.99	451.11	997.0
2023-11-20 04:24:00	SPY	ETF	451.07	451.14	451.04	451.14	600.0
2023-11-20 04:25:00	SPY	ETF	451.09	451.13	451.08	451.08	1075.0
2023-11-20 04:26:00	SPY	ETF	451.06	451.06	451.0	451.0	230.0
2023-11-20 04:27:00	SPY	ETF	451.05	451.06	451.02	451.02	700.0
2023-11-20 04:28:00	SPY	ETF	451.09	451.14	451.05	451.14	1572.0
2023-11-20 04:29:00	SPY	ETF	451.07	451.11	451.04	451.1	1000.0
2023-11-20 04:30:00	SPY	ETF	451.05	451.09	451.04	451.04	1520.0
2023-11-20 04:31:00	SPY	ETF	451.08	451.08	450.99	451.04	685.0
2023-11-20 04:32:00	SPY	ETF	451.01	451.15	451.01	451.15	1545.0
2023-11-20 04:33:00	SPY	ETF	451.15	451.21	451.14	451.21	1650.0
2023-11-20 04:34:00	SPY	ETF	451.19	451.21	451.14	451.14	300.0
2023-11-20 04:35:00	SPY	ETF	451.16	451.25	451.16	451.22	6975.0
2023-11-20 04:36:00	SPY	ETF	451.13	451.13	451.13	451.13	400.0
2023-11-20 04:37:00	SPY	ETF	451.12	451.14	451.12	451.14	500.0
2023-11-20 04:44:00	SPY	ETF	451.18	451.18	451.18	451.18	400.0
2023-11-20 04:51:00	SPY	ETF	451.17	451.17	451.17	451.17	300.0
2023-11-20 04:52:00	SPY	ETF	451.19	451.21	451.19	451.21	825.0
2023-11-20 04:53:00	SPY	ETF	451.25	451.25	451.25	451.25	184.0
2023-11-20 04:54:00	SPY	ETF	451.33	451.33	451.33	451.33	412.0
2023-11-20 04:56:00	SPY	ETF	451.34	451.34	451.34	451.34	200.0
2023-11-20 04:58:00	SPY	ETF	451.39	451.39	451.39	451.39	128.0
2023-11-20 05:07:00	SPY	ETF	451.41	451.42	451.41	451.42	410.0
2023-11-20 05:08:00	SPY	ETF	451.4	451.4	451.4	451.4	100.0
2023-11-20 05:12:00	SPY	ETF	451.38	451.38	451.38	451.38	500.0
2023-11-20 05:17:00	SPY	ETF	451.33	451.33	451.33	451.33	590.0
2023-11-20 05:20:00	SPY	ETF	451.4	451.4	451.4	451.4	200.0

> showing 50 of 278,690 rows — these rows as CSV

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