PREVIEW / etf_30min / 2001-01-12

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-12.parquet
  size:    12 KB
  rows:    313

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
2001-01-12 09:30:00	SPY	ETF	132.6875	132.8438	131.9688	132.0312	766800.0
2001-01-12 10:00:00	SPY	ETF	132.0	132.4062	131.4375	132.3125	548900.0
2001-01-12 10:30:00	SPY	ETF	132.3125	133.0	132.2812	132.8438	573400.0
2001-01-12 11:00:00	SPY	ETF	132.875	133.5	132.8125	133.5	361400.0
2001-01-12 11:30:00	SPY	ETF	133.5	133.7188	132.7188	132.875	423100.0
2001-01-12 12:00:00	SPY	ETF	132.75	132.9062	132.1562	132.2812	262200.0
2001-01-12 12:30:00	SPY	ETF	132.1875	132.4062	131.5625	132.1875	775000.0
2001-01-12 13:00:00	SPY	ETF	132.125	132.125	131.5625	131.75	171900.0
2001-01-12 13:30:00	SPY	ETF	131.625	132.3438	131.5625	132.125	202000.0
2001-01-12 14:00:00	SPY	ETF	132.0938	132.3125	131.3438	131.375	261300.0
2001-01-12 14:30:00	SPY	ETF	131.3125	131.9688	131.2812	131.9375	519100.0
2001-01-12 15:00:00	SPY	ETF	131.9688	132.0938	131.5625	131.8125	276400.0
2001-01-12 15:30:00	SPY	ETF	131.8125	132.4688	131.8125	131.9062	1044500.0
2001-01-12 16:00:00	SPY	ETF	131.875	132.375	131.7812	132.0	790600.0
2001-01-12 16:30:00	SPY	ETF	132.0625	132.25	132.0	132.0	42500.0
2001-01-12 09:30:00	QQQ	ETF	62.75	62.8438	61.5	61.8438	10522300.0
2001-01-12 10:00:00	QQQ	ETF	61.875	62.6875	61.5	62.4375	5403400.0
2001-01-12 10:30:00	QQQ	ETF	62.4375	63.7188	62.25	63.4375	6724700.0
2001-01-12 11:00:00	QQQ	ETF	63.625	64.5	63.4688	64.375	5658600.0
2001-01-12 11:30:00	QQQ	ETF	64.4062	64.625	63.25	63.5938	5066800.0
2001-01-12 12:00:00	QQQ	ETF	63.6562	63.8125	62.6562	62.6875	3549200.0
2001-01-12 12:30:00	QQQ	ETF	62.625	63.25	62.0312	62.875	5089000.0
2001-01-12 13:00:00	QQQ	ETF	62.875	62.9688	62.3438	62.4375	2255400.0
2001-01-12 13:30:00	QQQ	ETF	62.4688	63.3125	62.375	63.0938	2016000.0
2001-01-12 14:00:00	QQQ	ETF	63.0938	63.25	62.0	62.0625	2196600.0
2001-01-12 14:30:00	QQQ	ETF	62.0312	62.875	61.875	62.875	3363400.0
2001-01-12 15:00:00	QQQ	ETF	62.875	62.9062	62.0625	62.5	1929100.0
2001-01-12 15:30:00	QQQ	ETF	62.5625	63.0	62.3438	62.4688	2869000.0
2001-01-12 16:00:00	QQQ	ETF	62.4375	62.8125	60.5	62.7188	1270100.0
2001-01-12 16:30:00	QQQ	ETF	62.7188	62.75	62.6875	62.75	3300.0
2001-01-12 17:00:00	QQQ	ETF	62.8125	62.8125	62.6875	62.8125	3600.0
2001-01-12 17:30:00	QQQ	ETF	62.8125	62.8125	62.5625	62.75	7400.0
2001-01-12 18:00:00	QQQ	ETF	62.625	62.8125	62.625	62.625	1900.0
2001-01-12 09:30:00	IWM	ETF	48.0625	48.2188	47.9844	48.0938	133400.0
2001-01-12 10:00:00	IWM	ETF	48.0	48.125	47.8125	48.125	53200.0
2001-01-12 10:30:00	IWM	ETF	48.0312	48.3438	48.0	48.1875	40200.0
2001-01-12 11:00:00	IWM	ETF	48.3438	48.625	48.3125	48.4688	209400.0
2001-01-12 11:30:00	IWM	ETF	48.6562	48.7188	48.5	48.5312	173600.0
2001-01-12 12:00:00	IWM	ETF	48.6562	48.6562	48.3438	48.3438	23400.0
2001-01-12 12:30:00	IWM	ETF	48.3125	48.4062	48.3125	48.4062	56400.0
2001-01-12 13:00:00	IWM	ETF	48.375	48.4688	48.375	48.4688	11400.0
2001-01-12 13:30:00	IWM	ETF	48.2812	48.5	48.2812	48.4688	4000.0
2001-01-12 14:00:00	IWM	ETF	48.4688	48.4688	48.2656	48.2656	129000.0
2001-01-12 14:30:00	IWM	ETF	48.3125	48.375	48.1875	48.1875	2600.0
2001-01-12 15:00:00	IWM	ETF	48.1875	48.5	48.1875	48.4844	33200.0
2001-01-12 15:30:00	IWM	ETF	48.5	48.5	48.2812	48.2812	8000.0
2001-01-12 16:00:00	IWM	ETF	48.1875	48.375	48.1875	48.375	15800.0
2001-01-12 09:30:00	DIA	ETF	105.5312	105.7812	105.375	105.4375	327200.0
2001-01-12 10:00:00	DIA	ETF	105.4688	105.625	105.0312	105.125	306900.0
2001-01-12 10:30:00	DIA	ETF	105.6562	106.0	105.4375	105.8125	84400.0

> showing 50 of 313 rows — these rows as CSV

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