IRCLogs for #armagetron in 2023-10-10 • ArmaNelgTron.tk

Searching from 2023-10-10 00:00:00 to 2023-10-10 23:59:59.999999.
Query completed in 1.41 seconds
[2023-10-10 00:40:11] <Lucifer_arma> you know, the deeper I get into this, the more I learn that it's even deeper than I thought
[2023-10-10 00:40:11] <armagetronbridge> 10irc:Lucifer_arma| you know, the deeper I get into this, the more I learn that it's even deeper than I thought
[2023-10-10 00:40:43] <Lucifer_arma> example: I'm just going to grab a list of assets and save them in the database.  So I create a table for it matching the object in the brokerage api.  Then I do the retrieval.
[2023-10-10 00:40:44] <armagetronbridge> 10irc:Lucifer_arma| example: I'm just going to grab a list of assets and save them in the database.  So I create a table for it matching the object in the brokerage api.  Then I do the retrieval.
[2023-10-10 00:41:21] <Lucifer_arma> While looking over the data retrieved, I find that *one* of the fields is, in fact, a list, and thus requires another table to support it, with a symbol as primary key.  So now I not only have to create the new table, I have to write the support code for it.
[2023-10-10 00:41:21] <armagetronbridge> 10irc:Lucifer_arma| While looking over the data retrieved, I find that *one* of the fields is, in fact, a list, and thus requires another table to support it, with a symbol as primary key.  So now I not only have to create the new table, I have to write the support code for it.
[2023-10-10 01:44:23] <Lucifer_arma> ok, I take it back.  My cluster is *not* running at full strength, even without the other worker, because the scheduler is taking so long to send out jobs that one worker is plenty to keep up with it
[2023-10-10 01:44:24] <armagetronbridge> 10irc:Lucifer_arma| ok, I take it back.  My cluster is *not* running at full strength, even without the other worker, because the scheduler is taking so long to send out jobs that one worker is plenty to keep up with it
[2023-10-10 03:22:42] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 03:23:22] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 03:26:17] --> Armanelgtron has joined the channel
[2023-10-10 03:26:19] -!- silver.libera.chat set mode #armagetron +nt
[2023-10-10 03:26:19] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-10-10 03:27:16] --> Armanelgtron has joined the channel
[2023-10-10 03:27:16] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-10-10 03:27:16] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-10-10 03:27:17] -!- larich.oftc.net set mode #armagetron +nt
[2023-10-10 03:27:17] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-10-10 04:56:53] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 04:57:34] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 05:00:09] --> Armanelgtron has joined the channel
[2023-10-10 05:00:10] -!- copper.libera.chat set mode #armagetron +nt
[2023-10-10 05:00:10] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-10-10 05:01:09] --> Armanelgtron has joined the channel
[2023-10-10 05:01:09] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-10-10 05:01:09] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-10-10 05:01:10] -!- larich.oftc.net set mode #armagetron +nt
[2023-10-10 05:01:10] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-10-10 05:25:54] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 05:26:45] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 05:27:59] --> Armanelgtron has joined the channel
[2023-10-10 05:27:59] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-10-10 05:27:59] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-10-10 05:28:00] -!- larich.oftc.net set mode #armagetron +nt
[2023-10-10 05:28:00] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-10-10 05:28:41] --> Armanelgtron has joined the channel
[2023-10-10 05:28:42] -!- silver.libera.chat set mode #armagetron +nt
[2023-10-10 05:28:42] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-10-10 05:50:16] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 05:51:36] <-- Armanelgtron has quit (No Ping reply in 210 seconds.)
[2023-10-10 05:54:15] --> Armanelgtron_ has joined the channel
[2023-10-10 05:54:15] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-10-10 05:54:15] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-10-10 05:54:15] -!- Armanelgtron changed nick to Guest2832
[2023-10-10 05:54:15] -!- Armanelgtron changed nick to Armanelgtron
[2023-10-10 05:54:16] -!- larich.oftc.net set mode #armagetron +nt
[2023-10-10 05:54:16] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-10-10 05:54:20] <-- Guest2832 has quit (Ping timeout: 480 seconds)
[2023-10-10 05:55:18] --> Armanelgtron has joined the channel
[2023-10-10 05:55:19] -!- tungsten.libera.chat set mode #armagetron +nt
[2023-10-10 05:55:19] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-10-10 10:13:52] --> JackSkellington has joined the channel
[2023-10-10 10:58:52] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 10:59:33] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 11:02:26] --> Armanelgtron_ has joined the channel
[2023-10-10 11:02:26] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-10-10 11:02:26] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-10-10 11:02:26] -!- Armanelgtron changed nick to Guest2857
[2023-10-10 11:02:26] -!- Armanelgtron changed nick to Armanelgtron
[2023-10-10 11:02:27] -!- larich.oftc.net set mode #armagetron +nt
[2023-10-10 11:02:27] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-10-10 11:02:40] <-- Guest2857 has quit (Ping timeout: 480 seconds)
[2023-10-10 11:03:28] --> Armanelgtron has joined the channel
[2023-10-10 11:03:29] -!- silver.libera.chat set mode #armagetron +nt
[2023-10-10 11:03:29] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-10-10 11:16:03] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 11:17:12] <-- Armanelgtron has quit (No Ping reply in 210 seconds.)
[2023-10-10 11:19:37] --> Armanelgtron_ has joined the channel
[2023-10-10 11:19:37] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-10-10 11:19:37] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-10-10 11:19:37] -!- Armanelgtron changed nick to Guest2859
[2023-10-10 11:19:37] -!- Armanelgtron changed nick to Armanelgtron
[2023-10-10 11:19:39] -!- larich.oftc.net set mode #armagetron +nt
[2023-10-10 11:19:39] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-10-10 11:19:55] <-- Guest2859 has quit (Ping timeout: 480 seconds)
[2023-10-10 11:20:38] --> Armanelgtron has joined the channel
[2023-10-10 11:20:39] -!- molybdenum.libera.chat set mode #armagetron +nt
[2023-10-10 11:20:39] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-10-10 14:03:49] --> monr0e_ has joined the channel
[2023-10-10 14:07:10] <-- JackSkellington has quit (Ping timeout: 272 seconds)
[2023-10-10 15:43:53] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 15:47:33] <-- Armanelgtron has quit (No Ping reply in 270 seconds.)
[2023-10-10 15:48:17] --> Armanelgtron has joined the channel
[2023-10-10 15:48:17] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-10-10 15:48:17] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-10-10 15:48:19] -!- weber.oftc.net set mode #armagetron +nt
[2023-10-10 15:48:19] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-10-10 15:48:49] --> Armanelgtron has joined the channel
[2023-10-10 15:48:50] -!- silver.libera.chat set mode #armagetron +nt
[2023-10-10 15:48:50] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-10-10 16:01:53] <armagetronbridge> 06discord:Jack Skellingquent| This is why you pull queries first and evaluate the responses. Also, don't use a symbol as the primary key. A symbol is not immutable, although changes are rare. In the event that it *does* change, you'll want the ability to add the new symbol, and retain the historical one for reference. A unique ID for each tradeable entity will give you that flexibility, and let you track symb <clipped message>
[2023-10-10 16:01:53] <armagetron-bridge> 06discord:Jack Skellingquent| This is why you pull queries first and evaluate the responses. Also, don't use a symbol as the primary key. A symbol is not immutable, although changes are rare. In the event that it *does* change, you'll want the ability to add the new symbol, and retain the historical one for reference. A unique ID for each tradeable entity will give you that flexibility, and let you track symb <clipped message>
[2023-10-10 16:01:53] <armagetron-bridge> 06discord:Jack Skellingquent| ols across markets more easily.
[2023-10-10 16:01:54] <armagetronbridge> 06discord:Jack Skellingquent| ols across markets more easily.
[2023-10-10 16:59:39] <Lucifer_arma> well, ignoring for a moment that symbol changes are rare enough that they can be used as a primary key, there's actually a uuid for assets, I've just never used uuid before
[2023-10-10 16:59:40] <armagetronbridge> 10irc:Lucifer_arma| well, ignoring for a moment that symbol changes are rare enough that they can be used as a primary key, there's actually a uuid for assets, I've just never used uuid before
[2023-10-10 17:00:01] <Lucifer_arma> I have a mid-term plan of changing the primary key to the uuid, but I have to get that copied everywhere it's needed first
[2023-10-10 17:00:02] <armagetronbridge> 10irc:Lucifer_arma| I have a mid-term plan of changing the primary key to the uuid, but I have to get that copied everywhere it's needed first
[2023-10-10 17:00:11] <Lucifer_arma> my database isn't just incomplete right now, it's also not fully designed :)
[2023-10-10 17:00:11] <armagetronbridge> 10irc:Lucifer_arma| my database isn't just incomplete right now, it's also not fully designed :)
[2023-10-10 17:01:59] <Lucifer_arma> I also have to figure out how uuid's are used in python and postgres.  Right now, I'm just storing it in a varchar field
[2023-10-10 17:02:00] <armagetronbridge> 10irc:Lucifer_arma| I also have to figure out how uuid's are used in python and postgres.  Right now, I'm just storing it in a varchar field
[2023-10-10 17:02:53] <Lucifer_arma> but before that, I need to streamline jobs.  They've picked up a lot of cruft from a bunch of individual cases of "I need this right now, I'll work out how it's best later"
[2023-10-10 17:02:54] <armagetronbridge> 10irc:Lucifer_arma| but before that, I need to streamline jobs.  They've picked up a lot of cruft from a bunch of individual cases of "I need this right now, I'll work out how it's best later"
[2023-10-10 17:03:20] -!- monr0e_ changed nick to JackSkellington
[2023-10-10 18:43:30] <-- JackSkellington has quit (Ping timeout: 255 seconds)
[2023-10-10 19:27:20] <Lucifer_arma> lovely.  Turns out my weighted moving average job has been writing to the wrong table this whole time, so now I have to drop both tables and start fresh with them.
[2023-10-10 19:27:21] <armagetronbridge> 10irc:Lucifer_arma| lovely.  Turns out my weighted moving average job has been writing to the wrong table this whole time, so now I have to drop both tables and start fresh with them.
[2023-10-10 19:27:23] <Lucifer_arma> heh
[2023-10-10 19:27:24] <armagetronbridge> 10irc:Lucifer_arma| heh
[2023-10-10 22:00:32] <Lucifer_arma> ok, everything's fixed again.  Cluster is back up to full speed, now it would benefit from having that third worker brought online
[2023-10-10 22:00:32] <armagetronbridge> 10irc:Lucifer_arma| ok, everything's fixed again.  Cluster is back up to full speed, now it would benefit from having that third worker brought online
[2023-10-10 22:00:55] <Lucifer_arma> need to reimplement the rate limiter at some point, when ever I actually exceed the requests allowed for that particular api
[2023-10-10 22:00:55] <armagetronbridge> 10irc:Lucifer_arma| need to reimplement the rate limiter at some point, when ever I actually exceed the requests allowed for that particular api
[2023-10-10 22:24:54] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 22:25:54] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 22:28:12] --> Armanelgtron has joined the channel
[2023-10-10 22:28:14] -!- molybdenum.libera.chat set mode #armagetron +nt
[2023-10-10 22:28:14] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-10-10 22:29:10] --> Armanelgtron has joined the channel
[2023-10-10 22:29:10] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-10-10 22:29:10] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-10-10 22:29:11] -!- weber.oftc.net set mode #armagetron +nt
[2023-10-10 22:29:11] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
[2023-10-10 22:35:01] <Lucifer_arma> ok, so the question about price history for days when there are no trades is a little deeper.  The prices can actually change, which suggests the history I have includes "speculative" prices on those days
[2023-10-10 22:35:02] <armagetronbridge> 10irc:Lucifer_arma| ok, so the question about price history for days when there are no trades is a little deeper.  The prices can actually change, which suggests the history I have includes "speculative" prices on those days
[2023-10-10 22:35:56] <Lucifer_arma> so, say you check your portfolio value after hours and find that it's changed.  The prices get changed based on supply/demand, even if no trades take place.  That's the brokerage determining a speculative price based on orders that it knows about right then.
[2023-10-10 22:35:56] <armagetronbridge> 10irc:Lucifer_arma| so, say you check your portfolio value after hours and find that it's changed.  The prices get changed based on supply/demand, even if no trades take place.  That's the brokerage determining a speculative price based on orders that it knows about right then.
[2023-10-10 22:36:26] <Lucifer_arma> So that value can change even when no trades are actually happening.  It appears that this is in the price history, too, which is from a different data source.
[2023-10-10 22:36:27] <armagetronbridge> 10irc:Lucifer_arma| So that value can change even when no trades are actually happening.  It appears that this is in the price history, too, which is from a different data source.
[2023-10-10 22:36:55] <Lucifer_arma> so, should the technical indicators include these speculative prices?  Do the standard technical indicators you get from, say, yahoo, or google, or whoever, also include them?
[2023-10-10 22:36:57] <armagetronbridge> 10irc:Lucifer_arma| so, should the technical indicators include these speculative prices?  Do the standard technical indicators you get from, say, yahoo, or google, or whoever, also include them?
[2023-10-10 22:37:30] <Lucifer_arma> I've got it filtering out such records for new syncs, which means I have about 90 days to decide whether or not to keep it that way
[2023-10-10 22:37:30] <armagetronbridge> 10irc:Lucifer_arma| I've got it filtering out such records for new syncs, which means I have about 90 days to decide whether or not to keep it that way
[2023-10-10 23:22:16] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 23:24:27] <-- Armanelgtron has quit (No Ping reply in 180 seconds.)
[2023-10-10 23:26:22] --> Armanelgtron has joined the channel
[2023-10-10 23:26:23] -!- cadmium.libera.chat set mode #armagetron +nt
[2023-10-10 23:26:23] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC
[2023-10-10 23:26:51] --> Armanelgtron has joined the channel
[2023-10-10 23:26:51] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC"
[2023-10-10 23:26:51] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC
[2023-10-10 23:26:53] -!- weber.oftc.net set mode #armagetron +nt
[2023-10-10 23:26:53] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC
View entire month
DISCLAIMER: These logs of public chat may contain some content which may not be appropriate for all audiences. Use at your own risk.
Logs from 2006-2009 pulled from wrtlprnft
Format changes at: 2015-08-25, 2017-02-20, and 2020-03-23. Times (2015 and later) should be Eastern.
. [About this site] [Credits]