PREVIEW / etf_30min / 2023-11-09

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-09.parquet
  size:    734 KB
  rows:    29,254

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-09 04:00:00	SPY	ETF	437.58	437.73	437.3	437.73	7483.0
2023-11-09 04:30:00	SPY	ETF	437.69	437.73	437.44	437.59	4766.0
2023-11-09 05:00:00	SPY	ETF	437.6	438.07	437.6	437.99	10599.0
2023-11-09 05:30:00	SPY	ETF	437.93	438.53	437.93	438.45	41874.0
2023-11-09 06:00:00	SPY	ETF	438.4	438.4	437.79	437.85	11200.0
2023-11-09 06:30:00	SPY	ETF	437.86	437.93	437.71	437.74	26782.0
2023-11-09 07:00:00	SPY	ETF	437.74	438.0	437.74	437.85	106924.0
2023-11-09 07:30:00	SPY	ETF	437.85	438.12	437.85	438.12	83507.0
2023-11-09 08:00:00	SPY	ETF	437.9503	438.4904	437.12	438.44	130012.0
2023-11-09 08:30:00	SPY	ETF	438.33	438.75	438.06	438.61	145495.0
2023-11-09 09:00:00	SPY	ETF	438.65	438.8	438.23	438.42	235001.0
2023-11-09 09:30:00	SPY	ETF	438.42	438.47	436.98	437.88	4824538.0
2023-11-09 10:00:00	SPY	ETF	437.88	438.1593	436.36	436.4876	4499765.0
2023-11-09 10:30:00	SPY	ETF	436.51	437.03	436.08	436.98	3023570.0
2023-11-09 11:00:00	SPY	ETF	436.97	437.88	436.95	437.42	3549419.0
2023-11-09 11:30:00	SPY	ETF	437.43	438.08	437.34	437.7988	2698731.0
2023-11-09 12:00:00	SPY	ETF	437.81	437.89	437.12	437.21	2105111.0
2023-11-09 12:30:00	SPY	ETF	437.21	437.74	437.08	437.605	1851988.0
2023-11-09 13:00:00	SPY	ETF	437.6	437.6709	435.15	436.4	7909944.0
2023-11-09 13:30:00	SPY	ETF	436.4	436.63	435.155	435.46	3684142.0
2023-11-09 14:00:00	SPY	ETF	435.44	435.44	433.93	434.81	6793414.0
2023-11-09 14:30:00	SPY	ETF	434.79	435.05	433.64	433.85	4622460.0
2023-11-09 15:00:00	SPY	ETF	433.845	434.33	433.45	433.77	4008701.0
2023-11-09 15:30:00	SPY	ETF	433.78	434.045	433.4	433.87	10956117.0
2023-11-09 16:00:00	SPY	ETF	433.87	437.6161	433.7684	434.23	3775757.0
2023-11-09 16:30:00	SPY	ETF	434.22	434.24	434.04	434.08	236633.0
2023-11-09 17:00:00	SPY	ETF	434.1	434.17	433.95	434.17	70340.0
2023-11-09 17:30:00	SPY	ETF	434.17	434.17	433.95	434.01	39428.0
2023-11-09 18:00:00	SPY	ETF	434.02	434.02	433.36	433.55	112835.0
2023-11-09 18:30:00	SPY	ETF	433.52	433.63	433.5	433.63	23776.0
2023-11-09 19:00:00	SPY	ETF	433.6	433.6	433.15	433.21	45186.0
2023-11-09 19:30:00	SPY	ETF	433.26	433.64	433.07	433.64	32825.0
2023-11-09 04:00:00	QQQ	ETF	372.84	372.94	372.63	372.93	19362.0
2023-11-09 04:30:00	QQQ	ETF	372.91	373.0	372.72	372.88	18914.0
2023-11-09 05:00:00	QQQ	ETF	372.91	373.19	372.91	373.13	19033.0
2023-11-09 05:30:00	QQQ	ETF	373.14	373.57	373.14	373.4	65779.0
2023-11-09 06:00:00	QQQ	ETF	373.46	373.46	372.8	372.83	10811.0
2023-11-09 06:30:00	QQQ	ETF	372.82	372.95	372.66	372.7	12225.0
2023-11-09 07:00:00	QQQ	ETF	372.75	373.07	372.71	372.9	35108.0
2023-11-09 07:30:00	QQQ	ETF	372.85	373.13	372.85	373.12	47077.0
2023-11-09 08:00:00	QQQ	ETF	372.98	373.4204	372.7	373.35	203697.0
2023-11-09 08:30:00	QQQ	ETF	373.33	373.62	372.99	373.5801	198637.0
2023-11-09 09:00:00	QQQ	ETF	373.61	373.79	373.33	373.6	258144.0
2023-11-09 09:30:00	QQQ	ETF	373.64	374.08	372.72	374.07	3446134.0
2023-11-09 10:00:00	QQQ	ETF	374.08	374.32	372.4	372.6301	2790876.0
2023-11-09 10:30:00	QQQ	ETF	372.64	373.32	372.2201	373.26	2392848.0
2023-11-09 11:00:00	QQQ	ETF	373.24	374.3	373.215	373.7288	2467725.0
2023-11-09 11:30:00	QQQ	ETF	373.73	374.8	373.6	374.55	2248004.0
2023-11-09 12:00:00	QQQ	ETF	374.555	374.58	373.28	373.38	1748129.0
2023-11-09 12:30:00	QQQ	ETF	373.38	373.98	373.08	373.9	1517395.0

> showing 50 of 29,254 rows — these rows as CSV

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