PREVIEW / etf_1min / 2024-05-06

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-05-06.parquet
  size:    5.0 MB
  rows:    285,727

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
2024-05-06 04:00:00	SPY	ETF	511.93	511.94	511.89	511.9	1526.0
2024-05-06 04:01:00	SPY	ETF	511.9	511.9	511.9	511.9	100.0
2024-05-06 04:02:00	SPY	ETF	511.91	511.91	511.85	511.9	530.0
2024-05-06 04:03:00	SPY	ETF	511.89	511.89	511.89	511.89	168.0
2024-05-06 04:04:00	SPY	ETF	511.94	511.95	511.92	511.92	2765.0
2024-05-06 04:08:00	SPY	ETF	511.96	511.96	511.91	511.91	325.0
2024-05-06 04:10:00	SPY	ETF	511.99	511.99	511.99	511.99	200.0
2024-05-06 04:11:00	SPY	ETF	512.02	512.02	512.02	512.02	144.0
2024-05-06 04:12:00	SPY	ETF	512.09	512.15	512.09	512.15	500.0
2024-05-06 04:13:00	SPY	ETF	512.16	512.17	512.13	512.13	688.0
2024-05-06 04:15:00	SPY	ETF	512.15	512.15	512.15	512.15	100.0
2024-05-06 04:16:00	SPY	ETF	512.13	512.13	512.07	512.07	708.0
2024-05-06 04:17:00	SPY	ETF	512.07	512.07	512.07	512.07	300.0
2024-05-06 04:19:00	SPY	ETF	512.09	512.11	512.09	512.11	661.0
2024-05-06 04:21:00	SPY	ETF	512.17	512.2	512.16	512.2	400.0
2024-05-06 04:24:00	SPY	ETF	512.28	512.28	512.28	512.28	200.0
2024-05-06 04:25:00	SPY	ETF	512.28	512.29	512.26	512.26	950.0
2024-05-06 04:26:00	SPY	ETF	512.26	512.26	512.26	512.26	500.0
2024-05-06 04:27:00	SPY	ETF	512.3	512.32	512.3	512.32	376.0
2024-05-06 04:28:00	SPY	ETF	512.33	512.33	512.33	512.33	316.0
2024-05-06 04:29:00	SPY	ETF	512.37	512.37	512.37	512.37	100.0
2024-05-06 04:30:00	SPY	ETF	512.37	512.37	512.34	512.34	300.0
2024-05-06 04:34:00	SPY	ETF	512.47	512.47	512.44	512.44	325.0
2024-05-06 04:35:00	SPY	ETF	512.42	512.42	512.42	512.42	250.0
2024-05-06 04:36:00	SPY	ETF	512.46	512.46	512.37	512.37	336.0
2024-05-06 04:38:00	SPY	ETF	512.37	512.37	512.37	512.37	100.0
2024-05-06 04:39:00	SPY	ETF	512.37	512.37	512.37	512.37	100.0
2024-05-06 04:40:00	SPY	ETF	512.33	512.33	512.33	512.33	104.0
2024-05-06 04:41:00	SPY	ETF	512.33	512.33	512.33	512.33	375.0
2024-05-06 04:42:00	SPY	ETF	512.33	512.33	512.33	512.33	100.0
2024-05-06 04:47:00	SPY	ETF	512.33	512.33	512.33	512.33	250.0
2024-05-06 04:50:00	SPY	ETF	512.32	512.32	512.32	512.32	599.0
2024-05-06 04:54:00	SPY	ETF	512.32	512.32	512.32	512.32	312.0
2024-05-06 04:56:00	SPY	ETF	512.28	512.29	512.28	512.29	800.0
2024-05-06 05:00:00	SPY	ETF	512.38	512.38	512.38	512.38	400.0
2024-05-06 05:02:00	SPY	ETF	512.42	512.42	512.42	512.42	997.0
2024-05-06 05:06:00	SPY	ETF	512.45	512.45	512.45	512.45	100.0
2024-05-06 05:09:00	SPY	ETF	512.45	512.45	512.45	512.45	125.0
2024-05-06 05:11:00	SPY	ETF	512.4	512.4	512.4	512.4	100.0
2024-05-06 05:13:00	SPY	ETF	512.52	512.52	512.52	512.52	200.0
2024-05-06 05:17:00	SPY	ETF	512.47	512.47	512.47	512.47	100.0
2024-05-06 05:18:00	SPY	ETF	512.48	512.48	512.48	512.48	200.0
2024-05-06 05:21:00	SPY	ETF	512.5	512.5	512.5	512.5	124.0
2024-05-06 05:22:00	SPY	ETF	512.5	512.5	512.5	512.5	687.0
2024-05-06 05:23:00	SPY	ETF	512.58	512.58	512.58	512.58	163.0
2024-05-06 05:24:00	SPY	ETF	512.57	512.57	512.57	512.57	375.0
2024-05-06 05:26:00	SPY	ETF	512.65	512.66	512.65	512.66	200.0
2024-05-06 05:30:00	SPY	ETF	512.61	512.61	512.61	512.61	100.0
2024-05-06 05:34:00	SPY	ETF	512.66	512.66	512.66	512.66	600.0
2024-05-06 05:35:00	SPY	ETF	512.69	512.7	512.62	512.62	1500.0

> showing 50 of 285,727 rows — these rows as CSV

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