import { Cast } from './types/Cast';

function create(table: string, query: string, cast: Cast, suf?: string): string {
  return `
  ${cast.CREATE_TBL_PREFIX}${suf ? `${table}_${suf}` : table}${cast.CREATE_TBL_SUFFIX}
  ${cast.CREATE_SUB_PREFIX}
  ${query}
  ${cast.CREATE_SUB_SUFFIX}
  `;
}

export const Customers = {
  select: (_cast: Cast) => `
    select 'AH-10465' as customer_id, 'Customer 1' as customer_name union all
    select 'AJ-10780' as customer_id, 'Customer 2' as customer_name union all
    select 'AS-10225' as customer_id, 'Customer 3' as customer_name union all
    select 'AW-10840' as customer_id, 'Customer 4' as customer_name union all
    select 'BB-11545' as customer_id, 'Customer 5' as customer_name union all
    select 'BF-11020' as customer_id, 'Customer 6' as customer_name union all
    select 'BF-11170' as customer_id, 'Customer 7' as customer_name union all
    select 'BM-11650' as customer_id, 'Customer 8' as customer_name union all
    select 'BS-11380' as customer_id, 'Customer 9' as customer_name union all
    select 'BS-11755' as customer_id, 'Customer 10' as customer_name union all
    select 'CA-12775' as customer_id, 'Customer 11' as customer_name union all
    select 'CC-12475' as customer_id, 'Customer 12' as customer_name union all
    select 'CD-12280' as customer_id, 'Customer 13' as customer_name union all
    select 'CS-12355' as customer_id, 'Customer 14' as customer_name union all
    select 'DB-13405' as customer_id, 'Customer 15' as customer_name union all
    select 'DG-13300' as customer_id, 'Customer 16' as customer_name union all
    select 'DW-13480' as customer_id, 'Customer 17' as customer_name union all
    select 'EM-14140' as customer_id, 'Customer 18' as customer_name union all
    select 'GA-14725' as customer_id, 'Customer 19' as customer_name union all
    select 'GZ-14470' as customer_id, 'Customer 20' as customer_name union all
    select 'HH-15010' as customer_id, 'Customer 21' as customer_name union all
    select 'HK-14890' as customer_id, 'Customer 22' as customer_name union all
    select 'JH-15430' as customer_id, 'Customer 23' as customer_name union all
    select 'JO-15550' as customer_id, 'Customer 24' as customer_name union all
    select 'JS-16030' as customer_id, 'Customer 25' as customer_name union all
    select 'JW-15220' as customer_id, 'Customer 26' as customer_name union all
    select 'KL-16555' as customer_id, 'Customer 27' as customer_name union all
    select 'KN-16705' as customer_id, 'Customer 28' as customer_name union all
    select 'LC-17050' as customer_id, 'Customer 29' as customer_name union all
    select 'LR-16915' as customer_id, 'Customer 30' as customer_name union all
    select 'MC-17605' as customer_id, 'Customer 31' as customer_name union all
    select 'MG-17650' as customer_id, 'Customer 32' as customer_name union all
    select 'ML-17755' as customer_id, 'Customer 33' as customer_name union all
    select 'MM-18280' as customer_id, 'Customer 34' as customer_name union all
    select 'NP-18670' as customer_id, 'Customer 35' as customer_name union all
    select 'PF-19165' as customer_id, 'Customer 36' as customer_name union all
    select 'SB-20185' as customer_id, 'Customer 37' as customer_name union all
    select 'SS-20140' as customer_id, 'Customer 38' as customer_name union all
    select 'TB-21175' as customer_id, 'Customer 39' as customer_name union all
    select 'TS-21205' as customer_id, 'Customer 40' as customer_name union all
    select 'WB-21850' as customer_id, 'Customer 41' as customer_name
  `,
  create: (cast: Cast, name: string, suf?: string) => create(name, Customers.select(cast), cast, suf),
};

export const Products = {
  select: (_cast: Cast) => `
    select 'Furniture' as category, 'Tables' as sub_category, 'Anderson Hickey Conga Table Tops & Accessories' as product_name union all
    select 'Furniture' as category, 'Tables' as sub_category, 'Balt Solid Wood Rectangular Table' as product_name union all
    select 'Furniture' as category, 'Bookcases' as sub_category, 'DMI Eclipse Executive Suite Bookcases' as product_name union all
    select 'Furniture' as category, 'Bookcases' as sub_category, 'Global Adaptabilites Bookcase, Cherry/Storm Gray Finish' as product_name union all
    select 'Furniture' as category, 'Chairs' as sub_category, 'Harbour Creations 67200 Series Stacking Chairs' as product_name union all
    select 'Furniture' as category, 'Chairs' as sub_category, 'Iceberg Nesting Folding Chair, 19w x 6d x 43h' as product_name union all
    select 'Furniture' as category, 'Furnishings' as sub_category, 'Linden 10 Round Wall Clock, Black' as product_name union all
    select 'Furniture' as category, 'Furnishings' as sub_category, 'Magna Visual Magnetic Picture Hangers' as product_name union all
    select 'Office Supplies' as category, 'Art' as sub_category, 'OIC #2 Pencils, Medium Soft' as product_name union all
    select 'Office Supplies' as category, 'Art' as sub_category, 'Panasonic KP-380BK Classic Electric Pencil Sharpener' as product_name union all
    select 'Office Supplies' as category, 'Storage' as sub_category, 'Project Tote Personal File' as product_name union all
    select 'Office Supplies' as category, 'Storage' as sub_category, 'Recycled Eldon Regeneration Jumbo File' as product_name union all
    select 'Office Supplies' as category, 'Envelopes' as sub_category, 'Tyvek Side-Opening Peel & Seel Expanding Envelopes' as product_name union all
    select 'Office Supplies' as category, 'Envelopes' as sub_category, 'Wausau Papers Astrobrights Colored Envelopes' as product_name union all
    select 'Office Supplies' as category, 'Fasteners' as sub_category, 'Vinyl Coated Wire Paper Clips in Organizer Box, 800/Box' as product_name union all
    select 'Office Supplies' as category, 'Fasteners' as sub_category, 'Plymouth Boxed Rubber Bands by Plymouth' as product_name union all
    select 'Technology' as category, 'Accessories' as sub_category, 'Logitech di_Novo Edge Keyboard' as product_name union all
    select 'Technology' as category, 'Accessories' as sub_category, 'Kingston Digital DataTraveler 16GB USB 2.0' as product_name union all
    select 'Technology' as category, 'Accessories' as sub_category, 'Kingston Digital DataTraveler 16GB USB 2.1' as product_name union all
    select 'Technology' as category, 'Accessories' as sub_category, 'Kingston Digital DataTraveler 16GB USB 2.2' as product_name union all
    select 'Technology' as category, 'Phones' as sub_category, 'Google Nexus 5' as product_name union all
    select 'Technology' as category, 'Phones' as sub_category, 'Google Nexus 6' as product_name union all
    select 'Technology' as category, 'Phones' as sub_category, 'Google Nexus 7' as product_name union all
    select 'Technology' as category, 'Phones' as sub_category, 'HTC One' as product_name union all
    select 'Technology' as category, 'Copiers' as sub_category, 'Canon PC1080F Personal Copier' as product_name union all
    select 'Technology' as category, 'Copiers' as sub_category, 'Hewlett Packard 610 Color Digital Copier / Printer' as product_name union all
    select 'Technology' as category, 'Machines' as sub_category, 'Lexmark 20R1285 X6650 Wireless All-in-One Printer' as product_name union all
    select 'Technology' as category, 'Machines' as sub_category, 'Okidata C610n Printer' as product_name
  `,
  create: (cast: Cast, name: string, suf?: string) => create(name, Products.select(cast), cast, suf),
};

