PREVIEW / etf_30min / 2003-07-28

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-28.parquet
  size:    23 KB
  rows:    700

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
2003-07-28 08:00:00	SPY	ETF	100.35	100.41	100.35	100.38	32500.0
2003-07-28 08:30:00	SPY	ETF	100.41	100.41	100.36	100.41	15400.0
2003-07-28 09:00:00	SPY	ETF	100.43	100.46	100.34	100.34	15400.0
2003-07-28 09:30:00	SPY	ETF	100.37	100.49	99.67	99.86	5486900.0
2003-07-28 10:00:00	SPY	ETF	99.82	100.31	99.706	100.26	3072900.0
2003-07-28 10:30:00	SPY	ETF	100.2	100.4	99.96	100.26	2201300.0
2003-07-28 11:00:00	SPY	ETF	100.27	100.45	100.1	100.36	1947400.0
2003-07-28 11:30:00	SPY	ETF	100.38	100.39	100.07	100.07	1608800.0
2003-07-28 12:00:00	SPY	ETF	100.07	100.1	99.7	99.84	1638700.0
2003-07-28 12:30:00	SPY	ETF	99.84	99.989	99.67	99.97	1276000.0
2003-07-28 13:00:00	SPY	ETF	99.96	100.04	99.76	99.98	654000.0
2003-07-28 13:30:00	SPY	ETF	99.98	100.37	99.95	100.22	2744900.0
2003-07-28 14:00:00	SPY	ETF	100.22	100.28	99.86	99.9	1989100.0
2003-07-28 14:30:00	SPY	ETF	99.92	100.288	99.86	100.25	1779700.0
2003-07-28 15:00:00	SPY	ETF	100.25	100.33	100.03	100.264	1865400.0
2003-07-28 15:30:00	SPY	ETF	100.24	100.35	99.75	100.04	3303300.0
2003-07-28 16:00:00	SPY	ETF	100.04	100.09	99.8	99.87	1172700.0
2003-07-28 16:30:00	SPY	ETF	99.85	99.919	99.84	99.919	31900.0
2003-07-28 17:00:00	SPY	ETF	99.91	99.91	99.9	99.9	7300.0
2003-07-28 17:30:00	SPY	ETF	99.93	99.94	99.89	99.89	1000.0
2003-07-28 18:00:00	SPY	ETF	99.9	99.95	99.9	99.944	7400.0
2003-07-28 19:30:00	SPY	ETF	99.91	99.91	99.9	99.9	700.0
2003-07-28 08:00:00	QQQ	ETF	31.89	31.93	31.86	31.9	37100.0
2003-07-28 08:30:00	QQQ	ETF	31.91	31.91	31.89	31.89	8000.0
2003-07-28 09:00:00	QQQ	ETF	31.9	31.95	31.85	31.85	80200.0
2003-07-28 09:30:00	QQQ	ETF	31.86	31.9	31.6	31.72	9851300.0
2003-07-28 10:00:00	QQQ	ETF	31.72	31.92	31.67	31.871	4589700.0
2003-07-28 10:30:00	QQQ	ETF	31.9	31.97	31.78	31.91	5833800.0
2003-07-28 11:00:00	QQQ	ETF	31.92	31.988	31.827	31.951	4186100.0
2003-07-28 11:30:00	QQQ	ETF	31.951	31.97	31.8	31.82	2478900.0
2003-07-28 12:00:00	QQQ	ETF	31.83	31.83	31.68	31.76	3846800.0
2003-07-28 12:30:00	QQQ	ETF	31.76	31.8	31.67	31.77	2579600.0
2003-07-28 13:00:00	QQQ	ETF	31.77	31.82	31.67	31.8	1188600.0
2003-07-28 13:30:00	QQQ	ETF	31.789	31.926	31.77	31.861	2517800.0
2003-07-28 14:00:00	QQQ	ETF	31.86	31.9	31.71	31.71	2738200.0
2003-07-28 14:30:00	QQQ	ETF	31.738	31.921	31.709	31.92	3469500.0
2003-07-28 15:00:00	QQQ	ETF	31.902	31.938	31.8	31.93	2708900.0
2003-07-28 15:30:00	QQQ	ETF	31.92	31.96	31.72	31.85	6059500.0
2003-07-28 16:00:00	QQQ	ETF	31.85	31.92	31.83	31.9	1056100.0
2003-07-28 16:30:00	QQQ	ETF	31.91	31.92	31.88	31.88	85400.0
2003-07-28 17:00:00	QQQ	ETF	31.88	31.891	31.8	31.84	152800.0
2003-07-28 17:30:00	QQQ	ETF	31.84	31.86	31.84	31.84	21200.0
2003-07-28 18:00:00	QQQ	ETF	31.866	31.87	31.84	31.85	12200.0
2003-07-28 18:30:00	QQQ	ETF	31.85	31.86	31.84	31.86	5000.0
2003-07-28 19:00:00	QQQ	ETF	31.86	31.86	31.86	31.86	600.0
2003-07-28 19:30:00	QQQ	ETF	31.86	31.86	31.86	31.86	100.0
2003-07-28 09:30:00	IWM	ETF	46.82	47.13	46.79	46.925	824600.0
2003-07-28 10:00:00	IWM	ETF	46.9	47.23	46.865	47.23	179000.0
2003-07-28 10:30:00	IWM	ETF	47.235	47.29	47.085	47.19	236000.0
2003-07-28 11:00:00	IWM	ETF	47.195	47.24	47.085	47.171	249000.0

> showing 50 of 700 rows — these rows as CSV

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