PREVIEW / etf_30min / 2001-01-25

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-01-25.parquet
  size:    12 KB
  rows:    312

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-25 09:30:00	SPY	ETF	136.25	136.6875	136.0312	136.5312	961300.0
2001-01-25 10:00:00	SPY	ETF	136.6875	137.25	135.9062	136.2188	1359300.0
2001-01-25 10:30:00	SPY	ETF	136.375	136.5	135.6562	135.875	1123200.0
2001-01-25 11:00:00	SPY	ETF	135.75	136.2188	135.6875	136.125	486000.0
2001-01-25 11:30:00	SPY	ETF	136.125	136.8438	135.9375	136.6875	1395800.0
2001-01-25 12:00:00	SPY	ETF	136.6562	136.75	136.3125	136.6562	384100.0
2001-01-25 12:30:00	SPY	ETF	136.5312	136.6562	136.2188	136.5625	438100.0
2001-01-25 13:00:00	SPY	ETF	136.6562	137.0312	136.5625	136.7812	695900.0
2001-01-25 13:30:00	SPY	ETF	136.6562	136.875	136.4062	136.625	629400.0
2001-01-25 14:00:00	SPY	ETF	136.5	136.625	135.875	136.0	441800.0
2001-01-25 14:30:00	SPY	ETF	136.0312	136.2188	135.75	136.0	625800.0
2001-01-25 15:00:00	SPY	ETF	136.0	136.3125	135.75	136.25	506000.0
2001-01-25 15:30:00	SPY	ETF	136.125	136.2812	135.875	136.0625	847400.0
2001-01-25 16:00:00	SPY	ETF	136.0312	136.1562	135.8438	136.0312	409600.0
2001-01-25 16:30:00	SPY	ETF	136.0	136.0312	136.0	136.0312	3900.0
2001-01-25 09:30:00	QQQ	ETF	66.875	67.3125	66.5312	67.25	8140200.0
2001-01-25 10:00:00	QQQ	ETF	67.25	67.6562	66.3438	66.5625	7915300.0
2001-01-25 10:30:00	QQQ	ETF	66.625	67.0312	65.9688	66.0	4576500.0
2001-01-25 11:00:00	QQQ	ETF	66.0312	66.2188	65.8125	66.1875	3241100.0
2001-01-25 11:30:00	QQQ	ETF	66.2188	66.75	65.75	66.4688	4815000.0
2001-01-25 12:00:00	QQQ	ETF	66.5	66.5312	65.8125	66.25	2681400.0
2001-01-25 12:30:00	QQQ	ETF	66.25	66.5	65.9375	66.1875	1258100.0
2001-01-25 13:00:00	QQQ	ETF	66.2188	66.625	66.125	66.25	1838900.0
2001-01-25 13:30:00	QQQ	ETF	66.2188	66.4688	65.5938	65.6875	2851800.0
2001-01-25 14:00:00	QQQ	ETF	65.7812	65.875	64.875	64.9375	4721900.0
2001-01-25 14:30:00	QQQ	ETF	64.9375	65.3438	64.75	65.125	3900000.0
2001-01-25 15:00:00	QQQ	ETF	65.0	65.4062	64.75	65.1562	2634100.0
2001-01-25 15:30:00	QQQ	ETF	65.25	65.2812	64.625	64.7812	4527000.0
2001-01-25 16:00:00	QQQ	ETF	64.75	65.0625	64.375	64.375	1345400.0
2001-01-25 16:30:00	QQQ	ETF	64.5	66.5	64.0625	66.5	308000.0
2001-01-25 17:00:00	QQQ	ETF	64.5	65.125	63.5	63.625	169700.0
2001-01-25 17:30:00	QQQ	ETF	63.625	63.75	63.1875	63.375	180100.0
2001-01-25 18:00:00	QQQ	ETF	63.5	63.75	63.375	63.625	86200.0
2001-01-25 09:30:00	IWM	ETF	50.0156	50.0156	49.8438	49.9062	51400.0
2001-01-25 10:00:00	IWM	ETF	50.0	50.1562	49.7188	49.7188	51000.0
2001-01-25 10:30:00	IWM	ETF	49.9375	49.9375	49.7188	49.7969	4600.0
2001-01-25 11:00:00	IWM	ETF	49.6562	49.8438	49.6094	49.8438	64800.0
2001-01-25 11:30:00	IWM	ETF	49.9375	50.0312	49.8438	50.0312	42800.0
2001-01-25 12:00:00	IWM	ETF	49.9844	50.0	49.8438	50.0	63000.0
2001-01-25 12:30:00	IWM	ETF	49.9688	49.9844	49.9688	49.9844	400.0
2001-01-25 13:00:00	IWM	ETF	50.0	50.1562	49.9688	49.9688	147200.0
2001-01-25 13:30:00	IWM	ETF	49.9688	50.0469	49.9688	49.9688	70200.0
2001-01-25 14:00:00	IWM	ETF	49.9844	50.0	49.8438	50.0	28800.0
2001-01-25 14:30:00	IWM	ETF	49.9375	49.9375	49.7188	49.7812	80400.0
2001-01-25 15:00:00	IWM	ETF	50.0	50.0625	49.9375	49.9375	60800.0
2001-01-25 15:30:00	IWM	ETF	50.0	50.0156	49.7344	49.8125	86600.0
2001-01-25 16:00:00	IWM	ETF	49.75	49.75	49.75	49.75	10000.0
2001-01-25 09:30:00	DIA	ETF	106.6875	107.2188	106.4375	107.2188	191200.0
2001-01-25 10:00:00	DIA	ETF	107.2188	107.6562	106.75	107.0938	149300.0
2001-01-25 10:30:00	DIA	ETF	107.1562	107.25	106.5625	107.0	88500.0

> showing 50 of 312 rows — these rows as CSV

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