PREVIEW / etf_30min / 2024-08-16

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-16.parquet
  size:    814 KB
  rows:    32,493

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-16 04:00:00	SPY	ETF	553.87	554.23	553.61	553.83	8641.0
2024-08-16 04:30:00	SPY	ETF	553.75	553.83	553.54	553.83	4306.0
2024-08-16 05:00:00	SPY	ETF	553.84	554.06	553.84	554.01	1797.0
2024-08-16 05:30:00	SPY	ETF	553.91	553.95	553.52	553.52	3738.0
2024-08-16 06:00:00	SPY	ETF	553.5	553.5	552.64	552.69	31570.0
2024-08-16 06:30:00	SPY	ETF	552.96	552.98	552.4	552.89	74370.0
2024-08-16 07:00:00	SPY	ETF	552.92	552.95	552.44	552.54	110399.0
2024-08-16 07:30:00	SPY	ETF	552.47	552.78	552.22	552.22	82654.0
2024-08-16 08:00:00	SPY	ETF	552.8	554.59	551.48	551.58	218962.0
2024-08-16 08:30:00	SPY	ETF	551.56	551.569	550.13	550.77	388158.0
2024-08-16 09:00:00	SPY	ETF	550.74	551.44	550.65	551.36	241818.0
2024-08-16 09:30:00	SPY	ETF	551.42	552.63	551.26	552.27	3197661.0
2024-08-16 10:00:00	SPY	ETF	552.21	553.62	552.15	552.968	1717088.0
2024-08-16 10:30:00	SPY	ETF	552.9384	553.16	551.645	552.18	1673330.0
2024-08-16 11:00:00	SPY	ETF	552.16	552.78	551.98	552.68	1324064.0
2024-08-16 11:30:00	SPY	ETF	552.68	553.52	552.47	553.35	996914.0
2024-08-16 12:00:00	SPY	ETF	553.34	554.16	553.06	553.895	1280404.0
2024-08-16 12:30:00	SPY	ETF	553.9	555.02	553.77	554.81	955279.0
2024-08-16 13:00:00	SPY	ETF	554.82	554.91	554.29	554.59	1018167.0
2024-08-16 13:30:00	SPY	ETF	554.5899	554.86	553.96	554.55	1010302.0
2024-08-16 14:00:00	SPY	ETF	554.56	554.56	553.81	554.29	1137420.0
2024-08-16 14:30:00	SPY	ETF	554.29	554.73	553.9	554.585	957020.0
2024-08-16 15:00:00	SPY	ETF	554.57	554.71	554.07	554.1	1414888.0
2024-08-16 15:30:00	SPY	ETF	554.095	554.46	553.55	554.21	5121669.0
2024-08-16 16:00:00	SPY	ETF	554.23	554.65	554.11	554.49	2393424.0
2024-08-16 16:30:00	SPY	ETF	554.46	554.53	554.29	554.5	100709.0
2024-08-16 17:00:00	SPY	ETF	554.47	554.77	554.31	554.48	209166.0
2024-08-16 17:30:00	SPY	ETF	554.49	554.6	554.35	554.35	24517.0
2024-08-16 18:00:00	SPY	ETF	554.57	554.57	554.3	554.32	14384.0
2024-08-16 18:30:00	SPY	ETF	554.31	554.31	553.95	554.0	48263.0
2024-08-16 19:00:00	SPY	ETF	554.0	554.03	553.87	554.03	25200.0
2024-08-16 19:30:00	SPY	ETF	554.04	554.04	553.9	553.9	7296.0
2024-08-16 04:00:00	QQQ	ETF	475.45	476.2	475.24	475.31	31969.0
2024-08-16 04:30:00	QQQ	ETF	475.38	475.64	475.09	475.57	46093.0
2024-08-16 05:00:00	QQQ	ETF	475.51	475.89	475.45	475.89	14195.0
2024-08-16 05:30:00	QQQ	ETF	475.78	475.95	475.3	475.42	18432.0
2024-08-16 06:00:00	QQQ	ETF	475.34	475.35	474.49	474.85	26632.0
2024-08-16 06:30:00	QQQ	ETF	474.93	474.93	474.36	474.79	25363.0
2024-08-16 07:00:00	QQQ	ETF	474.89	474.98	474.23	474.37	111189.0
2024-08-16 07:30:00	QQQ	ETF	474.34	474.73	473.75	473.796	90836.0
2024-08-16 08:00:00	QQQ	ETF	474.63	476.75	472.68	472.85	330589.0
2024-08-16 08:30:00	QQQ	ETF	472.85	472.85	471.35	472.05	490174.0
2024-08-16 09:00:00	QQQ	ETF	472.05	472.79	471.96	472.79	390440.0
2024-08-16 09:30:00	QQQ	ETF	472.66	473.4	471.65	472.49	3331655.0
2024-08-16 10:00:00	QQQ	ETF	472.38	474.8	472.33	474.24	2182150.0
2024-08-16 10:30:00	QQQ	ETF	474.24	474.78	472.5	473.05	1572111.0
2024-08-16 11:00:00	QQQ	ETF	473.04	473.67	472.48	473.29	1266163.0
2024-08-16 11:30:00	QQQ	ETF	473.34	474.59	473.18	474.39	879291.0
2024-08-16 12:00:00	QQQ	ETF	474.4	475.4592	474.1	475.31	881939.0
2024-08-16 12:30:00	QQQ	ETF	475.32	476.41	475.16	476.19	923723.0

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

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