select value:day date , case when date < '2022-08-11' then '1. Before Aug 11, 2022' when date between '2022-08-11' and '2022-09-15' then '2. Aug 11 - Sep 15, 2022' end period , value:interest interest from table(flatten(input => parse_json( ' [ { "day": "2022-01-01", "interest": "0" }, { "day": "2022-01-02", "interest": "1" }, { "day": "2022-01-03", "interest": "1" }, { "day": "2022-01-04", "interest": "0" }, { "day": "2022-01-05", "interest": "1" }, { "day": "2022-01-06", "interest": "0" }, { "day": "2022-01-07", "interest": "0" }, { "day": "2022-01-08", "interest": "0" }, { "day": "2022-01-09", "interest": "1" }, { "day": "2022-01-10", "interest": "0" }, { "day": "2022-01-11", "interest": "<1" }, { "day": "2022-01-12", "interest": "0" }, { "day": "2022-01-13", "interest": "<1" }, { "day": "2022-01-14", "interest": "1" }, { "day": "2022-01-15", "interest": "1" }, { "day": "2022-01-16", "interest": "0" }, { "day": "2022-01-17", "interest": "0" }, { "day": "2022-01-18", "interest": "1" }, { "day": "2022-01-19", "interest": "1" }, { "day": "2022-01-20", "interest": "2" }, { "day": "2022-01-21", "interest": "<1" }, { "day": "2022-01-22", "interest": "0" }, { "day": "2022-01-23", "interest": "1" }, { "day": "2022-01-24", "interest": "0" }, { "day": "2022-01-25", "interest": "0" }, { "day": "2022-01-26", "interest": "0" }, { "day": "2022-01-27", "interest": "0" }, { "day": "2022-01-28", "interest": "0" }, { "day": "2022-01-29", "interest": "0" }, { "day": "2022-01-30", "interest": "0" }, { "day": "2022-01-31", "interest": "0" }, { "day": "2022-02-01", "interest": "1" }, { "day": "2022-02-02", "interest": "0" }, { "day": "2022-02-03", "interest": "0" }, { "day": "2022-02-04", "interest": "0" }, { "day": "2022-02-05", "interest": "0" }, { "day": "2022-02-06", "interest": "0" }, { "day": "2022-02-07", "interest": "0" }, { "day": "2022-02-08", "interest": "0" }, { "day": "2022-02-09", "interest": "<1" }, { "day": "2022-02-10", "interest": "0" }, { "day": "2022-02-11", "interest": "0" }, { "day": "2022-02-12", "interest": "<1" }, { "day": "2022-02-13", "interest": "0" }, { "day": "2022-02-14", "interest": "0" }, { "day": "2022-02-15", "interest": "2" }, { "day": "2022-02-16", "interest": "1" }, { "day": "2022-02-17", "interest": "0" }, { "day": "2022-02-18", "interest": "<1" }, { "day": "2022-02-19", "interest": "<1" }, { "day": "2022-02-20", "interest": "0" }, { "day": "2022-02-21", "interest": "1" }, { "day": "2022-02-22", "interest": "0" }, { "day": "2022-02-23", "interest": "1" }, { "day": "2022-02-24", "interest": "1" }, { "day": "2022-02-25", "interest": "1" }, { "day": "2022-02-26", "interest": "0" }, { "day": "2022-02-27", "interest": "1" }, { "day": "2022-02-28", "interest": "0" }, { "day": "2022-03-01", "interest": "0" }, { "day": "2022-03-02", "interest": "1" }, { "day": "2022-03-03", "interest": "0" }, { "day": "2022-03-04", "interest": "0" }, { "day": "2022-03-05", "interest": "0" }, { "day": "2022-03-06", "interest": "0" }, { "day": "2022-03-07", "interest": "0" }, { "day": "2022-03-08", "interest": "0" }, { "day": "2022-03-09", "interest": "1" }, { "day": "2022-03-10", "interest": "1" }, { "day": "2022-03-11", "interest": "0" }, { "day": "2022-03-12", "interest": "<1" }, { "day": "2022-03-13", "interest": "1" }, { "day": "2022-03-14", "interest": "1" }, { "day": "2022-03-15", "interest": "<1" }, { "day": "2022-03-16", "interest": "1" }, { "day": "2022-03-17", "interest": "1" }, { "day": "2022-03-18", "interest": "1" }, { "day": "2022-03-19", "interest": "1" }, { "day": "2022-03-20", "interest": "1" }, { "day": "2022-03-21", "interest": "1" }, { "day": "2022-03-22", "interest": "2" }, { "day": "2022-03-23", "interest": "1" }, { "day": "2022-03-24", "interest": "1" }, { "day": "2022-03-25", "interest": "1" }, { "day": "2022-03-26", "interest": "1" }, { "day": "2022-03-27", "interest": "2" }, { "day": "2022-03-28", "interest": "3" }, { "day": "2022-03-29", "interest": "2" }, { "day": "2022-03-30", "interest": "1" }, { "day": "2022-03-31", "interest": "2" }, { "day": "2022-04-01", "interest": "2" }, { "day": "2022-04-02", "interest": "2" }, { "day": "2022-04-03", "interest": "2" }, { "day": "2022-04-04", "interest": "2" }, { "day": "2022-04-05", "interest": "2" }, { "day": "2022-04-06", "interest": "2" }, { "day": "2022-04-07", "interest": "2" }, { "day": "2022-04-08", "interest": "0" }, { "day": "2022-04-09", "interest": "1" }, { "day": "2022-04-10", "interest": "1" }, { "day": "2022-04-11", "interest": "2" }, { "day": "2022-04-12", "interest": "1" }, { "day": "2022-04-13", "interest": "4" }, { "day": "2022-04-14", "interest": "4" }, { "day": "2022-04-15", "interest": "1" }, { "day": "2022-04-16", "interest": "1" }, { "day": "2022-04-17", "interest": "1" }, { "day": "2022-04-18", "interest": "1" }, { "day": "2022-04-19", "interest": "1" }, { "day": "2022-04-20", "interest": "1" }, { "day": "2022-04-21", "interest": "1" }, { "day": "2022-04-22", "interest": "1" }, { "day": "2022-04-23", "interest": "1" }, { "day": "2022-04-24", "interest": "1" }, { "day": "2022-04-25", "interest": "1" }, { "day": "2022-04-26", "interest": "0" }, { "day": "2022-04-27", "interest": "1" }, { "day": "2022-04-28", "interest": "1" }, { "day": "2022-04-29", "interest": "1" }, { "day": "2022-04-30", "interest": "1" }, { "day": "2022-05-01", "interest": "1" }, { "day": "2022-05-02", "interest": "2" }, { "day": "2022-05-03", "interest": "1" }, { "day": "2022-05-04", "interest": "1" }, { "day": "2022-05-05", "interest": "1" }, { "day": "2022-05-06", "interest": "2" }, { "day": "2022-05-07", "interest": "1" }, { "day": "2022-05-08", "interest": "0" }, { "day": "2022-05-09", "interest": "1" }, { "day": "2022-05-10", "interest": "<1" }, { "day": "2022-05-11", "interest": "2" }, { "day": "2022-05-12", "interest": "1" }, { "day": "2022-05-13", "interest": "1" }, { "day": "2022-05-14", "interest": "2" }, { "day": "2022-05-15", "interest": "1" }, { "day": "2022-05-16", "interest": "2" }, { "day": "2022-05-17", "interest": "2" }, { "day": "2022-05-18", "interest": "<1" }, { "day": "2022-05-19", "interest": "1" }, { "day": "2022-05-20", "interest": "3" }, { "day": "2022-05-21", "interest": "1" }, { "day": "2022-05-22", "interest": "1" }, { "day": "2022-05-23", "interest": "1" }, { "day": "2022-05-24", "interest": "1" }, { "day": "2022-05-25", "interest": "2" }, { "day": "2022-05-26", "interest": "1" }, { "day": "2022-05-27", "interest": "2" }, { "day": "2022-05-28", "interest": "2" }, { "day": "2022-05-29", "interest": "2" }, { "day": "2022-05-30", "interest": "1" }, { "day": "2022-05-31", "interest": "1" }, { "day": "2022-06-01", "interest": "2" }, { "day": "2022-06-02", "interest": "1" }, { "day": "2022-06-03", "interest": "2" }, { "day": "2022-06-04", "interest": "3" }, { "day": "2022-06-05", "interest": "2" }, { "day": "2022-06-06", "interest": "2" }, { "day": "2022-06-07", "interest": "2" }, { "day": "2022-06-08", "interest": "4" }, { "day": "2022-06-09", "interest": "3" }, { "day": "2022-06-10", "interest": "2" }, { "day": "2022-06-11", "interest": "2" }, { "day": "2022-06-12", "interest": "3" }, { "day": "2022-06-13", "interest": "2" }, { "day": "2022-06-14", "interest": "1" }, { "day": "2022-06-15", "interest": "1" }, { "day": "2022-06-16", "interest": "1" }, { "day": "2022-06-17", "interest": "1" }, { "day": "2022-06-18", "interest": "1" }, { "day": "2022-06-19", "interest": "1" }, { "day": "2022-06-20", "interest": "1" }, { "day": "2022-06-21", "interest": "1" }, { "day": "2022-06-22", "interest": "1" }, { "day": "2022-06-23", "interest": "0" }, { "day": "2022-06-24", "interest": "1" }, { "day": "2022-06-25", "interest": "2" }, { "day": "2022-06-26", "interest": "1" }, { "day": "2022-06-27", "interest": "1" }, { "day": "2022-06-28", "interest": "3" }, { "day": "2022-06-29", "interest": "1" }, { "day": "2022-06-30", "interest": "2" }, { "day": "2022-07-01", "interest": "2" }, { "day": "2022-07-02", "interest": "1" }, { "day": "2022-07-03", "interest": "1" }, { "day": "2022-07-04", "interest": "1" }, { "day": "2022-07-05", "interest": "1" }, { "day": "2022-07-06", "interest": "2" }, { "day": "2022-07-07", "interest": "1" }, { "day": "2022-07-08", "interest": "3" }, { "day": "2022-07-09", "interest": "<1" }, { "day": "2022-07-10", "interest": "1" }, { "day": "2022-07-11", "interest": "1" }, { "day": "2022-07-12", "interest": "0" }, { "day": "2022-07-13", "interest": "2" }, { "day": "2022-07-14", "interest": "1" }, { "day": "2022-07-15", "interest": "2" }, { "day": "2022-07-16", "interest": "4" }, { "day": "2022-07-17", "interest": "4" }, { "day": "2022-07-18", "interest": "7" }, { "day": "2022-07-19", "interest": "3" }, { "day": "2022-07-20", "interest": "3" }, { "day": "2022-07-21", "interest": "2" }, { "day": "2022-07-22", "interest": "3" }, { "day": "2022-07-23", "interest": "2" }, { "day": "2022-07-24", "interest": "3" }, { "day": "2022-07-25", "interest": "2" }, { "day": "2022-07-26", "interest": "2" }, { "day": "2022-07-27", "interest": "2" }, { "day": "2022-07-28", "interest": "3" }, { "day": "2022-07-29", "interest": "3" }, { "day": "2022-07-30", "interest": "3" }, { "day": "2022-07-31", "interest": "4" }, { "day": "2022-08-01", "interest": "3" }, { "day": "2022-08-02", "interest": "3" }, { "day": "2022-08-03", "interest": "3" }, { "day": "2022-08-04", "interest": "3" }, { "day": "2022-08-05", "interest": "4" }, { "day": "2022-08-06", "interest": "4" }, { "day": "2022-08-07", "interest": "3" }, { "day": "2022-08-08", "interest": "5" }, { "day": "2022-08-09", "interest": "5" }, { "day": "2022-08-10", "interest": "6" }, { "day": "2022-08-11", "interest": "11" }, { "day": "2022-08-12", "interest": "9" }, { "day": "2022-08-13", "interest": "9" }, { "day": "2022-08-14", "interest": "8" }, { "day": "2022-08-15", "interest": "8" }, { "day": "2022-08-16", "interest": "6" }, { "day": "2022-08-17", "interest": "7" }, { "day": "2022-08-18", "interest": "7" }, { "day": "2022-08-19", "interest": "7" }, { "day": "2022-08-20", "interest": "8" }, { "day": "2022-08-21", "interest": "6" }, { "day": "2022-08-22", "interest": "7" }, { "day": "2022-08-23", "interest": "6" }, { "day": "2022-08-24", "interest": "6" }, { "day": "2022-08-25", "interest": "8" }, { "day": "2022-08-26", "interest": "7" }, { "day": "2022-08-27", "interest": "9" }, { "day": "2022-08-28", "interest": "5" }, { "day": "2022-08-29", "interest": "12" }, { "day": "2022-08-30", "interest": "16" }, { "day": "2022-08-31", "interest": "8" }, { "day": "2022-09-01", "interest": "10" }, { "day": "2022-09-02", "interest": "11" }, { "day": "2022-09-03", "interest": "10" }, { "day": "2022-09-04", "interest": "11" }, { "day": "2022-09-05", "interest": "18" }, { "day": "2022-09-06", "interest": "26" }, { "day": "2022-09-07", "interest": "24" }, { "day": "2022-09-08", "interest": "17" }, { "day": "2022-09-09", "interest": "21" }, { "day": "2022-09-10", "interest": "27" }, { "day": "2022-09-11", "interest": "45" }, { "day": "2022-09-12", "interest": "100" } ] ' )))

Ethereum - ETH Removed