PREVIEW / etf_1min / 2023-09-20

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-09-20.parquet
  size:    4.5 MB
  rows:    253,886

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-09-20 04:00:00	SPY	ETF	442.98	442.98	442.91	442.91	1600.0
2023-09-20 04:04:00	SPY	ETF	442.72	442.72	442.72	442.72	100.0
2023-09-20 04:05:00	SPY	ETF	442.65	442.72	442.65	442.72	300.0
2023-09-20 04:07:00	SPY	ETF	442.78	442.78	442.78	442.78	200.0
2023-09-20 04:09:00	SPY	ETF	442.78	442.78	442.78	442.78	125.0
2023-09-20 04:10:00	SPY	ETF	442.76	442.88	442.73	442.84	622.0
2023-09-20 04:13:00	SPY	ETF	442.73	442.73	442.71	442.71	349.0
2023-09-20 04:15:00	SPY	ETF	442.77	442.78	442.77	442.77	732.0
2023-09-20 04:16:00	SPY	ETF	442.76	442.76	442.76	442.76	100.0
2023-09-20 04:17:00	SPY	ETF	442.92	442.92	442.92	442.92	125.0
2023-09-20 04:18:00	SPY	ETF	442.94	442.94	442.94	442.94	400.0
2023-09-20 04:19:00	SPY	ETF	442.99	442.99	442.99	442.99	4000.0
2023-09-20 04:20:00	SPY	ETF	443.05	443.05	443.05	443.05	100.0
2023-09-20 04:21:00	SPY	ETF	443.05	443.05	443.05	443.05	300.0
2023-09-20 04:23:00	SPY	ETF	443.15	443.15	443.15	443.15	1140.0
2023-09-20 04:24:00	SPY	ETF	443.25	443.25	443.24	443.25	3675.0
2023-09-20 04:25:00	SPY	ETF	443.2	443.2	443.15	443.19	3000.0
2023-09-20 04:26:00	SPY	ETF	443.15	443.15	443.15	443.15	677.0
2023-09-20 04:27:00	SPY	ETF	443.18	443.24	443.18	443.24	220.0
2023-09-20 04:29:00	SPY	ETF	443.15	443.15	443.15	443.15	300.0
2023-09-20 04:30:00	SPY	ETF	443.16	443.16	443.16	443.16	625.0
2023-09-20 04:31:00	SPY	ETF	443.17	443.17	443.17	443.17	100.0
2023-09-20 04:32:00	SPY	ETF	443.25	443.25	443.25	443.25	1187.0
2023-09-20 04:33:00	SPY	ETF	443.25	443.25	443.25	443.25	500.0
2023-09-20 04:34:00	SPY	ETF	443.26	443.3	443.26	443.3	795.0
2023-09-20 04:36:00	SPY	ETF	443.3	443.3	443.27	443.27	1178.0
2023-09-20 04:37:00	SPY	ETF	443.26	443.27	443.26	443.27	312.0
2023-09-20 04:40:00	SPY	ETF	443.26	443.31	443.26	443.31	2627.0
2023-09-20 04:43:00	SPY	ETF	443.32	443.35	443.32	443.35	1639.0
2023-09-20 04:45:00	SPY	ETF	443.35	443.44	443.35	443.44	1325.0
2023-09-20 04:47:00	SPY	ETF	443.42	443.44	443.42	443.44	200.0
2023-09-20 04:48:00	SPY	ETF	443.43	443.43	443.36	443.36	321.0
2023-09-20 04:49:00	SPY	ETF	443.36	443.39	443.36	443.36	1101.0
2023-09-20 04:50:00	SPY	ETF	443.35	443.37	443.35	443.37	1300.0
2023-09-20 04:51:00	SPY	ETF	443.31	443.31	443.25	443.25	1524.0
2023-09-20 04:53:00	SPY	ETF	443.31	443.33	443.31	443.33	200.0
2023-09-20 04:54:00	SPY	ETF	443.33	443.33	443.33	443.33	100.0
2023-09-20 04:56:00	SPY	ETF	443.36	443.36	443.36	443.36	500.0
2023-09-20 04:57:00	SPY	ETF	443.4	443.4	443.4	443.4	100.0
2023-09-20 04:58:00	SPY	ETF	443.42	443.43	443.39	443.39	800.0
2023-09-20 05:00:00	SPY	ETF	443.45	443.45	443.43	443.43	240.0
2023-09-20 05:01:00	SPY	ETF	443.46	443.46	443.43	443.45	1660.0
2023-09-20 05:02:00	SPY	ETF	443.44	443.55	443.44	443.55	5500.0
2023-09-20 05:03:00	SPY	ETF	443.55	443.56	443.5	443.5	2580.0
2023-09-20 05:04:00	SPY	ETF	443.53	443.53	443.53	443.53	100.0
2023-09-20 05:05:00	SPY	ETF	443.49	443.49	443.44	443.44	575.0
2023-09-20 05:06:00	SPY	ETF	443.44	443.44	443.41	443.41	2580.0
2023-09-20 05:07:00	SPY	ETF	443.43	443.45	443.43	443.45	700.0
2023-09-20 05:08:00	SPY	ETF	443.38	443.38	443.38	443.38	100.0
2023-09-20 05:09:00	SPY	ETF	443.35	443.35	443.35	443.35	200.0

> showing 50 of 253,886 rows — these rows as CSV

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