=== STRUCTURE DE LA TABLE dm_epex_power_spot ===

id | int(11) | NO | PRI
market_area | varchar(10) | NO | MUL
trading_date | date | NO | MUL
hour | tinyint(4) | NO | 
minute | tinyint(4) | YES | 
buy_volume | decimal(15,2) | YES | 
sell_volume | decimal(15,2) | YES | 
volume | decimal(15,2) | YES | MUL
price | decimal(10,2) | YES | MUL
url_query | text | YES | 
currency | varchar(3) | YES | 
created_at | timestamp | NO | 
time_sequence | tinyint(4) | YES | 

=== DERNIERS ENREGISTREMENTS ===
Array
(
    [id] => 35184
    [market_area] => CH
    [trading_date] => 2026-01-27
    [hour] => 23
    [minute] => 45
    [buy_volume] => 911.20
    [sell_volume] => 242.10
    [volume] => 911.20
    [price] => 102.16
    [url_query] => https://www.epexspot.com/en/market-results?market_area=CH&auction=SWISSIX&trading_date=2026-01-26&delivery_date=2026-01-27&modality=Auction&sub_modality=DayAhead&product=15&data_mode=table
    [currency] => EUR
    [created_at] => 2026-01-26 13:09:08
    [time_sequence] => 1
)

---
Array
(
    [id] => 35183
    [market_area] => CH
    [trading_date] => 2026-01-27
    [hour] => 23
    [minute] => 30
    [buy_volume] => 944.80
    [sell_volume] => 237.60
    [volume] => 944.80
    [price] => 102.74
    [url_query] => https://www.epexspot.com/en/market-results?market_area=CH&auction=SWISSIX&trading_date=2026-01-26&delivery_date=2026-01-27&modality=Auction&sub_modality=DayAhead&product=15&data_mode=table
    [currency] => EUR
    [created_at] => 2026-01-26 13:09:08
    [time_sequence] => 1
)

---
Array
(
    [id] => 35182
    [market_area] => CH
    [trading_date] => 2026-01-27
    [hour] => 23
    [minute] => 15
    [buy_volume] => 965.90
    [sell_volume] => 235.90
    [volume] => 965.90
    [price] => 104.76
    [url_query] => https://www.epexspot.com/en/market-results?market_area=CH&auction=SWISSIX&trading_date=2026-01-26&delivery_date=2026-01-27&modality=Auction&sub_modality=DayAhead&product=15&data_mode=table
    [currency] => EUR
    [created_at] => 2026-01-26 13:09:08
    [time_sequence] => 1
)

---
Array
(
    [id] => 35181
    [market_area] => CH
    [trading_date] => 2026-01-27
    [hour] => 23
    [minute] => 0
    [buy_volume] => 982.40
    [sell_volume] => 236.20
    [volume] => 982.40
    [price] => 108.30
    [url_query] => https://www.epexspot.com/en/market-results?market_area=CH&auction=SWISSIX&trading_date=2026-01-26&delivery_date=2026-01-27&modality=Auction&sub_modality=DayAhead&product=15&data_mode=table
    [currency] => EUR
    [created_at] => 2026-01-26 13:09:08
    [time_sequence] => 1
)

---
Array
(
    [id] => 35180
    [market_area] => CH
    [trading_date] => 2026-01-27
    [hour] => 22
    [minute] => 45
    [buy_volume] => 996.90
    [sell_volume] => 244.80
    [volume] => 996.90
    [price] => 106.46
    [url_query] => https://www.epexspot.com/en/market-results?market_area=CH&auction=SWISSIX&trading_date=2026-01-26&delivery_date=2026-01-27&modality=Auction&sub_modality=DayAhead&product=15&data_mode=table
    [currency] => EUR
    [created_at] => 2026-01-26 13:09:08
    [time_sequence] => 1
)

---

=== COMPTAGE PAR DATE ===
<br />
<b>Fatal error</b>:  Uncaught mysqli_sql_exception: Unknown column 'delivery_date' in 'field list' in C:\xampp\htdocs\scrapping_V4\data\check_epex_table.php:26
Stack trace:
#0 C:\xampp\htdocs\scrapping_V4\data\check_epex_table.php(26): mysqli_query(Object(mysqli), 'SELECT DATE(del...')
#1 {main}
  thrown in <b>C:\xampp\htdocs\scrapping_V4\data\check_epex_table.php</b> on line <b>26</b><br />