PREVIEW / etf_30min / 2025-06-27

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-27.parquet
  size:    991 KB
  rows:    40,865

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-06-27 04:00:00	SPY	ETF	613.64	613.79	613.39	613.42	50402.0
2025-06-27 04:30:00	SPY	ETF	613.5	613.76	613.43	613.76	10075.0
2025-06-27 05:00:00	SPY	ETF	613.75	613.75	613.37	613.59	29040.0
2025-06-27 05:30:00	SPY	ETF	613.61	613.66	613.37	613.53	29085.0
2025-06-27 06:00:00	SPY	ETF	613.67	613.67	613.35	613.35	47286.0
2025-06-27 06:30:00	SPY	ETF	613.44	613.55	613.4	613.51	7627.0
2025-06-27 07:00:00	SPY	ETF	613.52	614.01	613.47	613.9	85717.0
2025-06-27 07:30:00	SPY	ETF	613.87	614.39	613.87	614.34	77939.0
2025-06-27 08:00:00	SPY	ETF	613.83	614.55	612.6	614.1	193344.0
2025-06-27 08:30:00	SPY	ETF	613.99	614.11	613.35	613.44	521964.0
2025-06-27 09:00:00	SPY	ETF	613.43	613.49	612.89	612.9	322249.0
2025-06-27 09:30:00	SPY	ETF	612.88	614.6599	612.7	614.36	4874866.0
2025-06-27 10:00:00	SPY	ETF	614.37	615.5	614.37	614.905	4350195.0
2025-06-27 10:30:00	SPY	ETF	614.91	615.55	614.6	614.81	2812118.0
2025-06-27 11:00:00	SPY	ETF	614.82	615.39	614.6	615.34	1927860.0
2025-06-27 11:30:00	SPY	ETF	615.34	616.1	615.3001	615.902	2448253.0
2025-06-27 12:00:00	SPY	ETF	615.9	616.35	615.69	616.315	2053787.0
2025-06-27 12:30:00	SPY	ETF	616.315	616.39	615.645	615.97	2113127.0
2025-06-27 13:00:00	SPY	ETF	615.955	615.96	615.26	615.39	1484025.0
2025-06-27 13:30:00	SPY	ETF	615.4	615.58	613.27	614.155	5144306.0
2025-06-27 14:00:00	SPY	ETF	614.16	614.38	612.33	612.33	4064841.0
2025-06-27 14:30:00	SPY	ETF	612.34	612.6	610.83	611.19	7479617.0
2025-06-27 15:00:00	SPY	ETF	611.185	612.71	611.01	612.385	5436058.0
2025-06-27 15:30:00	SPY	ETF	612.38	615.14	612.38	614.86	12959442.0
2025-06-27 16:00:00	SPY	ETF	614.86	614.91	614.19	614.28	3173119.0
2025-06-27 16:30:00	SPY	ETF	614.28	614.68	614.28	614.61	172275.0
2025-06-27 17:00:00	SPY	ETF	614.62	614.62	614.3	614.4	55229.0
2025-06-27 17:30:00	SPY	ETF	614.38	614.38	614.12	614.25	36825.0
2025-06-27 18:00:00	SPY	ETF	614.23	614.3928	614.1	614.1	19537.0
2025-06-27 18:30:00	SPY	ETF	614.1	614.1	613.18	613.2	146575.0
2025-06-27 19:00:00	SPY	ETF	613.2	613.549	612.86	613.33	55400.0
2025-06-27 19:30:00	SPY	ETF	613.27	613.64	613.18	613.43	34133.0
2025-06-27 04:00:00	QQQ	ETF	547.67	548.24	547.67	547.94	22941.0
2025-06-27 04:30:00	QQQ	ETF	547.93	548.33	547.9	548.33	10403.0
2025-06-27 05:00:00	QQQ	ETF	548.31	548.31	547.84	548.01	15433.0
2025-06-27 05:30:00	QQQ	ETF	548.04	548.2	547.92	548.19	19729.0
2025-06-27 06:00:00	QQQ	ETF	548.26	548.27	547.79	547.88	12331.0
2025-06-27 06:30:00	QQQ	ETF	547.92	547.98	547.83	547.95	29913.0
2025-06-27 07:00:00	QQQ	ETF	547.9	548.66	547.87	548.6	74144.0
2025-06-27 07:30:00	QQQ	ETF	548.55	549.0	548.55	549.0	43050.0
2025-06-27 08:00:00	QQQ	ETF	548.14	549.19	546.84	548.85	187165.0
2025-06-27 08:30:00	QQQ	ETF	548.7	548.73	547.64	547.84	224391.0
2025-06-27 09:00:00	QQQ	ETF	547.815	547.88	547.15	547.21	190209.0
2025-06-27 09:30:00	QQQ	ETF	547.26	548.72	546.74	548.598	3378853.0
2025-06-27 10:00:00	QQQ	ETF	548.6	549.99	548.6	549.0252	3499658.0
2025-06-27 10:30:00	QQQ	ETF	549.02	549.76	548.2	548.4512	2083210.0
2025-06-27 11:00:00	QQQ	ETF	548.46	549.26	548.1403	549.26	1467302.0
2025-06-27 11:30:00	QQQ	ETF	549.26	549.93	549.19	549.655	1398227.0
2025-06-27 12:00:00	QQQ	ETF	549.66	549.66	548.92	549.36	1608860.0
2025-06-27 12:30:00	QQQ	ETF	549.37	549.4293	548.69	549.3	1590671.0

> showing 50 of 40,865 rows — these rows as CSV

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