PREVIEW / etf_1min / 2023-08-22

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-08-22.parquet
  size:    4.4 MB
  rows:    252,978

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-22 04:00:00	SPY	ETF	440.55	440.68	439.52	440.68	800.0
2023-08-22 04:01:00	SPY	ETF	440.73	440.73	440.67	440.67	1175.0
2023-08-22 04:02:00	SPY	ETF	440.7	440.71	440.61	440.61	1175.0
2023-08-22 04:04:00	SPY	ETF	440.73	440.73	440.73	440.73	404.0
2023-08-22 04:05:00	SPY	ETF	440.75	440.75	440.58	440.58	4579.0
2023-08-22 04:06:00	SPY	ETF	440.62	440.7	440.58	440.68	2411.0
2023-08-22 04:07:00	SPY	ETF	440.75	440.75	440.68	440.7	2159.0
2023-08-22 04:08:00	SPY	ETF	440.7	440.8	440.7	440.71	2171.0
2023-08-22 04:09:00	SPY	ETF	440.76	440.76	440.64	440.72	2700.0
2023-08-22 04:10:00	SPY	ETF	440.72	440.77	440.71	440.73	4150.0
2023-08-22 04:11:00	SPY	ETF	440.82	440.84	440.75	440.81	3125.0
2023-08-22 04:12:00	SPY	ETF	440.76	440.83	440.74	440.74	2750.0
2023-08-22 04:13:00	SPY	ETF	440.82	440.82	440.82	440.82	112.0
2023-08-22 04:14:00	SPY	ETF	440.75	440.78	440.71	440.71	1850.0
2023-08-22 04:15:00	SPY	ETF	440.77	440.77	440.71	440.75	3300.0
2023-08-22 04:16:00	SPY	ETF	440.78	440.84	440.78	440.84	925.0
2023-08-22 04:18:00	SPY	ETF	440.62	440.62	440.58	440.58	400.0
2023-08-22 04:19:00	SPY	ETF	440.57	440.64	440.57	440.64	435.0
2023-08-22 04:20:00	SPY	ETF	440.61	440.65	440.6	440.65	1092.0
2023-08-22 04:21:00	SPY	ETF	440.6	440.62	440.6	440.62	550.0
2023-08-22 04:22:00	SPY	ETF	440.7	440.7	440.64	440.68	3900.0
2023-08-22 04:23:00	SPY	ETF	440.62	440.63	440.6	440.62	1673.0
2023-08-22 04:27:00	SPY	ETF	440.69	440.69	440.69	440.69	150.0
2023-08-22 04:28:00	SPY	ETF	440.7	440.7	440.7	440.7	106.0
2023-08-22 04:29:00	SPY	ETF	440.62	440.62	440.53	440.53	375.0
2023-08-22 04:30:00	SPY	ETF	440.6	440.63	440.6	440.63	700.0
2023-08-22 04:31:00	SPY	ETF	440.61	440.65	440.61	440.65	63049.0
2023-08-22 04:32:00	SPY	ETF	440.61	440.63	440.61	440.63	12200.0
2023-08-22 04:33:00	SPY	ETF	440.63	440.7	440.63	440.7	25775.0
2023-08-22 04:34:00	SPY	ETF	440.59	440.68	440.59	440.68	6300.0
2023-08-22 04:35:00	SPY	ETF	440.63	440.68	440.63	440.65	2000.0
2023-08-22 04:36:00	SPY	ETF	440.67	440.73	440.67	440.73	1100.0
2023-08-22 04:37:00	SPY	ETF	440.73	440.73	440.73	440.73	459.0
2023-08-22 04:39:00	SPY	ETF	440.75	440.75	440.75	440.75	100.0
2023-08-22 04:41:00	SPY	ETF	440.74	440.74	440.73	440.73	475.0
2023-08-22 04:42:00	SPY	ETF	440.87	440.89	440.86	440.86	694.0
2023-08-22 04:43:00	SPY	ETF	440.86	440.86	440.84	440.84	600.0
2023-08-22 04:44:00	SPY	ETF	440.9	440.9	440.89	440.89	1526.0
2023-08-22 04:45:00	SPY	ETF	440.88	440.88	440.82	440.82	3498.0
2023-08-22 04:46:00	SPY	ETF	440.89	440.89	440.89	440.89	100.0
2023-08-22 04:47:00	SPY	ETF	440.88	440.89	440.8	440.8	3997.0
2023-08-22 04:48:00	SPY	ETF	440.8	440.8	440.8	440.8	108.0
2023-08-22 04:52:00	SPY	ETF	440.75	440.75	440.75	440.75	300.0
2023-08-22 04:54:00	SPY	ETF	440.73	440.73	440.71	440.71	225.0
2023-08-22 04:56:00	SPY	ETF	440.68	440.68	440.68	440.68	300.0
2023-08-22 04:57:00	SPY	ETF	440.65	440.65	440.59	440.65	1520.0
2023-08-22 04:58:00	SPY	ETF	440.69	440.69	440.69	440.69	200.0
2023-08-22 05:03:00	SPY	ETF	440.71	440.71	440.7	440.7	2998.0
2023-08-22 05:04:00	SPY	ETF	440.69	440.69	440.69	440.69	100.0
2023-08-22 05:05:00	SPY	ETF	440.71	440.71	440.71	440.71	100.0

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

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