PREVIEW / etf_1min / 2024-04-23

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-04-23.parquet
  size:    5.2 MB
  rows:    293,216

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
2024-04-23 04:00:00	SPY	ETF	499.8	500.22	499.8	500.22	757.0
2024-04-23 04:01:00	SPY	ETF	500.24	500.24	500.23	500.23	675.0
2024-04-23 04:02:00	SPY	ETF	500.3	500.33	500.3	500.33	2475.0
2024-04-23 04:03:00	SPY	ETF	500.3	500.3	500.3	500.3	490.0
2024-04-23 04:04:00	SPY	ETF	500.36	500.36	500.34	500.34	1900.0
2024-04-23 04:08:00	SPY	ETF	500.16	500.18	500.16	500.18	323.0
2024-04-23 04:10:00	SPY	ETF	500.24	500.38	500.24	500.38	1600.0
2024-04-23 04:11:00	SPY	ETF	500.33	500.33	500.29	500.29	1651.0
2024-04-23 04:16:00	SPY	ETF	500.69	500.69	500.69	500.69	300.0
2024-04-23 04:17:00	SPY	ETF	500.73	500.73	500.7	500.7	408.0
2024-04-23 04:18:00	SPY	ETF	500.65	500.65	500.65	500.65	100.0
2024-04-23 04:22:00	SPY	ETF	500.65	500.65	500.65	500.65	100.0
2024-04-23 04:23:00	SPY	ETF	500.71	500.71	500.71	500.71	100.0
2024-04-23 04:25:00	SPY	ETF	500.65	500.65	500.65	500.65	100.0
2024-04-23 04:26:00	SPY	ETF	500.65	500.65	500.65	500.65	200.0
2024-04-23 04:30:00	SPY	ETF	500.52	500.54	500.51	500.54	2500.0
2024-04-23 04:31:00	SPY	ETF	500.52	500.56	500.52	500.56	300.0
2024-04-23 04:32:00	SPY	ETF	500.51	500.51	500.46	500.47	4400.0
2024-04-23 04:37:00	SPY	ETF	500.0	500.0	500.0	500.0	300.0
2024-04-23 04:41:00	SPY	ETF	500.0	500.0	500.0	500.0	300.0
2024-04-23 04:42:00	SPY	ETF	500.1	500.12	500.1	500.11	3600.0
2024-04-23 04:45:00	SPY	ETF	500.15	500.15	500.15	500.15	400.0
2024-04-23 04:50:00	SPY	ETF	500.12	500.12	500.12	500.12	116.0
2024-04-23 04:53:00	SPY	ETF	500.27	500.27	500.27	500.27	1000.0
2024-04-23 04:55:00	SPY	ETF	500.22	500.22	500.19	500.19	8310.0
2024-04-23 04:56:00	SPY	ETF	500.19	500.19	500.18	500.18	1835.0
2024-04-23 04:57:00	SPY	ETF	500.2	500.23	500.15	500.15	4000.0
2024-04-23 04:58:00	SPY	ETF	500.12	500.12	500.12	500.12	1000.0
2024-04-23 04:59:00	SPY	ETF	500.07	500.07	500.07	500.07	1000.0
2024-04-23 05:00:00	SPY	ETF	500.05	500.05	500.05	500.05	1100.0
2024-04-23 05:02:00	SPY	ETF	500.3	500.31	500.3	500.31	1000.0
2024-04-23 05:08:00	SPY	ETF	500.15	500.15	500.15	500.15	579.0
2024-04-23 05:10:00	SPY	ETF	500.24	500.24	500.24	500.24	200.0
2024-04-23 05:24:00	SPY	ETF	500.21	500.22	500.21	500.22	300.0
2024-04-23 05:26:00	SPY	ETF	500.26	500.26	500.26	500.26	100.0
2024-04-23 05:29:00	SPY	ETF	500.5	500.5	500.5	500.5	100.0
2024-04-23 05:31:00	SPY	ETF	500.26	500.26	500.26	500.26	101.0
2024-04-23 05:32:00	SPY	ETF	500.23	500.23	500.23	500.23	200.0
2024-04-23 05:33:00	SPY	ETF	500.0	500.01	500.0	500.0	4068.0
2024-04-23 05:34:00	SPY	ETF	500.13	500.13	500.13	500.13	350.0
2024-04-23 05:36:00	SPY	ETF	500.23	500.23	500.23	500.23	150.0
2024-04-23 05:37:00	SPY	ETF	500.22	500.22	500.22	500.22	125.0
2024-04-23 05:41:00	SPY	ETF	500.2	500.2	500.16	500.16	200.0
2024-04-23 05:43:00	SPY	ETF	500.2	500.2	500.2	500.2	100.0
2024-04-23 05:44:00	SPY	ETF	500.08	500.08	500.08	500.08	100.0
2024-04-23 05:45:00	SPY	ETF	500.01	500.01	499.88	499.89	1000.0
2024-04-23 05:46:00	SPY	ETF	499.9	499.9	499.9	499.9	100.0
2024-04-23 05:47:00	SPY	ETF	499.97	499.98	499.97	499.98	225.0
2024-04-23 05:50:00	SPY	ETF	499.95	499.95	499.95	499.95	300.0
2024-04-23 05:52:00	SPY	ETF	499.95	499.96	499.95	499.96	200.0

> showing 50 of 293,216 rows — these rows as CSV

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