PREVIEW / etf_30min / 2000-08-09

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-08-09.parquet
  size:    11 KB
  rows:    278

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
2000-08-09 09:30:00	SPY	ETF	149.125	149.2188	148.6875	148.9688	634600.0
2000-08-09 10:00:00	SPY	ETF	148.875	149.0625	148.625	148.9062	151300.0
2000-08-09 10:30:00	SPY	ETF	148.9375	149.0	148.125	148.3125	453300.0
2000-08-09 11:00:00	SPY	ETF	148.375	148.4062	148.0	148.2812	526100.0
2000-08-09 11:30:00	SPY	ETF	148.1562	148.2812	147.875	148.2188	333500.0
2000-08-09 12:00:00	SPY	ETF	148.2188	148.3438	148.0938	148.3125	257000.0
2000-08-09 12:30:00	SPY	ETF	148.3125	148.5	148.1562	148.3125	250700.0
2000-08-09 13:00:00	SPY	ETF	148.4375	148.75	148.3125	148.6875	233100.0
2000-08-09 13:30:00	SPY	ETF	148.5625	148.6562	148.125	148.1875	145600.0
2000-08-09 14:00:00	SPY	ETF	148.2188	148.5312	148.125	148.25	215700.0
2000-08-09 14:30:00	SPY	ETF	148.2188	148.875	148.2188	148.6562	173600.0
2000-08-09 15:00:00	SPY	ETF	148.6875	148.75	147.6875	147.6875	694900.0
2000-08-09 15:30:00	SPY	ETF	147.8438	147.9375	147.375	147.6875	1040500.0
2000-08-09 16:00:00	SPY	ETF	147.625	147.7812	147.4062	147.4375	208200.0
2000-08-09 16:30:00	SPY	ETF	147.4375	147.4375	147.4375	147.4375	800.0
2000-08-09 09:30:00	QQQ	ETF	93.6875	94.0	93.125	93.875	3379200.0
2000-08-09 10:00:00	QQQ	ETF	93.75	94.4375	93.5625	94.2188	2305700.0
2000-08-09 10:30:00	QQQ	ETF	94.125	94.2188	93.0625	93.3125	1754200.0
2000-08-09 11:00:00	QQQ	ETF	93.3125	93.5	92.875	93.0312	1430600.0
2000-08-09 11:30:00	QQQ	ETF	93.1562	93.2812	92.5625	93.0625	1018700.0
2000-08-09 12:00:00	QQQ	ETF	93.0625	93.375	92.9375	93.25	622100.0
2000-08-09 12:30:00	QQQ	ETF	93.3125	93.6562	93.0625	93.25	523200.0
2000-08-09 13:00:00	QQQ	ETF	93.2812	93.625	93.125	93.4062	527200.0
2000-08-09 13:30:00	QQQ	ETF	93.375	93.5938	92.75	92.875	714600.0
2000-08-09 14:00:00	QQQ	ETF	92.875	93.25	92.6875	92.7812	1003200.0
2000-08-09 14:30:00	QQQ	ETF	92.75	93.5	92.75	93.25	905700.0
2000-08-09 15:00:00	QQQ	ETF	93.25	93.4375	92.75	92.875	884400.0
2000-08-09 15:30:00	QQQ	ETF	92.9375	92.9688	92.0	92.4688	2126800.0
2000-08-09 16:00:00	QQQ	ETF	92.1562	92.25	91.375	91.875	1338600.0
2000-08-09 16:30:00	QQQ	ETF	91.75	91.8125	91.625	91.6875	31500.0
2000-08-09 17:00:00	QQQ	ETF	91.5	91.9375	91.5	91.6875	10600.0
2000-08-09 17:30:00	QQQ	ETF	91.625	91.6875	91.625	91.625	1600.0
2000-08-09 18:00:00	QQQ	ETF	91.625	91.625	91.625	91.625	200.0
2000-08-09 09:30:00	IWM	ETF	51.2812	51.2812	51.1562	51.1562	2400.0
2000-08-09 10:00:00	IWM	ETF	51.2188	51.2188	51.2031	51.2031	2000.0
2000-08-09 10:30:00	IWM	ETF	51.1562	51.1562	50.875	50.875	800.0
2000-08-09 11:00:00	IWM	ETF	50.7812	50.7812	50.75	50.7812	5800.0
2000-08-09 11:30:00	IWM	ETF	50.8125	50.8281	50.6875	50.6875	1400.0
2000-08-09 13:00:00	IWM	ETF	50.8438	50.9219	50.8438	50.9219	2200.0
2000-08-09 13:30:00	IWM	ETF	51.0156	51.0156	51.0156	51.0156	200.0
2000-08-09 14:00:00	IWM	ETF	50.75	50.9219	50.75	50.75	4200.0
2000-08-09 15:00:00	IWM	ETF	50.9219	50.9219	50.8438	50.8594	1000.0
2000-08-09 15:30:00	IWM	ETF	50.7656	50.7656	50.5312	50.5312	3000.0
2000-08-09 09:30:00	DIA	ETF	109.4062	109.6562	109.1875	109.4375	205500.0
2000-08-09 10:00:00	DIA	ETF	109.2812	109.4375	109.0625	109.2812	260900.0
2000-08-09 10:30:00	DIA	ETF	109.3125	109.4375	108.9062	109.0	196300.0
2000-08-09 11:00:00	DIA	ETF	109.125	109.125	108.9375	109.125	36900.0
2000-08-09 11:30:00	DIA	ETF	109.0312	109.2812	109.0	109.2188	19100.0
2000-08-09 12:00:00	DIA	ETF	109.25	109.3125	109.0312	109.125	37300.0
2000-08-09 12:30:00	DIA	ETF	109.0938	109.25	109.0625	109.0625	6300.0

> showing 50 of 278 rows — these rows as CSV

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