PREVIEW / etf_30min / 2001-01-05

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-05.parquet
  size:    13 KB
  rows:    329

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-05 09:30:00	SPY	ETF	133.4688	133.625	130.4375	131.25	1822200.0
2001-01-05 10:00:00	SPY	ETF	131.4375	132.75	131.2812	132.5938	3131700.0
2001-01-05 10:30:00	SPY	ETF	132.5938	132.6875	131.5	131.625	1203100.0
2001-01-05 11:00:00	SPY	ETF	131.6562	131.6875	130.7812	131.125	534600.0
2001-01-05 11:30:00	SPY	ETF	131.125	131.3125	130.2812	131.125	899200.0
2001-01-05 12:00:00	SPY	ETF	131.2812	131.5	130.6875	131.3438	580200.0
2001-01-05 12:30:00	SPY	ETF	131.2812	131.75	131.2812	131.4375	407600.0
2001-01-05 13:00:00	SPY	ETF	131.5312	131.5625	131.0625	131.3125	371500.0
2001-01-05 13:30:00	SPY	ETF	131.125	131.4688	130.8438	131.4375	152500.0
2001-01-05 14:00:00	SPY	ETF	131.4688	131.4688	130.5938	130.9688	275400.0
2001-01-05 14:30:00	SPY	ETF	130.9688	130.9688	130.0625	130.3125	430100.0
2001-01-05 15:00:00	SPY	ETF	130.4062	130.4062	129.6875	130.0	519700.0
2001-01-05 15:30:00	SPY	ETF	130.0	130.375	129.2812	130.25	1731700.0
2001-01-05 16:00:00	SPY	ETF	130.3438	130.4062	129.1875	129.4688	631900.0
2001-01-05 16:30:00	SPY	ETF	129.1875	129.1875	129.1875	129.1875	300.0
2001-01-05 17:00:00	SPY	ETF	129.4688	129.4688	129.4688	129.4688	100.0
2001-01-05 09:30:00	QQQ	ETF	61.3125	61.3125	58.25	58.5	12807900.0
2001-01-05 10:00:00	QQQ	ETF	58.5	59.9375	58.375	59.3125	11100000.0
2001-01-05 10:30:00	QQQ	ETF	59.3125	59.6875	58.3438	58.5625	4840800.0
2001-01-05 11:00:00	QQQ	ETF	58.5938	58.6562	57.5	57.8438	6416000.0
2001-01-05 11:30:00	QQQ	ETF	57.8125	58.4375	57.375	58.25	4480500.0
2001-01-05 12:00:00	QQQ	ETF	58.1875	58.4688	57.625	58.1875	3547100.0
2001-01-05 12:30:00	QQQ	ETF	58.1875	58.75	58.0	58.2812	1887200.0
2001-01-05 13:00:00	QQQ	ETF	58.2812	58.4688	57.6562	57.75	2140500.0
2001-01-05 13:30:00	QQQ	ETF	57.75	58.0	57.375	57.7188	2167400.0
2001-01-05 14:00:00	QQQ	ETF	57.75	57.875	57.125	57.5	2360200.0
2001-01-05 14:30:00	QQQ	ETF	57.5	57.5	56.5625	56.875	3233600.0
2001-01-05 15:00:00	QQQ	ETF	56.875	56.9375	56.1875	56.625	4048100.0
2001-01-05 15:30:00	QQQ	ETF	56.6562	57.0	56.0	56.6875	8213600.0
2001-01-05 16:00:00	QQQ	ETF	56.75	56.875	56.125	56.375	1080600.0
2001-01-05 16:30:00	QQQ	ETF	56.375	56.8125	56.0	56.8125	28100.0
2001-01-05 17:00:00	QQQ	ETF	56.5	56.625	56.0	56.375	5600.0
2001-01-05 17:30:00	QQQ	ETF	56.3125	56.375	56.1875	56.1875	9600.0
2001-01-05 18:00:00	QQQ	ETF	56.1875	56.8125	56.125	56.25	7400.0
2001-01-05 09:30:00	IWM	ETF	47.4375	47.4375	46.3125	46.5	66200.0
2001-01-05 10:00:00	IWM	ETF	46.4375	46.9688	46.4062	46.875	79800.0
2001-01-05 10:30:00	IWM	ETF	46.9219	46.9219	46.6562	46.75	1400.0
2001-01-05 11:00:00	IWM	ETF	46.7188	46.7188	46.4219	46.4219	22200.0
2001-01-05 11:30:00	IWM	ETF	46.4219	46.4219	46.0625	46.25	6400.0
2001-01-05 12:00:00	IWM	ETF	46.25	46.375	46.25	46.375	20400.0
2001-01-05 12:30:00	IWM	ETF	46.1875	46.1875	46.1875	46.1875	200.0
2001-01-05 13:00:00	IWM	ETF	46.4375	46.4375	46.4062	46.4062	3600.0
2001-01-05 13:30:00	IWM	ETF	46.1562	46.1562	46.1562	46.1562	200.0
2001-01-05 14:00:00	IWM	ETF	46.2812	46.2812	46.125	46.2188	14600.0
2001-01-05 14:30:00	IWM	ETF	46.2344	46.2344	46.0	46.0938	10600.0
2001-01-05 15:00:00	IWM	ETF	46.0	46.0	45.8125	45.9375	21800.0
2001-01-05 15:30:00	IWM	ETF	46.0938	46.1562	45.875	45.9688	14600.0
2001-01-05 16:00:00	IWM	ETF	46.0312	46.0312	46.0312	46.0312	1200.0
2001-01-05 09:30:00	DIA	ETF	108.1875	108.4062	106.625	107.6562	343000.0
2001-01-05 10:00:00	DIA	ETF	107.5	108.3125	107.5	107.9688	302700.0

> showing 50 of 329 rows — these rows as CSV

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