PREVIEW / etf_30min / 2024-07-08

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-08.parquet
  size:    816 KB
  rows:    33,251

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-08 04:00:00	SPY	ETF	553.85	554.52	553.85	554.43	6698.0
2024-07-08 04:30:00	SPY	ETF	554.45	554.65	554.41	554.53	1631.0
2024-07-08 05:00:00	SPY	ETF	554.46	554.55	554.43	554.54	2792.0
2024-07-08 05:30:00	SPY	ETF	554.52	554.65	554.47	554.5	5591.0
2024-07-08 06:00:00	SPY	ETF	554.51	554.6	554.5	554.54	29623.0
2024-07-08 06:30:00	SPY	ETF	554.56	554.6	554.44	554.49	7899.0
2024-07-08 07:00:00	SPY	ETF	554.44	554.81	554.42	554.81	14582.0
2024-07-08 07:30:00	SPY	ETF	554.82	554.92	554.79	554.89	24353.0
2024-07-08 08:00:00	SPY	ETF	554.5	555.09	553.75	555.04	92690.0
2024-07-08 08:30:00	SPY	ETF	555.06	555.22	555.01	555.2	64826.0
2024-07-08 09:00:00	SPY	ETF	555.18	555.5	555.15	555.421	136590.0
2024-07-08 09:30:00	SPY	ETF	555.44	556.2501	555.29	556.02	2524795.0
2024-07-08 10:00:00	SPY	ETF	556.01	556.04	555.16	555.4917	1662966.0
2024-07-08 10:30:00	SPY	ETF	555.49	555.57	554.91	555.2	1049024.0
2024-07-08 11:00:00	SPY	ETF	555.21	555.54	555.06	555.37	1019996.0
2024-07-08 11:30:00	SPY	ETF	555.36	555.45	554.732	555.09	1143163.0
2024-07-08 12:00:00	SPY	ETF	555.08	555.1	554.295	554.585	1140747.0
2024-07-08 12:30:00	SPY	ETF	554.58	554.885	554.49	554.8001	895428.0
2024-07-08 13:00:00	SPY	ETF	554.81	554.92	554.47	554.9	697557.0
2024-07-08 13:30:00	SPY	ETF	554.91	555.37	554.89	555.23	813150.0
2024-07-08 14:00:00	SPY	ETF	555.22	555.29	554.92	555.22	576351.0
2024-07-08 14:30:00	SPY	ETF	555.23	555.23	554.19	554.95	1100085.0
2024-07-08 15:00:00	SPY	ETF	554.95	554.9795	554.53	554.619	923423.0
2024-07-08 15:30:00	SPY	ETF	554.6	555.56	554.51	555.34	5856059.0
2024-07-08 16:00:00	SPY	ETF	555.34	555.58	555.15	555.47	3469880.0
2024-07-08 16:30:00	SPY	ETF	555.47	555.48	555.28	555.43	286947.0
2024-07-08 17:00:00	SPY	ETF	555.42	555.49	555.42	555.45	14147.0
2024-07-08 17:30:00	SPY	ETF	555.45	555.45	555.38	555.4	11379.0
2024-07-08 18:00:00	SPY	ETF	555.38	555.65	555.28	555.64	24181.0
2024-07-08 18:30:00	SPY	ETF	555.65	555.68	555.57	555.6	7514.0
2024-07-08 19:00:00	SPY	ETF	555.65	556.1	555.65	556.08	28632.0
2024-07-08 19:30:00	SPY	ETF	556.1	556.45	556.05	556.4	49995.0
2024-07-08 04:00:00	QQQ	ETF	495.88	496.02	495.81	495.9	22154.0
2024-07-08 04:30:00	QQQ	ETF	495.93	496.1	495.81	495.83	19396.0
2024-07-08 05:00:00	QQQ	ETF	495.83	496.14	495.8	496.14	4093.0
2024-07-08 05:30:00	QQQ	ETF	496.14	496.22	495.94	496.0	12196.0
2024-07-08 06:00:00	QQQ	ETF	496.03	496.19	496.03	496.11	9396.0
2024-07-08 06:30:00	QQQ	ETF	496.11	496.15	495.97	496.01	22521.0
2024-07-08 07:00:00	QQQ	ETF	495.96	496.36	495.92	496.29	67706.0
2024-07-08 07:30:00	QQQ	ETF	496.31	496.51	496.31	496.45	59541.0
2024-07-08 08:00:00	QQQ	ETF	496.45	496.63	495.4	496.55	81797.0
2024-07-08 08:30:00	QQQ	ETF	496.55	496.65	495.75	496.47	42012.0
2024-07-08 09:00:00	QQQ	ETF	496.44	496.79	496.38	496.54	107103.0
2024-07-08 09:30:00	QQQ	ETF	496.53	497.04	495.781	496.62	2556286.0
2024-07-08 10:00:00	QQQ	ETF	496.62	496.78	495.69	496.34	1463825.0
2024-07-08 10:30:00	QQQ	ETF	496.34	496.56	495.5	496.0	993646.0
2024-07-08 11:00:00	QQQ	ETF	496.0	497.36	495.875	497.265	1311392.0
2024-07-08 11:30:00	QQQ	ETF	497.27	497.48	496.65	497.4108	1143943.0
2024-07-08 12:00:00	QQQ	ETF	497.43	497.47	496.01	496.34	990481.0
2024-07-08 12:30:00	QQQ	ETF	496.33	496.78	496.06	496.626	731418.0

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

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