PREVIEW / etf_30min / 2023-09-01

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-01.parquet
  size:    691 KB
  rows:    27,294

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-09-01 04:00:00	SPY	ETF	451.53	451.61	451.12	451.45	13790.0
2023-09-01 04:30:00	SPY	ETF	451.35	451.57	451.35	451.37	3647.0
2023-09-01 05:00:00	SPY	ETF	451.52	451.95	451.52	451.95	17671.0
2023-09-01 05:30:00	SPY	ETF	451.92	451.95	451.69	451.71	9031.0
2023-09-01 06:00:00	SPY	ETF	451.7	452.03	451.49	451.94	16157.0
2023-09-01 06:30:00	SPY	ETF	451.9	452.54	451.89	452.05	124947.0
2023-09-01 07:00:00	SPY	ETF	451.99	452.28	451.86	452.18	74582.0
2023-09-01 07:30:00	SPY	ETF	452.13	452.32	451.99	452.06	50201.0
2023-09-01 08:00:00	SPY	ETF	450.94	452.4	450.75	452.17	274230.0
2023-09-01 08:30:00	SPY	ETF	452.44	453.5	451.71	453.11	1052482.0
2023-09-01 09:00:00	SPY	ETF	453.13	453.66	452.85	453.17	460232.0
2023-09-01 09:30:00	SPY	ETF	453.17	453.67	451.15	452.3358	6667357.0
2023-09-01 10:00:00	SPY	ETF	452.3	453.04	451.16	452.72	5452592.0
2023-09-01 10:30:00	SPY	ETF	452.71	452.71	450.67	450.98	3592192.0
2023-09-01 11:00:00	SPY	ETF	450.95	451.25	450.66	450.83	2401387.0
2023-09-01 11:30:00	SPY	ETF	450.85	450.9823	449.69	449.882	3169405.0
2023-09-01 12:00:00	SPY	ETF	449.88	450.79	449.68	450.58	2016729.0
2023-09-01 12:30:00	SPY	ETF	450.585	451.0	450.1	450.74	2142299.0
2023-09-01 13:00:00	SPY	ETF	450.74	450.895	450.325	450.35	1526903.0
2023-09-01 13:30:00	SPY	ETF	450.34	450.7178	450.18	450.65	1450155.0
2023-09-01 14:00:00	SPY	ETF	450.6457	450.7901	449.92	450.1499	1543983.0
2023-09-01 14:30:00	SPY	ETF	450.131	450.57	449.88	450.55	1826115.0
2023-09-01 15:00:00	SPY	ETF	450.54	451.02	450.38	451.0	2506111.0
2023-09-01 15:30:00	SPY	ETF	451.01	451.3	450.58	451.21	8005207.0
2023-09-01 16:00:00	SPY	ETF	451.21	452.3699	450.94	450.98	2717081.0
2023-09-01 16:30:00	SPY	ETF	451.0	451.19	450.81	450.82	427964.0
2023-09-01 17:00:00	SPY	ETF	450.92	450.93	450.25	450.35	132629.0
2023-09-01 17:30:00	SPY	ETF	450.35	450.5	450.1	450.48	110982.0
2023-09-01 18:00:00	SPY	ETF	450.5	451.0	450.0	450.99	140432.0
2023-09-01 18:30:00	SPY	ETF	450.98	450.99	450.82	450.85	10753.0
2023-09-01 19:00:00	SPY	ETF	450.94	450.95	450.86	450.87	1398.0
2023-09-01 19:30:00	SPY	ETF	450.91	450.95	450.85	450.92	12246.0
2023-09-01 04:00:00	QQQ	ETF	378.13	378.61	378.13	378.31	7582.0
2023-09-01 04:30:00	QQQ	ETF	378.33	378.45	378.2	378.3	9101.0
2023-09-01 05:00:00	QQQ	ETF	378.29	378.8	378.28	378.73	30586.0
2023-09-01 05:30:00	QQQ	ETF	378.76	378.76	378.45	378.45	5157.0
2023-09-01 06:00:00	QQQ	ETF	378.51	378.74	378.31	378.65	6378.0
2023-09-01 06:30:00	QQQ	ETF	378.64	378.83	378.53	378.57	4160.0
2023-09-01 07:00:00	QQQ	ETF	378.67	379.08	378.6	378.96	46361.0
2023-09-01 07:30:00	QQQ	ETF	378.96	379.1	378.761	378.83	40137.0
2023-09-01 08:00:00	QQQ	ETF	378.78	379.1	377.3	379.069	338220.0
2023-09-01 08:30:00	QQQ	ETF	379.07	381.0	378.45	380.49	1211060.0
2023-09-01 09:00:00	QQQ	ETF	380.55	381.05	380.05	380.4	306307.0
2023-09-01 09:30:00	QQQ	ETF	380.4	380.83	377.15	378.58	5915882.0
2023-09-01 10:00:00	QQQ	ETF	378.56	379.42	377.29	379.21	3596931.0
2023-09-01 10:30:00	QQQ	ETF	379.2	379.2	376.751	377.055	2579303.0
2023-09-01 11:00:00	QQQ	ETF	377.05	377.82	376.84	377.35	1706541.0
2023-09-01 11:30:00	QQQ	ETF	377.37	377.56	376.12	376.29	1840222.0
2023-09-01 12:00:00	QQQ	ETF	376.27	377.39	376.0801	377.14	1604114.0
2023-09-01 12:30:00	QQQ	ETF	377.11	377.73	376.65	377.55	1264664.0

> showing 50 of 27,294 rows — these rows as CSV

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