PREVIEW / etf_30min / 2024-03-08

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-08.parquet
  size:    809 KB
  rows:    32,585

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-08 04:00:00	SPY	ETF	515.75	515.87	515.57	515.8	10434.0
2024-03-08 04:30:00	SPY	ETF	515.75	515.83	515.7	515.7	1803.0
2024-03-08 05:00:00	SPY	ETF	515.69	515.69	515.5	515.5	7482.0
2024-03-08 05:30:00	SPY	ETF	515.55	515.63	515.5	515.61	8000.0
2024-03-08 06:00:00	SPY	ETF	515.59	515.65	515.45	515.45	2672.0
2024-03-08 06:30:00	SPY	ETF	515.39	515.4	514.77	514.91	11453.0
2024-03-08 07:00:00	SPY	ETF	514.88	514.92	514.11	514.3	51798.0
2024-03-08 07:30:00	SPY	ETF	514.31	514.42	514.02	514.3	116661.0
2024-03-08 08:00:00	SPY	ETF	514.31	516.27	514.05	514.5	152337.0
2024-03-08 08:30:00	SPY	ETF	514.5	516.8	513.15	516.27	1105245.0
2024-03-08 09:00:00	SPY	ETF	516.27	516.8	515.06	515.49	416724.0
2024-03-08 09:30:00	SPY	ETF	515.46	517.8004	515.31	517.76	5248920.0
2024-03-08 10:00:00	SPY	ETF	517.76	518.2201	517.51	517.95	3731249.0
2024-03-08 10:30:00	SPY	ETF	517.96	518.0722	516.9485	517.55	3185723.0
2024-03-08 11:00:00	SPY	ETF	517.54	517.63	514.63	514.76	6842116.0
2024-03-08 11:30:00	SPY	ETF	514.75	515.28	513.94	514.017	6181132.0
2024-03-08 12:00:00	SPY	ETF	514.01	514.9	513.57	514.63	3650356.0
2024-03-08 12:30:00	SPY	ETF	514.64	514.84	512.3	512.55	4384047.0
2024-03-08 13:00:00	SPY	ETF	512.55	513.26	512.06	512.33	4459577.0
2024-03-08 13:30:00	SPY	ETF	512.2939	512.54	511.13	511.71	4369663.0
2024-03-08 14:00:00	SPY	ETF	511.71	513.7	511.64	513.46	4049911.0
2024-03-08 14:30:00	SPY	ETF	513.46	514.46	513.45	513.83	3807827.0
2024-03-08 15:00:00	SPY	ETF	513.83	514.4	511.78	511.93	3794176.0
2024-03-08 15:30:00	SPY	ETF	511.93	512.82	511.72	511.76	8278045.0
2024-03-08 16:00:00	SPY	ETF	511.77	512.67	511.7	512.32	2041144.0
2024-03-08 16:30:00	SPY	ETF	512.3	512.39	512.13	512.17	122410.0
2024-03-08 17:00:00	SPY	ETF	512.14	512.15	512.05	512.0883	29389.0
2024-03-08 17:30:00	SPY	ETF	512.01	512.04	511.76	511.76	35503.0
2024-03-08 18:00:00	SPY	ETF	511.76	511.97	511.72	511.89	334405.0
2024-03-08 18:30:00	SPY	ETF	511.85	511.85	511.72	511.7219	26695.0
2024-03-08 19:00:00	SPY	ETF	511.7205	511.82	511.71	511.71	15092.0
2024-03-08 19:30:00	SPY	ETF	511.71	511.8	511.61	511.64	21473.0
2024-03-08 04:00:00	QQQ	ETF	445.89	446.14	445.6	446.12	35946.0
2024-03-08 04:30:00	QQQ	ETF	446.1	446.4	445.97	446.24	23312.0
2024-03-08 05:00:00	QQQ	ETF	446.2	446.22	445.6	445.67	20984.0
2024-03-08 05:30:00	QQQ	ETF	445.71	445.99	445.67	445.96	16123.0
2024-03-08 06:00:00	QQQ	ETF	445.85	446.06	445.46	445.46	10203.0
2024-03-08 06:30:00	QQQ	ETF	445.4	445.47	444.75	445.08	48214.0
2024-03-08 07:00:00	QQQ	ETF	445.16	445.38	444.5	444.79	76705.0
2024-03-08 07:30:00	QQQ	ETF	444.78	444.9	444.17	444.59	144461.0
2024-03-08 08:00:00	QQQ	ETF	445.12	446.5	444.24	444.87	324579.0
2024-03-08 08:30:00	QQQ	ETF	444.81	447.02	443.22	446.62	1191133.0
2024-03-08 09:00:00	QQQ	ETF	446.55	447.15	445.5	445.83	163642.0
2024-03-08 09:30:00	QQQ	ETF	445.81	447.5113	445.07	447.46	4359420.0
2024-03-08 10:00:00	QQQ	ETF	447.47	448.6	447.3	448.4699	2934964.0
2024-03-08 10:30:00	QQQ	ETF	448.49	448.64	446.425	447.28	3080275.0
2024-03-08 11:00:00	QQQ	ETF	447.24	447.4	442.7	442.861	7695609.0
2024-03-08 11:30:00	QQQ	ETF	442.86	443.64	441.66	442.31	5754047.0
2024-03-08 12:00:00	QQQ	ETF	442.3	443.2	441.16	442.62	3661987.0
2024-03-08 12:30:00	QQQ	ETF	442.67	442.8659	439.32	439.63	3517308.0

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

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