PREVIEW / etf_30min / 2024-12-20

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-20.parquet
  size:    964 KB
  rows:    39,731

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
2024-12-20 04:00:00	SPY	ETF	581.98	581.98	579.63	579.97	63572.0
2024-12-20 04:30:00	SPY	ETF	580.16	580.41	579.45	579.67	19816.0
2024-12-20 05:00:00	SPY	ETF	579.8	580.08	579.14	579.57	27357.0
2024-12-20 05:30:00	SPY	ETF	579.59	580.3	579.27	579.92	39044.0
2024-12-20 06:00:00	SPY	ETF	579.98	580.47	579.71	579.95	31927.0
2024-12-20 06:30:00	SPY	ETF	579.89	580.09	579.24	579.42	79283.0
2024-12-20 07:00:00	SPY	ETF	579.4	579.55	577.74	578.0	199020.0
2024-12-20 07:30:00	SPY	ETF	577.94	579.68	577.81	579.59	259135.0
2024-12-20 08:00:00	SPY	ETF	579.36	583.82	577.7494	579.84	251239.0
2024-12-20 08:30:00	SPY	ETF	579.92	582.28	579.9	581.33	853427.0
2024-12-20 09:00:00	SPY	ETF	581.26	582.14	580.6	581.79	655790.0
2024-12-20 09:30:00	SPY	ETF	581.77	584.18	580.91	582.06	6157148.0
2024-12-20 10:00:00	SPY	ETF	582.09	587.09	582.08	586.975	4360393.0
2024-12-20 10:30:00	SPY	ETF	586.97	589.28	586.92	588.26	4812614.0
2024-12-20 11:00:00	SPY	ETF	588.29	592.34	588.1	592.3387	4061510.0
2024-12-20 11:30:00	SPY	ETF	592.34	594.9	592.25	594.42	4693855.0
2024-12-20 12:00:00	SPY	ETF	594.41	595.75	593.81	595.61	2517861.0
2024-12-20 12:30:00	SPY	ETF	595.62	595.63	593.86	594.55	2406879.0
2024-12-20 13:00:00	SPY	ETF	594.56	594.6195	592.15	592.1687	2843578.0
2024-12-20 13:30:00	SPY	ETF	592.17	593.4	591.85	592.0699	2809218.0
2024-12-20 14:00:00	SPY	ETF	592.02	593.33	591.62	593.28	2511950.0
2024-12-20 14:30:00	SPY	ETF	593.22	593.94	592.21	592.4999	2449626.0
2024-12-20 15:00:00	SPY	ETF	592.5	592.89	591.56	591.77	2981953.0
2024-12-20 15:30:00	SPY	ETF	591.79	592.38	589.47	590.87	17910033.0
2024-12-20 16:00:00	SPY	ETF	590.91	592.55	589.71	589.75	9814830.0
2024-12-20 16:30:00	SPY	ETF	589.7	590.39	589.5	590.32	412429.0
2024-12-20 17:00:00	SPY	ETF	590.36	590.9	589.92	590.52	194544.0
2024-12-20 17:30:00	SPY	ETF	590.71	591.7	590.45	591.49	154256.0
2024-12-20 18:00:00	SPY	ETF	591.54	592.0	591.15	591.85	37057.0
2024-12-20 18:30:00	SPY	ETF	591.9999	592.17	591.9	592.17	21663.0
2024-12-20 19:00:00	SPY	ETF	592.2	592.3	592.1	592.1	44874.0
2024-12-20 19:30:00	SPY	ETF	592.06	592.18	592.0	592.12	69850.0
2024-12-20 04:00:00	QQQ	ETF	510.97	511.46	508.38	508.4	103619.0
2024-12-20 04:30:00	QQQ	ETF	508.5	508.93	507.79	508.11	117106.0
2024-12-20 05:00:00	QQQ	ETF	508.18	508.74	507.51	508.12	60433.0
2024-12-20 05:30:00	QQQ	ETF	508.28	508.47	507.76	507.78	34432.0
2024-12-20 06:00:00	QQQ	ETF	507.62	508.17	507.3	507.73	91928.0
2024-12-20 06:30:00	QQQ	ETF	507.74	507.96	506.97	507.39	67887.0
2024-12-20 07:00:00	QQQ	ETF	507.34	507.54	505.41	505.87	183335.0
2024-12-20 07:30:00	QQQ	ETF	505.81	507.67	505.46	507.651	201296.0
2024-12-20 08:00:00	QQQ	ETF	507.36	512.5	505.4581	508.17	482715.0
2024-12-20 08:30:00	QQQ	ETF	508.2139	510.95	508.0	510.6	676288.0
2024-12-20 09:00:00	QQQ	ETF	510.5	511.2	509.641	510.64	695678.0
2024-12-20 09:30:00	QQQ	ETF	510.44	512.84	509.29	510.92	3936305.0
2024-12-20 10:00:00	QQQ	ETF	511.0	516.56	510.965	516.47	2474178.0
2024-12-20 10:30:00	QQQ	ETF	516.46	518.7799	516.41	517.8401	2774677.0
2024-12-20 11:00:00	QQQ	ETF	517.88	521.68	517.63	521.47	2015490.0
2024-12-20 11:30:00	QQQ	ETF	521.46	524.28	521.4	523.42	2689379.0
2024-12-20 12:00:00	QQQ	ETF	523.45	524.82	522.88	524.79	1403908.0
2024-12-20 12:30:00	QQQ	ETF	524.79	524.82	522.98	523.54	1305852.0

> showing 50 of 39,731 rows — these rows as CSV

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