export const ECommerce = {
  select: (cast: Cast) => {
    const { DATE_PREFIX, DATE_SUFFIX } = cast;
    return `
      select 3060 as row_id, 'CA-2017-131492' as order_id, ${DATE_PREFIX}'2020-10-19'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-10-20'${DATE_SUFFIX} as completed_date, 'HH-15010' as customer_id, 'San Francisco' as city, 'Furniture' as category, 'Tables' as sub_category, 'Anderson Hickey Conga Table Tops & Accessories' as product_name, 24.36800 as sales, 2 as quantity, 0.20000 as discount, -3.35060 as profit union all
      select 523 as row_id,  'CA-2017-145142' as order_id, ${DATE_PREFIX}'2020-01-23'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-01-24'${DATE_SUFFIX} as completed_date, 'MC-17605' as customer_id, 'Detroit' as city, 'Furniture' as category, 'Tables' as sub_category, 'Balt Solid Wood Rectangular Table' as product_name, 210.98000 as sales, 2 as quantity, 0.00000 as discount, 21.09800 as profit union all
      select 9584 as row_id, 'CA-2017-116127' as order_id, ${DATE_PREFIX}'2020-06-25'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-26'${DATE_SUFFIX} as completed_date, 'SB-20185' as customer_id, 'New York City' as city, 'Furniture' as category, 'Bookcases' as sub_category, 'DMI Eclipse Executive Suite Bookcases' as product_name, 400.78400 as sales, 1 as quantity, 0.20000 as discount, -5.00980 as profit union all
      select 8425 as row_id, 'CA-2017-150091' as order_id, ${DATE_PREFIX}'2020-10-12'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-10-13'${DATE_SUFFIX} as completed_date, 'NP-18670' as customer_id, 'Lakewood' as city, 'Furniture' as category, 'Bookcases' as sub_category, 'Global Adaptabilites Bookcase, Cherry/Storm Gray Finish' as product_name, 2154.90000 as sales, 5 as quantity, 0.00000 as discount, 129.29400 as profit union all
      select 2655 as row_id, 'CA-2017-112515' as order_id, ${DATE_PREFIX}'2020-09-17'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-18'${DATE_SUFFIX} as completed_date, 'AS-10225' as customer_id, 'Provo' as city, 'Furniture' as category, 'Bookcases' as sub_category, 'Global Adaptabilites Bookcase, Cherry/Storm Gray Finish' as product_name, 1292.94000 as sales, 3 as quantity, 0.00000 as discount, 77.57640 as profit union all
      select 2952 as row_id, 'CA-2017-134915' as order_id, ${DATE_PREFIX}'2020-11-12'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-13'${DATE_SUFFIX} as completed_date, 'EM-14140' as customer_id, 'Glendale' as city, 'Furniture' as category, 'Chairs' as sub_category, 'Harbour Creations 67200 Series Stacking Chairs' as product_name, 113.88800 as sales, 2 as quantity, 0.20000 as discount, 9.96520 as profit union all
      select 9473 as row_id, 'CA-2017-102925' as order_id, ${DATE_PREFIX}'2020-11-05'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-06'${DATE_SUFFIX} as completed_date, 'CD-12280' as customer_id, 'New York City' as city, 'Furniture' as category, 'Chairs' as sub_category, 'Harbour Creations 67200 Series Stacking Chairs' as product_name, 128.12400 as sales, 2 as quantity, 0.10000 as discount, 24.20120 as profit union all
      select 5220 as row_id, 'CA-2017-145653' as order_id, ${DATE_PREFIX}'2020-09-01'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-02'${DATE_SUFFIX} as completed_date, 'CA-12775' as customer_id, 'Detroit' as city, 'Furniture' as category, 'Chairs' as sub_category, 'Harbour Creations 67200 Series Stacking Chairs' as product_name, 498.26000 as sales, 7 as quantity, 0.00000 as discount, 134.53020 as profit union all
      select 4031 as row_id, 'CA-2017-124296' as order_id, ${DATE_PREFIX}'2020-12-24'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-25'${DATE_SUFFIX} as completed_date, 'CS-12355' as customer_id, 'Lafayette' as city, 'Furniture' as category, 'Chairs' as sub_category, 'Iceberg Nesting Folding Chair, 19w x 6d x 43h' as product_name, 232.88000 as sales, 4 as quantity, 0.00000 as discount, 60.54880 as profit union all
      select 8621 as row_id, 'US-2017-119319' as order_id, ${DATE_PREFIX}'2020-11-06'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-07'${DATE_SUFFIX} as completed_date, 'LC-17050' as customer_id, 'Dallas' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Linden 10 Round Wall Clock, Black' as product_name, 30.56000 as sales, 5 as quantity, 0.60000 as discount, -19.86400 as profit union all
      select 3059 as row_id, 'CA-2017-131492' as order_id, ${DATE_PREFIX}'2020-10-19'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-10-20'${DATE_SUFFIX} as completed_date, 'HH-15010' as customer_id, 'San Francisco' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Linden 10 Round Wall Clock, Black' as product_name, 30.56000 as sales, 2 as quantity, 0.00000 as discount, 10.39040 as profit union all
      select 7425 as row_id, 'CA-2017-135069' as order_id, ${DATE_PREFIX}'2020-04-10'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-04-11'${DATE_SUFFIX} as completed_date, 'BS-11755' as customer_id, 'Philadelphia' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Linden 10 Round Wall Clock, Black' as product_name, 36.67200 as sales, 3 as quantity, 0.20000 as discount, 6.41760 as profit union all
      select 849 as row_id,  'CA-2017-107503' as order_id, ${DATE_PREFIX}'2020-01-01'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-01-02'${DATE_SUFFIX} as completed_date, 'GA-14725' as customer_id, 'Lorain' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Linden 10 Round Wall Clock, Black' as product_name, 48.89600 as sales, 4 as quantity, 0.20000 as discount, 8.55680 as profit union all
      select 6205 as row_id, 'CA-2017-145660' as order_id, ${DATE_PREFIX}'2020-12-01'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-02'${DATE_SUFFIX} as completed_date, 'MG-17650' as customer_id, 'Marion' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Magna Visual Magnetic Picture Hangers' as product_name, 7.71200 as sales, 2 as quantity, 0.20000 as discount, 1.73520 as profit union all
      select 1494 as row_id, 'CA-2017-139661' as order_id, ${DATE_PREFIX}'2020-10-30'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX} as completed_date, 'JW-15220' as customer_id, 'Vancouver' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Magna Visual Magnetic Picture Hangers' as product_name, 9.64000 as sales, 2 as quantity, 0.00000 as discount, 3.66320 as profit union all
      select 3934 as row_id, 'CA-2017-123001' as order_id, ${DATE_PREFIX}'2020-09-02'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-03'${DATE_SUFFIX} as completed_date, 'AW-10840' as customer_id, 'Bakersfield' as city, 'Office Supplies' as category, 'Art' as sub_category, 'OIC #2 Pencils, Medium Soft' as product_name, 9.40000 as sales, 5 as quantity, 0.00000 as discount, 2.72600 as profit union all
      select 3448 as row_id, 'CA-2017-102554' as order_id, ${DATE_PREFIX}'2020-06-11'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-12'${DATE_SUFFIX} as completed_date, 'KN-16705' as customer_id, 'Auburn' as city, 'Office Supplies' as category, 'Art' as sub_category, 'OIC #2 Pencils, Medium Soft' as product_name, 3.76000 as sales, 2 as quantity, 0.00000 as discount, 1.09040 as profit union all
      select 6459 as row_id, 'US-2017-133361' as order_id, ${DATE_PREFIX}'2020-05-14'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-05-15'${DATE_SUFFIX} as completed_date, 'AJ-10780' as customer_id, 'Baltimore' as city, 'Office Supplies' as category, 'Art' as sub_category, 'OIC #2 Pencils, Medium Soft' as product_name, 3.76000 as sales, 2 as quantity, 0.00000 as discount, 1.09040 as profit union all
      select 6272 as row_id, 'CA-2017-102379' as order_id, ${DATE_PREFIX}'2020-12-02'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-03'${DATE_SUFFIX} as completed_date, 'BB-11545' as customer_id, 'Oakland' as city, 'Office Supplies' as category, 'Art' as sub_category, 'Panasonic KP-380BK Classic Electric Pencil Sharpener' as product_name, 179.90000 as sales, 5 as quantity, 0.00000 as discount, 44.97500 as profit union all
      select 9619 as row_id, 'CA-2017-160633' as order_id, ${DATE_PREFIX}'2020-11-16'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-17'${DATE_SUFFIX} as completed_date, 'BS-11380' as customer_id, 'Bowling' as city, 'Office Supplies' as category, 'Art' as sub_category, 'Panasonic KP-380BK Classic Electric Pencil Sharpener' as product_name, 86.35200 as sales, 3 as quantity, 0.20000 as discount, 5.39700 as profit union all
      select 1013 as row_id, 'CA-2017-118437' as order_id, ${DATE_PREFIX}'2020-06-17'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-18'${DATE_SUFFIX} as completed_date, 'PF-19165' as customer_id, 'Olympia' as city, 'Office Supplies' as category, 'Storage' as sub_category, 'Project Tote Personal File' as product_name, 14.03000 as sales, 1 as quantity, 0.00000 as discount, 4.06870 as profit union all
      select 4012 as row_id, 'CA-2017-100811' as order_id, ${DATE_PREFIX}'2020-11-21'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX} as completed_date, 'CC-12475' as customer_id, 'Philadelphia' as city, 'Office Supplies' as category, 'Storage' as sub_category, 'Recycled Eldon Regeneration Jumbo File' as product_name, 39.29600 as sales, 4 as quantity, 0.20000 as discount, 3.92960 as profit union all
      select 2595 as row_id, 'CA-2017-149048' as order_id, ${DATE_PREFIX}'2020-05-13'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-05-14'${DATE_SUFFIX} as completed_date, 'BM-11650' as customer_id, 'Columbus' as city, 'Office Supplies' as category, 'Envelopes' as sub_category, 'Tyvek Side-Opening Peel & Seel Expanding Envelopes' as product_name, 180.96000 as sales, 2 as quantity, 0.00000 as discount, 81.43200 as profit union all
      select 2329 as row_id, 'CA-2017-138422' as order_id, ${DATE_PREFIX}'2020-09-23'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-24'${DATE_SUFFIX} as completed_date, 'KN-16705' as customer_id, 'Columbus' as city, 'Office Supplies' as category, 'Envelopes' as sub_category, 'Wausau Papers Astrobrights Colored Envelopes' as product_name, 14.35200 as sales, 3 as quantity, 0.20000 as discount, 5.20260 as profit union all
      select 4227 as row_id, 'CA-2017-120327' as order_id, ${DATE_PREFIX}'2020-11-11'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-12'${DATE_SUFFIX} as completed_date, 'WB-21850' as customer_id, 'Columbus' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Vinyl Coated Wire Paper Clips in Organizer Box, 800/Box' as product_name, 45.92000 as sales, 4 as quantity, 0.00000 as discount, 21.58240 as profit union all
      select 6651 as row_id, 'US-2017-124779' as order_id, ${DATE_PREFIX}'2020-09-08'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-09'${DATE_SUFFIX} as completed_date, 'BF-11020' as customer_id, 'Arlington' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Vinyl Coated Wire Paper Clips in Organizer Box, 800/Box' as product_name, 45.92000 as sales, 5 as quantity, 0.20000 as discount, 15.49800 as profit union all
      select 8673 as row_id, 'CA-2017-163265' as order_id, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-02-17'${DATE_SUFFIX} as completed_date, 'JS-16030' as customer_id, 'Decatur' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Vinyl Coated Wire Paper Clips in Organizer Box, 800/Box' as product_name, 18.36800 as sales, 2 as quantity, 0.20000 as discount, 6.19920 as profit union all
      select 1995 as row_id, 'CA-2017-133648' as order_id, ${DATE_PREFIX}'2020-06-25'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-26'${DATE_SUFFIX} as completed_date, 'ML-17755' as customer_id, 'Columbus' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Plymouth Boxed Rubber Bands by Plymouth' as product_name, 11.30400 as sales, 3 as quantity, 0.20000 as discount, -2.11950 as profit union all
      select 7310 as row_id, 'CA-2017-112172' as order_id, ${DATE_PREFIX}'2020-06-10'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-11'${DATE_SUFFIX} as completed_date, 'MM-18280' as customer_id, 'New York City' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Plymouth Boxed Rubber Bands by Plymouth' as product_name, 14.13000 as sales, 3 as quantity, 0.00000 as discount, 0.70650 as profit union all
      select 3717 as row_id, 'CA-2017-144568' as order_id, ${DATE_PREFIX}'2020-05-29'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-05-30'${DATE_SUFFIX} as completed_date, 'JO-15550' as customer_id, 'Omaha' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Plymouth Boxed Rubber Bands by Plymouth' as product_name, 23.55000 as sales, 5 as quantity, 0.00000 as discount, 1.17750 as profit union all
      select 4882 as row_id, 'CA-2017-143567' as order_id, ${DATE_PREFIX}'2020-11-02'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-03'${DATE_SUFFIX} as completed_date, 'TB-21175' as customer_id, 'Columbus' as city, 'Technology' as category, 'Accessories' as sub_category, 'Logitech di_Novo Edge Keyboard' as product_name, 2249.91000 as sales, 9 as quantity, 0.00000 as discount, 517.47930 as profit union all
      select 5277 as row_id, 'CA-2017-147333' as order_id, ${DATE_PREFIX}'2020-12-14'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-15'${DATE_SUFFIX} as completed_date, 'KL-16555' as customer_id, 'Columbus' as city, 'Technology' as category, 'Accessories' as sub_category, 'Kingston Digital DataTraveler 16GB USB 2.0' as product_name, 44.75000 as sales, 5 as quantity, 0.00000 as discount, 8.50250 as profit union all
      select 6125 as row_id, 'CA-2017-145772' as order_id, ${DATE_PREFIX}'2020-06-03'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-04'${DATE_SUFFIX} as completed_date, 'SS-20140' as customer_id, 'Los Angeles' as city, 'Technology' as category, 'Accessories' as sub_category, 'Kingston Digital DataTraveler 16GB USB 2.1' as product_name, 44.75000 as sales, 5 as quantity, 0.00000 as discount, 8.50250 as profit union all
      select 2455 as row_id, 'CA-2017-140949' as order_id, ${DATE_PREFIX}'2020-03-17'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-03-18'${DATE_SUFFIX} as completed_date, 'DB-13405' as customer_id, 'New York City' as city, 'Technology' as category, 'Accessories' as sub_category, 'Kingston Digital DataTraveler 16GB USB 2.2' as product_name, 71.60000 as sales, 8 as quantity, 0.00000 as discount, 13.60400 as profit union all
      select 2661 as row_id, 'CA-2017-123372' as order_id, ${DATE_PREFIX}'2020-11-28'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX} as completed_date, 'DG-13300' as customer_id, 'Columbus' as city, 'Technology' as category, 'Phones' as sub_category, 'Google Nexus 5' as product_name, 1979.89000 as sales, 11 as quantity, 0.00000 as discount, 494.97250 as profit union all
      select 3083 as row_id, 'US-2017-132297' as order_id, ${DATE_PREFIX}'2020-05-27'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-05-28'${DATE_SUFFIX} as completed_date, 'DW-13480' as customer_id, 'Louisville' as city, 'Technology' as category, 'Phones' as sub_category, 'Google Nexus 6' as product_name, 539.97000 as sales, 3 as quantity, 0.00000 as discount, 134.99250 as profit union all
      select 4161 as row_id, 'CA-2017-115546' as order_id, ${DATE_PREFIX}'2020-05-14'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-05-15'${DATE_SUFFIX} as completed_date, 'AH-10465' as customer_id, 'New York City' as city, 'Technology' as category, 'Phones' as sub_category, 'Google Nexus 7' as product_name, 539.97000 as sales, 3 as quantity, 0.00000 as discount, 134.99250 as profit union all
      select 8697 as row_id, 'CA-2017-119284' as order_id, ${DATE_PREFIX}'2020-06-15'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-16'${DATE_SUFFIX} as completed_date, 'TS-21205' as customer_id, 'Columbus' as city, 'Technology' as category, 'Phones' as sub_category, 'HTC One' as product_name, 239.97600 as sales, 3 as quantity, 0.20000 as discount, 26.99730 as profit union all
      select 7698 as row_id, 'CA-2017-151799' as order_id, ${DATE_PREFIX}'2020-12-14'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-17'${DATE_SUFFIX} as completed_date, 'BF-11170' as customer_id, 'Columbus' as city, 'Technology' as category, 'Copiers' as sub_category, 'Canon PC1080F Personal Copier' as product_name, 1199.98000 as sales, 2 as quantity, 0.00000 as discount, 467.99220 as profit union all
      select 7174 as row_id, 'US-2017-141677' as order_id, ${DATE_PREFIX}'2020-03-26'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-03-27'${DATE_SUFFIX} as completed_date, 'HK-14890' as customer_id, 'Houston' as city, 'Technology' as category, 'Copiers' as sub_category, 'Canon PC1080F Personal Copier' as product_name, 2399.96000 as sales, 5 as quantity, 0.20000 as discount, 569.99050 as profit union all
      select 9618 as row_id, 'CA-2017-160633' as order_id, ${DATE_PREFIX}'2020-11-16'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-17'${DATE_SUFFIX} as completed_date, 'BS-11380' as customer_id, 'Columbus' as city, 'Technology' as category, 'Copiers' as sub_category, 'Hewlett Packard 610 Color Digital Copier / Printer' as product_name, 899.98200 as sales, 3 as quantity, 0.40000 as discount, 74.99850 as profit union all
      select 8958 as row_id, 'CA-2017-105620' as order_id, ${DATE_PREFIX}'2020-12-25'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-26'${DATE_SUFFIX} as completed_date, 'JH-15430' as customer_id, 'Columbus' as city, 'Technology' as category, 'Machines' as sub_category, 'Lexmark 20R1285 X6650 Wireless All-in-One Printer' as product_name, 120.00000 as sales, 2 as quantity, 0.50000 as discount, -7.20000 as profit union all
      select 8878 as row_id, 'CA-2017-126928' as order_id, ${DATE_PREFIX}'2020-09-17'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-18'${DATE_SUFFIX} as completed_date, 'GZ-14470' as customer_id, 'Morristown' as city, 'Technology' as category, 'Machines' as sub_category, 'Lexmark 20R1285 X6650 Wireless All-in-One Printer' as product_name, 480.00000 as sales, 4 as quantity, 0.00000 as discount, 225.60000 as profit union all
      select 7293 as row_id, 'CA-2017-109183' as order_id, ${DATE_PREFIX}'2020-12-04'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-05'${DATE_SUFFIX} as completed_date, 'LR-16915' as customer_id, 'Columbus' as city, 'Technology' as category, 'Machines' as sub_category, 'Okidata C610n Printer' as product_name, 649.00000 as sales, 2 as quantity, 0.50000 as discount, -272.58000 as profit
    `;
  },
  create: (cast: Cast, name: string, suf?: string) => create(name, ECommerce.select(cast), cast, suf),
};

