PREVIEW / etf_30min / 2025-11-19

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-11-19.parquet
  size:    1.1 MB
  rows:    45,205

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-11-19 04:00:00	SPY	ETF	660.2	661.37	660.0	661.35	78228.0
2025-11-19 04:30:00	SPY	ETF	661.32	662.36	661.14	662.28	24161.0
2025-11-19 05:00:00	SPY	ETF	662.29	662.81	662.0	662.66	18840.0
2025-11-19 05:30:00	SPY	ETF	662.63	662.9	662.29	662.83	18440.0
2025-11-19 06:00:00	SPY	ETF	662.78	663.32	662.72	662.93	21641.0
2025-11-19 06:30:00	SPY	ETF	662.83	664.0	662.57	662.65	44466.0
2025-11-19 07:00:00	SPY	ETF	662.58	662.89	662.2	662.63	73565.0
2025-11-19 07:30:00	SPY	ETF	662.72	663.18	662.7	662.71	50280.0
2025-11-19 08:00:00	SPY	ETF	662.72	663.23	658.01	662.34	207753.0
2025-11-19 08:30:00	SPY	ETF	662.36	662.8	661.66	661.7925	214225.0
2025-11-19 09:00:00	SPY	ETF	661.77	661.92	660.65	660.76	292214.0
2025-11-19 09:30:00	SPY	ETF	660.78	665.84	660.11	665.67	8666733.0
2025-11-19 10:00:00	SPY	ETF	665.67	667.34	665.42	666.25	7313299.0
2025-11-19 10:30:00	SPY	ETF	666.27	666.5545	662.6	662.97	5097343.0
2025-11-19 11:00:00	SPY	ETF	662.9604	663.53	661.28	662.01	5906168.0
2025-11-19 11:30:00	SPY	ETF	662.02	662.5897	660.78	662.515	4146625.0
2025-11-19 12:00:00	SPY	ETF	662.5	662.98	660.23	661.17	4092255.0
2025-11-19 12:30:00	SPY	ETF	661.18	661.93	658.745	661.36	5665430.0
2025-11-19 13:00:00	SPY	ETF	661.34	662.62	660.94	661.0201	4076978.0
2025-11-19 13:30:00	SPY	ETF	661.01	663.33	660.76	662.5292	4415537.0
2025-11-19 14:00:00	SPY	ETF	662.55	662.79	659.48	659.8	4309209.0
2025-11-19 14:30:00	SPY	ETF	659.79	662.01	659.33	661.25	3837818.0
2025-11-19 15:00:00	SPY	ETF	661.25	664.4	661.0	663.5	4847587.0
2025-11-19 15:30:00	SPY	ETF	663.5	664.76	661.74	662.65	8539208.0
2025-11-19 16:00:00	SPY	ETF	662.65	666.0	661.54	664.63	4156643.0
2025-11-19 16:30:00	SPY	ETF	664.67	666.8	664.67	666.07	726994.0
2025-11-19 17:00:00	SPY	ETF	666.0	666.75	665.84	666.05	288401.0
2025-11-19 17:30:00	SPY	ETF	666.03	666.03	665.27	665.9	71875.0
2025-11-19 18:00:00	SPY	ETF	665.89	668.72	662.62	668.36	412424.0
2025-11-19 18:30:00	SPY	ETF	668.39	669.52	668.22	669.52	94734.0
2025-11-19 19:00:00	SPY	ETF	669.53	670.42	669.05	670.29	125084.0
2025-11-19 19:30:00	SPY	ETF	670.3	670.67	669.92	670.0475	160497.0
2025-11-19 04:00:00	QQQ	ETF	595.72	597.68	595.72	597.52	65691.0
2025-11-19 04:30:00	QQQ	ETF	597.49	598.77	597.2	598.61	68914.0
2025-11-19 05:00:00	QQQ	ETF	598.67	599.37	598.36	599.17	65528.0
2025-11-19 05:30:00	QQQ	ETF	599.17	599.43	598.66	599.25	71855.0
2025-11-19 06:00:00	QQQ	ETF	599.21	600.0	599.11	599.41	55073.0
2025-11-19 06:30:00	QQQ	ETF	599.4	599.89	598.96	599.07	64702.0
2025-11-19 07:00:00	QQQ	ETF	599.03	599.44	598.58	599.2	155009.0
2025-11-19 07:30:00	QQQ	ETF	599.26	599.74	599.1	599.14	110509.0
2025-11-19 08:00:00	QQQ	ETF	599.12	599.86	593.05	598.9	499199.0
2025-11-19 08:30:00	QQQ	ETF	598.87	599.4	598.16	598.36	242652.0
2025-11-19 09:00:00	QQQ	ETF	598.29	598.66	596.97	597.04	386969.0
2025-11-19 09:30:00	QQQ	ETF	597.07	604.08	596.14	603.9	6651276.0
2025-11-19 10:00:00	QQQ	ETF	603.89	606.16	603.57	605.3599	7190004.0
2025-11-19 10:30:00	QQQ	ETF	605.36	605.72	600.38	600.915	5070131.0
2025-11-19 11:00:00	QQQ	ETF	600.905	601.31	598.27	599.41	5274248.0
2025-11-19 11:30:00	QQQ	ETF	599.41	599.81	597.99	599.6	2968904.0
2025-11-19 12:00:00	QQQ	ETF	599.6	599.74	596.35	597.57	3216649.0
2025-11-19 12:30:00	QQQ	ETF	597.53	598.19	594.59	597.64	3575964.0

> showing 50 of 45,205 rows — these rows as CSV

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