PREVIEW / etf_30min / 2001-09-26

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-09-26.parquet
  size:    16 KB
  rows:    418

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
2001-09-26 09:30:00	SPY	ETF	102.35	102.4	101.25	101.51	3629800.0
2001-09-26 10:00:00	SPY	ETF	101.51	101.8	101.25	101.49	1327100.0
2001-09-26 10:30:00	SPY	ETF	101.45	101.65	101.15	101.56	1150400.0
2001-09-26 11:00:00	SPY	ETF	101.6	101.66	100.9	100.9	1097200.0
2001-09-26 11:30:00	SPY	ETF	100.9	101.15	100.65	100.76	1298400.0
2001-09-26 12:00:00	SPY	ETF	100.8	101.05	100.75	100.97	747900.0
2001-09-26 12:30:00	SPY	ETF	101.0	101.1	100.75	100.81	655100.0
2001-09-26 13:00:00	SPY	ETF	100.75	100.82	100.49	100.76	1371400.0
2001-09-26 13:30:00	SPY	ETF	100.78	100.84	100.5	100.74	987200.0
2001-09-26 14:00:00	SPY	ETF	100.76	101.0	100.59	100.65	612900.0
2001-09-26 14:30:00	SPY	ETF	100.66	100.78	100.43	100.68	660700.0
2001-09-26 15:00:00	SPY	ETF	100.69	100.89	100.54	100.62	996100.0
2001-09-26 15:30:00	SPY	ETF	100.63	101.0	100.48	101.0	1632400.0
2001-09-26 16:00:00	SPY	ETF	101.0	101.42	100.97	101.15	1367300.0
2001-09-26 17:00:00	SPY	ETF	101.25	101.45	101.25	101.45	1200.0
2001-09-26 17:30:00	SPY	ETF	101.45	101.45	101.45	101.45	500.0
2001-09-26 18:00:00	SPY	ETF	101.15	101.15	101.15	101.15	200.0
2001-09-26 09:30:00	QQQ	ETF	29.95	30.0	29.38	29.48	8251500.0
2001-09-26 10:00:00	QQQ	ETF	29.48	29.57	29.2	29.32	6643900.0
2001-09-26 10:30:00	QQQ	ETF	29.3	29.4	29.05	29.35	5581000.0
2001-09-26 11:00:00	QQQ	ETF	29.32	29.38	28.98	29.07	3137700.0
2001-09-26 11:30:00	QQQ	ETF	29.02	29.15	28.8	28.89	5005100.0
2001-09-26 12:00:00	QQQ	ETF	28.89	29.02	28.83	28.99	2838800.0
2001-09-26 12:30:00	QQQ	ETF	28.99	29.08	28.86	28.9	2493700.0
2001-09-26 13:00:00	QQQ	ETF	28.89	28.9	28.63	28.79	3439800.0
2001-09-26 13:30:00	QQQ	ETF	28.8	28.85	28.58	28.7	2595400.0
2001-09-26 14:00:00	QQQ	ETF	28.73	28.86	28.6	28.64	2332300.0
2001-09-26 14:30:00	QQQ	ETF	28.65	28.72	28.48	28.55	3305200.0
2001-09-26 15:00:00	QQQ	ETF	28.56	28.73	28.46	28.53	3127200.0
2001-09-26 15:30:00	QQQ	ETF	28.55	28.64	28.41	28.51	6241900.0
2001-09-26 16:00:00	QQQ	ETF	28.5	28.75	28.48	28.5	1892800.0
2001-09-26 16:30:00	QQQ	ETF	28.63	28.65	28.6	28.6	20400.0
2001-09-26 17:00:00	QQQ	ETF	28.6	28.61	28.44	28.52	51200.0
2001-09-26 17:30:00	QQQ	ETF	28.52	28.55	28.45	28.53	10000.0
2001-09-26 18:00:00	QQQ	ETF	28.5	28.5	28.4	28.45	23300.0
2001-09-26 09:30:00	IWM	ETF	39.6	39.8	39.5	39.5	497000.0
2001-09-26 10:00:00	IWM	ETF	39.48	39.5	39.48	39.5	4400.0
2001-09-26 10:30:00	IWM	ETF	39.395	39.395	39.2	39.39	146000.0
2001-09-26 11:00:00	IWM	ETF	39.4	39.4	39.075	39.27	16000.0
2001-09-26 11:30:00	IWM	ETF	39.055	39.16	39.0	39.0	12800.0
2001-09-26 12:00:00	IWM	ETF	39.05	39.125	38.94	39.09	20000.0
2001-09-26 12:30:00	IWM	ETF	39.085	39.085	39.0	39.0	3400.0
2001-09-26 13:00:00	IWM	ETF	39.075	39.075	38.995	38.995	6800.0
2001-09-26 13:30:00	IWM	ETF	39.025	39.045	38.905	38.905	8600.0
2001-09-26 14:00:00	IWM	ETF	39.025	39.05	38.9	39.0	10600.0
2001-09-26 14:30:00	IWM	ETF	38.995	39.0	38.9	38.9	16600.0
2001-09-26 15:00:00	IWM	ETF	38.875	38.945	38.7	38.85	43600.0
2001-09-26 15:30:00	IWM	ETF	38.85	38.94	38.675	38.825	180800.0
2001-09-26 16:00:00	IWM	ETF	38.88	38.89	38.88	38.89	3000.0
2001-09-26 09:30:00	DIA	ETF	87.39	87.5	86.05	86.5	772500.0

> showing 50 of 418 rows — these rows as CSV

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