PREVIEW / etf_30min / 2000-05-16

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-05-16.parquet
  size:    10 KB
  rows:    209

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-05-16 09:30:00	SPY	ETF	146.5625	147.375	146.3438	146.9062	1929900.0
2000-05-16 10:00:00	SPY	ETF	146.9062	147.0938	146.625	147.0	559100.0
2000-05-16 10:30:00	SPY	ETF	147.0312	147.125	146.75	146.8125	166000.0
2000-05-16 11:00:00	SPY	ETF	146.9688	147.125	146.6562	147.0625	126300.0
2000-05-16 11:30:00	SPY	ETF	147.125	147.4688	147.0312	147.0625	264700.0
2000-05-16 12:00:00	SPY	ETF	147.0625	147.25	146.875	147.0312	106600.0
2000-05-16 12:30:00	SPY	ETF	147.0312	147.2188	146.875	147.0	205400.0
2000-05-16 13:00:00	SPY	ETF	147.0	147.3125	146.9375	147.125	168700.0
2000-05-16 13:30:00	SPY	ETF	147.125	147.2188	146.9375	147.0	236200.0
2000-05-16 14:00:00	SPY	ETF	147.0	147.7188	145.625	146.3438	2088100.0
2000-05-16 14:30:00	SPY	ETF	146.5	146.875	145.3125	146.875	1101500.0
2000-05-16 15:00:00	SPY	ETF	146.9688	147.375	146.4375	147.125	303100.0
2000-05-16 15:30:00	SPY	ETF	147.3125	147.4375	146.5625	147.0	272500.0
2000-05-16 16:00:00	SPY	ETF	147.0	147.125	146.6875	146.6875	353300.0
2000-05-16 16:30:00	SPY	ETF	146.5625	146.5625	146.5625	146.5625	800.0
2000-05-16 17:00:00	SPY	ETF	146.6875	146.6875	146.6875	146.6875	200.0
2000-05-16 09:30:00	QQQ	ETF	90.0	90.6875	89.8125	90.375	3750000.0
2000-05-16 10:00:00	QQQ	ETF	90.25	91.375	90.125	91.25	1426300.0
2000-05-16 10:30:00	QQQ	ETF	91.25	91.375	90.5	90.5625	942000.0
2000-05-16 11:00:00	QQQ	ETF	90.5625	90.9375	90.0	90.8125	767200.0
2000-05-16 11:30:00	QQQ	ETF	90.6875	91.125	90.625	90.7812	867000.0
2000-05-16 12:00:00	QQQ	ETF	90.6875	90.8438	90.5	90.7188	366000.0
2000-05-16 12:30:00	QQQ	ETF	90.625	90.9375	90.5	90.625	980400.0
2000-05-16 13:00:00	QQQ	ETF	90.75	91.0	90.625	90.9688	1125600.0
2000-05-16 13:30:00	QQQ	ETF	90.875	91.125	90.75	90.875	820600.0
2000-05-16 14:00:00	QQQ	ETF	90.875	91.5	88.5	89.625	4273600.0
2000-05-16 14:30:00	QQQ	ETF	89.5	90.25	88.0625	89.75	3511500.0
2000-05-16 15:00:00	QQQ	ETF	90.1875	91.0	89.375	90.6875	2106900.0
2000-05-16 15:30:00	QQQ	ETF	90.5625	91.2812	90.1875	91.125	2192400.0
2000-05-16 16:00:00	QQQ	ETF	91.125	91.25	90.75	91.0625	541200.0
2000-05-16 16:30:00	QQQ	ETF	91.1875	91.1875	91.0	91.0	6400.0
2000-05-16 17:00:00	QQQ	ETF	91.0	91.0625	91.0	91.0625	600.0
2000-05-16 17:30:00	QQQ	ETF	91.0	91.25	90.9375	91.25	800.0
2000-05-16 18:00:00	QQQ	ETF	91.0625	91.125	90.8125	90.8125	1000.0
2000-05-16 09:30:00	DIA	ETF	108.875	109.2188	108.5625	109.1875	146800.0
2000-05-16 10:00:00	DIA	ETF	109.1562	109.2188	108.75	109.1562	138200.0
2000-05-16 10:30:00	DIA	ETF	109.0625	109.3125	108.8438	109.0312	57000.0
2000-05-16 11:00:00	DIA	ETF	109.0	109.4688	109.0	109.4688	15700.0
2000-05-16 11:30:00	DIA	ETF	109.5	109.75	109.3125	109.375	33500.0
2000-05-16 12:00:00	DIA	ETF	109.5	109.6875	109.25	109.4375	51100.0
2000-05-16 12:30:00	DIA	ETF	109.3125	109.5938	109.3125	109.4688	8300.0
2000-05-16 13:00:00	DIA	ETF	109.375	109.625	109.375	109.375	9400.0
2000-05-16 13:30:00	DIA	ETF	109.375	109.5938	109.2812	109.3125	22300.0
2000-05-16 14:00:00	DIA	ETF	109.5	109.5938	108.1875	108.75	256000.0
2000-05-16 14:30:00	DIA	ETF	108.6562	109.2188	108.1875	109.0	221400.0
2000-05-16 15:00:00	DIA	ETF	109.2188	109.75	108.8438	109.3125	87200.0
2000-05-16 15:30:00	DIA	ETF	109.375	109.7812	109.0938	109.1562	102300.0
2000-05-16 16:00:00	DIA	ETF	109.1875	109.3125	109.1562	109.3125	6100.0

> showing 48 of 209 rows — these rows as CSV

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