PREVIEW / etf_30min / 2023-10-09

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-09.parquet
  size:    706 KB
  rows:    28,056

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-10-09 04:00:00	SPY	ETF	426.08	426.91	425.95	425.98	50226.0
2023-10-09 04:30:00	SPY	ETF	426.03	427.15	426.03	427.08	19447.0
2023-10-09 05:00:00	SPY	ETF	427.03	427.61	426.96	427.46	21964.0
2023-10-09 05:30:00	SPY	ETF	427.37	427.48	426.96	427.06	26474.0
2023-10-09 06:00:00	SPY	ETF	427.13	427.59	427.12	427.19	17517.0
2023-10-09 06:30:00	SPY	ETF	427.16	427.38	426.89	426.89	25339.0
2023-10-09 07:00:00	SPY	ETF	427.0	427.14	426.61	426.77	95805.0
2023-10-09 07:30:00	SPY	ETF	426.77	426.87	426.43	426.8	126518.0
2023-10-09 08:00:00	SPY	ETF	427.0608	427.6196	425.5	427.21	323487.0
2023-10-09 08:30:00	SPY	ETF	427.18	427.18	426.26	426.49	327885.0
2023-10-09 09:00:00	SPY	ETF	426.47	427.84	426.46	427.53	563339.0
2023-10-09 09:30:00	SPY	ETF	427.58	429.09	427.35	428.85	6572293.0
2023-10-09 10:00:00	SPY	ETF	428.845	429.14	427.7	428.335	4344542.0
2023-10-09 10:30:00	SPY	ETF	428.32	428.52	427.0101	427.365	4279093.0
2023-10-09 11:00:00	SPY	ETF	427.36	428.74	427.28	428.67	3109741.0
2023-10-09 11:30:00	SPY	ETF	428.67	429.08	428.2886	429.035	2785628.0
2023-10-09 12:00:00	SPY	ETF	429.04	429.98	428.77	429.16	3446742.0
2023-10-09 12:30:00	SPY	ETF	429.15	429.49	428.54	428.94	2394724.0
2023-10-09 13:00:00	SPY	ETF	428.97	429.94	428.83	429.93	2018250.0
2023-10-09 13:30:00	SPY	ETF	429.92	432.13	429.92	432.11	5034073.0
2023-10-09 14:00:00	SPY	ETF	432.12	432.57	431.7801	432.44	4422105.0
2023-10-09 14:30:00	SPY	ETF	432.44	432.88	431.695	432.55	4250647.0
2023-10-09 15:00:00	SPY	ETF	432.55	432.68	431.945	432.26	3992268.0
2023-10-09 15:30:00	SPY	ETF	432.25	432.29	431.56	432.27	9193157.0
2023-10-09 16:00:00	SPY	ETF	432.27	432.51	428.5063	432.23	3374234.0
2023-10-09 16:30:00	SPY	ETF	432.27	432.27	432.15	432.18	68246.0
2023-10-09 17:00:00	SPY	ETF	432.33	432.33	432.14	432.23	21325.0
2023-10-09 17:30:00	SPY	ETF	432.28	432.35	432.16	432.16	25348.0
2023-10-09 18:00:00	SPY	ETF	432.2	432.24	432.08	432.24	26619.0
2023-10-09 18:30:00	SPY	ETF	432.21	432.24	432.13	432.13	14766.0
2023-10-09 19:00:00	SPY	ETF	432.15	432.26	432.12	432.26	10418.0
2023-10-09 19:30:00	SPY	ETF	432.25	432.28	432.13	432.26	27104.0
2023-10-09 04:00:00	QQQ	ETF	362.47	362.47	361.45	361.45	166418.0
2023-10-09 04:30:00	QQQ	ETF	361.64	362.53	361.58	362.37	40896.0
2023-10-09 05:00:00	QQQ	ETF	362.4	362.66	362.2	362.46	35734.0
2023-10-09 05:30:00	QQQ	ETF	362.42	362.42	361.95	362.05	22189.0
2023-10-09 06:00:00	QQQ	ETF	362.2	362.47	362.12	362.16	11242.0
2023-10-09 06:30:00	QQQ	ETF	362.17	362.27	361.9	361.92	16102.0
2023-10-09 07:00:00	QQQ	ETF	361.95	362.12	361.6	361.72	126365.0
2023-10-09 07:30:00	QQQ	ETF	361.69	361.9	361.5	361.85	124646.0
2023-10-09 08:00:00	QQQ	ETF	361.9581	362.73	361.45	362.32	360404.0
2023-10-09 08:30:00	QQQ	ETF	362.35	362.35	361.36	361.69	360646.0
2023-10-09 09:00:00	QQQ	ETF	361.68	362.84	361.68	362.35	392241.0
2023-10-09 09:30:00	QQQ	ETF	362.3	363.529	360.78	363.3	5994021.0
2023-10-09 10:00:00	QQQ	ETF	363.31	363.6197	361.74	362.83	3299870.0
2023-10-09 10:30:00	QQQ	ETF	362.81	363.0409	361.51	361.79	2266487.0
2023-10-09 11:00:00	QQQ	ETF	361.78	362.84	361.175	362.76	1983514.0
2023-10-09 11:30:00	QQQ	ETF	362.76	363.22	362.53	363.2	1820532.0
2023-10-09 12:00:00	QQQ	ETF	363.2	364.3	363.06	363.59	1585221.0
2023-10-09 12:30:00	QQQ	ETF	363.59	363.857	363.13	363.52	1504033.0

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

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