Amazon Timestream - Stock trades demo

[@russomi]

Thanks for the great demo!

[@thewisearchitect]

Great demo @cloudonaut. Thank U.

[@cloudonaut]

Thanks for your motivating feedback!

[@yonishalom83]

The errors you're getting are when partial query text is selected/highlighted (it executes just the highlighted portion)

[@cloudonaut]

I see. Thank you!

[@christiansalway7140]

I was hitting my head against the table when you kept saying it was an issue with the UI arghhh!! Thank you for telling him, yoni. haha Good video, thanks.

[@niharjain5379]

Great demo @cloudonaut. I have a doubt. How can I use time series data for stocks charts which are changing real time. What is the in general query time ?

[@cloudonaut]

Timestream stores the latest data in memory, and only writes historical data to disk.
ANTWORTEN

[@emmanueltd7628]

hello, how would i get the open and close price for each time_bin?

[@cloudonaut]

Is your definition of the open/close price the first/last price of a bin? If so, use first_value(), last_value().

[@asifhalde6485]

hey michael, how is the network connectivity managed ? like do you have to connect from ec2 within the vpc or you can connect to timestream
database using internet

[@cloudonaut]

Both options are possible. By default, the AWS/Timestream API is available via the public Internet. But you can create a VPC endpoint for a private VPC only connection docs.aws.amazon.com/timestream/latest/developerguide/VPCEndpoints.html

[@chinlim7865]

Hi Michael, I am looking at ingesting data from sensors > Raspberry Pi > IoT Core > Timestream Are you still happy with the performance of Timestream? Is it cost-effective? Thanks

[@cloudonaut]

Yes I am!