PREVIEW / etf_30min / 2000-04-27

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-04-27.parquet
  size:    10 KB
  rows:    195

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-04-27 09:30:00	SPY	ETF	143.0	145.0	143.0	144.5938	1713500.0
2000-04-27 10:00:00	SPY	ETF	144.375	146.25	144.1875	145.4375	2072100.0
2000-04-27 10:30:00	SPY	ETF	145.5	145.5	144.6562	145.0	2706000.0
2000-04-27 11:00:00	SPY	ETF	144.9375	145.0312	144.0625	144.375	2065500.0
2000-04-27 11:30:00	SPY	ETF	144.4688	145.625	144.375	145.0625	904700.0
2000-04-27 12:00:00	SPY	ETF	145.25	146.2188	145.25	146.2188	504300.0
2000-04-27 12:30:00	SPY	ETF	146.1562	146.1875	145.3125	145.75	554000.0
2000-04-27 13:00:00	SPY	ETF	145.5625	145.6875	144.9375	145.1875	257700.0
2000-04-27 13:30:00	SPY	ETF	145.2812	146.125	145.1875	145.9688	435400.0
2000-04-27 14:00:00	SPY	ETF	145.8125	146.7188	145.75	146.7188	833300.0
2000-04-27 14:30:00	SPY	ETF	146.75	147.125	146.125	146.5	1263800.0
2000-04-27 15:00:00	SPY	ETF	146.625	146.875	145.8125	146.6875	872400.0
2000-04-27 15:30:00	SPY	ETF	146.625	147.3438	146.25	146.5	1025300.0
2000-04-27 16:00:00	SPY	ETF	146.4688	146.625	145.75	145.75	346600.0
2000-04-27 16:30:00	SPY	ETF	145.75	145.75	145.75	145.75	1000.0
2000-04-27 17:00:00	SPY	ETF	145.75	146.0	145.75	146.0	1000.0
2000-04-27 09:30:00	QQQ	ETF	83.5	86.875	83.5	86.25	5942000.0
2000-04-27 10:00:00	QQQ	ETF	86.25	89.125	86.0	88.0	5209000.0
2000-04-27 10:30:00	QQQ	ETF	87.875	88.5938	87.5	88.5	3014400.0
2000-04-27 11:00:00	QQQ	ETF	88.5	88.5312	87.25	87.8125	1939900.0
2000-04-27 11:30:00	QQQ	ETF	87.8438	89.625	87.8125	89.1875	2557600.0
2000-04-27 12:00:00	QQQ	ETF	89.125	90.5625	89.0	90.25	2064700.0
2000-04-27 12:30:00	QQQ	ETF	90.4688	90.625	89.4375	89.6875	1499700.0
2000-04-27 13:00:00	QQQ	ETF	89.6875	90.0	88.875	89.25	1132500.0
2000-04-27 13:30:00	QQQ	ETF	89.25	90.75	89.25	90.75	1204300.0
2000-04-27 14:00:00	QQQ	ETF	90.625	91.875	90.1875	91.875	3014500.0
2000-04-27 14:30:00	QQQ	ETF	91.875	92.375	90.875	91.375	3279300.0
2000-04-27 15:00:00	QQQ	ETF	91.5	91.7188	90.5	91.5625	2494100.0
2000-04-27 15:30:00	QQQ	ETF	91.625	92.4688	91.3125	92.25	2755000.0
2000-04-27 16:00:00	QQQ	ETF	92.0	92.25	91.25	91.3125	762700.0
2000-04-27 16:30:00	QQQ	ETF	91.25	91.5	91.25	91.375	2600.0
2000-04-27 17:00:00	QQQ	ETF	91.375	91.5	91.375	91.5	1500.0
2000-04-27 17:30:00	QQQ	ETF	91.375	91.375	91.25	91.3125	1700.0
2000-04-27 18:00:00	QQQ	ETF	91.3125	91.375	91.25	91.25	700.0
2000-04-27 09:30:00	DIA	ETF	107.0938	108.25	107.0938	107.875	300100.0
2000-04-27 10:00:00	DIA	ETF	107.9688	108.7188	107.75	108.3125	174500.0
2000-04-27 10:30:00	DIA	ETF	108.125	108.4375	107.9375	108.2188	98100.0
2000-04-27 11:00:00	DIA	ETF	108.0625	108.1562	107.3125	107.4375	118100.0
2000-04-27 11:30:00	DIA	ETF	107.5938	108.3125	107.5	107.9375	195100.0
2000-04-27 12:00:00	DIA	ETF	107.9062	108.625	107.9062	108.625	79300.0
2000-04-27 12:30:00	DIA	ETF	108.625	108.625	107.9375	108.1562	31400.0
2000-04-27 13:00:00	DIA	ETF	108.1875	108.375	107.875	108.0	17400.0
2000-04-27 13:30:00	DIA	ETF	108.0625	108.7812	107.875	108.5625	46500.0
2000-04-27 14:00:00	DIA	ETF	108.4688	109.25	108.2812	109.25	62900.0
2000-04-27 14:30:00	DIA	ETF	109.25	109.5	108.9375	109.0312	89300.0
2000-04-27 15:00:00	DIA	ETF	109.25	109.2812	108.3125	108.8125	98900.0
2000-04-27 15:30:00	DIA	ETF	108.9062	109.5	108.6875	108.6875	308000.0
2000-04-27 16:00:00	DIA	ETF	108.875	108.875	108.25	108.375	18400.0

> showing 48 of 195 rows — these rows as CSV

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