PREVIEW / etf_1min / 2023-09-13

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-09-13.parquet
  size:    4.3 MB
  rows:    241,472

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-09-13 04:00:00	SPY	ETF	446.06	446.06	445.99	446.03	2119.0
2023-09-13 04:01:00	SPY	ETF	446.1	446.1	446.1	446.1	200.0
2023-09-13 04:03:00	SPY	ETF	446.19	446.2	446.19	446.2	383.0
2023-09-13 04:08:00	SPY	ETF	446.02	446.02	446.0	446.0	200.0
2023-09-13 04:09:00	SPY	ETF	446.06	446.06	446.06	446.06	300.0
2023-09-13 04:10:00	SPY	ETF	446.0	446.0	446.0	446.0	765.0
2023-09-13 04:13:00	SPY	ETF	445.91	445.91	445.91	445.91	100.0
2023-09-13 04:15:00	SPY	ETF	446.04	446.04	446.04	446.04	112.0
2023-09-13 04:17:00	SPY	ETF	445.9	445.9	445.84	445.84	306.0
2023-09-13 04:18:00	SPY	ETF	445.88	445.88	445.88	445.88	100.0
2023-09-13 04:20:00	SPY	ETF	445.79	445.79	445.79	445.79	300.0
2023-09-13 04:22:00	SPY	ETF	445.92	445.92	445.92	445.92	175.0
2023-09-13 04:23:00	SPY	ETF	446.0	446.0	446.0	446.0	250.0
2023-09-13 04:24:00	SPY	ETF	446.0	446.0	446.0	446.0	400.0
2023-09-13 04:26:00	SPY	ETF	445.94	445.94	445.93	445.93	2500.0
2023-09-13 04:27:00	SPY	ETF	445.99	446.06	445.99	446.06	841.0
2023-09-13 04:28:00	SPY	ETF	445.98	445.98	445.98	445.98	500.0
2023-09-13 04:29:00	SPY	ETF	445.94	445.94	445.94	445.94	100.0
2023-09-13 04:35:00	SPY	ETF	445.8	445.8	445.8	445.8	250.0
2023-09-13 04:37:00	SPY	ETF	445.83	445.84	445.8	445.8	2501.0
2023-09-13 04:39:00	SPY	ETF	445.63	445.63	445.63	445.63	170.0
2023-09-13 04:40:00	SPY	ETF	445.65	445.65	445.65	445.65	194.0
2023-09-13 04:42:00	SPY	ETF	445.61	445.61	445.57	445.57	795.0
2023-09-13 04:43:00	SPY	ETF	445.64	445.65	445.63	445.63	551.0
2023-09-13 04:45:00	SPY	ETF	445.69	445.7	445.69	445.7	694.0
2023-09-13 04:49:00	SPY	ETF	445.55	445.55	445.55	445.55	970.0
2023-09-13 04:52:00	SPY	ETF	445.65	445.65	445.65	445.65	100.0
2023-09-13 04:55:00	SPY	ETF	445.7	445.75	445.7	445.75	674.0
2023-09-13 04:58:00	SPY	ETF	445.63	445.63	445.52	445.52	200.0
2023-09-13 04:59:00	SPY	ETF	445.55	445.55	445.55	445.55	1300.0
2023-09-13 05:00:00	SPY	ETF	445.55	445.55	445.52	445.52	1762.0
2023-09-13 05:03:00	SPY	ETF	445.48	445.5	445.48	445.5	1123.0
2023-09-13 05:04:00	SPY	ETF	445.5	445.5	445.5	445.5	200.0
2023-09-13 05:06:00	SPY	ETF	445.6	445.6	445.6	445.6	270.0
2023-09-13 05:11:00	SPY	ETF	445.72	445.72	445.72	445.72	119.0
2023-09-13 05:14:00	SPY	ETF	445.7	445.7	445.7	445.7	112.0
2023-09-13 05:15:00	SPY	ETF	445.75	445.75	445.75	445.75	165.0
2023-09-13 05:19:00	SPY	ETF	445.9	445.9	445.83	445.83	335.0
2023-09-13 05:22:00	SPY	ETF	445.86	445.86	445.86	445.86	455.0
2023-09-13 05:23:00	SPY	ETF	445.88	445.88	445.88	445.88	400.0
2023-09-13 05:25:00	SPY	ETF	445.88	445.88	445.88	445.88	100.0
2023-09-13 05:26:00	SPY	ETF	445.89	445.89	445.89	445.89	100.0
2023-09-13 05:29:00	SPY	ETF	445.78	445.78	445.78	445.78	100.0
2023-09-13 05:34:00	SPY	ETF	445.82	445.82	445.82	445.82	118.0
2023-09-13 05:40:00	SPY	ETF	445.99	446.0	445.95	445.95	1500.0
2023-09-13 05:42:00	SPY	ETF	445.95	445.97	445.95	445.95	3617.0
2023-09-13 05:46:00	SPY	ETF	445.69	445.74	445.68	445.68	2800.0
2023-09-13 05:47:00	SPY	ETF	445.58	445.58	445.58	445.58	148.0
2023-09-13 05:51:00	SPY	ETF	445.76	445.76	445.76	445.76	136.0
2023-09-13 05:56:00	SPY	ETF	445.75	445.8	445.75	445.8	870.0

> showing 50 of 241,472 rows — these rows as CSV

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