PREVIEW / etf_30min / 2000-08-31

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-08-31.parquet
  size:    11 KB
  rows:    264

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-31 09:30:00	SPY	ETF	151.0625	151.4688	150.9062	151.1875	808500.0
2000-08-31 10:00:00	SPY	ETF	151.2812	152.1562	151.2812	152.1562	639500.0
2000-08-31 10:30:00	SPY	ETF	152.0625	152.4688	152.0625	152.3438	305900.0
2000-08-31 11:00:00	SPY	ETF	152.3125	152.3125	152.125	152.1562	103600.0
2000-08-31 11:30:00	SPY	ETF	152.25	152.5	152.2188	152.25	529200.0
2000-08-31 12:00:00	SPY	ETF	152.2188	152.5625	152.1562	152.375	253300.0
2000-08-31 12:30:00	SPY	ETF	152.5	152.5312	152.1875	152.3438	313200.0
2000-08-31 13:00:00	SPY	ETF	152.25	152.4375	152.1875	152.375	115300.0
2000-08-31 13:30:00	SPY	ETF	152.375	152.75	152.375	152.6875	180100.0
2000-08-31 14:00:00	SPY	ETF	152.6875	152.9688	152.6562	152.6875	268800.0
2000-08-31 14:30:00	SPY	ETF	152.7812	152.875	152.625	152.8438	94700.0
2000-08-31 15:00:00	SPY	ETF	152.7812	153.0938	152.5	152.6875	191800.0
2000-08-31 15:30:00	SPY	ETF	152.625	152.8125	152.25	152.25	580900.0
2000-08-31 16:00:00	SPY	ETF	152.1562	152.5	152.125	152.3438	364000.0
2000-08-31 16:30:00	SPY	ETF	152.3438	152.3438	152.2812	152.2812	14000.0
2000-08-31 09:30:00	QQQ	ETF	99.625	100.0	99.5625	99.9375	2674600.0
2000-08-31 10:00:00	QQQ	ETF	99.9375	100.75	99.875	100.625	2143600.0
2000-08-31 10:30:00	QQQ	ETF	100.75	100.875	100.5	100.7188	1637700.0
2000-08-31 11:00:00	QQQ	ETF	100.6875	100.875	100.5	100.75	766900.0
2000-08-31 11:30:00	QQQ	ETF	100.75	100.8438	100.625	100.625	433000.0
2000-08-31 12:00:00	QQQ	ETF	100.625	101.0	100.625	100.9688	829500.0
2000-08-31 12:30:00	QQQ	ETF	100.9688	101.0	100.75	100.8125	381500.0
2000-08-31 13:00:00	QQQ	ETF	100.8125	101.0	100.625	100.75	308500.0
2000-08-31 13:30:00	QQQ	ETF	100.7812	101.1875	100.6875	101.0	967200.0
2000-08-31 14:00:00	QQQ	ETF	101.1875	101.4688	101.0	101.4062	986900.0
2000-08-31 14:30:00	QQQ	ETF	101.375	101.4688	101.25	101.4375	624300.0
2000-08-31 15:00:00	QQQ	ETF	101.375	101.75	101.375	101.5	1041400.0
2000-08-31 15:30:00	QQQ	ETF	101.5	101.8125	101.1875	101.6875	2074100.0
2000-08-31 16:00:00	QQQ	ETF	101.8125	101.875	101.5625	101.875	580000.0
2000-08-31 16:30:00	QQQ	ETF	101.6875	101.75	101.625	101.6875	3000.0
2000-08-31 17:00:00	QQQ	ETF	101.8125	101.875	101.6875	101.875	1800.0
2000-08-31 17:30:00	QQQ	ETF	101.625	102.0	101.625	102.0	1900.0
2000-08-31 18:00:00	QQQ	ETF	101.5	101.625	101.5	101.625	3000.0
2000-08-31 09:30:00	IWM	ETF	53.4062	53.6562	53.4062	53.6562	7000.0
2000-08-31 10:00:00	IWM	ETF	53.8438	53.8438	53.8438	53.8438	2400.0
2000-08-31 10:30:00	IWM	ETF	53.875	53.875	53.8594	53.8594	600.0
2000-08-31 11:00:00	IWM	ETF	53.875	53.9062	53.875	53.9062	400.0
2000-08-31 11:30:00	IWM	ETF	53.9844	53.9844	53.9844	53.9844	15200.0
2000-08-31 12:00:00	IWM	ETF	53.9531	53.9531	53.9531	53.9531	200.0
2000-08-31 12:30:00	IWM	ETF	53.9844	54.0	53.7969	54.0	37600.0
2000-08-31 13:30:00	IWM	ETF	53.8125	53.9688	53.8125	53.9688	1800.0
2000-08-31 14:00:00	IWM	ETF	53.9688	53.9688	53.9688	53.9688	2200.0
2000-08-31 14:30:00	IWM	ETF	54.0	54.0	53.8125	53.8125	600.0
2000-08-31 15:00:00	IWM	ETF	54.0469	54.1562	54.0469	54.1562	31600.0
2000-08-31 15:30:00	IWM	ETF	54.1562	54.1562	53.7812	53.9219	31400.0
2000-08-31 16:00:00	IWM	ETF	53.7812	53.7812	53.75	53.75	20200.0
2000-08-31 09:30:00	DIA	ETF	111.5	111.8438	111.4375	111.5625	137900.0
2000-08-31 10:00:00	DIA	ETF	111.625	112.375	111.625	112.375	110000.0
2000-08-31 10:30:00	DIA	ETF	112.5	112.7812	112.375	112.7188	74700.0
2000-08-31 11:00:00	DIA	ETF	112.7188	112.9375	112.5938	112.75	92400.0

> showing 50 of 264 rows — these rows as CSV

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