PREVIEW / etf_30min / 2024-01-29

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-29.parquet
  size:    799 KB
  rows:    31,633

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-01-29 04:00:00	SPY	ETF	487.7	487.94	487.36	487.42	12648.0
2024-01-29 04:30:00	SPY	ETF	487.48	487.63	487.17	487.24	6722.0
2024-01-29 05:00:00	SPY	ETF	487.4	487.58	487.37	487.58	1890.0
2024-01-29 05:30:00	SPY	ETF	487.58	487.68	487.49	487.56	1475.0
2024-01-29 06:00:00	SPY	ETF	487.69	487.81	487.57	487.73	5784.0
2024-01-29 06:30:00	SPY	ETF	487.78	487.85	487.7	487.79	14390.0
2024-01-29 07:00:00	SPY	ETF	487.8	488.0	487.76	488.0	58966.0
2024-01-29 07:30:00	SPY	ETF	487.92	487.99	487.5	487.54	90266.0
2024-01-29 08:00:00	SPY	ETF	487.54	488.0	486.94	487.4881	156993.0
2024-01-29 08:30:00	SPY	ETF	487.46	487.51	487.3	487.48	74297.0
2024-01-29 09:00:00	SPY	ETF	487.46	487.71	487.36	487.7	98797.0
2024-01-29 09:30:00	SPY	ETF	487.73	488.15	487.4568	488.03	4404852.0
2024-01-29 10:00:00	SPY	ETF	488.03	488.27	487.4	487.67	3121079.0
2024-01-29 10:30:00	SPY	ETF	487.68	487.9199	487.18	487.3	3096222.0
2024-01-29 11:00:00	SPY	ETF	487.32	487.82	487.17	487.74	1844774.0
2024-01-29 11:30:00	SPY	ETF	487.74	488.18	487.73	488.1204	1522962.0
2024-01-29 12:00:00	SPY	ETF	488.13	488.48	487.88	488.24	2256431.0
2024-01-29 12:30:00	SPY	ETF	488.24	488.59	487.86	488.18	2089530.0
2024-01-29 13:00:00	SPY	ETF	488.18	488.46	487.84	488.4299	1271658.0
2024-01-29 13:30:00	SPY	ETF	488.4216	488.54	488.18	488.215	1189775.0
2024-01-29 14:00:00	SPY	ETF	488.22	488.91	488.09	488.795	2092601.0
2024-01-29 14:30:00	SPY	ETF	488.795	489.11	488.71	488.885	1938490.0
2024-01-29 15:00:00	SPY	ETF	488.89	491.415	488.89	490.93	6051009.0
2024-01-29 15:30:00	SPY	ETF	490.94	491.365	490.38	491.26	8509967.0
2024-01-29 16:00:00	SPY	ETF	491.265	491.33	488.4372	491.11	4237684.0
2024-01-29 16:30:00	SPY	ETF	491.09	491.18	490.88	490.88	275819.0
2024-01-29 17:00:00	SPY	ETF	490.9	491.27	490.9	491.01	93431.0
2024-01-29 17:30:00	SPY	ETF	491.0	491.19	491.0	491.01	34685.0
2024-01-29 18:00:00	SPY	ETF	491.01	491.27	490.86	491.15	72259.0
2024-01-29 18:30:00	SPY	ETF	491.21	491.27	490.99	491.05	629471.0
2024-01-29 19:00:00	SPY	ETF	491.05	491.38	490.93	491.38	39363.0
2024-01-29 19:30:00	SPY	ETF	491.36	491.4	491.26	491.29	16487.0
2024-01-29 04:00:00	QQQ	ETF	425.07	425.29	424.14	424.22	29745.0
2024-01-29 04:30:00	QQQ	ETF	424.41	424.6	424.14	424.26	15262.0
2024-01-29 05:00:00	QQQ	ETF	424.3	424.65	424.28	424.62	11154.0
2024-01-29 05:30:00	QQQ	ETF	424.61	424.89	424.44	424.65	20946.0
2024-01-29 06:00:00	QQQ	ETF	424.63	424.88	424.52	424.88	15422.0
2024-01-29 06:30:00	QQQ	ETF	424.78	424.94	424.62	424.8	22043.0
2024-01-29 07:00:00	QQQ	ETF	424.76	425.01	424.67	424.93	45906.0
2024-01-29 07:30:00	QQQ	ETF	424.8	424.83	424.3	424.48	32514.0
2024-01-29 08:00:00	QQQ	ETF	424.92	424.9787	423.76	424.33	86556.0
2024-01-29 08:30:00	QQQ	ETF	424.25	424.34	424.07	424.23	73500.0
2024-01-29 09:00:00	QQQ	ETF	424.2	424.43	423.97	424.25	94395.0
2024-01-29 09:30:00	QQQ	ETF	424.28	425.12	423.85	424.53	2734729.0
2024-01-29 10:00:00	QQQ	ETF	424.54	424.8	423.76	424.33	2439648.0
2024-01-29 10:30:00	QQQ	ETF	424.33	424.65	423.79	423.85	2050822.0
2024-01-29 11:00:00	QQQ	ETF	423.84	424.58	423.61	424.52	1506403.0
2024-01-29 11:30:00	QQQ	ETF	424.54	425.0899	424.435	425.06	1269056.0
2024-01-29 12:00:00	QQQ	ETF	425.06	425.7	424.95	425.3904	1728483.0
2024-01-29 12:30:00	QQQ	ETF	425.3989	425.75	425.06	425.45	2061732.0

> showing 50 of 31,633 rows — these rows as CSV

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