PREVIEW / etf_1min / 2023-07-06

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-07-06.parquet
  size:    4.7 MB
  rows:    264,448

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-07-06 04:00:00	SPY	ETF	441.5	441.5	441.45	441.49	2285.0
2023-07-06 04:01:00	SPY	ETF	441.45	441.45	441.45	441.45	200.0
2023-07-06 04:02:00	SPY	ETF	441.5	441.5	441.49	441.49	1055.0
2023-07-06 04:03:00	SPY	ETF	441.54	441.54	441.52	441.52	700.0
2023-07-06 04:04:00	SPY	ETF	441.5	441.5	441.41	441.41	1086.0
2023-07-06 04:05:00	SPY	ETF	441.43	441.49	441.43	441.43	1239.0
2023-07-06 04:06:00	SPY	ETF	441.43	441.44	441.37	441.41	1623.0
2023-07-06 04:07:00	SPY	ETF	441.4	441.4	441.38	441.38	478.0
2023-07-06 04:08:00	SPY	ETF	441.51	441.51	441.51	441.51	200.0
2023-07-06 04:09:00	SPY	ETF	441.51	441.56	441.51	441.53	2361.0
2023-07-06 04:10:00	SPY	ETF	441.5	441.52	441.49	441.52	442.0
2023-07-06 04:12:00	SPY	ETF	441.5	441.5	441.5	441.5	500.0
2023-07-06 04:13:00	SPY	ETF	441.46	441.46	441.46	441.46	113.0
2023-07-06 04:14:00	SPY	ETF	441.49	441.49	441.49	441.49	100.0
2023-07-06 04:15:00	SPY	ETF	441.48	441.48	441.48	441.48	595.0
2023-07-06 04:16:00	SPY	ETF	441.43	441.47	441.43	441.47	375.0
2023-07-06 04:17:00	SPY	ETF	441.4	441.41	441.4	441.41	200.0
2023-07-06 04:18:00	SPY	ETF	441.44	441.44	441.44	441.44	300.0
2023-07-06 04:19:00	SPY	ETF	441.5	441.5	441.5	441.5	100.0
2023-07-06 04:21:00	SPY	ETF	441.46	441.46	441.44	441.44	243.0
2023-07-06 04:22:00	SPY	ETF	441.38	441.38	441.36	441.36	200.0
2023-07-06 04:23:00	SPY	ETF	441.33	441.33	441.33	441.33	800.0
2023-07-06 04:24:00	SPY	ETF	441.3	441.3	441.3	441.3	100.0
2023-07-06 04:25:00	SPY	ETF	441.3	441.3	441.3	441.3	200.0
2023-07-06 04:26:00	SPY	ETF	441.31	441.31	441.31	441.31	200.0
2023-07-06 04:32:00	SPY	ETF	441.34	441.34	441.33	441.33	604.0
2023-07-06 04:34:00	SPY	ETF	441.37	441.37	441.31	441.31	350.0
2023-07-06 04:35:00	SPY	ETF	441.34	441.34	441.33	441.33	200.0
2023-07-06 04:36:00	SPY	ETF	441.3	441.3	441.3	441.3	100.0
2023-07-06 04:38:00	SPY	ETF	441.24	441.24	441.24	441.24	200.0
2023-07-06 04:40:00	SPY	ETF	441.33	441.36	441.33	441.36	340.0
2023-07-06 04:41:00	SPY	ETF	441.37	441.41	441.37	441.41	1191.0
2023-07-06 04:42:00	SPY	ETF	441.42	441.42	441.42	441.42	122.0
2023-07-06 04:43:00	SPY	ETF	441.41	441.41	441.41	441.41	127.0
2023-07-06 04:47:00	SPY	ETF	441.61	441.61	441.57	441.57	540.0
2023-07-06 04:48:00	SPY	ETF	441.57	441.57	441.57	441.57	200.0
2023-07-06 04:50:00	SPY	ETF	441.74	441.74	441.74	441.74	800.0
2023-07-06 04:51:00	SPY	ETF	441.68	441.68	441.61	441.61	1000.0
2023-07-06 04:52:00	SPY	ETF	441.6	441.61	441.6	441.61	500.0
2023-07-06 04:54:00	SPY	ETF	441.55	441.59	441.55	441.59	1500.0
2023-07-06 04:55:00	SPY	ETF	441.54	441.56	441.54	441.56	1355.0
2023-07-06 04:59:00	SPY	ETF	441.45	441.45	441.45	441.45	100.0
2023-07-06 05:01:00	SPY	ETF	441.28	441.34	441.28	441.34	3250.0
2023-07-06 05:04:00	SPY	ETF	441.31	441.31	441.31	441.31	114.0
2023-07-06 05:05:00	SPY	ETF	441.2	441.2	441.18	441.2	1504.0
2023-07-06 05:06:00	SPY	ETF	441.24	441.24	441.22	441.22	1400.0
2023-07-06 05:07:00	SPY	ETF	441.18	441.18	441.18	441.18	200.0
2023-07-06 05:08:00	SPY	ETF	441.27	441.27	441.27	441.27	200.0
2023-07-06 05:11:00	SPY	ETF	441.37	441.37	441.35	441.36	4980.0
2023-07-06 05:14:00	SPY	ETF	441.37	441.38	441.35	441.35	1981.0

> showing 50 of 264,448 rows — these rows as CSV

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