PREVIEW / etf_1min / 2023-10-20

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-10-20.parquet
  size:    4.9 MB
  rows:    279,530

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-20 04:00:00	SPY	ETF	425.78	425.78	425.59	425.6	6950.0
2023-10-20 04:01:00	SPY	ETF	425.58	425.59	425.5	425.52	6462.0
2023-10-20 04:02:00	SPY	ETF	425.57	425.57	425.34	425.45	3599.0
2023-10-20 04:03:00	SPY	ETF	425.68	425.68	425.68	425.68	100.0
2023-10-20 04:04:00	SPY	ETF	425.72	425.84	425.72	425.84	1200.0
2023-10-20 04:05:00	SPY	ETF	425.86	425.87	425.86	425.87	500.0
2023-10-20 04:06:00	SPY	ETF	425.99	425.99	425.97	425.97	525.0
2023-10-20 04:07:00	SPY	ETF	425.92	425.96	425.85	425.89	875.0
2023-10-20 04:08:00	SPY	ETF	425.78	425.83	425.76	425.77	600.0
2023-10-20 04:09:00	SPY	ETF	425.71	425.71	425.62	425.67	699.0
2023-10-20 04:10:00	SPY	ETF	425.61	425.76	425.61	425.7	1300.0
2023-10-20 04:11:00	SPY	ETF	425.74	425.87	425.74	425.87	350.0
2023-10-20 04:12:00	SPY	ETF	425.84	426.02	425.84	426.02	600.0
2023-10-20 04:13:00	SPY	ETF	426.02	426.06	426.02	426.06	350.0
2023-10-20 04:14:00	SPY	ETF	425.99	425.99	425.99	425.99	550.0
2023-10-20 04:15:00	SPY	ETF	425.98	425.98	425.8	425.8	1200.0
2023-10-20 04:16:00	SPY	ETF	425.84	425.92	425.82	425.92	653.0
2023-10-20 04:17:00	SPY	ETF	425.97	425.97	425.97	425.97	100.0
2023-10-20 04:18:00	SPY	ETF	425.94	425.94	425.9	425.92	500.0
2023-10-20 04:19:00	SPY	ETF	425.98	425.98	425.98	425.98	600.0
2023-10-20 04:20:00	SPY	ETF	425.97	425.99	425.97	425.99	796.0
2023-10-20 04:21:00	SPY	ETF	426.04	426.04	426.0	426.0	700.0
2023-10-20 04:22:00	SPY	ETF	426.05	426.2	426.05	426.19	2533.0
2023-10-20 04:23:00	SPY	ETF	426.13	426.19	426.07	426.19	2213.0
2023-10-20 04:24:00	SPY	ETF	426.22	426.22	426.18	426.18	3350.0
2023-10-20 04:25:00	SPY	ETF	426.22	426.32	426.22	426.32	5507.0
2023-10-20 04:26:00	SPY	ETF	426.32	426.39	426.32	426.39	975.0
2023-10-20 04:27:00	SPY	ETF	426.34	426.46	426.34	426.43	3532.0
2023-10-20 04:28:00	SPY	ETF	426.34	426.39	426.34	426.36	1200.0
2023-10-20 04:29:00	SPY	ETF	426.36	426.39	426.33	426.34	1000.0
2023-10-20 04:30:00	SPY	ETF	426.27	426.27	426.24	426.24	350.0
2023-10-20 04:31:00	SPY	ETF	426.17	426.17	426.17	426.17	100.0
2023-10-20 04:32:00	SPY	ETF	426.3	426.37	426.3	426.37	417.0
2023-10-20 04:33:00	SPY	ETF	426.37	426.37	426.35	426.35	1183.0
2023-10-20 04:34:00	SPY	ETF	426.29	426.4	426.29	426.37	700.0
2023-10-20 04:35:00	SPY	ETF	426.3	426.34	426.27	426.27	1126.0
2023-10-20 04:36:00	SPY	ETF	426.25	426.28	426.25	426.28	1900.0
2023-10-20 04:38:00	SPY	ETF	426.41	426.49	426.41	426.49	700.0
2023-10-20 04:39:00	SPY	ETF	426.52	426.52	426.52	426.52	250.0
2023-10-20 04:40:00	SPY	ETF	426.55	426.55	426.55	426.55	100.0
2023-10-20 04:41:00	SPY	ETF	426.6	426.6	426.6	426.6	500.0
2023-10-20 04:42:00	SPY	ETF	426.54	426.54	426.54	426.54	1200.0
2023-10-20 04:44:00	SPY	ETF	426.59	426.59	426.58	426.58	546.0
2023-10-20 04:45:00	SPY	ETF	426.62	426.62	426.62	426.62	100.0
2023-10-20 04:46:00	SPY	ETF	426.71	426.71	426.7	426.7	531.0
2023-10-20 04:47:00	SPY	ETF	426.73	426.73	426.73	426.73	184.0
2023-10-20 04:48:00	SPY	ETF	426.67	426.67	426.67	426.67	248.0
2023-10-20 04:50:00	SPY	ETF	426.64	426.66	426.64	426.66	900.0
2023-10-20 04:52:00	SPY	ETF	426.53	426.54	426.33	426.33	1249.0
2023-10-20 04:53:00	SPY	ETF	426.33	426.39	426.33	426.39	483.0

> showing 50 of 279,530 rows — these rows as CSV

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