How much data you can extract in initial load , like for last year , I believe you may at least once extract some old data and then write a incremental script and add one column as "Today() as date" and saves it on daily basis if the use case is your data is available only for this day. or if you can extract data on week , month so it is also possible ,Its all about your use case , data availability and use case.
