PREVIEW / etf_30min / 2000-06-28

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-06-28.parquet
  size:    11 KB
  rows:    254

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-06-28 09:30:00	SPY	ETF	145.625	145.8438	145.4375	145.7188	220600.0
2000-06-28 10:00:00	SPY	ETF	145.8438	146.0312	145.625	145.875	252300.0
2000-06-28 10:30:00	SPY	ETF	145.8125	145.875	145.5312	145.6562	126300.0
2000-06-28 11:00:00	SPY	ETF	145.5	145.6875	145.4375	145.5938	141900.0
2000-06-28 11:30:00	SPY	ETF	145.5312	145.8438	145.5	145.8438	104100.0
2000-06-28 12:00:00	SPY	ETF	145.9688	146.1562	145.75	146.125	307000.0
2000-06-28 12:30:00	SPY	ETF	146.1875	146.1875	145.875	145.875	52600.0
2000-06-28 13:00:00	SPY	ETF	146.0	146.1875	145.875	146.0312	32500.0
2000-06-28 13:30:00	SPY	ETF	145.9375	146.25	145.7812	146.1562	101800.0
2000-06-28 14:00:00	SPY	ETF	146.2188	146.8125	146.0312	146.6562	836700.0
2000-06-28 14:30:00	SPY	ETF	146.8125	146.9688	146.2812	146.625	785800.0
2000-06-28 15:00:00	SPY	ETF	146.5625	146.875	146.4062	146.5312	203200.0
2000-06-28 15:30:00	SPY	ETF	146.4375	146.625	145.3125	145.625	561800.0
2000-06-28 16:00:00	SPY	ETF	145.5938	145.75	145.375	145.5625	541200.0
2000-06-28 09:30:00	QQQ	ETF	92.9688	93.5	92.5	93.375	1864100.0
2000-06-28 10:00:00	QQQ	ETF	93.3125	94.25	93.3125	94.125	1954900.0
2000-06-28 10:30:00	QQQ	ETF	94.1875	94.25	93.5312	93.625	809300.0
2000-06-28 11:00:00	QQQ	ETF	93.5625	94.0	93.5	93.9375	818000.0
2000-06-28 11:30:00	QQQ	ETF	94.0	94.5625	93.7188	94.5	710100.0
2000-06-28 12:00:00	QQQ	ETF	94.4375	94.5625	94.1562	94.4062	530500.0
2000-06-28 12:30:00	QQQ	ETF	94.375	94.5	94.125	94.3125	398700.0
2000-06-28 13:00:00	QQQ	ETF	94.1875	94.5	94.0	94.125	625200.0
2000-06-28 13:30:00	QQQ	ETF	94.125	94.375	94.0	94.375	662700.0
2000-06-28 14:00:00	QQQ	ETF	94.375	95.5	93.5	94.625	2762200.0
2000-06-28 14:30:00	QQQ	ETF	94.625	95.25	94.375	94.875	2332500.0
2000-06-28 15:00:00	QQQ	ETF	94.8125	95.375	94.5625	95.375	1826600.0
2000-06-28 15:30:00	QQQ	ETF	95.125	95.1875	93.5625	94.125	2872200.0
2000-06-28 16:00:00	QQQ	ETF	94.125	94.375	93.875	93.875	529300.0
2000-06-28 16:30:00	QQQ	ETF	94.5	94.5	94.25	94.25	1500.0
2000-06-28 17:00:00	QQQ	ETF	94.0	94.25	94.0	94.25	600.0
2000-06-28 17:30:00	QQQ	ETF	94.0	94.0	94.0	94.0	200.0
2000-06-28 18:00:00	QQQ	ETF	93.875	94.0	93.875	94.0	400.0
2000-06-28 09:30:00	IWM	ETF	50.9375	50.9375	50.9375	50.9375	1000.0
2000-06-28 10:00:00	IWM	ETF	51.2188	51.2188	51.2188	51.2188	1000.0
2000-06-28 10:30:00	IWM	ETF	51.2031	51.2031	51.0938	51.1094	9000.0
2000-06-28 11:30:00	IWM	ETF	51.0625	51.0625	51.0625	51.0625	10000.0
2000-06-28 12:00:00	IWM	ETF	51.25	51.3125	51.25	51.3125	2600.0
2000-06-28 12:30:00	IWM	ETF	51.3906	51.3906	51.2188	51.2188	6400.0
2000-06-28 13:00:00	IWM	ETF	51.1562	51.4062	51.1562	51.4062	3600.0
2000-06-28 13:30:00	IWM	ETF	51.4219	51.4688	51.4219	51.4375	5000.0
2000-06-28 14:00:00	IWM	ETF	51.5	51.6562	51.375	51.5469	12200.0
2000-06-28 14:30:00	IWM	ETF	51.5625	51.7969	51.5625	51.6875	7400.0
2000-06-28 15:00:00	IWM	ETF	51.8281	52.1875	51.8281	52.1875	5200.0
2000-06-28 15:30:00	IWM	ETF	52.0625	52.0625	51.625	51.75	84800.0
2000-06-28 16:00:00	IWM	ETF	51.9375	52.0	51.9375	52.0	22400.0
2000-06-28 09:30:00	DIA	ETF	105.75	105.8125	105.375	105.4688	78100.0
2000-06-28 10:00:00	DIA	ETF	105.625	105.6562	105.3125	105.4688	5200.0
2000-06-28 10:30:00	DIA	ETF	105.5312	105.5312	105.1562	105.375	12700.0
2000-06-28 11:00:00	DIA	ETF	105.375	105.5625	105.1562	105.4375	34300.0
2000-06-28 11:30:00	DIA	ETF	105.4375	105.75	105.375	105.75	9200.0

> showing 50 of 254 rows — these rows as CSV

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