PREVIEW / etf_30min / 2024-11-15

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-15.parquet
  size:    925 KB
  rows:    36,278

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-11-15 04:00:00	SPY	ETF	590.35	590.49	589.97	590.12	20574.0
2024-11-15 04:30:00	SPY	ETF	590.06	590.36	589.88	590.03	11127.0
2024-11-15 05:00:00	SPY	ETF	590.04	590.15	589.71	590.08	7194.0
2024-11-15 05:30:00	SPY	ETF	590.03	590.27	589.93	590.22	36757.0
2024-11-15 06:00:00	SPY	ETF	590.22	590.66	590.22	590.66	20668.0
2024-11-15 06:30:00	SPY	ETF	590.62	590.77	590.58	590.75	70098.0
2024-11-15 07:00:00	SPY	ETF	590.68	591.11	590.67	590.9	125040.0
2024-11-15 07:30:00	SPY	ETF	590.88	591.36	590.77	591.36	82950.0
2024-11-15 08:00:00	SPY	ETF	590.7	592.23	589.18	590.78	157942.0
2024-11-15 08:30:00	SPY	ETF	590.87	591.37	590.21	590.326	236718.0
2024-11-15 09:00:00	SPY	ETF	590.41	590.49	589.6	589.8	271942.0
2024-11-15 09:30:00	SPY	ETF	589.73	590.2	588.46	588.66	4750781.0
2024-11-15 10:00:00	SPY	ETF	588.66	588.74	586.67	586.815	3224655.0
2024-11-15 10:30:00	SPY	ETF	586.82	587.6	586.04	586.43	2413471.0
2024-11-15 11:00:00	SPY	ETF	586.4	587.2894	586.16	587.24	1633290.0
2024-11-15 11:30:00	SPY	ETF	587.23	587.38	585.47	585.7787	2261090.0
2024-11-15 12:00:00	SPY	ETF	585.7793	585.95	585.2168	585.4671	1725706.0
2024-11-15 12:30:00	SPY	ETF	585.47	585.81	584.64	585.46	1685623.0
2024-11-15 13:00:00	SPY	ETF	585.465	585.67	585.01	585.43	1322806.0
2024-11-15 13:30:00	SPY	ETF	585.38	585.38	583.86	584.5	1845750.0
2024-11-15 14:00:00	SPY	ETF	584.5	585.04	584.04	584.09	1335944.0
2024-11-15 14:30:00	SPY	ETF	584.11	585.7799	584.03	584.97	2438008.0
2024-11-15 15:00:00	SPY	ETF	584.96	586.2299	584.89	585.31	2179665.0
2024-11-15 15:30:00	SPY	ETF	585.31	586.19	584.73	585.7	5499540.0
2024-11-15 16:00:00	SPY	ETF	585.72	586.52	585.62	586.02	3504042.0
2024-11-15 16:30:00	SPY	ETF	586.02	586.09	585.75	586.04	253879.0
2024-11-15 17:00:00	SPY	ETF	586.05	586.08	585.9	585.9	34396.0
2024-11-15 17:30:00	SPY	ETF	585.9	585.97	585.642	585.79	882268.0
2024-11-15 18:00:00	SPY	ETF	585.79	585.94	585.7	585.93	47294.0
2024-11-15 18:30:00	SPY	ETF	585.91	585.99	585.75	585.95	12662.0
2024-11-15 19:00:00	SPY	ETF	585.99	586.12	585.88	586.0202	6318.0
2024-11-15 19:30:00	SPY	ETF	586.02	586.24	585.97	586.2	23577.0
2024-11-15 04:00:00	QQQ	ETF	505.28	505.28	504.26	504.44	55558.0
2024-11-15 04:30:00	QQQ	ETF	504.33	504.8	504.22	504.47	42418.0
2024-11-15 05:00:00	QQQ	ETF	504.48	504.66	504.1	504.64	63920.0
2024-11-15 05:30:00	QQQ	ETF	504.55	504.71	504.4	504.62	55067.0
2024-11-15 06:00:00	QQQ	ETF	504.63	505.28	504.58	505.26	31382.0
2024-11-15 06:30:00	QQQ	ETF	505.22	505.28	504.94	505.08	91451.0
2024-11-15 07:00:00	QQQ	ETF	505.07	505.55	504.91	505.1	83935.0
2024-11-15 07:30:00	QQQ	ETF	505.15	505.54	505.03	505.48	85944.0
2024-11-15 08:00:00	QQQ	ETF	505.03	506.94	503.78	504.72	104470.0
2024-11-15 08:30:00	QQQ	ETF	504.87	505.4	504.0	504.18	237475.0
2024-11-15 09:00:00	QQQ	ETF	504.27	504.31	502.82	503.11	419579.0
2024-11-15 09:30:00	QQQ	ETF	502.94	503.33	501.04	501.31	4327162.0
2024-11-15 10:00:00	QQQ	ETF	501.34	501.48	498.7	498.89	2641566.0
2024-11-15 10:30:00	QQQ	ETF	498.89	499.37	497.76	498.18	2534368.0
2024-11-15 11:00:00	QQQ	ETF	498.19	498.76	497.535	498.66	1559855.0
2024-11-15 11:30:00	QQQ	ETF	498.68	498.93	496.28	496.62	2231004.0
2024-11-15 12:00:00	QQQ	ETF	496.625	496.92	496.14	496.6175	1631216.0
2024-11-15 12:30:00	QQQ	ETF	496.61	497.06	495.47	496.37	1788800.0

> showing 50 of 36,278 rows — these rows as CSV

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