PREVIEW / etf_30min / 2024-11-04

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-04.parquet
  size:    883 KB
  rows:    35,267

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-04 04:00:00	SPY	ETF	571.87	571.87	571.51	571.64	12890.0
2024-11-04 04:30:00	SPY	ETF	571.63	572.0	571.35	572.0	10518.0
2024-11-04 05:00:00	SPY	ETF	571.94	572.42	571.94	572.26	3771.0
2024-11-04 05:30:00	SPY	ETF	572.45	572.8	572.45	572.63	2188.0
2024-11-04 06:00:00	SPY	ETF	572.73	572.75	572.22	572.22	4957.0
2024-11-04 06:30:00	SPY	ETF	572.32	572.42	572.2	572.32	8097.0
2024-11-04 07:00:00	SPY	ETF	572.33	572.599	571.51	571.55	72373.0
2024-11-04 07:30:00	SPY	ETF	571.61	572.11	571.0	572.0	70198.0
2024-11-04 08:00:00	SPY	ETF	572.5	573.0	571.0599	571.82	70635.0
2024-11-04 08:30:00	SPY	ETF	571.78	572.11	571.52	571.63	53748.0
2024-11-04 09:00:00	SPY	ETF	571.62	571.62	570.45	571.18	198004.0
2024-11-04 09:30:00	SPY	ETF	571.18	571.54	569.27	571.52	2550548.0
2024-11-04 10:00:00	SPY	ETF	571.4701	572.5	571.21	572.1099	1493503.0
2024-11-04 10:30:00	SPY	ETF	572.09	572.22	571.3	571.63	1159751.0
2024-11-04 11:00:00	SPY	ETF	571.64	572.19	571.0204	571.11	983552.0
2024-11-04 11:30:00	SPY	ETF	571.11	571.18	568.27	568.85	2060527.0
2024-11-04 12:00:00	SPY	ETF	568.8701	570.105	567.89	570.01	1626937.0
2024-11-04 12:30:00	SPY	ETF	569.98	570.86	569.79	570.46	779171.0
2024-11-04 13:00:00	SPY	ETF	570.45	571.09	569.2325	570.55	970325.0
2024-11-04 13:30:00	SPY	ETF	570.52	571.27	570.32	570.6627	809890.0
2024-11-04 14:00:00	SPY	ETF	570.67	571.21	570.26	570.3302	1020584.0
2024-11-04 14:30:00	SPY	ETF	570.32	571.07	570.1	570.5103	1209883.0
2024-11-04 15:00:00	SPY	ETF	570.51	570.68	569.94	570.24	1306681.0
2024-11-04 15:30:00	SPY	ETF	570.23	570.27	569.17	569.77	4952683.0
2024-11-04 16:00:00	SPY	ETF	569.78	570.2706	569.5	570.1	2124598.0
2024-11-04 16:30:00	SPY	ETF	570.1	570.28	569.81	570.28	251786.0
2024-11-04 17:00:00	SPY	ETF	570.24	570.2401	570.01	570.1	106160.0
2024-11-04 17:30:00	SPY	ETF	570.15	570.23	569.5704	570.23	199539.0
2024-11-04 18:00:00	SPY	ETF	570.24	570.7	569.84	569.89	67919.0
2024-11-04 18:30:00	SPY	ETF	569.92	570.2	569.72	569.72	24146.0
2024-11-04 19:00:00	SPY	ETF	569.72	569.72	569.47	569.47	12766.0
2024-11-04 19:30:00	SPY	ETF	569.59	569.69	569.4	569.58	15203.0
2024-11-04 04:00:00	QQQ	ETF	487.97	487.98	487.5	487.59	17693.0
2024-11-04 04:30:00	QQQ	ETF	487.66	488.0	487.21	487.91	20496.0
2024-11-04 05:00:00	QQQ	ETF	487.98	488.45	487.98	488.37	11627.0
2024-11-04 05:30:00	QQQ	ETF	488.47	489.0	488.47	488.6	9913.0
2024-11-04 06:00:00	QQQ	ETF	488.75	488.75	488.0	488.0	6099.0
2024-11-04 06:30:00	QQQ	ETF	488.02	488.46	488.02	488.32	16525.0
2024-11-04 07:00:00	QQQ	ETF	488.3	488.61	487.18	487.35	48872.0
2024-11-04 07:30:00	QQQ	ETF	487.31	487.971	486.42	487.92	85916.0
2024-11-04 08:00:00	QQQ	ETF	488.09	489.86	486.46	487.74	113279.0
2024-11-04 08:30:00	QQQ	ETF	487.77	488.18	487.26	487.51	62849.0
2024-11-04 09:00:00	QQQ	ETF	487.42	487.42	486.07	486.82	175734.0
2024-11-04 09:30:00	QQQ	ETF	486.82	487.32	484.2545	487.1563	2221154.0
2024-11-04 10:00:00	QQQ	ETF	487.13	488.83	486.8	488.3401	1131754.0
2024-11-04 10:30:00	QQQ	ETF	488.33	488.95	487.81	488.4	862652.0
2024-11-04 11:00:00	QQQ	ETF	488.41	489.38	488.07	488.22	823614.0
2024-11-04 11:30:00	QQQ	ETF	488.22	488.29	485.22	485.81	1366453.0
2024-11-04 12:00:00	QQQ	ETF	485.84	486.7099	484.685	486.69	1446516.0
2024-11-04 12:30:00	QQQ	ETF	486.68	487.46	486.3837	487.01	709974.0

> showing 50 of 35,267 rows — these rows as CSV

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