PREVIEW / etf_30min / 2000-07-10

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-10.parquet
  size:    11 KB
  rows:    271

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-10 09:30:00	SPY	ETF	147.875	148.2812	147.6875	147.9688	223100.0
2000-07-10 10:00:00	SPY	ETF	148.0	148.4688	147.8438	147.875	248100.0
2000-07-10 10:30:00	SPY	ETF	147.9375	148.1562	147.7188	148.0312	145100.0
2000-07-10 11:00:00	SPY	ETF	148.0312	148.0312	147.625	148.0312	314800.0
2000-07-10 11:30:00	SPY	ETF	148.0312	148.4062	148.0	148.1875	70300.0
2000-07-10 12:00:00	SPY	ETF	148.25	148.4688	148.125	148.375	77400.0
2000-07-10 12:30:00	SPY	ETF	148.25	148.5312	148.0938	148.4688	90400.0
2000-07-10 13:00:00	SPY	ETF	148.5	148.7188	148.5	148.5938	107100.0
2000-07-10 13:30:00	SPY	ETF	148.4688	148.9062	148.4688	148.6875	222600.0
2000-07-10 14:00:00	SPY	ETF	148.7188	148.875	148.25	148.4062	232900.0
2000-07-10 14:30:00	SPY	ETF	148.5312	148.5625	148.2188	148.5	64000.0
2000-07-10 15:00:00	SPY	ETF	148.5	148.625	148.0312	148.0312	144600.0
2000-07-10 15:30:00	SPY	ETF	148.0	148.125	147.7188	147.9688	430000.0
2000-07-10 16:00:00	SPY	ETF	147.875	147.875	147.4688	147.8438	346600.0
2000-07-10 16:30:00	SPY	ETF	147.8438	147.8438	147.8438	147.8438	900.0
2000-07-10 09:30:00	QQQ	ETF	94.6875	95.6875	94.625	94.8125	2138400.0
2000-07-10 10:00:00	QQQ	ETF	94.7812	95.5	94.6875	94.875	1224700.0
2000-07-10 10:30:00	QQQ	ETF	94.8125	95.375	94.6875	95.25	621100.0
2000-07-10 11:00:00	QQQ	ETF	95.125	95.125	94.5	94.8438	855800.0
2000-07-10 11:30:00	QQQ	ETF	94.875	95.4375	94.625	95.25	942600.0
2000-07-10 12:00:00	QQQ	ETF	95.25	95.4688	95.0625	95.1875	285800.0
2000-07-10 12:30:00	QQQ	ETF	95.1875	95.4375	95.0312	95.375	414300.0
2000-07-10 13:00:00	QQQ	ETF	95.375	95.875	95.25	95.3125	712400.0
2000-07-10 13:30:00	QQQ	ETF	95.3125	95.875	95.3125	95.625	531800.0
2000-07-10 14:00:00	QQQ	ETF	95.6875	95.75	94.75	95.0312	594600.0
2000-07-10 14:30:00	QQQ	ETF	95.0938	95.1875	94.7188	94.9375	804000.0
2000-07-10 15:00:00	QQQ	ETF	95.0	95.3438	94.5	94.5	789100.0
2000-07-10 15:30:00	QQQ	ETF	94.5	94.6875	94.0	94.1875	1889600.0
2000-07-10 16:00:00	QQQ	ETF	94.0938	94.5	94.0938	94.1562	421200.0
2000-07-10 17:00:00	QQQ	ETF	94.5	94.5	94.375	94.375	700.0
2000-07-10 17:30:00	QQQ	ETF	94.25	94.25	94.25	94.25	1100.0
2000-07-10 18:00:00	QQQ	ETF	94.4688	94.4688	94.4688	94.4688	500.0
2000-07-10 09:30:00	IWM	ETF	52.7188	52.8594	52.7188	52.8594	3000.0
2000-07-10 10:00:00	IWM	ETF	52.9531	52.9531	52.9531	52.9531	400.0
2000-07-10 11:00:00	IWM	ETF	52.9531	52.9531	52.8438	52.8906	6000.0
2000-07-10 11:30:00	IWM	ETF	52.8906	52.9844	52.8906	52.9844	9800.0
2000-07-10 12:00:00	IWM	ETF	53.0469	53.0469	53.0469	53.0469	200.0
2000-07-10 12:30:00	IWM	ETF	53.125	53.125	53.1094	53.1094	2400.0
2000-07-10 13:00:00	IWM	ETF	53.1562	53.1875	53.1562	53.1875	1800.0
2000-07-10 13:30:00	IWM	ETF	53.2812	53.2812	53.1562	53.1562	1000.0
2000-07-10 14:00:00	IWM	ETF	53.2188	53.2188	53.2188	53.2188	400.0
2000-07-10 14:30:00	IWM	ETF	53.0312	53.0312	53.0312	53.0312	1000.0
2000-07-10 15:00:00	IWM	ETF	53.1562	53.1562	53.1562	53.1562	200.0
2000-07-10 15:30:00	IWM	ETF	52.9062	53.0781	52.9062	53.0781	8200.0
2000-07-10 16:00:00	IWM	ETF	53.0938	53.0938	53.0938	53.0938	10400.0
2000-07-10 09:30:00	DIA	ETF	106.0625	106.75	106.0625	106.5	48100.0
2000-07-10 10:00:00	DIA	ETF	106.6875	106.8438	106.4375	106.5938	18600.0
2000-07-10 10:30:00	DIA	ETF	106.4375	106.75	106.375	106.5625	10800.0
2000-07-10 11:00:00	DIA	ETF	106.5	106.6562	106.25	106.5	9600.0
2000-07-10 11:30:00	DIA	ETF	106.5	106.8438	106.4375	106.7188	150200.0

> showing 50 of 271 rows — these rows as CSV

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