PREVIEW / etf_30min / 2024-12-11

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-11.parquet
  size:    942 KB
  rows:    36,476

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-11 04:00:00	SPY	ETF	603.34	603.57	603.33	603.38	10195.0
2024-12-11 04:30:00	SPY	ETF	603.41	603.52	603.4	603.52	2012.0
2024-12-11 05:00:00	SPY	ETF	603.44	603.44	603.21	603.21	1792.0
2024-12-11 05:30:00	SPY	ETF	603.26	603.43	603.26	603.43	3108.0
2024-12-11 06:00:00	SPY	ETF	603.43	603.61	603.43	603.61	3027.0
2024-12-11 06:30:00	SPY	ETF	603.64	603.64	603.45	603.52	1394.0
2024-12-11 07:00:00	SPY	ETF	603.45	603.55	603.31	603.55	28887.0
2024-12-11 07:30:00	SPY	ETF	603.57	603.57	603.27	603.36	62315.0
2024-12-11 08:00:00	SPY	ETF	603.4115	603.77	602.9	603.73	158190.0
2024-12-11 08:30:00	SPY	ETF	603.73	605.3609	603.35	605.34	416692.0
2024-12-11 09:00:00	SPY	ETF	605.33	605.94	605.27	605.78	163623.0
2024-12-11 09:30:00	SPY	ETF	605.78	606.655	605.5	606.61	2998590.0
2024-12-11 10:00:00	SPY	ETF	606.6	607.25	606.3202	606.535	1777975.0
2024-12-11 10:30:00	SPY	ETF	606.56	607.06	606.4816	606.7783	1004067.0
2024-12-11 11:00:00	SPY	ETF	606.79	607.52	606.51	607.48	972181.0
2024-12-11 11:30:00	SPY	ETF	607.48	607.87	607.36	607.74	1040196.0
2024-12-11 12:00:00	SPY	ETF	607.75	608.19	607.6798	607.72	1035404.0
2024-12-11 12:30:00	SPY	ETF	607.75	608.12	607.61	608.12	702515.0
2024-12-11 13:00:00	SPY	ETF	608.125	608.435	607.98	608.32	677381.0
2024-12-11 13:30:00	SPY	ETF	608.31	608.4	607.73	607.81	823249.0
2024-12-11 14:00:00	SPY	ETF	607.815	607.98	607.56	607.93	890548.0
2024-12-11 14:30:00	SPY	ETF	607.92	608.2168	607.71	607.94	911757.0
2024-12-11 15:00:00	SPY	ETF	607.95	608.09	607.86	608.07	904816.0
2024-12-11 15:30:00	SPY	ETF	608.065	608.065	607.31	607.5	2828164.0
2024-12-11 16:00:00	SPY	ETF	607.5	607.53	602.8	607.04	2613802.0
2024-12-11 16:30:00	SPY	ETF	607.06	607.07	606.94	607.0	59708.0
2024-12-11 17:00:00	SPY	ETF	607.04	607.1284	606.95	607.02	18111.0
2024-12-11 17:30:00	SPY	ETF	607.01	607.07	606.97	607.05	11490.0
2024-12-11 18:00:00	SPY	ETF	607.02	607.09	606.83	606.8607	33501.0
2024-12-11 18:30:00	SPY	ETF	606.95	606.98	606.85	606.92	11889.0
2024-12-11 19:00:00	SPY	ETF	606.94	606.95	606.65	606.69	19845.0
2024-12-11 19:30:00	SPY	ETF	606.69	606.76	606.5	606.76	43991.0
2024-12-11 04:00:00	QQQ	ETF	521.27	521.78	521.27	521.62	31974.0
2024-12-11 04:30:00	QQQ	ETF	521.56	521.7	521.51	521.65	13897.0
2024-12-11 05:00:00	QQQ	ETF	521.65	521.72	521.31	521.4	13780.0
2024-12-11 05:30:00	QQQ	ETF	521.42	521.62	521.4	521.6	6558.0
2024-12-11 06:00:00	QQQ	ETF	521.62	521.84	521.62	521.81	11713.0
2024-12-11 06:30:00	QQQ	ETF	521.84	521.89	521.41	521.46	11431.0
2024-12-11 07:00:00	QQQ	ETF	521.44	521.59	521.28	521.56	23396.0
2024-12-11 07:30:00	QQQ	ETF	521.58	521.58	521.24	521.38	19369.0
2024-12-11 08:00:00	QQQ	ETF	520.91	522.05	520.63	522.05	98745.0
2024-12-11 08:30:00	QQQ	ETF	521.98	523.68	521.86	523.59	325206.0
2024-12-11 09:00:00	QQQ	ETF	523.56	524.98	523.51	524.98	311377.0
2024-12-11 09:30:00	QQQ	ETF	524.98	527.59	524.59	527.56	3290212.0
2024-12-11 10:00:00	QQQ	ETF	527.56	528.52	527.15	527.4	2180323.0
2024-12-11 10:30:00	QQQ	ETF	527.455	528.34	527.02	527.6	1505453.0
2024-12-11 11:00:00	QQQ	ETF	527.62	529.18	527.44	529.17	1292591.0
2024-12-11 11:30:00	QQQ	ETF	529.17	529.3491	528.6701	529.12	1025731.0
2024-12-11 12:00:00	QQQ	ETF	529.14	529.77	529.1031	529.56	990332.0
2024-12-11 12:30:00	QQQ	ETF	529.55	529.87	529.19	529.6401	694028.0

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

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