PREVIEW / etf_30min / 2022-09-26

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-26.parquet
  size:    695 KB
  rows:    28,645

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
2022-09-26 04:00:00	SPY	ETF	367.17	368.03	365.9	368.03	44154.0
2022-09-26 04:30:00	SPY	ETF	368.14	368.22	367.37	367.6	15334.0
2022-09-26 05:00:00	SPY	ETF	367.54	367.76	365.82	366.0	39863.0
2022-09-26 05:30:00	SPY	ETF	365.99	366.01	364.44	364.82	50525.0
2022-09-26 06:00:00	SPY	ETF	365.08	365.96	364.43	365.87	35272.0
2022-09-26 06:30:00	SPY	ETF	365.84	366.0	365.3	365.4	145443.0
2022-09-26 07:00:00	SPY	ETF	365.32	365.68	364.81	365.65	173924.0
2022-09-26 07:30:00	SPY	ETF	365.59	366.0	365.5	365.76	153587.0
2022-09-26 08:00:00	SPY	ETF	365.8	368.7	364.7396	366.22	346445.0
2022-09-26 08:30:00	SPY	ETF	366.28	367.4	365.47	367.27	500899.0
2022-09-26 09:00:00	SPY	ETF	367.17	367.45	366.35	366.45	394939.0
2022-09-26 09:30:00	SPY	ETF	366.43	368.67	366.06	368.43	6524083.0
2022-09-26 10:00:00	SPY	ETF	368.48	370.21	367.38	369.82	5174373.0
2022-09-26 10:30:00	SPY	ETF	369.83	369.92	367.82	368.48	3851342.0
2022-09-26 11:00:00	SPY	ETF	368.5	368.84	365.93	365.95	3794475.0
2022-09-26 11:30:00	SPY	ETF	365.97	367.17	365.34	366.85	4434245.0
2022-09-26 12:00:00	SPY	ETF	366.86	366.89	364.41	364.665	3641181.0
2022-09-26 12:30:00	SPY	ETF	364.67	365.91	363.89	365.57	4273375.0
2022-09-26 13:00:00	SPY	ETF	365.57	365.59	363.0299	363.67	4349200.0
2022-09-26 13:30:00	SPY	ETF	363.63	364.72	363.18	363.31	3754955.0
2022-09-26 14:00:00	SPY	ETF	363.29	365.22	363.1619	363.819	3671810.0
2022-09-26 14:30:00	SPY	ETF	363.8	365.98	363.48	365.5297	4532556.0
2022-09-26 15:00:00	SPY	ETF	365.52	366.23	364.81	365.46	5574977.0
2022-09-26 15:30:00	SPY	ETF	365.47	366.86	363.94	364.31	11718510.0
2022-09-26 16:00:00	SPY	ETF	364.31	364.71	363.37	363.84	3094323.0
2022-09-26 16:30:00	SPY	ETF	363.8	364.31	363.63	363.93	457052.0
2022-09-26 17:00:00	SPY	ETF	363.9	364.31	363.9	363.94	134045.0
2022-09-26 17:30:00	SPY	ETF	363.99	364.31	363.75	363.91	292973.0
2022-09-26 18:00:00	SPY	ETF	363.94	364.33	363.4	364.19	109426.0
2022-09-26 18:30:00	SPY	ETF	364.27	364.49	364.24	364.38	68186.0
2022-09-26 19:00:00	SPY	ETF	364.43	364.98	364.43	364.93	48534.0
2022-09-26 19:30:00	SPY	ETF	364.9	365.31	364.67	365.1	63523.0
2022-09-26 04:00:00	QQQ	ETF	275.51	276.25	274.8	276.23	103862.0
2022-09-26 04:30:00	QQQ	ETF	276.31	276.33	275.55	275.75	32925.0
2022-09-26 05:00:00	QQQ	ETF	275.81	275.91	274.44	274.54	45171.0
2022-09-26 05:30:00	QQQ	ETF	274.55	274.6	273.25	273.82	129643.0
2022-09-26 06:00:00	QQQ	ETF	274.0	274.68	273.54	274.62	71844.0
2022-09-26 06:30:00	QQQ	ETF	274.61	274.64	274.0	274.05	91062.0
2022-09-26 07:00:00	QQQ	ETF	274.03	274.12	273.37	274.06	170822.0
2022-09-26 07:30:00	QQQ	ETF	274.07	274.36	273.86	274.1	115112.0
2022-09-26 08:00:00	QQQ	ETF	274.06	276.2796	273.15	274.58	292336.0
2022-09-26 08:30:00	QQQ	ETF	274.59	275.79	274.0	275.76	435002.0
2022-09-26 09:00:00	QQQ	ETF	275.76	275.82	274.75	274.98	488942.0
2022-09-26 09:30:00	QQQ	ETF	274.98	278.53	274.75	278.36	7675856.0
2022-09-26 10:00:00	QQQ	ETF	278.38	279.49	277.49	279.115	5467171.0
2022-09-26 10:30:00	QQQ	ETF	279.08	279.16	277.01	277.58	3463344.0
2022-09-26 11:00:00	QQQ	ETF	277.605	277.9	275.58	275.61	3412052.0
2022-09-26 11:30:00	QQQ	ETF	275.61	276.73	275.0504	276.47	3295262.0
2022-09-26 12:00:00	QQQ	ETF	276.5	276.505	274.19	274.42	2733158.0
2022-09-26 12:30:00	QQQ	ETF	274.42	275.79	273.96	275.4738	3087375.0

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

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