PREVIEW / etf_30min / 2026-06-09

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-06-09.parquet
  size:    1.1 MB
  rows:    47,018

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
2026-06-09 04:00:00	SPY	ETF	741.12	742.42	740.7	742.1	74770.0
2026-06-09 04:30:00	SPY	ETF	742.25	742.62	741.9093	742.05	20993.0
2026-06-09 05:00:00	SPY	ETF	741.94	742.82	741.94	742.77	10345.0
2026-06-09 05:30:00	SPY	ETF	742.47	742.875	742.3	742.72	4107.0
2026-06-09 06:00:00	SPY	ETF	742.75	742.99	741.21	742.73	76798.0
2026-06-09 06:30:00	SPY	ETF	742.72	743.39	742.33	742.95	34570.0
2026-06-09 07:00:00	SPY	ETF	742.86	743.19	742.25	742.43	79814.0
2026-06-09 07:30:00	SPY	ETF	742.43	742.85	742.11	742.149	53603.0
2026-06-09 08:00:00	SPY	ETF	742.22	742.56	741.96	742.15	67219.0
2026-06-09 08:30:00	SPY	ETF	742.19	743.41	742.19	743.33	106974.0
2026-06-09 09:00:00	SPY	ETF	743.37	743.68	742.72	743.67	164470.0
2026-06-09 09:30:00	SPY	ETF	743.63	746.9	743.28	744.38	4472273.0
2026-06-09 10:00:00	SPY	ETF	744.3638	745.045	739.42	741.21	4868265.0
2026-06-09 10:30:00	SPY	ETF	741.17	741.71	734.65	737.75	5758711.0
2026-06-09 11:00:00	SPY	ETF	737.79	738.42	730.77	731.0	3385170.0
2026-06-09 11:30:00	SPY	ETF	731.0	732.75	728.96	729.06	5569601.0
2026-06-09 12:00:00	SPY	ETF	729.08	730.57	725.3	727.36	5992225.0
2026-06-09 12:30:00	SPY	ETF	727.34	728.57	722.59	726.62	7962359.0
2026-06-09 13:00:00	SPY	ETF	726.62	731.28	726.4	730.76	4461207.0
2026-06-09 13:30:00	SPY	ETF	730.78	733.95	730.21	732.56	4044110.0
2026-06-09 14:00:00	SPY	ETF	732.65	735.18	732.14	735.1	3034968.0
2026-06-09 14:30:00	SPY	ETF	735.12	737.13	734.3	736.74	3066987.0
2026-06-09 15:00:00	SPY	ETF	736.74	737.69	733.2	734.6	3468240.0
2026-06-09 15:30:00	SPY	ETF	734.58	737.47	732.53	737.05	8279389.0
2026-06-09 16:00:00	SPY	ETF	737.07	737.729	736.1304	736.77	2706581.0
2026-06-09 16:30:00	SPY	ETF	736.77	737.14	736.4	736.7	187332.0
2026-06-09 17:00:00	SPY	ETF	736.75	736.75	735.25	735.44	94777.0
2026-06-09 17:30:00	SPY	ETF	735.44	735.93	735.2	735.5	109999.0
2026-06-09 18:00:00	SPY	ETF	735.64	736.49	735.31	735.61	145723.0
2026-06-09 18:30:00	SPY	ETF	735.5904	735.5904	734.26	734.8	76913.0
2026-06-09 19:00:00	SPY	ETF	734.85	735.7	734.5013	734.6	34794.0
2026-06-09 19:30:00	SPY	ETF	734.49	735.75	734.33	735.7	27965.0
2026-06-09 04:00:00	QQQ	ETF	719.4	721.85	718.98	721.27	188889.0
2026-06-09 04:30:00	QQQ	ETF	721.25	721.82	720.68	720.74	51895.0
2026-06-09 05:00:00	QQQ	ETF	720.77	722.0	720.67	721.92	44812.0
2026-06-09 05:30:00	QQQ	ETF	721.8	722.05	721.1574	721.93	29020.0
2026-06-09 06:00:00	QQQ	ETF	721.8	722.11	720.23	721.57	85564.0
2026-06-09 06:30:00	QQQ	ETF	721.56	722.15	720.9	721.81	49623.0
2026-06-09 07:00:00	QQQ	ETF	721.75	722.24	721.43	721.89	97172.0
2026-06-09 07:30:00	QQQ	ETF	721.86	722.77	721.61	721.6999	147036.0
2026-06-09 08:00:00	QQQ	ETF	721.75	722.1165	715.533	721.44	155055.0
2026-06-09 08:30:00	QQQ	ETF	721.43	723.01	721.36	722.92	251172.0
2026-06-09 09:00:00	QQQ	ETF	722.97	723.21	721.95	722.98	270134.0
2026-06-09 09:30:00	QQQ	ETF	722.98	725.66	720.49	721.505	4827912.0
2026-06-09 10:00:00	QQQ	ETF	721.47	722.4	714.01	715.95	5713051.0
2026-06-09 10:30:00	QQQ	ETF	715.95	716.97	707.16	710.9401	5480930.0
2026-06-09 11:00:00	QQQ	ETF	710.99	712.43	701.5	701.73	4527984.0
2026-06-09 11:30:00	QQQ	ETF	701.76	704.405	697.4	697.71	6769407.0
2026-06-09 12:00:00	QQQ	ETF	697.75	699.94	690.0	693.575	7610611.0
2026-06-09 12:30:00	QQQ	ETF	693.54	694.7199	686.37	692.565	8304399.0

> showing 50 of 47,018 rows — these rows as CSV

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