PREVIEW / etf_30min / 2024-12-04

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-04.parquet
  size:    930 KB
  rows:    36,894

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-04 04:00:00	SPY	ETF	604.68	605.58	604.68	605.31	29000.0
2024-12-04 04:30:00	SPY	ETF	605.31	605.42	605.21	605.39	6883.0
2024-12-04 05:00:00	SPY	ETF	605.37	605.42	605.1	605.27	40664.0
2024-12-04 05:30:00	SPY	ETF	605.3	605.6	605.3	605.5	10566.0
2024-12-04 06:00:00	SPY	ETF	605.48	605.72	605.46	605.59	28337.0
2024-12-04 06:30:00	SPY	ETF	605.55	605.81	605.55	605.81	8863.0
2024-12-04 07:00:00	SPY	ETF	605.78	605.9	605.68	605.751	92390.0
2024-12-04 07:30:00	SPY	ETF	605.789	605.81	605.55	605.56	46713.0
2024-12-04 08:00:00	SPY	ETF	605.7809	605.89	603.91	605.7	60054.0
2024-12-04 08:30:00	SPY	ETF	605.7	606.11	605.61	606.07	117346.0
2024-12-04 09:00:00	SPY	ETF	606.09	606.2	605.61	605.61	152580.0
2024-12-04 09:30:00	SPY	ETF	605.6	606.21	605.51	605.89	2433765.0
2024-12-04 10:00:00	SPY	ETF	605.88	606.02	604.95	605.63	2278639.0
2024-12-04 10:30:00	SPY	ETF	605.66	606.3	605.54	606.23	1403889.0
2024-12-04 11:00:00	SPY	ETF	606.22	606.5	606.22	606.33	888851.0
2024-12-04 11:30:00	SPY	ETF	606.3207	606.47	606.06	606.35	557173.0
2024-12-04 12:00:00	SPY	ETF	606.345	606.49	606.02	606.35	1027144.0
2024-12-04 12:30:00	SPY	ETF	606.35	606.54	605.91	606.4	764501.0
2024-12-04 13:00:00	SPY	ETF	606.4	606.45	605.84	605.8698	493165.0
2024-12-04 13:30:00	SPY	ETF	605.86	606.53	605.2	605.9801	1100988.0
2024-12-04 14:00:00	SPY	ETF	605.98	606.86	605.77	606.7801	1115555.0
2024-12-04 14:30:00	SPY	ETF	606.78	607.13	606.67	606.9158	1207286.0
2024-12-04 15:00:00	SPY	ETF	606.9	607.52	606.83	607.31	1618688.0
2024-12-04 15:30:00	SPY	ETF	607.31	607.91	607.18	607.61	6955246.0
2024-12-04 16:00:00	SPY	ETF	607.59	607.66	607.1	607.27	3025445.0
2024-12-04 16:30:00	SPY	ETF	607.29	607.35	607.16	607.24	64888.0
2024-12-04 17:00:00	SPY	ETF	607.22	607.4	607.18	607.36	28782.0
2024-12-04 17:30:00	SPY	ETF	607.3242	607.34	607.26	607.27	8291.0
2024-12-04 18:00:00	SPY	ETF	607.25	607.3	607.02	607.24	47778.0
2024-12-04 18:30:00	SPY	ETF	607.22	607.22	607.09	607.1	7909.0
2024-12-04 19:00:00	SPY	ETF	607.05	607.05	606.9	607.04	9376.0
2024-12-04 19:30:00	SPY	ETF	606.98	607.0	606.76	606.88	98011.0
2024-12-04 04:00:00	QQQ	ETF	519.54	519.86	519.36	519.8	59059.0
2024-12-04 04:30:00	QQQ	ETF	519.71	519.94	519.56	519.93	40146.0
2024-12-04 05:00:00	QQQ	ETF	519.9	519.95	519.6	519.66	35619.0
2024-12-04 05:30:00	QQQ	ETF	519.77	520.19	519.75	519.94	12445.0
2024-12-04 06:00:00	QQQ	ETF	519.95	520.46	519.95	520.2	29293.0
2024-12-04 06:30:00	QQQ	ETF	520.2	520.58	520.14	520.3	26831.0
2024-12-04 07:00:00	QQQ	ETF	520.32	520.5	520.18	520.35	82489.0
2024-12-04 07:30:00	QQQ	ETF	520.33	520.56	520.13	520.18	22227.0
2024-12-04 08:00:00	QQQ	ETF	520.4	520.65	517.257	520.44	95137.0
2024-12-04 08:30:00	QQQ	ETF	520.43	521.061	520.35	521.06	162035.0
2024-12-04 09:00:00	QQQ	ETF	521.04	521.27	520.3	520.33	187507.0
2024-12-04 09:30:00	QQQ	ETF	520.32	520.91	519.6	520.3	2452341.0
2024-12-04 10:00:00	QQQ	ETF	520.28	521.43	519.68	521.27	1561295.0
2024-12-04 10:30:00	QQQ	ETF	521.28	522.1	521.0601	521.87	1674186.0
2024-12-04 11:00:00	QQQ	ETF	521.9199	522.25	521.4	521.56	1345430.0
2024-12-04 11:30:00	QQQ	ETF	521.57	521.75	521.06	521.65	875982.0
2024-12-04 12:00:00	QQQ	ETF	521.64	522.12	521.35	521.86	807127.0
2024-12-04 12:30:00	QQQ	ETF	521.85	522.02	521.25	521.86	546483.0

> showing 50 of 36,894 rows — these rows as CSV

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