PREVIEW / etf_30min / 2000-08-02

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-08-02.parquet
  size:    11 KB
  rows:    277

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-02 09:30:00	SPY	ETF	143.875	144.375	143.625	144.25	1432700.0
2000-08-02 10:00:00	SPY	ETF	144.3125	145.25	144.3125	145.0	983400.0
2000-08-02 10:30:00	SPY	ETF	144.875	145.375	144.75	145.375	264800.0
2000-08-02 11:00:00	SPY	ETF	145.3125	145.375	144.9062	145.375	487600.0
2000-08-02 11:30:00	SPY	ETF	145.375	145.375	144.9062	145.0625	598700.0
2000-08-02 12:00:00	SPY	ETF	145.0	145.25	145.0	145.1875	236700.0
2000-08-02 12:30:00	SPY	ETF	145.25	145.375	145.125	145.3438	206000.0
2000-08-02 13:00:00	SPY	ETF	145.3438	145.4062	145.0	145.0	367800.0
2000-08-02 13:30:00	SPY	ETF	145.0312	145.125	144.7188	145.0	414200.0
2000-08-02 14:00:00	SPY	ETF	145.0	145.2188	144.9375	145.0312	269700.0
2000-08-02 14:30:00	SPY	ETF	145.0625	145.1562	144.75	144.8125	434200.0
2000-08-02 15:00:00	SPY	ETF	144.9688	145.1875	144.5	144.8438	542100.0
2000-08-02 15:30:00	SPY	ETF	144.875	144.9375	144.1562	144.25	666500.0
2000-08-02 16:00:00	SPY	ETF	144.3125	144.5938	144.1875	144.5938	383700.0
2000-08-02 09:30:00	QQQ	ETF	87.875	88.0	86.9375	87.5312	2983700.0
2000-08-02 10:00:00	QQQ	ETF	87.5625	89.75	87.4375	89.3125	3322200.0
2000-08-02 10:30:00	QQQ	ETF	89.25	90.0	88.75	90.0	1687600.0
2000-08-02 11:00:00	QQQ	ETF	89.875	90.375	89.5625	90.1875	3212800.0
2000-08-02 11:30:00	QQQ	ETF	90.125	90.125	89.625	89.625	595700.0
2000-08-02 12:00:00	QQQ	ETF	89.625	90.0	89.5625	89.875	500000.0
2000-08-02 12:30:00	QQQ	ETF	89.8125	90.0938	89.75	89.9375	567900.0
2000-08-02 13:00:00	QQQ	ETF	89.9375	90.0	89.3125	89.4375	740700.0
2000-08-02 13:30:00	QQQ	ETF	89.375	89.4688	88.7188	89.25	896300.0
2000-08-02 14:00:00	QQQ	ETF	89.25	89.5312	88.875	89.125	1295600.0
2000-08-02 14:30:00	QQQ	ETF	89.0625	89.3125	88.4375	88.5625	1618700.0
2000-08-02 15:00:00	QQQ	ETF	88.5	88.875	87.5	88.2188	2372000.0
2000-08-02 15:30:00	QQQ	ETF	88.125	88.3438	86.875	87.0938	2849500.0
2000-08-02 16:00:00	QQQ	ETF	87.0938	87.125	86.5	86.75	852200.0
2000-08-02 16:30:00	QQQ	ETF	86.75	86.875	86.6875	86.6875	3800.0
2000-08-02 17:00:00	QQQ	ETF	86.6875	86.75	86.6875	86.75	500.0
2000-08-02 17:30:00	QQQ	ETF	86.875	86.875	86.75	86.875	700.0
2000-08-02 18:00:00	QQQ	ETF	86.75	86.75	86.6875	86.6875	3400.0
2000-08-02 10:00:00	IWM	ETF	49.625	50.1875	49.5	49.875	24600.0
2000-08-02 10:30:00	IWM	ETF	49.9062	49.9062	49.9062	49.9062	2000.0
2000-08-02 11:00:00	IWM	ETF	50.0312	50.1406	50.0312	50.1406	600.0
2000-08-02 11:30:00	IWM	ETF	50.1875	50.1875	50.1875	50.1875	800.0
2000-08-02 12:00:00	IWM	ETF	50.1562	50.2031	50.0938	50.0938	1400.0
2000-08-02 12:30:00	IWM	ETF	50.2031	50.2031	50.2031	50.2031	600.0
2000-08-02 13:00:00	IWM	ETF	50.2812	50.2812	50.25	50.25	600.0
2000-08-02 13:30:00	IWM	ETF	50.2188	50.2188	49.9688	49.9688	41600.0
2000-08-02 14:00:00	IWM	ETF	50.0781	50.0781	50.0781	50.0781	1400.0
2000-08-02 15:00:00	IWM	ETF	49.8438	50.0156	49.8438	50.0156	2600.0
2000-08-02 15:30:00	IWM	ETF	50.1094	50.1094	49.9219	49.9219	400.0
2000-08-02 16:00:00	IWM	ETF	49.9062	50.0	49.9062	50.0	312000.0
2000-08-02 09:30:00	DIA	ETF	105.9062	106.625	105.875	106.5938	231600.0
2000-08-02 10:00:00	DIA	ETF	106.875	107.125	106.6875	106.75	164900.0
2000-08-02 10:30:00	DIA	ETF	106.75	107.0	106.625	106.8438	7700.0
2000-08-02 11:00:00	DIA	ETF	106.8438	106.9688	106.625	106.875	12600.0
2000-08-02 11:30:00	DIA	ETF	106.875	106.9375	106.6562	106.8438	65000.0
2000-08-02 12:00:00	DIA	ETF	106.75	107.0625	106.75	106.9688	14700.0

> showing 50 of 277 rows — these rows as CSV

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