PREVIEW / etf_1min / 2023-01-20

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-01-20.parquet
  size:    4.6 MB
  rows:    253,486

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-01-20 04:01:00	SPY	ETF	389.37	389.37	389.37	389.37	500.0
2023-01-20 04:03:00	SPY	ETF	389.42	389.42	389.25	389.25	765.0
2023-01-20 04:04:00	SPY	ETF	389.22	389.22	389.22	389.22	100.0
2023-01-20 04:06:00	SPY	ETF	389.15	389.15	389.15	389.15	200.0
2023-01-20 04:07:00	SPY	ETF	389.01	389.01	388.84	388.84	4802.0
2023-01-20 04:08:00	SPY	ETF	388.78	388.78	388.78	388.78	140.0
2023-01-20 04:09:00	SPY	ETF	388.83	388.85	388.83	388.85	5603.0
2023-01-20 04:10:00	SPY	ETF	388.87	388.87	388.85	388.85	200.0
2023-01-20 04:11:00	SPY	ETF	388.73	388.73	388.7	388.7	1000.0
2023-01-20 04:12:00	SPY	ETF	388.71	388.71	388.7	388.7	300.0
2023-01-20 04:13:00	SPY	ETF	388.67	388.7	388.67	388.7	256.0
2023-01-20 04:14:00	SPY	ETF	388.65	388.66	388.65	388.66	200.0
2023-01-20 04:15:00	SPY	ETF	388.72	388.72	388.72	388.72	150.0
2023-01-20 04:16:00	SPY	ETF	388.94	389.01	388.94	389.01	209.0
2023-01-20 04:17:00	SPY	ETF	389.05	389.05	389.05	389.05	600.0
2023-01-20 04:18:00	SPY	ETF	389.17	389.17	389.17	389.17	100.0
2023-01-20 04:21:00	SPY	ETF	389.44	389.44	389.44	389.44	100.0
2023-01-20 04:22:00	SPY	ETF	389.46	389.46	389.46	389.46	200.0
2023-01-20 04:24:00	SPY	ETF	389.28	389.28	389.28	389.28	300.0
2023-01-20 04:25:00	SPY	ETF	389.44	389.44	389.44	389.44	100.0
2023-01-20 04:26:00	SPY	ETF	389.41	389.41	389.39	389.39	200.0
2023-01-20 04:29:00	SPY	ETF	389.28	389.28	389.28	389.28	1100.0
2023-01-20 04:30:00	SPY	ETF	389.23	389.23	389.23	389.23	100.0
2023-01-20 04:31:00	SPY	ETF	389.28	389.28	389.23	389.23	200.0
2023-01-20 04:32:00	SPY	ETF	389.24	389.24	389.2	389.2	400.0
2023-01-20 04:33:00	SPY	ETF	389.35	389.35	389.35	389.35	400.0
2023-01-20 04:34:00	SPY	ETF	389.39	389.39	389.36	389.36	366.0
2023-01-20 04:35:00	SPY	ETF	389.36	389.36	389.35	389.35	1000.0
2023-01-20 04:39:00	SPY	ETF	389.3	389.3	389.28	389.28	600.0
2023-01-20 04:41:00	SPY	ETF	389.25	389.25	389.21	389.21	901.0
2023-01-20 04:43:00	SPY	ETF	389.2	389.2	389.14	389.14	1499.0
2023-01-20 04:44:00	SPY	ETF	389.12	389.15	389.12	389.15	900.0
2023-01-20 04:45:00	SPY	ETF	389.1	389.1	389.06	389.06	1269.0
2023-01-20 04:46:00	SPY	ETF	389.01	389.01	389.0	389.0	1500.0
2023-01-20 04:48:00	SPY	ETF	389.0	389.0	389.0	389.0	300.0
2023-01-20 04:49:00	SPY	ETF	389.06	389.06	388.98	388.98	656.0
2023-01-20 04:50:00	SPY	ETF	388.99	389.01	388.99	389.01	742.0
2023-01-20 04:51:00	SPY	ETF	389.0	389.0	389.0	389.0	289.0
2023-01-20 04:52:00	SPY	ETF	389.14	389.14	389.14	389.14	251.0
2023-01-20 04:53:00	SPY	ETF	389.1	389.1	389.1	389.1	289.0
2023-01-20 04:54:00	SPY	ETF	389.08	389.13	389.08	389.13	339.0
2023-01-20 04:56:00	SPY	ETF	389.0	389.0	388.82	388.85	876.0
2023-01-20 04:57:00	SPY	ETF	388.83	388.83	388.81	388.81	1848.0
2023-01-20 04:58:00	SPY	ETF	388.81	388.81	388.79	388.81	864.0
2023-01-20 04:59:00	SPY	ETF	388.83	388.84	388.8	388.8	676.0
2023-01-20 05:00:00	SPY	ETF	388.76	388.76	388.72	388.72	834.0
2023-01-20 05:01:00	SPY	ETF	388.72	388.72	388.71	388.71	300.0
2023-01-20 05:02:00	SPY	ETF	388.7	388.7	388.65	388.65	807.0
2023-01-20 05:03:00	SPY	ETF	388.69	388.69	388.64	388.64	1099.0
2023-01-20 05:04:00	SPY	ETF	388.62	388.62	388.62	388.62	288.0

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

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