PREVIEW / etf_1min / 2023-02-09

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-02-09.parquet
  size:    4.7 MB
  rows:    263,672

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-02-09 04:00:00	SPY	ETF	413.59	413.83	413.02	413.81	10067.0
2023-02-09 04:01:00	SPY	ETF	413.76	413.76	413.69	413.69	1400.0
2023-02-09 04:02:00	SPY	ETF	413.68	413.75	413.65	413.75	1205.0
2023-02-09 04:03:00	SPY	ETF	413.78	413.78	413.74	413.74	941.0
2023-02-09 04:04:00	SPY	ETF	413.77	413.77	413.76	413.76	716.0
2023-02-09 04:05:00	SPY	ETF	413.75	413.75	413.75	413.75	100.0
2023-02-09 04:06:00	SPY	ETF	413.85	413.87	413.85	413.87	600.0
2023-02-09 04:07:00	SPY	ETF	413.88	413.94	413.88	413.92	1075.0
2023-02-09 04:08:00	SPY	ETF	413.88	413.88	413.88	413.88	500.0
2023-02-09 04:09:00	SPY	ETF	413.74	413.79	413.72	413.79	1800.0
2023-02-09 04:10:00	SPY	ETF	413.72	413.8	413.72	413.8	993.0
2023-02-09 04:11:00	SPY	ETF	413.87	413.9	413.83	413.9	5500.0
2023-02-09 04:13:00	SPY	ETF	413.8	413.82	413.8	413.8	800.0
2023-02-09 04:14:00	SPY	ETF	413.84	413.84	413.84	413.84	200.0
2023-02-09 04:15:00	SPY	ETF	413.8	413.81	413.8	413.81	600.0
2023-02-09 04:16:00	SPY	ETF	413.8	413.84	413.78	413.84	450.0
2023-02-09 04:17:00	SPY	ETF	413.77	413.77	413.76	413.76	616.0
2023-02-09 04:18:00	SPY	ETF	413.74	413.79	413.74	413.77	313.0
2023-02-09 04:19:00	SPY	ETF	413.67	413.67	413.67	413.67	100.0
2023-02-09 04:22:00	SPY	ETF	413.75	413.8	413.75	413.8	203.0
2023-02-09 04:23:00	SPY	ETF	413.63	413.64	413.63	413.64	200.0
2023-02-09 04:24:00	SPY	ETF	413.68	413.72	413.68	413.72	1040.0
2023-02-09 04:25:00	SPY	ETF	413.76	413.76	413.76	413.76	100.0
2023-02-09 04:27:00	SPY	ETF	413.68	413.72	413.68	413.72	613.0
2023-02-09 04:28:00	SPY	ETF	413.72	413.72	413.72	413.72	167.0
2023-02-09 04:29:00	SPY	ETF	413.7	413.7	413.7	413.7	5251.0
2023-02-09 04:30:00	SPY	ETF	413.79	413.79	413.79	413.79	100.0
2023-02-09 04:31:00	SPY	ETF	413.76	413.76	413.75	413.75	510.0
2023-02-09 04:32:00	SPY	ETF	413.7	413.7	413.7	413.7	300.0
2023-02-09 04:33:00	SPY	ETF	413.75	413.75	413.75	413.75	100.0
2023-02-09 04:34:00	SPY	ETF	413.76	413.76	413.76	413.76	100.0
2023-02-09 04:35:00	SPY	ETF	413.82	413.82	413.82	413.82	100.0
2023-02-09 04:37:00	SPY	ETF	413.99	413.99	413.97	413.97	322.0
2023-02-09 04:38:00	SPY	ETF	413.96	414.04	413.96	414.04	620.0
2023-02-09 04:39:00	SPY	ETF	413.95	413.99	413.95	413.99	353.0
2023-02-09 04:40:00	SPY	ETF	413.95	413.95	413.87	413.94	1600.0
2023-02-09 04:41:00	SPY	ETF	413.96	414.02	413.96	413.98	3900.0
2023-02-09 04:42:00	SPY	ETF	414.08	414.08	414.05	414.08	3300.0
2023-02-09 04:43:00	SPY	ETF	414.04	414.04	414.04	414.04	1600.0
2023-02-09 04:44:00	SPY	ETF	414.09	414.09	414.09	414.09	400.0
2023-02-09 04:45:00	SPY	ETF	414.2	414.24	414.19	414.24	3200.0
2023-02-09 04:46:00	SPY	ETF	414.22	414.26	414.22	414.24	500.0
2023-02-09 04:48:00	SPY	ETF	414.1	414.13	414.1	414.13	1300.0
2023-02-09 04:50:00	SPY	ETF	414.25	414.38	414.25	414.28	6800.0
2023-02-09 04:51:00	SPY	ETF	414.31	414.35	414.29	414.35	1128.0
2023-02-09 04:52:00	SPY	ETF	414.32	414.33	414.32	414.33	1011.0
2023-02-09 04:55:00	SPY	ETF	414.39	414.39	414.36	414.36	573.0
2023-02-09 04:56:00	SPY	ETF	414.42	414.42	414.41	414.41	650.0
2023-02-09 04:57:00	SPY	ETF	414.39	414.39	414.39	414.39	100.0
2023-02-09 04:58:00	SPY	ETF	414.43	414.43	414.43	414.43	500.0

> showing 50 of 263,672 rows — these rows as CSV

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