PREVIEW / etf_30min / 2025-07-29

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-29.parquet
  size:    994 KB
  rows:    41,038

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
2025-07-29 04:00:00	SPY	ETF	638.44	638.61	638.1	638.55	19941.0
2025-07-29 04:30:00	SPY	ETF	638.5	638.52	638.25	638.32	25360.0
2025-07-29 05:00:00	SPY	ETF	638.34	638.65	638.3	638.36	10428.0
2025-07-29 05:30:00	SPY	ETF	638.46	638.74	638.32	638.56	23403.0
2025-07-29 06:00:00	SPY	ETF	638.65	638.75	638.57	638.65	8172.0
2025-07-29 06:30:00	SPY	ETF	638.65	638.8	638.65	638.71	17676.0
2025-07-29 07:00:00	SPY	ETF	638.69	638.89	638.43	638.51	42353.0
2025-07-29 07:30:00	SPY	ETF	638.49	638.6	638.239	638.5	43624.0
2025-07-29 08:00:00	SPY	ETF	638.8	638.8683	637.82	638.3	77475.0
2025-07-29 08:30:00	SPY	ETF	638.28	638.45	637.98	638.12	96556.0
2025-07-29 09:00:00	SPY	ETF	638.11	638.4196	637.99	638.37	131471.0
2025-07-29 09:30:00	SPY	ETF	638.36	638.67	637.24	637.93	4631118.0
2025-07-29 10:00:00	SPY	ETF	638.0	638.09	637.38	637.76	2783243.0
2025-07-29 10:30:00	SPY	ETF	637.75	637.86	636.54	636.74	3095450.0
2025-07-29 11:00:00	SPY	ETF	636.72	637.01	635.18	635.29	3641473.0
2025-07-29 11:30:00	SPY	ETF	635.29	636.21	634.69	635.885	3404862.0
2025-07-29 12:00:00	SPY	ETF	635.88	636.04	635.41	635.66	2133662.0
2025-07-29 12:30:00	SPY	ETF	635.662	636.225	635.1	636.19	1813781.0
2025-07-29 13:00:00	SPY	ETF	636.19	636.56	636.05	636.18	2237177.0
2025-07-29 13:30:00	SPY	ETF	636.175	636.39	634.94	635.61	2721047.0
2025-07-29 14:00:00	SPY	ETF	635.6	635.76	635.135	635.32	2158079.0
2025-07-29 14:30:00	SPY	ETF	635.315	635.86	635.2	635.34	1691789.0
2025-07-29 15:00:00	SPY	ETF	635.32	635.61	635.03	635.06	2652091.0
2025-07-29 15:30:00	SPY	ETF	635.07	635.4	634.335	635.24	7686315.0
2025-07-29 16:00:00	SPY	ETF	635.225	635.35	634.87	635.04	1839883.0
2025-07-29 16:30:00	SPY	ETF	634.98	635.07	634.9	635.01	100484.0
2025-07-29 17:00:00	SPY	ETF	634.99	635.09	634.95	635.08	112862.0
2025-07-29 17:30:00	SPY	ETF	635.01	635.16	634.96	635.06	54335.0
2025-07-29 18:00:00	SPY	ETF	635.13	635.45	635.06	635.2	123450.0
2025-07-29 18:30:00	SPY	ETF	635.27	635.46	635.2	635.43	9155.0
2025-07-29 19:00:00	SPY	ETF	635.4	635.48	635.3601	635.48	5073.0
2025-07-29 19:30:00	SPY	ETF	635.48	635.5702	635.26	635.44	12419.0
2025-07-29 04:00:00	QQQ	ETF	570.59	570.71	570.05	570.61	30657.0
2025-07-29 04:30:00	QQQ	ETF	570.55	570.64	570.41	570.44	19892.0
2025-07-29 05:00:00	QQQ	ETF	570.51	570.68	570.44	570.51	10634.0
2025-07-29 05:30:00	QQQ	ETF	570.53	571.0	570.5	570.84	23290.0
2025-07-29 06:00:00	QQQ	ETF	570.9	571.07	570.75	570.83	12404.0
2025-07-29 06:30:00	QQQ	ETF	570.81	571.02	570.76	570.89	20406.0
2025-07-29 07:00:00	QQQ	ETF	570.91	571.05	570.69	570.8	43630.0
2025-07-29 07:30:00	QQQ	ETF	570.84	570.93	570.41	570.93	30187.0
2025-07-29 08:00:00	QQQ	ETF	570.49	571.2	568.566	570.79	106231.0
2025-07-29 08:30:00	QQQ	ETF	570.76	570.84	570.25	570.42	81936.0
2025-07-29 09:00:00	QQQ	ETF	570.43	570.91	570.3	570.76	123678.0
2025-07-29 09:30:00	QQQ	ETF	570.77	572.11	569.8	570.56	4518370.0
2025-07-29 10:00:00	QQQ	ETF	570.69	570.72	569.41	569.89	2822665.0
2025-07-29 10:30:00	QQQ	ETF	569.88	570.3	568.82	569.135	2068485.0
2025-07-29 11:00:00	QQQ	ETF	569.11	569.47	567.42	567.545	2954499.0
2025-07-29 11:30:00	QQQ	ETF	567.54	568.88	566.92	568.51	3370298.0
2025-07-29 12:00:00	QQQ	ETF	568.48	568.72	567.605	567.86	1367028.0
2025-07-29 12:30:00	QQQ	ETF	567.84	568.59	567.18	568.58	1132975.0

> showing 50 of 41,038 rows — these rows as CSV

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