PREVIEW / etf_30min / 2022-10-03

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-03.parquet
  size:    694 KB
  rows:    28,163

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-10-03 04:00:00	SPY	ETF	358.0	358.0	356.7	356.97	29360.0
2022-10-03 04:30:00	SPY	ETF	357.21	357.6	357.2	357.4	13950.0
2022-10-03 05:00:00	SPY	ETF	357.44	357.88	356.3	357.88	50364.0
2022-10-03 05:30:00	SPY	ETF	357.8	358.24	357.5	358.02	45022.0
2022-10-03 06:00:00	SPY	ETF	358.09	358.59	357.9	358.59	67406.0
2022-10-03 06:30:00	SPY	ETF	358.59	359.18	357.98	359.14	106093.0
2022-10-03 07:00:00	SPY	ETF	359.12	359.34	358.77	359.2	273177.0
2022-10-03 07:30:00	SPY	ETF	359.06	359.99	358.87	359.99	269426.0
2022-10-03 08:00:00	SPY	ETF	359.0001	360.4	356.76	360.08	290235.0
2022-10-03 08:30:00	SPY	ETF	360.0	361.65	359.9	361.11	509706.0
2022-10-03 09:00:00	SPY	ETF	361.11	362.0	361.07	361.12	530521.0
2022-10-03 09:30:00	SPY	ETF	361.08	361.63	359.21	360.65	7465106.0
2022-10-03 10:00:00	SPY	ETF	360.6	364.82	360.58	364.3405	6573444.0
2022-10-03 10:30:00	SPY	ETF	364.38	364.95	363.86	364.32	4799072.0
2022-10-03 11:00:00	SPY	ETF	364.3111	365.45	364.09	364.92	4109888.0
2022-10-03 11:30:00	SPY	ETF	364.925	365.19	363.44	363.77	3531842.0
2022-10-03 12:00:00	SPY	ETF	363.78	364.97	363.665	363.73	2717173.0
2022-10-03 12:30:00	SPY	ETF	363.73	364.31	363.4	364.29	2397895.0
2022-10-03 13:00:00	SPY	ETF	364.29	365.6401	364.17	365.3	2799019.0
2022-10-03 13:30:00	SPY	ETF	365.32	366.19	365.27	365.68	3222656.0
2022-10-03 14:00:00	SPY	ETF	365.67	367.609	365.665	367.4901	4161625.0
2022-10-03 14:30:00	SPY	ETF	367.51	368.55	367.35	368.12	4344674.0
2022-10-03 15:00:00	SPY	ETF	368.115	368.37	367.265	368.06	4913434.0
2022-10-03 15:30:00	SPY	ETF	368.0599	368.29	366.08	366.6	12431488.0
2022-10-03 16:00:00	SPY	ETF	366.6	367.24	366.52	367.11	5560496.0
2022-10-03 16:30:00	SPY	ETF	367.09	367.18	366.61	366.9	369507.0
2022-10-03 17:00:00	SPY	ETF	366.98	367.0	366.67	366.98	79804.0
2022-10-03 17:30:00	SPY	ETF	366.99	367.01	366.86	367.0	18209.0
2022-10-03 18:00:00	SPY	ETF	367.04	367.46	366.7	366.72	83551.0
2022-10-03 18:30:00	SPY	ETF	366.76	366.76	366.12	366.48	104491.0
2022-10-03 19:00:00	SPY	ETF	366.48	367.57	366.48	367.42	56419.0
2022-10-03 19:30:00	SPY	ETF	367.55	367.79	367.23	367.69	62718.0
2022-10-03 04:00:00	QQQ	ETF	266.73	266.73	265.43	265.7	91338.0
2022-10-03 04:30:00	QQQ	ETF	265.81	266.18	265.5	266.09	38963.0
2022-10-03 05:00:00	QQQ	ETF	265.95	266.2	265.2	266.18	109504.0
2022-10-03 05:30:00	QQQ	ETF	266.16	266.67	266.11	266.57	77581.0
2022-10-03 06:00:00	QQQ	ETF	266.56	266.98	266.49	266.86	92054.0
2022-10-03 06:30:00	QQQ	ETF	267.04	267.46	266.55	267.45	50324.0
2022-10-03 07:00:00	QQQ	ETF	267.43	267.8	267.24	267.55	320612.0
2022-10-03 07:30:00	QQQ	ETF	267.5	268.34	267.37	268.33	262360.0
2022-10-03 08:00:00	QQQ	ETF	267.46	268.62	265.5796	268.32	548131.0
2022-10-03 08:30:00	QQQ	ETF	268.28	269.59	268.08	269.08	555242.0
2022-10-03 09:00:00	QQQ	ETF	269.08	269.81	269.06	269.14	592445.0
2022-10-03 09:30:00	QQQ	ETF	269.07	269.74	267.53	268.78	5447130.0
2022-10-03 10:00:00	QQQ	ETF	268.76	271.74	268.74	271.51	5614024.0
2022-10-03 10:30:00	QQQ	ETF	271.53	272.1183	271.25	271.34	3406800.0
2022-10-03 11:00:00	QQQ	ETF	271.35	272.26	271.03	272.0	2615944.0
2022-10-03 11:30:00	QQQ	ETF	272.01	272.1816	270.3701	270.81	2092901.0
2022-10-03 12:00:00	QQQ	ETF	270.79	271.92	270.78	271.07	1644628.0
2022-10-03 12:30:00	QQQ	ETF	271.08	271.61	270.76	271.51	1398898.0

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

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