PREVIEW / etf_30min / 2024-07-22

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-22.parquet
  size:    836 KB
  rows:    33,723

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-07-22 04:00:00	SPY	ETF	550.51	551.07	550.5	551.07	53533.0
2024-07-22 04:30:00	SPY	ETF	550.99	551.34	550.9	550.92	43664.0
2024-07-22 05:00:00	SPY	ETF	550.84	551.25	550.82	551.25	31189.0
2024-07-22 05:30:00	SPY	ETF	551.25	551.56	551.19	551.56	27851.0
2024-07-22 06:00:00	SPY	ETF	551.57	551.79	551.35	551.77	4017.0
2024-07-22 06:30:00	SPY	ETF	551.78	552.09	551.62	552.09	30106.0
2024-07-22 07:00:00	SPY	ETF	552.09	552.15	551.4	551.71	262628.0
2024-07-22 07:30:00	SPY	ETF	551.73	552.23	551.7	552.07	98338.0
2024-07-22 08:00:00	SPY	ETF	552.0916	552.85	550.17	552.73	188403.0
2024-07-22 08:30:00	SPY	ETF	552.76	552.88	552.2	552.27	116741.0
2024-07-22 09:00:00	SPY	ETF	552.35	553.1	552.23	552.98	159011.0
2024-07-22 09:30:00	SPY	ETF	553.0	554.4101	552.275	552.6601	5073892.0
2024-07-22 10:00:00	SPY	ETF	552.67	553.2	551.34	553.2	2312776.0
2024-07-22 10:30:00	SPY	ETF	553.21	554.43	552.755	553.77	2055331.0
2024-07-22 11:00:00	SPY	ETF	553.76	554.46	551.6999	551.74	2431877.0
2024-07-22 11:30:00	SPY	ETF	551.75	551.9	551.02	551.76	1902787.0
2024-07-22 12:00:00	SPY	ETF	551.74	552.42	551.2805	552.145	1032291.0
2024-07-22 12:30:00	SPY	ETF	552.11	553.78	551.8004	553.5314	1230201.0
2024-07-22 13:00:00	SPY	ETF	553.55	554.39	553.55	554.135	1120421.0
2024-07-22 13:30:00	SPY	ETF	554.14	554.85	554.1	554.515	1142040.0
2024-07-22 14:00:00	SPY	ETF	554.5352	555.08	554.17	554.58	1231015.0
2024-07-22 14:30:00	SPY	ETF	554.575	555.27	554.56	554.815	1186281.0
2024-07-22 15:00:00	SPY	ETF	554.82	555.03	554.155	554.52	1358004.0
2024-07-22 15:30:00	SPY	ETF	554.53	555.14	554.33	554.65	4473372.0
2024-07-22 16:00:00	SPY	ETF	554.63	554.94	554.32	554.35	2401824.0
2024-07-22 16:30:00	SPY	ETF	554.32	554.5	554.25	554.5	56302.0
2024-07-22 17:00:00	SPY	ETF	554.51	554.65	554.0	554.18	389473.0
2024-07-22 17:30:00	SPY	ETF	554.16	554.18	554.0	554.16	55547.0
2024-07-22 18:00:00	SPY	ETF	554.21	554.81	554.21	554.81	82095.0
2024-07-22 18:30:00	SPY	ETF	554.85	554.85	554.65	554.65	5393.0
2024-07-22 19:00:00	SPY	ETF	554.68	554.68	554.43	554.53	9238.0
2024-07-22 19:30:00	SPY	ETF	554.42	554.53	554.2	554.28	28297.0
2024-07-22 04:00:00	QQQ	ETF	477.52	478.26	477.52	478.26	67502.0
2024-07-22 04:30:00	QQQ	ETF	478.15	478.5	477.92	477.92	40024.0
2024-07-22 05:00:00	QQQ	ETF	477.85	478.33	477.78	478.33	30058.0
2024-07-22 05:30:00	QQQ	ETF	478.29	478.76	478.29	478.73	11545.0
2024-07-22 06:00:00	QQQ	ETF	478.73	479.33	478.47	479.2	43654.0
2024-07-22 06:30:00	QQQ	ETF	479.16	479.69	478.98	479.69	59510.0
2024-07-22 07:00:00	QQQ	ETF	479.68	479.72	479.15	479.3	104295.0
2024-07-22 07:30:00	QQQ	ETF	479.33	479.88	479.3	479.85	127165.0
2024-07-22 08:00:00	QQQ	ETF	479.6703	480.51	476.21	480.41	236105.0
2024-07-22 08:30:00	QQQ	ETF	480.5	480.65	480.09	480.2	156306.0
2024-07-22 09:00:00	QQQ	ETF	480.2	481.25	480.2	481.13	332991.0
2024-07-22 09:30:00	QQQ	ETF	481.17	482.86	479.44	481.5369	4051594.0
2024-07-22 10:00:00	QQQ	ETF	481.6	481.76	479.73	481.335	2531041.0
2024-07-22 10:30:00	QQQ	ETF	481.37	482.69	480.58	481.175	2064956.0
2024-07-22 11:00:00	QQQ	ETF	481.2	482.21	478.2	478.4	2820183.0
2024-07-22 11:30:00	QQQ	ETF	478.4	479.27	477.76	479.065	1522115.0
2024-07-22 12:00:00	QQQ	ETF	479.08	480.05	478.38	479.69	899748.0
2024-07-22 12:30:00	QQQ	ETF	479.7	481.64	479.43	481.36	1093923.0

> showing 50 of 33,723 rows — these rows as CSV

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