Revealing the stories in French real estate data

QuestDB, an open-source database optimized for market data, is utilized to analyze the French real estate market using the Demande de Valeurs Foncières (DVF) dataset, which includes detailed property transaction records. The analysis reveals significant trends and shifts in the market since COVID-19, such as the impact of rising interest rates and the migration from urban centers like Paris to suburban areas, which is possibly due to the financial and spatial advantages of peripheral regions. Using QuestDB for data ingestion and Grafana for visualization, the study highlights a structural decline in transaction numbers and values, particularly in Paris, while showcasing regional disparities in property prices and transaction volume. The data suggests a reduction in the number of transactions and a decrease in prices, challenging the common belief that real estate prices always rise. The enriched DVF dataset, with geographic coordinates, allows for mapping and further analysis, spotlighting high-value transactions and price per square meter variations across different regions, ultimately reflecting on the wealth gap and illustrating market trends through various visualizations.