PREVIEW / etf_1min / 2023-01-27

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-01-27.parquet
  size:    4.7 MB
  rows:    262,467

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
2023-01-27 04:00:00	SPY	ETF	403.42	404.0	403.2	403.4	1519.0
2023-01-27 04:02:00	SPY	ETF	403.45	403.45	403.42	403.42	1000.0
2023-01-27 04:03:00	SPY	ETF	403.49	403.49	403.41	403.45	4031.0
2023-01-27 04:04:00	SPY	ETF	403.4	403.49	403.39	403.49	1200.0
2023-01-27 04:05:00	SPY	ETF	403.44	403.44	403.34	403.34	4270.0
2023-01-27 04:06:00	SPY	ETF	403.32	403.32	403.3	403.3	200.0
2023-01-27 04:07:00	SPY	ETF	403.37	403.37	403.36	403.36	200.0
2023-01-27 04:08:00	SPY	ETF	403.34	403.34	403.33	403.33	200.0
2023-01-27 04:09:00	SPY	ETF	403.3	403.35	403.3	403.35	5400.0
2023-01-27 04:10:00	SPY	ETF	403.36	403.36	403.36	403.36	1000.0
2023-01-27 04:11:00	SPY	ETF	403.35	403.46	403.35	403.46	1200.0
2023-01-27 04:12:00	SPY	ETF	403.39	403.46	403.39	403.46	238.0
2023-01-27 04:13:00	SPY	ETF	403.44	403.53	403.44	403.53	983.0
2023-01-27 04:14:00	SPY	ETF	403.49	403.49	403.49	403.49	100.0
2023-01-27 04:15:00	SPY	ETF	403.49	403.5	403.49	403.5	7800.0
2023-01-27 04:16:00	SPY	ETF	403.5	403.52	403.48	403.51	42150.0
2023-01-27 04:17:00	SPY	ETF	403.5	403.5	403.5	403.5	100.0
2023-01-27 04:18:00	SPY	ETF	403.46	403.51	403.46	403.51	699.0
2023-01-27 04:19:00	SPY	ETF	403.47	403.47	403.47	403.47	623.0
2023-01-27 04:20:00	SPY	ETF	403.49	403.49	403.49	403.49	114.0
2023-01-27 04:22:00	SPY	ETF	403.57	403.57	403.57	403.57	115.0
2023-01-27 04:24:00	SPY	ETF	403.39	403.39	403.39	403.39	100.0
2023-01-27 04:26:00	SPY	ETF	403.35	403.35	403.3	403.3	400.0
2023-01-27 04:27:00	SPY	ETF	403.3	403.3	403.28	403.3	974.0
2023-01-27 04:28:00	SPY	ETF	403.31	403.32	403.31	403.32	202.0
2023-01-27 04:29:00	SPY	ETF	403.32	403.32	403.32	403.32	431.0
2023-01-27 04:31:00	SPY	ETF	403.3	403.3	403.3	403.3	692.0
2023-01-27 04:32:00	SPY	ETF	403.39	403.39	403.39	403.39	100.0
2023-01-27 04:35:00	SPY	ETF	403.39	403.43	403.39	403.43	500.0
2023-01-27 04:36:00	SPY	ETF	403.44	403.44	403.44	403.44	123.0
2023-01-27 04:37:00	SPY	ETF	403.44	403.44	403.44	403.44	100.0
2023-01-27 04:38:00	SPY	ETF	403.47	403.47	403.44	403.45	2910.0
2023-01-27 04:39:00	SPY	ETF	403.46	403.46	403.46	403.46	100.0
2023-01-27 04:40:00	SPY	ETF	403.38	403.38	403.38	403.38	100.0
2023-01-27 04:42:00	SPY	ETF	403.36	403.36	403.36	403.36	100.0
2023-01-27 04:43:00	SPY	ETF	403.32	403.44	403.32	403.44	209.0
2023-01-27 04:45:00	SPY	ETF	403.45	403.45	403.45	403.45	100.0
2023-01-27 04:46:00	SPY	ETF	403.4	403.4	403.4	403.4	100.0
2023-01-27 04:47:00	SPY	ETF	403.41	403.43	403.35	403.43	400.0
2023-01-27 04:48:00	SPY	ETF	403.45	403.48	403.45	403.48	326.0
2023-01-27 04:49:00	SPY	ETF	403.49	403.68	403.49	403.62	2900.0
2023-01-27 04:50:00	SPY	ETF	403.65	403.67	403.61	403.66	800.0
2023-01-27 04:51:00	SPY	ETF	403.6	403.6	403.6	403.6	1000.0
2023-01-27 04:52:00	SPY	ETF	403.65	403.65	403.65	403.65	100.0
2023-01-27 04:53:00	SPY	ETF	403.65	403.69	403.65	403.69	276.0
2023-01-27 04:54:00	SPY	ETF	403.66	403.66	403.6	403.6	1100.0
2023-01-27 04:55:00	SPY	ETF	403.58	403.59	403.58	403.59	1100.0
2023-01-27 04:56:00	SPY	ETF	403.53	403.53	403.53	403.53	100.0
2023-01-27 04:57:00	SPY	ETF	403.57	403.57	403.57	403.57	500.0
2023-01-27 04:58:00	SPY	ETF	403.57	403.61	403.57	403.61	1516.0

> showing 50 of 262,467 rows — these rows as CSV

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