PREVIEW / etf_30min / 2024-09-16

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-16.parquet
  size:    804 KB
  rows:    33,080

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-09-16 04:00:00	SPY	ETF	562.21	562.6	562.12	562.57	10870.0
2024-09-16 04:30:00	SPY	ETF	562.51	562.56	562.27	562.56	3246.0
2024-09-16 05:00:00	SPY	ETF	562.52	562.74	562.46	562.59	3561.0
2024-09-16 05:30:00	SPY	ETF	562.59	562.62	562.3	562.3	2611.0
2024-09-16 06:00:00	SPY	ETF	562.34	562.34	561.77	561.77	11511.0
2024-09-16 06:30:00	SPY	ETF	561.72	562.21	561.71	562.11	4524.0
2024-09-16 07:00:00	SPY	ETF	562.14	562.18	561.52	561.61	29458.0
2024-09-16 07:30:00	SPY	ETF	561.7	561.9	561.58	561.71	48232.0
2024-09-16 08:00:00	SPY	ETF	562.14	562.3	561.42	561.53	140878.0
2024-09-16 08:30:00	SPY	ETF	561.56	561.8042	561.34	561.53	60061.0
2024-09-16 09:00:00	SPY	ETF	561.55	561.79	561.41	561.76	127160.0
2024-09-16 09:30:00	SPY	ETF	561.74	562.92	560.82	562.48	3536000.0
2024-09-16 10:00:00	SPY	ETF	562.47	562.82	561.06	561.4788	1823025.0
2024-09-16 10:30:00	SPY	ETF	561.46	561.47	559.9	560.7298	2391187.0
2024-09-16 11:00:00	SPY	ETF	560.72	561.54	560.16	560.83	1623458.0
2024-09-16 11:30:00	SPY	ETF	560.82	561.42	560.5	561.27	1035870.0
2024-09-16 12:00:00	SPY	ETF	561.275	561.42	560.34	561.3899	1243166.0
2024-09-16 12:30:00	SPY	ETF	561.38	561.61	560.79	561.5699	1439009.0
2024-09-16 13:00:00	SPY	ETF	561.57	561.91	561.2	561.715	950231.0
2024-09-16 13:30:00	SPY	ETF	561.71	562.55	561.61	562.5005	972819.0
2024-09-16 14:00:00	SPY	ETF	562.505	562.6	562.06	562.55	1127819.0
2024-09-16 14:30:00	SPY	ETF	562.54	562.72	561.84	562.6975	1311608.0
2024-09-16 15:00:00	SPY	ETF	562.68	562.71	561.96	562.26	1206221.0
2024-09-16 15:30:00	SPY	ETF	562.245	563.11	562.1524	562.86	3528642.0
2024-09-16 16:00:00	SPY	ETF	562.86	562.92	562.43	562.59	1222206.0
2024-09-16 16:30:00	SPY	ETF	562.59	562.7488	562.33	562.34	76073.0
2024-09-16 17:00:00	SPY	ETF	562.4351	562.4351	562.15	562.15	29745.0
2024-09-16 17:30:00	SPY	ETF	562.22	562.35	562.0	562.11	63233.0
2024-09-16 18:00:00	SPY	ETF	562.23	562.88	562.23	562.71	56827.0
2024-09-16 18:30:00	SPY	ETF	562.74	562.8474	562.66	562.66	7710.0
2024-09-16 19:00:00	SPY	ETF	562.81	562.81	562.43	562.68	11777.0
2024-09-16 19:30:00	SPY	ETF	562.67	562.7097	562.44	562.44	18262.0
2024-09-16 04:00:00	QQQ	ETF	474.68	475.75	474.68	475.6	18820.0
2024-09-16 04:30:00	QQQ	ETF	475.55	475.55	475.25	475.38	10695.0
2024-09-16 05:00:00	QQQ	ETF	475.42	475.64	475.26	475.36	4029.0
2024-09-16 05:30:00	QQQ	ETF	475.4	475.41	475.02	475.17	15023.0
2024-09-16 06:00:00	QQQ	ETF	475.14	475.14	473.93	474.13	14019.0
2024-09-16 06:30:00	QQQ	ETF	474.13	474.58	474.0	474.52	10646.0
2024-09-16 07:00:00	QQQ	ETF	474.57	474.58	473.5	473.62	78357.0
2024-09-16 07:30:00	QQQ	ETF	473.59	473.93	473.4	473.67	30037.0
2024-09-16 08:00:00	QQQ	ETF	474.35	475.6704	473.15	473.36	83185.0
2024-09-16 08:30:00	QQQ	ETF	473.39	473.46	472.95	473.19	100607.0
2024-09-16 09:00:00	QQQ	ETF	473.21	473.34	472.806	473.17	117929.0
2024-09-16 09:30:00	QQQ	ETF	473.19	473.8599	470.5301	473.0007	3150960.0
2024-09-16 10:00:00	QQQ	ETF	473.02	473.82	471.58	472.0579	1657851.0
2024-09-16 10:30:00	QQQ	ETF	472.02	472.07	469.89	470.89	2178420.0
2024-09-16 11:00:00	QQQ	ETF	470.87	472.56	469.98	471.93	1301507.0
2024-09-16 11:30:00	QQQ	ETF	471.9036	472.31	470.58	471.57	976692.0
2024-09-16 12:00:00	QQQ	ETF	471.56	471.83	470.2	471.45	929476.0
2024-09-16 12:30:00	QQQ	ETF	471.45	472.03	470.753	471.98	667528.0

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

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