PREVIEW / etf_1min / 2023-06-23

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-06-23.parquet
  size:    4.4 MB
  rows:    252,508

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-06-23 04:00:00	SPY	ETF	434.63	434.98	434.53	434.67	5373.0
2023-06-23 04:01:00	SPY	ETF	434.64	434.71	434.64	434.71	4553.0
2023-06-23 04:02:00	SPY	ETF	434.69	434.71	434.64	434.64	1131.0
2023-06-23 04:03:00	SPY	ETF	434.56	434.59	434.56	434.59	897.0
2023-06-23 04:04:00	SPY	ETF	434.58	434.63	434.58	434.61	2165.0
2023-06-23 04:06:00	SPY	ETF	434.7	434.73	434.7	434.73	1202.0
2023-06-23 04:08:00	SPY	ETF	434.82	434.84	434.8	434.84	563.0
2023-06-23 04:09:00	SPY	ETF	434.81	434.81	434.81	434.81	200.0
2023-06-23 04:10:00	SPY	ETF	434.79	434.8	434.77	434.77	700.0
2023-06-23 04:11:00	SPY	ETF	434.77	434.77	434.77	434.77	300.0
2023-06-23 04:12:00	SPY	ETF	434.7	434.7	434.7	434.7	300.0
2023-06-23 04:13:00	SPY	ETF	434.69	434.72	434.69	434.72	3449.0
2023-06-23 04:14:00	SPY	ETF	434.73	434.73	434.73	434.73	100.0
2023-06-23 04:15:00	SPY	ETF	434.79	434.81	434.79	434.81	200.0
2023-06-23 04:16:00	SPY	ETF	434.78	434.79	434.78	434.79	500.0
2023-06-23 04:17:00	SPY	ETF	434.83	434.83	434.83	434.83	100.0
2023-06-23 04:18:00	SPY	ETF	434.8	434.8	434.8	434.8	600.0
2023-06-23 04:19:00	SPY	ETF	434.66	434.66	434.66	434.66	364.0
2023-06-23 04:20:00	SPY	ETF	434.64	434.76	434.64	434.76	1130.0
2023-06-23 04:21:00	SPY	ETF	434.76	434.76	434.76	434.76	107.0
2023-06-23 04:23:00	SPY	ETF	434.5	434.5	434.5	434.5	350.0
2023-06-23 04:24:00	SPY	ETF	434.59	434.59	434.54	434.54	200.0
2023-06-23 04:25:00	SPY	ETF	434.46	434.46	434.42	434.42	520.0
2023-06-23 04:26:00	SPY	ETF	434.56	434.57	434.56	434.57	500.0
2023-06-23 04:29:00	SPY	ETF	434.56	434.56	434.46	434.46	1214.0
2023-06-23 04:30:00	SPY	ETF	434.52	434.6	434.49	434.6	499.0
2023-06-23 04:31:00	SPY	ETF	434.58	434.58	434.58	434.58	100.0
2023-06-23 04:32:00	SPY	ETF	434.6	434.6	434.6	434.6	200.0
2023-06-23 04:33:00	SPY	ETF	434.6	434.6	434.58	434.58	200.0
2023-06-23 04:35:00	SPY	ETF	434.59	434.73	434.59	434.73	2960.0
2023-06-23 04:36:00	SPY	ETF	434.75	434.75	434.75	434.75	800.0
2023-06-23 04:42:00	SPY	ETF	434.75	434.75	434.75	434.75	1200.0
2023-06-23 04:43:00	SPY	ETF	434.77	434.81	434.77	434.81	1400.0
2023-06-23 04:45:00	SPY	ETF	434.79	434.79	434.79	434.79	300.0
2023-06-23 04:46:00	SPY	ETF	434.81	434.81	434.76	434.76	262.0
2023-06-23 04:47:00	SPY	ETF	434.77	434.77	434.77	434.77	200.0
2023-06-23 04:48:00	SPY	ETF	434.62	434.62	434.59	434.59	300.0
2023-06-23 04:50:00	SPY	ETF	434.64	434.64	434.5	434.5	3862.0
2023-06-23 04:51:00	SPY	ETF	434.4	434.4	434.4	434.4	159.0
2023-06-23 04:52:00	SPY	ETF	434.4	434.4	434.3	434.3	212.0
2023-06-23 04:53:00	SPY	ETF	434.31	434.34	434.31	434.34	230.0
2023-06-23 04:55:00	SPY	ETF	434.49	434.49	434.42	434.42	600.0
2023-06-23 04:56:00	SPY	ETF	434.38	434.38	434.38	434.38	400.0
2023-06-23 04:57:00	SPY	ETF	434.39	434.39	434.36	434.38	408.0
2023-06-23 04:58:00	SPY	ETF	434.35	434.35	434.35	434.35	400.0
2023-06-23 04:59:00	SPY	ETF	434.35	434.35	434.35	434.35	100.0
2023-06-23 05:01:00	SPY	ETF	434.35	434.35	434.34	434.35	1200.0
2023-06-23 05:02:00	SPY	ETF	434.33	434.33	434.33	434.33	100.0
2023-06-23 05:07:00	SPY	ETF	434.37	434.37	434.37	434.37	674.0
2023-06-23 05:09:00	SPY	ETF	434.4	434.4	434.4	434.4	1000.0

> showing 50 of 252,508 rows — these rows as CSV

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