PREVIEW / etf_1min / 2024-09-26

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-09-26.parquet
  size:    5.5 MB
  rows:    315,414

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-09-26 04:00:00	SPY	ETF	573.72	574.62	573.72	574.5	3384.0
2024-09-26 04:01:00	SPY	ETF	574.53	574.53	574.53	574.53	557.0
2024-09-26 04:02:00	SPY	ETF	574.6	574.61	574.54	574.61	2800.0
2024-09-26 04:03:00	SPY	ETF	574.53	574.53	574.43	574.43	652.0
2024-09-26 04:04:00	SPY	ETF	574.41	574.48	574.41	574.48	1549.0
2024-09-26 04:05:00	SPY	ETF	574.5	574.5	574.46	574.46	333.0
2024-09-26 04:06:00	SPY	ETF	574.48	574.52	574.48	574.52	590.0
2024-09-26 04:07:00	SPY	ETF	574.51	574.51	574.51	574.51	187.0
2024-09-26 04:08:00	SPY	ETF	574.5	574.5	574.5	574.5	1600.0
2024-09-26 04:09:00	SPY	ETF	574.36	574.4	574.36	574.36	633.0
2024-09-26 04:10:00	SPY	ETF	574.4	574.4	574.39	574.39	278.0
2024-09-26 04:13:00	SPY	ETF	574.72	574.72	574.72	574.72	211.0
2024-09-26 04:14:00	SPY	ETF	574.71	574.71	574.62	574.62	1145.0
2024-09-26 04:15:00	SPY	ETF	574.68	574.74	574.68	574.74	273.0
2024-09-26 04:16:00	SPY	ETF	574.7	574.7	574.69	574.7	649.0
2024-09-26 04:17:00	SPY	ETF	574.68	574.68	574.61	574.61	400.0
2024-09-26 04:18:00	SPY	ETF	574.65	574.65	574.6	574.6	306.0
2024-09-26 04:20:00	SPY	ETF	574.67	574.67	574.6	574.65	1205.0
2024-09-26 04:21:00	SPY	ETF	574.68	574.68	574.68	574.68	100.0
2024-09-26 04:22:00	SPY	ETF	574.67	574.67	574.67	574.67	740.0
2024-09-26 04:23:00	SPY	ETF	574.68	574.68	574.68	574.68	1001.0
2024-09-26 04:24:00	SPY	ETF	574.69	574.69	574.69	574.69	1000.0
2024-09-26 04:25:00	SPY	ETF	574.7	574.7	574.64	574.69	1401.0
2024-09-26 04:26:00	SPY	ETF	574.58	574.58	574.58	574.58	722.0
2024-09-26 04:27:00	SPY	ETF	574.57	574.6	574.55	574.55	1960.0
2024-09-26 04:28:00	SPY	ETF	574.68	574.68	574.68	574.68	300.0
2024-09-26 04:30:00	SPY	ETF	574.68	574.68	574.68	574.68	232.0
2024-09-26 04:31:00	SPY	ETF	574.67	574.67	574.66	574.67	2000.0
2024-09-26 04:35:00	SPY	ETF	574.66	574.75	574.66	574.75	5855.0
2024-09-26 04:36:00	SPY	ETF	574.82	574.82	574.7	574.7	1091.0
2024-09-26 04:37:00	SPY	ETF	574.65	574.65	574.65	574.65	561.0
2024-09-26 04:38:00	SPY	ETF	574.63	574.63	574.58	574.58	361.0
2024-09-26 04:39:00	SPY	ETF	574.58	574.58	574.51	574.51	1142.0
2024-09-26 04:42:00	SPY	ETF	574.45	574.45	574.41	574.41	508.0
2024-09-26 04:43:00	SPY	ETF	574.41	574.41	574.41	574.41	100.0
2024-09-26 04:44:00	SPY	ETF	574.34	574.37	574.33	574.37	540.0
2024-09-26 04:45:00	SPY	ETF	574.41	574.41	574.41	574.41	100.0
2024-09-26 04:48:00	SPY	ETF	574.42	574.42	574.42	574.42	100.0
2024-09-26 04:49:00	SPY	ETF	574.42	574.42	574.41	574.42	2961.0
2024-09-26 04:50:00	SPY	ETF	574.42	574.43	574.41	574.41	820.0
2024-09-26 04:53:00	SPY	ETF	574.4	574.4	574.4	574.4	500.0
2024-09-26 04:59:00	SPY	ETF	574.57	574.57	574.57	574.57	100.0
2024-09-26 05:00:00	SPY	ETF	574.52	574.52	574.48	574.48	784.0
2024-09-26 05:01:00	SPY	ETF	574.46	574.53	574.46	574.53	687.0
2024-09-26 05:03:00	SPY	ETF	574.34	574.39	574.34	574.39	374.0
2024-09-26 05:04:00	SPY	ETF	574.4	574.4	574.4	574.4	100.0
2024-09-26 05:05:00	SPY	ETF	574.39	574.43	574.39	574.43	623.0
2024-09-26 05:07:00	SPY	ETF	574.43	574.43	574.4	574.4	351.0
2024-09-26 05:08:00	SPY	ETF	574.39	574.39	574.39	574.39	187.0
2024-09-26 05:09:00	SPY	ETF	574.39	574.39	574.39	574.39	100.0

> showing 50 of 315,414 rows — these rows as CSV

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