PREVIEW / etf_30min / 2023-06-23

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-23.parquet
  size:    684 KB
  rows:    27,450

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-23 04:00:00	SPY	ETF	434.63	434.98	434.42	434.46	26718.0
2023-06-23 04:30:00	SPY	ETF	434.52	434.81	434.3	434.35	14792.0
2023-06-23 05:00:00	SPY	ETF	434.35	434.63	434.3	434.3	7097.0
2023-06-23 05:30:00	SPY	ETF	434.44	434.71	434.32	434.65	7468.0
2023-06-23 06:00:00	SPY	ETF	434.63	434.7	434.31	434.53	9622.0
2023-06-23 06:30:00	SPY	ETF	434.41	434.49	434.2	434.33	111198.0
2023-06-23 07:00:00	SPY	ETF	434.37	435.03	434.34	434.87	97361.0
2023-06-23 07:30:00	SPY	ETF	434.869	434.869	434.48	434.61	127281.0
2023-06-23 08:00:00	SPY	ETF	434.64	435.4	434.0	434.09	346243.0
2023-06-23 08:30:00	SPY	ETF	434.06	434.07	432.97	433.15	513830.0
2023-06-23 09:00:00	SPY	ETF	433.16	433.5	432.88	432.93	339800.0
2023-06-23 09:30:00	SPY	ETF	432.93	433.589	432.7117	433.405	6432735.0
2023-06-23 10:00:00	SPY	ETF	433.4	433.99	433.16	433.6701	4113444.0
2023-06-23 10:30:00	SPY	ETF	433.675	434.24	433.105	433.575	3305472.0
2023-06-23 11:00:00	SPY	ETF	433.58	433.79	432.84	433.17	3140592.0
2023-06-23 11:30:00	SPY	ETF	433.16	433.99	433.005	433.855	2962034.0
2023-06-23 12:00:00	SPY	ETF	433.86	434.57	433.71	434.52	3070558.0
2023-06-23 12:30:00	SPY	ETF	434.53	434.83	434.27	434.55	2823497.0
2023-06-23 13:00:00	SPY	ETF	434.56	434.9	434.2	434.82	2024038.0
2023-06-23 13:30:00	SPY	ETF	434.82	435.06	434.58	434.58	2020631.0
2023-06-23 14:00:00	SPY	ETF	434.575	434.66	433.8899	433.995	3476155.0
2023-06-23 14:30:00	SPY	ETF	433.99	434.035	432.89	432.97	4736590.0
2023-06-23 15:00:00	SPY	ETF	432.98	433.57	432.47	433.125	6128307.0
2023-06-23 15:30:00	SPY	ETF	433.13	433.98	432.96	433.21	12723116.0
2023-06-23 16:00:00	SPY	ETF	433.21	433.42	432.56	432.9	4092077.0
2023-06-23 16:30:00	SPY	ETF	432.9	433.21	432.88	433.04	90823.0
2023-06-23 17:00:00	SPY	ETF	433.0599	433.21	432.96	432.96	44082.0
2023-06-23 17:30:00	SPY	ETF	432.94	432.95	432.86	432.91	16747.0
2023-06-23 18:00:00	SPY	ETF	432.91	433.21	432.86	432.86	7285.0
2023-06-23 18:30:00	SPY	ETF	432.81	432.84	432.66	432.74	13755.0
2023-06-23 19:00:00	SPY	ETF	432.73	432.82	432.6701	432.74	5701.0
2023-06-23 19:30:00	SPY	ETF	432.81	432.81	432.67	432.73	6853.0
2023-06-23 04:00:00	QQQ	ETF	364.88	364.88	363.83	363.9	65238.0
2023-06-23 04:30:00	QQQ	ETF	363.87	364.2	363.37	363.48	25644.0
2023-06-23 05:00:00	QQQ	ETF	363.55	364.01	363.55	363.59	61826.0
2023-06-23 05:30:00	QQQ	ETF	363.75	364.11	363.68	364.0	26362.0
2023-06-23 06:00:00	QQQ	ETF	363.99	364.07	363.62	363.81	20549.0
2023-06-23 06:30:00	QQQ	ETF	363.79	363.86	363.45	363.76	24638.0
2023-06-23 07:00:00	QQQ	ETF	363.76	364.6	363.76	364.43	87960.0
2023-06-23 07:30:00	QQQ	ETF	364.42	364.48	364.01	364.18	117711.0
2023-06-23 08:00:00	QQQ	ETF	364.01	364.89	363.51	363.62	227147.0
2023-06-23 08:30:00	QQQ	ETF	363.59	363.62	361.67	362.179	556250.0
2023-06-23 09:00:00	QQQ	ETF	362.1	362.58	361.95	362.17	351659.0
2023-06-23 09:30:00	QQQ	ETF	362.21	363.3	360.8227	361.655	5778304.0
2023-06-23 10:00:00	QQQ	ETF	361.66	362.8799	361.17	362.2999	3200589.0
2023-06-23 10:30:00	QQQ	ETF	362.28	363.2	361.79	362.35	2240165.0
2023-06-23 11:00:00	QQQ	ETF	362.36	362.67	361.35	361.62	1938787.0
2023-06-23 11:30:00	QQQ	ETF	361.62	362.85	361.3501	362.545	2154869.0
2023-06-23 12:00:00	QQQ	ETF	362.55	363.87	362.5399	363.84	2188099.0
2023-06-23 12:30:00	QQQ	ETF	363.86	364.2	363.6	364.05	1803850.0

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

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