PREVIEW / etf_30min / 2000-04-06

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-04-06.parquet
  size:    9 KB
  rows:    211

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-06 09:30:00	SPY	ETF	150.25	150.7812	149.5625	150.4688	787600.0
2000-04-06 10:00:00	SPY	ETF	150.4375	151.375	150.1562	150.875	801900.0
2000-04-06 10:30:00	SPY	ETF	151.0	151.6875	150.625	151.0312	936800.0
2000-04-06 11:00:00	SPY	ETF	151.2188	151.5	150.5312	150.75	588000.0
2000-04-06 11:30:00	SPY	ETF	150.625	151.0	150.4062	150.7188	233500.0
2000-04-06 12:00:00	SPY	ETF	150.625	150.8438	150.2812	150.6875	135300.0
2000-04-06 12:30:00	SPY	ETF	150.6875	150.6875	150.1875	150.5625	365300.0
2000-04-06 13:00:00	SPY	ETF	150.4688	150.8438	150.3438	150.75	159000.0
2000-04-06 13:30:00	SPY	ETF	150.9062	151.0	150.4688	150.4688	89300.0
2000-04-06 14:00:00	SPY	ETF	150.5625	150.875	150.0	150.0312	144900.0
2000-04-06 14:30:00	SPY	ETF	150.0	150.25	149.5312	149.5625	513300.0
2000-04-06 15:00:00	SPY	ETF	149.5	150.0	149.0	149.6875	654200.0
2000-04-06 15:30:00	SPY	ETF	149.4688	150.5	149.4062	150.3125	365100.0
2000-04-06 16:00:00	SPY	ETF	150.25	150.7188	150.1875	150.4688	568600.0
2000-04-06 09:30:00	QQQ	ETF	102.375	103.125	101.25	102.5	5500500.0
2000-04-06 10:00:00	QQQ	ETF	102.6875	103.6875	102.0	103.375	2963500.0
2000-04-06 10:30:00	QQQ	ETF	103.4375	103.75	102.5	103.25	1803200.0
2000-04-06 11:00:00	QQQ	ETF	103.0	103.875	102.25	102.25	2562000.0
2000-04-06 11:30:00	QQQ	ETF	102.6875	103.0	101.75	102.375	2006800.0
2000-04-06 12:00:00	QQQ	ETF	102.4375	103.2188	102.25	102.8125	776200.0
2000-04-06 12:30:00	QQQ	ETF	102.8125	103.125	101.9375	102.4375	1997800.0
2000-04-06 13:00:00	QQQ	ETF	102.4375	102.9688	102.0625	102.875	1351600.0
2000-04-06 13:30:00	QQQ	ETF	102.875	103.25	102.5	102.75	1132700.0
2000-04-06 14:00:00	QQQ	ETF	102.75	103.2188	101.8125	101.875	741500.0
2000-04-06 14:30:00	QQQ	ETF	102.0	102.0	100.5625	100.5625	2589900.0
2000-04-06 15:00:00	QQQ	ETF	100.625	101.375	99.75	100.75	2597200.0
2000-04-06 15:30:00	QQQ	ETF	101.0	102.5	100.625	101.8125	1919200.0
2000-04-06 16:00:00	QQQ	ETF	101.5	102.3438	101.5	102.0	2448000.0
2000-04-06 16:30:00	QQQ	ETF	102.0625	102.25	102.0	102.25	2000.0
2000-04-06 17:00:00	QQQ	ETF	102.3125	102.4375	102.25	102.4375	1300.0
2000-04-06 17:30:00	QQQ	ETF	102.5	102.5	102.5	102.5	300.0
2000-04-06 18:00:00	QQQ	ETF	102.5	102.5	102.5	102.5	100.0
2000-04-06 09:30:00	DIA	ETF	111.375	111.4375	110.6562	111.1875	97400.0
2000-04-06 10:00:00	DIA	ETF	111.2188	112.2188	111.0312	111.875	1350200.0
2000-04-06 10:30:00	DIA	ETF	111.7812	112.1562	111.5938	111.9688	354800.0
2000-04-06 11:00:00	DIA	ETF	111.7812	112.0938	111.375	111.7812	90800.0
2000-04-06 11:30:00	DIA	ETF	111.625	111.8125	111.25	111.4062	20500.0
2000-04-06 12:00:00	DIA	ETF	111.3438	111.5	111.25	111.4688	57600.0
2000-04-06 12:30:00	DIA	ETF	111.4375	111.4688	111.25	111.4375	22800.0
2000-04-06 13:00:00	DIA	ETF	111.5	111.6875	111.375	111.5938	9300.0
2000-04-06 13:30:00	DIA	ETF	111.6562	111.7188	111.375	111.4375	30400.0
2000-04-06 14:00:00	DIA	ETF	111.2812	111.5	110.9375	110.9375	81300.0
2000-04-06 14:30:00	DIA	ETF	110.9375	111.125	110.5938	110.7188	109000.0
2000-04-06 15:00:00	DIA	ETF	110.875	110.9688	110.375	110.6875	25300.0
2000-04-06 15:30:00	DIA	ETF	110.5625	111.375	110.5625	111.2188	28300.0
2000-04-06 16:00:00	DIA	ETF	111.25	111.4062	111.25	111.4062	2000.0

> showing 46 of 211 rows — these rows as CSV

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