PREVIEW / etf_1min / 2024-11-27

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-11-27.parquet
  size:    5.5 MB
  rows:    312,672

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-11-27 04:00:00	SPY	ETF	600.11	600.15	600.05	600.15	608.0
2024-11-27 04:01:00	SPY	ETF	600.05	600.05	600.05	600.05	119.0
2024-11-27 04:04:00	SPY	ETF	600.31	600.34	600.3	600.34	516.0
2024-11-27 04:05:00	SPY	ETF	600.33	600.33	600.27	600.27	316.0
2024-11-27 04:06:00	SPY	ETF	600.4	600.4	600.4	600.4	188.0
2024-11-27 04:09:00	SPY	ETF	600.15	600.15	600.15	600.15	355.0
2024-11-27 04:10:00	SPY	ETF	600.1	600.1	600.1	600.1	1687.0
2024-11-27 04:11:00	SPY	ETF	600.13	600.22	600.13	600.22	287.0
2024-11-27 04:17:00	SPY	ETF	600.2	600.2	600.2	600.2	160.0
2024-11-27 04:18:00	SPY	ETF	600.2	600.2	600.2	600.2	600.0
2024-11-27 04:19:00	SPY	ETF	600.07	600.07	600.01	600.01	500.0
2024-11-27 04:20:00	SPY	ETF	600.09	600.09	599.95	599.96	1517.0
2024-11-27 04:22:00	SPY	ETF	599.91	599.91	599.91	599.91	200.0
2024-11-27 04:23:00	SPY	ETF	599.92	600.04	599.92	600.04	287.0
2024-11-27 04:25:00	SPY	ETF	600.17	600.17	600.17	600.17	100.0
2024-11-27 04:28:00	SPY	ETF	599.96	599.96	599.96	599.96	243.0
2024-11-27 04:29:00	SPY	ETF	599.96	599.96	599.96	599.96	362.0
2024-11-27 04:30:00	SPY	ETF	600.0	600.01	600.0	600.01	1161.0
2024-11-27 04:31:00	SPY	ETF	599.9	599.9	599.77	599.77	500.0
2024-11-27 04:33:00	SPY	ETF	599.77	599.77	599.7	599.7	1079.0
2024-11-27 04:34:00	SPY	ETF	599.68	599.68	599.68	599.68	100.0
2024-11-27 04:35:00	SPY	ETF	599.73	599.8	599.72	599.73	1900.0
2024-11-27 04:36:00	SPY	ETF	599.77	599.82	599.7	599.82	777.0
2024-11-27 04:37:00	SPY	ETF	599.76	599.76	599.76	599.76	167.0
2024-11-27 04:40:00	SPY	ETF	599.9	599.9	599.89	599.9	630.0
2024-11-27 04:42:00	SPY	ETF	599.82	599.82	599.82	599.82	100.0
2024-11-27 04:45:00	SPY	ETF	599.87	599.87	599.7	599.7	1200.0
2024-11-27 04:47:00	SPY	ETF	599.9	599.9	599.9	599.9	498.0
2024-11-27 04:48:00	SPY	ETF	599.9	599.97	599.9	599.92	15953.0
2024-11-27 04:49:00	SPY	ETF	599.9	599.92	599.84	599.84	1200.0
2024-11-27 04:57:00	SPY	ETF	599.97	599.97	599.97	599.97	732.0
2024-11-27 04:58:00	SPY	ETF	599.97	599.97	599.87	599.87	1077.0
2024-11-27 05:00:00	SPY	ETF	599.97	599.97	599.97	599.97	1194.0
2024-11-27 05:08:00	SPY	ETF	599.79	599.79	599.79	599.79	100.0
2024-11-27 05:10:00	SPY	ETF	599.76	599.76	599.76	599.76	187.0
2024-11-27 05:15:00	SPY	ETF	600.02	600.02	600.0	600.0	1037.0
2024-11-27 05:16:00	SPY	ETF	600.04	600.08	600.04	600.08	200.0
2024-11-27 05:22:00	SPY	ETF	599.95	599.95	599.95	599.95	199.0
2024-11-27 05:27:00	SPY	ETF	600.0	600.0	600.0	600.0	100.0
2024-11-27 05:30:00	SPY	ETF	600.03	600.03	600.03	600.03	267.0
2024-11-27 05:38:00	SPY	ETF	600.0	600.0	600.0	600.0	284.0
2024-11-27 05:41:00	SPY	ETF	600.0	600.0	600.0	600.0	374.0
2024-11-27 05:44:00	SPY	ETF	599.89	599.89	599.89	599.89	187.0
2024-11-27 05:45:00	SPY	ETF	599.91	599.91	599.91	599.91	100.0
2024-11-27 06:06:00	SPY	ETF	600.06	600.06	600.06	600.06	100.0
2024-11-27 06:09:00	SPY	ETF	600.07	600.07	600.0	600.0	1595.0
2024-11-27 06:11:00	SPY	ETF	599.94	599.94	599.94	599.94	1000.0
2024-11-27 06:13:00	SPY	ETF	599.93	599.93	599.93	599.93	300.0
2024-11-27 06:15:00	SPY	ETF	599.87	599.87	599.81	599.81	987.0
2024-11-27 06:16:00	SPY	ETF	599.88	599.88	599.88	599.88	238.0

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

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