PREVIEW / etf_30min / 2000-03-23

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-03-23.parquet
  size:    10 KB
  rows:    227

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-03-23 09:30:00	SPY	ETF	149.1562	150.2188	149.1562	149.875	912800.0
2000-03-23 10:00:00	SPY	ETF	150.0	150.0938	149.375	149.5	973900.0
2000-03-23 10:30:00	SPY	ETF	149.5625	150.8125	149.5625	150.625	358600.0
2000-03-23 11:00:00	SPY	ETF	150.4375	150.625	150.1875	150.375	258400.0
2000-03-23 11:30:00	SPY	ETF	150.25	150.625	150.0	150.5	809900.0
2000-03-23 12:00:00	SPY	ETF	150.3438	151.25	150.3438	151.1875	614200.0
2000-03-23 12:30:00	SPY	ETF	151.1875	152.125	151.0	152.0	909700.0
2000-03-23 13:00:00	SPY	ETF	152.0	152.4688	151.8125	152.25	1284900.0
2000-03-23 13:30:00	SPY	ETF	152.25	153.0938	151.875	153.0	935300.0
2000-03-23 14:00:00	SPY	ETF	153.0312	153.4688	151.9375	153.4375	1231200.0
2000-03-23 14:30:00	SPY	ETF	153.375	153.4375	152.625	153.0	573200.0
2000-03-23 15:00:00	SPY	ETF	153.2188	153.375	152.625	152.9062	754500.0
2000-03-23 15:30:00	SPY	ETF	152.8125	153.0	152.4375	152.625	554100.0
2000-03-23 16:00:00	SPY	ETF	152.625	153.1562	152.5	152.5	1106300.0
2000-03-23 17:00:00	SPY	ETF	152.6562	152.6562	152.6562	152.6562	600.0
2000-03-23 09:30:00	QQQ	ETF	114.4688	115.75	113.5625	115.375	2052800.0
2000-03-23 10:00:00	QQQ	ETF	115.0625	115.6875	114.0	114.9688	1886800.0
2000-03-23 10:30:00	QQQ	ETF	114.9688	115.9375	114.375	115.6875	1338100.0
2000-03-23 11:00:00	QQQ	ETF	115.5	115.6875	114.625	114.75	1483100.0
2000-03-23 11:30:00	QQQ	ETF	114.875	115.3438	114.5	115.3438	726100.0
2000-03-23 12:00:00	QQQ	ETF	115.25	115.875	115.1875	115.4375	581200.0
2000-03-23 12:30:00	QQQ	ETF	115.5	116.5	115.25	116.4375	976200.0
2000-03-23 13:00:00	QQQ	ETF	116.4375	117.2188	116.25	116.8125	2567200.0
2000-03-23 13:30:00	QQQ	ETF	116.875	117.7188	116.25	117.6875	1749400.0
2000-03-23 14:00:00	QQQ	ETF	117.6875	117.75	116.375	117.5625	1476600.0
2000-03-23 14:30:00	QQQ	ETF	117.25	117.4688	116.375	117.2188	1251500.0
2000-03-23 15:00:00	QQQ	ETF	117.2188	117.4688	116.625	116.75	853300.0
2000-03-23 15:30:00	QQQ	ETF	116.6875	116.875	115.6875	116.5	1283700.0
2000-03-23 16:00:00	QQQ	ETF	116.4688	116.625	116.0312	116.625	933200.0
2000-03-23 16:30:00	QQQ	ETF	116.75	116.75	116.5	116.5	300.0
2000-03-23 17:00:00	QQQ	ETF	117.0	117.0	116.375	116.375	600.0
2000-03-23 17:30:00	QQQ	ETF	116.375	116.375	116.375	116.375	100.0
2000-03-23 18:00:00	QQQ	ETF	116.5	116.5	116.0	116.0	300.0
2000-03-23 09:30:00	DIA	ETF	108.375	109.0625	108.25	108.9062	220400.0
2000-03-23 10:00:00	DIA	ETF	108.7812	108.875	108.4375	108.4688	139600.0
2000-03-23 10:30:00	DIA	ETF	108.625	109.5625	108.5625	109.25	146300.0
2000-03-23 11:00:00	DIA	ETF	109.1875	109.4688	109.0625	109.25	88400.0
2000-03-23 11:30:00	DIA	ETF	109.0	109.1875	108.7812	108.875	60100.0
2000-03-23 12:00:00	DIA	ETF	108.9375	109.6875	108.9375	109.6562	102500.0
2000-03-23 12:30:00	DIA	ETF	109.6562	110.4688	109.5	110.4688	190600.0
2000-03-23 13:00:00	DIA	ETF	110.3125	110.5938	110.0625	110.25	112000.0
2000-03-23 13:30:00	DIA	ETF	110.4375	110.875	110.125	110.8125	62800.0
2000-03-23 14:00:00	DIA	ETF	110.625	111.0625	109.875	111.0625	113700.0
2000-03-23 14:30:00	DIA	ETF	110.9375	111.1875	110.5312	110.9062	307900.0
2000-03-23 15:00:00	DIA	ETF	111.0938	111.5	110.75	111.1562	148600.0
2000-03-23 15:30:00	DIA	ETF	111.0938	111.25	110.75	111.0	131800.0
2000-03-23 16:00:00	DIA	ETF	111.0625	111.1875	110.9688	111.125	54000.0

> showing 47 of 227 rows — these rows as CSV

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