PREVIEW / etf_30min / 2025-01-16

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-16.parquet
  size:    936 KB
  rows:    37,398

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-01-16 04:00:00	SPY	ETF	594.75	594.75	594.37	594.38	7798.0
2025-01-16 04:30:00	SPY	ETF	594.23	594.32	593.71	594.32	16455.0
2025-01-16 05:00:00	SPY	ETF	593.8	594.82	593.62	594.8	21187.0
2025-01-16 05:30:00	SPY	ETF	594.8	594.89	594.7	594.7	6167.0
2025-01-16 06:00:00	SPY	ETF	594.6	594.72	594.32	594.51	3713.0
2025-01-16 06:30:00	SPY	ETF	594.49	594.8	594.19	594.68	21481.0
2025-01-16 07:00:00	SPY	ETF	594.65	594.66	593.44	593.62	258165.0
2025-01-16 07:30:00	SPY	ETF	593.59	593.8	592.87	593.01	106200.0
2025-01-16 08:00:00	SPY	ETF	594.33	595.56	592.55	593.22	187332.0
2025-01-16 08:30:00	SPY	ETF	593.31	593.75	592.72	593.59	218098.0
2025-01-16 09:00:00	SPY	ETF	593.59	594.34	593.3	594.17	193744.0
2025-01-16 09:30:00	SPY	ETF	594.18	594.3	592.065	592.185	3085330.0
2025-01-16 10:00:00	SPY	ETF	592.18	593.21	591.32	592.2828	1897672.0
2025-01-16 10:30:00	SPY	ETF	592.27	593.46	591.78	593.46	1122798.0
2025-01-16 11:00:00	SPY	ETF	593.44	594.35	592.54	593.3601	1998218.0
2025-01-16 11:30:00	SPY	ETF	593.34	593.57	591.82	593.5055	1209353.0
2025-01-16 12:00:00	SPY	ETF	593.495	593.81	592.785	593.78	851705.0
2025-01-16 12:30:00	SPY	ETF	593.78	593.8	592.8101	592.9799	645617.0
2025-01-16 13:00:00	SPY	ETF	592.97	593.54	592.11	592.26	820602.0
2025-01-16 13:30:00	SPY	ETF	592.26	592.4	590.93	591.4	1787083.0
2025-01-16 14:00:00	SPY	ETF	591.38	592.6126	591.075	592.465	1071326.0
2025-01-16 14:30:00	SPY	ETF	592.47	593.08	592.185	592.93	1119886.0
2025-01-16 15:00:00	SPY	ETF	592.93	593.33	591.94	592.29	1519504.0
2025-01-16 15:30:00	SPY	ETF	592.29	593.2	591.48	591.7	3611757.0
2025-01-16 16:00:00	SPY	ETF	591.71	591.9	590.35	590.67	2583320.0
2025-01-16 16:30:00	SPY	ETF	590.77	591.02	590.77	591.0	127674.0
2025-01-16 17:00:00	SPY	ETF	591.03	591.04	590.94	590.95	17845.0
2025-01-16 17:30:00	SPY	ETF	590.97	591.0	590.95	591.0	20045.0
2025-01-16 18:00:00	SPY	ETF	591.0	591.37	590.86	591.23	39901.0
2025-01-16 18:30:00	SPY	ETF	591.28	591.44	591.28	591.44	20411.0
2025-01-16 19:00:00	SPY	ETF	591.48	591.55	591.31	591.45	9314.0
2025-01-16 19:30:00	SPY	ETF	591.55	591.6	591.41	591.51	6835.0
2025-01-16 04:00:00	QQQ	ETF	519.52	520.25	518.52	518.94	60439.0
2025-01-16 04:30:00	QQQ	ETF	518.98	518.98	518.06	518.53	23459.0
2025-01-16 05:00:00	QQQ	ETF	518.31	519.07	517.81	519.0	11594.0
2025-01-16 05:30:00	QQQ	ETF	519.12	519.32	518.96	519.03	22645.0
2025-01-16 06:00:00	QQQ	ETF	519.1	519.24	518.73	519.12	17204.0
2025-01-16 06:30:00	QQQ	ETF	519.14	519.51	518.8	519.37	17813.0
2025-01-16 07:00:00	QQQ	ETF	519.23	519.29	517.99	518.24	44944.0
2025-01-16 07:30:00	QQQ	ETF	518.2	518.59	517.46	517.55	88385.0
2025-01-16 08:00:00	QQQ	ETF	518.72	520.31	515.62	517.52	205410.0
2025-01-16 08:30:00	QQQ	ETF	517.83	518.71	517.4	518.5	152880.0
2025-01-16 09:00:00	QQQ	ETF	518.47	519.09	518.0305	518.99	181680.0
2025-01-16 09:30:00	QQQ	ETF	519.0	519.0599	515.99	516.1538	2471064.0
2025-01-16 10:00:00	QQQ	ETF	516.1101	517.34	515.2	516.16	1823069.0
2025-01-16 10:30:00	QQQ	ETF	516.18	517.38	515.31	517.32	1242036.0
2025-01-16 11:00:00	QQQ	ETF	517.31	518.52	516.43	516.98	1403834.0
2025-01-16 11:30:00	QQQ	ETF	516.96	517.31	514.76	516.76	1343518.0
2025-01-16 12:00:00	QQQ	ETF	516.76	517.37	516.03	517.275	845241.0
2025-01-16 12:30:00	QQQ	ETF	517.29	517.32	516.1904	516.45	487993.0

> showing 50 of 37,398 rows — these rows as CSV

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