PREVIEW / etf_30min / 2025-03-07

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-07.parquet
  size:    971 KB
  rows:    39,917

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-03-07 04:00:00	SPY	ETF	574.34	575.54	574.17	575.02	11905.0
2025-03-07 04:30:00	SPY	ETF	575.19	575.4	574.85	575.22	5603.0
2025-03-07 05:00:00	SPY	ETF	574.94	574.94	574.0	574.61	19160.0
2025-03-07 05:30:00	SPY	ETF	574.57	574.92	574.44	574.54	8780.0
2025-03-07 06:00:00	SPY	ETF	574.49	574.74	574.43	574.7	21898.0
2025-03-07 06:30:00	SPY	ETF	574.77	575.12	574.57	574.75	8716.0
2025-03-07 07:00:00	SPY	ETF	574.74	574.74	573.6	573.6	111213.0
2025-03-07 07:30:00	SPY	ETF	573.54	573.9	572.87	573.43	143180.0
2025-03-07 08:00:00	SPY	ETF	574.5	574.89	572.51	573.2	291846.0
2025-03-07 08:30:00	SPY	ETF	572.12	578.22	571.25	571.7494	1739451.0
2025-03-07 09:00:00	SPY	ETF	571.73	572.68	570.4	570.86	576398.0
2025-03-07 09:30:00	SPY	ETF	570.9	576.0678	570.8	573.95	5019944.0
2025-03-07 10:00:00	SPY	ETF	573.95	575.069	571.77	572.36	3142713.0
2025-03-07 10:30:00	SPY	ETF	572.35	573.0	568.4281	570.91	6315174.0
2025-03-07 11:00:00	SPY	ETF	570.92	571.26	567.37	567.63	2633561.0
2025-03-07 11:30:00	SPY	ETF	567.67	568.035	565.63	567.1	4188917.0
2025-03-07 12:00:00	SPY	ETF	567.12	568.6695	565.8	568.08	3693433.0
2025-03-07 12:30:00	SPY	ETF	568.06	573.08	567.44	570.185	5315573.0
2025-03-07 13:00:00	SPY	ETF	570.19	574.29	570.13	572.6269	3421597.0
2025-03-07 13:30:00	SPY	ETF	572.66	575.3	572.29	575.24	2435989.0
2025-03-07 14:00:00	SPY	ETF	575.27	577.31	574.13	576.575	3765632.0
2025-03-07 14:30:00	SPY	ETF	576.66	577.14	574.66	575.1735	2714828.0
2025-03-07 15:00:00	SPY	ETF	575.16	576.72	574.62	575.9796	2760843.0
2025-03-07 15:30:00	SPY	ETF	575.94	577.39	572.81	575.85	6793218.0
2025-03-07 16:00:00	SPY	ETF	575.85	575.99	574.36	575.58	3474910.0
2025-03-07 16:30:00	SPY	ETF	575.58	575.8264	575.4	575.41	188675.0
2025-03-07 17:00:00	SPY	ETF	575.59	575.75	575.37	575.37	151674.0
2025-03-07 17:30:00	SPY	ETF	575.36	575.5	574.82	574.95	56804.0
2025-03-07 18:00:00	SPY	ETF	575.02	575.02	574.7513	574.82	52812.0
2025-03-07 18:30:00	SPY	ETF	574.81	574.92	574.75	574.8493	31146.0
2025-03-07 19:00:00	SPY	ETF	574.85	574.85	574.35	574.69	33548.0
2025-03-07 19:30:00	SPY	ETF	574.73	574.8	574.65	574.71	11264.0
2025-03-07 04:00:00	QQQ	ETF	490.43	491.79	490.2	491.3	56457.0
2025-03-07 04:30:00	QQQ	ETF	491.2	491.47	490.8	491.09	15577.0
2025-03-07 05:00:00	QQQ	ETF	491.13	491.13	490.16	490.72	16887.0
2025-03-07 05:30:00	QQQ	ETF	490.7	490.99	490.37	490.6	15451.0
2025-03-07 06:00:00	QQQ	ETF	490.43	490.81	490.0	490.78	71427.0
2025-03-07 06:30:00	QQQ	ETF	490.73	491.29	490.41	490.75	41514.0
2025-03-07 07:00:00	QQQ	ETF	490.72	490.72	489.38	489.39	75337.0
2025-03-07 07:30:00	QQQ	ETF	489.35	489.8	488.61	489.32	220649.0
2025-03-07 08:00:00	QQQ	ETF	489.32	491.4296	488.33	489.4	377233.0
2025-03-07 08:30:00	QQQ	ETF	488.65	492.89	487.26	487.92	746189.0
2025-03-07 09:00:00	QQQ	ETF	487.92	489.02	486.94	487.18	632678.0
2025-03-07 09:30:00	QQQ	ETF	487.16	492.18	486.92	489.75	4492476.0
2025-03-07 10:00:00	QQQ	ETF	489.7	490.98	487.355	487.735	2520821.0
2025-03-07 10:30:00	QQQ	ETF	487.69	488.41	483.57	486.75	4218008.0
2025-03-07 11:00:00	QQQ	ETF	486.77	487.11	482.82	483.15	2169291.0
2025-03-07 11:30:00	QQQ	ETF	483.18	483.48	480.53	482.1625	3720225.0
2025-03-07 12:00:00	QQQ	ETF	482.19	483.75	480.73	483.28	2405313.0
2025-03-07 12:30:00	QQQ	ETF	483.2233	488.3224	482.57	484.93	3024459.0

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

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