aboutsummaryrefslogtreecommitdiff
path: root/data
diff options
context:
space:
mode:
authorclarkohw <66530369+clarkohw@users.noreply.github.com>2021-04-04 23:13:00 -0400
committerGitHub <noreply@github.com>2021-04-04 23:13:00 -0400
commitb8023de2b8d942e995b7a6419a7da814afe8a4a3 (patch)
tree5df6a11038ca35598d3c1aaecc921893952ac210 /data
parent32f6f0e6f9d9beb8476f00417f68276fa2247d4e (diff)
parentcb79a2b3c94ef0fbfc7c1f9208b6f3027d08b4f9 (diff)
Merge branch 'master' into profic-calc
Diffstat (limited to 'data')
-rw-r--r--data/MockTradeData.txt7
-rw-r--r--data/mock_trades.sqlite3bin45056 -> 49152 bytes
2 files changed, 7 insertions, 0 deletions
diff --git a/data/MockTradeData.txt b/data/MockTradeData.txt
index fac6615..35c2ee4 100644
--- a/data/MockTradeData.txt
+++ b/data/MockTradeData.txt
@@ -13,4 +13,11 @@ The only unintuitive bit is the is_buy column, this is dummy (binary) variable
that takes on a value of 1 if the trade is a buy and a value of 0
if the trade is a sell.
+**USING THE DATABASE CONNECTIONS CORRECTLY!**
+
+Converting from UTC Instant/unix time to an America/New_York timezone data
+You want to add 5 hours to the UTC date to get the correct timezone formatted like so...
+"2021-03-12T05:00:00.00Z"
+
+So this is in UTC, but it is equivalent to 12 am on March 3rd in NYC Time
- Julia \ No newline at end of file
diff --git a/data/mock_trades.sqlite3 b/data/mock_trades.sqlite3
index c9455c9..7658214 100644
--- a/data/mock_trades.sqlite3
+++ b/data/mock_trades.sqlite3
Binary files differ