PREVIEW / etf_30min / 2000-09-05

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-09-05.parquet
  size:    11 KB
  rows:    303

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-05 09:30:00	SPY	ETF	151.875	152.1875	151.5938	152.0312	671200.0
2000-09-05 10:00:00	SPY	ETF	152.0312	152.125	151.375	151.5	351900.0
2000-09-05 10:30:00	SPY	ETF	151.5	151.5	151.0	151.2812	452500.0
2000-09-05 11:00:00	SPY	ETF	151.25	151.2812	151.0625	151.25	110300.0
2000-09-05 11:30:00	SPY	ETF	151.1875	151.4062	151.0312	151.1875	84000.0
2000-09-05 12:00:00	SPY	ETF	151.125	151.3438	151.0312	151.3438	136600.0
2000-09-05 12:30:00	SPY	ETF	151.3438	151.3438	151.0625	151.125	141000.0
2000-09-05 13:00:00	SPY	ETF	151.25	151.4688	151.125	151.4062	158100.0
2000-09-05 13:30:00	SPY	ETF	151.5	151.6875	151.4062	151.5	87900.0
2000-09-05 14:00:00	SPY	ETF	151.4688	151.5	151.1562	151.4688	121400.0
2000-09-05 14:30:00	SPY	ETF	151.375	151.4375	151.0312	151.0312	62100.0
2000-09-05 15:00:00	SPY	ETF	151.0938	151.2188	150.8125	151.1875	447200.0
2000-09-05 15:30:00	SPY	ETF	151.1562	151.3438	151.0312	151.25	247000.0
2000-09-05 16:00:00	SPY	ETF	151.1875	151.4062	151.0625	151.2812	287200.0
2000-09-05 16:30:00	SPY	ETF	151.2812	151.2812	151.2812	151.2812	700.0
2000-09-05 09:30:00	QQQ	ETF	101.625	101.75	101.125	101.5	2357200.0
2000-09-05 10:00:00	QQQ	ETF	101.625	101.6562	100.375	100.5	2490500.0
2000-09-05 10:30:00	QQQ	ETF	100.5	101.0	100.0312	100.9062	1997300.0
2000-09-05 11:00:00	QQQ	ETF	100.875	100.875	100.4375	100.6875	705800.0
2000-09-05 11:30:00	QQQ	ETF	100.625	100.8125	100.1875	100.3125	605000.0
2000-09-05 12:00:00	QQQ	ETF	100.3438	100.7188	100.125	100.6562	652900.0
2000-09-05 12:30:00	QQQ	ETF	100.6562	100.6875	100.1875	100.3438	365700.0
2000-09-05 13:00:00	QQQ	ETF	100.375	100.625	100.1875	100.5625	726500.0
2000-09-05 13:30:00	QQQ	ETF	100.5625	100.875	100.4375	100.6562	949800.0
2000-09-05 14:00:00	QQQ	ETF	100.5938	100.6562	100.25	100.4062	647100.0
2000-09-05 14:30:00	QQQ	ETF	100.375	100.4375	99.875	100.0	1197700.0
2000-09-05 15:00:00	QQQ	ETF	99.9375	100.25	99.6562	100.2188	1353300.0
2000-09-05 15:30:00	QQQ	ETF	100.2812	100.2812	99.4062	99.5938	1704200.0
2000-09-05 16:00:00	QQQ	ETF	99.625	99.8438	99.5	99.625	484900.0
2000-09-05 16:30:00	QQQ	ETF	99.625	99.75	99.5625	99.5625	1100.0
2000-09-05 17:30:00	QQQ	ETF	99.875	99.875	99.875	99.875	1700.0
2000-09-05 18:00:00	QQQ	ETF	99.5	99.5	99.5	99.5	300.0
2000-09-05 09:30:00	IWM	ETF	54.1094	54.1094	54.0469	54.0469	2200.0
2000-09-05 10:00:00	IWM	ETF	54.2031	54.2031	54.0625	54.0625	2800.0
2000-09-05 10:30:00	IWM	ETF	53.9531	54.0156	53.9531	54.0156	1000.0
2000-09-05 11:00:00	IWM	ETF	54.0469	54.0469	54.0469	54.0469	1000.0
2000-09-05 12:00:00	IWM	ETF	54.0625	54.0625	54.0625	54.0625	30000.0
2000-09-05 12:30:00	IWM	ETF	54.1562	54.1562	54.1562	54.1562	1400.0
2000-09-05 13:00:00	IWM	ETF	54.1562	54.1562	54.0938	54.0938	9800.0
2000-09-05 13:30:00	IWM	ETF	54.125	54.2812	54.125	54.2812	21800.0
2000-09-05 14:00:00	IWM	ETF	54.2344	54.2344	54.125	54.125	3200.0
2000-09-05 14:30:00	IWM	ETF	54.2812	54.2812	54.2031	54.2031	3800.0
2000-09-05 15:00:00	IWM	ETF	54.1562	54.1875	54.1562	54.1875	5800.0
2000-09-05 15:30:00	IWM	ETF	54.0156	54.0625	53.9375	54.0469	27200.0
2000-09-05 16:00:00	IWM	ETF	53.8125	53.8125	53.8125	53.8125	400.0
2000-09-05 09:30:00	DIA	ETF	111.9375	112.625	111.9375	112.5	69100.0
2000-09-05 10:00:00	DIA	ETF	112.625	112.6562	112.0625	112.1875	111700.0
2000-09-05 10:30:00	DIA	ETF	112.125	112.2188	111.8125	112.125	27100.0
2000-09-05 11:00:00	DIA	ETF	112.0	112.25	112.0	112.125	11700.0
2000-09-05 11:30:00	DIA	ETF	112.125	112.4375	112.125	112.25	13300.0

> showing 50 of 303 rows — these rows as CSV

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