PREVIEW / etf_1min / 2023-01-25

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-01-25.parquet
  size:    4.6 MB
  rows:    261,068

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-01-25 04:00:00	SPY	ETF	398.8	398.8	398.76	398.76	400.0
2023-01-25 04:01:00	SPY	ETF	398.76	398.76	398.68	398.7	3100.0
2023-01-25 04:02:00	SPY	ETF	398.65	398.65	398.62	398.62	400.0
2023-01-25 04:03:00	SPY	ETF	398.65	398.65	398.65	398.65	100.0
2023-01-25 04:04:00	SPY	ETF	398.66	398.66	398.66	398.66	3950.0
2023-01-25 04:05:00	SPY	ETF	398.56	398.64	398.56	398.64	3600.0
2023-01-25 04:06:00	SPY	ETF	398.63	398.67	398.63	398.67	600.0
2023-01-25 04:08:00	SPY	ETF	398.79	398.79	398.79	398.79	1000.0
2023-01-25 04:09:00	SPY	ETF	398.64	398.64	398.62	398.62	620.0
2023-01-25 04:10:00	SPY	ETF	398.67	398.67	398.65	398.65	261.0
2023-01-25 04:13:00	SPY	ETF	398.55	398.55	398.55	398.55	106.0
2023-01-25 04:14:00	SPY	ETF	398.54	398.54	398.54	398.54	101.0
2023-01-25 04:15:00	SPY	ETF	398.53	398.55	398.49	398.49	890.0
2023-01-25 04:16:00	SPY	ETF	398.47	398.5	398.46	398.46	504.0
2023-01-25 04:17:00	SPY	ETF	398.48	398.48	398.32	398.32	2627.0
2023-01-25 04:18:00	SPY	ETF	398.36	398.36	398.31	398.31	7800.0
2023-01-25 04:19:00	SPY	ETF	398.39	398.39	398.39	398.39	100.0
2023-01-25 04:20:00	SPY	ETF	398.44	398.44	398.44	398.44	100.0
2023-01-25 04:21:00	SPY	ETF	398.41	398.41	398.4	398.4	400.0
2023-01-25 04:22:00	SPY	ETF	398.33	398.36	398.33	398.36	200.0
2023-01-25 04:23:00	SPY	ETF	398.31	398.31	398.31	398.31	100.0
2023-01-25 04:24:00	SPY	ETF	398.25	398.29	398.25	398.29	201.0
2023-01-25 04:25:00	SPY	ETF	398.29	398.37	398.29	398.37	760.0
2023-01-25 04:26:00	SPY	ETF	398.36	398.45	398.36	398.45	212.0
2023-01-25 04:27:00	SPY	ETF	398.44	398.44	398.44	398.44	100.0
2023-01-25 04:28:00	SPY	ETF	398.41	398.41	398.41	398.41	200.0
2023-01-25 04:29:00	SPY	ETF	398.5	398.5	398.5	398.5	500.0
2023-01-25 04:30:00	SPY	ETF	398.5	398.5	398.5	398.5	103.0
2023-01-25 04:31:00	SPY	ETF	398.57	398.57	398.54	398.57	460.0
2023-01-25 04:32:00	SPY	ETF	398.54	398.59	398.54	398.59	207.0
2023-01-25 04:33:00	SPY	ETF	398.45	398.45	398.45	398.45	100.0
2023-01-25 04:35:00	SPY	ETF	398.28	398.29	398.28	398.29	200.0
2023-01-25 04:36:00	SPY	ETF	398.36	398.36	398.36	398.36	211.0
2023-01-25 04:38:00	SPY	ETF	398.39	398.39	398.33	398.33	250.0
2023-01-25 04:39:00	SPY	ETF	398.37	398.39	398.37	398.39	1000.0
2023-01-25 04:40:00	SPY	ETF	398.39	398.49	398.39	398.49	213.0
2023-01-25 04:41:00	SPY	ETF	398.44	398.45	398.44	398.45	342.0
2023-01-25 04:42:00	SPY	ETF	398.44	398.5	398.44	398.5	800.0
2023-01-25 04:43:00	SPY	ETF	398.45	398.45	398.45	398.45	900.0
2023-01-25 04:44:00	SPY	ETF	398.42	398.42	398.35	398.35	3869.0
2023-01-25 04:46:00	SPY	ETF	398.3	398.3	398.29	398.29	5467.0
2023-01-25 04:48:00	SPY	ETF	398.22	398.24	398.19	398.19	1899.0
2023-01-25 04:49:00	SPY	ETF	398.19	398.19	398.09	398.09	700.0
2023-01-25 04:50:00	SPY	ETF	398.07	398.07	397.94	397.94	6600.0
2023-01-25 04:51:00	SPY	ETF	397.9	397.94	397.9	397.94	400.0
2023-01-25 04:52:00	SPY	ETF	397.89	397.89	397.89	397.89	100.0
2023-01-25 04:53:00	SPY	ETF	397.85	397.85	397.83	397.83	200.0
2023-01-25 04:54:00	SPY	ETF	397.78	397.78	397.69	397.69	700.0
2023-01-25 04:55:00	SPY	ETF	397.66	397.66	397.66	397.66	100.0
2023-01-25 04:56:00	SPY	ETF	397.79	397.79	397.79	397.79	200.0

> showing 50 of 261,068 rows — these rows as CSV

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