PREVIEW / etf_30min / 2001-01-17

all etf 30-min files

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

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-17 09:30:00	SPY	ETF	134.8438	134.8438	134.0312	134.25	2065200.0
2001-01-17 10:00:00	SPY	ETF	134.2812	134.5625	134.0625	134.5625	710000.0
2001-01-17 10:30:00	SPY	ETF	134.5625	135.0312	134.3438	134.8125	384200.0
2001-01-17 11:00:00	SPY	ETF	134.6875	135.0312	134.375	134.5625	241100.0
2001-01-17 11:30:00	SPY	ETF	134.5938	134.7812	134.375	134.5938	187500.0
2001-01-17 12:00:00	SPY	ETF	134.5	134.9688	134.4375	134.625	116700.0
2001-01-17 12:30:00	SPY	ETF	134.7188	134.7188	134.375	134.5	82400.0
2001-01-17 13:00:00	SPY	ETF	134.5	134.5625	133.875	134.0	247800.0
2001-01-17 13:30:00	SPY	ETF	134.0	134.375	133.875	134.3438	153000.0
2001-01-17 14:00:00	SPY	ETF	134.375	134.375	133.6562	133.9375	134400.0
2001-01-17 14:30:00	SPY	ETF	133.9375	133.9688	133.0625	133.0938	996300.0
2001-01-17 15:00:00	SPY	ETF	133.0938	133.4688	132.75	133.4688	656500.0
2001-01-17 15:30:00	SPY	ETF	133.375	133.4688	132.625	132.9375	1239200.0
2001-01-17 16:00:00	SPY	ETF	133.0625	133.4688	132.9062	133.4375	340800.0
2001-01-17 16:30:00	SPY	ETF	133.4375	133.875	133.4375	133.625	20400.0
2001-01-17 17:00:00	SPY	ETF	134.0	134.0	134.0	134.0	100.0
2001-01-17 09:30:00	QQQ	ETF	64.5	65.0	64.3125	64.875	13470400.0
2001-01-17 10:00:00	QQQ	ETF	64.75	65.375	64.6875	65.2188	6948100.0
2001-01-17 10:30:00	QQQ	ETF	65.1875	65.5938	65.0625	65.3125	4207600.0
2001-01-17 11:00:00	QQQ	ETF	65.25	65.5625	64.875	65.0625	3683000.0
2001-01-17 11:30:00	QQQ	ETF	65.1875	65.375	65.0312	65.25	1993000.0
2001-01-17 12:00:00	QQQ	ETF	65.3125	65.5625	65.2188	65.25	1572500.0
2001-01-17 12:30:00	QQQ	ETF	65.25	65.375	65.0	65.1875	1923600.0
2001-01-17 13:00:00	QQQ	ETF	65.0625	65.1875	64.5	64.5	2705600.0
2001-01-17 13:30:00	QQQ	ETF	64.5625	65.0938	64.5	65.0	2342000.0
2001-01-17 14:00:00	QQQ	ETF	65.0312	65.0938	64.25	64.6562	2909700.0
2001-01-17 14:30:00	QQQ	ETF	64.7188	64.75	63.75	64.0	4137400.0
2001-01-17 15:00:00	QQQ	ETF	64.0	64.125	63.125	64.0	5090000.0
2001-01-17 15:30:00	QQQ	ETF	64.0	64.1875	63.2812	63.6875	4866000.0
2001-01-17 16:00:00	QQQ	ETF	63.5938	64.5	63.3125	63.5	1151300.0
2001-01-17 16:30:00	QQQ	ETF	63.6875	64.875	63.5	64.75	276200.0
2001-01-17 17:00:00	QQQ	ETF	64.7812	65.0	64.0	64.1875	423700.0
2001-01-17 17:30:00	QQQ	ETF	64.125	64.25	63.9375	64.0	135800.0
2001-01-17 18:00:00	QQQ	ETF	64.0	64.25	63.9375	64.25	26000.0
2001-01-17 09:30:00	IWM	ETF	50.0938	50.0938	49.7188	49.7188	50600.0
2001-01-17 10:00:00	IWM	ETF	49.7656	49.7969	49.75	49.75	35000.0
2001-01-17 10:30:00	IWM	ETF	49.7812	50.0	49.7812	50.0	134400.0
2001-01-17 11:00:00	IWM	ETF	50.1875	50.1875	49.75	49.75	26400.0
2001-01-17 11:30:00	IWM	ETF	49.8125	49.8125	49.8125	49.8125	75800.0
2001-01-17 12:00:00	IWM	ETF	49.9375	49.9375	49.7812	49.9219	16600.0
2001-01-17 12:30:00	IWM	ETF	49.8125	49.9375	49.8125	49.8125	2000.0
2001-01-17 13:00:00	IWM	ETF	49.8125	49.8125	49.5625	49.5625	30200.0
2001-01-17 13:30:00	IWM	ETF	49.6875	49.75	49.5	49.75	186600.0
2001-01-17 14:00:00	IWM	ETF	49.7344	49.75	49.4688	49.5625	99600.0
2001-01-17 14:30:00	IWM	ETF	49.5938	49.5938	49.25	49.4375	2600.0
2001-01-17 15:00:00	IWM	ETF	49.3438	49.375	48.9688	49.125	85200.0
2001-01-17 15:30:00	IWM	ETF	49.2812	49.3125	49.0312	49.3125	275400.0
2001-01-17 16:00:00	IWM	ETF	49.2344	49.3125	49.2344	49.3125	53000.0
2001-01-17 09:30:00	DIA	ETF	107.2188	107.375	106.0	106.2812	398200.0
2001-01-17 10:00:00	DIA	ETF	106.3125	106.5938	106.125	106.5	250600.0

> showing 50 of 324 rows — these rows as CSV

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