feature(database): add snapshots table

Adds snapshot table in order to support historical data.