=== STRUCTURE TABLE eex_v2_futures ===

CREATE TABLE `eex_v2_futures` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pricesymbol` varchar(50) DEFAULT NULL,
  `tradedatetimegmt` datetime DEFAULT NULL,
  `onexchsingletradevolume` decimal(15,2) DEFAULT NULL,
  `onexchtradevolumeeex` decimal(15,2) DEFAULT NULL,
  `offexchtradevolumeeex` decimal(15,2) DEFAULT NULL,
  `openinterest` decimal(15,2) DEFAULT NULL,
  `ontradeprice` varchar(50) DEFAULT NULL,
  `close` varchar(50) NOT NULL,
  `service_name` varchar(50) DEFAULT NULL COMMENT 'Service source: futures_power, futures_eua, futures_gas',
  `api_url` varchar(500) DEFAULT NULL COMMENT 'URL API appelée',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_symbol_date` (`pricesymbol`,`tradedatetimegmt`),
  KEY `idx_tradedatetimegmt` (`tradedatetimegmt`),
  KEY `idx_pricesymbol` (`pricesymbol`),
  KEY `idx_service_name` (`service_name`),
  KEY `idx_futures_trade_date` (`tradedatetimegmt`)
) ENGINE=InnoDB AUTO_INCREMENT=6503 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Cotations futures gaz EEX v2'