PREVIEW / etf_1min / 2023-08-25

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-08-25.parquet
  size:    4.5 MB
  rows:    254,103

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-08-25 04:00:00	SPY	ETF	437.48	437.56	437.48	437.52	1355.0
2023-08-25 04:01:00	SPY	ETF	437.53	437.63	437.53	437.59	1260.0
2023-08-25 04:02:00	SPY	ETF	437.58	437.7	437.58	437.7	990.0
2023-08-25 04:03:00	SPY	ETF	437.74	437.84	437.74	437.84	529.0
2023-08-25 04:04:00	SPY	ETF	437.85	437.85	437.85	437.85	400.0
2023-08-25 04:05:00	SPY	ETF	437.82	437.82	437.82	437.82	100.0
2023-08-25 04:06:00	SPY	ETF	437.8	437.8	437.8	437.8	600.0
2023-08-25 04:08:00	SPY	ETF	437.67	437.67	437.61	437.61	416.0
2023-08-25 04:09:00	SPY	ETF	437.66	437.72	437.63	437.63	3030.0
2023-08-25 04:10:00	SPY	ETF	437.69	437.77	437.69	437.73	456.0
2023-08-25 04:11:00	SPY	ETF	437.89	437.89	437.89	437.89	200.0
2023-08-25 04:13:00	SPY	ETF	438.0	438.07	438.0	438.04	1615.0
2023-08-25 04:14:00	SPY	ETF	438.0	438.0	438.0	438.0	135.0
2023-08-25 04:15:00	SPY	ETF	437.99	437.99	437.92	437.97	619.0
2023-08-25 04:17:00	SPY	ETF	437.89	437.9	437.87	437.9	600.0
2023-08-25 04:18:00	SPY	ETF	437.87	437.87	437.87	437.87	400.0
2023-08-25 04:19:00	SPY	ETF	437.93	437.93	437.93	437.93	150.0
2023-08-25 04:21:00	SPY	ETF	438.01	438.01	438.01	438.01	400.0
2023-08-25 04:22:00	SPY	ETF	438.06	438.06	438.06	438.06	400.0
2023-08-25 04:23:00	SPY	ETF	438.14	438.24	438.13	438.24	4734.0
2023-08-25 04:24:00	SPY	ETF	438.17	438.21	438.17	438.21	570.0
2023-08-25 04:25:00	SPY	ETF	438.11	438.22	438.08	438.16	1670.0
2023-08-25 04:26:00	SPY	ETF	438.06	438.06	438.06	438.06	600.0
2023-08-25 04:27:00	SPY	ETF	438.05	438.05	438.03	438.03	600.0
2023-08-25 04:28:00	SPY	ETF	438.03	438.03	438.03	438.03	100.0
2023-08-25 04:29:00	SPY	ETF	438.03	438.03	438.02	438.02	1909.0
2023-08-25 04:30:00	SPY	ETF	438.06	438.07	438.06	438.07	635.0
2023-08-25 04:32:00	SPY	ETF	438.04	438.04	438.03	438.03	265.0
2023-08-25 04:35:00	SPY	ETF	438.1	438.1	438.1	438.1	140.0
2023-08-25 04:37:00	SPY	ETF	438.16	438.16	438.16	438.16	134.0
2023-08-25 04:38:00	SPY	ETF	438.1	438.1	438.1	438.1	155.0
2023-08-25 04:39:00	SPY	ETF	438.02	438.02	437.92	437.92	2032.0
2023-08-25 04:40:00	SPY	ETF	437.99	437.99	437.99	437.99	163.0
2023-08-25 04:45:00	SPY	ETF	437.93	437.93	437.93	437.93	400.0
2023-08-25 04:46:00	SPY	ETF	437.76	437.76	437.76	437.76	200.0
2023-08-25 04:49:00	SPY	ETF	437.71	437.71	437.71	437.71	100.0
2023-08-25 04:50:00	SPY	ETF	437.71	437.71	437.71	437.71	120.0
2023-08-25 04:51:00	SPY	ETF	437.76	437.77	437.75	437.75	318.0
2023-08-25 04:52:00	SPY	ETF	437.78	437.81	437.78	437.81	595.0
2023-08-25 04:53:00	SPY	ETF	437.8	437.8	437.8	437.8	270.0
2023-08-25 04:57:00	SPY	ETF	438.0	438.0	438.0	438.0	100.0
2023-08-25 04:58:00	SPY	ETF	438.0	438.0	437.95	437.98	880.0
2023-08-25 04:59:00	SPY	ETF	437.99	437.99	437.99	437.99	105.0
2023-08-25 05:00:00	SPY	ETF	438.03	438.03	438.03	438.03	142.0
2023-08-25 05:01:00	SPY	ETF	437.88	437.88	437.88	437.88	100.0
2023-08-25 05:05:00	SPY	ETF	437.83	437.83	437.83	437.83	100.0
2023-08-25 05:07:00	SPY	ETF	437.69	437.69	437.69	437.69	358.0
2023-08-25 05:09:00	SPY	ETF	437.77	437.77	437.77	437.77	210.0
2023-08-25 05:10:00	SPY	ETF	437.81	437.81	437.81	437.81	180.0
2023-08-25 05:12:00	SPY	ETF	437.86	437.86	437.86	437.86	400.0

> showing 50 of 254,103 rows — these rows as CSV

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