search

warren-oneill / powerline

Extension to the zipline library for the German EPEX and EEX energy markets
Other
7 stars 1 forks source link

EPEXSpot import using wrong BEGIN_DATE for H24 #11

Closed dhexus closed 9 years ago

dhexus commented 9 years ago

unbenannt

babadsha commented 9 years ago

Analysis: Timestamps were imported incorrectly due to missing TIMEZONE entry in DATAFEED table.

Solution: For DB initializing, _setup/setupfeeds.sh has been corrected. If you already have a database GG, the following commands will repair your data:

update DATAFEED set TIMEZONE = 'Europe/Berlin';
update TIMESTAMP_DECIMAL set BEGIN_TS = convert_tz(BEGIN_TS, 'Europe/Berlin', 'utc');