PREVIEW / etf_1min / 2023-03-16

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-03-16.parquet
  size:    4.9 MB
  rows:    285,296

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-16 04:00:00	SPY	ETF	390.54	390.93	390.27	390.93	1044.0
2023-03-16 04:01:00	SPY	ETF	390.91	390.93	390.79	390.79	7000.0
2023-03-16 04:02:00	SPY	ETF	390.95	390.96	390.95	390.95	2900.0
2023-03-16 04:03:00	SPY	ETF	390.83	390.94	390.8	390.8	6375.0
2023-03-16 04:04:00	SPY	ETF	390.88	390.94	390.77	390.78	2681.0
2023-03-16 04:05:00	SPY	ETF	390.76	390.76	390.69	390.69	1435.0
2023-03-16 04:06:00	SPY	ETF	390.59	390.59	390.59	390.59	100.0
2023-03-16 04:07:00	SPY	ETF	390.5	390.52	390.5	390.52	3280.0
2023-03-16 04:08:00	SPY	ETF	390.33	390.56	390.33	390.56	207.0
2023-03-16 04:09:00	SPY	ETF	390.49	390.49	390.47	390.47	400.0
2023-03-16 04:10:00	SPY	ETF	390.43	390.59	390.42	390.59	2012.0
2023-03-16 04:11:00	SPY	ETF	390.63	390.64	390.5	390.5	900.0
2023-03-16 04:12:00	SPY	ETF	390.36	390.47	390.36	390.47	1047.0
2023-03-16 04:13:00	SPY	ETF	390.27	390.27	390.17	390.17	1001.0
2023-03-16 04:15:00	SPY	ETF	389.81	389.81	389.55	389.55	3600.0
2023-03-16 04:16:00	SPY	ETF	389.61	389.62	389.5	389.51	575.0
2023-03-16 04:17:00	SPY	ETF	389.54	389.56	389.5	389.5	6216.0
2023-03-16 04:18:00	SPY	ETF	389.52	389.52	389.52	389.52	1200.0
2023-03-16 04:21:00	SPY	ETF	389.51	389.54	389.51	389.54	780.0
2023-03-16 04:22:00	SPY	ETF	389.64	389.69	389.6	389.67	3109.0
2023-03-16 04:24:00	SPY	ETF	389.51	389.51	389.48	389.48	600.0
2023-03-16 04:25:00	SPY	ETF	389.62	389.83	389.62	389.83	1180.0
2023-03-16 04:26:00	SPY	ETF	389.76	390.0	389.71	390.0	1902.0
2023-03-16 04:27:00	SPY	ETF	390.02	390.02	389.9	389.9	390.0
2023-03-16 04:29:00	SPY	ETF	389.77	389.77	389.77	389.77	100.0
2023-03-16 04:30:00	SPY	ETF	390.12	390.2	390.12	390.15	806.0
2023-03-16 04:32:00	SPY	ETF	390.0	390.07	389.87	390.07	2224.0
2023-03-16 04:34:00	SPY	ETF	389.8	389.8	389.78	389.8	900.0
2023-03-16 04:35:00	SPY	ETF	389.79	389.91	389.79	389.8	2700.0
2023-03-16 04:36:00	SPY	ETF	389.94	389.99	389.94	389.99	480.0
2023-03-16 04:37:00	SPY	ETF	390.24	390.24	390.21	390.21	200.0
2023-03-16 04:38:00	SPY	ETF	390.12	390.13	390.12	390.13	800.0
2023-03-16 04:39:00	SPY	ETF	390.04	390.22	390.04	390.22	1700.0
2023-03-16 04:41:00	SPY	ETF	390.3	390.34	390.27	390.27	2100.0
2023-03-16 04:42:00	SPY	ETF	390.29	390.34	390.19	390.19	1550.0
2023-03-16 04:43:00	SPY	ETF	390.04	390.19	390.04	390.19	610.0
2023-03-16 04:44:00	SPY	ETF	390.29	390.29	390.27	390.29	2890.0
2023-03-16 04:45:00	SPY	ETF	390.17	390.17	390.17	390.17	100.0
2023-03-16 04:47:00	SPY	ETF	390.19	390.19	390.19	390.19	370.0
2023-03-16 04:49:00	SPY	ETF	389.95	389.95	389.7	389.81	4500.0
2023-03-16 04:50:00	SPY	ETF	389.73	389.73	389.73	389.73	400.0
2023-03-16 04:51:00	SPY	ETF	389.56	389.56	389.56	389.56	200.0
2023-03-16 04:52:00	SPY	ETF	389.67	389.67	389.51	389.51	1000.0
2023-03-16 04:53:00	SPY	ETF	389.44	389.73	389.44	389.66	1215.0
2023-03-16 04:55:00	SPY	ETF	389.55	389.55	389.55	389.55	2828.0
2023-03-16 04:56:00	SPY	ETF	389.5	389.5	389.48	389.49	2100.0
2023-03-16 04:57:00	SPY	ETF	389.42	389.42	389.4	389.4	500.0
2023-03-16 04:58:00	SPY	ETF	389.51	389.61	389.51	389.61	2115.0
2023-03-16 04:59:00	SPY	ETF	389.37	389.37	389.34	389.34	215.0
2023-03-16 05:00:00	SPY	ETF	389.32	389.32	389.29	389.3	3015.0

> showing 50 of 285,296 rows — these rows as CSV

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