PREVIEW / etf_30min / 2000-09-14

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-09-14.parquet
  size:    11 KB
  rows:    267

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-09-14 09:30:00	SPY	ETF	149.875	149.9375	149.4375	149.5938	547800.0
2000-09-14 10:00:00	SPY	ETF	149.5938	149.7188	149.3125	149.5312	168600.0
2000-09-14 10:30:00	SPY	ETF	149.5	149.6562	149.375	149.625	108600.0
2000-09-14 11:00:00	SPY	ETF	149.5938	149.75	149.2812	149.5	346500.0
2000-09-14 11:30:00	SPY	ETF	149.4375	149.5312	149.1875	149.4688	101300.0
2000-09-14 12:00:00	SPY	ETF	149.4688	149.5	149.125	149.1562	98900.0
2000-09-14 12:30:00	SPY	ETF	149.0625	149.375	149.0625	149.3125	91200.0
2000-09-14 13:00:00	SPY	ETF	149.375	149.375	149.1562	149.3125	105500.0
2000-09-14 13:30:00	SPY	ETF	149.2188	149.2812	148.625	148.8125	207900.0
2000-09-14 14:00:00	SPY	ETF	148.8125	148.9688	148.4688	148.875	266300.0
2000-09-14 14:30:00	SPY	ETF	149.0	149.0	148.875	148.9062	3800.0
2000-09-14 15:00:00	SPY	ETF	148.9375	148.9375	148.4062	148.5	313700.0
2000-09-14 15:30:00	SPY	ETF	148.5	148.625	148.1562	148.5312	724000.0
2000-09-14 16:00:00	SPY	ETF	148.5625	148.7188	148.4375	148.4688	126400.0
2000-09-14 16:30:00	SPY	ETF	149.625	149.625	149.625	149.625	200.0
2000-09-14 09:30:00	QQQ	ETF	95.25	95.625	94.75	95.375	5875000.0
2000-09-14 10:00:00	QQQ	ETF	95.4062	95.5625	94.875	95.375	1979500.0
2000-09-14 10:30:00	QQQ	ETF	95.375	95.5	95.0625	95.4688	951100.0
2000-09-14 11:00:00	QQQ	ETF	95.4375	95.7188	95.25	95.5625	1147100.0
2000-09-14 11:30:00	QQQ	ETF	95.5938	95.5938	95.125	95.4375	767100.0
2000-09-14 12:00:00	QQQ	ETF	95.4688	95.5938	95.0	95.0	1554500.0
2000-09-14 12:30:00	QQQ	ETF	95.0625	95.125	94.8125	95.0938	1490800.0
2000-09-14 13:00:00	QQQ	ETF	95.0625	95.125	94.625	94.7188	892400.0
2000-09-14 13:30:00	QQQ	ETF	94.7188	94.8125	93.375	94.0	2469100.0
2000-09-14 14:00:00	QQQ	ETF	94.0	94.625	93.5	94.375	2600300.0
2000-09-14 14:30:00	QQQ	ETF	94.5625	94.5938	94.1875	94.1875	725700.0
2000-09-14 15:00:00	QQQ	ETF	94.375	94.5	93.625	93.75	1329700.0
2000-09-14 15:30:00	QQQ	ETF	93.75	93.8438	92.625	93.2188	2890300.0
2000-09-14 16:00:00	QQQ	ETF	93.2188	93.625	93.0	93.5	1553700.0
2000-09-14 16:30:00	QQQ	ETF	93.5625	93.625	93.0	93.1875	23500.0
2000-09-14 17:00:00	QQQ	ETF	93.0	93.1875	92.8125	92.875	14200.0
2000-09-14 17:30:00	QQQ	ETF	92.875	93.0625	92.875	93.0	3100.0
2000-09-14 18:00:00	QQQ	ETF	93.0	93.0	92.75	93.0	1900.0
2000-09-14 09:30:00	IWM	ETF	53.8281	53.8281	53.5781	53.5781	2800.0
2000-09-14 10:00:00	IWM	ETF	53.7656	53.9688	53.7656	53.9219	56200.0
2000-09-14 11:00:00	IWM	ETF	54.0312	54.0781	54.0312	54.0625	1800.0
2000-09-14 11:30:00	IWM	ETF	54.0625	54.0625	54.0	54.0	3200.0
2000-09-14 12:00:00	IWM	ETF	54.0312	54.0625	54.0312	54.0312	7600.0
2000-09-14 12:30:00	IWM	ETF	54.0312	54.0312	54.0312	54.0312	1200.0
2000-09-14 13:00:00	IWM	ETF	54.0312	54.0625	54.0312	54.0625	3200.0
2000-09-14 13:30:00	IWM	ETF	53.9375	53.9375	53.9375	53.9375	4000.0
2000-09-14 14:00:00	IWM	ETF	53.9062	54.0	53.8125	53.9062	11200.0
2000-09-14 15:00:00	IWM	ETF	54.0312	54.0312	54.0312	54.0312	2400.0
2000-09-14 15:30:00	IWM	ETF	54.0625	54.1094	53.875	54.0312	12600.0
2000-09-14 16:00:00	IWM	ETF	53.9062	53.9062	53.9062	53.9062	400.0
2000-09-14 09:30:00	DIA	ETF	112.1875	112.4688	111.9375	112.0	180800.0
2000-09-14 10:00:00	DIA	ETF	112.0	112.0312	111.5938	111.625	14500.0
2000-09-14 10:30:00	DIA	ETF	111.5	111.7812	111.5	111.75	23000.0
2000-09-14 11:00:00	DIA	ETF	111.6875	111.75	111.375	111.4375	15900.0
2000-09-14 11:30:00	DIA	ETF	111.4375	111.4375	111.1562	111.375	12000.0

> showing 50 of 267 rows — these rows as CSV

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