PREVIEW / etf_1min / 2023-08-29

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-08-29.parquet
  size:    4.6 MB
  rows:    258,669

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-29 04:00:00	SPY	ETF	442.68	442.71	442.68	442.71	300.0
2023-08-29 04:03:00	SPY	ETF	442.8	442.81	442.74	442.74	1116.0
2023-08-29 04:05:00	SPY	ETF	442.78	442.78	442.78	442.78	176.0
2023-08-29 04:07:00	SPY	ETF	442.73	442.73	442.73	442.73	500.0
2023-08-29 04:09:00	SPY	ETF	442.7	442.7	442.7	442.7	100.0
2023-08-29 04:10:00	SPY	ETF	442.65	442.65	442.65	442.65	200.0
2023-08-29 04:11:00	SPY	ETF	442.53	442.53	442.5	442.53	807.0
2023-08-29 04:13:00	SPY	ETF	442.46	442.46	442.46	442.46	119.0
2023-08-29 04:15:00	SPY	ETF	442.54	442.54	442.53	442.53	2410.0
2023-08-29 04:21:00	SPY	ETF	442.66	442.66	442.66	442.66	600.0
2023-08-29 04:22:00	SPY	ETF	442.69	442.77	442.69	442.76	900.0
2023-08-29 04:23:00	SPY	ETF	442.76	442.76	442.76	442.76	300.0
2023-08-29 04:26:00	SPY	ETF	442.7	442.7	442.7	442.7	5000.0
2023-08-29 04:30:00	SPY	ETF	442.65	442.65	442.65	442.65	100.0
2023-08-29 04:32:00	SPY	ETF	442.79	442.8	442.79	442.8	1200.0
2023-08-29 04:33:00	SPY	ETF	442.89	442.89	442.89	442.89	100.0
2023-08-29 04:37:00	SPY	ETF	443.04	443.04	443.0	443.0	517.0
2023-08-29 04:41:00	SPY	ETF	442.94	442.94	442.94	442.94	290.0
2023-08-29 04:42:00	SPY	ETF	442.91	442.91	442.91	442.91	100.0
2023-08-29 04:44:00	SPY	ETF	442.87	442.87	442.87	442.87	300.0
2023-08-29 04:45:00	SPY	ETF	442.9	442.9	442.9	442.9	110.0
2023-08-29 04:48:00	SPY	ETF	442.96	442.96	442.96	442.96	100.0
2023-08-29 04:50:00	SPY	ETF	442.87	442.94	442.87	442.94	5300.0
2023-08-29 04:53:00	SPY	ETF	442.71	442.71	442.71	442.71	100.0
2023-08-29 04:54:00	SPY	ETF	442.69	442.69	442.69	442.69	300.0
2023-08-29 04:55:00	SPY	ETF	442.71	442.71	442.71	442.71	459.0
2023-08-29 04:56:00	SPY	ETF	442.73	442.97	442.69	442.69	9164.0
2023-08-29 05:00:00	SPY	ETF	442.44	442.44	442.42	442.42	640.0
2023-08-29 05:01:00	SPY	ETF	442.63	442.63	442.63	442.63	100.0
2023-08-29 05:02:00	SPY	ETF	442.65	442.65	442.65	442.65	100.0
2023-08-29 05:03:00	SPY	ETF	442.55	442.55	442.55	442.55	100.0
2023-08-29 05:04:00	SPY	ETF	442.65	442.65	442.65	442.65	200.0
2023-08-29 05:05:00	SPY	ETF	442.64	442.65	442.63	442.65	600.0
2023-08-29 05:06:00	SPY	ETF	442.63	442.74	442.63	442.74	1150.0
2023-08-29 05:07:00	SPY	ETF	442.73	442.73	442.72	442.72	400.0
2023-08-29 05:08:00	SPY	ETF	442.76	442.76	442.76	442.76	200.0
2023-08-29 05:09:00	SPY	ETF	442.75	442.77	442.75	442.77	300.0
2023-08-29 05:10:00	SPY	ETF	442.84	442.84	442.84	442.84	200.0
2023-08-29 05:11:00	SPY	ETF	442.83	442.91	442.83	442.91	519.0
2023-08-29 05:12:00	SPY	ETF	442.85	442.85	442.85	442.85	100.0
2023-08-29 05:13:00	SPY	ETF	442.85	442.85	442.85	442.85	120.0
2023-08-29 05:18:00	SPY	ETF	442.66	442.66	442.6	442.6	221.0
2023-08-29 05:19:00	SPY	ETF	442.56	442.56	442.56	442.56	200.0
2023-08-29 05:20:00	SPY	ETF	442.62	442.62	442.62	442.62	200.0
2023-08-29 05:22:00	SPY	ETF	442.65	442.66	442.65	442.66	200.0
2023-08-29 05:23:00	SPY	ETF	442.62	442.62	442.58	442.6	4500.0
2023-08-29 05:26:00	SPY	ETF	442.71	442.71	442.71	442.71	199.0
2023-08-29 05:27:00	SPY	ETF	442.69	442.73	442.69	442.73	256.0
2023-08-29 05:29:00	SPY	ETF	442.76	442.76	442.76	442.76	100.0
2023-08-29 05:30:00	SPY	ETF	442.76	442.79	442.76	442.79	2132.0

> showing 50 of 258,669 rows — these rows as CSV

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