PREVIEW / etf_1min / 2024-07-18

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-07-18.parquet
  size:    5.5 MB
  rows:    312,086

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-18 04:00:00	SPY	ETF	558.27	558.32	558.27	558.3	1023.0
2024-07-18 04:01:00	SPY	ETF	558.23	558.3	558.23	558.3	923.0
2024-07-18 04:02:00	SPY	ETF	558.24	558.24	558.24	558.24	333.0
2024-07-18 04:03:00	SPY	ETF	558.25	558.28	558.21	558.21	993.0
2024-07-18 04:04:00	SPY	ETF	558.18	558.18	558.12	558.12	801.0
2024-07-18 04:05:00	SPY	ETF	558.01	558.17	558.01	558.13	2036.0
2024-07-18 04:06:00	SPY	ETF	557.93	557.93	557.89	557.89	343.0
2024-07-18 04:07:00	SPY	ETF	558.1	558.1	558.1	558.1	139.0
2024-07-18 04:08:00	SPY	ETF	558.18	558.18	558.18	558.18	300.0
2024-07-18 04:11:00	SPY	ETF	558.13	558.13	558.13	558.13	100.0
2024-07-18 04:17:00	SPY	ETF	558.07	558.07	558.07	558.07	100.0
2024-07-18 04:18:00	SPY	ETF	557.96	557.96	557.96	557.96	136.0
2024-07-18 04:19:00	SPY	ETF	558.04	558.04	558.04	558.04	100.0
2024-07-18 04:21:00	SPY	ETF	558.11	558.21	558.11	558.2	1700.0
2024-07-18 04:22:00	SPY	ETF	558.35	558.35	558.35	558.35	250.0
2024-07-18 04:25:00	SPY	ETF	558.24	558.24	558.24	558.24	145.0
2024-07-18 04:26:00	SPY	ETF	558.2	558.2	558.16	558.16	489.0
2024-07-18 04:27:00	SPY	ETF	558.16	558.16	558.16	558.16	294.0
2024-07-18 04:28:00	SPY	ETF	558.13	558.13	558.13	558.13	582.0
2024-07-18 04:30:00	SPY	ETF	558.26	558.26	558.26	558.26	300.0
2024-07-18 04:32:00	SPY	ETF	558.32	558.5	558.32	558.5	598.0
2024-07-18 04:33:00	SPY	ETF	558.6	558.6	558.6	558.6	300.0
2024-07-18 04:34:00	SPY	ETF	558.74	558.8	558.74	558.8	463.0
2024-07-18 04:37:00	SPY	ETF	558.62	558.75	558.62	558.73	590.0
2024-07-18 04:38:00	SPY	ETF	558.79	558.79	558.79	558.79	116.0
2024-07-18 04:40:00	SPY	ETF	558.71	558.71	558.7	558.7	500.0
2024-07-18 04:42:00	SPY	ETF	558.84	558.84	558.75	558.75	231.0
2024-07-18 04:43:00	SPY	ETF	558.7	558.75	558.7	558.74	430.0
2024-07-18 04:45:00	SPY	ETF	558.85	558.85	558.85	558.85	141.0
2024-07-18 04:46:00	SPY	ETF	558.7	558.7	558.66	558.66	491.0
2024-07-18 04:48:00	SPY	ETF	558.79	558.82	558.79	558.82	222.0
2024-07-18 04:49:00	SPY	ETF	558.74	558.74	558.74	558.74	100.0
2024-07-18 04:50:00	SPY	ETF	558.84	558.84	558.81	558.81	412.0
2024-07-18 04:51:00	SPY	ETF	558.76	558.76	558.76	558.76	200.0
2024-07-18 04:53:00	SPY	ETF	558.85	558.85	558.78	558.78	306.0
2024-07-18 04:55:00	SPY	ETF	558.82	558.84	558.82	558.84	222.0
2024-07-18 04:56:00	SPY	ETF	558.84	558.84	558.84	558.84	200.0
2024-07-18 05:02:00	SPY	ETF	558.82	558.82	558.82	558.82	100.0
2024-07-18 05:08:00	SPY	ETF	558.8	558.8	558.8	558.8	313.0
2024-07-18 05:09:00	SPY	ETF	558.85	558.85	558.85	558.85	200.0
2024-07-18 05:15:00	SPY	ETF	559.0	559.0	559.0	559.0	134.0
2024-07-18 05:19:00	SPY	ETF	558.9	558.9	558.88	558.88	335.0
2024-07-18 05:20:00	SPY	ETF	558.92	558.92	558.92	558.92	100.0
2024-07-18 05:21:00	SPY	ETF	558.92	558.92	558.92	558.92	100.0
2024-07-18 05:22:00	SPY	ETF	558.94	558.94	558.94	558.94	100.0
2024-07-18 05:26:00	SPY	ETF	558.75	558.75	558.75	558.75	124.0
2024-07-18 05:31:00	SPY	ETF	558.5	558.5	558.5	558.5	100.0
2024-07-18 05:33:00	SPY	ETF	558.24	558.24	558.24	558.24	100.0
2024-07-18 05:36:00	SPY	ETF	558.1	558.1	558.1	558.1	452.0
2024-07-18 05:37:00	SPY	ETF	558.11	558.17	558.11	558.17	1391.0

> showing 50 of 312,086 rows — these rows as CSV

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