PREVIEW / etf_30min / 2001-01-23

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-23.parquet
  size:    13 KB
  rows:    337

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-23 09:30:00	SPY	ETF	134.4688	135.125	134.3438	134.5	684400.0
2001-01-23 10:00:00	SPY	ETF	134.5625	134.7812	134.1562	134.625	378000.0
2001-01-23 10:30:00	SPY	ETF	134.5	135.1562	134.5	135.0312	638500.0
2001-01-23 11:00:00	SPY	ETF	135.125	135.1875	134.75	135.0938	573400.0
2001-01-23 11:30:00	SPY	ETF	135.0	135.3438	134.9062	134.9688	713000.0
2001-01-23 12:00:00	SPY	ETF	134.9062	135.5312	134.9062	135.375	804400.0
2001-01-23 12:30:00	SPY	ETF	135.375	135.4688	135.0312	135.2812	186400.0
2001-01-23 13:00:00	SPY	ETF	135.25	135.5	135.1875	135.375	276800.0
2001-01-23 13:30:00	SPY	ETF	135.4375	135.7812	135.2812	135.5938	417300.0
2001-01-23 14:00:00	SPY	ETF	135.5938	136.2188	135.5	136.0312	615800.0
2001-01-23 14:30:00	SPY	ETF	136.0625	136.375	135.875	136.25	740800.0
2001-01-23 15:00:00	SPY	ETF	136.125	136.4688	135.9062	136.0625	556200.0
2001-01-23 15:30:00	SPY	ETF	136.0938	136.6562	135.875	136.125	1036300.0
2001-01-23 16:00:00	SPY	ETF	136.125	136.125	135.5	135.9688	293200.0
2001-01-23 16:30:00	SPY	ETF	136.125	136.125	136.125	136.125	800.0
2001-01-23 09:30:00	QQQ	ETF	65.9062	66.5	65.375	65.6875	6205400.0
2001-01-23 10:00:00	QQQ	ETF	65.625	65.9375	65.3125	65.6875	3223800.0
2001-01-23 10:30:00	QQQ	ETF	65.6875	66.625	65.5312	66.5312	4198000.0
2001-01-23 11:00:00	QQQ	ETF	66.5312	66.5312	66.0312	66.3125	1799300.0
2001-01-23 11:30:00	QQQ	ETF	66.3125	66.7188	66.0938	66.1562	3061800.0
2001-01-23 12:00:00	QQQ	ETF	66.1562	66.8438	66.125	66.6875	1788500.0
2001-01-23 12:30:00	QQQ	ETF	66.75	66.875	66.3438	66.7188	1669900.0
2001-01-23 13:00:00	QQQ	ETF	66.6875	67.0	66.5	66.75	1851500.0
2001-01-23 13:30:00	QQQ	ETF	66.75	67.3438	66.7188	67.1875	3208100.0
2001-01-23 14:00:00	QQQ	ETF	67.2188	67.8125	67.125	67.7188	3326400.0
2001-01-23 14:30:00	QQQ	ETF	67.625	67.9375	67.25	67.8125	4619000.0
2001-01-23 15:00:00	QQQ	ETF	67.8125	68.25	67.625	67.6875	5739300.0
2001-01-23 15:30:00	QQQ	ETF	67.8125	68.4062	67.625	67.875	5035300.0
2001-01-23 16:00:00	QQQ	ETF	67.8125	68.0625	67.625	67.875	1469800.0
2001-01-23 16:30:00	QQQ	ETF	68.125	68.5	67.75	68.375	171500.0
2001-01-23 17:00:00	QQQ	ETF	68.25	68.625	68.125	68.5625	54800.0
2001-01-23 17:30:00	QQQ	ETF	68.5625	68.875	68.0625	68.625	109100.0
2001-01-23 18:00:00	QQQ	ETF	68.6875	68.875	68.5	68.8125	35200.0
2001-01-23 09:30:00	IWM	ETF	49.0	49.1094	48.875	48.875	12000.0
2001-01-23 10:00:00	IWM	ETF	48.9688	49.1875	48.9688	49.1875	28400.0
2001-01-23 10:30:00	IWM	ETF	49.3125	49.5625	49.1875	49.5	167200.0
2001-01-23 11:00:00	IWM	ETF	49.5	49.5	49.25	49.375	84400.0
2001-01-23 11:30:00	IWM	ETF	49.4062	49.4375	49.2812	49.2812	35800.0
2001-01-23 12:00:00	IWM	ETF	49.375	49.5	49.375	49.4844	33200.0
2001-01-23 12:30:00	IWM	ETF	49.4844	49.4844	49.4062	49.4062	25600.0
2001-01-23 13:00:00	IWM	ETF	49.4844	49.5	49.4062	49.4688	78400.0
2001-01-23 13:30:00	IWM	ETF	49.5	49.6875	49.5	49.5	76400.0
2001-01-23 14:00:00	IWM	ETF	49.6875	49.6875	49.5	49.5312	87200.0
2001-01-23 14:30:00	IWM	ETF	49.5938	49.6875	49.5938	49.6875	30200.0
2001-01-23 15:00:00	IWM	ETF	49.8125	49.9062	49.7188	49.9062	11600.0
2001-01-23 15:30:00	IWM	ETF	49.9062	50.125	49.75	50.0312	162200.0
2001-01-23 16:00:00	IWM	ETF	50.0625	50.1875	50.0625	50.1875	95600.0
2001-01-23 16:30:00	IWM	ETF	49.4844	49.4844	49.4844	49.4844	2148600.0
2001-01-23 09:30:00	DIA	ETF	105.625	106.125	105.625	105.75	48300.0
2001-01-23 10:00:00	DIA	ETF	105.8125	106.0	105.5312	105.9688	60400.0

> showing 50 of 337 rows — these rows as CSV

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