PREVIEW / etf_1min / 2023-08-01

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-08-01.parquet
  size:    4.7 MB
  rows:    265,129

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-08-01 04:00:00	SPY	ETF	457.3	457.3	457.2	457.2	1500.0
2023-08-01 04:01:00	SPY	ETF	457.2	457.2	457.15	457.16	5700.0
2023-08-01 04:02:00	SPY	ETF	457.15	457.25	457.15	457.25	5100.0
2023-08-01 04:03:00	SPY	ETF	457.18	457.18	457.18	457.18	202.0
2023-08-01 04:04:00	SPY	ETF	457.18	457.18	457.18	457.18	402.0
2023-08-01 04:05:00	SPY	ETF	457.16	457.17	457.16	457.17	222.0
2023-08-01 04:06:00	SPY	ETF	457.17	457.17	457.05	457.05	402.0
2023-08-01 04:07:00	SPY	ETF	457.06	457.06	457.0	457.0	730.0
2023-08-01 04:08:00	SPY	ETF	457.0	457.01	456.97	457.01	2885.0
2023-08-01 04:10:00	SPY	ETF	456.95	457.04	456.95	457.04	2400.0
2023-08-01 04:11:00	SPY	ETF	457.01	457.01	456.95	456.95	748.0
2023-08-01 04:12:00	SPY	ETF	457.0	457.0	457.0	457.0	100.0
2023-08-01 04:13:00	SPY	ETF	456.97	457.0	456.96	457.0	3800.0
2023-08-01 04:14:00	SPY	ETF	456.98	456.98	456.98	456.98	141.0
2023-08-01 04:15:00	SPY	ETF	456.95	456.95	456.95	456.95	500.0
2023-08-01 04:16:00	SPY	ETF	456.95	456.95	456.95	456.95	114.0
2023-08-01 04:17:00	SPY	ETF	456.92	456.93	456.92	456.92	2000.0
2023-08-01 04:18:00	SPY	ETF	456.92	456.92	456.92	456.92	1000.0
2023-08-01 04:19:00	SPY	ETF	456.88	456.89	456.85	456.85	3042.0
2023-08-01 04:20:00	SPY	ETF	456.9	456.91	456.88	456.91	2200.0
2023-08-01 04:21:00	SPY	ETF	456.9	456.9	456.9	456.9	225.0
2023-08-01 04:22:00	SPY	ETF	456.87	456.87	456.87	456.87	100.0
2023-08-01 04:23:00	SPY	ETF	456.86	456.86	456.86	456.86	200.0
2023-08-01 04:24:00	SPY	ETF	456.75	456.75	456.71	456.71	849.0
2023-08-01 04:27:00	SPY	ETF	456.75	456.75	456.75	456.75	132.0
2023-08-01 04:28:00	SPY	ETF	456.73	456.73	456.73	456.73	120.0
2023-08-01 04:29:00	SPY	ETF	456.72	456.72	456.72	456.72	100.0
2023-08-01 04:30:00	SPY	ETF	456.65	456.65	456.65	456.65	300.0
2023-08-01 04:31:00	SPY	ETF	456.55	456.55	456.54	456.54	1700.0
2023-08-01 04:33:00	SPY	ETF	456.44	456.44	456.44	456.44	200.0
2023-08-01 04:37:00	SPY	ETF	456.7	456.75	456.7	456.75	1650.0
2023-08-01 04:43:00	SPY	ETF	456.69	456.69	456.69	456.69	348.0
2023-08-01 04:44:00	SPY	ETF	456.6	456.6	456.6	456.6	100.0
2023-08-01 04:45:00	SPY	ETF	456.61	456.61	456.56	456.56	407.0
2023-08-01 04:48:00	SPY	ETF	456.31	456.31	456.31	456.31	100.0
2023-08-01 04:52:00	SPY	ETF	456.6	456.6	456.6	456.6	215.0
2023-08-01 04:57:00	SPY	ETF	456.78	456.78	456.78	456.78	100.0
2023-08-01 05:00:00	SPY	ETF	456.63	456.63	456.63	456.63	100.0
2023-08-01 05:01:00	SPY	ETF	456.66	456.66	456.66	456.66	200.0
2023-08-01 05:03:00	SPY	ETF	456.6	456.6	456.6	456.6	400.0
2023-08-01 05:05:00	SPY	ETF	456.61	456.61	456.61	456.61	100.0
2023-08-01 05:06:00	SPY	ETF	456.64	456.64	456.63	456.63	400.0
2023-08-01 05:07:00	SPY	ETF	456.62	456.62	456.6	456.6	700.0
2023-08-01 05:08:00	SPY	ETF	456.59	456.59	456.54	456.54	400.0
2023-08-01 05:09:00	SPY	ETF	456.56	456.56	456.56	456.56	124.0
2023-08-01 05:11:00	SPY	ETF	456.63	456.63	456.62	456.63	2784.0
2023-08-01 05:13:00	SPY	ETF	456.58	456.58	456.58	456.58	100.0
2023-08-01 05:14:00	SPY	ETF	456.5	456.5	456.5	456.5	700.0
2023-08-01 05:16:00	SPY	ETF	456.39	456.39	456.39	456.39	100.0
2023-08-01 05:17:00	SPY	ETF	456.44	456.44	456.44	456.44	100.0

> showing 50 of 265,129 rows — these rows as CSV

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