PREVIEW / etf_30min / 2001-01-03

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-03.parquet
  size:    14 KB
  rows:    344

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-03 09:30:00	SPY	ETF	128.3125	129.5312	128.3125	128.8125	859000.0
2001-01-03 10:00:00	SPY	ETF	128.8125	130.4688	128.7188	130.0938	859300.0
2001-01-03 10:30:00	SPY	ETF	130.0625	130.2812	129.1875	129.3125	357400.0
2001-01-03 11:00:00	SPY	ETF	129.5312	129.5312	128.375	128.8125	567400.0
2001-01-03 11:30:00	SPY	ETF	128.6562	129.125	128.0938	128.3438	452200.0
2001-01-03 12:00:00	SPY	ETF	128.375	128.4688	127.6562	128.2188	613000.0
2001-01-03 12:30:00	SPY	ETF	128.1875	128.7188	127.875	128.5625	610600.0
2001-01-03 13:00:00	SPY	ETF	128.6562	136.0	128.1562	133.5	4180600.0
2001-01-03 13:30:00	SPY	ETF	133.9375	136.0	132.4688	133.0	3989000.0
2001-01-03 14:00:00	SPY	ETF	133.0	134.0	132.625	134.0	1909700.0
2001-01-03 14:30:00	SPY	ETF	134.0	134.8125	133.375	134.1562	1104300.0
2001-01-03 15:00:00	SPY	ETF	134.3438	135.3438	134.1562	134.7188	559200.0
2001-01-03 15:30:00	SPY	ETF	134.7188	135.125	134.5	135.0	857700.0
2001-01-03 16:00:00	SPY	ETF	134.8438	135.5	134.5	135.0	548700.0
2001-01-03 16:30:00	SPY	ETF	135.0	135.0	134.0312	134.0312	1875500.0
2001-01-03 17:30:00	SPY	ETF	134.875	135.0	134.875	135.0	2000.0
2001-01-03 09:30:00	QQQ	ETF	52.1875	54.1875	52.1562	53.25	11923000.0
2001-01-03 10:00:00	QQQ	ETF	53.25	55.3125	52.6875	54.875	9381600.0
2001-01-03 10:30:00	QQQ	ETF	54.75	55.1875	54.25	54.5625	5449000.0
2001-01-03 11:00:00	QQQ	ETF	54.5312	54.6562	53.0625	53.625	5697900.0
2001-01-03 11:30:00	QQQ	ETF	53.625	54.1562	53.0	53.0938	2952700.0
2001-01-03 12:00:00	QQQ	ETF	53.0	53.3125	52.3438	53.125	3756400.0
2001-01-03 12:30:00	QQQ	ETF	53.1875	54.125	52.8125	54.0	2946200.0
2001-01-03 13:00:00	QQQ	ETF	54.0625	63.5	53.2812	60.6875	16540700.0
2001-01-03 13:30:00	QQQ	ETF	60.5625	61.875	59.0	59.3125	19679200.0
2001-01-03 14:00:00	QQQ	ETF	59.375	61.4375	59.25	61.125	10908200.0
2001-01-03 14:30:00	QQQ	ETF	61.125	62.25	61.0	61.8438	6642800.0
2001-01-03 15:00:00	QQQ	ETF	62.0625	63.0312	61.75	62.0625	7155400.0
2001-01-03 15:30:00	QQQ	ETF	62.0625	63.0625	62.0	62.75	7950600.0
2001-01-03 16:00:00	QQQ	ETF	62.8125	63.0	61.0938	62.0	3394300.0
2001-01-03 16:30:00	QQQ	ETF	62.375	65.25	58.0	62.0	908300.0
2001-01-03 17:00:00	QQQ	ETF	62.0	62.375	61.25	62.1875	39400.0
2001-01-03 17:30:00	QQQ	ETF	62.0	62.375	62.0	62.0938	15400.0
2001-01-03 18:00:00	QQQ	ETF	62.125	62.25	62.125	62.25	1800.0
2001-01-03 09:30:00	IWM	ETF	45.75	46.1875	45.75	45.9375	39800.0
2001-01-03 10:00:00	IWM	ETF	45.9688	46.375	45.875	46.375	26400.0
2001-01-03 10:30:00	IWM	ETF	46.5	46.5781	46.1875	46.25	55400.0
2001-01-03 11:00:00	IWM	ETF	46.2188	46.25	46.1562	46.25	3000.0
2001-01-03 11:30:00	IWM	ETF	46.25	46.375	46.1875	46.25	3800.0
2001-01-03 12:00:00	IWM	ETF	46.125	46.125	45.7188	45.8438	3200.0
2001-01-03 12:30:00	IWM	ETF	45.7812	45.8438	45.7188	45.75	2800.0
2001-01-03 13:00:00	IWM	ETF	45.9688	48.5	45.8125	48.5	279400.0
2001-01-03 13:30:00	IWM	ETF	48.75	48.75	47.3125	47.3125	326400.0
2001-01-03 14:00:00	IWM	ETF	47.5	47.7812	47.25	47.7812	126000.0
2001-01-03 14:30:00	IWM	ETF	47.75	48.0312	47.75	48.0312	154600.0
2001-01-03 15:00:00	IWM	ETF	48.0	48.25	47.8125	48.0625	184200.0
2001-01-03 15:30:00	IWM	ETF	47.9844	48.25	47.9844	48.1094	155000.0
2001-01-03 16:00:00	IWM	ETF	48.1094	48.1094	48.1094	48.1094	47400.0
2001-01-03 09:30:00	DIA	ETF	106.4062	107.375	106.3438	106.6875	452600.0
2001-01-03 10:00:00	DIA	ETF	106.75	107.6562	106.625	107.3438	353600.0

> showing 50 of 344 rows — these rows as CSV

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