Database flooded with quotes of one currency pair?

Question

Database

Database filled with data for the last 10 years. Number of unique records 500 K
Data: (exact time) - (price).
Date format (2017-10-40-03-00-00-00)
Prices (1000000.00000000)$
Interested in how much it will weigh in megabytes???

Answer 1

For a database like MySQL, you can try to roughly estimate:
ID - INT - 4 bytes ... in theory it is possible without this field, but with it it will be easier and more correct, it seems to me ...
Date - Timestamp - 4 bytes
Price - Float - 4 bytes. It seems like a float should be enough for a given accuracy (Range from -3.402823466E+38 to -1.175494351E-38 and from 1.175494351E-38 to 3.402823466E+38)
+ service information, about 5 bytes per entry.
Total one line - about 17 bytes.
500K rows - 17 bytes * 500K = 8500Kbytes = 8.5 MB plus overhead...