PREVIEW / etf_1min / 2022-07-27

all etf 1-min files

  file:    by_date/etf_1min/2022/2022-07-27.parquet
  size:    4.3 MB
  rows:    247,131

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-27 04:00:00	SPY	ETF	394.5	394.6	394.28	394.57	2904.0
2022-07-27 04:02:00	SPY	ETF	394.7	394.71	394.7	394.71	246.0
2022-07-27 04:03:00	SPY	ETF	394.74	394.79	394.74	394.79	234.0
2022-07-27 04:04:00	SPY	ETF	394.74	394.79	394.74	394.78	1481.0
2022-07-27 04:05:00	SPY	ETF	394.83	394.83	394.82	394.82	330.0
2022-07-27 04:06:00	SPY	ETF	394.91	394.93	394.91	394.92	700.0
2022-07-27 04:07:00	SPY	ETF	394.98	395.34	394.98	395.33	10274.0
2022-07-27 04:08:00	SPY	ETF	395.42	395.42	395.32	395.32	3826.0
2022-07-27 04:09:00	SPY	ETF	395.32	395.32	395.26	395.26	894.0
2022-07-27 04:10:00	SPY	ETF	395.23	395.34	395.23	395.34	225.0
2022-07-27 04:12:00	SPY	ETF	395.31	395.33	395.21	395.22	3559.0
2022-07-27 04:13:00	SPY	ETF	395.19	395.19	395.19	395.19	100.0
2022-07-27 04:14:00	SPY	ETF	395.2	395.2	395.2	395.2	100.0
2022-07-27 04:16:00	SPY	ETF	395.21	395.21	395.21	395.21	100.0
2022-07-27 04:18:00	SPY	ETF	395.1	395.1	394.97	394.97	300.0
2022-07-27 04:22:00	SPY	ETF	394.83	394.83	394.82	394.82	500.0
2022-07-27 04:23:00	SPY	ETF	394.84	394.84	394.84	394.84	100.0
2022-07-27 04:24:00	SPY	ETF	394.81	394.88	394.81	394.88	245.0
2022-07-27 04:25:00	SPY	ETF	394.76	394.85	394.76	394.85	300.0
2022-07-27 04:26:00	SPY	ETF	394.9	394.9	394.82	394.82	500.0
2022-07-27 04:28:00	SPY	ETF	394.74	394.75	394.74	394.75	2300.0
2022-07-27 04:32:00	SPY	ETF	394.92	395.05	394.92	394.95	2800.0
2022-07-27 04:33:00	SPY	ETF	394.97	394.97	394.95	394.97	800.0
2022-07-27 04:34:00	SPY	ETF	394.95	394.95	394.95	394.95	300.0
2022-07-27 04:35:00	SPY	ETF	394.94	394.94	394.94	394.94	500.0
2022-07-27 04:36:00	SPY	ETF	394.99	394.99	394.99	394.99	466.0
2022-07-27 04:37:00	SPY	ETF	394.99	394.99	394.99	394.99	500.0
2022-07-27 04:38:00	SPY	ETF	395.04	395.04	395.04	395.04	100.0
2022-07-27 04:39:00	SPY	ETF	394.9	394.9	394.84	394.84	300.0
2022-07-27 04:40:00	SPY	ETF	394.9	394.9	394.9	394.9	300.0
2022-07-27 04:42:00	SPY	ETF	394.84	394.89	394.84	394.89	2500.0
2022-07-27 04:43:00	SPY	ETF	394.9	395.04	394.9	395.04	2200.0
2022-07-27 04:44:00	SPY	ETF	394.95	394.95	394.95	394.95	600.0
2022-07-27 04:45:00	SPY	ETF	394.98	394.98	394.98	394.98	1400.0
2022-07-27 04:46:00	SPY	ETF	395.0	395.03	394.98	394.98	4700.0
2022-07-27 04:47:00	SPY	ETF	394.93	394.95	394.93	394.94	300.0
2022-07-27 04:48:00	SPY	ETF	394.9	394.9	394.9	394.9	300.0
2022-07-27 04:51:00	SPY	ETF	394.99	395.04	394.9	395.04	2400.0
2022-07-27 04:52:00	SPY	ETF	395.06	395.08	395.0	395.08	3200.0
2022-07-27 04:54:00	SPY	ETF	395.13	395.13	395.1	395.11	3599.0
2022-07-27 04:55:00	SPY	ETF	395.04	395.04	395.02	395.02	1700.0
2022-07-27 04:56:00	SPY	ETF	395.02	395.02	395.0	395.0	2715.0
2022-07-27 04:57:00	SPY	ETF	394.99	395.01	394.99	395.01	1000.0
2022-07-27 04:58:00	SPY	ETF	395.02	395.04	395.02	395.04	2000.0
2022-07-27 05:00:00	SPY	ETF	394.89	394.89	394.89	394.89	200.0
2022-07-27 05:01:00	SPY	ETF	395.0	395.02	395.0	395.0	1500.0
2022-07-27 05:03:00	SPY	ETF	394.83	394.83	394.83	394.83	100.0
2022-07-27 05:04:00	SPY	ETF	395.0	395.0	395.0	395.0	300.0
2022-07-27 05:06:00	SPY	ETF	395.05	395.05	395.05	395.05	100.0
2022-07-27 05:07:00	SPY	ETF	395.0	395.0	395.0	395.0	300.0

> showing 50 of 247,131 rows — these rows as CSV

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