PREVIEW / etf_30min / 2023-09-06

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-06.parquet
  size:    692 KB
  rows:    27,656

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-09-06 04:00:00	SPY	ETF	448.09	448.6	447.98	448.12	6839.0
2023-09-06 04:30:00	SPY	ETF	448.12	448.31	448.09	448.31	2615.0
2023-09-06 05:00:00	SPY	ETF	448.52	448.52	448.31	448.31	1918.0
2023-09-06 05:30:00	SPY	ETF	448.43	448.53	448.26	448.53	2447.0
2023-09-06 06:00:00	SPY	ETF	448.43	448.63	448.41	448.43	4073.0
2023-09-06 06:30:00	SPY	ETF	448.52	448.57	448.36	448.36	3589.0
2023-09-06 07:00:00	SPY	ETF	448.37	448.58	448.2	448.53	39536.0
2023-09-06 07:30:00	SPY	ETF	448.52	448.58	448.17	448.33	23715.0
2023-09-06 08:00:00	SPY	ETF	448.26	449.12	447.89	448.22	83106.0
2023-09-06 08:30:00	SPY	ETF	448.26	448.49	447.9	448.42	91494.0
2023-09-06 09:00:00	SPY	ETF	448.44	448.48	448.22	448.37	84748.0
2023-09-06 09:30:00	SPY	ETF	448.4	448.51	447.41	447.9554	4771369.0
2023-09-06 10:00:00	SPY	ETF	447.92	447.92	446.03	446.085	6581734.0
2023-09-06 10:30:00	SPY	ETF	446.095	446.575	445.6	445.6701	4293079.0
2023-09-06 11:00:00	SPY	ETF	445.685	445.99	445.17	445.81	4987380.0
2023-09-06 11:30:00	SPY	ETF	445.815	446.01	445.42	445.55	2856603.0
2023-09-06 12:00:00	SPY	ETF	445.55	445.745	444.84	444.92	2646009.0
2023-09-06 12:30:00	SPY	ETF	444.93	445.0	444.01	444.25	3766450.0
2023-09-06 13:00:00	SPY	ETF	444.25	445.19	443.81	444.8599	3603986.0
2023-09-06 13:30:00	SPY	ETF	444.85	445.57	444.8129	445.31	2819137.0
2023-09-06 14:00:00	SPY	ETF	445.31	445.82	445.16	445.7113	2600957.0
2023-09-06 14:30:00	SPY	ETF	445.71	446.18	445.7	445.945	3335814.0
2023-09-06 15:00:00	SPY	ETF	445.935	446.2	445.33	445.825	3539248.0
2023-09-06 15:30:00	SPY	ETF	445.835	446.4	445.71	446.19	8088709.0
2023-09-06 16:00:00	SPY	ETF	446.19	446.22	444.8119	445.96	2223449.0
2023-09-06 16:30:00	SPY	ETF	445.98	446.08	445.98	446.06	105113.0
2023-09-06 17:00:00	SPY	ETF	446.05	446.22	445.9	446.0	522497.0
2023-09-06 17:30:00	SPY	ETF	446.0	446.03	445.98	446.03	3372.0
2023-09-06 18:00:00	SPY	ETF	446.04	446.13	445.95	445.95	57894.0
2023-09-06 18:30:00	SPY	ETF	445.93	446.009	445.9	445.94	8251.0
2023-09-06 19:00:00	SPY	ETF	446.05	446.1	446.03	446.09	8811.0
2023-09-06 19:30:00	SPY	ETF	446.1	446.18	446.0	446.13	35445.0
2023-09-06 04:00:00	QQQ	ETF	377.0	377.1	376.39	376.66	21370.0
2023-09-06 04:30:00	QQQ	ETF	376.66	376.87	376.51	376.84	14571.0
2023-09-06 05:00:00	QQQ	ETF	376.83	377.02	376.5	376.67	15190.0
2023-09-06 05:30:00	QQQ	ETF	376.64	376.97	376.6	376.97	7129.0
2023-09-06 06:00:00	QQQ	ETF	376.84	377.16	376.84	376.91	9783.0
2023-09-06 06:30:00	QQQ	ETF	377.01	377.14	376.86	377.07	11800.0
2023-09-06 07:00:00	QQQ	ETF	377.06	377.49	376.89	377.37	65303.0
2023-09-06 07:30:00	QQQ	ETF	377.38	377.49	377.03	377.11	44229.0
2023-09-06 08:00:00	QQQ	ETF	377.29	378.353	375.92	377.04	113932.0
2023-09-06 08:30:00	QQQ	ETF	377.04	377.54	376.66	377.2	163392.0
2023-09-06 09:00:00	QQQ	ETF	377.19	377.32	377.0	377.181	113329.0
2023-09-06 09:30:00	QQQ	ETF	377.28	377.63	376.33	376.92	3500063.0
2023-09-06 10:00:00	QQQ	ETF	376.9	376.9	374.51	374.5304	5509130.0
2023-09-06 10:30:00	QQQ	ETF	374.53	375.39	374.245	374.25	2452880.0
2023-09-06 11:00:00	QQQ	ETF	374.26	374.77	373.61	374.6	2747811.0
2023-09-06 11:30:00	QQQ	ETF	374.605	374.83	374.03	374.215	1715937.0
2023-09-06 12:00:00	QQQ	ETF	374.22	374.57	373.27	373.36	1753592.0
2023-09-06 12:30:00	QQQ	ETF	373.37	373.5	372.76	373.095	2445417.0

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

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