C# Online Compiler | .NET Fiddle

<no name> by Anonymous

/*
  Generate the start and end ticks values, for querying Table Storage when using a partition key that uses a reverse time stamp
*/
using System;

const int numberOfDays = 10;

var startDateTime = new DateTime(DateTime.UtcNow.Year, 5, 5);
var endDateTime =  startDateTime.AddDays(numberOfDays);

var start = new DateTime(startDateTime.Year, startDateTime.Month, startDateTime.Day, startDateTime.Hour, startDateTime.Minute, 0, 0, DateTimeKind.Utc);
var end = new DateTime(endDateTime.Year, endDateTime.Month, endDateTime.Day, endDateTime.Hour, endDateTime.Minute, 0, 0, DateTimeKind.Utc);

Console.WriteLine($"start: {DateTime.MaxValue.Ticks - start.Ticks:D19}");
Console.WriteLine($"  end: {DateTime.MaxValue.Ticks - end.Ticks:D19}");

​x
 
/*
  Generate the start and end ticks values, for querying Table Storage when using a partition key that uses a reverse time stamp
*/
using System;
​
const int numberOfDays = 10;
​
var startDateTime = new DateTime(DateTime.UtcNow.Year, 5, 5);
var endDateTime =  startDateTime.AddDays(numberOfDays);
​
var start = new DateTime(startDateTime.Year, startDateTime.Month, startDateTime.Day, startDateTime.Hour, startDateTime.Minute, 0, 0, DateTimeKind.Utc);
var end = new DateTime(endDateTime.Year, endDateTime.Month, endDateTime.Day, endDateTime.Hour, endDateTime.Minute, 0, 0, DateTimeKind.Utc);
​
Console.WriteLine($"start: {DateTime.MaxValue.Ticks - start.Ticks:D19}");
Console.WriteLine($"  end: {DateTime.MaxValue.Ticks - end.Ticks:D19}");
​
​
​

QuoteRequest { symbol = GOOG, from = 01/01/2004 00:00:00, to = 12/31/2019 00:00:00, interval = 1d }
https://query1.finance.yahoo.com/v7/finance/download/GOOG?period1=1072915200&period2=1577750400&interval=1d&events=history
status = Unauthorized
97 bytes

QuoteRequest { symbol = MSFT, from = 01/01/2004 00:00:00, to = 12/31/2019 00:00:00, interval = 1d }
https://query1.finance.yahoo.com/v7/finance/download/MSFT?period1=1072915200&period2=1577750400&interval=1d&events=history
status = Unauthorized
97 bytes

QuoteRequest { symbol = INTC, from = 01/01/2004 00:00:00, to = 12/31/2019 00:00:00, interval = 1d }
https://query1.finance.yahoo.com/v7/finance/download/INTC?period1=1072915200&period2=1577750400&interval=1d&events=history
status = Unauthorized
97 bytes

QuoteRequest { symbol = AMZN, from = 12/01/2004 00:00:00, to = 12/31/2019 00:00:00, interval = 1d }
https://query1.finance.yahoo.com/v7/finance/download/AMZN?period1=1101859200&period2=1577750400&interval=1d&events=history
status = Unauthorized
97 bytes

QuoteRequest { symbol = IBM, from = 12/01/2004 00:00:00, to = 12/31/2019 00:00:00, interval = 1d }
https://query1.finance.yahoo.com/v7/finance/download/IBM?period1=1101859200&period2=1577750400&interval=1d&events=history
status = Unauthorized
97 bytes

Cached Result
Last Run:	9:38:20 am
Compile:	0.023s
Execute:	2.15s
Memory:	40.40Mb
CPU:	2.173s

View IL Code