How to get input file size as column in AWS Athena external tables

I know how to get the path of the files via pseudo column like, for example:

select "$path" from table

But I also want to bring the filesize next to it, is it possible? Thanks in advance.