PREVIEW / etf_30min / 2024-12-30

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-30.parquet
  size:    952 KB
  rows:    39,614

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-12-30 04:00:00	SPY	ETF	593.45	593.69	593.34	593.69	16978.0
2024-12-30 04:30:00	SPY	ETF	593.62	593.62	593.36	593.54	3661.0
2024-12-30 05:00:00	SPY	ETF	593.41	593.69	593.41	593.66	4360.0
2024-12-30 05:30:00	SPY	ETF	593.65	593.65	593.54	593.54	2398.0
2024-12-30 06:00:00	SPY	ETF	593.56	593.81	593.55	593.81	3556.0
2024-12-30 06:30:00	SPY	ETF	593.83	593.85	593.51	593.51	9093.0
2024-12-30 07:00:00	SPY	ETF	593.6	593.61	592.78	592.8	47304.0
2024-12-30 07:30:00	SPY	ETF	592.921	592.921	588.71	589.42	292844.0
2024-12-30 08:00:00	SPY	ETF	589.41	593.95	588.76	589.1	276607.0
2024-12-30 08:30:00	SPY	ETF	589.12	589.37	586.91	587.35	312061.0
2024-12-30 09:00:00	SPY	ETF	587.42	588.33	587.2	587.92	381741.0
2024-12-30 09:30:00	SPY	ETF	587.96	588.01	585.19	585.22	4366799.0
2024-12-30 10:00:00	SPY	ETF	585.21	586.21	584.41	584.77	3623585.0
2024-12-30 10:30:00	SPY	ETF	584.76	587.4	584.75	587.11	2259918.0
2024-12-30 11:00:00	SPY	ETF	587.08	588.465	586.41	587.99	1657365.0
2024-12-30 11:30:00	SPY	ETF	587.97	589.63	587.9301	589.295	1427151.0
2024-12-30 12:00:00	SPY	ETF	589.28	590.55	589.1501	590.44	1279502.0
2024-12-30 12:30:00	SPY	ETF	590.45	591.47	589.65	591.09	1254887.0
2024-12-30 13:00:00	SPY	ETF	591.05	591.74	589.97	590.59	860681.0
2024-12-30 13:30:00	SPY	ETF	590.51	591.53	590.35	591.1	731941.0
2024-12-30 14:00:00	SPY	ETF	591.12	591.27	589.42	590.34	1331108.0
2024-12-30 14:30:00	SPY	ETF	590.32	591.14	590.18	590.92	1264159.0
2024-12-30 15:00:00	SPY	ETF	590.9	591.21	589.56	589.59	2201280.0
2024-12-30 15:30:00	SPY	ETF	589.59	590.64	588.07	588.23	5076021.0
2024-12-30 16:00:00	SPY	ETF	588.25	588.44	587.35	588.1	2106251.0
2024-12-30 16:30:00	SPY	ETF	588.1	588.18	587.7	588.05	242931.0
2024-12-30 17:00:00	SPY	ETF	588.03	588.2549	587.93	587.96	896295.0
2024-12-30 17:30:00	SPY	ETF	587.95	587.95	587.82	587.85	13844.0
2024-12-30 18:00:00	SPY	ETF	587.85	587.9	587.08	587.61	45514.0
2024-12-30 18:30:00	SPY	ETF	587.67	587.9	587.641	587.85	21036.0
2024-12-30 19:00:00	SPY	ETF	587.86	587.94	587.58	587.62	9931.0
2024-12-30 19:30:00	SPY	ETF	587.42	587.57	587.27	587.3	33479.0
2024-12-30 04:00:00	QQQ	ETF	521.45	521.57	520.7	521.19	36804.0
2024-12-30 04:30:00	QQQ	ETF	521.18	521.38	520.93	521.35	8448.0
2024-12-30 05:00:00	QQQ	ETF	521.14	521.62	521.11	521.5	10769.0
2024-12-30 05:30:00	QQQ	ETF	521.47	521.5	521.17	521.41	7966.0
2024-12-30 06:00:00	QQQ	ETF	521.39	521.69	521.31	521.68	10901.0
2024-12-30 06:30:00	QQQ	ETF	521.58	521.66	521.13	521.26	15655.0
2024-12-30 07:00:00	QQQ	ETF	521.26	521.32	520.29	520.48	40956.0
2024-12-30 07:30:00	QQQ	ETF	520.5	520.64	516.42	517.25	200640.0
2024-12-30 08:00:00	QQQ	ETF	520.98	522.2	516.43	516.83	222526.0
2024-12-30 08:30:00	QQQ	ETF	516.85	517.07	514.38	514.86	320484.0
2024-12-30 09:00:00	QQQ	ETF	514.86	515.94	514.7403	515.43	256632.0
2024-12-30 09:30:00	QQQ	ETF	515.51	515.71	512.54	512.64	3422133.0
2024-12-30 10:00:00	QQQ	ETF	512.62	514.22	511.83	512.44	1762515.0
2024-12-30 10:30:00	QQQ	ETF	512.49	515.4	512.4	514.74	1358361.0
2024-12-30 11:00:00	QQQ	ETF	514.69	515.96	513.9579	515.335	1134900.0
2024-12-30 11:30:00	QQQ	ETF	515.31	517.0	515.2788	516.79	1167524.0
2024-12-30 12:00:00	QQQ	ETF	516.76	518.1899	516.485	518.0799	1064386.0
2024-12-30 12:30:00	QQQ	ETF	518.1	519.3	517.5	518.9401	1563894.0

> showing 50 of 39,614 rows — these rows as CSV

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