PREVIEW / etf_30min / 2000-09-01

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-09-01.parquet
  size:    11 KB
  rows:    298

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-01 09:30:00	SPY	ETF	153.25	153.25	152.6875	152.9062	413600.0
2000-09-01 10:00:00	SPY	ETF	152.9062	153.5938	152.3125	152.375	636600.0
2000-09-01 10:30:00	SPY	ETF	152.4375	152.6875	152.0	152.5938	414000.0
2000-09-01 11:00:00	SPY	ETF	152.5625	152.8438	152.5	152.8438	128100.0
2000-09-01 11:30:00	SPY	ETF	152.75	152.9688	152.7188	152.8438	140300.0
2000-09-01 12:00:00	SPY	ETF	152.7812	152.9062	152.6875	152.8125	84000.0
2000-09-01 12:30:00	SPY	ETF	152.875	153.0938	152.7188	153.0938	87400.0
2000-09-01 13:00:00	SPY	ETF	153.0625	153.125	152.625	152.75	36400.0
2000-09-01 13:30:00	SPY	ETF	152.75	152.75	152.4375	152.5	105100.0
2000-09-01 14:00:00	SPY	ETF	152.5	152.7812	152.375	152.625	107800.0
2000-09-01 14:30:00	SPY	ETF	152.625	152.6875	152.25	152.25	139300.0
2000-09-01 15:00:00	SPY	ETF	152.3438	152.5	152.3125	152.4062	184200.0
2000-09-01 15:30:00	SPY	ETF	152.5	152.5938	152.1875	152.5625	441400.0
2000-09-01 16:00:00	SPY	ETF	152.5	152.6562	152.375	152.375	230200.0
2000-09-01 16:30:00	SPY	ETF	152.5	152.5	152.5	152.5	30000.0
2000-09-01 09:30:00	QQQ	ETF	103.0	103.25	102.5625	102.8438	3008200.0
2000-09-01 10:00:00	QQQ	ETF	102.875	103.5	101.9375	102.0	2399800.0
2000-09-01 10:30:00	QQQ	ETF	101.9375	102.1562	101.1875	102.0625	2420700.0
2000-09-01 11:00:00	QQQ	ETF	102.0312	102.25	101.875	102.2188	926500.0
2000-09-01 11:30:00	QQQ	ETF	102.1875	102.75	102.125	102.4062	1002900.0
2000-09-01 12:00:00	QQQ	ETF	102.4688	102.5	102.25	102.375	667500.0
2000-09-01 12:30:00	QQQ	ETF	102.375	102.5	102.0625	102.4375	433900.0
2000-09-01 13:00:00	QQQ	ETF	102.4375	102.4688	102.0625	102.1875	221400.0
2000-09-01 13:30:00	QQQ	ETF	102.25	102.25	101.625	101.8438	515500.0
2000-09-01 14:00:00	QQQ	ETF	101.7812	102.2188	101.625	102.2188	299600.0
2000-09-01 14:30:00	QQQ	ETF	102.2188	102.25	101.6875	101.7812	435600.0
2000-09-01 15:00:00	QQQ	ETF	101.8125	102.1875	101.75	102.0938	366600.0
2000-09-01 15:30:00	QQQ	ETF	102.0625	102.375	102.0	102.3125	963700.0
2000-09-01 16:00:00	QQQ	ETF	102.375	102.5	102.1875	102.5	338900.0
2000-09-01 16:30:00	QQQ	ETF	102.0	102.5625	102.0	102.3125	1600.0
2000-09-01 17:00:00	QQQ	ETF	102.625	102.625	102.625	102.625	500.0
2000-09-01 09:30:00	IWM	ETF	54.0	54.2188	54.0	54.0625	113200.0
2000-09-01 10:00:00	IWM	ETF	53.875	54.0625	53.875	53.9375	4800.0
2000-09-01 10:30:00	IWM	ETF	53.9531	53.9531	53.7344	53.7344	2400.0
2000-09-01 11:00:00	IWM	ETF	53.8906	53.8906	53.8906	53.8906	400.0
2000-09-01 11:30:00	IWM	ETF	54.0	54.0	54.0	54.0	1800.0
2000-09-01 12:00:00	IWM	ETF	53.9531	53.9531	53.9531	53.9531	200.0
2000-09-01 12:30:00	IWM	ETF	54.0	54.0	54.0	54.0	12400.0
2000-09-01 13:00:00	IWM	ETF	54.0	54.0	54.0	54.0	600.0
2000-09-01 13:30:00	IWM	ETF	54.0625	54.0625	54.0	54.0	2200.0
2000-09-01 14:00:00	IWM	ETF	53.9688	53.9688	53.9688	53.9688	14000.0
2000-09-01 14:30:00	IWM	ETF	54.1562	54.1562	54.1562	54.1562	4000.0
2000-09-01 15:00:00	IWM	ETF	54.1875	54.2812	54.1875	54.2812	6800.0
2000-09-01 15:30:00	IWM	ETF	54.125	54.2812	54.125	54.1875	4200.0
2000-09-01 16:00:00	IWM	ETF	54.2812	54.2812	54.1875	54.1875	19800.0
2000-09-01 09:30:00	DIA	ETF	112.9375	113.0	112.4688	112.6562	37400.0
2000-09-01 10:00:00	DIA	ETF	112.75	113.25	112.4688	112.4688	92900.0
2000-09-01 10:30:00	DIA	ETF	112.5938	112.8438	112.3125	112.6562	28200.0
2000-09-01 11:00:00	DIA	ETF	112.625	112.8438	112.625	112.8125	25600.0
2000-09-01 11:30:00	DIA	ETF	112.8125	113.0	112.8125	112.8125	20100.0

> showing 50 of 298 rows — these rows as CSV

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