PREVIEW / etf_30min / 2023-06-22

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-22.parquet
  size:    679 KB
  rows:    27,319

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-06-22 04:00:00	SPY	ETF	434.46	434.46	433.76	434.23	13252.0
2023-06-22 04:30:00	SPY	ETF	434.01	434.31	434.0	434.1	11419.0
2023-06-22 05:00:00	SPY	ETF	434.17	434.35	434.09	434.09	10210.0
2023-06-22 05:30:00	SPY	ETF	434.25	434.58	434.23	434.35	5598.0
2023-06-22 06:00:00	SPY	ETF	434.35	434.39	433.93	434.15	12861.0
2023-06-22 06:30:00	SPY	ETF	434.12	434.16	433.64	433.85	90035.0
2023-06-22 07:00:00	SPY	ETF	433.88	433.96	433.48	433.74	347933.0
2023-06-22 07:30:00	SPY	ETF	433.58	434.07	433.55	434.02	42686.0
2023-06-22 08:00:00	SPY	ETF	433.8	434.94	433.56	433.92	140183.0
2023-06-22 08:30:00	SPY	ETF	434.1	434.57	433.86	434.01	135059.0
2023-06-22 09:00:00	SPY	ETF	433.95	434.15	433.67	433.95	130151.0
2023-06-22 09:30:00	SPY	ETF	433.94	435.0899	433.6	434.7472	5756974.0
2023-06-22 10:00:00	SPY	ETF	434.79	436.02	434.515	435.58	4312641.0
2023-06-22 10:30:00	SPY	ETF	435.59	435.85	434.03	434.5295	4241911.0
2023-06-22 11:00:00	SPY	ETF	434.52	435.4	434.48	434.86	2694656.0
2023-06-22 11:30:00	SPY	ETF	434.84	435.83	434.74	435.57	2461945.0
2023-06-22 12:00:00	SPY	ETF	435.58	435.59	434.885	435.2428	2288800.0
2023-06-22 12:30:00	SPY	ETF	435.26	435.67	435.015	435.24	2105070.0
2023-06-22 13:00:00	SPY	ETF	435.24	435.26	434.415	435.01	2358318.0
2023-06-22 13:30:00	SPY	ETF	435.02	435.69	434.81	435.655	2136647.0
2023-06-22 14:00:00	SPY	ETF	435.65	435.9891	435.465	435.945	2413571.0
2023-06-22 14:30:00	SPY	ETF	435.95	436.45	435.69	436.4	3328863.0
2023-06-22 15:00:00	SPY	ETF	436.4	436.455	435.54	435.58	2822298.0
2023-06-22 15:30:00	SPY	ETF	435.58	436.62	435.335	436.54	8794691.0
2023-06-22 16:00:00	SPY	ETF	436.54	436.68	436.19	436.45	2062355.0
2023-06-22 16:30:00	SPY	ETF	436.46	436.81	436.44	436.7	177445.0
2023-06-22 17:00:00	SPY	ETF	436.67	436.89	436.6	436.8	54216.0
2023-06-22 17:30:00	SPY	ETF	436.79	436.86	436.75	436.77	28615.0
2023-06-22 18:00:00	SPY	ETF	436.77	436.82	436.57	436.8	141643.0
2023-06-22 18:30:00	SPY	ETF	436.7799	436.7799	436.7	436.7	12486.0
2023-06-22 19:00:00	SPY	ETF	436.74	436.76	436.65	436.67	40446.0
2023-06-22 19:30:00	SPY	ETF	436.67	436.73	436.56	436.58	24661.0
2023-06-22 04:00:00	QQQ	ETF	361.1	361.19	360.88	361.09	20561.0
2023-06-22 04:30:00	QQQ	ETF	361.01	361.09	360.74	360.88	6281.0
2023-06-22 05:00:00	QQQ	ETF	361.0	361.32	360.92	361.1	6643.0
2023-06-22 05:30:00	QQQ	ETF	361.15	361.62	361.15	361.46	40622.0
2023-06-22 06:00:00	QQQ	ETF	361.58	361.63	360.85	360.99	19705.0
2023-06-22 06:30:00	QQQ	ETF	360.94	360.94	360.52	360.69	37061.0
2023-06-22 07:00:00	QQQ	ETF	360.7	361.01	360.34	360.6	137873.0
2023-06-22 07:30:00	QQQ	ETF	360.58	361.05	360.561	360.98	56854.0
2023-06-22 08:00:00	QQQ	ETF	360.57	362.171	360.46	360.96	101038.0
2023-06-22 08:30:00	QQQ	ETF	361.15	361.61	360.72	360.91	272643.0
2023-06-22 09:00:00	QQQ	ETF	360.83	361.2	360.49	360.64	315960.0
2023-06-22 09:30:00	QQQ	ETF	360.63	363.42	360.22	363.0839	4811029.0
2023-06-22 10:00:00	QQQ	ETF	363.11	364.69	362.702	364.355	3811033.0
2023-06-22 10:30:00	QQQ	ETF	364.35	364.49	362.43	363.06	3053178.0
2023-06-22 11:00:00	QQQ	ETF	363.05	364.565	363.03	363.7103	2344976.0
2023-06-22 11:30:00	QQQ	ETF	363.72	365.45	363.51	364.9	2490234.0
2023-06-22 12:00:00	QQQ	ETF	364.91	364.935	363.752	364.09	1674434.0
2023-06-22 12:30:00	QQQ	ETF	364.12	364.69	363.92	364.14	1283587.0

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

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