vd (visidata) is amazing. The only tool that really works for me with millions of rows csv's

See also lnav (https://lnav.org), a mini-ETL CLI power tool.