PREVIEW / etf_30min / 2024-08-28

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-28.parquet
  size:    816 KB
  rows:    32,688

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-28 04:00:00	SPY	ETF	561.19	561.8	561.19	561.8	9952.0
2024-08-28 04:30:00	SPY	ETF	561.97	562.23	561.97	562.23	6226.0
2024-08-28 05:00:00	SPY	ETF	562.23	562.25	562.03	562.25	1030.0
2024-08-28 05:30:00	SPY	ETF	562.23	562.23	561.93	562.05	2240.0
2024-08-28 06:00:00	SPY	ETF	562.08	562.08	561.98	562.01	1249.0
2024-08-28 06:30:00	SPY	ETF	561.95	561.96	561.8	561.85	3447.0
2024-08-28 07:00:00	SPY	ETF	561.89	561.89	561.6	561.6	5193.0
2024-08-28 07:30:00	SPY	ETF	561.57	561.72	561.0	561.16	28195.0
2024-08-28 08:00:00	SPY	ETF	561.63	562.1804	560.84	561.29	34251.0
2024-08-28 08:30:00	SPY	ETF	561.29	561.54	561.23	561.42	43262.0
2024-08-28 09:00:00	SPY	ETF	561.43	561.53	560.88	561.2	57988.0
2024-08-28 09:30:00	SPY	ETF	561.21	561.65	560.59	561.08	1697234.0
2024-08-28 10:00:00	SPY	ETF	561.06	561.29	560.41	561.11	1000898.0
2024-08-28 10:30:00	SPY	ETF	561.09	561.31	559.45	559.64	1266084.0
2024-08-28 11:00:00	SPY	ETF	559.62	559.67	557.7	558.31	2024674.0
2024-08-28 11:30:00	SPY	ETF	558.32	558.585	557.72	558.45	2103845.0
2024-08-28 12:00:00	SPY	ETF	558.445	558.659	556.8925	557.5	1211786.0
2024-08-28 12:30:00	SPY	ETF	557.505	558.67	557.31	558.565	945619.0
2024-08-28 13:00:00	SPY	ETF	558.555	558.87	557.64	557.95	821441.0
2024-08-28 13:30:00	SPY	ETF	557.965	558.3	555.21	555.335	1525291.0
2024-08-28 14:00:00	SPY	ETF	555.35	556.22	555.04	555.735	1899483.0
2024-08-28 14:30:00	SPY	ETF	555.73	558.16	555.5	558.06	1432361.0
2024-08-28 15:00:00	SPY	ETF	558.04	558.78	557.15	558.55	2353131.0
2024-08-28 15:30:00	SPY	ETF	558.55	559.36	558.04	558.33	6110876.0
2024-08-28 16:00:00	SPY	ETF	558.34	558.84	554.87	556.31	2851821.0
2024-08-28 16:30:00	SPY	ETF	556.55	557.96	555.89	556.53	352056.0
2024-08-28 17:00:00	SPY	ETF	557.0	558.0	555.75	555.85	128118.0
2024-08-28 17:30:00	SPY	ETF	555.87	556.41	554.91	555.13	153554.0
2024-08-28 18:00:00	SPY	ETF	555.0	555.97	554.81	555.22	143604.0
2024-08-28 18:30:00	SPY	ETF	555.3	555.4	553.38	554.25	58980.0
2024-08-28 19:00:00	SPY	ETF	554.2	554.58	554.09	554.09	22545.0
2024-08-28 19:30:00	SPY	ETF	554.18	554.56	554.18	554.46	33018.0
2024-08-28 04:00:00	QQQ	ETF	476.71	476.89	476.41	476.83	21910.0
2024-08-28 04:30:00	QQQ	ETF	476.86	477.8	476.86	477.68	23845.0
2024-08-28 05:00:00	QQQ	ETF	477.66	477.82	477.49	477.65	17105.0
2024-08-28 05:30:00	QQQ	ETF	477.51	477.58	477.18	477.35	5272.0
2024-08-28 06:00:00	QQQ	ETF	477.45	477.45	477.14	477.31	8650.0
2024-08-28 06:30:00	QQQ	ETF	477.36	477.45	477.11	477.25	3610.0
2024-08-28 07:00:00	QQQ	ETF	477.27	477.28	476.69	476.69	37632.0
2024-08-28 07:30:00	QQQ	ETF	476.69	476.85	475.95	476.15	55394.0
2024-08-28 08:00:00	QQQ	ETF	476.84	477.7096	475.85	476.51	86778.0
2024-08-28 08:30:00	QQQ	ETF	476.5	476.76	476.43	476.73	44370.0
2024-08-28 09:00:00	QQQ	ETF	476.6	476.8	475.58	476.19	136270.0
2024-08-28 09:30:00	QQQ	ETF	476.29	477.02	473.97	474.62	2141467.0
2024-08-28 10:00:00	QQQ	ETF	474.66	475.48	473.59	475.17	1770356.0
2024-08-28 10:30:00	QQQ	ETF	475.16	475.47	472.15	472.16	2093056.0
2024-08-28 11:00:00	QQQ	ETF	472.1499	472.1499	469.33	470.5	2897500.0
2024-08-28 11:30:00	QQQ	ETF	470.49	471.66	469.96	471.5199	1502324.0
2024-08-28 12:00:00	QQQ	ETF	471.45	471.805	469.91	470.75	1053238.0
2024-08-28 12:30:00	QQQ	ETF	470.72	472.33	470.56	472.102	903648.0

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

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