From 1e26cab2dec20b67bc5528cb2448ab69a593c66e Mon Sep 17 00:00:00 2001 From: Julia McCauley Date: Wed, 31 Mar 2021 16:35:24 -0400 Subject: made mocktrade sqlite database --- data/MockTradeData.txt | 16 ++++++++++++++++ data/mock_trades.sqlite3 | Bin 0 -> 45056 bytes 2 files changed, 16 insertions(+) create mode 100644 data/MockTradeData.txt create mode 100644 data/mock_trades.sqlite3 (limited to 'data') diff --git a/data/MockTradeData.txt b/data/MockTradeData.txt new file mode 100644 index 0000000..fac6615 --- /dev/null +++ b/data/MockTradeData.txt @@ -0,0 +1,16 @@ +This is just a quick explanation of the mock trade data for anyone +that wants to use it. + +Each row in the table represents a trade that +happened in the past two weeks (either a buy or a sell) +It's 1000 randomly generated rows, with 25 possible people and 50 possible stocks. +They could have purchased/sold anywhere from 1 -> 50 shares. + +Timestamps are when the trade was executed and they're in unix. +The range for these timestamps is a two week range from March 12th to March 26th. + +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. + +- Julia \ No newline at end of file diff --git a/data/mock_trades.sqlite3 b/data/mock_trades.sqlite3 new file mode 100644 index 0000000..c9455c9 Binary files /dev/null and b/data/mock_trades.sqlite3 differ -- cgit v1.2.3-70-g09d2