export const BigECommerce = {
  select: (cast: Cast) => {
    const { GENERATE_BIG_SERIES, DATE_PREFIX, DATE_SUFFIX, TRUE_LITERAL, FALSE_LITERAL } = cast;
    const trueLiteral = TRUE_LITERAL || 'true';
    const falseLiteral = FALSE_LITERAL || 'false';
    const data = `
      select 3060 as row_id, 'CA-2017-131492' as order_id, ${DATE_PREFIX}'2020-10-19'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-10-20'${DATE_SUFFIX} as completed_date, 'HH-15010' as customer_id, 'San Francisco' as city, 'Furniture' as category, 'Tables' as sub_category, 'Anderson Hickey Conga Table Tops & Accessories' as product_name, 24.36800 as sales, 2 as quantity, 0.20000 as discount, -3.35060 as profit, ${falseLiteral} as is_returning union all
      select 523 as row_id,  'CA-2017-145142' as order_id, ${DATE_PREFIX}'2020-01-23'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-01-24'${DATE_SUFFIX} as completed_date, 'MC-17605' as customer_id, 'Detroit' as city, 'Furniture' as category, 'Tables' as sub_category, 'Balt Solid Wood Rectangular Table' as product_name, 210.98000 as sales, 2 as quantity, 0.00000 as discount, 21.09800 as profit, ${falseLiteral} as is_returning union all
      select 9584 as row_id, 'CA-2017-116127' as order_id, ${DATE_PREFIX}'2020-06-25'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-26'${DATE_SUFFIX} as completed_date, 'SB-20185' as customer_id, 'New York City' as city, 'Furniture' as category, 'Bookcases' as sub_category, 'DMI Eclipse Executive Suite Bookcases' as product_name, 400.78400 as sales, 1 as quantity, 0.20000 as discount, -5.00980 as profit, ${falseLiteral} as is_returning union all
      select 8425 as row_id, 'CA-2017-150091' as order_id, ${DATE_PREFIX}'2020-10-12'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-10-13'${DATE_SUFFIX} as completed_date, 'NP-18670' as customer_id, 'Lakewood' as city, 'Furniture' as category, 'Bookcases' as sub_category, 'Global Adaptabilites Bookcase, Cherry/Storm Gray Finish' as product_name, 2154.90000 as sales, 5 as quantity, 0.00000 as discount, 129.29400 as profit, ${falseLiteral} as is_returning union all
      select 2655 as row_id, 'CA-2017-112515' as order_id, ${DATE_PREFIX}'2020-09-17'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-18'${DATE_SUFFIX} as completed_date, 'AS-10225' as customer_id, 'Provo' as city, 'Furniture' as category, 'Bookcases' as sub_category, 'Global Adaptabilites Bookcase, Cherry/Storm Gray Finish' as product_name, 1292.94000 as sales, 3 as quantity, 0.00000 as discount, 77.57640 as profit, ${falseLiteral} as is_returning union all
      select 2952 as row_id, 'CA-2017-134915' as order_id, ${DATE_PREFIX}'2020-11-12'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-13'${DATE_SUFFIX} as completed_date, 'EM-14140' as customer_id, 'Glendale' as city, 'Furniture' as category, 'Chairs' as sub_category, 'Harbour Creations 67200 Series Stacking Chairs' as product_name, 113.88800 as sales, 2 as quantity, 0.20000 as discount, 9.96520 as profit, ${falseLiteral} as is_returning union all
      select 9473 as row_id, 'CA-2017-102925' as order_id, ${DATE_PREFIX}'2020-11-05'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-06'${DATE_SUFFIX} as completed_date, 'CD-12280' as customer_id, 'New York City' as city, 'Furniture' as category, 'Chairs' as sub_category, 'Harbour Creations 67200 Series Stacking Chairs' as product_name, 128.12400 as sales, 2 as quantity, 0.10000 as discount, 24.20120 as profit, ${falseLiteral} as is_returning union all
      select 5220 as row_id, 'CA-2017-145653' as order_id, ${DATE_PREFIX}'2020-09-01'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-02'${DATE_SUFFIX} as completed_date, 'CA-12775' as customer_id, 'Detroit' as city, 'Furniture' as category, 'Chairs' as sub_category, 'Harbour Creations 67200 Series Stacking Chairs' as product_name, 498.26000 as sales, 7 as quantity, 0.00000 as discount, 134.53020 as profit, ${falseLiteral} as is_returning union all
      select 4031 as row_id, 'CA-2017-124296' as order_id, ${DATE_PREFIX}'2020-12-24'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-25'${DATE_SUFFIX} as completed_date, 'CS-12355' as customer_id, 'Lafayette' as city, 'Furniture' as category, 'Chairs' as sub_category, 'Iceberg Nesting Folding Chair, 19w x 6d x 43h' as product_name, 232.88000 as sales, 4 as quantity, 0.00000 as discount, 60.54880 as profit, ${trueLiteral} as is_returning union all
      select 8621 as row_id, 'US-2017-119319' as order_id, ${DATE_PREFIX}'2020-11-06'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-07'${DATE_SUFFIX} as completed_date, 'LC-17050' as customer_id, 'Dallas' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Linden 10 Round Wall Clock, Black' as product_name, 30.56000 as sales, 5 as quantity, 0.60000 as discount, -19.86400 as profit, ${falseLiteral} as is_returning union all
      select 3059 as row_id, 'CA-2017-131492' as order_id, ${DATE_PREFIX}'2020-10-19'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-10-20'${DATE_SUFFIX} as completed_date, 'HH-15010' as customer_id, 'San Francisco' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Linden 10 Round Wall Clock, Black' as product_name, 30.56000 as sales, 2 as quantity, 0.00000 as discount, 10.39040 as profit, ${falseLiteral} as is_returning union all
      select 7425 as row_id, 'CA-2017-135069' as order_id, ${DATE_PREFIX}'2020-04-10'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-04-11'${DATE_SUFFIX} as completed_date, 'BS-11755' as customer_id, 'Philadelphia' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Linden 10 Round Wall Clock, Black' as product_name, 36.67200 as sales, 3 as quantity, 0.20000 as discount, 6.41760 as profit, ${falseLiteral} as is_returning union all
      select 849 as row_id,  'CA-2017-107503' as order_id, ${DATE_PREFIX}'2020-01-01'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-01-02'${DATE_SUFFIX} as completed_date, 'GA-14725' as customer_id, 'Lorain' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Linden 10 Round Wall Clock, Black' as product_name, 48.89600 as sales, 4 as quantity, 0.20000 as discount, 8.55680 as profit, ${trueLiteral} as is_returning union all
      select 6205 as row_id, 'CA-2017-145660' as order_id, ${DATE_PREFIX}'2020-12-01'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-02'${DATE_SUFFIX} as completed_date, 'MG-17650' as customer_id, 'Marion' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Magna Visual Magnetic Picture Hangers' as product_name, 7.71200 as sales, 2 as quantity, 0.20000 as discount, 1.73520 as profit, ${falseLiteral} as is_returning union all
      select 1494 as row_id, 'CA-2017-139661' as order_id, ${DATE_PREFIX}'2020-10-30'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX} as completed_date, 'JW-15220' as customer_id, 'Vancouver' as city, 'Furniture' as category, 'Furnishings' as sub_category, 'Magna Visual Magnetic Picture Hangers' as product_name, 9.64000 as sales, 2 as quantity, 0.00000 as discount, 3.66320 as profit, ${falseLiteral} as is_returning union all
      select 3934 as row_id, 'CA-2017-123001' as order_id, ${DATE_PREFIX}'2020-09-02'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-03'${DATE_SUFFIX} as completed_date, 'AW-10840' as customer_id, 'Bakersfield' as city, 'Office Supplies' as category, 'Art' as sub_category, 'OIC #2 Pencils, Medium Soft' as product_name, 9.40000 as sales, 5 as quantity, 0.00000 as discount, 2.72600 as profit, ${falseLiteral} as is_returning union all
      select 3448 as row_id, 'CA-2017-102554' as order_id, ${DATE_PREFIX}'2020-06-11'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-12'${DATE_SUFFIX} as completed_date, 'KN-16705' as customer_id, 'Auburn' as city, 'Office Supplies' as category, 'Art' as sub_category, 'OIC #2 Pencils, Medium Soft' as product_name, 3.76000 as sales, 2 as quantity, 0.00000 as discount, 1.09040 as profit, ${falseLiteral} as is_returning union all
      select 6459 as row_id, 'US-2017-133361' as order_id, ${DATE_PREFIX}'2020-05-14'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-05-15'${DATE_SUFFIX} as completed_date, 'AJ-10780' as customer_id, 'Baltimore' as city, 'Office Supplies' as category, 'Art' as sub_category, 'OIC #2 Pencils, Medium Soft' as product_name, 3.76000 as sales, 2 as quantity, 0.00000 as discount, 1.09040 as profit, ${falseLiteral} as is_returning union all
      select 6272 as row_id, 'CA-2017-102379' as order_id, ${DATE_PREFIX}'2020-12-02'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-03'${DATE_SUFFIX} as completed_date, 'BB-11545' as customer_id, 'Oakland' as city, 'Office Supplies' as category, 'Art' as sub_category, 'Panasonic KP-380BK Classic Electric Pencil Sharpener' as product_name, 179.90000 as sales, 5 as quantity, 0.00000 as discount, 44.97500 as profit, ${falseLiteral} as is_returning union all
      select 9619 as row_id, 'CA-2017-160633' as order_id, ${DATE_PREFIX}'2020-11-16'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-17'${DATE_SUFFIX} as completed_date, 'BS-11380' as customer_id, 'Bowling' as city, 'Office Supplies' as category, 'Art' as sub_category, 'Panasonic KP-380BK Classic Electric Pencil Sharpener' as product_name, 86.35200 as sales, 3 as quantity, 0.20000 as discount, 5.39700 as profit, ${falseLiteral} as is_returning union all
      select 1013 as row_id, 'CA-2017-118437' as order_id, ${DATE_PREFIX}'2020-06-17'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-18'${DATE_SUFFIX} as completed_date, 'PF-19165' as customer_id, 'Olympia' as city, 'Office Supplies' as category, 'Storage' as sub_category, 'Project Tote Personal File' as product_name, 14.03000 as sales, 1 as quantity, 0.00000 as discount, 4.06870 as profit, ${falseLiteral} as is_returning union all
      select 4012 as row_id, 'CA-2017-100811' as order_id, ${DATE_PREFIX}'2020-11-21'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX} as completed_date, 'CC-12475' as customer_id, 'Philadelphia' as city, 'Office Supplies' as category, 'Storage' as sub_category, 'Recycled Eldon Regeneration Jumbo File' as product_name, 39.29600 as sales, 4 as quantity, 0.20000 as discount, 3.92960 as profit, ${falseLiteral} as is_returning union all
      select 2595 as row_id, 'CA-2017-149048' as order_id, ${DATE_PREFIX}'2020-05-13'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-05-14'${DATE_SUFFIX} as completed_date, 'BM-11650' as customer_id, 'Columbus' as city, 'Office Supplies' as category, 'Envelopes' as sub_category, 'Tyvek Side-Opening Peel & Seel Expanding Envelopes' as product_name, 180.96000 as sales, 2 as quantity, 0.00000 as discount, 81.43200 as profit, ${falseLiteral} as is_returning union all
      select 2329 as row_id, 'CA-2017-138422' as order_id, ${DATE_PREFIX}'2020-09-23'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-24'${DATE_SUFFIX} as completed_date, 'KN-16705' as customer_id, 'Columbus' as city, 'Office Supplies' as category, 'Envelopes' as sub_category, 'Wausau Papers Astrobrights Colored Envelopes' as product_name, 14.35200 as sales, 3 as quantity, 0.20000 as discount, 5.20260 as profit, ${falseLiteral} as is_returning union all
      select 4227 as row_id, 'CA-2017-120327' as order_id, ${DATE_PREFIX}'2020-11-11'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-12'${DATE_SUFFIX} as completed_date, 'WB-21850' as customer_id, 'Columbus' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Vinyl Coated Wire Paper Clips in Organizer Box, 800/Box' as product_name, 45.92000 as sales, 4 as quantity, 0.00000 as discount, 21.58240 as profit, ${falseLiteral} as is_returning union all
      select 6651 as row_id, 'US-2017-124779' as order_id, ${DATE_PREFIX}'2020-09-08'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-09'${DATE_SUFFIX} as completed_date, 'BF-11020' as customer_id, 'Arlington' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Vinyl Coated Wire Paper Clips in Organizer Box, 800/Box' as product_name, 45.92000 as sales, 5 as quantity, 0.20000 as discount, 15.49800 as profit, ${falseLiteral} as is_returning union all
      select 8673 as row_id, 'CA-2017-163265' as order_id, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-02-17'${DATE_SUFFIX} as completed_date, 'JS-16030' as customer_id, 'Decatur' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Vinyl Coated Wire Paper Clips in Organizer Box, 800/Box' as product_name, 18.36800 as sales, 2 as quantity, 0.20000 as discount, 6.19920 as profit, ${falseLiteral} as is_returning union all
      select 1995 as row_id, 'CA-2017-133648' as order_id, ${DATE_PREFIX}'2020-06-25'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-26'${DATE_SUFFIX} as completed_date, 'ML-17755' as customer_id, 'Columbus' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Plymouth Boxed Rubber Bands by Plymouth' as product_name, 11.30400 as sales, 3 as quantity, 0.20000 as discount, -2.11950 as profit, ${falseLiteral} as is_returning union all
      select 7310 as row_id, 'CA-2017-112172' as order_id, ${DATE_PREFIX}'2020-06-10'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-11'${DATE_SUFFIX} as completed_date, 'MM-18280' as customer_id, 'New York City' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Plymouth Boxed Rubber Bands by Plymouth' as product_name, 14.13000 as sales, 3 as quantity, 0.00000 as discount, 0.70650 as profit, ${falseLiteral} as is_returning union all
      select 3717 as row_id, 'CA-2017-144568' as order_id, ${DATE_PREFIX}'2020-05-29'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-05-30'${DATE_SUFFIX} as completed_date, 'JO-15550' as customer_id, 'Omaha' as city, 'Office Supplies' as category, 'Fasteners' as sub_category, 'Plymouth Boxed Rubber Bands by Plymouth' as product_name, 23.55000 as sales, 5 as quantity, 0.00000 as discount, 1.17750 as profit, ${falseLiteral} as is_returning union all
      select 4882 as row_id, 'CA-2017-143567' as order_id, ${DATE_PREFIX}'2020-11-02'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-03'${DATE_SUFFIX} as completed_date, 'TB-21175' as customer_id, 'Columbus' as city, 'Technology' as category, 'Accessories' as sub_category, 'Logitech di_Novo Edge Keyboard' as product_name, 2249.91000 as sales, 9 as quantity, 0.00000 as discount, 517.47930 as profit, ${falseLiteral} as is_returning union all
      select 5277 as row_id, 'CA-2017-147333' as order_id, ${DATE_PREFIX}'2020-12-14'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-15'${DATE_SUFFIX} as completed_date, 'KL-16555' as customer_id, 'Columbus' as city, 'Technology' as category, 'Accessories' as sub_category, 'Kingston Digital DataTraveler 16GB USB 2.0' as product_name, 44.75000 as sales, 5 as quantity, 0.00000 as discount, 8.50250 as profit, ${falseLiteral} as is_returning union all
      select 6125 as row_id, 'CA-2017-145772' as order_id, ${DATE_PREFIX}'2020-06-03'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-04'${DATE_SUFFIX} as completed_date, 'SS-20140' as customer_id, 'Los Angeles' as city, 'Technology' as category, 'Accessories' as sub_category, 'Kingston Digital DataTraveler 16GB USB 2.1' as product_name, 44.75000 as sales, 5 as quantity, 0.00000 as discount, 8.50250 as profit, ${falseLiteral} as is_returning union all
      select 2455 as row_id, 'CA-2017-140949' as order_id, ${DATE_PREFIX}'2020-03-17'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-03-18'${DATE_SUFFIX} as completed_date, 'DB-13405' as customer_id, 'New York City' as city, 'Technology' as category, 'Accessories' as sub_category, 'Kingston Digital DataTraveler 16GB USB 2.2' as product_name, 71.60000 as sales, 8 as quantity, 0.00000 as discount, 13.60400 as profit, ${falseLiteral} as is_returning union all
      select 2661 as row_id, 'CA-2017-123372' as order_id, ${DATE_PREFIX}'2020-11-28'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX} as completed_date, 'DG-13300' as customer_id, 'Columbus' as city, 'Technology' as category, 'Phones' as sub_category, 'Google Nexus 5' as product_name, 1979.89000 as sales, 11 as quantity, 0.00000 as discount, 494.97250 as profit, ${falseLiteral} as is_returning union all
      select 3083 as row_id, 'US-2017-132297' as order_id, ${DATE_PREFIX}'2020-05-27'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-05-28'${DATE_SUFFIX} as completed_date, 'DW-13480' as customer_id, 'Louisville' as city, 'Technology' as category, 'Phones' as sub_category, 'Google Nexus 6' as product_name, 539.97000 as sales, 3 as quantity, 0.00000 as discount, 134.99250 as profit, ${falseLiteral} as is_returning union all
      select 4161 as row_id, 'CA-2017-115546' as order_id, ${DATE_PREFIX}'2020-05-14'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-05-15'${DATE_SUFFIX} as completed_date, 'AH-10465' as customer_id, 'New York City' as city, 'Technology' as category, 'Phones' as sub_category, 'Google Nexus 7' as product_name, 539.97000 as sales, 3 as quantity, 0.00000 as discount, 134.99250 as profit, ${falseLiteral} as is_returning union all
      select 8697 as row_id, 'CA-2017-119284' as order_id, ${DATE_PREFIX}'2020-06-15'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-06-16'${DATE_SUFFIX} as completed_date, 'TS-21205' as customer_id, 'Columbus' as city, 'Technology' as category, 'Phones' as sub_category, 'HTC One' as product_name, 239.97600 as sales, 3 as quantity, 0.20000 as discount, 26.99730 as profit, ${falseLiteral} as is_returning union all
      select 7698 as row_id, 'CA-2017-151799' as order_id, ${DATE_PREFIX}'2020-12-14'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-15'${DATE_SUFFIX} as completed_date, 'BF-11170' as customer_id, 'Columbus' as city, 'Technology' as category, 'Copiers' as sub_category, 'Canon PC1080F Personal Copier' as product_name, 1199.98000 as sales, 2 as quantity, 0.00000 as discount, 467.99220 as profit, ${falseLiteral} as is_returning union all
      select 7174 as row_id, 'US-2017-141677' as order_id, ${DATE_PREFIX}'2020-03-26'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-03-27'${DATE_SUFFIX} as completed_date, 'HK-14890' as customer_id, 'Houston' as city, 'Technology' as category, 'Copiers' as sub_category, 'Canon PC1080F Personal Copier' as product_name, 2399.96000 as sales, 5 as quantity, 0.20000 as discount, 569.99050 as profit, ${falseLiteral} as is_returning union all
      select 9618 as row_id, 'CA-2017-160633' as order_id, ${DATE_PREFIX}'2020-11-16'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-11-17'${DATE_SUFFIX} as completed_date, 'BS-11380' as customer_id, 'Columbus' as city, 'Technology' as category, 'Copiers' as sub_category, 'Hewlett Packard 610 Color Digital Copier / Printer' as product_name, 899.98200 as sales, 3 as quantity, 0.40000 as discount, 74.99850 as profit, ${falseLiteral} as is_returning union all
      select 8958 as row_id, 'CA-2017-105620' as order_id, ${DATE_PREFIX}'2020-12-25'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-26'${DATE_SUFFIX} as completed_date, 'JH-15430' as customer_id, 'Columbus' as city, 'Technology' as category, 'Machines' as sub_category, 'Lexmark 20R1285 X6650 Wireless All-in-One Printer' as product_name, NULL as sales, 2 as quantity, 0.50000 as discount, -7.20000 as profit, NULL as is_returning union all
      select 8878 as row_id, 'CA-2017-126928' as order_id, ${DATE_PREFIX}'2020-09-17'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-09-18'${DATE_SUFFIX} as completed_date, 'GZ-14470' as customer_id, 'Morristown' as city, 'Technology' as category, 'Machines' as sub_category, 'Lexmark 20R1285 X6650 Wireless All-in-One Printer' as product_name, 600.00000 as sales, 4 as quantity, 0.00000 as discount, 225.60000 as profit, ${falseLiteral} as is_returning union all
      select 7293 as row_id, 'CA-2017-109183' as order_id, ${DATE_PREFIX}'2020-12-04'${DATE_SUFFIX} as order_date, ${DATE_PREFIX}'2020-12-05'${DATE_SUFFIX} as completed_date, 'LR-16915' as customer_id, 'Columbus' as city, 'Technology' as category, 'Machines' as sub_category, 'Okidata C610n Printer' as product_name, 649.00000 as sales, 2 as quantity, 0.50000 as discount, -272.58000 as profit, ${falseLiteral} as is_returning
    `;
    if (!GENERATE_BIG_SERIES) {
      return `SELECT row_id as id, row_id, order_id, order_date, completed_date, city, category, sub_category, product_name, customer_id, sales, quantity, discount, profit, is_returning from (${data}) d`;
    }

    return `select value * 10000 + row_id as id, row_id, order_id, order_date, completed_date, city, category, sub_category, product_name, customer_id, sales, quantity, discount, profit, is_returning from ${GENERATE_BIG_SERIES} CROSS JOIN (${data}) d`;
  },
  create: (cast: Cast, name: string, suf?: string) => create(name, BigECommerce.select(cast), cast, suf),
};

