PREVIEW / etf_1min / 2023-10-09

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-10-09.parquet
  size:    4.5 MB
  rows:    253,023

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-09 04:00:00	SPY	ETF	426.08	426.91	426.0	426.18	5118.0
2023-10-09 04:01:00	SPY	ETF	426.18	426.18	425.97	425.97	5385.0
2023-10-09 04:02:00	SPY	ETF	426.19	426.27	426.14	426.27	2275.0
2023-10-09 04:03:00	SPY	ETF	426.31	426.53	426.31	426.46	3139.0
2023-10-09 04:04:00	SPY	ETF	426.41	426.41	426.12	426.12	1593.0
2023-10-09 04:05:00	SPY	ETF	426.11	426.11	425.95	426.0	5234.0
2023-10-09 04:06:00	SPY	ETF	426.06	426.06	426.02	426.02	1334.0
2023-10-09 04:07:00	SPY	ETF	426.15	426.15	426.1	426.1	241.0
2023-10-09 04:08:00	SPY	ETF	426.01	426.06	426.01	426.06	413.0
2023-10-09 04:09:00	SPY	ETF	426.04	426.07	426.02	426.05	1718.0
2023-10-09 04:10:00	SPY	ETF	426.2	426.35	426.19	426.35	1425.0
2023-10-09 04:11:00	SPY	ETF	426.38	426.41	426.38	426.4	1772.0
2023-10-09 04:12:00	SPY	ETF	426.29	426.29	426.15	426.15	1919.0
2023-10-09 04:13:00	SPY	ETF	426.16	426.16	426.15	426.15	1200.0
2023-10-09 04:14:00	SPY	ETF	426.28	426.28	426.28	426.28	250.0
2023-10-09 04:15:00	SPY	ETF	426.34	426.34	426.25	426.25	1025.0
2023-10-09 04:16:00	SPY	ETF	426.26	426.26	426.21	426.21	1125.0
2023-10-09 04:17:00	SPY	ETF	426.2	426.2	426.15	426.15	2400.0
2023-10-09 04:18:00	SPY	ETF	426.12	426.22	426.12	426.22	1550.0
2023-10-09 04:21:00	SPY	ETF	426.32	426.32	426.23	426.23	1000.0
2023-10-09 04:22:00	SPY	ETF	426.3	426.42	426.3	426.42	1573.0
2023-10-09 04:23:00	SPY	ETF	426.38	426.38	426.38	426.38	150.0
2023-10-09 04:24:00	SPY	ETF	426.0	426.0	425.95	425.95	3776.0
2023-10-09 04:25:00	SPY	ETF	426.0	426.08	425.96	426.08	1056.0
2023-10-09 04:26:00	SPY	ETF	426.1	426.1	426.1	426.1	500.0
2023-10-09 04:27:00	SPY	ETF	426.13	426.16	426.0	426.0	2700.0
2023-10-09 04:28:00	SPY	ETF	426.08	426.08	426.08	426.08	180.0
2023-10-09 04:29:00	SPY	ETF	425.98	425.98	425.98	425.98	175.0
2023-10-09 04:30:00	SPY	ETF	426.03	426.03	426.03	426.03	100.0
2023-10-09 04:31:00	SPY	ETF	426.08	426.21	426.08	426.21	225.0
2023-10-09 04:32:00	SPY	ETF	426.39	426.5	426.39	426.5	500.0
2023-10-09 04:33:00	SPY	ETF	426.49	426.49	426.48	426.48	475.0
2023-10-09 04:34:00	SPY	ETF	426.36	426.41	426.36	426.39	565.0
2023-10-09 04:35:00	SPY	ETF	426.23	426.23	426.23	426.23	325.0
2023-10-09 04:36:00	SPY	ETF	426.3	426.3	426.3	426.3	200.0
2023-10-09 04:37:00	SPY	ETF	426.51	426.55	426.51	426.55	600.0
2023-10-09 04:38:00	SPY	ETF	426.64	426.66	426.61	426.66	364.0
2023-10-09 04:39:00	SPY	ETF	426.67	426.67	426.62	426.62	300.0
2023-10-09 04:40:00	SPY	ETF	426.76	426.78	426.73	426.78	675.0
2023-10-09 04:41:00	SPY	ETF	426.77	426.82	426.72	426.78	1613.0
2023-10-09 04:42:00	SPY	ETF	426.75	426.86	426.75	426.86	369.0
2023-10-09 04:43:00	SPY	ETF	426.81	426.9	426.81	426.87	1400.0
2023-10-09 04:44:00	SPY	ETF	426.92	426.92	426.8	426.8	1915.0
2023-10-09 04:45:00	SPY	ETF	426.84	426.84	426.82	426.82	1223.0
2023-10-09 04:46:00	SPY	ETF	426.86	426.86	426.84	426.84	625.0
2023-10-09 04:47:00	SPY	ETF	426.81	426.81	426.81	426.81	275.0
2023-10-09 04:48:00	SPY	ETF	426.9	426.9	426.9	426.9	876.0
2023-10-09 04:50:00	SPY	ETF	426.91	426.91	426.91	426.91	100.0
2023-10-09 04:51:00	SPY	ETF	426.92	426.96	426.9	426.95	714.0
2023-10-09 04:52:00	SPY	ETF	426.99	427.01	426.99	426.99	1850.0

> showing 50 of 253,023 rows — these rows as CSV

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