PREVIEW / etf_30min / 2001-01-24

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-24.parquet
  size:    12 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-24 09:30:00	SPY	ETF	136.25	136.7188	135.875	136.4375	1031200.0
2001-01-24 10:00:00	SPY	ETF	136.5	136.9375	136.25	136.625	704900.0
2001-01-24 10:30:00	SPY	ETF	136.5312	137.0625	136.25	136.6875	393900.0
2001-01-24 11:00:00	SPY	ETF	136.8125	137.2188	136.6875	137.2188	526700.0
2001-01-24 11:30:00	SPY	ETF	137.25	137.3125	136.8438	136.9062	497800.0
2001-01-24 12:00:00	SPY	ETF	136.9688	137.0312	136.5	136.625	159400.0
2001-01-24 12:30:00	SPY	ETF	136.75	136.7812	136.4062	136.5	280400.0
2001-01-24 13:00:00	SPY	ETF	136.4062	136.5625	136.125	136.4062	299100.0
2001-01-24 13:30:00	SPY	ETF	136.375	136.4375	135.8438	136.1875	268700.0
2001-01-24 14:00:00	SPY	ETF	136.1875	136.5625	136.0	136.375	215000.0
2001-01-24 14:30:00	SPY	ETF	136.4062	136.7188	136.25	136.4375	501400.0
2001-01-24 15:00:00	SPY	ETF	136.5625	136.9375	136.3438	136.4375	200400.0
2001-01-24 15:30:00	SPY	ETF	136.375	136.6875	136.25	136.6875	407500.0
2001-01-24 16:00:00	SPY	ETF	136.7188	136.8438	136.25	136.5	499800.0
2001-01-24 16:30:00	SPY	ETF	136.375	136.375	136.25	136.25	1900.0
2001-01-24 17:30:00	SPY	ETF	136.4375	136.4375	136.25	136.25	2000.0
2001-01-24 18:00:00	SPY	ETF	136.25	136.25	136.25	136.25	300.0
2001-01-24 09:30:00	QQQ	ETF	68.0625	68.7188	67.375	68.4062	10173200.0
2001-01-24 10:00:00	QQQ	ETF	68.4688	68.75	67.9375	68.4688	5898100.0
2001-01-24 10:30:00	QQQ	ETF	68.4375	68.9375	68.0625	68.6875	3864000.0
2001-01-24 11:00:00	QQQ	ETF	68.6562	69.0625	68.5	69.0625	3961400.0
2001-01-24 11:30:00	QQQ	ETF	69.0625	69.125	68.625	68.8125	3691700.0
2001-01-24 12:00:00	QQQ	ETF	68.75	68.875	68.0625	68.3438	2821500.0
2001-01-24 12:30:00	QQQ	ETF	68.3125	68.5	68.0	68.0625	1965800.0
2001-01-24 13:00:00	QQQ	ETF	68.0625	68.0625	67.3438	67.625	3671800.0
2001-01-24 13:30:00	QQQ	ETF	67.6875	67.75	67.0312	67.5	2593800.0
2001-01-24 14:00:00	QQQ	ETF	67.5	68.0	67.3125	67.8125	2535100.0
2001-01-24 14:30:00	QQQ	ETF	67.8438	68.125	67.5	67.8125	1988300.0
2001-01-24 15:00:00	QQQ	ETF	67.8438	68.4375	67.6875	67.875	2726600.0
2001-01-24 15:30:00	QQQ	ETF	67.8438	68.0	67.5	67.9375	3283800.0
2001-01-24 16:00:00	QQQ	ETF	67.9375	68.0625	67.0	67.0625	1819700.0
2001-01-24 16:30:00	QQQ	ETF	67.0625	67.9688	66.375	66.8125	698700.0
2001-01-24 17:00:00	QQQ	ETF	66.75	67.0	66.7188	66.8125	168300.0
2001-01-24 17:30:00	QQQ	ETF	66.8125	67.375	66.8125	66.9375	32300.0
2001-01-24 18:00:00	QQQ	ETF	66.9375	67.125	66.6875	66.75	88500.0
2001-01-24 09:30:00	IWM	ETF	50.25	50.25	49.9062	50.2344	79000.0
2001-01-24 10:00:00	IWM	ETF	50.2344	50.3438	50.2188	50.3125	34000.0
2001-01-24 10:30:00	IWM	ETF	50.2969	50.3438	50.1562	50.2188	73400.0
2001-01-24 11:00:00	IWM	ETF	50.2812	50.3125	50.1875	50.2812	21800.0
2001-01-24 11:30:00	IWM	ETF	50.25	50.4062	50.25	50.2812	50800.0
2001-01-24 12:00:00	IWM	ETF	50.2188	50.2656	50.0938	50.1562	32400.0
2001-01-24 12:30:00	IWM	ETF	50.2656	50.2656	50.125	50.1875	66200.0
2001-01-24 13:00:00	IWM	ETF	50.2812	50.2812	50.0	50.0938	107000.0
2001-01-24 13:30:00	IWM	ETF	50.0938	50.0938	49.8125	49.8125	132400.0
2001-01-24 14:00:00	IWM	ETF	49.9375	50.1406	49.9375	50.0312	107200.0
2001-01-24 14:30:00	IWM	ETF	50.1562	50.1562	49.9688	50.0625	44400.0
2001-01-24 15:00:00	IWM	ETF	50.0	50.2344	50.0	50.1719	40600.0
2001-01-24 15:30:00	IWM	ETF	50.1094	50.125	50.0	50.0	96200.0
2001-01-24 09:30:00	DIA	ETF	106.5312	106.625	106.25	106.5	81600.0
2001-01-24 10:00:00	DIA	ETF	106.5938	106.8438	106.375	106.5	76800.0

> showing 50 of 328 rows — these rows as CSV

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