Can I get the queries run in my project’s query history, including the Bytes Billed, in some kind of select statement I can run in bigquery itself to do analysis?
You sure can!
Check out the INFORMATION_SCHEMA.JOBS_BY_* views
There are various flavors including jobs by user, project, folder, organization.
They include the total_bytes_processed and total_bytes_billed as well.
Here is a sample query
SELECT job_id, total_bytes_billed FROM `region-us`.INFORMATION_SCHEMA.JOBS_BY_PROJECT