This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# TODO: find the problem on LeetCode at the end for optimization | |
Return an array of numbers that all add up to zero, and there should be no duplicates | |
[0,1,2,-2,-1,-1,1] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
================= | |
November 20, 2023 | |
================= | |
-2. Serving Utensil(s) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Date | Close | |
---|---|---|
4/5/1999 16:00:00 | 132.41 | |
4/6/1999 16:00:00 | 132.09 | |
4/7/1999 16:00:00 | 133.16 | |
4/8/1999 16:00:00 | 134.84 | |
4/9/1999 16:00:00 | 134.88 | |
4/12/1999 16:00:00 | 136.31 | |
4/13/1999 16:00:00 | 135.44 | |
4/14/1999 16:00:00 | 133.16 | |
4/15/1999 16:00:00 | 132.66 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Date | Close | |
---|---|---|
7/7/2017 16:00:00 | 39.69 | |
7/10/2017 16:00:00 | 39.69 | |
7/11/2017 16:00:00 | 39.69 | |
7/12/2017 16:00:00 | 39.69 | |
7/13/2017 16:00:00 | 39.69 | |
7/14/2017 16:00:00 | 40.26 | |
7/17/2017 16:00:00 | 40.22 | |
7/18/2017 16:00:00 | 40.14 | |
7/19/2017 16:00:00 | 40.14 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Date | Close | |
---|---|---|
5/30/2000 16:00:00 | 47.41 | |
5/31/2000 16:00:00 | 47.58 | |
6/1/2000 16:00:00 | 48.66 | |
6/2/2000 16:00:00 | 51.19 | |
6/5/2000 16:00:00 | 51 | |
6/6/2000 16:00:00 | 51.5 | |
6/7/2000 16:00:00 | 51.56 | |
6/8/2000 16:00:00 | 51.44 | |
6/9/2000 16:00:00 | 52.34 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Date | Close | |
---|---|---|
4/1/2020 16:00:00 | 178.32 | |
4/2/2020 16:00:00 | 182.46 | |
4/3/2020 16:00:00 | 179.7 | |
4/6/2020 16:00:00 | 192.36 | |
4/7/2020 16:00:00 | 192.06 | |
4/8/2020 16:00:00 | 198.6 | |
4/9/2020 16:00:00 | 201.54 | |
4/13/2020 16:00:00 | 199.5 | |
4/14/2020 16:00:00 | 205.62 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Date | Close | |
---|---|---|
9/8/2011 16:00:00 | 10 | |
9/9/2011 16:00:00 | 9.71 | |
9/12/2011 16:00:00 | 9.5 | |
9/13/2011 16:00:00 | 9.57 | |
9/14/2011 16:00:00 | 9.64 | |
9/15/2011 16:00:00 | 9.82 | |
9/16/2011 16:00:00 | 9.84 | |
9/19/2011 16:00:00 | 9.59 | |
9/20/2011 16:00:00 | 9.62 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Date | QQQ_ETF_Price | |
---|---|---|
4/1/1999 16:00:00 | 53.65 | |
4/2/1999 16:00:00 | 53.65 | |
4/5/1999 16:00:00 | 55.49 | |
4/6/1999 16:00:00 | 55.47 | |
4/7/1999 16:00:00 | 54.81 | |
4/8/1999 16:00:00 | 55.62 | |
4/9/1999 16:00:00 | 55.81 | |
4/12/1999 16:00:00 | 55.48 | |
4/13/1999 16:00:00 | 54.38 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ETF statistics | Example command: | ||||||
GOOGLEFINANCE - Google Docs Editors Help | GOOGLEFINANCE("NASDAQ:GOOG","price", DATE(2014,1,1), DATE(2014,12,31),"DAILY") | ||||||
Date | Price (Closing) | ||||||
Date | Close | if we're want historical data for all the ETFs on some big list we compile from Morningstar or Google or wherever, we can use Sheets' functions to "for-each" through all of em and put all the data in Sheets properly | |||||
1/3/2000 16:00:00 | 94.81 | ||||||
1/4/2000 16:00:00 | 88.01 | ||||||
1/5/2000 16:00:00 | 86.25 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
www.linkedin.com/in/nathanbendich |
NewerOlder