PREVIEW / etf_30min / 2022-09-29

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-29.parquet
  size:    674 KB
  rows:    27,469

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-29 04:00:00	SPY	ETF	366.02	367.48	364.0	366.37	47210.0
2022-09-29 04:30:00	SPY	ETF	366.22	366.72	365.81	366.09	129786.0
2022-09-29 05:00:00	SPY	ETF	366.3	367.71	366.0	367.1	68784.0
2022-09-29 05:30:00	SPY	ETF	367.27	368.29	367.09	367.69	79477.0
2022-09-29 06:00:00	SPY	ETF	367.57	367.6	366.44	366.69	71372.0
2022-09-29 06:30:00	SPY	ETF	366.7	367.7	366.6	367.06	76299.0
2022-09-29 07:00:00	SPY	ETF	367.07	368.5	367.02	368.41	157745.0
2022-09-29 07:30:00	SPY	ETF	368.44	368.49	367.31	367.35	270519.0
2022-09-29 08:00:00	SPY	ETF	367.17	370.85	365.29	367.51	639201.0
2022-09-29 08:30:00	SPY	ETF	367.39	368.22	364.77	365.8	1348303.0
2022-09-29 09:00:00	SPY	ETF	365.77	367.35	365.5	366.8	586323.0
2022-09-29 09:30:00	SPY	ETF	366.81	367.11	362.81	363.19	9942206.0
2022-09-29 10:00:00	SPY	ETF	363.19	363.33	360.59	361.83	8761335.0
2022-09-29 10:30:00	SPY	ETF	361.84	363.068	360.75	362.56	6762716.0
2022-09-29 11:00:00	SPY	ETF	362.56	363.91	362.12	362.7699	5591564.0
2022-09-29 11:30:00	SPY	ETF	362.788	364.67	362.31	364.01	4823386.0
2022-09-29 12:00:00	SPY	ETF	364.0	364.43	362.44	362.83	3132225.0
2022-09-29 12:30:00	SPY	ETF	362.83	363.45	362.17	362.2701	3078118.0
2022-09-29 13:00:00	SPY	ETF	362.275	362.32	361.44	361.73	3320031.0
2022-09-29 13:30:00	SPY	ETF	361.74	362.455	360.44	360.5	4283430.0
2022-09-29 14:00:00	SPY	ETF	360.51	360.96	359.7	360.74	5392052.0
2022-09-29 14:30:00	SPY	ETF	360.75	361.58	359.9	359.919	4368166.0
2022-09-29 15:00:00	SPY	ETF	359.92	361.98	359.883	361.26	6080982.0
2022-09-29 15:30:00	SPY	ETF	361.26	363.255	361.13	362.79	15526636.0
2022-09-29 16:00:00	SPY	ETF	362.8	363.8	362.72	363.12	6025061.0
2022-09-29 16:30:00	SPY	ETF	363.11	363.28	362.98	363.28	173599.0
2022-09-29 17:00:00	SPY	ETF	363.24	363.28	362.79	363.1	63487.0
2022-09-29 17:30:00	SPY	ETF	363.13	363.18	363.0	363.0	41569.0
2022-09-29 18:00:00	SPY	ETF	362.99	364.1	362.85	363.51	202875.0
2022-09-29 18:30:00	SPY	ETF	363.51	363.86	363.25	363.74	55655.0
2022-09-29 19:00:00	SPY	ETF	363.83	364.05	363.7	364.05	19791.0
2022-09-29 19:30:00	SPY	ETF	364.06	364.43	364.0	364.21	61951.0
2022-09-29 04:00:00	QQQ	ETF	277.46	277.46	275.63	276.3	105999.0
2022-09-29 04:30:00	QQQ	ETF	276.24	276.66	275.9	276.05	74373.0
2022-09-29 05:00:00	QQQ	ETF	276.3	277.36	275.97	276.9	47088.0
2022-09-29 05:30:00	QQQ	ETF	276.97	277.82	276.9	277.07	44133.0
2022-09-29 06:00:00	QQQ	ETF	277.03	277.12	275.93	276.18	77909.0
2022-09-29 06:30:00	QQQ	ETF	276.17	277.0	276.12	276.45	78792.0
2022-09-29 07:00:00	QQQ	ETF	276.4	277.65	276.37	277.5	155434.0
2022-09-29 07:30:00	QQQ	ETF	277.47	277.65	276.62	276.62	188597.0
2022-09-29 08:00:00	QQQ	ETF	276.58	280.2	275.5	276.93	482604.0
2022-09-29 08:30:00	QQQ	ETF	276.6	276.82	274.57	275.5	969326.0
2022-09-29 09:00:00	QQQ	ETF	275.45	276.58	275.17	275.9	708868.0
2022-09-29 09:30:00	QQQ	ETF	275.9	276.25	272.48	272.8	8100901.0
2022-09-29 10:00:00	QQQ	ETF	272.81	273.07	270.46	271.4592	7477551.0
2022-09-29 10:30:00	QQQ	ETF	271.45	272.26	270.45	271.83	4329069.0
2022-09-29 11:00:00	QQQ	ETF	271.83	272.76	271.23	271.85	3477047.0
2022-09-29 11:30:00	QQQ	ETF	271.835	273.27	271.5201	272.8224	3119999.0
2022-09-29 12:00:00	QQQ	ETF	272.84	273.175	271.24	271.54	2339746.0
2022-09-29 12:30:00	QQQ	ETF	271.53	271.97	270.91	271.04	1938308.0

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

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