PREVIEW / etf_1min / 2023-11-16

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-11-16.parquet
  size:    4.9 MB
  rows:    281,644

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-11-16 04:00:00	SPY	ETF	449.69	449.69	449.6	449.63	1832.0
2023-11-16 04:01:00	SPY	ETF	449.56	449.59	449.44	449.54	4062.0
2023-11-16 04:02:00	SPY	ETF	449.54	449.58	449.51	449.53	3450.0
2023-11-16 04:03:00	SPY	ETF	449.47	449.49	449.41	449.44	2750.0
2023-11-16 04:04:00	SPY	ETF	449.5	449.54	449.47	449.52	2125.0
2023-11-16 04:05:00	SPY	ETF	449.43	449.48	449.43	449.47	2860.0
2023-11-16 04:06:00	SPY	ETF	449.45	449.52	449.45	449.52	1275.0
2023-11-16 04:07:00	SPY	ETF	449.51	449.55	449.49	449.52	2062.0
2023-11-16 04:08:00	SPY	ETF	449.53	449.55	449.51	449.55	1710.0
2023-11-16 04:09:00	SPY	ETF	449.59	449.67	449.54	449.66	1700.0
2023-11-16 04:10:00	SPY	ETF	449.69	449.69	449.66	449.68	2150.0
2023-11-16 04:11:00	SPY	ETF	449.7	449.77	449.67	449.7	1816.0
2023-11-16 04:12:00	SPY	ETF	449.76	449.76	449.69	449.72	1650.0
2023-11-16 04:13:00	SPY	ETF	449.74	449.76	449.72	449.76	1300.0
2023-11-16 04:14:00	SPY	ETF	449.76	449.82	449.73	449.81	1700.0
2023-11-16 04:15:00	SPY	ETF	449.78	449.84	449.78	449.84	2750.0
2023-11-16 04:16:00	SPY	ETF	449.8	449.93	449.8	449.93	1023.0
2023-11-16 04:17:00	SPY	ETF	449.96	449.97	449.88	449.97	2320.0
2023-11-16 04:18:00	SPY	ETF	449.94	450.03	449.94	449.96	2673.0
2023-11-16 04:19:00	SPY	ETF	449.94	449.98	449.92	449.97	925.0
2023-11-16 04:20:00	SPY	ETF	450.03	450.07	450.0	450.03	2494.0
2023-11-16 04:21:00	SPY	ETF	450.0	450.04	449.99	450.0	1072.0
2023-11-16 04:22:00	SPY	ETF	449.98	450.07	449.97	450.03	2026.0
2023-11-16 04:23:00	SPY	ETF	450.02	450.02	449.94	449.94	775.0
2023-11-16 04:24:00	SPY	ETF	450.02	450.02	449.94	449.94	475.0
2023-11-16 04:25:00	SPY	ETF	449.94	449.94	449.86	449.86	962.0
2023-11-16 04:26:00	SPY	ETF	449.87	449.88	449.79	449.87	1475.0
2023-11-16 04:27:00	SPY	ETF	449.88	449.91	449.79	449.91	675.0
2023-11-16 04:28:00	SPY	ETF	449.82	449.87	449.8	449.87	1625.0
2023-11-16 04:29:00	SPY	ETF	449.8	449.83	449.74	449.74	1372.0
2023-11-16 04:30:00	SPY	ETF	449.73	449.73	449.73	449.73	475.0
2023-11-16 04:31:00	SPY	ETF	449.68	449.71	449.58	449.58	1152.0
2023-11-16 04:32:00	SPY	ETF	449.65	449.73	449.64	449.73	1044.0
2023-11-16 04:33:00	SPY	ETF	449.65	449.68	449.65	449.68	2107.0
2023-11-16 04:34:00	SPY	ETF	449.63	449.63	449.63	449.63	325.0
2023-11-16 04:35:00	SPY	ETF	449.65	449.66	449.65	449.66	543.0
2023-11-16 04:36:00	SPY	ETF	449.75	449.75	449.75	449.75	124.0
2023-11-16 04:39:00	SPY	ETF	449.59	449.59	449.52	449.52	445.0
2023-11-16 04:40:00	SPY	ETF	449.54	449.54	449.54	449.54	180.0
2023-11-16 04:46:00	SPY	ETF	449.55	449.56	449.55	449.56	500.0
2023-11-16 04:50:00	SPY	ETF	449.62	449.62	449.62	449.62	100.0
2023-11-16 04:52:00	SPY	ETF	449.6	449.6	449.52	449.52	399.0
2023-11-16 04:54:00	SPY	ETF	449.51	449.51	449.51	449.51	271.0
2023-11-16 05:05:00	SPY	ETF	449.52	449.52	449.42	449.42	200.0
2023-11-16 05:06:00	SPY	ETF	449.44	449.44	449.44	449.44	100.0
2023-11-16 05:09:00	SPY	ETF	449.45	449.45	449.45	449.45	238.0
2023-11-16 05:12:00	SPY	ETF	449.55	449.55	449.55	449.55	280.0
2023-11-16 05:15:00	SPY	ETF	449.65	449.68	449.65	449.68	1682.0
2023-11-16 05:18:00	SPY	ETF	449.64	449.67	449.64	449.67	368.0
2023-11-16 05:19:00	SPY	ETF	449.7	449.7	449.7	449.7	200.0

> showing 50 of 281,644 rows — these rows as CSV

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