PREVIEW / etf_1min / 2023-03-09

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-03-09.parquet
  size:    4.7 MB
  rows:    265,107

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-03-09 04:00:00	SPY	ETF	398.18	398.22	398.13	398.13	2328.0
2023-03-09 04:01:00	SPY	ETF	398.12	398.12	398.01	398.01	649.0
2023-03-09 04:02:00	SPY	ETF	398.03	398.03	397.94	397.94	950.0
2023-03-09 04:03:00	SPY	ETF	397.95	397.96	397.92	397.92	1104.0
2023-03-09 04:04:00	SPY	ETF	397.91	397.91	397.89	397.91	1334.0
2023-03-09 04:05:00	SPY	ETF	397.97	397.97	397.93	397.94	728.0
2023-03-09 04:06:00	SPY	ETF	397.98	397.99	397.97	397.99	2500.0
2023-03-09 04:09:00	SPY	ETF	397.99	398.01	397.99	398.01	252.0
2023-03-09 04:10:00	SPY	ETF	398.03	398.03	398.03	398.03	1248.0
2023-03-09 04:12:00	SPY	ETF	398.07	398.07	398.07	398.07	107.0
2023-03-09 04:16:00	SPY	ETF	397.94	397.97	397.94	397.97	309.0
2023-03-09 04:20:00	SPY	ETF	397.79	397.81	397.79	397.79	1900.0
2023-03-09 04:21:00	SPY	ETF	397.79	397.89	397.79	397.89	300.0
2023-03-09 04:27:00	SPY	ETF	397.89	397.9	397.89	397.9	1400.0
2023-03-09 04:28:00	SPY	ETF	397.94	397.94	397.92	397.92	300.0
2023-03-09 04:29:00	SPY	ETF	397.9	397.9	397.85	397.85	475.0
2023-03-09 04:35:00	SPY	ETF	397.89	397.9	397.89	397.9	865.0
2023-03-09 04:36:00	SPY	ETF	397.89	397.89	397.89	397.89	800.0
2023-03-09 04:37:00	SPY	ETF	398.01	398.01	397.89	397.89	2800.0
2023-03-09 04:38:00	SPY	ETF	397.85	397.85	397.85	397.85	351.0
2023-03-09 04:39:00	SPY	ETF	397.92	397.92	397.92	397.92	100.0
2023-03-09 04:43:00	SPY	ETF	397.9	397.91	397.9	397.91	500.0
2023-03-09 04:44:00	SPY	ETF	397.83	397.84	397.83	397.84	200.0
2023-03-09 04:45:00	SPY	ETF	397.8	397.8	397.79	397.79	2100.0
2023-03-09 04:46:00	SPY	ETF	397.75	397.75	397.75	397.75	100.0
2023-03-09 04:47:00	SPY	ETF	397.66	397.66	397.66	397.66	100.0
2023-03-09 04:48:00	SPY	ETF	397.6	397.6	397.54	397.54	300.0
2023-03-09 04:49:00	SPY	ETF	397.67	397.7	397.67	397.7	204.0
2023-03-09 04:50:00	SPY	ETF	397.55	397.55	397.55	397.55	400.0
2023-03-09 04:51:00	SPY	ETF	397.58	397.58	397.58	397.58	200.0
2023-03-09 04:52:00	SPY	ETF	397.69	397.69	397.63	397.63	400.0
2023-03-09 04:53:00	SPY	ETF	397.61	397.61	397.61	397.61	318.0
2023-03-09 04:54:00	SPY	ETF	397.59	397.59	397.59	397.59	100.0
2023-03-09 04:56:00	SPY	ETF	397.62	397.62	397.58	397.58	207.0
2023-03-09 04:58:00	SPY	ETF	397.61	397.61	397.61	397.61	500.0
2023-03-09 04:59:00	SPY	ETF	397.55	397.55	397.48	397.52	6950.0
2023-03-09 05:02:00	SPY	ETF	397.48	397.54	397.48	397.54	1412.0
2023-03-09 05:03:00	SPY	ETF	397.49	397.49	397.49	397.49	991.0
2023-03-09 05:06:00	SPY	ETF	397.54	397.56	397.54	397.56	1200.0
2023-03-09 05:09:00	SPY	ETF	397.49	397.53	397.49	397.53	300.0
2023-03-09 05:11:00	SPY	ETF	397.64	397.64	397.64	397.64	500.0
2023-03-09 05:12:00	SPY	ETF	397.62	397.68	397.62	397.68	1700.0
2023-03-09 05:13:00	SPY	ETF	397.66	397.69	397.66	397.69	2028.0
2023-03-09 05:14:00	SPY	ETF	397.67	397.67	397.67	397.67	688.0
2023-03-09 05:15:00	SPY	ETF	397.6	397.6	397.57	397.57	350.0
2023-03-09 05:18:00	SPY	ETF	397.61	397.61	397.61	397.61	350.0
2023-03-09 05:19:00	SPY	ETF	397.64	397.64	397.64	397.64	200.0
2023-03-09 05:20:00	SPY	ETF	397.58	397.58	397.58	397.58	1000.0
2023-03-09 05:22:00	SPY	ETF	397.51	397.51	397.5	397.5	2998.0
2023-03-09 05:23:00	SPY	ETF	397.42	397.42	397.42	397.42	400.0

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

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