PREVIEW / etf_30min / 2024-08-20

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-20.parquet
  size:    826 KB
  rows:    32,724

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
2024-08-20 04:00:00	SPY	ETF	560.0	560.43	559.92	559.92	56796.0
2024-08-20 04:30:00	SPY	ETF	559.91	559.91	559.31	559.77	9832.0
2024-08-20 05:00:00	SPY	ETF	559.89	560.2	559.89	560.2	10713.0
2024-08-20 05:30:00	SPY	ETF	560.06	560.14	559.71	559.71	5714.0
2024-08-20 06:00:00	SPY	ETF	559.68	560.0	559.65	559.92	4004.0
2024-08-20 06:30:00	SPY	ETF	560.03	560.11	559.91	560.05	4973.0
2024-08-20 07:00:00	SPY	ETF	559.95	560.26	559.89	559.9	41364.0
2024-08-20 07:30:00	SPY	ETF	559.89	560.06	559.76	559.95	53314.0
2024-08-20 08:00:00	SPY	ETF	560.21	560.57	559.4404	559.9	83826.0
2024-08-20 08:30:00	SPY	ETF	559.87	559.87	559.46	559.59	127553.0
2024-08-20 09:00:00	SPY	ETF	559.6	559.61	559.12	559.21	130841.0
2024-08-20 09:30:00	SPY	ETF	559.15	560.84	559.14	560.745	2644875.0
2024-08-20 10:00:00	SPY	ETF	560.75	560.82	558.79	559.11	2295808.0
2024-08-20 10:30:00	SPY	ETF	559.1	559.23	557.96	558.38	2339994.0
2024-08-20 11:00:00	SPY	ETF	558.38	558.66	557.88	557.97	1310063.0
2024-08-20 11:30:00	SPY	ETF	557.96	559.3205	557.84	559.29	1292587.0
2024-08-20 12:00:00	SPY	ETF	559.29	559.43	558.22	558.585	1142624.0
2024-08-20 12:30:00	SPY	ETF	558.58	558.75	558.02	558.05	643333.0
2024-08-20 13:00:00	SPY	ETF	558.05	558.29	557.325	558.1798	1170153.0
2024-08-20 13:30:00	SPY	ETF	558.17	558.48	557.69	558.325	814077.0
2024-08-20 14:00:00	SPY	ETF	558.31	559.74	558.2	559.4099	1588908.0
2024-08-20 14:30:00	SPY	ETF	559.39	559.48	558.81	559.08	1067904.0
2024-08-20 15:00:00	SPY	ETF	559.08	559.23	558.64	558.68	1160231.0
2024-08-20 15:30:00	SPY	ETF	558.67	559.17	558.4	558.62	4299975.0
2024-08-20 16:00:00	SPY	ETF	558.62	559.1	558.5487	558.92	1930635.0
2024-08-20 16:30:00	SPY	ETF	558.9	558.9	558.58	558.58	83054.0
2024-08-20 17:00:00	SPY	ETF	558.5801	558.7	558.52	558.57	573719.0
2024-08-20 17:30:00	SPY	ETF	558.53	558.7	558.42	558.5	305956.0
2024-08-20 18:00:00	SPY	ETF	558.51	558.66	558.35	558.51	19338.0
2024-08-20 18:30:00	SPY	ETF	558.57	558.69	558.38	558.53	8613.0
2024-08-20 19:00:00	SPY	ETF	558.6	558.6	558.45	558.46	3057.0
2024-08-20 19:30:00	SPY	ETF	558.55	558.74	558.49	558.54	9887.0
2024-08-20 04:00:00	QQQ	ETF	481.77	482.61	481.77	481.8	33610.0
2024-08-20 04:30:00	QQQ	ETF	481.82	481.92	481.13	481.65	46578.0
2024-08-20 05:00:00	QQQ	ETF	481.76	482.36	481.76	482.17	9836.0
2024-08-20 05:30:00	QQQ	ETF	482.12	482.31	481.85	481.85	8387.0
2024-08-20 06:00:00	QQQ	ETF	481.75	481.91	481.63	481.79	8083.0
2024-08-20 06:30:00	QQQ	ETF	481.78	482.15	481.76	481.82	34461.0
2024-08-20 07:00:00	QQQ	ETF	481.79	482.1	481.64	481.64	57702.0
2024-08-20 07:30:00	QQQ	ETF	481.64	481.85	481.45	481.7	59066.0
2024-08-20 08:00:00	QQQ	ETF	481.7919	482.89	480.91	481.65	147609.0
2024-08-20 08:30:00	QQQ	ETF	481.64	481.64	480.97	481.1	154557.0
2024-08-20 09:00:00	QQQ	ETF	481.0901	481.14	480.2	480.34	575509.0
2024-08-20 09:30:00	QQQ	ETF	480.35	482.94	480.33	482.79	3110140.0
2024-08-20 10:00:00	QQQ	ETF	482.8	482.9	479.97	480.5	2606531.0
2024-08-20 10:30:00	QQQ	ETF	480.5	480.78	478.55	479.55	2188882.0
2024-08-20 11:00:00	QQQ	ETF	479.56	480.51	479.27	479.7	1261188.0
2024-08-20 11:30:00	QQQ	ETF	479.65	481.22	479.49	481.19	971550.0
2024-08-20 12:00:00	QQQ	ETF	481.21	481.35	479.95	480.195	899462.0
2024-08-20 12:30:00	QQQ	ETF	480.15	480.44	479.34	479.37	749226.0

> showing 50 of 32,724 rows — these rows as CSV

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