PREVIEW / etf_30min / 2000-07-18

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-18.parquet
  size:    11 KB
  rows:    276

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-18 09:30:00	SPY	ETF	150.625	150.625	150.25	150.4375	384500.0
2000-07-18 10:00:00	SPY	ETF	150.375	150.5312	149.875	150.2188	355200.0
2000-07-18 10:30:00	SPY	ETF	150.0625	150.375	149.8438	150.0	424000.0
2000-07-18 11:00:00	SPY	ETF	149.9375	149.9375	149.5	149.5	295400.0
2000-07-18 11:30:00	SPY	ETF	149.5	149.875	149.3438	149.7188	189900.0
2000-07-18 12:00:00	SPY	ETF	149.7188	150.0	149.625	149.75	81100.0
2000-07-18 12:30:00	SPY	ETF	149.75	149.9375	149.625	149.625	61300.0
2000-07-18 13:00:00	SPY	ETF	149.75	149.9688	149.625	149.9688	100000.0
2000-07-18 13:30:00	SPY	ETF	149.9375	150.125	149.875	149.9375	255800.0
2000-07-18 14:00:00	SPY	ETF	149.9375	150.0	149.625	149.625	140600.0
2000-07-18 14:30:00	SPY	ETF	149.625	150.0625	149.625	149.9062	77400.0
2000-07-18 15:00:00	SPY	ETF	150.0	150.0	149.5	149.625	266500.0
2000-07-18 15:30:00	SPY	ETF	149.625	150.125	149.3438	149.6875	755700.0
2000-07-18 16:00:00	SPY	ETF	149.875	149.9375	149.5625	149.75	783500.0
2000-07-18 16:30:00	SPY	ETF	149.75	149.75	149.75	149.75	300.0
2000-07-18 09:30:00	QQQ	ETF	100.375	100.7812	100.0625	100.5	2870800.0
2000-07-18 10:00:00	QQQ	ETF	100.5625	100.625	99.3125	99.6875	2364600.0
2000-07-18 10:30:00	QQQ	ETF	99.8125	99.875	99.125	99.3125	1902500.0
2000-07-18 11:00:00	QQQ	ETF	99.375	99.4375	98.7812	98.8125	2323900.0
2000-07-18 11:30:00	QQQ	ETF	98.8125	99.3125	98.3438	99.0625	1707100.0
2000-07-18 12:00:00	QQQ	ETF	99.0625	99.6562	98.9375	99.4375	901000.0
2000-07-18 12:30:00	QQQ	ETF	99.4375	99.5625	99.125	99.4375	517200.0
2000-07-18 13:00:00	QQQ	ETF	99.4375	99.625	99.1875	99.625	438400.0
2000-07-18 13:30:00	QQQ	ETF	99.625	99.875	99.5	99.5	1101600.0
2000-07-18 14:00:00	QQQ	ETF	99.5	99.5938	99.125	99.375	991900.0
2000-07-18 14:30:00	QQQ	ETF	99.375	99.875	99.25	99.6875	824700.0
2000-07-18 15:00:00	QQQ	ETF	99.6875	99.7188	98.9375	99.1875	1558200.0
2000-07-18 15:30:00	QQQ	ETF	99.1562	99.5625	98.75	99.0	2512400.0
2000-07-18 16:00:00	QQQ	ETF	99.125	99.5	99.0	99.125	592700.0
2000-07-18 16:30:00	QQQ	ETF	99.3438	99.5	99.1875	99.25	7000.0
2000-07-18 17:00:00	QQQ	ETF	99.3125	99.375	99.3125	99.375	1400.0
2000-07-18 17:30:00	QQQ	ETF	99.375	99.375	99.0625	99.375	5400.0
2000-07-18 18:00:00	QQQ	ETF	99.375	99.5	99.0	99.5	4300.0
2000-07-18 09:30:00	IWM	ETF	54.1406	54.1406	54.1406	54.1406	400.0
2000-07-18 10:00:00	IWM	ETF	53.9688	54.0312	53.75	53.8125	17200.0
2000-07-18 10:30:00	IWM	ETF	53.75	53.75	53.75	53.75	200.0
2000-07-18 11:00:00	IWM	ETF	53.7031	53.75	53.6562	53.6562	3000.0
2000-07-18 11:30:00	IWM	ETF	53.5625	53.5625	53.5625	53.5625	3200.0
2000-07-18 12:00:00	IWM	ETF	53.7969	53.7969	53.7969	53.7969	400.0
2000-07-18 12:30:00	IWM	ETF	53.7812	53.8125	53.75	53.75	1000.0
2000-07-18 13:00:00	IWM	ETF	53.8906	53.8906	53.8906	53.8906	200.0
2000-07-18 13:30:00	IWM	ETF	53.875	53.875	53.875	53.875	200.0
2000-07-18 14:30:00	IWM	ETF	53.9062	54.0156	53.9062	53.9844	105200.0
2000-07-18 15:00:00	IWM	ETF	53.875	53.875	53.75	53.75	101000.0
2000-07-18 15:30:00	IWM	ETF	53.6875	53.6875	53.6875	53.6875	3000.0
2000-07-18 16:00:00	IWM	ETF	53.5625	53.5625	53.5625	53.5625	400.0
2000-07-18 09:30:00	DIA	ETF	107.5625	108.0	107.5625	107.6875	36200.0
2000-07-18 10:00:00	DIA	ETF	107.8125	107.9062	107.4375	107.5	14700.0
2000-07-18 10:30:00	DIA	ETF	107.5312	107.6875	107.3125	107.4062	54900.0
2000-07-18 11:00:00	DIA	ETF	107.375	107.375	107.0312	107.0625	70000.0

> showing 50 of 276 rows — these rows as CSV

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