PREVIEW / etf_30min / 2001-09-24

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-09-24.parquet
  size:    17 KB
  rows:    447

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-24 09:30:00	SPY	ETF	99.72	100.06	99.25	99.4	3889400.0
2001-09-24 10:00:00	SPY	ETF	99.3	99.8	99.06	99.6	2494500.0
2001-09-24 10:30:00	SPY	ETF	99.59	99.96	99.29	99.8	2245100.0
2001-09-24 11:00:00	SPY	ETF	99.88	100.4	99.82	100.16	2708700.0
2001-09-24 11:30:00	SPY	ETF	100.16	100.6	100.0	100.51	2098400.0
2001-09-24 12:00:00	SPY	ETF	100.47	100.66	100.34	100.54	816500.0
2001-09-24 12:30:00	SPY	ETF	100.52	100.82	100.47	100.82	1019800.0
2001-09-24 13:00:00	SPY	ETF	100.76	100.82	100.35	100.5	1025700.0
2001-09-24 13:30:00	SPY	ETF	100.5	100.6	100.13	100.3	836800.0
2001-09-24 14:00:00	SPY	ETF	100.32	100.73	100.3	100.42	1001000.0
2001-09-24 14:30:00	SPY	ETF	100.38	101.13	100.38	100.96	1227200.0
2001-09-24 15:00:00	SPY	ETF	101.02	101.16	100.61	100.66	1805800.0
2001-09-24 15:30:00	SPY	ETF	100.67	100.7	100.2	100.48	2762900.0
2001-09-24 16:00:00	SPY	ETF	100.48	100.85	100.3	100.85	886000.0
2001-09-24 16:30:00	SPY	ETF	100.25	100.7	100.25	100.7	11900.0
2001-09-24 17:00:00	SPY	ETF	100.8	100.87	100.65	100.8	13000.0
2001-09-24 17:30:00	SPY	ETF	100.8	100.8	100.7	100.7	1200.0
2001-09-24 18:00:00	SPY	ETF	100.85	100.85	100.85	100.85	100.0
2001-09-24 09:30:00	QQQ	ETF	29.08	29.93	28.9	29.0	14483800.0
2001-09-24 10:00:00	QQQ	ETF	28.95	29.32	28.8	29.22	13054100.0
2001-09-24 10:30:00	QQQ	ETF	29.19	29.47	29.04	29.44	6642800.0
2001-09-24 11:00:00	QQQ	ETF	29.42	29.68	29.4	29.51	7033700.0
2001-09-24 11:30:00	QQQ	ETF	29.56	29.69	29.4	29.62	4253300.0
2001-09-24 12:00:00	QQQ	ETF	29.64	29.76	29.52	29.55	3726100.0
2001-09-24 12:30:00	QQQ	ETF	29.56	29.85	29.54	29.8	2567400.0
2001-09-24 13:00:00	QQQ	ETF	29.8	29.82	29.56	29.65	3245700.0
2001-09-24 13:30:00	QQQ	ETF	29.65	29.75	29.45	29.45	3401300.0
2001-09-24 14:00:00	QQQ	ETF	29.48	29.7	29.43	29.5	3028800.0
2001-09-24 14:30:00	QQQ	ETF	29.53	29.95	29.47	29.9	4787300.0
2001-09-24 15:00:00	QQQ	ETF	29.9	29.99	29.61	29.64	5458700.0
2001-09-24 15:30:00	QQQ	ETF	29.68	29.7	29.36	29.6	8421600.0
2001-09-24 16:00:00	QQQ	ETF	29.59	29.66	29.35	29.36	1942300.0
2001-09-24 16:30:00	QQQ	ETF	29.39	29.61	29.34	29.51	71300.0
2001-09-24 17:00:00	QQQ	ETF	29.56	29.6	29.49	29.6	18900.0
2001-09-24 17:30:00	QQQ	ETF	29.6	29.7	29.59	29.65	5000.0
2001-09-24 18:00:00	QQQ	ETF	29.65	29.8	29.65	29.79	20900.0
2001-09-24 09:30:00	IWM	ETF	38.25	38.825	38.25	38.7	500400.0
2001-09-24 10:00:00	IWM	ETF	38.75	38.9	38.65	38.775	423600.0
2001-09-24 10:30:00	IWM	ETF	38.875	38.9	38.825	38.89	12000.0
2001-09-24 11:00:00	IWM	ETF	39.0	39.125	38.875	39.05	103800.0
2001-09-24 11:30:00	IWM	ETF	39.05	39.095	38.975	39.0	96400.0
2001-09-24 12:00:00	IWM	ETF	39.06	39.075	38.975	39.0	37400.0
2001-09-24 12:30:00	IWM	ETF	39.005	39.075	38.995	39.075	54600.0
2001-09-24 13:00:00	IWM	ETF	39.06	39.1	39.03	39.03	33600.0
2001-09-24 13:30:00	IWM	ETF	39.06	39.145	38.97	39.0	30000.0
2001-09-24 14:00:00	IWM	ETF	38.925	39.05	38.925	39.05	47000.0
2001-09-24 14:30:00	IWM	ETF	39.05	39.235	39.05	39.235	12000.0
2001-09-24 15:00:00	IWM	ETF	39.15	39.15	39.05	39.05	77800.0
2001-09-24 15:30:00	IWM	ETF	39.05	39.29	38.905	39.29	69400.0
2001-09-24 16:00:00	IWM	ETF	39.19	39.19	39.0	39.0	90400.0

> showing 50 of 447 rows — these rows as CSV

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