PREVIEW / etf_1min / 2024-11-01

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-11-01.parquet
  size:    5.6 MB
  rows:    314,878

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-01 04:00:00	SPY	ETF	570.19	570.4	570.19	570.4	928.0
2024-11-01 04:01:00	SPY	ETF	570.33	570.33	570.33	570.33	100.0
2024-11-01 04:02:00	SPY	ETF	570.5	570.5	570.5	570.5	2154.0
2024-11-01 04:03:00	SPY	ETF	570.55	570.55	570.55	570.55	450.0
2024-11-01 04:04:00	SPY	ETF	570.53	570.68	570.53	570.68	700.0
2024-11-01 04:05:00	SPY	ETF	570.55	570.58	570.55	570.58	462.0
2024-11-01 04:06:00	SPY	ETF	570.54	570.55	570.43	570.55	1074.0
2024-11-01 04:07:00	SPY	ETF	570.56	570.56	570.53	570.53	215.0
2024-11-01 04:08:00	SPY	ETF	570.6	570.6	570.53	570.53	500.0
2024-11-01 04:10:00	SPY	ETF	570.6	570.6	570.6	570.6	977.0
2024-11-01 04:11:00	SPY	ETF	570.62	570.65	570.5	570.5	772.0
2024-11-01 04:12:00	SPY	ETF	570.67	570.67	570.6	570.67	2874.0
2024-11-01 04:13:00	SPY	ETF	570.7	570.75	570.66	570.66	1400.0
2024-11-01 04:14:00	SPY	ETF	570.67	570.67	570.67	570.67	300.0
2024-11-01 04:15:00	SPY	ETF	570.79	570.79	570.79	570.79	100.0
2024-11-01 04:16:00	SPY	ETF	570.67	570.67	570.53	570.53	1430.0
2024-11-01 04:17:00	SPY	ETF	570.64	570.64	570.57	570.57	2987.0
2024-11-01 04:18:00	SPY	ETF	570.54	570.54	570.54	570.54	587.0
2024-11-01 04:19:00	SPY	ETF	570.52	570.52	570.44	570.5	6273.0
2024-11-01 04:20:00	SPY	ETF	570.52	570.55	570.52	570.55	2035.0
2024-11-01 04:21:00	SPY	ETF	570.56	570.56	570.49	570.49	700.0
2024-11-01 04:23:00	SPY	ETF	570.45	570.49	570.45	570.49	1699.0
2024-11-01 04:25:00	SPY	ETF	570.45	570.45	570.45	570.45	300.0
2024-11-01 04:26:00	SPY	ETF	570.48	570.48	570.48	570.48	100.0
2024-11-01 04:27:00	SPY	ETF	570.6	570.6	570.59	570.59	250.0
2024-11-01 04:30:00	SPY	ETF	570.6	570.6	570.52	570.52	657.0
2024-11-01 04:31:00	SPY	ETF	570.6	570.62	570.53	570.55	1724.0
2024-11-01 04:32:00	SPY	ETF	570.54	570.57	570.54	570.57	1035.0
2024-11-01 04:33:00	SPY	ETF	570.65	570.75	570.65	570.75	956.0
2024-11-01 04:36:00	SPY	ETF	570.57	570.57	570.57	570.57	124.0
2024-11-01 04:37:00	SPY	ETF	570.71	570.71	570.71	570.71	115.0
2024-11-01 04:38:00	SPY	ETF	570.8	570.8	570.8	570.8	1371.0
2024-11-01 04:39:00	SPY	ETF	570.94	570.94	570.94	570.94	300.0
2024-11-01 04:40:00	SPY	ETF	570.82	570.84	570.82	570.84	287.0
2024-11-01 04:41:00	SPY	ETF	570.53	570.61	570.53	570.61	500.0
2024-11-01 04:42:00	SPY	ETF	570.5	570.63	570.5	570.63	487.0
2024-11-01 04:44:00	SPY	ETF	570.59	570.78	570.58	570.78	2050.0
2024-11-01 04:45:00	SPY	ETF	570.77	570.77	570.77	570.77	200.0
2024-11-01 04:46:00	SPY	ETF	570.62	570.62	570.62	570.62	200.0
2024-11-01 04:48:00	SPY	ETF	570.59	570.59	570.59	570.59	187.0
2024-11-01 04:49:00	SPY	ETF	570.57	570.57	570.57	570.57	100.0
2024-11-01 04:50:00	SPY	ETF	570.59	570.59	570.57	570.57	761.0
2024-11-01 04:51:00	SPY	ETF	570.57	570.57	570.57	570.57	100.0
2024-11-01 04:52:00	SPY	ETF	570.59	570.59	570.59	570.59	823.0
2024-11-01 04:54:00	SPY	ETF	570.61	570.61	570.52	570.54	600.0
2024-11-01 04:56:00	SPY	ETF	570.4	570.4	570.39	570.39	848.0
2024-11-01 04:59:00	SPY	ETF	570.47	570.52	570.47	570.52	300.0
2024-11-01 05:00:00	SPY	ETF	570.59	570.69	570.59	570.69	300.0
2024-11-01 05:01:00	SPY	ETF	570.68	570.68	570.58	570.67	650.0
2024-11-01 05:03:00	SPY	ETF	570.58	570.58	570.58	570.58	293.0

> showing 50 of 314,878 rows — these rows as CSV

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