PREVIEW / etf_1min / 2024-07-29

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-07-29.parquet
  size:    5.1 MB
  rows:    290,772

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-07-29 04:00:00	SPY	ETF	545.24	545.24	545.11	545.2	1821.0
2024-07-29 04:01:00	SPY	ETF	545.2	545.29	545.2	545.29	612.0
2024-07-29 04:02:00	SPY	ETF	545.31	545.31	545.31	545.31	281.0
2024-07-29 04:03:00	SPY	ETF	545.28	545.44	545.28	545.44	300.0
2024-07-29 04:04:00	SPY	ETF	545.43	545.51	545.42	545.48	542.0
2024-07-29 04:05:00	SPY	ETF	545.39	545.4	545.39	545.4	670.0
2024-07-29 04:06:00	SPY	ETF	545.46	545.46	545.39	545.39	600.0
2024-07-29 04:07:00	SPY	ETF	545.4	545.62	545.4	545.62	474.0
2024-07-29 04:08:00	SPY	ETF	545.72	545.72	545.72	545.72	200.0
2024-07-29 04:10:00	SPY	ETF	545.98	545.98	545.98	545.98	200.0
2024-07-29 04:11:00	SPY	ETF	545.9	545.9	545.9	545.9	300.0
2024-07-29 04:13:00	SPY	ETF	545.98	545.98	545.98	545.98	100.0
2024-07-29 04:14:00	SPY	ETF	545.95	546.01	545.93	546.01	1591.0
2024-07-29 04:22:00	SPY	ETF	546.09	546.09	546.09	546.09	100.0
2024-07-29 04:23:00	SPY	ETF	545.96	545.96	545.96	545.96	615.0
2024-07-29 04:25:00	SPY	ETF	545.82	545.82	545.82	545.82	100.0
2024-07-29 04:27:00	SPY	ETF	545.79	545.79	545.79	545.79	200.0
2024-07-29 04:29:00	SPY	ETF	545.87	545.87	545.87	545.87	300.0
2024-07-29 04:31:00	SPY	ETF	545.77	545.77	545.77	545.77	100.0
2024-07-29 04:33:00	SPY	ETF	545.82	545.86	545.82	545.86	300.0
2024-07-29 04:35:00	SPY	ETF	545.84	545.84	545.8	545.8	200.0
2024-07-29 04:37:00	SPY	ETF	545.69	545.69	545.69	545.69	100.0
2024-07-29 04:38:00	SPY	ETF	545.4	545.4	545.4	545.4	300.0
2024-07-29 04:41:00	SPY	ETF	545.21	545.3	545.21	545.3	222.0
2024-07-29 04:49:00	SPY	ETF	545.61	545.61	545.61	545.61	1000.0
2024-07-29 04:53:00	SPY	ETF	545.7	545.7	545.7	545.7	459.0
2024-07-29 04:55:00	SPY	ETF	545.6	545.6	545.6	545.6	100.0
2024-07-29 04:59:00	SPY	ETF	545.64	545.64	545.64	545.64	200.0
2024-07-29 05:00:00	SPY	ETF	545.62	545.62	545.62	545.62	100.0
2024-07-29 05:01:00	SPY	ETF	545.55	545.55	545.54	545.54	300.0
2024-07-29 05:02:00	SPY	ETF	545.58	545.58	545.58	545.58	100.0
2024-07-29 05:03:00	SPY	ETF	545.57	545.57	545.57	545.57	200.0
2024-07-29 05:21:00	SPY	ETF	545.42	545.42	545.42	545.42	950.0
2024-07-29 05:29:00	SPY	ETF	545.76	545.76	545.76	545.76	200.0
2024-07-29 05:37:00	SPY	ETF	545.87	545.88	545.87	545.88	2100.0
2024-07-29 05:39:00	SPY	ETF	545.9	545.9	545.9	545.9	100.0
2024-07-29 05:47:00	SPY	ETF	546.02	546.02	546.02	546.02	100.0
2024-07-29 06:01:00	SPY	ETF	546.33	546.33	546.33	546.33	100.0
2024-07-29 06:03:00	SPY	ETF	546.33	546.35	546.32	546.35	1049.0
2024-07-29 06:07:00	SPY	ETF	546.47	546.47	546.47	546.47	300.0
2024-07-29 06:10:00	SPY	ETF	546.5	546.5	546.5	546.5	100.0
2024-07-29 06:13:00	SPY	ETF	546.3	546.3	546.3	546.3	100.0
2024-07-29 06:15:00	SPY	ETF	546.47	546.47	546.47	546.47	100.0
2024-07-29 06:17:00	SPY	ETF	546.42	546.42	546.42	546.42	100.0
2024-07-29 06:23:00	SPY	ETF	546.63	546.63	546.63	546.63	100.0
2024-07-29 06:26:00	SPY	ETF	546.65	546.65	546.65	546.65	100.0
2024-07-29 06:28:00	SPY	ETF	546.66	546.66	546.66	546.66	200.0
2024-07-29 06:30:00	SPY	ETF	546.73	546.73	546.73	546.73	3000.0
2024-07-29 06:31:00	SPY	ETF	546.72	546.74	546.72	546.74	639.0
2024-07-29 06:34:00	SPY	ETF	546.8	546.8	546.8	546.8	100.0

> showing 50 of 290,772 rows — these rows as CSV

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