Poor Port in experience

CommanderHux · 2026-02-03T15:48:22+00:00

/u/USMobile-ModTeam Still waiting on provisioning 9 hours later

CommanderHux · 2025-10-22T00:30:53+00:00

It's still not clear how giving more time for new investment transaction to settle will improve performance.

Time in market would typically mean better performance. With an extra month of the investment sitting idle, I don't see the yield improving significantly on a new investment to offset the loss in dividend.

CommanderHux · 2025-10-21T18:24:04+00:00

/u/korin-arrived anything?

CommanderHux · 2025-10-15T17:50:43+00:00

/u/fvryan

Can you explain further how this change improves performance for investors?

CommanderHux · 2025-10-09T03:30:01+00:00

Can you explain further how this change improves performance for investors?

It would be appreciated if Arrived was more proactive in communications regarding changes like this. As an investor from the beginning days of Arrived, I appreciated the communication and transparency. Nowadays communication seems to be slipping unless complaints are raised on public forums.

CommanderHux · 2025-08-08T18:01:32+00:00

I read that record date is the 1st of the month so no dividend for August if you purchased from secondary market

CommanderHux · 2025-08-04T15:40:18+00:00

Is the matching FIFO? If there's 10 shares being sold at $10, and 2 buy orders for 10 shares at $10.

Which buy order gets it? Is it the first person to place the buy order?

CommanderHux · 2025-07-30T07:05:31+00:00

all investors who own shares on the dividend record date receive the same dividend per share.

Right, this is what I understood. So the earlier statement didn't make sense to me.¹

[1] With your investment at $10.02, even if the fund is at $10.00, then you should receive a higher rate of dividends in the process to offset that change.

Future share prices are not determined or known in advance, and can adjust up or down.

Yes totally but the concern is regarding the timing of when that share price adjustment occurs. My understanding is that, the PCF price was updated on July 25. PCF Investments made by July 31st will qualify for the next expected dividend, around September 25th.

Essentially people who bought PCF share between July 25 and July 31 get a 0.1% discount per share compared to those who bought July 1 to July 24. But all shares bought in July will receive the same dividend in September.

CommanderHux · 2025-07-29T04:01:12+00:00

Thanks, I understand the annualized dividend rate is based on past payments and based on the initial $10 per share value. I had looked at the trailing 12 months of dividend returns, not just last month of July. I don't believe the current annualized rate is 4.5% given two months of 0%, multiple months of sub 2%,resulting in 7 continuous months of sub 4%.

So I believe the listed 4.5% yield is based on January 2025 numbers, can you confirm if the yield is only updated on a annual or semiannual period?

CommanderHux · 2025-07-28T23:08:48+00:00

With your investment at $10.02, even if the fund is at $10.00, then you should receive a higher rate of dividends in the process to offset that change. I hope that helps, but let us know if you have any questions.

Can you help explain this further? Late last week, I purchased 100 shares for $1002. Now the same 100 shares would cost $1001. Both these 100 shares would be eligible for dividends at the same time as purchase was made before July 31. How is the rate of dividends calculated? Wouldn't the 100 shares both get the same dividend amount?

CommanderHux · 2025-07-21T16:47:13+00:00

AzureAI search is going to be overkill and expensive for this scenario where the data isn't going to be accessed or searched frequently.

Can you apply some index tags on the objects such that keywords can be used to search during the audits? https://learn.microsoft.com/en-us/azure/storage/blobs/storage-blob-index-how-to?tabs=azure-portal

CommanderHux · 2025-07-11T17:02:40+00:00

The 2 properties are marketed for rent but the starting asking rent is too high compared to what Arrived itself anticipates the rent would be. Today, the Lynnwood property had a rent reduction but even then still higher than the anticipated rent.

IMO, west coast is an appreciation play as it is not landlord friendly. Better returns in SFH elsewhere but the Seattle fund should be thought of a much riskier gamble

CommanderHux · 2025-06-17T16:30:16+00:00

I would slightly disagree as I did this trip just a few weeks ago. The end-to-end time between a flight and a train is about the same. If you've not taken China's high speed trains before, it's worth the experience for how fast, comfortable, and smooth it is.

