PREVIEW / etf_30min / 2025-01-13

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-13.parquet
  size:    960 KB
  rows:    39,061

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-13 04:00:00	SPY	ETF	578.23	578.23	575.09	575.25	28953.0
2025-01-13 04:30:00	SPY	ETF	575.07	575.73	575.04	575.25	19908.0
2025-01-13 05:00:00	SPY	ETF	575.33	575.64	575.2	575.64	9121.0
2025-01-13 05:30:00	SPY	ETF	575.76	576.16	575.53	575.7	2484.0
2025-01-13 06:00:00	SPY	ETF	575.5	576.23	575.5	575.92	16768.0
2025-01-13 06:30:00	SPY	ETF	575.76	576.2	575.76	575.97	8877.0
2025-01-13 07:00:00	SPY	ETF	576.02	576.67	575.3	576.2	126882.0
2025-01-13 07:30:00	SPY	ETF	576.3	577.48	576.12	576.94	173892.0
2025-01-13 08:00:00	SPY	ETF	575.8	578.77	575.3196	576.71	166363.0
2025-01-13 08:30:00	SPY	ETF	576.78	577.49	576.58	576.7809	117897.0
2025-01-13 09:00:00	SPY	ETF	576.78	576.86	575.68	575.77	416545.0
2025-01-13 09:30:00	SPY	ETF	575.77	578.32	575.35	577.87	4527488.0
2025-01-13 10:00:00	SPY	ETF	577.88	578.62	575.94	576.02	2493574.0
2025-01-13 10:30:00	SPY	ETF	576.073	579.18	576.03	577.9	2012537.0
2025-01-13 11:00:00	SPY	ETF	577.9	578.14	576.77	576.99	1701993.0
2025-01-13 11:30:00	SPY	ETF	576.97	578.21	575.88	576.0	1693176.0
2025-01-13 12:00:00	SPY	ETF	576.02	578.53	575.68	578.23	1580680.0
2025-01-13 12:30:00	SPY	ETF	578.2	579.55	577.6	579.46	1292013.0
2025-01-13 13:00:00	SPY	ETF	579.46	579.75	578.88	579.72	1174755.0
2025-01-13 13:30:00	SPY	ETF	579.69	580.285	579.37	580.01	1599810.0
2025-01-13 14:00:00	SPY	ETF	580.01	580.36	578.97	580.31	1357208.0
2025-01-13 14:30:00	SPY	ETF	580.29	581.0	579.57	580.4816	1885897.0
2025-01-13 15:00:00	SPY	ETF	580.47	580.97	579.89	580.1	1724228.0
2025-01-13 15:30:00	SPY	ETF	580.1	581.75	579.87	581.54	4833971.0
2025-01-13 16:00:00	SPY	ETF	581.53	582.25	581.17	582.16	4399388.0
2025-01-13 16:30:00	SPY	ETF	582.17	582.25	581.89	582.15	144907.0
2025-01-13 17:00:00	SPY	ETF	582.14	582.15	582.07	582.15	36934.0
2025-01-13 17:30:00	SPY	ETF	582.16	582.5	582.13	582.3798	59617.0
2025-01-13 18:00:00	SPY	ETF	582.59	583.24	582.59	582.99	73390.0
2025-01-13 18:30:00	SPY	ETF	583.0	583.93	583.0	583.21	124643.0
2025-01-13 19:00:00	SPY	ETF	583.2	583.2	582.76	582.83	16527.0
2025-01-13 19:30:00	SPY	ETF	582.96	583.2	582.8	583.2	27780.0
2025-01-13 04:00:00	QQQ	ETF	504.28	504.28	499.61	500.04	128649.0
2025-01-13 04:30:00	QQQ	ETF	499.86	500.62	499.86	500.29	64936.0
2025-01-13 05:00:00	QQQ	ETF	500.22	500.75	499.92	500.64	44585.0
2025-01-13 05:30:00	QQQ	ETF	500.61	501.45	500.61	500.75	42397.0
2025-01-13 06:00:00	QQQ	ETF	500.87	501.43	500.53	501.19	46045.0
2025-01-13 06:30:00	QQQ	ETF	501.06	501.47	500.8	501.2	53544.0
2025-01-13 07:00:00	QQQ	ETF	501.24	502.17	500.3	501.63	193920.0
2025-01-13 07:30:00	QQQ	ETF	501.63	503.17	501.38	502.6	140426.0
2025-01-13 08:00:00	QQQ	ETF	501.75	504.95	499.881	502.29	284548.0
2025-01-13 08:30:00	QQQ	ETF	502.43	503.07	502.12	502.23	121979.0
2025-01-13 09:00:00	QQQ	ETF	502.44	502.44	501.06	501.2	313716.0
2025-01-13 09:30:00	QQQ	ETF	501.2	503.07	499.7	502.145	3958166.0
2025-01-13 10:00:00	QQQ	ETF	502.14	503.42	500.02	500.095	1731516.0
2025-01-13 10:30:00	QQQ	ETF	500.11	503.988	500.0801	502.05	1760964.0
2025-01-13 11:00:00	QQQ	ETF	502.06	502.45	500.75	501.0	1104587.0
2025-01-13 11:30:00	QQQ	ETF	500.98	502.69	500.31	500.53	1123559.0
2025-01-13 12:00:00	QQQ	ETF	500.52	503.52	500.06	503.17	1558414.0
2025-01-13 12:30:00	QQQ	ETF	503.16	504.3	502.46	504.18	1275038.0

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

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