PREVIEW / etf_1min / 2023-06-20

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-06-20.parquet
  size:    4.7 MB
  rows:    262,603

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-06-20 04:00:00	SPY	ETF	438.66	438.7	438.48	438.6	5138.0
2023-06-20 04:01:00	SPY	ETF	438.67	438.67	438.67	438.67	100.0
2023-06-20 04:02:00	SPY	ETF	438.62	438.62	438.51	438.54	4703.0
2023-06-20 04:03:00	SPY	ETF	438.52	438.52	438.5	438.5	2239.0
2023-06-20 04:04:00	SPY	ETF	438.47	438.48	438.44	438.48	2097.0
2023-06-20 04:05:00	SPY	ETF	438.41	438.41	438.36	438.38	600.0
2023-06-20 04:06:00	SPY	ETF	438.39	438.39	438.37	438.37	331.0
2023-06-20 04:07:00	SPY	ETF	438.39	438.45	438.38	438.45	684.0
2023-06-20 04:08:00	SPY	ETF	438.47	438.48	438.45	438.45	1255.0
2023-06-20 04:09:00	SPY	ETF	438.42	438.42	438.39	438.4	5764.0
2023-06-20 04:10:00	SPY	ETF	438.33	438.33	438.33	438.33	200.0
2023-06-20 04:12:00	SPY	ETF	438.24	438.24	438.2	438.2	2618.0
2023-06-20 04:13:00	SPY	ETF	438.13	438.13	438.13	438.13	100.0
2023-06-20 04:15:00	SPY	ETF	438.22	438.22	438.22	438.22	150.0
2023-06-20 04:17:00	SPY	ETF	438.18	438.18	438.15	438.15	1001.0
2023-06-20 04:18:00	SPY	ETF	438.19	438.19	438.12	438.15	1570.0
2023-06-20 04:20:00	SPY	ETF	438.05	438.08	438.05	438.07	4000.0
2023-06-20 04:22:00	SPY	ETF	438.1	438.16	438.1	438.16	842.0
2023-06-20 04:23:00	SPY	ETF	438.08	438.08	438.08	438.08	727.0
2023-06-20 04:25:00	SPY	ETF	438.0	438.0	438.0	438.0	600.0
2023-06-20 04:26:00	SPY	ETF	437.9	437.9	437.83	437.83	1100.0
2023-06-20 04:27:00	SPY	ETF	437.89	437.89	437.89	437.89	200.0
2023-06-20 04:28:00	SPY	ETF	437.89	437.89	437.89	437.89	100.0
2023-06-20 04:29:00	SPY	ETF	437.85	437.86	437.84	437.84	1500.0
2023-06-20 04:30:00	SPY	ETF	437.8	437.83	437.8	437.8	980.0
2023-06-20 04:31:00	SPY	ETF	437.73	437.75	437.73	437.74	1126.0
2023-06-20 04:32:00	SPY	ETF	437.75	437.75	437.71	437.71	400.0
2023-06-20 04:33:00	SPY	ETF	437.62	437.62	437.62	437.62	200.0
2023-06-20 04:34:00	SPY	ETF	437.64	437.64	437.55	437.55	1640.0
2023-06-20 04:35:00	SPY	ETF	437.59	437.59	437.55	437.59	596.0
2023-06-20 04:36:00	SPY	ETF	437.59	437.59	437.4	437.43	2139.0
2023-06-20 04:37:00	SPY	ETF	437.4	437.4	437.4	437.4	400.0
2023-06-20 04:38:00	SPY	ETF	437.4	437.45	437.4	437.45	550.0
2023-06-20 04:39:00	SPY	ETF	437.61	437.61	437.61	437.61	100.0
2023-06-20 04:40:00	SPY	ETF	437.6	437.65	437.6	437.65	575.0
2023-06-20 04:41:00	SPY	ETF	437.68	437.72	437.68	437.72	611.0
2023-06-20 04:42:00	SPY	ETF	437.72	437.74	437.72	437.74	825.0
2023-06-20 04:43:00	SPY	ETF	437.74	437.75	437.74	437.75	7200.0
2023-06-20 04:44:00	SPY	ETF	437.81	437.81	437.7	437.7	409.0
2023-06-20 04:45:00	SPY	ETF	437.63	437.63	437.63	437.63	100.0
2023-06-20 04:46:00	SPY	ETF	437.55	437.55	437.55	437.55	106.0
2023-06-20 04:47:00	SPY	ETF	437.56	437.56	437.49	437.49	400.0
2023-06-20 04:50:00	SPY	ETF	437.41	437.41	437.33	437.33	2500.0
2023-06-20 04:51:00	SPY	ETF	437.29	437.35	437.29	437.35	3630.0
2023-06-20 04:53:00	SPY	ETF	437.25	437.25	437.25	437.25	209.0
2023-06-20 04:54:00	SPY	ETF	437.22	437.22	437.22	437.22	100.0
2023-06-20 04:55:00	SPY	ETF	437.29	437.29	437.29	437.29	114.0
2023-06-20 04:56:00	SPY	ETF	437.21	437.21	437.2	437.2	517.0
2023-06-20 04:57:00	SPY	ETF	437.25	437.39	437.25	437.39	1024.0
2023-06-20 04:58:00	SPY	ETF	437.36	437.36	437.24	437.24	900.0

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

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