PREVIEW / etf_30min / 2024-12-09

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-09.parquet
  size:    935 KB
  rows:    37,271

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-09 04:00:00	SPY	ETF	608.5	608.5	607.92	607.99	11717.0
2024-12-09 04:30:00	SPY	ETF	607.88	607.92	607.62	607.68	4808.0
2024-12-09 05:00:00	SPY	ETF	607.68	607.74	607.4	607.54	9296.0
2024-12-09 05:30:00	SPY	ETF	607.58	607.62	607.41	607.54	6661.0
2024-12-09 06:00:00	SPY	ETF	607.7	607.7	607.19	607.49	13848.0
2024-12-09 06:30:00	SPY	ETF	607.45	607.47	607.0	607.44	12254.0
2024-12-09 07:00:00	SPY	ETF	607.57	607.78	607.5	607.78	18587.0
2024-12-09 07:30:00	SPY	ETF	607.8	607.92	607.54	607.74	16595.0
2024-12-09 08:00:00	SPY	ETF	607.5546	608.52	607.5005	607.72	52745.0
2024-12-09 08:30:00	SPY	ETF	607.7206	607.87	607.58	607.72	32305.0
2024-12-09 09:00:00	SPY	ETF	607.67	607.94	607.53	607.69	54489.0
2024-12-09 09:30:00	SPY	ETF	607.69	607.86	607.2	607.46	1975714.0
2024-12-09 10:00:00	SPY	ETF	607.48	607.58	606.18	606.3775	1677577.0
2024-12-09 10:30:00	SPY	ETF	606.3698	606.64	605.26	605.38	2046534.0
2024-12-09 11:00:00	SPY	ETF	605.38	605.9	604.61	605.785	1917582.0
2024-12-09 11:30:00	SPY	ETF	605.78	606.125	605.47	606.01	1017759.0
2024-12-09 12:00:00	SPY	ETF	606.01	606.06	605.2732	605.61	591209.0
2024-12-09 12:30:00	SPY	ETF	605.58	606.07	605.325	605.3499	520774.0
2024-12-09 13:00:00	SPY	ETF	605.335	605.795	605.04	605.725	597082.0
2024-12-09 13:30:00	SPY	ETF	605.72	606.43	605.625	606.01	785548.0
2024-12-09 14:00:00	SPY	ETF	606.01	606.01	605.24	605.37	938016.0
2024-12-09 14:30:00	SPY	ETF	605.37	605.44	604.51	604.99	1022004.0
2024-12-09 15:00:00	SPY	ETF	605.0	605.07	604.32	604.46	1945419.0
2024-12-09 15:30:00	SPY	ETF	604.46	604.79	604.08	604.66	6054111.0
2024-12-09 16:00:00	SPY	ETF	604.63	604.68	604.0801	604.32	2734094.0
2024-12-09 16:30:00	SPY	ETF	604.32	604.53	604.28	604.47	38728.0
2024-12-09 17:00:00	SPY	ETF	604.39	604.49	604.35	604.41	18660.0
2024-12-09 17:30:00	SPY	ETF	604.4	604.78	604.4	604.62	179682.0
2024-12-09 18:00:00	SPY	ETF	604.56	604.59	604.16	604.35	96323.0
2024-12-09 18:30:00	SPY	ETF	604.42	604.42	604.2	604.3	15253.0
2024-12-09 19:00:00	SPY	ETF	604.25	604.3	604.19	604.19	7401.0
2024-12-09 19:30:00	SPY	ETF	604.3	604.45	604.26	604.42	14176.0
2024-12-09 04:00:00	QQQ	ETF	526.72	527.63	526.5	526.51	39575.0
2024-12-09 04:30:00	QQQ	ETF	526.49	526.52	525.83	525.99	28178.0
2024-12-09 05:00:00	QQQ	ETF	525.85	526.0	525.59	525.79	25606.0
2024-12-09 05:30:00	QQQ	ETF	525.95	525.97	525.5	525.59	22608.0
2024-12-09 06:00:00	QQQ	ETF	525.68	525.83	525.29	525.76	21274.0
2024-12-09 06:30:00	QQQ	ETF	525.77	525.8	524.93	525.56	45722.0
2024-12-09 07:00:00	QQQ	ETF	525.55	525.76	525.36	525.7	30234.0
2024-12-09 07:30:00	QQQ	ETF	525.73	525.92	525.4	525.86	62875.0
2024-12-09 08:00:00	QQQ	ETF	525.61	527.59	525.07	525.72	85149.0
2024-12-09 08:30:00	QQQ	ETF	525.69	525.91	525.45	525.67	50502.0
2024-12-09 09:00:00	QQQ	ETF	525.6699	525.94	525.45	525.5	73467.0
2024-12-09 09:30:00	QQQ	ETF	525.55	526.35	524.75	525.76	1757625.0
2024-12-09 10:00:00	QQQ	ETF	525.725	525.95	523.86	524.06	988927.0
2024-12-09 10:30:00	QQQ	ETF	524.08	524.63	522.82	522.91	1689496.0
2024-12-09 11:00:00	QQQ	ETF	522.93	523.43	521.22	522.93	1805040.0
2024-12-09 11:30:00	QQQ	ETF	522.91	523.2	522.35	523.04	751686.0
2024-12-09 12:00:00	QQQ	ETF	523.01	523.25	522.48	522.81	421866.0
2024-12-09 12:30:00	QQQ	ETF	522.77	523.33	522.4137	522.45	316949.0

> showing 50 of 37,271 rows — these rows as CSV

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