Financial-market-trend-recovery
Simulated Energy Financial Risk Market Data for Trend and Recovery Analysis
@kaggle.ziya07_financial_market_trend_recovery
Energy Finance Dataset
@kaggle.ziya07_financial_market_trend_recovery.energy_finance_dataset
- 1.01 MB
- 36500 rows
- 10 columns
dateDate | company_idCompany ID | revenueRevenue ($) | expenseExpense ($) | profitProfit ($) | market_priceMarket Price ($) | volatility_indexVolatility Index | compliance_issueCompliance Issue | compliance_fineCompliance Fine ($) | regulatory_changeRegulatory Change |
|---|---|---|---|---|---|---|---|---|---|
| Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | COMP_1 | 193524.66 | 380532.15 | -187007.49 | 95.88 | 0.58 | |||
| Mon Jan 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | COMP_1 | 38460.97 | 347139.58 | -308678.61 | 84.1 | 0.67 | |||
| Tue Jan 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | COMP_1 | 417896.89 | 88873.95 | 329022.94 | 46.36 | 0.25 | |||
| Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | COMP_1 | 221653.06 | 120035.51 | 101617.55 | 85.07 | 0.21 | |||
| Thu Jan 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | COMP_1 | 233474.29 | 315144.5 | -81670.20999999999 | 47.97 | 0.51 | |||
| Fri Jan 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | COMP_1 | 307696.98 | 72357.03 | 235339.95 | 35.85 | 0.86 | 1 | ||
| Sat Jan 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | COMP_1 | 159260.75 | 43580.49 | 115680.26 | 91.58 | 0.45 | |||
| Sun Jan 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | COMP_1 | 26850.38 | 364181.56 | -337331.18 | 53.29 | 0.63 | |||
| Mon Jan 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | COMP_1 | 277888.04 | 78017.51 | 199870.53 | 117.26 | 0.72 | 1 | ||
| Tue Jan 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | COMP_1 | 302970.99 | 369140.32 | -66169.33000000002 | 37.96 | 0.26 |
CREATE TABLE energy_finance_dataset (
"date" TIMESTAMP,
"company_id" VARCHAR,
"revenue" DOUBLE,
"expense" DOUBLE,
"profit" DOUBLE,
"market_price" DOUBLE,
"volatility_index" DOUBLE,
"compliance_issue" BIGINT,
"compliance_fine" DOUBLE,
"regulatory_change" BIGINT
);