PREVIEW / etf_30min / 2023-11-22

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-22.parquet
  size:    721 KB
  rows:    28,860

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-22 04:00:00	SPY	ETF	453.27	453.79	453.27	453.63	18467.0
2023-11-22 04:30:00	SPY	ETF	453.59	453.69	453.45	453.62	13090.0
2023-11-22 05:00:00	SPY	ETF	453.55	453.99	453.55	453.8	9855.0
2023-11-22 05:30:00	SPY	ETF	453.89	454.29	453.89	454.29	7578.0
2023-11-22 06:00:00	SPY	ETF	454.3	454.45	454.14	454.42	21748.0
2023-11-22 06:30:00	SPY	ETF	454.38	454.41	454.03	454.11	25312.0
2023-11-22 07:00:00	SPY	ETF	454.1	454.57	454.09	454.49	68826.0
2023-11-22 07:30:00	SPY	ETF	454.48	454.7	454.45	454.46	35425.0
2023-11-22 08:00:00	SPY	ETF	454.16	454.9	453.0	454.9	236210.0
2023-11-22 08:30:00	SPY	ETF	454.84	455.02	454.39	454.95	116676.0
2023-11-22 09:00:00	SPY	ETF	454.99	455.18	454.67	454.98	263684.0
2023-11-22 09:30:00	SPY	ETF	454.98	456.38	454.34	454.935	7291977.0
2023-11-22 10:00:00	SPY	ETF	454.93	455.04	453.8895	454.96	5004404.0
2023-11-22 10:30:00	SPY	ETF	454.96	455.53	454.28	454.5084	3726527.0
2023-11-22 11:00:00	SPY	ETF	454.51	455.22	454.45	455.01	2457952.0
2023-11-22 11:30:00	SPY	ETF	455.02	455.57	454.89	455.51	2221259.0
2023-11-22 12:00:00	SPY	ETF	455.51	455.9	455.151	455.38	2454702.0
2023-11-22 12:30:00	SPY	ETF	455.39	455.41	454.62	455.0805	2379401.0
2023-11-22 13:00:00	SPY	ETF	455.08	455.565	455.0	455.55	1510891.0
2023-11-22 13:30:00	SPY	ETF	455.55	455.6	455.205	455.32	1761843.0
2023-11-22 14:00:00	SPY	ETF	455.31	455.62	455.23	455.48	2130467.0
2023-11-22 14:30:00	SPY	ETF	455.47	455.5	453.925	454.84	4307342.0
2023-11-22 15:00:00	SPY	ETF	454.84	455.2968	454.67	455.2801	2940932.0
2023-11-22 15:30:00	SPY	ETF	455.28	455.41	454.98	455.03	6534976.0
2023-11-22 16:00:00	SPY	ETF	455.03	455.1399	454.87	455.08	1772819.0
2023-11-22 16:30:00	SPY	ETF	455.08	455.08	454.94	454.94	730495.0
2023-11-22 17:00:00	SPY	ETF	455.02	455.02	454.96	454.98	155680.0
2023-11-22 17:30:00	SPY	ETF	455.0	455.0	454.88	454.88	5354.0
2023-11-22 18:00:00	SPY	ETF	454.86	454.88	454.69	454.73	54517.0
2023-11-22 18:30:00	SPY	ETF	454.73	454.75	454.7	454.72	8089.0
2023-11-22 19:00:00	SPY	ETF	454.7	454.73	454.6	454.67	8164.0
2023-11-22 19:30:00	SPY	ETF	454.64	454.85	454.64	454.85	16864.0
2023-11-22 04:00:00	QQQ	ETF	387.91	388.49	387.84	388.35	43086.0
2023-11-22 04:30:00	QQQ	ETF	388.38	388.6	388.25	388.6	11691.0
2023-11-22 05:00:00	QQQ	ETF	388.6	389.07	388.6	388.95	27578.0
2023-11-22 05:30:00	QQQ	ETF	388.97	389.56	388.96	389.56	67414.0
2023-11-22 06:00:00	QQQ	ETF	389.54	389.85	389.38	389.83	47676.0
2023-11-22 06:30:00	QQQ	ETF	389.93	389.93	389.58	389.6	34533.0
2023-11-22 07:00:00	QQQ	ETF	389.62	390.26	389.57	390.17	107745.0
2023-11-22 07:30:00	QQQ	ETF	390.2	390.36	389.96	390.01	167989.0
2023-11-22 08:00:00	QQQ	ETF	389.66	390.52	387.6	390.52	286817.0
2023-11-22 08:30:00	QQQ	ETF	390.28	390.58	389.93	390.4503	266667.0
2023-11-22 09:00:00	QQQ	ETF	390.55	390.7799	390.22	390.58	214222.0
2023-11-22 09:30:00	QQQ	ETF	390.57	393.07	389.74	390.5	7831638.0
2023-11-22 10:00:00	QQQ	ETF	390.48	390.6366	389.04	390.3835	4440946.0
2023-11-22 10:30:00	QQQ	ETF	390.39	391.29	389.56	389.8599	2852849.0
2023-11-22 11:00:00	QQQ	ETF	389.87	390.67	389.75	390.4471	1906315.0
2023-11-22 11:30:00	QQQ	ETF	390.46	390.96	390.35	390.91	1519755.0
2023-11-22 12:00:00	QQQ	ETF	390.91	391.34	390.675	390.98	1648654.0
2023-11-22 12:30:00	QQQ	ETF	390.99	391.05	390.3	390.645	1183206.0

> showing 50 of 28,860 rows — these rows as CSV

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