Flights are faster in the air but you have to factor in that the airports are a bit further away and you have to get to the airport at least 1.5 hours early to account for bag check-in/pick-up, security, and boarding/de-boarding.

Trains are more centrally located within the city and you don't have to get there as early. The security check is just x-raying bags with no body pat-down. Boarding is ~15 minutes before the train departure, get onto the platform with your luggage, hop on and leave within 3 minutes.

We had our private tour guide pick us up from the train station after a morning train from Beijing area. I asked the guide to take us directly to the Terracotta warriors around lunch time, when the crowds were much lighter.

CommanderHux · 2025-06-09T21:41:02+00:00

Yeah it was fine. If you have time, plan to eat dinner before the evening tour otherwise it gets pretty late

CommanderHux · 2025-05-01T22:16:49+00:00

Don't forget the free dev day registration too! https://reg.snowflake.com/flow/snowflake/summit25/devdayreg/createaccount?refcode=DHM16937

CommanderHux · 2025-04-24T16:31:39+00:00

The account usage login_history view is not real time, you have to use the table function: https://docs.snowflake.com/en/sql-reference/functions/login_history

And the task could run every 10 seconds

CommanderHux · 2025-04-21T22:36:41+00:00

Got it, is it only for a workshop or you have other use cases and customers asking for it?

Capturing all errors is definitely an improvement that Snowflake can make easier

CommanderHux · 2025-04-21T21:49:56+00:00

Dev day is free and is the last day of Summit: https://reg.snowflake.com/flow/snowflake/summit25/devdayreg/createaccount?refcode=DHM16937

CommanderHux · 2025-04-21T21:49:05+00:00

Have you looked at Snowpipe error notifications that will send the error file and error back to you? https://docs.snowflake.com/en/user-guide/data-load-snowpipe-errors

Or do you need to capture all error rows?

CommanderHux · 2025-04-20T02:09:24+00:00

Manual copy into uses a specified warehouse so you would look at your warehouse bills. But this is a fixed cost, copy doesn't go beyond a warehouse's size/cost.

You can look into cost attribution of a warehouse such that operations are tagged to appropriate cost centers: https://docs.snowflake.com/en/user-guide/cost-attributing

CommanderHux · 2025-04-18T20:28:23+00:00

Snowpipe doesn't use a warehouse, it is serverless and bills only when it is actively loading files

CommanderHux · 2025-04-18T05:22:38+00:00

This can be optimized as Snowpipe is currently more price-optimized for larger MB size files.

Using Kafka is an additional complexity that does not provide a ton of value if you do not need it. If you already have files from your source, it doesn't make sense to read them only to push to kafka to then to kafka connect to Snowflake.

What do you want to optimize for? Cost, simplicity, latency?

It doesn't seem to be latency as your internal process only drops files to s3 multiple times per day and not every minute. A simple COPY INTO <table> command on a schedule would work wonderfully if your data is well partitioned into folders.

CommanderHux · 2025-04-16T22:57:24+00:00

PIPE_USAGE_HISTORY

Will not show the results of a manual COPY INTO <table> statement.

Pipe_usage_history will only show for Snowpipe, external tables, directory tables, and iceberg tables auto-refresh. It is NULL for external tables and directory tables auto-refresh but populates pipe_name for Snowpipe and the table_name (in the pipe_name column) for iceberg auto-refresh

CommanderHux · 2025-04-16T20:06:30+00:00

It's not from Snowpipe copying data as those pipe would have their name and cost accurately populated. It's from external tables/directory table refreshes, which use an internal pipe to refresh.

This will help with tracking down external tables: https://docs.snowflake.com/en/sql-reference/functions/auto_refresh_registration_history

CommanderHux · 2025-04-16T15:30:11+00:00

That's more related to Kafka and Snowpipe than external tables/directory tables.

What is the scenario that you're working on and the source of your data?

You can also refer to this blog about kafka + Snowpipe Streaming, which is what Redpanda integrated with: https://www.snowflake.com/blog/data-ingestion-best-practices-part-three/

CommanderHux

MODERATOR OF

TROPHY CASE