PREVIEW / etf_1min / 2023-01-09

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-01-09.parquet
  size:    4.9 MB
  rows:    278,577

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-09 04:00:00	SPY	ETF	388.37	388.61	388.37	388.61	406.0
2023-01-09 04:01:00	SPY	ETF	388.61	388.63	388.57	388.62	2742.0
2023-01-09 04:02:00	SPY	ETF	388.66	388.7	388.62	388.7	1084.0
2023-01-09 04:03:00	SPY	ETF	388.76	388.76	388.76	388.76	400.0
2023-01-09 04:04:00	SPY	ETF	388.82	388.82	388.82	388.82	100.0
2023-01-09 04:06:00	SPY	ETF	388.9	388.9	388.9	388.9	186.0
2023-01-09 04:07:00	SPY	ETF	388.8	388.82	388.73	388.73	3800.0
2023-01-09 04:11:00	SPY	ETF	388.89	388.89	388.89	388.89	100.0
2023-01-09 04:12:00	SPY	ETF	389.0	389.0	389.0	389.0	100.0
2023-01-09 04:13:00	SPY	ETF	388.96	388.96	388.9	388.9	300.0
2023-01-09 04:15:00	SPY	ETF	388.94	389.0	388.94	389.0	287.0
2023-01-09 04:17:00	SPY	ETF	389.1	389.1	389.1	389.1	200.0
2023-01-09 04:18:00	SPY	ETF	389.13	389.15	389.13	389.14	1000.0
2023-01-09 04:19:00	SPY	ETF	389.17	389.18	389.17	389.18	200.0
2023-01-09 04:21:00	SPY	ETF	389.25	389.25	389.25	389.25	500.0
2023-01-09 04:22:00	SPY	ETF	389.19	389.28	389.19	389.28	1200.0
2023-01-09 04:24:00	SPY	ETF	389.22	389.29	389.21	389.23	1800.0
2023-01-09 04:25:00	SPY	ETF	389.46	389.5	389.46	389.5	1475.0
2023-01-09 04:26:00	SPY	ETF	389.52	389.55	389.52	389.55	1400.0
2023-01-09 04:27:00	SPY	ETF	389.31	389.31	389.31	389.31	100.0
2023-01-09 04:28:00	SPY	ETF	389.28	389.33	389.28	389.33	230.0
2023-01-09 04:29:00	SPY	ETF	389.33	389.33	389.32	389.32	500.0
2023-01-09 04:30:00	SPY	ETF	389.34	389.34	389.29	389.29	600.0
2023-01-09 04:33:00	SPY	ETF	389.37	389.48	389.37	389.48	600.0
2023-01-09 04:34:00	SPY	ETF	389.4	389.4	389.4	389.4	1000.0
2023-01-09 04:35:00	SPY	ETF	389.37	389.39	389.37	389.37	2400.0
2023-01-09 04:36:00	SPY	ETF	389.53	389.54	389.53	389.54	600.0
2023-01-09 04:37:00	SPY	ETF	389.46	389.46	389.45	389.45	2500.0
2023-01-09 04:38:00	SPY	ETF	389.49	389.5	389.49	389.5	400.0
2023-01-09 04:43:00	SPY	ETF	389.5	389.5	389.5	389.5	296.0
2023-01-09 04:44:00	SPY	ETF	389.58	389.78	389.58	389.78	538.0
2023-01-09 04:45:00	SPY	ETF	389.79	389.8	389.78	389.78	1200.0
2023-01-09 04:46:00	SPY	ETF	389.63	389.67	389.63	389.67	200.0
2023-01-09 04:49:00	SPY	ETF	389.72	389.73	389.72	389.73	10000.0
2023-01-09 04:51:00	SPY	ETF	389.58	389.58	389.57	389.57	1200.0
2023-01-09 04:52:00	SPY	ETF	389.47	389.47	389.44	389.44	1700.0
2023-01-09 04:59:00	SPY	ETF	389.4	389.4	389.4	389.4	600.0
2023-01-09 05:01:00	SPY	ETF	389.35	389.35	389.35	389.35	200.0
2023-01-09 05:04:00	SPY	ETF	389.32	389.34	389.31	389.34	1898.0
2023-01-09 05:05:00	SPY	ETF	389.35	389.38	389.33	389.33	5200.0
2023-01-09 05:06:00	SPY	ETF	389.4	389.4	389.4	389.4	600.0
2023-01-09 05:07:00	SPY	ETF	389.49	389.5	389.47	389.5	1227.0
2023-01-09 05:09:00	SPY	ETF	389.47	389.47	389.47	389.47	250.0
2023-01-09 05:10:00	SPY	ETF	389.45	389.45	389.45	389.45	490.0
2023-01-09 05:11:00	SPY	ETF	389.49	389.51	389.49	389.51	1200.0
2023-01-09 05:13:00	SPY	ETF	389.6	389.65	389.6	389.65	256.0
2023-01-09 05:14:00	SPY	ETF	389.66	389.69	389.65	389.66	2400.0
2023-01-09 05:16:00	SPY	ETF	389.55	389.55	389.53	389.54	951.0
2023-01-09 05:17:00	SPY	ETF	389.51	389.51	389.51	389.51	600.0
2023-01-09 05:18:00	SPY	ETF	389.66	389.66	389.66	389.66	200.0

> showing 50 of 278,577 rows — these rows as CSV

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