PREVIEW / etf_30min / 2000-07-11

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-11.parquet
  size:    11 KB
  rows:    257

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-07-11 09:30:00	SPY	ETF	147.4688	148.1875	147.1562	148.125	812000.0
2000-07-11 10:00:00	SPY	ETF	148.0625	148.9688	147.9375	148.7812	567000.0
2000-07-11 10:30:00	SPY	ETF	148.75	149.125	148.75	148.8125	443200.0
2000-07-11 11:00:00	SPY	ETF	148.875	149.125	148.75	148.9062	271900.0
2000-07-11 11:30:00	SPY	ETF	148.5	148.9062	148.5	148.75	245400.0
2000-07-11 12:00:00	SPY	ETF	148.6875	149.125	148.6875	149.125	145300.0
2000-07-11 12:30:00	SPY	ETF	149.0938	149.0938	148.5	148.625	196400.0
2000-07-11 13:00:00	SPY	ETF	148.7188	148.7812	148.0312	148.375	239100.0
2000-07-11 13:30:00	SPY	ETF	148.3125	148.375	147.6562	147.875	329400.0
2000-07-11 14:00:00	SPY	ETF	147.875	148.0938	147.4375	148.0938	464500.0
2000-07-11 14:30:00	SPY	ETF	148.0625	148.2812	147.875	147.9062	429400.0
2000-07-11 15:00:00	SPY	ETF	147.9375	148.0312	147.3125	147.625	299500.0
2000-07-11 15:30:00	SPY	ETF	147.625	148.4062	147.5938	148.375	678300.0
2000-07-11 16:00:00	SPY	ETF	148.3125	148.4062	148.0312	148.0312	251400.0
2000-07-11 09:30:00	QQQ	ETF	94.0625	95.25	93.6875	94.9375	1680100.0
2000-07-11 10:00:00	QQQ	ETF	94.9375	95.75	94.625	95.5938	929400.0
2000-07-11 10:30:00	QQQ	ETF	95.625	95.75	95.3125	95.3125	1091100.0
2000-07-11 11:00:00	QQQ	ETF	95.3125	95.6875	95.3125	95.375	527100.0
2000-07-11 11:30:00	QQQ	ETF	95.3125	95.4375	95.0	95.0938	584700.0
2000-07-11 12:00:00	QQQ	ETF	95.0938	95.375	94.875	95.3125	746800.0
2000-07-11 12:30:00	QQQ	ETF	95.3125	95.3125	94.1875	94.5	1470500.0
2000-07-11 13:00:00	QQQ	ETF	94.4375	94.5625	93.3125	93.6875	1092600.0
2000-07-11 13:30:00	QQQ	ETF	93.625	93.75	92.875	93.5312	1749400.0
2000-07-11 14:00:00	QQQ	ETF	93.5312	93.625	92.8125	93.5	1121200.0
2000-07-11 14:30:00	QQQ	ETF	93.6875	94.0	93.25	93.375	906500.0
2000-07-11 15:00:00	QQQ	ETF	93.3125	93.4688	92.875	93.125	1118400.0
2000-07-11 15:30:00	QQQ	ETF	93.0938	93.875	92.9375	93.5	1105500.0
2000-07-11 16:00:00	QQQ	ETF	93.4375	93.75	93.1562	93.75	217800.0
2000-07-11 16:30:00	QQQ	ETF	93.625	94.25	93.625	94.25	3600.0
2000-07-11 17:00:00	QQQ	ETF	94.25	94.4688	94.25	94.25	1000.0
2000-07-11 17:30:00	QQQ	ETF	94.375	94.8125	94.375	94.8125	6800.0
2000-07-11 18:00:00	QQQ	ETF	94.75	95.0	94.5	95.0	2900.0
2000-07-11 09:30:00	IWM	ETF	53.0	53.0469	53.0	53.0	6400.0
2000-07-11 10:00:00	IWM	ETF	53.0	53.0625	53.0	53.0625	5400.0
2000-07-11 11:30:00	IWM	ETF	53.2188	53.2656	53.2188	53.2656	153600.0
2000-07-11 12:30:00	IWM	ETF	53.2969	53.2969	53.2969	53.2969	40000.0
2000-07-11 13:00:00	IWM	ETF	53.2188	53.2188	53.1094	53.1094	5400.0
2000-07-11 14:00:00	IWM	ETF	52.9219	52.9219	52.9219	52.9219	200.0
2000-07-11 14:30:00	IWM	ETF	52.9531	52.9531	52.9531	52.9531	400.0
2000-07-11 15:00:00	IWM	ETF	52.8438	52.8438	52.8438	52.8438	400.0
2000-07-11 15:30:00	IWM	ETF	52.9844	53.0312	52.9688	53.0312	1200.0
2000-07-11 16:00:00	IWM	ETF	53.0312	53.0312	53.0312	53.0312	200.0
2000-07-11 09:30:00	DIA	ETF	106.4688	107.3125	106.2812	107.25	181100.0
2000-07-11 10:00:00	DIA	ETF	107.0	107.75	107.0	107.5312	191200.0
2000-07-11 10:30:00	DIA	ETF	107.4688	107.9062	107.4375	107.625	35000.0
2000-07-11 11:00:00	DIA	ETF	107.5625	108.0	107.5312	107.75	40000.0
2000-07-11 11:30:00	DIA	ETF	107.6875	107.9375	107.6562	107.8125	29200.0
2000-07-11 12:00:00	DIA	ETF	107.7188	108.2188	107.7188	108.2188	38000.0
2000-07-11 12:30:00	DIA	ETF	108.0312	108.125	107.8125	108.0	34700.0
2000-07-11 13:00:00	DIA	ETF	107.875	108.0938	107.625	107.75	83900.0

> showing 50 of 257 rows — these rows as CSV

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