PREVIEW / etf_30min / 2024-07-31

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-31.parquet
  size:    842 KB
  rows:    34,035

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-31 04:00:00	SPY	ETF	544.98	546.95	544.98	546.87	80488.0
2024-07-31 04:30:00	SPY	ETF	546.9	547.45	546.9	546.95	18173.0
2024-07-31 05:00:00	SPY	ETF	546.98	547.03	546.75	546.8	6224.0
2024-07-31 05:30:00	SPY	ETF	546.98	547.24	546.77	546.92	43722.0
2024-07-31 06:00:00	SPY	ETF	546.91	547.32	546.83	547.24	57617.0
2024-07-31 06:30:00	SPY	ETF	547.16	547.47	547.1	547.47	28325.0
2024-07-31 07:00:00	SPY	ETF	547.4	547.4	546.82	547.1	343334.0
2024-07-31 07:30:00	SPY	ETF	547.09	547.51	546.96	547.29	108688.0
2024-07-31 08:00:00	SPY	ETF	547.07	548.23	543.9	547.95	344675.0
2024-07-31 08:30:00	SPY	ETF	547.91	548.96	547.66	548.79	407885.0
2024-07-31 09:00:00	SPY	ETF	548.82	549.38	548.7	548.95	438781.0
2024-07-31 09:30:00	SPY	ETF	548.98	549.26	547.5799	548.74	4667469.0
2024-07-31 10:00:00	SPY	ETF	548.75	550.55	548.47	550.3	2225372.0
2024-07-31 10:30:00	SPY	ETF	550.29	551.28	549.62	550.56	2474976.0
2024-07-31 11:00:00	SPY	ETF	550.56	551.23	550.3701	551.12	1482425.0
2024-07-31 11:30:00	SPY	ETF	551.12	551.71	550.28	550.66	1756628.0
2024-07-31 12:00:00	SPY	ETF	550.685	551.1	550.3	550.51	934031.0
2024-07-31 12:30:00	SPY	ETF	550.5	550.915	550.1	550.17	1002126.0
2024-07-31 13:00:00	SPY	ETF	550.17	550.98	549.92	550.3386	1522586.0
2024-07-31 13:30:00	SPY	ETF	550.33	550.79	548.66	550.29	2520577.0
2024-07-31 14:00:00	SPY	ETF	550.32	551.305	549.43	550.955	2090749.0
2024-07-31 14:30:00	SPY	ETF	550.96	553.5	550.48	553.06	3466631.0
2024-07-31 15:00:00	SPY	ETF	553.05	553.37	549.23	549.68	4971198.0
2024-07-31 15:30:00	SPY	ETF	549.66	552.2668	549.28	550.44	11693517.0
2024-07-31 16:00:00	SPY	ETF	550.44	552.94	550.33	551.75	5594471.0
2024-07-31 16:30:00	SPY	ETF	551.82	552.19	550.81	551.7	386145.0
2024-07-31 17:00:00	SPY	ETF	551.7	551.95	551.24	551.79	35851.0
2024-07-31 17:30:00	SPY	ETF	551.67	552.17	551.57	551.98	73978.0
2024-07-31 18:00:00	SPY	ETF	552.06	553.05	551.98	552.7	204885.0
2024-07-31 18:30:00	SPY	ETF	552.79	553.08	552.45	552.89	26654.0
2024-07-31 19:00:00	SPY	ETF	553.05	553.51	552.95	553.41	109003.0
2024-07-31 19:30:00	SPY	ETF	553.51	553.64	553.4	553.46	42200.0
2024-07-31 04:00:00	QQQ	ETF	463.04	464.5	462.7	464.27	171086.0
2024-07-31 04:30:00	QQQ	ETF	464.1	464.9	464.03	464.09	47108.0
2024-07-31 05:00:00	QQQ	ETF	464.1	464.23	463.72	463.87	23677.0
2024-07-31 05:30:00	QQQ	ETF	463.97	464.5	463.65	463.76	26977.0
2024-07-31 06:00:00	QQQ	ETF	463.76	464.5	463.75	464.16	66135.0
2024-07-31 06:30:00	QQQ	ETF	464.2	464.76	464.07	464.76	59771.0
2024-07-31 07:00:00	QQQ	ETF	464.75	465.0	464.12	464.505	179289.0
2024-07-31 07:30:00	QQQ	ETF	464.53	465.2	464.22	465.01	168709.0
2024-07-31 08:00:00	QQQ	ETF	464.24	466.19	457.187	465.96	378087.0
2024-07-31 08:30:00	QQQ	ETF	465.96	467.47	465.54	467.37	459615.0
2024-07-31 09:00:00	QQQ	ETF	467.35	468.1	467.23	467.96	875228.0
2024-07-31 09:30:00	QQQ	ETF	467.9	468.9	466.41	468.34	6811134.0
2024-07-31 10:00:00	QQQ	ETF	468.37	470.29	467.93	469.57	2815727.0
2024-07-31 10:30:00	QQQ	ETF	469.58	470.83	468.85	469.82	1831702.0
2024-07-31 11:00:00	QQQ	ETF	469.82	470.78	469.58	470.74	1126459.0
2024-07-31 11:30:00	QQQ	ETF	470.72	471.36	469.76	470.26	1388080.0
2024-07-31 12:00:00	QQQ	ETF	470.265	470.76	469.5	469.78	891991.0
2024-07-31 12:30:00	QQQ	ETF	469.74	470.0699	469.18	469.26	716683.0

> showing 50 of 34,035 rows — these rows as CSV

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