PREVIEW / etf_30min / 2024-04-08

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-08.parquet
  size:    787 KB
  rows:    31,281

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-04-08 04:00:00	SPY	ETF	518.83	519.04	517.09	517.48	31316.0
2024-04-08 04:30:00	SPY	ETF	517.61	518.21	517.47	517.54	8566.0
2024-04-08 05:00:00	SPY	ETF	517.92	518.48	517.77	518.43	6964.0
2024-04-08 05:30:00	SPY	ETF	518.31	518.35	518.12	518.25	4424.0
2024-04-08 06:00:00	SPY	ETF	518.1	518.29	517.85	518.14	2319.0
2024-04-08 06:30:00	SPY	ETF	518.25	518.66	518.11	518.65	15345.0
2024-04-08 07:00:00	SPY	ETF	518.63	518.93	518.54	518.56	28539.0
2024-04-08 07:30:00	SPY	ETF	518.48	518.75	518.15	518.75	52443.0
2024-04-08 08:00:00	SPY	ETF	518.83	519.24	517.86	519.19	129414.0
2024-04-08 08:30:00	SPY	ETF	519.17	519.89	518.99	519.8	168773.0
2024-04-08 09:00:00	SPY	ETF	519.81	519.95	519.1	519.15	180419.0
2024-04-08 09:30:00	SPY	ETF	519.15	519.39	517.98	518.83	3986588.0
2024-04-08 10:00:00	SPY	ETF	518.84	519.58	518.2	519.537	2842463.0
2024-04-08 10:30:00	SPY	ETF	519.53	520.18	519.49	519.99	2702437.0
2024-04-08 11:00:00	SPY	ETF	519.99	520.13	519.33	519.525	1828950.0
2024-04-08 11:30:00	SPY	ETF	519.5	519.51	518.28	518.73	2584601.0
2024-04-08 12:00:00	SPY	ETF	518.73	518.78	517.89	518.5601	2295366.0
2024-04-08 12:30:00	SPY	ETF	518.56	519.44	518.46	519.44	1609075.0
2024-04-08 13:00:00	SPY	ETF	519.43	519.46	518.79	519.275	1365675.0
2024-04-08 13:30:00	SPY	ETF	519.28	519.4	518.65	519.31	1438275.0
2024-04-08 14:00:00	SPY	ETF	519.31	519.48	518.9399	519.18	1716085.0
2024-04-08 14:30:00	SPY	ETF	519.17	519.26	518.6699	519.255	1477676.0
2024-04-08 15:00:00	SPY	ETF	519.26	519.38	518.74	519.255	1704216.0
2024-04-08 15:30:00	SPY	ETF	519.25	519.7	518.23	518.67	8487737.0
2024-04-08 16:00:00	SPY	ETF	518.66	519.05	518.63	518.89	1847101.0
2024-04-08 16:30:00	SPY	ETF	518.88	518.98	518.85	518.92	155378.0
2024-04-08 17:00:00	SPY	ETF	518.89	519.0	518.74	518.93	30217.0
2024-04-08 17:30:00	SPY	ETF	518.89	518.98	518.83	518.98	4204.0
2024-04-08 18:00:00	SPY	ETF	519.03	519.2	518.88	519.0006	16878.0
2024-04-08 18:30:00	SPY	ETF	518.98	519.0599	518.96	519.059	8254.0
2024-04-08 19:00:00	SPY	ETF	519.0599	519.0599	518.9	518.9	6800.0
2024-04-08 19:30:00	SPY	ETF	518.89	518.96	518.8	518.81	5803.0
2024-04-08 04:00:00	QQQ	ETF	441.25	441.44	439.48	440.05	47276.0
2024-04-08 04:30:00	QQQ	ETF	439.98	440.77	439.93	440.02	25924.0
2024-04-08 05:00:00	QQQ	ETF	440.11	440.78	440.07	440.68	13040.0
2024-04-08 05:30:00	QQQ	ETF	440.66	440.85	440.39	440.75	4663.0
2024-04-08 06:00:00	QQQ	ETF	440.64	440.81	440.2	440.6	13657.0
2024-04-08 06:30:00	QQQ	ETF	440.66	441.0	440.34	440.97	8676.0
2024-04-08 07:00:00	QQQ	ETF	441.02	441.279	440.76	440.82	53977.0
2024-04-08 07:30:00	QQQ	ETF	440.79	440.85	440.32	440.85	34985.0
2024-04-08 08:00:00	QQQ	ETF	441.01	441.5	439.8696	441.32	134261.0
2024-04-08 08:30:00	QQQ	ETF	441.31	442.3	441.16	442.1	164361.0
2024-04-08 09:00:00	QQQ	ETF	442.17	442.31	441.35	441.38	160196.0
2024-04-08 09:30:00	QQQ	ETF	441.42	441.6	439.2	440.76	2982265.0
2024-04-08 10:00:00	QQQ	ETF	440.74	441.7	440.15	441.68	2061338.0
2024-04-08 10:30:00	QQQ	ETF	441.685	442.5	441.6501	442.2499	1756500.0
2024-04-08 11:00:00	QQQ	ETF	442.25	442.43	441.32	441.57	1677144.0
2024-04-08 11:30:00	QQQ	ETF	441.54	441.54	440.21	440.7464	1403519.0
2024-04-08 12:00:00	QQQ	ETF	440.77	440.77	439.58	440.28	1581924.0
2024-04-08 12:30:00	QQQ	ETF	440.28	441.12	440.1601	441.09	1007734.0

> showing 50 of 31,281 rows — these rows as CSV

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