PREVIEW / etf_30min / 2001-01-02

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-02.parquet
  size:    13 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-02 09:30:00	SPY	ETF	132.0	132.1562	131.3438	131.5	1335300.0
2001-01-02 10:00:00	SPY	ETF	131.5	131.625	130.625	131.25	1174000.0
2001-01-02 10:30:00	SPY	ETF	131.3125	131.375	130.25	130.3125	650400.0
2001-01-02 11:00:00	SPY	ETF	130.1562	130.2812	129.3125	130.0	675400.0
2001-01-02 11:30:00	SPY	ETF	129.9688	130.1562	129.625	130.0312	221200.0
2001-01-02 12:00:00	SPY	ETF	130.0938	130.125	129.6875	129.6875	131400.0
2001-01-02 12:30:00	SPY	ETF	129.625	129.9688	129.5	129.9375	179900.0
2001-01-02 13:00:00	SPY	ETF	130.0	130.2812	129.6562	129.8125	258300.0
2001-01-02 13:30:00	SPY	ETF	129.7812	129.7812	129.1562	129.375	451800.0
2001-01-02 14:00:00	SPY	ETF	129.25	129.4688	128.8438	129.0	715400.0
2001-01-02 14:30:00	SPY	ETF	129.0	129.1562	128.4062	128.5625	487200.0
2001-01-02 15:00:00	SPY	ETF	128.5938	128.5938	127.8125	128.3438	803000.0
2001-01-02 15:30:00	SPY	ETF	128.3438	128.6562	127.5625	128.25	1220600.0
2001-01-02 16:00:00	SPY	ETF	128.0938	128.8125	128.0	128.375	407100.0
2001-01-02 16:30:00	SPY	ETF	128.0	128.8125	128.0	128.8125	300.0
2001-01-02 18:00:00	SPY	ETF	128.0625	128.0625	128.0625	128.0625	100.0
2001-01-02 09:30:00	QQQ	ETF	58.5625	58.6875	56.6875	56.6875	6087800.0
2001-01-02 10:00:00	QQQ	ETF	57.0	57.0	55.4375	56.25	5699500.0
2001-01-02 10:30:00	QQQ	ETF	56.25	56.3125	55.0312	55.125	4294400.0
2001-01-02 11:00:00	QQQ	ETF	55.125	55.125	53.8125	54.7812	7864300.0
2001-01-02 11:30:00	QQQ	ETF	54.8438	55.0625	54.125	54.9062	2848000.0
2001-01-02 12:00:00	QQQ	ETF	55.0	55.125	54.2812	54.625	2364300.0
2001-01-02 12:30:00	QQQ	ETF	54.5	55.0	54.2812	54.9375	1813400.0
2001-01-02 13:00:00	QQQ	ETF	54.9688	55.4688	54.875	54.9375	2352600.0
2001-01-02 13:30:00	QQQ	ETF	54.9375	55.0938	54.2812	54.5	1803100.0
2001-01-02 14:00:00	QQQ	ETF	54.5	54.875	53.5625	53.5625	3393800.0
2001-01-02 14:30:00	QQQ	ETF	53.625	54.1875	53.375	53.625	4265500.0
2001-01-02 15:00:00	QQQ	ETF	53.625	53.75	52.8125	53.1875	5737900.0
2001-01-02 15:30:00	QQQ	ETF	53.1875	53.625	52.4375	53.0	10662400.0
2001-01-02 16:00:00	QQQ	ETF	53.2188	53.4688	52.5	53.375	2560900.0
2001-01-02 16:30:00	QQQ	ETF	53.375	53.625	53.1875	53.4062	55600.0
2001-01-02 17:00:00	QQQ	ETF	53.4062	53.875	53.25	53.5	22700.0
2001-01-02 17:30:00	QQQ	ETF	53.5312	53.5312	53.375	53.5	9700.0
2001-01-02 18:00:00	QQQ	ETF	53.5	54.0	53.375	53.5	10000.0
2001-01-02 09:30:00	IWM	ETF	47.875	47.875	47.5	47.5	180200.0
2001-01-02 10:00:00	IWM	ETF	47.4375	47.4688	46.6875	46.75	156600.0
2001-01-02 10:30:00	IWM	ETF	46.9375	47.0	46.5	46.5	127200.0
2001-01-02 11:00:00	IWM	ETF	46.1875	46.4062	46.1875	46.25	47400.0
2001-01-02 11:30:00	IWM	ETF	46.25	46.4219	46.25	46.4219	20400.0
2001-01-02 12:00:00	IWM	ETF	46.4375	46.5	46.4062	46.5	32600.0
2001-01-02 12:30:00	IWM	ETF	46.5	46.5	46.3438	46.4375	5400.0
2001-01-02 13:00:00	IWM	ETF	46.4688	46.6406	46.4688	46.6406	54800.0
2001-01-02 13:30:00	IWM	ETF	46.5312	46.6094	46.4062	46.4062	16800.0
2001-01-02 14:00:00	IWM	ETF	46.25	46.4219	46.1562	46.25	42400.0
2001-01-02 14:30:00	IWM	ETF	46.0625	46.125	45.8438	45.8438	33000.0
2001-01-02 15:00:00	IWM	ETF	45.8438	45.9688	45.8438	45.9688	16200.0
2001-01-02 15:30:00	IWM	ETF	46.0	46.125	45.8438	46.0	81800.0
2001-01-02 16:00:00	IWM	ETF	46.2031	46.2031	46.2031	46.2031	3600.0
2001-01-02 09:30:00	DIA	ETF	107.1875	107.4375	106.6875	107.375	222600.0
2001-01-02 10:00:00	DIA	ETF	107.3438	107.625	106.9375	107.5	102200.0

> showing 50 of 324 rows — these rows as CSV

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