PREVIEW / etf_30min / 2024-05-08

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-08.parquet
  size:    784 KB
  rows:    30,815

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-05-08 04:00:00	SPY	ETF	517.37	517.63	517.31	517.63	3795.0
2024-05-08 04:30:00	SPY	ETF	517.54	517.54	517.18	517.18	4783.0
2024-05-08 05:00:00	SPY	ETF	517.16	517.35	517.15	517.27	5770.0
2024-05-08 05:30:00	SPY	ETF	517.19	517.52	517.19	517.35	3535.0
2024-05-08 06:00:00	SPY	ETF	517.3	517.43	517.08	517.27	7011.0
2024-05-08 06:30:00	SPY	ETF	517.32	517.32	516.95	516.98	18474.0
2024-05-08 07:00:00	SPY	ETF	516.84	516.87	516.45	516.49	62661.0
2024-05-08 07:30:00	SPY	ETF	516.42	516.64	516.29	516.47	156085.0
2024-05-08 08:00:00	SPY	ETF	516.59	517.37	515.37	515.42	258665.0
2024-05-08 08:30:00	SPY	ETF	515.52	515.6	514.979	515.41	183318.0
2024-05-08 09:00:00	SPY	ETF	515.46	515.55	515.17	515.25	124759.0
2024-05-08 09:30:00	SPY	ETF	515.26	516.53	515.14	516.5085	3937782.0
2024-05-08 10:00:00	SPY	ETF	516.495	517.12	516.04	516.9	2493578.0
2024-05-08 10:30:00	SPY	ETF	516.905	517.7171	516.695	517.395	2295941.0
2024-05-08 11:00:00	SPY	ETF	517.395	517.6797	516.635	517.03	2430603.0
2024-05-08 11:30:00	SPY	ETF	517.02	517.26	516.64	516.81	1454180.0
2024-05-08 12:00:00	SPY	ETF	516.8	517.12	516.63	516.83	1208975.0
2024-05-08 12:30:00	SPY	ETF	516.83	516.96	516.26	516.63	1323393.0
2024-05-08 13:00:00	SPY	ETF	516.64	516.87	516.1	516.29	1644110.0
2024-05-08 13:30:00	SPY	ETF	516.28	517.1001	516.2	517.07	1212583.0
2024-05-08 14:00:00	SPY	ETF	517.07	517.395	516.9197	517.26	1352374.0
2024-05-08 14:30:00	SPY	ETF	517.27	517.42	516.89	517.0099	1158035.0
2024-05-08 15:00:00	SPY	ETF	517.0	517.47	516.5699	517.31	2058744.0
2024-05-08 15:30:00	SPY	ETF	517.305	517.74	517.19	517.19	5883956.0
2024-05-08 16:00:00	SPY	ETF	517.18	517.2873	516.81	516.92	3069198.0
2024-05-08 16:30:00	SPY	ETF	516.9198	517.11	516.85	517.03	323417.0
2024-05-08 17:00:00	SPY	ETF	517.04	517.05	516.91	516.91	39863.0
2024-05-08 17:30:00	SPY	ETF	516.94	516.94	516.76	516.85	31266.0
2024-05-08 18:00:00	SPY	ETF	516.85	517.25	516.85	517.25	63231.0
2024-05-08 18:30:00	SPY	ETF	517.26	517.26	517.14	517.14	6292.0
2024-05-08 19:00:00	SPY	ETF	517.1	517.11	516.97	517.08	2323.0
2024-05-08 19:30:00	SPY	ETF	517.1	517.15	516.99	516.99	36177.0
2024-05-08 04:00:00	QQQ	ETF	440.5	440.83	440.38	440.79	5742.0
2024-05-08 04:30:00	QQQ	ETF	440.75	440.75	440.3	440.3	4126.0
2024-05-08 05:00:00	QQQ	ETF	440.22	440.43	440.22	440.23	5581.0
2024-05-08 05:30:00	QQQ	ETF	440.3	440.56	440.3	440.33	1272.0
2024-05-08 06:00:00	QQQ	ETF	440.19	440.46	440.04	440.41	7149.0
2024-05-08 06:30:00	QQQ	ETF	440.42	440.42	440.04	440.04	5706.0
2024-05-08 07:00:00	QQQ	ETF	440.03	440.03	439.45	439.5	28468.0
2024-05-08 07:30:00	QQQ	ETF	439.4	439.67	439.21	439.34	86186.0
2024-05-08 08:00:00	QQQ	ETF	439.8303	440.66	438.0	438.0	153114.0
2024-05-08 08:30:00	QQQ	ETF	438.0	438.16	437.43	437.85	173446.0
2024-05-08 09:00:00	QQQ	ETF	437.9	437.94	437.63	437.64	95503.0
2024-05-08 09:30:00	QQQ	ETF	437.66	439.85	437.55	439.705	2819693.0
2024-05-08 10:00:00	QQQ	ETF	439.71	440.7297	439.31	440.56	1864981.0
2024-05-08 10:30:00	QQQ	ETF	440.565	441.48	440.31	440.92	1354263.0
2024-05-08 11:00:00	QQQ	ETF	440.945	441.3	439.78	440.14	1380680.0
2024-05-08 11:30:00	QQQ	ETF	440.16	440.3	439.61	439.855	939908.0
2024-05-08 12:00:00	QQQ	ETF	439.855	440.25	439.66	439.96	793819.0
2024-05-08 12:30:00	QQQ	ETF	439.97	440.07	439.39	439.71	826646.0

> showing 50 of 30,815 rows — these rows as CSV

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