PREVIEW / etf_30min / 2001-01-04

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-04.parquet
  size:    13 KB
  rows:    328

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-04 09:30:00	SPY	ETF	134.9375	135.2188	134.3125	135.1875	1351700.0
2001-01-04 10:00:00	SPY	ETF	135.125	135.4688	134.2812	134.3125	863800.0
2001-01-04 10:30:00	SPY	ETF	134.3438	134.625	133.6875	134.3438	623000.0
2001-01-04 11:00:00	SPY	ETF	134.3438	134.8438	134.0625	134.3125	525800.0
2001-01-04 11:30:00	SPY	ETF	134.5938	134.625	133.875	134.5	563500.0
2001-01-04 12:00:00	SPY	ETF	134.5312	135.2812	134.4062	135.1562	602000.0
2001-01-04 12:30:00	SPY	ETF	135.0	135.0	134.3438	134.5625	577600.0
2001-01-04 13:00:00	SPY	ETF	134.5312	134.9375	134.2812	134.3125	678600.0
2001-01-04 13:30:00	SPY	ETF	134.25	134.3125	133.6562	134.1875	403400.0
2001-01-04 14:00:00	SPY	ETF	134.25	134.4062	133.5	133.625	456000.0
2001-01-04 14:30:00	SPY	ETF	133.625	133.7188	133.0	133.375	434300.0
2001-01-04 15:00:00	SPY	ETF	133.4062	133.9062	133.125	133.4688	550300.0
2001-01-04 15:30:00	SPY	ETF	133.5	133.9062	133.125	133.4062	499400.0
2001-01-04 16:00:00	SPY	ETF	133.25	133.9375	133.25	133.5312	994100.0
2001-01-04 17:00:00	SPY	ETF	134.1875	134.375	133.75	133.75	5300.0
2001-01-04 09:30:00	QQQ	ETF	61.625	63.4375	61.5	62.375	12968500.0
2001-01-04 10:00:00	QQQ	ETF	62.75	63.625	61.75	62.3125	6332000.0
2001-01-04 10:30:00	QQQ	ETF	62.25	62.4688	61.375	62.125	5248700.0
2001-01-04 11:00:00	QQQ	ETF	62.125	62.625	61.6875	62.375	3840700.0
2001-01-04 11:30:00	QQQ	ETF	62.3438	62.75	62.0	62.6875	2441500.0
2001-01-04 12:00:00	QQQ	ETF	62.75	63.375	62.6875	63.125	2784200.0
2001-01-04 12:30:00	QQQ	ETF	63.0625	63.1875	62.375	62.4688	1346900.0
2001-01-04 13:00:00	QQQ	ETF	62.5312	62.875	62.25	62.4375	1844900.0
2001-01-04 13:30:00	QQQ	ETF	62.4062	62.5	61.625	62.1562	2671100.0
2001-01-04 14:00:00	QQQ	ETF	62.0938	62.3125	60.9375	61.3125	3924700.0
2001-01-04 14:30:00	QQQ	ETF	61.25	61.375	60.5625	61.2188	4304200.0
2001-01-04 15:00:00	QQQ	ETF	61.25	62.0	61.125	61.6562	3946500.0
2001-01-04 15:30:00	QQQ	ETF	61.5	61.75	61.0	61.5	4139900.0
2001-01-04 16:00:00	QQQ	ETF	61.4688	61.5938	60.5	61.25	1241000.0
2001-01-04 16:30:00	QQQ	ETF	61.125	62.8125	61.0625	61.3438	276700.0
2001-01-04 17:00:00	QQQ	ETF	61.1875	63.0	61.0625	61.875	518800.0
2001-01-04 17:30:00	QQQ	ETF	61.875	62.0	61.5	61.625	245300.0
2001-01-04 18:00:00	QQQ	ETF	61.5	61.625	61.0	61.5938	36900.0
2001-01-04 09:30:00	IWM	ETF	47.9375	48.2812	47.9375	48.1562	70400.0
2001-01-04 10:00:00	IWM	ETF	48.2344	48.2812	48.0	48.1875	109600.0
2001-01-04 10:30:00	IWM	ETF	47.9375	48.125	47.8438	48.0625	108000.0
2001-01-04 11:00:00	IWM	ETF	48.0625	48.1562	47.9062	47.9062	9600.0
2001-01-04 11:30:00	IWM	ETF	48.0	48.125	47.7812	47.7812	53800.0
2001-01-04 12:00:00	IWM	ETF	47.9375	48.125	47.9375	48.125	1400.0
2001-01-04 12:30:00	IWM	ETF	48.125	48.1562	47.9375	47.9375	60600.0
2001-01-04 13:00:00	IWM	ETF	48.0312	48.0312	48.0312	48.0312	600.0
2001-01-04 13:30:00	IWM	ETF	47.9219	47.9375	47.75	47.75	3000.0
2001-01-04 14:00:00	IWM	ETF	47.9062	47.9375	47.5625	47.5625	50800.0
2001-01-04 14:30:00	IWM	ETF	47.6875	47.7188	47.3125	47.3125	8200.0
2001-01-04 15:00:00	IWM	ETF	47.5938	47.625	47.5	47.625	30000.0
2001-01-04 15:30:00	IWM	ETF	47.625	47.7031	47.5	47.5	600.0
2001-01-04 09:30:00	DIA	ETF	109.125	109.9688	109.125	109.5938	378100.0
2001-01-04 10:00:00	DIA	ETF	109.7188	110.25	109.5	109.625	212900.0
2001-01-04 10:30:00	DIA	ETF	109.5	109.8438	109.0938	109.7812	80300.0
2001-01-04 11:00:00	DIA	ETF	109.7812	110.0	109.4688	109.75	50700.0

> showing 50 of 328 rows — these rows as CSV

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