PREVIEW / etf_1min / 2022-07-28

all etf 1-min files

  file:    by_date/etf_1min/2022/2022-07-28.parquet
  size:    4.6 MB
  rows:    257,598

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
2022-07-28 04:00:00	SPY	ETF	401.04	401.04	400.17	400.34	12059.0
2022-07-28 04:01:00	SPY	ETF	400.26	400.26	400.2	400.2	1100.0
2022-07-28 04:02:00	SPY	ETF	400.08	400.08	400.08	400.08	1500.0
2022-07-28 04:05:00	SPY	ETF	400.19	400.2	400.19	400.2	4968.0
2022-07-28 04:06:00	SPY	ETF	400.06	400.1	400.06	400.07	2100.0
2022-07-28 04:07:00	SPY	ETF	400.0	400.0	400.0	400.0	760.0
2022-07-28 04:08:00	SPY	ETF	399.84	399.84	399.84	399.84	130.0
2022-07-28 04:10:00	SPY	ETF	399.98	399.98	399.98	399.98	100.0
2022-07-28 04:11:00	SPY	ETF	399.96	400.03	399.96	400.03	1500.0
2022-07-28 04:12:00	SPY	ETF	400.05	400.08	400.04	400.04	2100.0
2022-07-28 04:13:00	SPY	ETF	400.08	400.08	400.08	400.08	200.0
2022-07-28 04:18:00	SPY	ETF	400.23	400.23	400.23	400.23	893.0
2022-07-28 04:19:00	SPY	ETF	400.25	400.25	400.25	400.25	100.0
2022-07-28 04:21:00	SPY	ETF	400.21	400.21	400.19	400.19	288.0
2022-07-28 04:22:00	SPY	ETF	400.14	400.18	400.14	400.18	600.0
2022-07-28 04:23:00	SPY	ETF	400.1	400.1	400.1	400.1	200.0
2022-07-28 04:24:00	SPY	ETF	400.15	400.18	400.13	400.18	2200.0
2022-07-28 04:25:00	SPY	ETF	400.09	400.16	400.08	400.08	6392.0
2022-07-28 04:26:00	SPY	ETF	400.08	400.08	400.08	400.08	739.0
2022-07-28 04:27:00	SPY	ETF	399.96	399.96	399.96	399.96	900.0
2022-07-28 04:28:00	SPY	ETF	399.95	399.95	399.94	399.94	2100.0
2022-07-28 04:31:00	SPY	ETF	399.9	399.9	399.89	399.89	312.0
2022-07-28 04:32:00	SPY	ETF	399.87	399.87	399.86	399.86	800.0
2022-07-28 04:33:00	SPY	ETF	399.92	399.92	399.92	399.92	800.0
2022-07-28 04:37:00	SPY	ETF	399.8	399.8	399.8	399.8	500.0
2022-07-28 04:40:00	SPY	ETF	399.75	399.75	399.73	399.73	1900.0
2022-07-28 04:41:00	SPY	ETF	399.75	399.75	399.75	399.75	1032.0
2022-07-28 04:42:00	SPY	ETF	399.8	399.8	399.8	399.8	130.0
2022-07-28 04:44:00	SPY	ETF	399.86	399.86	399.86	399.86	800.0
2022-07-28 04:47:00	SPY	ETF	399.97	399.97	399.97	399.97	100.0
2022-07-28 04:48:00	SPY	ETF	399.9	399.9	399.79	399.79	4498.0
2022-07-28 04:50:00	SPY	ETF	399.88	399.88	399.88	399.88	500.0
2022-07-28 04:52:00	SPY	ETF	399.7	399.7	399.7	399.7	800.0
2022-07-28 04:53:00	SPY	ETF	399.51	399.51	399.5	399.5	1465.0
2022-07-28 04:57:00	SPY	ETF	399.61	399.61	399.61	399.61	160.0
2022-07-28 04:58:00	SPY	ETF	399.63	399.63	399.63	399.63	100.0
2022-07-28 04:59:00	SPY	ETF	399.61	399.61	399.61	399.61	104.0
2022-07-28 05:02:00	SPY	ETF	399.72	399.72	399.72	399.72	100.0
2022-07-28 05:03:00	SPY	ETF	399.7	399.7	399.7	399.7	100.0
2022-07-28 05:05:00	SPY	ETF	399.62	399.62	399.62	399.62	100.0
2022-07-28 05:10:00	SPY	ETF	399.45	399.45	399.45	399.45	400.0
2022-07-28 05:11:00	SPY	ETF	399.33	399.33	399.33	399.33	5500.0
2022-07-28 05:12:00	SPY	ETF	399.29	399.29	399.29	399.29	500.0
2022-07-28 05:14:00	SPY	ETF	399.28	399.28	399.2	399.2	2200.0
2022-07-28 05:15:00	SPY	ETF	399.22	399.28	399.22	399.28	20650.0
2022-07-28 05:16:00	SPY	ETF	399.22	399.3	399.2	399.27	13218.0
2022-07-28 05:17:00	SPY	ETF	399.3	399.3	399.24	399.24	1400.0
2022-07-28 05:19:00	SPY	ETF	399.28	399.3	399.28	399.3	1100.0
2022-07-28 05:20:00	SPY	ETF	399.26	399.26	399.26	399.26	500.0
2022-07-28 05:22:00	SPY	ETF	399.25	399.25	399.25	399.25	200.0

> showing 50 of 257,598 rows — these rows as CSV

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