PREVIEW / etf_30min / 2024-12-12

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-12.parquet
  size:    914 KB
  rows:    36,259

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-12 04:00:00	SPY	ETF	606.58	606.82	606.58	606.81	25421.0
2024-12-12 04:30:00	SPY	ETF	606.6	606.67	606.52	606.56	2698.0
2024-12-12 05:00:00	SPY	ETF	606.49	606.65	606.49	606.61	3587.0
2024-12-12 05:30:00	SPY	ETF	606.69	606.73	606.64	606.68	1808.0
2024-12-12 06:00:00	SPY	ETF	606.76	606.78	606.39	606.49	4472.0
2024-12-12 06:30:00	SPY	ETF	606.48	606.64	606.48	606.52	4200.0
2024-12-12 07:00:00	SPY	ETF	606.5	606.75	606.45	606.65	20716.0
2024-12-12 07:30:00	SPY	ETF	606.69	606.69	606.34	606.39	53715.0
2024-12-12 08:00:00	SPY	ETF	606.49	607.06	606.11	606.59	84603.0
2024-12-12 08:30:00	SPY	ETF	606.4	607.05	605.56	606.04	231284.0
2024-12-12 09:00:00	SPY	ETF	606.19	606.66	605.97	606.63	153540.0
2024-12-12 09:30:00	SPY	ETF	606.58	606.64	605.72	606.1999	2235420.0
2024-12-12 10:00:00	SPY	ETF	606.19	606.66	605.13	606.5626	1872563.0
2024-12-12 10:30:00	SPY	ETF	606.56	606.97	606.32	606.799	1056867.0
2024-12-12 11:00:00	SPY	ETF	606.79	607.16	606.62	606.865	625984.0
2024-12-12 11:30:00	SPY	ETF	606.88	606.91	605.77	605.79	779018.0
2024-12-12 12:00:00	SPY	ETF	605.77	606.89	605.77	606.4979	878100.0
2024-12-12 12:30:00	SPY	ETF	606.49	606.83	605.87	606.8	675060.0
2024-12-12 13:00:00	SPY	ETF	606.78	606.95	606.44	606.5167	597853.0
2024-12-12 13:30:00	SPY	ETF	606.51	606.55	605.72	605.76	623809.0
2024-12-12 14:00:00	SPY	ETF	605.75	606.12	604.83	604.93	1229354.0
2024-12-12 14:30:00	SPY	ETF	604.94	605.44	604.92	605.12	1030764.0
2024-12-12 15:00:00	SPY	ETF	605.1	605.23	604.75	604.88	1198434.0
2024-12-12 15:30:00	SPY	ETF	604.9	605.35	604.34	604.35	4201594.0
2024-12-12 16:00:00	SPY	ETF	604.35	604.75	603.91	604.65	3505555.0
2024-12-12 16:30:00	SPY	ETF	604.76	604.76	604.29	604.31	89344.0
2024-12-12 17:00:00	SPY	ETF	604.31	605.0	604.27	604.79	52377.0
2024-12-12 17:30:00	SPY	ETF	604.71	605.49	604.66	605.29	89381.0
2024-12-12 18:00:00	SPY	ETF	605.06	605.07	604.63	604.84	62134.0
2024-12-12 18:30:00	SPY	ETF	604.75	605.04	604.75	604.96	10873.0
2024-12-12 19:00:00	SPY	ETF	604.86	605.38	604.81	605.32	11576.0
2024-12-12 19:30:00	SPY	ETF	605.38	605.57	605.3	605.38	62302.0
2024-12-12 04:00:00	QQQ	ETF	529.07	529.33	528.85	528.9	28225.0
2024-12-12 04:30:00	QQQ	ETF	528.92	528.92	528.57	528.6	8406.0
2024-12-12 05:00:00	QQQ	ETF	528.6	528.9	528.47	528.79	18876.0
2024-12-12 05:30:00	QQQ	ETF	528.89	528.89	528.72	528.72	6634.0
2024-12-12 06:00:00	QQQ	ETF	528.78	528.89	528.33	528.55	18980.0
2024-12-12 06:30:00	QQQ	ETF	528.62	528.65	528.36	528.42	14685.0
2024-12-12 07:00:00	QQQ	ETF	528.42	528.55	528.25	528.36	46179.0
2024-12-12 07:30:00	QQQ	ETF	528.32	528.35	527.67	527.82	72153.0
2024-12-12 08:00:00	QQQ	ETF	528.5	529.35	527.51	528.11	105556.0
2024-12-12 08:30:00	QQQ	ETF	527.93	528.55	526.6	527.37	370481.0
2024-12-12 09:00:00	QQQ	ETF	527.37	527.77	527.18	527.72	166114.0
2024-12-12 09:30:00	QQQ	ETF	527.68	527.75	526.7611	527.43	2048612.0
2024-12-12 10:00:00	QQQ	ETF	527.407	528.3	526.02	528.0494	1700835.0
2024-12-12 10:30:00	QQQ	ETF	528.02	528.56	527.58	528.37	867675.0
2024-12-12 11:00:00	QQQ	ETF	528.36	528.83	528.17	528.2699	698146.0
2024-12-12 11:30:00	QQQ	ETF	528.28	528.35	527.16	527.22	649562.0
2024-12-12 12:00:00	QQQ	ETF	527.19	528.49	527.11	528.265	959924.0
2024-12-12 12:30:00	QQQ	ETF	528.2499	528.86	527.59	528.7929	652640.0

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

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