PREVIEW / etf_30min / 2000-08-07

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-08-07.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-08-07 09:30:00	SPY	ETF	146.7188	146.9062	146.375	146.5625	550600.0
2000-08-07 10:00:00	SPY	ETF	146.5625	147.25	146.5625	147.1562	242500.0
2000-08-07 10:30:00	SPY	ETF	147.1875	147.4062	147.125	147.25	185900.0
2000-08-07 11:00:00	SPY	ETF	147.25	147.9062	147.2188	147.75	294000.0
2000-08-07 11:30:00	SPY	ETF	147.7812	148.0625	147.6562	147.875	643800.0
2000-08-07 12:00:00	SPY	ETF	147.875	148.125	147.8438	147.875	233700.0
2000-08-07 12:30:00	SPY	ETF	147.9688	148.2188	147.8125	148.0938	167000.0
2000-08-07 13:00:00	SPY	ETF	148.0938	148.1875	147.875	148.0	138000.0
2000-08-07 13:30:00	SPY	ETF	148.0625	148.125	147.875	147.9375	218300.0
2000-08-07 14:00:00	SPY	ETF	148.0312	148.375	148.0312	148.0938	414600.0
2000-08-07 14:30:00	SPY	ETF	148.125	148.1875	147.6875	147.9375	245600.0
2000-08-07 15:00:00	SPY	ETF	147.9688	148.4062	147.875	148.2188	238900.0
2000-08-07 15:30:00	SPY	ETF	148.25	148.4375	148.0312	148.125	381800.0
2000-08-07 16:00:00	SPY	ETF	148.25	148.25	148.0	148.125	192600.0
2000-08-07 09:30:00	QQQ	ETF	90.875	91.5	90.25	90.5625	1932700.0
2000-08-07 10:00:00	QQQ	ETF	90.5625	92.125	90.3125	92.0938	1870400.0
2000-08-07 10:30:00	QQQ	ETF	92.125	92.375	91.75	91.9375	1114400.0
2000-08-07 11:00:00	QQQ	ETF	91.8438	92.9375	91.75	92.5938	1358400.0
2000-08-07 11:30:00	QQQ	ETF	92.5625	92.9375	92.3125	92.5938	833300.0
2000-08-07 12:00:00	QQQ	ETF	92.4375	92.75	92.125	92.1875	594300.0
2000-08-07 12:30:00	QQQ	ETF	92.25	93.0312	92.125	92.875	924700.0
2000-08-07 13:00:00	QQQ	ETF	92.875	92.9688	92.375	92.7812	1372400.0
2000-08-07 13:30:00	QQQ	ETF	92.7812	92.8125	92.4062	92.6562	307200.0
2000-08-07 14:00:00	QQQ	ETF	92.6875	92.875	92.25	92.3438	714400.0
2000-08-07 14:30:00	QQQ	ETF	92.3125	92.5312	91.5625	92.0938	1404500.0
2000-08-07 15:00:00	QQQ	ETF	92.125	92.6875	91.75	92.4375	924500.0
2000-08-07 15:30:00	QQQ	ETF	92.4062	92.9375	92.25	92.6875	1177600.0
2000-08-07 16:00:00	QQQ	ETF	92.7188	92.8125	92.25	92.8125	525400.0
2000-08-07 16:30:00	QQQ	ETF	92.5	92.5	92.5	92.5	300.0
2000-08-07 17:00:00	QQQ	ETF	92.125	92.125	92.125	92.125	300.0
2000-08-07 17:30:00	QQQ	ETF	92.8125	92.8125	92.25	92.25	3700.0
2000-08-07 09:30:00	IWM	ETF	50.4062	50.7188	50.4062	50.5	27200.0
2000-08-07 10:30:00	IWM	ETF	50.8125	50.8125	50.8125	50.8125	26600.0
2000-08-07 11:30:00	IWM	ETF	50.8125	50.8125	50.8125	50.8125	600.0
2000-08-07 12:00:00	IWM	ETF	50.9219	50.9375	50.8125	50.8125	4400.0
2000-08-07 13:30:00	IWM	ETF	50.9688	51.125	50.9688	51.0625	11800.0
2000-08-07 14:00:00	IWM	ETF	51.125	51.125	51.0625	51.0625	3000.0
2000-08-07 14:30:00	IWM	ETF	51.0938	51.0938	50.875	50.875	4000.0
2000-08-07 15:00:00	IWM	ETF	51.0625	51.0625	51.0625	51.0625	400.0
2000-08-07 15:30:00	IWM	ETF	51.0	51.1406	51.0	51.1406	10200.0
2000-08-07 09:30:00	DIA	ETF	107.7812	107.8438	107.3438	107.4688	85100.0
2000-08-07 10:00:00	DIA	ETF	107.4688	108.0625	107.4688	108.0	235400.0
2000-08-07 10:30:00	DIA	ETF	108.0625	108.125	107.75	107.9375	43800.0
2000-08-07 11:00:00	DIA	ETF	107.7812	108.2188	107.7812	108.0938	85300.0
2000-08-07 11:30:00	DIA	ETF	108.2188	108.5	108.0938	108.5	74600.0
2000-08-07 12:00:00	DIA	ETF	108.5	108.5	108.3125	108.375	6300.0
2000-08-07 12:30:00	DIA	ETF	108.25	108.6562	108.25	108.6562	68100.0
2000-08-07 13:00:00	DIA	ETF	108.4375	108.5938	108.4375	108.5	1700.0
2000-08-07 13:30:00	DIA	ETF	108.4375	108.5312	108.375	108.4375	39200.0
2000-08-07 14:00:00	DIA	ETF	108.5	108.75	108.4375	108.5625	27200.0

> showing 50 of 267 rows — these rows as CSV

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