export const RetailCalendar = {
  select: (cast: Cast) => {
    const { DATE_PREFIX, DATE_SUFFIX } = cast;
    // Calendar data for retail dates holds full 2020 year and small portion of the end of 2019.
    // As some DWHs are not able to process large datasets (e.g. Athena throws Member must have length less than or equal to 262144).
    return `
      SELECT ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX} AS date_val, '2019' AS retail_year_name, '2019-Q1' AS retail_quarter_name, '2019-M01' AS retail_month_name, '2019-W01' AS retail_week_name, ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX} AS retail_year_begin_date, ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX} AS retail_quarter_begin_date, ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX} AS retail_month_begin_date, ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX} AS retail_week_begin_date, ${DATE_PREFIX}'2019-01-06'${DATE_SUFFIX} AS retail_date_prev_month, ${DATE_PREFIX}'2018-11-04'${DATE_SUFFIX} AS retail_date_prev_quarter, ${DATE_PREFIX}'2018-02-04'${DATE_SUFFIX} AS retail_date_prev_year
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W40', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-04'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W40', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-05'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W40', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-06'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W40', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-07'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W40', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-08'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W40', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-09'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W40', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W41', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-11'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W41', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-12'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W41', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-13'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W41', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-14'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W41', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-15'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W41', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-16'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W41', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W42', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-18'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W42', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-19'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W42', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-20'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W42', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-21'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W42', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-22'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W42', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-23'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W42', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W43', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-25'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W43', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-26'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W43', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-27'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W43', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-28'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W43', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-29'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W43', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-11-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-11-30'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M10', '2019-W43', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W44', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-02'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W44', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-03'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W44', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-04'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W44', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-05'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W44', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-06'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W44', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-07'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W44', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W45', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-09'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W45', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-10'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W45', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-11'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W45', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-12'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W45', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-13'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W45', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-14'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W45', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W46', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-16'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W46', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-17'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W46', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-18'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W46', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-19'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W46', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-20'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W46', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-21'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W46', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W47', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-23'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W47', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-24'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W47', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-25'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W47', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-26'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W47', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-27'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W47', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-28'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W47', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-29'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W48', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2019-09-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-30'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W48', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2019-09-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2018-12-31'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2019-12-31'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W48', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2019-10-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-01'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W48', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2019-10-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-02'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W48', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2019-10-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-03'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W48', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2019-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-04'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M11', '2019-W48', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2019-10-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W49', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-06'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W49', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-07'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W49', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-08'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W49', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-09'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W49', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-10'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W49', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-11'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W49', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W50', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-13'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W50', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-14'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W50', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-15'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W50', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-16'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W50', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-17'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W50', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-18'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W50', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W51', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-20'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W51', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-21'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W51', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-22'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W51', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-23'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W51', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-24'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W51', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-25'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W51', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W52', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-27'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W52', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-28'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W52', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-29'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W52', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-30'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W52', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-01-31'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-01-31'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W52', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-01'${DATE_SUFFIX}, '2019', '2019-Q4', '2019-M12', '2019-W52', ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W01', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-03'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W01', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-04'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W01', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-05'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W01', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-06'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W01', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-07'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W01', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-08'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W01', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-09'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W02', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-10'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W02', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-11'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W02', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-12'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W02', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-13'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W02', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-14'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W02', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-15'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W02', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W03', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-17'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W03', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-18'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W03', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-19'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W03', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-20'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W03', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-21'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W03', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-22'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W03', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-23'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W04', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-24'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W04', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-25'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W04', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-26'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W04', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-27'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W04', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-02-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-28'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W04', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-02-29'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M01', '2020-W04', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W05', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-02'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W05', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-03'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W05', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-04'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W05', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-05'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W05', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-06'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W05', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-07'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W05', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-08'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W06', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-09'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W06', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-10'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W06', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-11'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W06', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-12'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W06', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-13'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W06', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-14'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W06', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-15'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W07', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-16'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W07', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-17'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W07', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-18'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W07', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-19'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W07', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-20'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W07', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-21'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W07', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-22'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W08', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-23'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W08', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-24'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W08', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-25'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W08', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-26'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W08', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-27'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W08', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-28'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W08', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-29'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W09', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2019-12-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-03-31'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-30'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W09', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2019-12-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-03-31'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W09', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2019-12-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-01'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W09', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-01-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-02'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W09', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-01-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-03'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W09', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-04'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M02', '2020-W09', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-29'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-01-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W10', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-06'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W10', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-07'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W10', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-08'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W10', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-09'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W10', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-10'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W10', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-11'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W10', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-12'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W11', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-13'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W11', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-14'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W11', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-15'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W11', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-16'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W11', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-17'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W11', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-18'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W11', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-19'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W12', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-20'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W12', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-21'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W12', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-22'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W12', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-23'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W12', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-24'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W12', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-25'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W12', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-26'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W13', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-27'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W13', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-28'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W13', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-04-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-29'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W13', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-04-30'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W13', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-01'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W13', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-02'${DATE_SUFFIX}, '2020', '2020-Q1', '2020-M03', '2020-W13', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W14', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-04'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W14', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-05'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W14', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-06'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W14', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-07'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W14', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-08'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W14', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-09'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W14', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-10'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W15', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-11'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W15', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-12'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W15', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-13'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W15', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-14'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W15', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-15'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W15', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-16'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W15', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-17'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W16', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-18'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W16', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-19'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W16', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-20'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W16', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-21'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W16', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-22'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W16', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-23'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W16', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-24'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W17', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-25'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W17', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-26'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W17', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-27'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W17', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-28'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W17', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-29'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W17', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-05-31'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-30'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M04', '2020-W17', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W18', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-01'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W18', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-02'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W18', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-03'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W18', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-04'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W18', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-05'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W18', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-06'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W18', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-07'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W19', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-08'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W19', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-09'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W19', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-10'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W19', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-11'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W19', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-12'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W19', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-13'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W19', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-14'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W20', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-15'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W20', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-16'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W20', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-17'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W20', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-18'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W20', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-19'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W20', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-20'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W20', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-21'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W21', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-22'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W21', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-23'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W21', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-24'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W21', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-25'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W21', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-26'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W21', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-27'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W21', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-03-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-28'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W22', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-28'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-03-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-06-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-29'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W22', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-28'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-03-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-06-30'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W22', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-28'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-03-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-01'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W22', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-28'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-04-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-02'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W22', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-28'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-04-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-03'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W22', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-28'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-04-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-04'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M05', '2020-W22', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-28'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-04-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W23', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-06'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W23', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-07'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W23', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-08'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W23', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-09'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W23', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-10'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W23', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-11'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W23', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-12'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W24', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-13'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W24', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-14'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W24', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-15'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W24', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-16'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W24', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-17'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W24', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-18'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W24', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-19'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W25', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-20'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W25', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-21'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W25', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-22'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W25', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-23'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W25', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-24'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W25', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-25'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W25', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-26'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W26', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-27'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W26', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-28'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W26', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-29'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W26', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-07-31'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-30'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W26', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-04-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-07-31'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W26', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-01'${DATE_SUFFIX}, '2020', '2020-Q2', '2020-M06', '2020-W26', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W27', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-03'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W27', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-04'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W27', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-05'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W27', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-06'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W27', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-07'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W27', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-08'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W27', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-09'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W28', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-10'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W28', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-11'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W28', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-12'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W28', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-13'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W28', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-14'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W28', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-15'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W28', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-16'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W29', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-17'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W29', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-18'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W29', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-19'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W29', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-20'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W29', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-21'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W29', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-22'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W29', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-23'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W30', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-24'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W30', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-25'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W30', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-26'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W30', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-27'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W30', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-28'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W30', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-29'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M07', '2020-W30', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-08-31'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W31', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-05-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-08-31'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W31', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-01'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W31', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-02'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W31', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-03'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W31', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-04'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W31', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-05'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W31', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-06'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W32', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-07'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W32', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-08'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W32', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-09'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W32', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-10'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W32', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-11'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W32', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-12'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W32', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-13'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W33', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-14'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W33', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-15'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W33', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-16'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W33', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-17'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W33', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-18'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W33', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-19'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W33', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-20'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W34', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-21'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W34', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-22'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W34', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-23'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W34', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-24'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W34', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-25'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W34', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-26'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W34', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-06-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-27'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W35', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-06-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-28'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W35', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-06-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-09-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-29'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W35', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-06-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-09-30'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W35', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-07-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-01'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W35', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-07-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-02'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W35', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-07-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-03'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M08', '2020-W35', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-07-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W36', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-05'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W36', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-06'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W36', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-07'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W36', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-08'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W36', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-09'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W36', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-10'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W36', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-11'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W37', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-12'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W37', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-13'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W37', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-14'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W37', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-15'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W37', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-16'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W37', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-17'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W37', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-18'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W38', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-19'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W38', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-20'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W38', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-21'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W38', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-22'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W38', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-23'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W38', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-24'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W38', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-25'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W39', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-26'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W39', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-27'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W39', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-28'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W39', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-29'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W39', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-10-31'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-30'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W39', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-07-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-10-31'${DATE_SUFFIX}, '2020', '2020-Q3', '2020-M09', '2020-W39', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W40', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-02'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W40', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-03'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W40', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-04'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W40', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-05'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W40', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-06'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W40', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-07'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W40', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-08'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W41', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-09'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W41', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-10'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W41', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-11'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W41', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-12'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W41', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-13'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W41', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-14'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W41', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-15'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W42', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-16'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W42', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-17'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W42', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-18'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W42', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-19'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W42', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-20'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W42', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-21'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W42', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W43', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-23'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W43', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-24'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W43', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-25'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W43', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-26'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W43', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-27'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W43', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-28'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M10', '2020-W43', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-11-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W44', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-11-30'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W44', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-08-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-01'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W44', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-02'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W44', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-03'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W44', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-04'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W44', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-05'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W44', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-06'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W45', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-07'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W45', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-08'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W45', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-09'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W45', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-10'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W45', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-11'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W45', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-12'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W45', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-13'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W46', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-14'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W46', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-15'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W46', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-16'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W46', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-17'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W46', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-18'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W46', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-19'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W46', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-20'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W47', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-21'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W47', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-22'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W47', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-23'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W47', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-24'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W47', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-25'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W47', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-26'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W47', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-09-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-27'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W48', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-09-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-28'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W48', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-09-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-29'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W48', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-09-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2019-12-31'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-30'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W48', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-09-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-01'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2020-12-31'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W48', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-10-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-02'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-01'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W48', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-10-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-03'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-02'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M11', '2020-W48', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-27'${DATE_SUFFIX}, NULL, ${DATE_PREFIX}'2020-10-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-04'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W49', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-05'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-04'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W49', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-06'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-05'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W49', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-07'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-06'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W49', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-08'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-07'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W49', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-09'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-08'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W49', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-04'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-10'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-09'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W49', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-05'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-11'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-10'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W50', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-06'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-12'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-11'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W50', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-07'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-13'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-12'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W50', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-08'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-14'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-13'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W50', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-09'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-15'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-14'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W50', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-16'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-15'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W50', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-11'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-17'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-16'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W50', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-10'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-12'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-18'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-17'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W51', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-13'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-19'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-18'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W51', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-14'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-20'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-19'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W51', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-15'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-21'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-20'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W51', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-16'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-22'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-21'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W51', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-23'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-22'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W51', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-18'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-24'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-23'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W51', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-17'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-19'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-25'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-24'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W52', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-20'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-26'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-25'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W52', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-21'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-27'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-26'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W52', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-22'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-27'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-28'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-27'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W52', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-23'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-28'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-29'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-28'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W52', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-29'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-30'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-29'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W52', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-25'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-30'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-01-31'${DATE_SUFFIX}
      UNION ALL
      SELECT ${DATE_PREFIX}'2021-01-30'${DATE_SUFFIX}, '2020', '2020-Q4', '2020-M12', '2020-W52', ${DATE_PREFIX}'2020-02-02'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-11-01'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-03'${DATE_SUFFIX}, ${DATE_PREFIX}'2021-01-24'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-12-26'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-10-31'${DATE_SUFFIX}, ${DATE_PREFIX}'2020-02-01'${DATE_SUFFIX}
    `;
  },
  create: (cast: Cast, name: string, suf?: string) => create(name, RetailCalendar.select(cast), cast, suf),
};
