PREVIEW / etf_30min / 2022-09-28

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-28.parquet
  size:    698 KB
  rows:    28,488

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-28 04:00:00	SPY	ETF	361.77	361.87	360.44	360.53	71884.0
2022-09-28 04:30:00	SPY	ETF	360.36	361.33	360.19	361.02	24730.0
2022-09-28 05:00:00	SPY	ETF	360.94	360.98	358.72	359.3	87881.0
2022-09-28 05:30:00	SPY	ETF	359.34	359.72	359.0	359.11	86404.0
2022-09-28 06:00:00	SPY	ETF	359.07	363.8	358.83	362.84	442833.0
2022-09-28 06:30:00	SPY	ETF	362.81	363.83	361.79	362.32	290437.0
2022-09-28 07:00:00	SPY	ETF	362.23	362.5	360.64	361.38	300989.0
2022-09-28 07:30:00	SPY	ETF	361.42	362.24	360.74	361.2	222983.0
2022-09-28 08:00:00	SPY	ETF	361.25	363.3404	359.0004	362.91	513734.0
2022-09-28 08:30:00	SPY	ETF	362.93	365.41	362.6	364.4	858447.0
2022-09-28 09:00:00	SPY	ETF	364.4	365.25	362.79	364.38	1674793.0
2022-09-28 09:30:00	SPY	ETF	364.38	364.96	362.6	364.305	8273706.0
2022-09-28 10:00:00	SPY	ETF	364.305	366.5	363.15	366.43	6740976.0
2022-09-28 10:30:00	SPY	ETF	366.43	367.5	365.9231	366.51	5742607.0
2022-09-28 11:00:00	SPY	ETF	366.54	368.24	366.16	367.2802	4837063.0
2022-09-28 11:30:00	SPY	ETF	367.29	368.46	366.56	368.3216	3681897.0
2022-09-28 12:00:00	SPY	ETF	368.35	369.57	368.15	368.3511	4134304.0
2022-09-28 12:30:00	SPY	ETF	368.36	369.34	368.11	368.88	3195199.0
2022-09-28 13:00:00	SPY	ETF	368.9	370.0	368.41	369.25	4277127.0
2022-09-28 13:30:00	SPY	ETF	369.25	369.5	368.23	368.71	3186713.0
2022-09-28 14:00:00	SPY	ETF	368.71	369.25	368.38	368.86	2852228.0
2022-09-28 14:30:00	SPY	ETF	368.86	369.8048	368.76	369.46	3181046.0
2022-09-28 15:00:00	SPY	ETF	369.47	371.15	369.36	370.845	5989518.0
2022-09-28 15:30:00	SPY	ETF	370.855	372.3	370.3	370.48	13473866.0
2022-09-28 16:00:00	SPY	ETF	370.48	371.1676	370.14	370.53	5849707.0
2022-09-28 16:30:00	SPY	ETF	370.5	370.6	370.1	370.25	279625.0
2022-09-28 17:00:00	SPY	ETF	370.11	370.35	370.11	370.24	60407.0
2022-09-28 17:30:00	SPY	ETF	370.22	370.53	370.2	370.25	142645.0
2022-09-28 18:00:00	SPY	ETF	370.25	370.78	370.25	370.75	83534.0
2022-09-28 18:30:00	SPY	ETF	370.76	370.77	369.59	369.89	69353.0
2022-09-28 19:00:00	SPY	ETF	369.89	370.15	369.78	370.07	41504.0
2022-09-28 19:30:00	SPY	ETF	370.1	370.11	369.76	370.0	74728.0
2022-09-28 04:00:00	QQQ	ETF	272.83	272.83	271.18	271.36	75783.0
2022-09-28 04:30:00	QQQ	ETF	271.28	271.94	270.95	271.67	19810.0
2022-09-28 05:00:00	QQQ	ETF	271.69	271.78	270.03	270.5	76457.0
2022-09-28 05:30:00	QQQ	ETF	270.4	270.61	270.05	270.27	41159.0
2022-09-28 06:00:00	QQQ	ETF	270.13	273.99	269.96	273.04	671995.0
2022-09-28 06:30:00	QQQ	ETF	273.12	273.96	272.12	272.41	258631.0
2022-09-28 07:00:00	QQQ	ETF	272.53	272.74	271.15	271.65	405363.0
2022-09-28 07:30:00	QQQ	ETF	271.68	272.34	271.19	271.72	206719.0
2022-09-28 08:00:00	QQQ	ETF	272.61	274.685	270.1904	273.1	529659.0
2022-09-28 08:30:00	QQQ	ETF	273.0275	275.05	272.77	274.25	932552.0
2022-09-28 09:00:00	QQQ	ETF	274.25	275.0	273.43	274.44	896549.0
2022-09-28 09:30:00	QQQ	ETF	274.46	275.0	272.945	274.0101	6616318.0
2022-09-28 10:00:00	QQQ	ETF	274.03	276.36	273.04	276.31	5572370.0
2022-09-28 10:30:00	QQQ	ETF	276.31	276.92	275.66	276.07	4789269.0
2022-09-28 11:00:00	QQQ	ETF	276.09	277.7	275.76	276.84	3490920.0
2022-09-28 11:30:00	QQQ	ETF	276.84	278.1	276.3282	278.04	2839136.0
2022-09-28 12:00:00	QQQ	ETF	278.04	278.85	277.62	277.7	3048220.0
2022-09-28 12:30:00	QQQ	ETF	277.71	278.33	277.44	277.97	1888479.0

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

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