PREVIEW / etf_30min / 2023-03-01

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-01.parquet
  size:    677 KB
  rows:    27,440

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-03-01 04:00:00	SPY	ETF	397.38	397.97	396.52	397.28	43226.0
2023-03-01 04:30:00	SPY	ETF	397.29	397.53	397.16	397.48	27079.0
2023-03-01 05:00:00	SPY	ETF	397.5	397.65	397.28	397.65	14553.0
2023-03-01 05:30:00	SPY	ETF	397.77	397.89	397.5	397.86	22606.0
2023-03-01 06:00:00	SPY	ETF	397.78	398.08	397.77	397.94	63008.0
2023-03-01 06:30:00	SPY	ETF	397.84	397.97	397.68	397.79	20198.0
2023-03-01 07:00:00	SPY	ETF	397.73	397.73	397.23	397.55	172290.0
2023-03-01 07:30:00	SPY	ETF	397.55	397.659	397.39	397.56	193199.0
2023-03-01 08:00:00	SPY	ETF	397.5183	398.0496	396.38	396.42	245911.0
2023-03-01 08:30:00	SPY	ETF	396.38	396.47	395.37	395.42	5327371.0
2023-03-01 09:00:00	SPY	ETF	395.41	395.7	395.03	395.41	530503.0
2023-03-01 09:30:00	SPY	ETF	395.41	396.69	395.16	396.08	8650680.0
2023-03-01 10:00:00	SPY	ETF	396.11	396.58	394.03	394.62	9052636.0
2023-03-01 10:30:00	SPY	ETF	394.61	396.28	394.24	395.849	6628930.0
2023-03-01 11:00:00	SPY	ETF	395.845	395.85	393.38	394.38	7110225.0
2023-03-01 11:30:00	SPY	ETF	394.39	396.13	394.28	395.735	5334549.0
2023-03-01 12:00:00	SPY	ETF	395.74	396.44	395.44	395.7499	4197557.0
2023-03-01 12:30:00	SPY	ETF	395.76	396.28	395.515	395.619	2706613.0
2023-03-01 13:00:00	SPY	ETF	395.62	395.6307	394.8499	394.93	2981600.0
2023-03-01 13:30:00	SPY	ETF	394.94	394.97	394.304	394.8076	3289797.0
2023-03-01 14:00:00	SPY	ETF	394.7901	394.95	394.015	394.06	3391276.0
2023-03-01 14:30:00	SPY	ETF	394.07	394.2884	393.64	394.06	3691319.0
2023-03-01 15:00:00	SPY	ETF	394.07	394.8	393.97	394.215	3721612.0
2023-03-01 15:30:00	SPY	ETF	394.2	395.18	394.11	394.78	9021410.0
2023-03-01 16:00:00	SPY	ETF	394.78	395.3	394.5	395.13	2927575.0
2023-03-01 16:30:00	SPY	ETF	395.13	395.3	395.04	395.16	234717.0
2023-03-01 17:00:00	SPY	ETF	395.16	395.18	394.9	394.9394	73815.0
2023-03-01 17:30:00	SPY	ETF	394.94	394.95	394.76	394.9	42254.0
2023-03-01 18:00:00	SPY	ETF	394.95	395.02	394.83	394.98	81391.0
2023-03-01 18:30:00	SPY	ETF	394.96	395.07	394.94	395.0	20323.0
2023-03-01 19:00:00	SPY	ETF	395.17	395.56	395.12	395.49	67821.0
2023-03-01 19:30:00	SPY	ETF	395.45	395.46	394.53	394.53	86638.0
2023-03-01 04:00:00	QQQ	ETF	294.52	295.05	294.5	294.5	58993.0
2023-03-01 04:30:00	QQQ	ETF	294.53	294.86	294.42	294.86	31977.0
2023-03-01 05:00:00	QQQ	ETF	294.78	294.97	294.53	294.97	17367.0
2023-03-01 05:30:00	QQQ	ETF	294.96	295.28	294.81	295.19	36051.0
2023-03-01 06:00:00	QQQ	ETF	295.13	295.38	295.03	295.22	41514.0
2023-03-01 06:30:00	QQQ	ETF	295.12	295.3	295.0	295.11	37635.0
2023-03-01 07:00:00	QQQ	ETF	295.08	295.12	294.55	294.95	163737.0
2023-03-01 07:30:00	QQQ	ETF	294.91	294.98	294.67	294.8	125048.0
2023-03-01 08:00:00	QQQ	ETF	294.94	295.2896	293.56	293.86	381143.0
2023-03-01 08:30:00	QQQ	ETF	293.82	293.86	292.92	292.93	429755.0
2023-03-01 09:00:00	QQQ	ETF	292.92	293.6	292.64	293.23	510049.0
2023-03-01 09:30:00	QQQ	ETF	293.24	293.93	292.1	293.25	6114849.0
2023-03-01 10:00:00	QQQ	ETF	293.29	293.65	290.89	291.32	6290446.0
2023-03-01 10:30:00	QQQ	ETF	291.31	292.92	290.891	292.2	4102097.0
2023-03-01 11:00:00	QQQ	ETF	292.19	292.19	290.2	290.91	4658061.0
2023-03-01 11:30:00	QQQ	ETF	290.9	292.51	290.75	292.195	3346295.0
2023-03-01 12:00:00	QQQ	ETF	292.22	292.87	291.84	292.24	2921375.0
2023-03-01 12:30:00	QQQ	ETF	292.25	292.75	292.04	292.1404	1529763.0

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

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