PREVIEW / etf_30min / 2000-07-19

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-19.parquet
  size:    11 KB
  rows:    260

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-19 09:30:00	SPY	ETF	149.4688	149.9062	149.1875	149.1875	1122300.0
2000-07-19 10:00:00	SPY	ETF	149.3125	149.8125	149.125	149.75	262500.0
2000-07-19 10:30:00	SPY	ETF	149.6875	149.75	149.2812	149.375	130900.0
2000-07-19 11:00:00	SPY	ETF	149.375	149.4688	148.75	148.9375	559400.0
2000-07-19 11:30:00	SPY	ETF	148.9375	148.9375	148.3438	148.375	527600.0
2000-07-19 12:00:00	SPY	ETF	148.375	148.6875	148.25	148.4688	250200.0
2000-07-19 12:30:00	SPY	ETF	148.5625	148.6875	148.3438	148.5625	84300.0
2000-07-19 13:00:00	SPY	ETF	148.5	149.125	148.5	148.8125	1652600.0
2000-07-19 13:30:00	SPY	ETF	148.7812	149.0625	148.6875	148.9375	189800.0
2000-07-19 14:00:00	SPY	ETF	149.0	149.25	148.7188	148.75	442400.0
2000-07-19 14:30:00	SPY	ETF	148.7812	148.9375	148.4375	148.5312	332700.0
2000-07-19 15:00:00	SPY	ETF	148.5625	149.0625	148.375	148.75	648300.0
2000-07-19 15:30:00	SPY	ETF	148.625	148.7188	148.25	148.4375	690100.0
2000-07-19 16:00:00	SPY	ETF	148.4062	148.875	148.4062	148.6875	747600.0
2000-07-19 17:30:00	SPY	ETF	148.5625	148.5625	148.5625	148.5625	1000.0
2000-07-19 09:30:00	QQQ	ETF	98.3125	98.9375	97.375	97.4375	3583800.0
2000-07-19 10:00:00	QQQ	ETF	97.5	98.2812	97.375	98.1875	1888900.0
2000-07-19 10:30:00	QQQ	ETF	98.125	98.3125	97.625	97.6562	933200.0
2000-07-19 11:00:00	QQQ	ETF	97.6562	98.0	97.0625	97.125	1590000.0
2000-07-19 11:30:00	QQQ	ETF	97.125	97.4062	96.625	96.625	1825400.0
2000-07-19 12:00:00	QQQ	ETF	96.6875	96.9688	96.5312	96.9375	1340900.0
2000-07-19 12:30:00	QQQ	ETF	96.8125	97.0	96.4062	96.5	976900.0
2000-07-19 13:00:00	QQQ	ETF	96.5625	97.3438	96.5625	96.9375	1077100.0
2000-07-19 13:30:00	QQQ	ETF	96.875	97.1562	96.75	97.0625	743800.0
2000-07-19 14:00:00	QQQ	ETF	97.125	97.3438	96.75	96.75	677700.0
2000-07-19 14:30:00	QQQ	ETF	96.6875	96.875	96.125	96.375	1145200.0
2000-07-19 15:00:00	QQQ	ETF	96.25	96.6875	96.0312	96.1875	1918900.0
2000-07-19 15:30:00	QQQ	ETF	96.125	96.25	95.6562	96.0625	3214600.0
2000-07-19 16:00:00	QQQ	ETF	96.0312	96.8125	96.0	96.625	452100.0
2000-07-19 16:30:00	QQQ	ETF	96.8125	97.0	96.625	96.6562	5300.0
2000-07-19 17:00:00	QQQ	ETF	96.75	97.0	96.125	96.75	5400.0
2000-07-19 17:30:00	QQQ	ETF	97.125	97.3125	96.9375	97.3125	5300.0
2000-07-19 18:00:00	QQQ	ETF	97.3125	97.625	96.875	97.25	405400.0
2000-07-19 09:30:00	IWM	ETF	53.3906	53.3906	53.1875	53.1875	1400.0
2000-07-19 10:30:00	IWM	ETF	53.2188	53.2188	53.2188	53.2188	7400.0
2000-07-19 11:00:00	IWM	ETF	53.2188	53.2188	52.9375	53.0625	4400.0
2000-07-19 11:30:00	IWM	ETF	52.8594	52.9688	52.8594	52.9531	800.0
2000-07-19 12:00:00	IWM	ETF	52.9375	52.9375	52.9375	52.9375	1400.0
2000-07-19 12:30:00	IWM	ETF	52.875	52.9219	52.875	52.9219	2800.0
2000-07-19 14:00:00	IWM	ETF	53.1094	53.1094	53.1094	53.1094	800.0
2000-07-19 15:00:00	IWM	ETF	52.9062	53.0	52.9062	53.0	1800.0
2000-07-19 15:30:00	IWM	ETF	52.875	52.875	52.625	52.625	14600.0
2000-07-19 09:30:00	DIA	ETF	107.5625	108.0	107.5625	107.7812	195800.0
2000-07-19 10:00:00	DIA	ETF	107.7812	108.1562	107.625	108.0312	108100.0
2000-07-19 10:30:00	DIA	ETF	108.0312	108.0938	107.75	107.8125	13500.0
2000-07-19 11:00:00	DIA	ETF	107.8125	107.9688	107.2812	107.375	27800.0
2000-07-19 11:30:00	DIA	ETF	107.3125	107.625	107.0938	107.1875	50600.0
2000-07-19 12:00:00	DIA	ETF	107.3125	107.3125	106.9375	107.125	27300.0
2000-07-19 12:30:00	DIA	ETF	107.125	107.1562	106.9375	107.0625	8500.0
2000-07-19 13:00:00	DIA	ETF	107.0625	107.4375	107.0312	107.3125	8100.0

> showing 50 of 260 rows — these rows as CSV

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