PREVIEW / etf_30min / 2000-08-04

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-08-04.parquet
  size:    11 KB
  rows:    281

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-04 09:30:00	SPY	ETF	146.3125	146.5625	145.8438	146.0625	709800.0
2000-08-04 10:00:00	SPY	ETF	146.0	146.5312	145.8438	146.0938	284900.0
2000-08-04 10:30:00	SPY	ETF	146.1562	146.25	145.4062	145.625	387900.0
2000-08-04 11:00:00	SPY	ETF	145.5	146.0	145.4688	145.9688	176800.0
2000-08-04 11:30:00	SPY	ETF	146.0312	146.2188	145.8438	146.0625	67700.0
2000-08-04 12:00:00	SPY	ETF	146.0625	146.25	145.625	145.9062	54900.0
2000-08-04 12:30:00	SPY	ETF	145.75	146.125	145.7188	146.0938	80600.0
2000-08-04 13:00:00	SPY	ETF	146.125	146.3125	145.875	146.125	165600.0
2000-08-04 13:30:00	SPY	ETF	146.125	146.125	145.75	146.0938	99500.0
2000-08-04 14:00:00	SPY	ETF	146.0625	146.5312	145.9375	146.125	112000.0
2000-08-04 14:30:00	SPY	ETF	146.25	146.625	146.0938	146.1875	174200.0
2000-08-04 15:00:00	SPY	ETF	146.2188	146.2812	145.625	146.1875	743400.0
2000-08-04 15:30:00	SPY	ETF	146.25	146.7188	146.0938	146.5312	314000.0
2000-08-04 16:00:00	SPY	ETF	146.4375	146.5938	146.3438	146.375	264700.0
2000-08-04 16:30:00	SPY	ETF	146.375	146.375	146.375	146.375	600.0
2000-08-04 09:30:00	QQQ	ETF	92.0	92.75	91.0625	92.0312	5295400.0
2000-08-04 10:00:00	QQQ	ETF	92.125	92.625	91.375	91.4375	2478200.0
2000-08-04 10:30:00	QQQ	ETF	91.375	91.625	89.875	90.3438	2696600.0
2000-08-04 11:00:00	QQQ	ETF	90.3438	91.25	90.0625	90.8125	1478800.0
2000-08-04 11:30:00	QQQ	ETF	90.875	91.125	90.5625	90.9688	764500.0
2000-08-04 12:00:00	QQQ	ETF	90.9375	90.9375	89.5	89.9375	1356300.0
2000-08-04 12:30:00	QQQ	ETF	89.9688	90.4688	89.75	90.125	907600.0
2000-08-04 13:00:00	QQQ	ETF	90.1875	90.375	89.5625	89.75	700900.0
2000-08-04 13:30:00	QQQ	ETF	89.6875	89.8125	89.125	89.7188	1191600.0
2000-08-04 14:00:00	QQQ	ETF	89.6562	90.4062	89.25	90.1875	998100.0
2000-08-04 14:30:00	QQQ	ETF	90.0625	90.875	89.9375	90.1562	1226000.0
2000-08-04 15:00:00	QQQ	ETF	89.9375	90.0938	89.125	89.8125	1165700.0
2000-08-04 15:30:00	QQQ	ETF	89.875	90.4688	89.5	90.25	1439700.0
2000-08-04 16:00:00	QQQ	ETF	90.2188	90.3125	89.9375	90.0	540800.0
2000-08-04 16:30:00	QQQ	ETF	90.0	90.1875	90.0	90.1875	1200.0
2000-08-04 17:00:00	QQQ	ETF	90.125	90.125	90.125	90.125	200.0
2000-08-04 17:30:00	QQQ	ETF	90.125	90.125	90.125	90.125	400.0
2000-08-04 18:00:00	QQQ	ETF	90.125	90.125	90.125	90.125	200.0
2000-08-04 09:30:00	IWM	ETF	50.5625	50.5781	50.25	50.25	142600.0
2000-08-04 10:00:00	IWM	ETF	50.3906	50.4375	50.3438	50.3438	5200.0
2000-08-04 10:30:00	IWM	ETF	50.1875	50.1875	50.0	50.0	6000.0
2000-08-04 11:00:00	IWM	ETF	50.0938	50.0938	49.9219	49.9219	800.0
2000-08-04 11:30:00	IWM	ETF	50.2344	50.2344	50.0781	50.0781	600.0
2000-08-04 12:00:00	IWM	ETF	50.0938	50.0938	50.0938	50.0938	2000.0
2000-08-04 12:30:00	IWM	ETF	50.125	50.125	50.125	50.125	10000.0
2000-08-04 13:30:00	IWM	ETF	50.125	50.125	50.125	50.125	400.0
2000-08-04 14:00:00	IWM	ETF	50.25	50.4062	50.25	50.3906	8800.0
2000-08-04 14:30:00	IWM	ETF	50.3906	50.3906	50.25	50.25	10200.0
2000-08-04 15:00:00	IWM	ETF	50.25	50.2969	50.2344	50.2969	9400.0
2000-08-04 15:30:00	IWM	ETF	50.1875	50.4062	50.1875	50.4062	321600.0
2000-08-04 16:00:00	IWM	ETF	50.3438	50.3438	50.2188	50.2188	52800.0
2000-08-04 09:30:00	DIA	ETF	107.125	107.375	106.625	106.875	46800.0
2000-08-04 10:00:00	DIA	ETF	106.6875	107.2188	106.6875	106.9375	112900.0
2000-08-04 10:30:00	DIA	ETF	106.9375	107.0938	106.75	106.875	13100.0
2000-08-04 11:00:00	DIA	ETF	106.8125	107.0625	106.75	106.9688	516100.0

> showing 50 of 281 rows — these rows as CSV

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