PREVIEW / etf_30min / 2001-10-31

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-10-31.parquet
  size:    17 KB
  rows:    417

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-10-31 09:30:00	SPY	ETF	106.9	107.43	106.75	107.18	2792600.0
2001-10-31 10:00:00	SPY	ETF	107.22	107.86	107.04	107.66	5976600.0
2001-10-31 10:30:00	SPY	ETF	107.66	107.69	107.22	107.27	1014100.0
2001-10-31 11:00:00	SPY	ETF	107.27	107.44	107.01	107.17	1068500.0
2001-10-31 11:30:00	SPY	ETF	107.16	107.38	107.01	107.06	542700.0
2001-10-31 12:00:00	SPY	ETF	107.06	107.12	106.69	106.84	968000.0
2001-10-31 12:30:00	SPY	ETF	106.85	106.88	106.01	106.15	2063300.0
2001-10-31 13:00:00	SPY	ETF	106.15	106.66	106.11	106.58	1411100.0
2001-10-31 13:30:00	SPY	ETF	106.55	106.88	106.4	106.74	1222600.0
2001-10-31 14:00:00	SPY	ETF	106.71	107.56	106.67	107.43	1777100.0
2001-10-31 14:30:00	SPY	ETF	107.4	107.72	107.34	107.7	1565400.0
2001-10-31 15:00:00	SPY	ETF	107.7	107.77	106.99	107.09	1837700.0
2001-10-31 15:30:00	SPY	ETF	107.05	107.09	106.2	106.27	3804300.0
2001-10-31 16:00:00	SPY	ETF	106.32	106.35	105.6	105.8	2050100.0
2001-10-31 16:30:00	SPY	ETF	105.9	106.0	105.8	105.82	17900.0
2001-10-31 17:00:00	SPY	ETF	105.75	105.81	105.67	105.67	2500.0
2001-10-31 17:30:00	SPY	ETF	105.85	105.85	105.77	105.84	4400.0
2001-10-31 18:00:00	SPY	ETF	105.82	105.82	105.82	105.82	1500.0
2001-10-31 09:30:00	QQQ	ETF	34.04	34.53	34.04	34.4	16454300.0
2001-10-31 10:00:00	QQQ	ETF	34.4	34.96	34.27	34.8	15136800.0
2001-10-31 10:30:00	QQQ	ETF	34.81	34.86	34.49	34.51	7298600.0
2001-10-31 11:00:00	QQQ	ETF	34.54	34.7	34.4	34.58	4299500.0
2001-10-31 11:30:00	QQQ	ETF	34.6	34.72	34.48	34.5	3227600.0
2001-10-31 12:00:00	QQQ	ETF	34.5	34.59	34.32	34.43	2776700.0
2001-10-31 12:30:00	QQQ	ETF	34.43	34.45	33.68	33.81	11520900.0
2001-10-31 13:00:00	QQQ	ETF	33.85	34.22	33.7	34.19	7381500.0
2001-10-31 13:30:00	QQQ	ETF	34.2	34.4	34.11	34.27	4520800.0
2001-10-31 14:00:00	QQQ	ETF	34.27	34.69	34.23	34.64	5336500.0
2001-10-31 14:30:00	QQQ	ETF	34.6	34.86	34.51	34.81	6236100.0
2001-10-31 15:00:00	QQQ	ETF	34.82	34.89	34.35	34.43	8289000.0
2001-10-31 15:30:00	QQQ	ETF	34.47	34.47	33.9	33.96	9628000.0
2001-10-31 16:00:00	QQQ	ETF	33.95	34.54	33.8	33.88	2579800.0
2001-10-31 16:30:00	QQQ	ETF	33.85	33.95	33.84	33.86	78100.0
2001-10-31 17:00:00	QQQ	ETF	33.9	33.9	33.82	33.9	40400.0
2001-10-31 17:30:00	QQQ	ETF	33.89	33.9	33.86	33.89	8100.0
2001-10-31 18:00:00	QQQ	ETF	33.9	33.95	33.86	33.89	19600.0
2001-10-31 09:30:00	IWM	ETF	42.325	42.615	42.275	42.275	17800.0
2001-10-31 10:00:00	IWM	ETF	42.4	42.885	42.4	42.86	225200.0
2001-10-31 10:30:00	IWM	ETF	42.75	42.75	42.75	42.75	800.0
2001-10-31 11:00:00	IWM	ETF	42.58	42.725	42.51	42.515	213400.0
2001-10-31 11:30:00	IWM	ETF	42.515	42.595	42.515	42.59	38600.0
2001-10-31 12:00:00	IWM	ETF	42.55	42.55	42.39	42.5	24200.0
2001-10-31 12:30:00	IWM	ETF	42.495	42.495	42.205	42.205	323800.0
2001-10-31 13:00:00	IWM	ETF	42.245	42.325	42.205	42.255	70800.0
2001-10-31 13:30:00	IWM	ETF	42.28	42.425	42.28	42.425	8200.0
2001-10-31 14:00:00	IWM	ETF	42.475	42.66	42.43	42.615	29800.0
2001-10-31 14:30:00	IWM	ETF	42.69	42.8	42.63	42.74	73800.0
2001-10-31 15:00:00	IWM	ETF	42.74	42.74	42.625	42.67	109800.0
2001-10-31 15:30:00	IWM	ETF	42.625	42.625	42.48	42.55	85800.0
2001-10-31 16:00:00	IWM	ETF	42.55	42.55	42.45	42.45	101400.0

> showing 50 of 417 rows — these rows as CSV

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