=== 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] => 43720
    [market_area] => BE
    [trading_date] => 2026-04-12
    [hour] => 23
    [minute] => 45
    [buy_volume] => 1.36
    [sell_volume] => 147.00
    [volume] => 1.36
    [price] => 110.23
    [url_query] => https://www.epexspot.com/en/market-results?market_area=BE&auction=MRC&trading_date=2026-04-11&delivery_date=2026-04-12&modality=Auction&sub_modality=DayAhead&product=15&data_mode=table
    [currency] => EUR
    [created_at] => 2026-04-13 10:24:07
    [time_sequence] => 1
)

---
Array
(
    [id] => 43719
    [market_area] => BE
    [trading_date] => 2026-04-12
    [hour] => 23
    [minute] => 30
    [buy_volume] => 1.39
    [sell_volume] => 146.40
    [volume] => 1.39
    [price] => 119.42
    [url_query] => https://www.epexspot.com/en/market-results?market_area=BE&auction=MRC&trading_date=2026-04-11&delivery_date=2026-04-12&modality=Auction&sub_modality=DayAhead&product=15&data_mode=table
    [currency] => EUR
    [created_at] => 2026-04-13 10:24:07
    [time_sequence] => 1
)

---
Array
(
    [id] => 43718
    [market_area] => BE
    [trading_date] => 2026-04-12
    [hour] => 23
    [minute] => 15
    [buy_volume] => 1.40
    [sell_volume] => 145.20
    [volume] => 1.40
    [price] => 119.30
    [url_query] => https://www.epexspot.com/en/market-results?market_area=BE&auction=MRC&trading_date=2026-04-11&delivery_date=2026-04-12&modality=Auction&sub_modality=DayAhead&product=15&data_mode=table
    [currency] => EUR
    [created_at] => 2026-04-13 10:24:07
    [time_sequence] => 1
)

---
Array
(
    [id] => 43717
    [market_area] => BE
    [trading_date] => 2026-04-12
    [hour] => 23
    [minute] => 0
    [buy_volume] => 1.41
    [sell_volume] => 157.80
    [volume] => 1.41
    [price] => 135.05
    [url_query] => https://www.epexspot.com/en/market-results?market_area=BE&auction=MRC&trading_date=2026-04-11&delivery_date=2026-04-12&modality=Auction&sub_modality=DayAhead&product=15&data_mode=table
    [currency] => EUR
    [created_at] => 2026-04-13 10:24:07
    [time_sequence] => 1
)

---
Array
(
    [id] => 43716
    [market_area] => BE
    [trading_date] => 2026-04-12
    [hour] => 22
    [minute] => 45
    [buy_volume] => 1.41
    [sell_volume] => 272.60
    [volume] => 1.41
    [price] => 119.41
    [url_query] => https://www.epexspot.com/en/market-results?market_area=BE&auction=MRC&trading_date=2026-04-11&delivery_date=2026-04-12&modality=Auction&sub_modality=DayAhead&product=15&data_mode=table
    [currency] => EUR
    [created_at] => 2026-04-13 10:24:07
    [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 />