PREVIEW / etf_30min / 2000-07-21

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-21.parquet
  size:    10 KB
  rows:    246

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-07-21 09:30:00	SPY	ETF	149.75	149.75	149.2812	149.5	750500.0
2000-07-21 10:00:00	SPY	ETF	149.5625	149.5625	148.625	148.9375	594100.0
2000-07-21 10:30:00	SPY	ETF	149.0	149.0	148.2812	148.5	397900.0
2000-07-21 11:00:00	SPY	ETF	148.4375	148.8125	148.375	148.375	107500.0
2000-07-21 11:30:00	SPY	ETF	148.5	148.75	148.4375	148.7188	167700.0
2000-07-21 12:00:00	SPY	ETF	148.75	148.9375	148.6562	148.9062	138100.0
2000-07-21 12:30:00	SPY	ETF	148.75	148.9062	148.5312	148.5625	208000.0
2000-07-21 13:00:00	SPY	ETF	148.5625	148.7812	148.5312	148.75	53100.0
2000-07-21 13:30:00	SPY	ETF	148.7188	148.7188	147.875	148.0	158900.0
2000-07-21 14:00:00	SPY	ETF	148.0312	148.2812	148.0	148.125	608500.0
2000-07-21 14:30:00	SPY	ETF	148.1875	148.4688	148.0625	148.2188	595700.0
2000-07-21 15:00:00	SPY	ETF	148.25	148.6875	148.125	148.6562	287500.0
2000-07-21 15:30:00	SPY	ETF	148.6562	148.9062	148.1875	148.25	992500.0
2000-07-21 16:00:00	SPY	ETF	148.1875	148.375	147.6875	147.6875	595400.0
2000-07-21 16:30:00	SPY	ETF	147.6875	147.6875	147.6875	147.6875	1000.0
2000-07-21 09:30:00	QQQ	ETF	98.4375	99.1875	98.4375	98.75	2258000.0
2000-07-21 10:00:00	QQQ	ETF	98.75	98.75	97.5	97.9375	2184100.0
2000-07-21 10:30:00	QQQ	ETF	97.9375	98.0	97.125	97.5	1722100.0
2000-07-21 11:00:00	QQQ	ETF	97.5625	97.875	97.4375	97.625	990100.0
2000-07-21 11:30:00	QQQ	ETF	97.6875	98.0938	97.5	98.0938	969100.0
2000-07-21 12:00:00	QQQ	ETF	98.0938	98.625	98.0	98.5625	923800.0
2000-07-21 12:30:00	QQQ	ETF	98.5625	98.6875	98.0625	98.1875	839700.0
2000-07-21 13:00:00	QQQ	ETF	98.1875	98.4375	98.0	98.125	239100.0
2000-07-21 13:30:00	QQQ	ETF	98.125	98.2188	97.5	97.6562	545400.0
2000-07-21 14:00:00	QQQ	ETF	97.625	98.125	97.5	97.625	347500.0
2000-07-21 14:30:00	QQQ	ETF	97.6875	98.125	97.5625	97.9375	428500.0
2000-07-21 15:00:00	QQQ	ETF	97.9375	98.375	97.875	98.125	744300.0
2000-07-21 15:30:00	QQQ	ETF	98.1875	98.4062	97.375	97.6875	1520300.0
2000-07-21 16:00:00	QQQ	ETF	97.5938	97.7188	97.3125	97.375	648400.0
2000-07-21 16:30:00	QQQ	ETF	97.3125	97.5	97.3125	97.3125	4100.0
2000-07-21 17:30:00	QQQ	ETF	97.3125	97.3125	97.3125	97.3125	700.0
2000-07-21 18:00:00	QQQ	ETF	97.375	97.5	97.0	97.0	1300.0
2000-07-21 10:00:00	IWM	ETF	53.1875	53.1875	52.8594	52.8594	7000.0
2000-07-21 10:30:00	IWM	ETF	52.6562	52.6562	52.5	52.6094	2800.0
2000-07-21 11:00:00	IWM	ETF	52.6875	52.7031	52.6875	52.7031	1600.0
2000-07-21 11:30:00	IWM	ETF	52.5	52.6406	52.5	52.6406	2600.0
2000-07-21 12:30:00	IWM	ETF	52.75	52.75	52.6562	52.6562	40800.0
2000-07-21 13:30:00	IWM	ETF	52.625	52.625	52.5	52.5	600.0
2000-07-21 14:00:00	IWM	ETF	52.5938	52.5938	52.5938	52.5938	2400.0
2000-07-21 14:30:00	IWM	ETF	52.5469	52.5469	52.5	52.5	29000.0
2000-07-21 15:00:00	IWM	ETF	52.625	52.625	52.5625	52.5625	400.0
2000-07-21 15:30:00	IWM	ETF	52.4688	52.625	52.4688	52.625	1200.0
2000-07-21 16:00:00	IWM	ETF	52.1562	52.25	52.0312	52.0312	62200.0
2000-07-21 09:30:00	DIA	ETF	108.0312	108.3438	108.0	108.0938	108100.0
2000-07-21 10:00:00	DIA	ETF	108.0625	108.25	107.6875	107.875	34000.0
2000-07-21 10:30:00	DIA	ETF	107.875	107.875	107.375	107.5938	47300.0
2000-07-21 11:00:00	DIA	ETF	107.6875	107.6875	107.375	107.375	8400.0
2000-07-21 11:30:00	DIA	ETF	107.375	107.5625	107.25	107.4688	20300.0
2000-07-21 12:00:00	DIA	ETF	107.3125	107.6875	107.3125	107.5	8900.0
2000-07-21 12:30:00	DIA	ETF	107.4375	107.625	107.375	107.5938	3900.0

> showing 50 of 246 rows — these rows as CSV

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