PREVIEW / etf_30min / 2001-01-08

all etf 30-min files

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

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-08 09:30:00	SPY	ETF	129.875	129.875	128.8438	129.4375	1281700.0
2001-01-08 10:00:00	SPY	ETF	129.3125	130.0625	128.8438	129.2188	435100.0
2001-01-08 10:30:00	SPY	ETF	129.3125	129.9688	129.0938	129.2812	269100.0
2001-01-08 11:00:00	SPY	ETF	129.1562	129.4062	128.8438	129.25	209100.0
2001-01-08 11:30:00	SPY	ETF	129.125	129.375	128.875	129.3438	934000.0
2001-01-08 12:00:00	SPY	ETF	129.25	129.8438	129.0625	129.125	119900.0
2001-01-08 12:30:00	SPY	ETF	129.2812	129.2812	128.6562	128.7812	342400.0
2001-01-08 13:00:00	SPY	ETF	128.9375	129.125	128.5625	128.875	122400.0
2001-01-08 13:30:00	SPY	ETF	128.9375	129.4062	128.6562	128.75	109700.0
2001-01-08 14:00:00	SPY	ETF	128.75	129.0938	128.125	128.1562	263200.0
2001-01-08 14:30:00	SPY	ETF	128.0312	128.3438	127.6875	128.0625	421800.0
2001-01-08 15:00:00	SPY	ETF	127.875	128.5	127.7812	128.5	263700.0
2001-01-08 15:30:00	SPY	ETF	128.5	129.75	128.3438	129.75	1097500.0
2001-01-08 16:00:00	SPY	ETF	129.8125	130.1875	129.6562	130.0938	484100.0
2001-01-08 16:30:00	SPY	ETF	130.1875	130.1875	130.125	130.125	200.0
2001-01-08 17:00:00	SPY	ETF	128.6875	128.6875	128.6875	128.6875	64200.0
2001-01-08 09:30:00	QQQ	ETF	56.3125	56.4688	54.5	54.875	10659500.0
2001-01-08 10:00:00	QQQ	ETF	54.9062	55.5	54.375	54.8125	6225000.0
2001-01-08 10:30:00	QQQ	ETF	54.9375	55.9062	54.8125	55.125	4588300.0
2001-01-08 11:00:00	QQQ	ETF	55.0625	55.25	54.625	54.8125	2049800.0
2001-01-08 11:30:00	QQQ	ETF	54.8125	55.5312	54.5	54.875	2004200.0
2001-01-08 12:00:00	QQQ	ETF	54.9375	55.6875	54.5	54.875	1258000.0
2001-01-08 12:30:00	QQQ	ETF	54.9062	55.125	54.3125	54.5625	1415700.0
2001-01-08 13:00:00	QQQ	ETF	54.5	54.6875	54.1875	54.4688	1454500.0
2001-01-08 13:30:00	QQQ	ETF	54.4375	54.9375	54.375	54.4375	2060600.0
2001-01-08 14:00:00	QQQ	ETF	54.4688	54.8438	53.9375	54.125	2005900.0
2001-01-08 14:30:00	QQQ	ETF	54.0312	54.125	53.5	53.75	5468400.0
2001-01-08 15:00:00	QQQ	ETF	53.7812	54.9375	53.6875	54.875	3355600.0
2001-01-08 15:30:00	QQQ	ETF	54.875	56.9375	54.75	56.875	8160100.0
2001-01-08 16:00:00	QQQ	ETF	54.625	57.5312	53.6875	57.5	2167700.0
2001-01-08 16:30:00	QQQ	ETF	57.4375	58.1875	57.25	58.0	272900.0
2001-01-08 17:00:00	QQQ	ETF	58.125	58.25	57.875	58.125	187000.0
2001-01-08 17:30:00	QQQ	ETF	58.0	58.0625	57.8125	57.9375	32200.0
2001-01-08 18:00:00	QQQ	ETF	58.0	58.125	57.75	57.9375	27800.0
2001-01-08 09:30:00	IWM	ETF	45.875	45.9375	45.6562	45.6562	25400.0
2001-01-08 10:00:00	IWM	ETF	45.8125	45.9219	45.6562	45.9219	7400.0
2001-01-08 10:30:00	IWM	ETF	46.0	46.0781	45.8906	46.0312	20800.0
2001-01-08 11:00:00	IWM	ETF	45.875	45.875	45.6875	45.7188	7800.0
2001-01-08 11:30:00	IWM	ETF	45.8906	45.8906	45.7188	45.7188	1200.0
2001-01-08 12:00:00	IWM	ETF	45.875	45.875	45.875	45.875	200.0
2001-01-08 12:30:00	IWM	ETF	45.875	45.875	45.875	45.875	5000.0
2001-01-08 13:00:00	IWM	ETF	45.8594	45.875	45.8594	45.875	1000.0
2001-01-08 13:30:00	IWM	ETF	45.75	45.75	45.7344	45.75	12400.0
2001-01-08 14:00:00	IWM	ETF	45.6562	45.8125	45.6562	45.7188	5800.0
2001-01-08 14:30:00	IWM	ETF	45.4688	45.5312	45.3438	45.3438	68800.0
2001-01-08 15:00:00	IWM	ETF	45.5	45.5	45.5	45.5	50000.0
2001-01-08 15:30:00	IWM	ETF	45.7812	46.1875	45.6562	46.1875	105000.0
2001-01-08 16:00:00	IWM	ETF	46.0	46.25	46.0	46.1875	56000.0
2001-01-08 09:30:00	DIA	ETF	106.0	106.7188	105.875	106.625	302100.0
2001-01-08 10:00:00	DIA	ETF	106.6875	107.125	106.2188	106.5938	125900.0

> showing 50 of 316 rows — these rows as CSV

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