PREVIEW / etf_1min / 2023-07-11

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-07-11.parquet
  size:    4.5 MB
  rows:    252,421

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-11 04:00:00	SPY	ETF	439.68	439.72	439.58	439.6	1298.0
2023-07-11 04:01:00	SPY	ETF	439.58	439.58	439.58	439.58	200.0
2023-07-11 04:02:00	SPY	ETF	439.5	439.55	439.49	439.49	1299.0
2023-07-11 04:03:00	SPY	ETF	439.56	439.58	439.56	439.58	321.0
2023-07-11 04:04:00	SPY	ETF	439.58	439.58	439.55	439.56	1015.0
2023-07-11 04:05:00	SPY	ETF	439.66	439.67	439.66	439.67	200.0
2023-07-11 04:06:00	SPY	ETF	439.71	439.72	439.71	439.72	568.0
2023-07-11 04:09:00	SPY	ETF	439.8	439.86	439.8	439.86	633.0
2023-07-11 04:11:00	SPY	ETF	439.87	439.87	439.87	439.87	112.0
2023-07-11 04:12:00	SPY	ETF	439.83	439.83	439.8	439.8	201.0
2023-07-11 04:13:00	SPY	ETF	439.75	439.76	439.74	439.76	862.0
2023-07-11 04:14:00	SPY	ETF	439.75	439.77	439.75	439.77	1201.0
2023-07-11 04:17:00	SPY	ETF	439.64	439.64	439.64	439.64	100.0
2023-07-11 04:20:00	SPY	ETF	439.59	439.59	439.59	439.59	100.0
2023-07-11 04:23:00	SPY	ETF	439.64	439.64	439.64	439.64	100.0
2023-07-11 04:24:00	SPY	ETF	439.65	439.65	439.65	439.65	300.0
2023-07-11 04:25:00	SPY	ETF	439.7	439.7	439.7	439.7	113.0
2023-07-11 04:26:00	SPY	ETF	439.58	439.61	439.56	439.61	300.0
2023-07-11 04:27:00	SPY	ETF	439.59	439.62	439.58	439.58	400.0
2023-07-11 04:28:00	SPY	ETF	439.58	439.63	439.58	439.63	714.0
2023-07-11 04:30:00	SPY	ETF	439.56	439.56	439.51	439.52	778.0
2023-07-11 04:31:00	SPY	ETF	439.51	439.51	439.51	439.51	200.0
2023-07-11 04:32:00	SPY	ETF	439.52	439.53	439.5	439.5	600.0
2023-07-11 04:33:00	SPY	ETF	439.5	439.52	439.5	439.52	1510.0
2023-07-11 04:34:00	SPY	ETF	439.55	439.6	439.55	439.6	400.0
2023-07-11 04:35:00	SPY	ETF	439.59	439.59	439.55	439.59	1589.0
2023-07-11 04:36:00	SPY	ETF	439.49	439.49	439.49	439.49	500.0
2023-07-11 04:38:00	SPY	ETF	439.45	439.45	439.45	439.45	370.0
2023-07-11 04:39:00	SPY	ETF	439.34	439.34	439.34	439.34	100.0
2023-07-11 04:42:00	SPY	ETF	439.37	439.37	439.25	439.25	2500.0
2023-07-11 04:43:00	SPY	ETF	439.22	439.24	439.22	439.24	1699.0
2023-07-11 04:44:00	SPY	ETF	439.25	439.25	439.24	439.24	500.0
2023-07-11 04:45:00	SPY	ETF	439.24	439.24	439.17	439.17	500.0
2023-07-11 04:46:00	SPY	ETF	439.16	439.19	439.14	439.14	1000.0
2023-07-11 04:47:00	SPY	ETF	439.18	439.19	439.18	439.19	200.0
2023-07-11 04:48:00	SPY	ETF	439.21	439.21	439.2	439.2	685.0
2023-07-11 04:50:00	SPY	ETF	439.3	439.3	439.3	439.3	100.0
2023-07-11 04:52:00	SPY	ETF	439.14	439.15	439.13	439.13	500.0
2023-07-11 04:53:00	SPY	ETF	439.18	439.21	439.17	439.21	1700.0
2023-07-11 04:55:00	SPY	ETF	439.29	439.35	439.29	439.35	1300.0
2023-07-11 04:56:00	SPY	ETF	439.4	439.4	439.4	439.4	640.0
2023-07-11 04:57:00	SPY	ETF	439.4	439.47	439.4	439.47	540.0
2023-07-11 04:58:00	SPY	ETF	439.45	439.45	439.45	439.45	100.0
2023-07-11 04:59:00	SPY	ETF	439.44	439.44	439.44	439.44	100.0
2023-07-11 05:00:00	SPY	ETF	439.42	439.42	439.38	439.38	500.0
2023-07-11 05:07:00	SPY	ETF	439.47	439.47	439.46	439.46	900.0
2023-07-11 05:10:00	SPY	ETF	439.46	439.46	439.46	439.46	100.0
2023-07-11 05:11:00	SPY	ETF	439.45	439.45	439.45	439.45	100.0
2023-07-11 05:14:00	SPY	ETF	439.56	439.61	439.56	439.61	200.0
2023-07-11 05:16:00	SPY	ETF	439.5	439.5	439.5	439.5	100.0

> showing 50 of 252,421 rows — these rows as CSV

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