The story
Originally referring to the act of burning lamp oil in oil lamps for light at night. The collocation midnight oil in its literal sense is attested from mid 17th c.
Etymology from Wiktionary, CC BY-SA 4.0.
burn the midnight oil
Today it means: To work studiously, especially late into the night. Full definition →