PREVIEW / etf_1min / 2023-03-31

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-03-31.parquet
  size:    4.6 MB
  rows:    259,797

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-03-31 04:00:00	SPY	ETF	403.81	403.81	403.81	403.81	2050.0
2023-03-31 04:01:00	SPY	ETF	403.8	403.8	403.76	403.76	1632.0
2023-03-31 04:03:00	SPY	ETF	403.8	403.82	403.75	403.75	855.0
2023-03-31 04:04:00	SPY	ETF	403.7	403.8	403.7	403.8	1318.0
2023-03-31 04:05:00	SPY	ETF	403.81	403.81	403.81	403.81	100.0
2023-03-31 04:07:00	SPY	ETF	403.85	403.85	403.85	403.85	111.0
2023-03-31 04:08:00	SPY	ETF	403.87	403.87	403.85	403.85	200.0
2023-03-31 04:09:00	SPY	ETF	403.79	403.79	403.78	403.78	217.0
2023-03-31 04:17:00	SPY	ETF	403.7	403.7	403.7	403.7	100.0
2023-03-31 04:18:00	SPY	ETF	403.6	403.6	403.6	403.6	1100.0
2023-03-31 04:19:00	SPY	ETF	403.53	403.53	403.53	403.53	150.0
2023-03-31 04:20:00	SPY	ETF	403.6	403.6	403.6	403.6	100.0
2023-03-31 04:22:00	SPY	ETF	403.68	403.68	403.68	403.68	100.0
2023-03-31 04:24:00	SPY	ETF	403.76	403.84	403.76	403.79	1800.0
2023-03-31 04:28:00	SPY	ETF	403.72	403.72	403.72	403.72	200.0
2023-03-31 04:29:00	SPY	ETF	403.79	403.79	403.78	403.78	500.0
2023-03-31 04:30:00	SPY	ETF	403.76	403.83	403.73	403.83	325.0
2023-03-31 04:32:00	SPY	ETF	403.85	403.85	403.85	403.85	116.0
2023-03-31 04:35:00	SPY	ETF	403.85	403.85	403.85	403.85	100.0
2023-03-31 04:37:00	SPY	ETF	403.83	403.83	403.83	403.83	100.0
2023-03-31 04:39:00	SPY	ETF	403.79	403.79	403.79	403.79	200.0
2023-03-31 04:40:00	SPY	ETF	403.89	403.89	403.89	403.89	100.0
2023-03-31 04:48:00	SPY	ETF	404.05	404.06	404.05	404.06	500.0
2023-03-31 04:49:00	SPY	ETF	404.05	404.05	404.05	404.05	1400.0
2023-03-31 04:54:00	SPY	ETF	403.95	403.95	403.95	403.95	500.0
2023-03-31 04:59:00	SPY	ETF	403.81	403.81	403.81	403.81	200.0
2023-03-31 05:00:00	SPY	ETF	403.87	403.87	403.87	403.87	100.0
2023-03-31 05:01:00	SPY	ETF	403.82	403.82	403.82	403.82	100.0
2023-03-31 05:03:00	SPY	ETF	403.87	403.87	403.87	403.87	100.0
2023-03-31 05:06:00	SPY	ETF	404.08	404.08	404.08	404.08	900.0
2023-03-31 05:07:00	SPY	ETF	404.18	404.18	404.18	404.18	100.0
2023-03-31 05:08:00	SPY	ETF	404.2	404.2	404.2	404.2	209.0
2023-03-31 05:10:00	SPY	ETF	404.27	404.27	404.27	404.27	357.0
2023-03-31 05:13:00	SPY	ETF	404.29	404.35	404.29	404.31	980.0
2023-03-31 05:14:00	SPY	ETF	404.31	404.31	404.31	404.31	500.0
2023-03-31 05:16:00	SPY	ETF	404.31	404.34	404.31	404.34	500.0
2023-03-31 05:17:00	SPY	ETF	404.35	404.35	404.35	404.35	100.0
2023-03-31 05:18:00	SPY	ETF	404.35	404.35	404.3	404.31	814.0
2023-03-31 05:20:00	SPY	ETF	404.33	404.33	404.28	404.28	400.0
2023-03-31 05:21:00	SPY	ETF	404.32	404.36	404.32	404.36	1399.0
2023-03-31 05:22:00	SPY	ETF	404.32	404.32	404.32	404.32	800.0
2023-03-31 05:34:00	SPY	ETF	404.44	404.44	404.44	404.44	100.0
2023-03-31 05:41:00	SPY	ETF	404.36	404.36	404.36	404.36	230.0
2023-03-31 05:42:00	SPY	ETF	404.35	404.38	404.35	404.38	210.0
2023-03-31 05:45:00	SPY	ETF	404.47	404.47	404.45	404.45	285.0
2023-03-31 05:47:00	SPY	ETF	404.53	404.53	404.53	404.53	198.0
2023-03-31 05:48:00	SPY	ETF	404.47	404.47	404.47	404.47	100.0
2023-03-31 05:49:00	SPY	ETF	404.48	404.48	404.48	404.48	2000.0
2023-03-31 05:52:00	SPY	ETF	404.24	404.24	404.24	404.24	385.0
2023-03-31 05:54:00	SPY	ETF	404.2	404.2	404.2	404.2	362.0

> showing 50 of 259,797 rows — these rows as CSV

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