PREVIEW / etf_30min / 2025-01-22

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-22.parquet
  size:    968 KB
  rows:    39,315

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-22 04:00:00	SPY	ETF	604.71	605.66	604.71	605.66	9649.0
2025-01-22 04:30:00	SPY	ETF	605.75	605.77	605.33	605.33	4737.0
2025-01-22 05:00:00	SPY	ETF	605.3	605.42	605.09	605.16	55068.0
2025-01-22 05:30:00	SPY	ETF	605.35	605.53	605.31	605.47	5238.0
2025-01-22 06:00:00	SPY	ETF	605.38	605.83	605.38	605.53	32331.0
2025-01-22 06:30:00	SPY	ETF	605.4	605.43	605.16	605.27	18892.0
2025-01-22 07:00:00	SPY	ETF	605.31	605.79	605.23	605.57	164713.0
2025-01-22 07:30:00	SPY	ETF	605.63	605.94	605.44	605.6	73717.0
2025-01-22 08:00:00	SPY	ETF	605.35	606.08	604.12	606.05	119529.0
2025-01-22 08:30:00	SPY	ETF	606.0699	606.18	605.9	606.15	78891.0
2025-01-22 09:00:00	SPY	ETF	606.17	606.19	605.66	605.92	312240.0
2025-01-22 09:30:00	SPY	ETF	605.92	606.57	605.36	606.4906	3530233.0
2025-01-22 10:00:00	SPY	ETF	606.5	607.04	606.0	606.7	2191327.0
2025-01-22 10:30:00	SPY	ETF	606.72	607.08	606.48	606.5512	1465013.0
2025-01-22 11:00:00	SPY	ETF	606.55	607.24	606.26	607.2375	1245269.0
2025-01-22 11:30:00	SPY	ETF	607.232	607.78	607.195	607.65	1232275.0
2025-01-22 12:00:00	SPY	ETF	607.65	607.82	607.3	607.55	1134156.0
2025-01-22 12:30:00	SPY	ETF	607.56	607.7	607.3	607.31	795595.0
2025-01-22 13:00:00	SPY	ETF	607.3	607.42	606.9412	607.0663	919630.0
2025-01-22 13:30:00	SPY	ETF	607.08	607.6267	607.01	607.04	626443.0
2025-01-22 14:00:00	SPY	ETF	607.04	607.35	606.83	606.905	1108738.0
2025-01-22 14:30:00	SPY	ETF	606.91	607.62	606.7801	607.6	1055514.0
2025-01-22 15:00:00	SPY	ETF	607.59	607.62	607.08	607.12	1429985.0
2025-01-22 15:30:00	SPY	ETF	607.12	607.35	606.23	606.34	5876814.0
2025-01-22 16:00:00	SPY	ETF	606.34	606.883	605.86	605.9599	3300597.0
2025-01-22 16:30:00	SPY	ETF	605.94	606.3003	605.89	606.3003	176104.0
2025-01-22 17:00:00	SPY	ETF	606.3	606.33	606.2	606.2	41147.0
2025-01-22 17:30:00	SPY	ETF	606.2	606.34	606.17	606.27	13935.0
2025-01-22 18:00:00	SPY	ETF	606.23	606.3	605.86	606.001	50258.0
2025-01-22 18:30:00	SPY	ETF	605.96	606.03	605.87	605.9499	9260.0
2025-01-22 19:00:00	SPY	ETF	605.85	606.08	605.73	605.7703	14066.0
2025-01-22 19:30:00	SPY	ETF	605.791	605.9493	605.72	605.87	17010.0
2025-01-22 04:00:00	QQQ	ETF	528.96	529.12	528.15	529.09	33982.0
2025-01-22 04:30:00	QQQ	ETF	529.17	529.37	528.74	528.81	29544.0
2025-01-22 05:00:00	QQQ	ETF	528.77	528.85	528.49	528.85	48883.0
2025-01-22 05:30:00	QQQ	ETF	528.85	529.04	528.81	529.0	10858.0
2025-01-22 06:00:00	QQQ	ETF	528.89	529.3	528.84	529.04	17507.0
2025-01-22 06:30:00	QQQ	ETF	529.0	529.14	528.8	528.86	28298.0
2025-01-22 07:00:00	QQQ	ETF	528.84	529.46	528.74	529.18	61519.0
2025-01-22 07:30:00	QQQ	ETF	529.16	529.65	529.14	529.45	84548.0
2025-01-22 08:00:00	QQQ	ETF	529.46	529.74	527.72	529.7	188522.0
2025-01-22 08:30:00	QQQ	ETF	529.65	529.98	529.52	529.89	103823.0
2025-01-22 09:00:00	QQQ	ETF	529.92	529.98	529.19	529.54	548780.0
2025-01-22 09:30:00	QQQ	ETF	529.57	532.215	529.26	531.89	5656509.0
2025-01-22 10:00:00	QQQ	ETF	531.92	532.44	530.97	531.85	1788574.0
2025-01-22 10:30:00	QQQ	ETF	531.87	532.59	531.42	531.45	1277933.0
2025-01-22 11:00:00	QQQ	ETF	531.4406	532.845	531.33	532.8	1454579.0
2025-01-22 11:30:00	QQQ	ETF	532.8	533.46	532.66	533.36	1248221.0
2025-01-22 12:00:00	QQQ	ETF	533.36	533.82	533.05	533.21	1153746.0
2025-01-22 12:30:00	QQQ	ETF	533.2	533.36	532.72	532.96	917414.0

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

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