PREVIEW / etf_30min / 2024-03-04

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-04.parquet
  size:    836 KB
  rows:    32,876

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-03-04 04:00:00	SPY	ETF	512.74	512.89	512.68	512.68	10370.0
2024-03-04 04:30:00	SPY	ETF	512.56	512.6	512.55	512.56	1756.0
2024-03-04 05:00:00	SPY	ETF	512.42	512.46	512.32	512.44	4769.0
2024-03-04 05:30:00	SPY	ETF	512.46	512.55	512.46	512.46	1700.0
2024-03-04 06:00:00	SPY	ETF	512.46	512.46	512.0	512.28	5277.0
2024-03-04 06:30:00	SPY	ETF	512.29	512.39	512.2	512.39	6542.0
2024-03-04 07:00:00	SPY	ETF	512.36	512.51	512.29	512.51	58733.0
2024-03-04 07:30:00	SPY	ETF	512.5	512.58	512.28	512.28	34734.0
2024-03-04 08:00:00	SPY	ETF	512.28	512.76	512.02	512.12	117516.0
2024-03-04 08:30:00	SPY	ETF	512.1	512.28	511.82	511.86	109486.0
2024-03-04 09:00:00	SPY	ETF	511.82	512.09	511.66	512.03	209955.0
2024-03-04 09:30:00	SPY	ETF	512.04	512.61	512.0	512.505	4420069.0
2024-03-04 10:00:00	SPY	ETF	512.5	512.64	512.07	512.49	2175021.0
2024-03-04 10:30:00	SPY	ETF	512.49	512.88	512.42	512.66	1875343.0
2024-03-04 11:00:00	SPY	ETF	512.665	512.81	512.24	512.44	1962079.0
2024-03-04 11:30:00	SPY	ETF	512.45	512.82	512.16	512.73	1505177.0
2024-03-04 12:00:00	SPY	ETF	512.72	513.145	512.49	513.13	1565446.0
2024-03-04 12:30:00	SPY	ETF	513.12	513.18	512.81	512.96	1481989.0
2024-03-04 13:00:00	SPY	ETF	512.955	513.07	512.35	512.62	1522920.0
2024-03-04 13:30:00	SPY	ETF	512.6	512.9	512.56	512.765	1366675.0
2024-03-04 14:00:00	SPY	ETF	512.76	513.02	512.6	512.92	1873151.0
2024-03-04 14:30:00	SPY	ETF	512.915	514.13	512.86	513.815	3315829.0
2024-03-04 15:00:00	SPY	ETF	513.8178	514.2	513.42	513.5288	2782508.0
2024-03-04 15:30:00	SPY	ETF	513.53	513.67	512.17	512.25	9308135.0
2024-03-04 16:00:00	SPY	ETF	512.24	512.32	511.81	511.81	2502996.0
2024-03-04 16:30:00	SPY	ETF	511.82	511.93	511.8	511.88	301167.0
2024-03-04 17:00:00	SPY	ETF	511.87	511.87	511.76	511.8	48728.0
2024-03-04 17:30:00	SPY	ETF	511.8	511.87	511.75	511.8	25312.0
2024-03-04 18:00:00	SPY	ETF	511.8	511.94	511.46	511.74	96754.0
2024-03-04 18:30:00	SPY	ETF	511.721	511.84	511.54	511.59	14147.0
2024-03-04 19:00:00	SPY	ETF	511.5	511.9	511.47	511.62	39062.0
2024-03-04 19:30:00	SPY	ETF	511.59	511.73	511.41	511.59	43735.0
2024-03-04 04:00:00	QQQ	ETF	446.48	446.77	446.0	446.0	58077.0
2024-03-04 04:30:00	QQQ	ETF	445.98	446.04	445.69	445.69	24531.0
2024-03-04 05:00:00	QQQ	ETF	445.68	445.75	445.43	445.62	17867.0
2024-03-04 05:30:00	QQQ	ETF	445.48	445.74	445.48	445.62	12384.0
2024-03-04 06:00:00	QQQ	ETF	445.61	445.67	445.2	445.38	10892.0
2024-03-04 06:30:00	QQQ	ETF	445.49	445.76	445.43	445.76	6920.0
2024-03-04 07:00:00	QQQ	ETF	445.77	446.12	445.66	446.12	61381.0
2024-03-04 07:30:00	QQQ	ETF	446.1	446.15	445.72	445.73	87030.0
2024-03-04 08:00:00	QQQ	ETF	445.79	446.65	445.56	445.81	145743.0
2024-03-04 08:30:00	QQQ	ETF	445.85	446.03	445.63	445.76	100098.0
2024-03-04 09:00:00	QQQ	ETF	445.75	445.78	445.33	445.66	138767.0
2024-03-04 09:30:00	QQQ	ETF	445.61	445.73	444.59	444.82	3907808.0
2024-03-04 10:00:00	QQQ	ETF	444.82	445.21	444.43	444.68	1983912.0
2024-03-04 10:30:00	QQQ	ETF	444.68	445.71	444.6	445.445	1785032.0
2024-03-04 11:00:00	QQQ	ETF	445.45	445.555	444.91	445.02	1087058.0
2024-03-04 11:30:00	QQQ	ETF	445.02	445.3803	444.47	445.31	1331505.0
2024-03-04 12:00:00	QQQ	ETF	445.28	445.52	444.84	445.515	1115428.0
2024-03-04 12:30:00	QQQ	ETF	445.51	445.59	444.77	445.0013	1268552.0

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

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