PREVIEW / etf_30min / 2023-06-12

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-12.parquet
  size:    711 KB
  rows:    27,718

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-12 04:00:00	SPY	ETF	431.34	431.68	431.01	431.48	33588.0
2023-06-12 04:30:00	SPY	ETF	431.54	431.64	431.3	431.64	6395.0
2023-06-12 05:00:00	SPY	ETF	431.57	431.73	431.55	431.55	9438.0
2023-06-12 05:30:00	SPY	ETF	431.5	431.51	430.92	431.08	12277.0
2023-06-12 06:00:00	SPY	ETF	431.05	431.05	430.43	430.6	15582.0
2023-06-12 06:30:00	SPY	ETF	430.61	430.8	430.48	430.8	23657.0
2023-06-12 07:00:00	SPY	ETF	430.7	431.14	430.61	431.11	44462.0
2023-06-12 07:30:00	SPY	ETF	431.09	431.26	430.99	431.13	59098.0
2023-06-12 08:00:00	SPY	ETF	431.03	431.7096	430.36	430.8	97960.0
2023-06-12 08:30:00	SPY	ETF	430.82	431.36	430.77	431.26	65872.0
2023-06-12 09:00:00	SPY	ETF	431.3	431.35	430.83	430.92	118740.0
2023-06-12 09:30:00	SPY	ETF	430.92	431.26	430.29	430.97	4751746.0
2023-06-12 10:00:00	SPY	ETF	430.98	431.0	430.28	430.73	3695049.0
2023-06-12 10:30:00	SPY	ETF	430.74	430.795	430.17	430.51	3309970.0
2023-06-12 11:00:00	SPY	ETF	430.51	430.79	430.34	430.68	2415991.0
2023-06-12 11:30:00	SPY	ETF	430.65	431.21	430.645	431.1	2691478.0
2023-06-12 12:00:00	SPY	ETF	431.11	431.25	430.99	431.17	2117023.0
2023-06-12 12:30:00	SPY	ETF	431.18	431.54	431.1733	431.455	2111486.0
2023-06-12 13:00:00	SPY	ETF	431.45	431.6	431.28	431.32	1845383.0
2023-06-12 13:30:00	SPY	ETF	431.3123	431.83	431.16	431.79	2582994.0
2023-06-12 14:00:00	SPY	ETF	431.785	431.86	431.58	431.67	2241563.0
2023-06-12 14:30:00	SPY	ETF	431.675	432.57	431.65	432.5119	3089353.0
2023-06-12 15:00:00	SPY	ETF	432.52	433.68	432.41	433.25	6362989.0
2023-06-12 15:30:00	SPY	ETF	433.24	433.88	433.04	433.79	13359542.0
2023-06-12 16:00:00	SPY	ETF	433.79	433.85	433.28	433.82	3208440.0
2023-06-12 16:30:00	SPY	ETF	433.8	434.06	433.8	434.04	272901.0
2023-06-12 17:00:00	SPY	ETF	434.02	434.06	433.8	433.93	61484.0
2023-06-12 17:30:00	SPY	ETF	433.98	433.98	433.88	433.94	20556.0
2023-06-12 18:00:00	SPY	ETF	433.91	433.91	433.78	433.87	39092.0
2023-06-12 18:30:00	SPY	ETF	433.88	434.24	433.87	434.15	46211.0
2023-06-12 19:00:00	SPY	ETF	434.19	434.19	433.98	434.06	25548.0
2023-06-12 19:30:00	SPY	ETF	433.96	433.96	433.73	433.9	53000.0
2023-06-12 04:00:00	QQQ	ETF	356.2	356.48	355.81	356.48	16593.0
2023-06-12 04:30:00	QQQ	ETF	356.52	356.6	356.35	356.6	10684.0
2023-06-12 05:00:00	QQQ	ETF	356.54	356.86	356.54	356.67	11610.0
2023-06-12 05:30:00	QQQ	ETF	356.7	356.7	356.1	356.24	17754.0
2023-06-12 06:00:00	QQQ	ETF	356.25	356.25	355.74	355.86	20890.0
2023-06-12 06:30:00	QQQ	ETF	355.79	356.15	355.65	356.02	17136.0
2023-06-12 07:00:00	QQQ	ETF	356.01	356.35	355.88	356.24	42423.0
2023-06-12 07:30:00	QQQ	ETF	356.269	356.41	356.24	356.33	41435.0
2023-06-12 08:00:00	QQQ	ETF	356.0119	356.8196	354.765	355.96	118169.0
2023-06-12 08:30:00	QQQ	ETF	355.91	356.6299	355.91	356.44	100341.0
2023-06-12 09:00:00	QQQ	ETF	356.5	356.53	356.02	356.16	125809.0
2023-06-12 09:30:00	QQQ	ETF	356.19	356.53	355.64	355.96	4130391.0
2023-06-12 10:00:00	QQQ	ETF	355.97	356.34	355.2	356.24	2567462.0
2023-06-12 10:30:00	QQQ	ETF	356.25	356.854	355.89	356.0014	2232712.0
2023-06-12 11:00:00	QQQ	ETF	356.01	356.58	355.67	356.4309	1351669.0
2023-06-12 11:30:00	QQQ	ETF	356.44	357.42	356.44	357.28	1835336.0
2023-06-12 12:00:00	QQQ	ETF	357.28	357.31	356.82	357.1436	1058778.0
2023-06-12 12:30:00	QQQ	ETF	357.1599	357.5	357.06	357.35	1075995.0

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

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