PREVIEW / etf_1min / 2023-03-20

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-03-20.parquet
  size:    4.6 MB
  rows:    271,214

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-20 04:00:00	SPY	ETF	387.49	389.0	387.49	388.04	7043.0
2023-03-20 04:01:00	SPY	ETF	388.03	388.16	387.94	388.1	8097.0
2023-03-20 04:02:00	SPY	ETF	388.15	388.33	388.15	388.29	875.0
2023-03-20 04:03:00	SPY	ETF	388.24	388.27	387.86	387.86	3350.0
2023-03-20 04:04:00	SPY	ETF	387.98	388.12	387.98	388.12	513.0
2023-03-20 04:05:00	SPY	ETF	388.29	388.31	388.21	388.3	5017.0
2023-03-20 04:06:00	SPY	ETF	388.4	388.4	388.0	388.0	2709.0
2023-03-20 04:07:00	SPY	ETF	387.93	387.93	387.69	387.71	1812.0
2023-03-20 04:08:00	SPY	ETF	387.67	387.67	387.51	387.51	1100.0
2023-03-20 04:09:00	SPY	ETF	387.43	387.8	387.43	387.8	805.0
2023-03-20 04:10:00	SPY	ETF	387.7	387.7	387.54	387.55	1563.0
2023-03-20 04:11:00	SPY	ETF	387.45	387.45	387.31	387.34	915.0
2023-03-20 04:12:00	SPY	ETF	387.19	387.3	387.0	387.0	8870.0
2023-03-20 04:13:00	SPY	ETF	387.02	387.02	386.74	386.9	2805.0
2023-03-20 04:14:00	SPY	ETF	386.75	386.8	386.61	386.62	2940.0
2023-03-20 04:15:00	SPY	ETF	386.59	386.74	386.35	386.35	1650.0
2023-03-20 04:16:00	SPY	ETF	386.27	386.34	386.21	386.3	990.0
2023-03-20 04:17:00	SPY	ETF	386.22	386.3	385.91	385.91	4257.0
2023-03-20 04:18:00	SPY	ETF	385.93	385.93	385.41	385.49	3578.0
2023-03-20 04:19:00	SPY	ETF	385.41	385.51	385.23	385.23	1329.0
2023-03-20 04:20:00	SPY	ETF	385.23	385.77	385.18	385.74	2609.0
2023-03-20 04:21:00	SPY	ETF	385.9	385.94	385.8	385.8	4314.0
2023-03-20 04:22:00	SPY	ETF	385.89	385.97	385.89	385.92	1400.0
2023-03-20 04:23:00	SPY	ETF	386.01	386.08	385.83	385.83	1049.0
2023-03-20 04:24:00	SPY	ETF	385.74	385.74	385.74	385.74	100.0
2023-03-20 04:25:00	SPY	ETF	385.82	386.24	385.79	386.24	888.0
2023-03-20 04:26:00	SPY	ETF	386.11	386.17	386.0	386.0	1300.0
2023-03-20 04:27:00	SPY	ETF	385.88	386.12	385.88	386.12	3200.0
2023-03-20 04:28:00	SPY	ETF	386.13	386.36	386.11	386.13	3641.0
2023-03-20 04:29:00	SPY	ETF	386.09	386.1	386.0	386.03	2900.0
2023-03-20 04:30:00	SPY	ETF	386.07	386.23	386.07	386.23	1895.0
2023-03-20 04:31:00	SPY	ETF	386.39	386.39	385.96	386.0	4259.0
2023-03-20 04:32:00	SPY	ETF	386.14	386.39	386.14	386.39	1000.0
2023-03-20 04:33:00	SPY	ETF	386.42	386.42	386.42	386.42	400.0
2023-03-20 04:34:00	SPY	ETF	386.18	386.3	386.18	386.3	1694.0
2023-03-20 04:35:00	SPY	ETF	386.39	386.5	386.31	386.42	850.0
2023-03-20 04:36:00	SPY	ETF	386.52	386.52	386.52	386.52	800.0
2023-03-20 04:37:00	SPY	ETF	386.67	387.05	386.67	387.05	7314.0
2023-03-20 04:38:00	SPY	ETF	387.0	387.0	386.81	386.95	3720.0
2023-03-20 04:39:00	SPY	ETF	387.05	387.24	387.01	387.24	3705.0
2023-03-20 04:40:00	SPY	ETF	387.2	387.3	387.16	387.21	4245.0
2023-03-20 04:41:00	SPY	ETF	387.21	387.51	387.16	387.51	4925.0
2023-03-20 04:42:00	SPY	ETF	387.47	387.77	387.36	387.77	12072.0
2023-03-20 04:43:00	SPY	ETF	387.8	387.81	387.53	387.53	5695.0
2023-03-20 04:44:00	SPY	ETF	387.31	387.31	387.29	387.31	1600.0
2023-03-20 04:45:00	SPY	ETF	387.28	387.47	387.2	387.46	5400.0
2023-03-20 04:46:00	SPY	ETF	387.45	387.47	387.45	387.47	1129.0
2023-03-20 04:47:00	SPY	ETF	387.54	387.54	387.54	387.54	100.0
2023-03-20 04:48:00	SPY	ETF	387.58	387.69	387.55	387.69	887.0
2023-03-20 04:49:00	SPY	ETF	387.52	387.53	387.52	387.52	1600.0

> showing 50 of 271,214 rows — these rows as CSV

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