It's theCUBE, covering the Virtual Vertica Big Data Conference 2020, brought to you by Vertica. Hello everybody, welcome to this special digital presentation of theCUBE. We're tracking the Vertica Virtual Big Data Conferences, the CUBEs, I think fifth year doing the BDC. We've been to every big data conference that they've held and really excited to be helping with the digital component here in these interesting times. Ron Cormier is here, Principal Database Engineer at the Trade Desk. Ron, great to see you, thanks for coming on. Hi David, my pleasure, good to see you as well. So we're talking a little bit about your background. You're basically a Vertica and database guru, but tell us about your role at the Trade Desk and then I want to get into a little bit about what the Trade Desk does. Sure. So I'm a Principal Database Engineer at the Trade Desk. The Trade Desk was one of my customers when I was working at HP as a member of the Vertica team. And I joined the Trade Desk in early 2016. And since then I've been working on building out their Vertica capabilities and expanding the data warehouse footprint in a kind of ever-growing database technology, data volume environment. And the Trade Desk is an ad tech firm and you specialize in real-time ad serving and pricing. And I guess real-time, people talk about real-time a lot. We define real-time as before you lose the customer. Maybe you could talk a little bit about the Trade Desk and the business and maybe how you define real-time. Totally.  And people are bidding on the privilege to show you an ad. And across the open internet, this happens seven to 13 million times per second. And so the ads, the whole auction dynamic and the display of the ad needs to happen really fast. So that's about as real-time as it gets outside of high-frequency trading as far as I'm aware. The Trade Desk participates in those auctions. We bid on behalf of our customers, which are ad agencies and the agencies represent brand. So the agencies are the madmen, companies of the world and they have brands that under their guidance. And so they give us budget to spend, to place the ads and display them. And once the ads get displayed, so we bid on the hundreds of thousands of auctions per second. Once we make those bids, anytime we do make a bid, some data flows into our data platform, which is powered by Vertica. So we're getting hundreds of thousands of events per second. We have other events that flow into Vertica as well. And we clean them up, we aggregate them, and then we run reports on the data. And we run about 40,000 reports per day on behalf of our customers. The reports aren't as real-time as I was talking about earlier. They're more batch-oriented. Our customers like to see big chunks of time, like a whole day or a whole week or a whole month on a single report. So we wait for that time period to complete and then we run the report and send them the results. So you have one of the largest commercial infrastructures in the big data sphere. Paint a picture for us. I understand you've got a couple of 320 node clusters. We're talking about petabytes of data, but describe what your environment looks like. Sure, so like I said, we've been Vertica customers for a while and we started out with a bunch of enterprise clusters. So the enterprise mode is the traditional Vertica deployment where the compute and the storage is tightly coupled, all the rate of raise on the servers. And we had four of those and we were doing okay, but our volumes are ever increasing. We wanted to store more data and we wanted to run more reports in a short period of time, keep pushing. And so we had these four clusters and then we started talking with Vertica about Eon mode and that's Vertica's separation of compute and storage where the compute and the storage can be scaled independently. We can add storage without adding compute or vice versa or we can add both. So that was something that we were very interested in for a couple of reasons. One, our enterprise clusters were running out of disk. Like an adding disk is expensive in enterprise mode. It's kind of a pain. You got to add compute at the same time. So you kind of end up in an unbalanced place. So Eon mode, that problem gets a lot better. We can add disk, infinite disk because it's backed by S3. And we can add compute really easy to scale the number of things that we run in parallel, the concurrency, just add a sub cluster. So they are two US East and US West of Amazon so regionally diverse. And the real benefit is that they can, we can stop nodes when we don't need them. Our workload is fairly lumpy, I call it. After the day completes, we do the ingest, we do the aggregation for ingesting and aggregating all day but the final hour or so needs to be completed. And then once that's done, the number of reports that we need to run spikes up, it goes really high.  So Eon has been a nice boon for us for both those reasons. I'd love to explore Eon a little bit more.  I think 2018 Vertica announced Eon mode. So it's only been out there a couple of years. So I'm curious for the folks that haven't moved to Eon mode, which presumably they want to for the same reasons that you mentioned, why buy compute and storage and chunks when you run out of storage, if you don't have to. What were some of the challenges that you had to, that you faced in going to Eon mode? What kind of things did you have to prepare for? Were there any out of scope expectations? Can you share that experience with us? Sure. So we were an early adopter. We participated in the beta program. I mean, I think it's fair to say we actually drove the requirements in a lot of ways because we approached Vertica early on. So the challenges were what you'd expect any early adopter to be going through. The sort of getting things working as expected. I mean, there's a number of cases which I could touch upon. Like we found an efficiency in the way that it accesses the data on S3. And it was accessing the data too frequently, which ended up was just expensive. So our S3 bill went up pretty significantly for a couple of months. So that was a challenge, but we worked through that. Another was that we recently made huge strides in with Vertica was the ability to stop and start nodes and not have to start them very quickly. And when they start to not interfere with any running queries. So when we create, when we want to spin up a bunch of compute, there was a point in time when it would break certain queries that were already running. So that was a challenge. But again, the Vertica team has been quite responsive to solving these issues and now that's behind us. In terms of those who need to get started, there's a, or looking to get started, there's a number of things to think about. Off the top of my head, there's sort of new configuration items that you'll want to think about like how instance type. So certainly Amazon has a variety of instances and it's important to consider one of Vertica's architectural advantages in these areas. Vertica has this caching layer on the instances themselves. And what that does is if we can keep the data in cache what we've found is that the performance is basically the same performance of enterprise mode. So having a good size cache when needed can be important. So we went with the i3 instance types which have a lot of local NVMe storage that we can, so we can cache data and get good performance. That's one thing to think about the number of nodes, the instance type, certainly the number of shards is a sort of technical item that needs to be considered. It's how the data gets distributed. It's sort of a layer on top of the segmentation that some Vertica engineers will be familiar with. And probably one of the big things that one needs to consider is how to get data in the database.  And so I think they're working on that but at the point we got there we had to, we exported all our data out of enterprise cluster as RK, bumped it out to S3 and then we had the EON cluster. It's like that data. Yeah, so awesome advice. Thank you for sharing that with the community. So but at the end of the day, so it sounds like you had some learning to do, some tweaking to do and obviously you had to get the data in. At the end of the day, was it worth it? What was the business impact? Yeah, it definitely was worth it for us. I mean, so right now we have four times the data in our EON cluster that we have in our enterprise clusters. We still run some enterprise clusters. We started with four at the peak, now we're down to two. So we have the two EON clusters. So it's been, I think our business would say it's been a huge win. Like we're doing things that we really never could have done before. Like forexing the data on enterprise would have been really difficult. It would have required non-trivial engineering to do things like daisy chaining clusters together and then how to aggregate data across clusters which would again, non-trivial. So we have all the data we want. We can continue to grow data. We're running reports on seasonality so our customers can compare their campaigns last year versus this year, which is, we just haven't been able to do in the past. We've expanded, so we grew the data vertically. We've expanded the data horizontally as well. So we're adding columns to our aggregates. We're enriching the data much more than we have in the past. So while we still have enterprise picking around, I'd say our EON clusters are doing the majority of the heavy lifting. And cloud was part of the enablement here, particularly with scale. Is that right? Definitely, definitely. And you're running on-prem as well? Is it even a hybrid mode or is it all AWS? Good question. So yeah, when I've been speaking about enterprise, I've been referring to on-prem. So we have physical machines in data centers. So yeah, we are running a hybrid now. And so it's really hard to get like an apples-to-apples direct comparison of enterprise on-prem versus EON in the cloud. One thing that I touch upon in my presentation is it would require, if I try to get apples-to-apples, and I think about how I would run the entire workload on enterprise or on EON. I had to run the entire thing, both. I try to think about how many cores we would need, CPU cores to do that. And basically it would be about the same number of cores, I think, for enterprise on-prem versus EON in the cloud. However, my EON nodes only need to be running. Half the cores only need to be running about six hours out of the day. So when the other 18 hours, I can shut them down and not be paying for them mostly. Interesting. Okay, and so I got to ask you, I mean notwithstanding the fact that you got a lot invested in Vertica and you got a lot of experience there, a lot of emerging cloud databases, did you look, I mean, you know a lot about database, not just Vertica, you're a database guru in many areas. Traditional RDBMS as well as MPP, new cloud databases, what is it about Vertica that works for you in the specific sweet spot that you've chosen? What's really the difference there? Yeah, so I think the key difference is the maturity. There are a number, I'm familiar with another, a number of other database platforms in the cloud and otherwise column stores specifically that don't have the maturity that we're used to and we need at our scale. So being able to specify alternate projections, so different sort orders on my data is huge and there's other platforms where we don't have that capability. And so Vertica is of course the original column store and they've had time to build up a lead in terms of their maturity and features and I think that other column stores, cloud otherwise are playing a little bit of catch up in that regard. Of course Vertica is playing catch up on the cloud side but if I had to pick whether I wanted to write a column store from scratch or use a defined file system, like a cloud file system from scratch, I'd probably think it would be easier to write the cloud file system. The column store is where the real smarts are. Interesting. Let's talk a little bit about some of the challenges you have in reporting. You had a very dynamic nature of reporting. Like you said, your clients want a time series. They just don't want a snapshot of a slice but at the same time, your reporting is probably pretty lumpy, a very dynamic demand curve. So first of all, is that accurate? Can you describe that sort of dynamic dynamism and how are you handling that? Yep, that's exactly right, it is lumpy and that's the exact word that I use. So like at the end of the UTC day, when UTC midnight rolls around, that's we do the final ingest, the final aggregate and then the queue for the number of reports that need to run spikes. So the majority of those 40,000 reports that we run per day, are run in the four to six hours after that spike happens. And so that's when we need to have all the compute come online and that's what helps us answer all those queries as fast as possible. And that's a big reason why Eon is an advantage for us because the rest of the day, we kind of, we don't necessarily need all that compute and we can shut it down and not pay for it. So Ron, I wonder if you could share with us just sort of the wrap here, where you want to take this? You're obviously very close to Vertica, you're driving them hard in Eon mode. You mentioned before, you'd like the ability to load data into Eon mode would have been nice for you. I guess that you're kind of over that hump, but what are the kinds of things, if Colin Mahoney's here in the room, what are you telling him that you want the team, the engineering team at Vertica to work on that would make your life better? I think the things that need the most attention, sort of near term is just smoothing out some of the edges in terms of making it a little bit more seamless in terms of the cloud aspects to it. So our goal is to be able to start instances and have them join the cluster in less than five minutes. We're not quite there yet. If you look at some of the other cloud database platforms that they're beating that handily. So I know the team is working on that. Some of the other things are the control. Like I mentioned, while we like control in the column store, we also want control on the cloud side of things in terms of being able to dedicate cluster, sub-cluster specific. So we can pin workloads against a specific sub-cluster and take advantage of the cash that's over there. We can say, okay, this resource pool, the sub-cluster is a new concept, relatively new concept for Vertica. So being able to have control of many things at the sub-cluster level, the resource pools, configuration parameters and so on. Yeah, so I mean, I personally have always been impressed with Vertica and their ability to sort of ride the way of adopting new trends. I mean, they do have a robust stack. It's been 10 plus years around. They certainly embraced the dupe, they're embracing machine learning. We've been talking about the cloud. So I actually have a lot of confidence to them, especially when you compare it to other sort of mid-last decade MPP column stores that came out. Vertica is one of the few remaining, certainly as an independent brand. So I think that speaks to the team there and the engineering culture, but run a few final words, just final thoughts on your role, the company, Vertica, wherever you want to take it. Yeah, no, I mean, we're really appreciative and we value the partnership that we have. And so I think it's been a win-win, like our volumes are like, I know that we have some data that got pulled into their test suite. So I think it's been a win-win for both sides and it'll be a win for other Vertica customers and prospects, knowing that they're working with some of the highest volume, velocity, variety data that's out there. Well, Ron, thanks for coming on. I wish we could have met face-to-face at the Encore in Boston. I think next year we'll be able to do that, but appreciate that technology allows us to have these remote conversations. Stay safe, all the best to you and your family, and thanks again. My pleasure, David. Good speaking with you. And thank you for watching everybody. We're covering, this is theCUBE's coverage of the Vertica Virtual Big Data Conference. I'm Dave Vellante. We'll be right back right after this short break.


Are we actually using it? Oh, we are. Yeah, they don't have to move during the evening. They're just picking it up. Yeah, don't they need one for the audience? Sure. So they could be heard? Yeah. Okay. So I am with the audience. Yeah. So then take them off. Hello everyone. Welcome back. Thank you so much for joining us for the panel. I'm Minta Ortiz and I work with Borderlands Theater. I also happen to be the playwright. And I'm just here to also let you know that we are live streaming the panel. So it could be, it might be being watched everywhere around the world, possibly. So we would love for you to participate and ask questions. And we have a microphone there that I'll be holding. And so if you want to ask a question, come up to the mic and ask your question. And so the mic is not actually live here. It's feeding into the live streaming. So for the panelists, we will pass the mic around so that everybody can be heard. And cool. So I'll hand it over to our wonderful moderator, Tina Cross. Thank you. Thank you very much. I just want to say good evening to all of you. And thank you so much for coming and sharing in this historical moment in our church. But before we get started, I have a very special request. I really don't want to have to talk to you way back in the back. So if you don't mind moving forward and let's be a community here together, that would be greatly appreciated. Come on over from the Banco. And there we go. That's better. I mean, I don't think folks are going to bite each other here. Okay. I was quite surprised when I was, well, I was asked to be, I thought, on the panel. And then I saw listed that I was the moderator and I'm saying, okay. And so I've been really thinking about, you know, how to present all of this to you. And I feel like that for you to best know how Eleazar and Reverend Allison Harrington have become a part of this community of faith is to have a little bit of a history.  What has brought us to this day that provides the backdrop, that provides the life, that provides the vision for them to be able to function here. Southside was started as a mission church for the Presbyterian church in approximately 1903. And they met in a tent. And in 1906, they built their first chapel. And if you had a chance to see the pictures out in the foyer, you will have seen those structures. The church burned down in 1937. And the Presbyterian thought, well, okay, we'll just leave it. But the church... Reverend Somerville was here until 1956. In 1956, we have Reverend Casper Black. He was a Black minister. And he was active in the Civil Rights Movement, brought us accommodation into the Civil Rights Movement. He was president of the NAACP here in Tucson. And we picketed and we marched for those areas of public accommodation that were segregated at that time. He was here until 1964. There was a period of time, definitely plus, we didn't have another minister for a couple of years and then we were... It was called to basically get us on our feet because it was at a point that the church was about to close its doors. And John presented himself to the session that still existed at that time and to the Presbyterian and asked for a period of time in which to get the congregation back into a functioning organization. And so he came in approximately 1969 and was here then for 35 years. I unfortunately did not have the pleasure and privilege to actually be here during the 80s and the Sanctuary Movement. I visited the church usually every six months. I was living in California at the time and my family still was here so therefore I came home and knew what was happening. Saw some of the refugees that were here in our Sanctuary. And then we had our major because we wanted to have showers for the refugees that were here. That was the idea for this kiva which finally came about. The showers are there but then we also ended up with a new kiva, a new worship center. And so that's kind of a capsule but as you can see there has always been from the very beginning that basis of social justice, that basis of taking care of your neighbor that has been a part of the life and the love and the faith of this congregation and has provided the foundation for the community organizations that still function or came out of working in this congregation. Eleazar Castellanos is one, he is the leader with the worker center that started 11 years ago here in order to provide individuals with a safe place where they could get work and be able to provide for their families. And I'm going to allow him to talk more about the program and his role and what they do with the worker center. And also it is my privilege to introduce our pastor, Reverend Allison Harrington. And she has now in 2019 will have 10 years with us. And so we're really very pleased and she comes with a long length of credentials which God has prepared her for this crazy congregation of Southside Presbyterium. And I'm not going to go through that litany. And then she will talk to you about her activities with the congregation here at Southside and then the current day sanctuary. So I'm going to turn the microphone over to Eleazar and he can talk to us about the work center. I'm nervous, I've always been nervous since the moment I came here. I've always been nervous when I started working on this place. I didn't know it was a sanctuary. I didn't know it was a safe place for the workers. But once I knew it, I just stick up. I said, this is a place. This is the place. Siempre tiene que existir un lugar como este. Disculpe mi inglés. Tengo más de 20 años en este país y no lo puedo hablar bien. But it was a pleasure for me to be a member of the Southside Worker Center. The Southside Worker Center started in 2006. When I came to this country in 1996, things were way better than 10 years ago. But suddenly everything started going bad for everyone here. 10 years ago, 2010, so many anti-immigrant laws became on this state. And many things changed. We started having so many problems finding jobs, people losing their jobs because of the status. We didn't have enough. A national leader in the immigrant rights movement, he was a participant in the Undocubus, which was a version of the Freedom Rides that went through the southern part of the United States to the Democratic National Convention to protest the deportations happening under the Obama administration. He was arrested then, which is very courageous for undocumented people to be arrested. He runs OSHA trainings. Our men have OSHA trainings, which is so good to keep them safe on the job. I just want to say just a few words about what we do today. And then we can have a few minutes for questions. But I'm just so privileged. And every time I see this play, at the end, I always cry, Miltha. I'm always like, oh my goodness, because this congregation is just an amazing congregation. And it's who they are, and it has nothing to do with me. I'm just happy to occupy that office right over there. But it's a deeply hospitable congregation. And it's not just about refugees, but it's about the homeless that come here twice a week to get fed. It's about providing a sanctuary space for day laborers to gather. It's about the multitude of ways in which we allow community groups to use our space. I think having Borderlands here is an example of that spirit of hospitality. Because the thing I want to say about hospitality is it's not easy, ever. You know that just entertaining people in your home during Thanksgiving, you have maybe folks come over and it's nice for like a day and then it's hard. And so having a whole stage set up here is hard. It like makes life just a lot more complicated. But the blessings are so amazing when we're able to really open up spaces to allow other people to dwell with us. And so the blessings always far. And so the congregation, even when I was like, well, we're going to have this whole setup, like nobody ever, I feel like other congregations would be like, no, we can't do that. Everybody I spoke to knew it was going to be hard, and it was going to be awesome at the same time. And it has been. So Sanctuary is still very much part of our ethos here. In 2014, we were part of reigniting the Sanctuary movement as the deportation rate soared under the Obama administration. We opened our doors to Daniel Neue Ruiz and then to Rosa Robles Doreto. And we were part of building a national network of churches that were responding to those deportation rates. And we were largely successful both here locally and nationally in getting people's cases closed and finding relief for a variety of people. And we were doing great and the network was growing and there was about 400 congregations involved. And then like this really weird thing happened and we elected a fascist dictator to be president, which is not a laughing matter at all. But a funny thing happened. When the president, the Trump was elected, Sanctuary grew like that. By the time of his inauguration, we had almost 1,000 congregations who were pledging to do the work of Sanctuary. And we currently have 1,100 congregations across the nation who are engaged in the work of Sanctuary. And we have 50 people living publicly in Sanctuary. There are a lot of people today living across the United States living privately in Sanctuary. But we realized this time that Sanctuary is a concept needed to expand because it wasn't enough for a congregation to say, we're Sanctuary, come find us if you need us and just kind of wait for someone to show up. We needed to go outside the walls of the church to make sure communities were Sanctuary spaces, that schools were Sanctuary spaces, that homes were Sanctuary spaces so that nobody had to enter into Sanctuary because Sanctuary is a horribly hard thing in terms of how it's being practiced these days. It's different than the 80s in terms of how it's being practiced. And so we found that we were really encouraging churches to get more engaged with their local day labor center, make sure your day laborers you know where they are, they're protected, work with your local legal clinic, work with your local immigrant rights organization and do whatever you can to support directly affected leadership and whatever that means.  And one of the things we've been telling people is that you don't really need that because people are saving themselves. But what people needed and one of the things that we learned was that when we asked people, the thing that they needed was childcare because mamas and daddies were coming together at these meetings and they needed childcare. And when we offered, when we started offering that, people were like, really? They weren't like impressed with like sanctuary. They were like, oh, you'll do childcare for us. That would be amazing. And it was a powerful way to kind of subvert power dynamics that have long existed, especially between women of color and white women, women of color mostly historically taking care of the children of white women. And so we're able to subvert that paradigm and take a back seat and support the leadership of others. And so the work has continued and deepened and kind of, again, following the leadership of directly affected folks who were also saying, it's not enough for a city to say they're sanctuary and then keep doing police enforcement in the same way that they've been doing it. And it was the movement for Black Lives that really was helping us understand this as we were once again aware of the way in which police patrol certain neighborhoods in different ways. And so that call to expand and deepen sanctuary has been something that has been felt, I think, across the nation and especially here. And so today we continue the work, trying to find ways to work alongside those who are directly affected following their leadership, doing things like making sure the board of supervisors here in Tucson refuses funding for Operation Stone Garden, which gives Sheriff's Department more money to aid in immigration enforcement.  Jim Corbett wrote a book called, oh I'm not gonna remember it, because I've never read it and I actually looked forward on Amazon and it's like $200 because it's out of print so I'm probably never gonna read it. But they had this, they had this, back in the 1980s they wrote this letter to the judge at the time of indictments and they said basically we'll continue this work until all of the earth is a sanctuary. And so we try to hold true to that and continue the work until no one has to live inside a church out of fear for being torn from their family. Thank you. Thank you very much. So we only have a few minutes left and so does anyone have a question of either Eliasar or Reverend Allison Harrington? I have a question, a couple of questions. What is Akiva? We're inside Akiva, but what is it? You want me to explain it? Okay, Akiva is a Hopi worship center in the earth and the design was something that Reverend Pfeiffer wanted to maintain the foundation of our church for the peoples that it was originally planned for which was our Native Americans, our Indian population, and originally they were called Papakos in this area. Although this is Hopi, this came from the New Mexico area and as you can see there is the opening at the top and we basically, you would have to climb down that into the ground for their worship and meditation and since we all can't do that, we just have that, you know, Fox opening up there and we have the design that takes us down from the level earth outside in order to do that. We have the natural pines, we have the saguaro ribs in these, so we wanted to use all of the natural kinds of building materials that is used for the Native peoples in this area. Thank you. Question about, you mentioned that you had people in sanctuary here, Alison. Rosa, how long was she in sanctuary and what was the outcome of that? She was in sanctuary for 461 days, not that we were counting the days. The outcome, so she was, we reached an agreement with the government that she would be safe to leave so it was, yeah, it was a long 461 days. Sarah Launius is here, who is an amazing community leader who was part of, was, we wouldn't have been able to do that work without her brilliance and so it was a long 461 days but I think it, for me, it was a day, it was a time when I learned what true solidarity means because there was times when it was like we had tons of press and congressmen would come and visit us, Linda Ronset would come visit, all these people would come visit and the prayer vigil would be huge and then there was days when nobody seemed to care and in those days when everything seemed hopeless and you decide not to quit and you decide to stick with it and to stand with somebody, that's when solidarity is not when it's easy and that's what we forget, we think it's going to be when it's easy but it's really true solidarity comes when it's really, really hard. To break down what it means to have somebody in sanctuary, can you explain that? Yeah, so it's interesting that the first practice of sanctuary in the United States articulated as sanctuary was actually during the Vietnam War when conscious objectors would take sanctuary in a congregation and church to avoid the draft. They were then actually, police came in and dragged them out of the churches which caused this huge public outcry, this image. So it was around that time that the government decided that churches and congregations would be considered sensitive locations and so that's one of the protections that a church has that law enforcement is going to be limited in terms of how it's going to operate but really it harkens back to biblical kind of mandates and continuing on through the middle ages as they said in the play, we don't want to go back to that time but the idea is when someone enters into sanctuary they enter into the protection of a church, of a sensitive location. That being said, if the memo around sensitive locations went away tomorrow, we would still do the work. It doesn't depend on the permission of Trump, obviously. And so you stay here and people do not leave the church so people call it a golden prison a lot of times because it is a beautiful thing and a heartbreaking thing at the same time but they don't just enter into the protection of a church where they live their life until their case can be resolved but also they enter into the protection of an organized community that is advocating for their deportation case to be resolved in a way that allows them to stay within the country. Thank you. And I think this is the last question and this one for Elisabeth. Does that law that you or that the thing that makes churches a safe space, what is it? A sensitive location. Does that help the worker center? That the worker center is here? Con esa ley le ayuda? Absolutely. That was the reason I stay here because it's a sanctuary for me. I'm not from Central America but I was someone who was dreaming to have a better life with his family. And I'm here. And who say things are easy? It wasn't easy. I was going to say about that and I completely forgot. But yeah, you know, day laborers are probably the most vulnerable in terms of this administration. They are the ones who are like the most persecuted and the ones who are most scapegoated and they're kind of the idea that Trump tries to invoke when he's trying to really just be particularly anti-immigrant. And so it's an honor for us to be able to stand with the day laborers and hopefully provide them a safer place to be. I will just mention one other thing. A big part of the hospitality, a big part of who we are as a church is we want to consider ourselves and I think people do consider us a hub of social justice work that happens here in Tucson and that's something that we have a lot of, there's people always here, half of Tucson has keys to this place. And we're about to, we're renovating, we're about to, we're not, Mark said at the beginning, we're not demolishing, thank you, the old sanctuary, we're renovating it and demolishing the Fellowship Hall Wing which is dreadful, beloved but dreadful. And so we're still in the midst of fundraising and we want to support the work of sanctuary, the work of Southside, you can donate online, especially to those who are streaming. I was going to ask if people want to support Southside Presbyterian Church, want to find out more about it, where would they go? Southsidepresbyterian.org


Hello, thank you for joining me. You can see where I am. I'm at Gospel Oak I've just come on the North London line from Wilson Junction So that way is looking towards Wilson Junction and Richmond and that way is looking towards Stratford We'll get a better view once the class 378 has departed We've come here today because we're going to do the goblin line since it's trains to parking Well, they go beyond parking now. It's a parking riverside. So as the train departs, we're gonna wait for our train to come in here So this is what's known as the goblin line as in Gospel Oak to Barking But last week they extended it by one more stop to Barking Riverside And that's what we've come to do today. There goes the class 378 So now that's gone. We'll just have a quick look at the North London line So line curves that way towards Camden and then it curves again and heads east and then if you look that way You can see that way goes towards Wilson Junction We're kind of at the bottom corner of Hampstead Heath here So this line I've seen quite a few changes on this line because when I was old enough to travel by train on my own This was class 150s on this line when it was all part of what was the Silverlink Metro And they used to use class 313s on this line Then the 150s were replaced by class 172s, which then went to West Midlands Railway So you can ride them still in the Birmingham area. In fact some of the X 150s that worked on this have now gone to Northern. I was at Bolton station in early 2020 And I saw a class 150 still in the London Midlands colours coming in So we're just waiting now for our train. In fact, it's funny on the dot matrix indicator. He says the train has arrived Hasn't. But it does say Barking Riverside. Oh, yeah, here we are So this is one of the new trains which now work the Gospel Oak to Barking line since it's been electrified Although when it was electrified I did want to travel on this line on a class 378 But shortened to four cars because I think you can only fit four cars on this line So the train's gonna pull in we're gonna ride our way right through to the other end Incidentally those lines there there. That's the freight connection. I did want to do that on a rail tour That's very rare for passenger haulage. There's a train coming in. Let's go into Richmond So we have two different types of London overground EMU. So we're gonna go on seven one ten two six five to Barking Riverside So we've arrived at Barking. We saw a couple of interesting things on the way as a C2C train Gospel to Barking trains used to terminate at the platform right over the other side of the station That's now effectively become a siding so if you're track pressure and you haven't done that siding then I don't know when your next option is going to be but we're now on the line towards Shoebring next So I've never been beyond Barking on a London overground train for you've also got the district line to upminster The C2C line straight ahead to Shoebring S. Yes, so I said this was got to you That's technically it does but this is the long way by Tilbury and a good strain It's just going past on that side and it's the good train for looking out on this But I saw quite a few other good trains on the way. So that's the London Tilbury Now we're heading down here this good strain we see it's probably come from Ripple Lane, there's a big freight yard now just before the freight yard we take this new branch So I've done this bit of track before but very soon. I'm going to Get a new bit of track that haven't been on the flyover will begin very shortly And the whole of this new line is on flyover. So it's always exciting doing a new line the last new line I did in London was obviously Elizabeth line if you're interested have a look the link on the screen now This is much shorter, but completely different whilst that was mainly underground. This is London overground So we're currently still on existing track. I have done all of this In fact one of those never did this line. I did this on the Hastings unit. Hastings 101 quite a few years ago So that was quite exciting Quite rare to probably do this on anything other than a C2C unit It's a good modern mile I'd say away from Parking where it begins. There is talk they might but another intermedia station or the car transports wagon It's just before this is becoming a Railway was a class 66 there 66 1 1 2 So this is all part I think it's part of the Ripple Lane complex is another class 66 stuff here It's quite good for our way if you just use it because of Dagmum dock You see any trains then come back and I was 66 1 6 9 I'm waddling away Now this looks like I think yes, we're on the We're not on the fly. We're on the new bits of track. I think the C2C lines the ones on there This looks like new overheads electrification. It's another class 66 66 number 30 So yeah, good bit line for all of you. You know that we're now on the new tracks. You can see Track laden's conflict if you just look ahead and just see divide that was curving away So we now cross over the C2C lines Just cross over to this side So all of this was Ripple Lane yard. I believe you know that there is still container terminals down That's probably where that container train came from we saw It's really gone C2C line. They go either side of the yard and now we're on the entirely new bit of track See the vine up snaking away ahead of us and I look like over there. They built a new country parks at the moment all of what you see looks like waste ground There's all a big ground brownfield site. It's all been regenerated. There'll be lots of new homes Probably a bit like what you can see on that side the trains at the moment the trains fairly quiet See, I'm not quite the only person on it But in a few years time this will probably become quite a busy train people will use this to commute into London Imagine flats and houses built all along there in the distance over there You can probably see some smaller tower blocks I think that's possibly Thames Mead, which is on the other side of the River Thames Well, my intention is it's called Barking Riverside to go and have a look at the river itself So we're just coming into the station now. It's a bit of a dead end What we really cool is they can one they extend it over the Thames That'd be quite exciting There's a college there a Riverside campus. So yeah the term Riverside is very much Yeah, I can just see the Thames over there and see some development is clearly going on here So So this is obviously winning station for me winning bit of track When I come back, I'm not sure if I'll get to do the crossover But um There's obviously crossover there. It depends when I come back I'll try and get a train out the other platform and I'm not too worried about the crossover So we're just coming out. I'm in the last carriage. So when we get out we'll be able to walk down The whole train and have a look look out over there. Yeah get a good view now of the Thames You can see industrial ships in it or maybe you can't but well I can see industrial ships The camera may not be picking them out, but they are there. So this view you actually get quite a good view from the station But all of this will disappear when they build houses. You won't be able to see quite so far So let's get off and have a look around this new station so I'm filming this video today um On what is it? It's wednesday 26th of july the station opened on that really really hot day when there was a heat wave Um, and everyone was advised not to travel. So I couldn't travel. I happened to be down in the south So I went to the isle of white that day. So if you want to see that have a look at link on screen now So let's have a look. So this is the train. We've just arrived on one 7-1-10-2-6-5 That's the view you get out of there. So you can see the river Ships in the distance. You can see some Incinerators and then over there. That's all the other side of the river.  You've arrived at parking riverside How can we see down here? So it's obviously bus routes come this way because I can see a bus down there From the end of the platform here gives us a chance to see the viaduct stretching off Back towards barking I think possibly in the future there's talk of the dlr being extended here And I can just see an aeroplane landing at city airport or that's the cameras picking it out I suspect it may happen that the dlr gets extended here. I think something will happen Whether it would be great if they did extend this over the river, whether they will My thought is it might have to be some sort of lifting bridge If they were to extend it because you might not get the big ships underneath at the level we're at because We're not exactly that high above ground now. Let's have a look at the architecture on the station. Look at that. It's Very quite an impressive building It's kind of semi inside and semi outside. It's quite windy up here. Nice and cool. It's not too hot today It's about about 20 degrees 19 degrees So that's why I didn't come here. I could have come here Last Tuesday, but that was that day that was the hottest day We've ever had and I didn't come here. That's a new design of seats. I've got I didn't come here on that day Because I just thought, you know, well, we're told not to travel and I think it would have been in If I don't actually think any trains ran that day I think trains ran on the opening day and then everything began to go wrong. So Trains effectively stopped running to get to here. So if you arrive and Get catch a train, it's raining. You can wait in here. Although thinking about it Would you ever actually need to sit on these seats because it looks as though there's always a train here It's a train here now and as we saw there was already a train when we arrived. So I think these seats A little bit pointless although I suppose it could be useful if there were times of disruption And you know, there were no trains here Then you may need to use those seats now. Let's have a look around This so the way out stages this lifts over there. There's um Steps going down From this end of the station. We get a really good view out over the river I can see a boat in a distance. Let's have a walk around here. So it most looks like It's not out the question that the line could go further wherever this will always be determinist I think probably what will happen Is there will be another station On this line. I don't think this will always be the end of the line. I think that will happen So just come around there. So there's the lifts will go down the The stairs to find our way out So yeah platform so that's platform whilst platform two trains to gospel oak, which is where we came from Now let's go and have a look Stairs to way out and see there. It's embossed. So if you were partially sighted you'd be able to find your way out So that's all quite good Yes, there's two sets of lifts says you go on the lifts. They go right down beyond there So that's fine out where the lifts come out because I'm you know inquisitive like to look around see I'm interested in those tiles they look like um Look a bit like a some sort of chocolate, but obviously they're not and yeah, they're just sort of lightweight concrete tiles, I think Reminds me a bit of obviously when we did come here to look around when we came to London to do the Elizabeth line on its opening day Although it's not quite the same. It's on the similar kind of Fairly grand scale although you couldn't put an Elizabeth line train in this Platform because it would be way too short.  I doubt a rail tour would ever come up because I'm gonna feel a short rail tour That's the bottom of the lifts Ahead of us is the gate line And so what we'll do we'll go through the gate line. We're going to have a look around the outside So here we are we're on the outside of the gate line at Barking riverside Interestingly, see how the ticket machines are actually set into the wall normally They're sort of forward because they've been put in afterwards because this was built with things like that in mind So we come out here Who says Barking riverside and there's that substation pylons So it's just some sort of drop-off zone here. Maybe a bus is well. It's a bit funny that Rope junction. Let's go through to the other side. There's not much to see out there. So we walk back through the station So we'll past Oh, I think ticket barriers, you know when they're brand new and they've got no you know, they're not worn out They they sort of look they come to look a bit tatty quite soon, but they don't yet So there's the thing is the ticket office is such which is assistant as their development parking riverside And there's also In here it says cycle parking. So let's have a look. What on earth are they? So now in the cycle parking thing Why Why is their Turnstiles Do they work right anyone watching? Why is their turnstile? They work And they go both ways That is really strange. Why are their turnstile Style Obviously not a ticket barrier Not many bikes. I suspect eventually this will be full with bikes There's what three four bikes in here now So i've done them all Why are their turnstiles here? That is the Or this thing i've ever come across This door opens So, um, yeah, that is weird. I don't even know what i'm supposed to be doing that, but that's interesting Right. Oh, yeah, look officially opened by the mayor of london july 2022 I wonder if they didn't put the date because the date It kind of opened it didn't really open because of the heat waves. They've just put july that's interesting. Anyway, um No doubt. I think what i'll have to do is come here again Maybe in a few years time and just compare the difference. That's interesting Get a view of this outside of the station with its You know overall roof that's the train we came in on I think that's what i'll have to do I'll have to come here again in a few years time and just have a look See how it's changed because it clearly Is not always going to be like this. That's what i find fascinating about visiting new stations I'll tell you another place it does remind me a little bit of Um Is brides glen That's the end of one of the louis tram lines in dublin The tram station is a bit like this it ends Here except there the development never happened. So once you get to brides glen what I notice is you get people who live Beyond there in say places like bray You see cars waiting to pick people up and they and people do ride the tram to the end of the line Um, but the interesting thing is when you get on the tram in dublin It says, um, this tram is for cherry wood Um, it doesn't say and cherry woods the penultimate stop and I said to try for one day I said why do they say it's for cherry wood when cherry wood isn't the end? And I asked him is that brides glen he said well have a look around. What do you see? I said nothing, but there's your answer. So um, it just does remind me a little bit of that But it seems to all those cranes The development is happening. This path seems to be a bit endless. What I'm going to do I'm going to keep walking and I'm going to find river Thames So as well as the station barking riverside is the Brand name for this huge development. That was that what seemingly seemed like an endless path We just walked along and there's the station. So all of this view we see here Is a temporary view, you know buildings are going to crop up all here. You might just get that view I'm not sure what's going to go on here You can see there's sort of um, there's a few paths around Um, so it's going to be quite pleasant when it is all done. There's obviously going to be building done here What's this about? This is another strange thing. Look at this There's a a temporary bridge But why is there a temporary bridge here? If we go over it and look Doesn't yeah, I don't think they've just painted it. Why have they built a temporary bridge here over nothing? Anyone watching know the answer? Goes to all four stations. If you know why there's a random temporary bridge Look and it is a bridge. It's not just a ramp. It's please serve no purpose. Look Why Why is there this temporary bridge? What's this for? Very strange It's funny place this they've had mystery turnstiles mystery temporary bridges Um, yeah, what's all this about? and it says Footpath 47. I think if we go down footpath 47 We might find river 10 and again, there's that view training the other platform Of barking riverside and clearly see the work going on I can just see the city over there and shard in the different distance Let's go down here because the 10th is now in front of us And um, that's what we've got here. There's all these containers It says barking riverside project office. So As we know, it's a big development And I you know, I am interested to see this development develop Oh, there's the tens So we've kind of reached the riverside at riverside In the distance. I can just see the qe2 bridge. I don't have to camera or pick that out But this might be a cafe or something. That's quite nice Um, what's here? So again, they're probably going to develop there I want to at least get to the river and I feel like I've reached the riverside at barking riverside I did a few years ago walk along Yeah, I think it was long there. Well, I did the london loop, which um one day I'll do into a series of videos on I went by train to ereith And I think I walked to that section's london loop And as I said, I could spot temsmead when I was on the train which temsmead is more Over abbey wood where of course the elizabeth line goes to So I think we've reached the riverside At barking riverside all over there Is your other route into london, but it's peak time only the tems clippers Go there they're building new ones. I think on the isle of y or some new boats So that's something we can do right. I'm um, can I go down here? I'm not going to go down there looks a bit dangerous and So Here we are. We've reached the river tems at barking riverside. I hope you enjoyed this video Thank you very much for watching. Please do feel free to like subscribe and comment If you want to come do this yourself. It's very easy. You can just get your get the train to barking and do this nice little branch I'm going to make my way back to the station and ride the train back to barking. So thank you very much. Goodbye


Madam Premier. Thank You Madam Speaker Over the next few days hundreds of thousands of British Columbians will join millions of Sikhs around the world and celebrating Visaki and British Columbia as all members know is the home of the largest Visaki celebration in North America, and that's the day that we celebrate the birth of the calsa It's the day that we celebrate the proud and enduring principles of the Sikh faith And we are lucky in British Columbia that over over a hundred years We have succeeded in attracting so many people to our shores of south asian descent An entrepreneurial community minded group of people who have made such a difference And I look forward with other members of this house in joining the thousands of people who will be participating In visaki events over the next few weeks I'd like to say on behalf of this house to all British Columbians Happy visaki. Luck luck for Diane


around this. I'm going to just put a table around it by going to the insert tab, tables, and then we'll just add a table around it and say okay. So then I'm going to I'm going to make these two cells skinnier again. I didn't mean to widen the cells out like that with the table. All right, so now so to simulate a draw of a card if it was an even deck that has all 52 cards in it you don't have the card shark with an ace up their sleeve that they snuck in to the deck then you would expect that we could just do a random draw between 1 and 52 to simulate a random draw of the card. So I can then let's make a skinny zero here a skinny zero column and then I'm just gonna say this is a random draw of a of a fair deck that we're trying to simulate. So I'm gonna go then to the home tab font group make this black white alignment group wrapping it and then alignment group centering it. So I'm gonna use my random number generator again. I'm gonna say rand between and I want to take it between 1 comma 52. So we're just gonna get a random number between 1 and 52. Enter there we have it. Now the question is well how far down do we want to go now we have it we're in Excel here so we can do this for quite some time so let's let's imagine that we did this a whole lot of time so let's take it down to like thousands of draws just for the fun of it. So we're gonna go into like I'm gonna drag it down to let's say like 3,000 I'm sorry let's say let's keep it down here I went to 5,000 that seems a little much. Let's just we'll keep it 5,000 instead of 5,002. I'll see if I can go up to just 5,000 5,001 because I think we started on cell number two. So a whole lot of random drawing happening here so I'm gonna go back up and so that would obviously take a lot of time in real life but our generator can do that and so then I can go into the insert tab and let's put just a table around it and it'll grab the whole table all the way down to cell 5,001 and then okay so now we've got a random generator so we've got a random generator and if I double click on it it should reshuffle or I can like re-sort it and it'll reshuffle as I re-sort it. So now let's just mimic one one of those random samples of you know the 5,000 draws that we drew one card at a time so I'm gonna copy this whole thing I'm gonna right click and copy and I'm gonna put it in column R but paste it just one two three so it just grabs those numbers and solidifies them to just one number. Let's go ahead and put a table around this one, insert and then tables and insert a table so here's our result of the first random draw and I'm gonna make this home tab alignment wrap center and there we've there we go so now we can sort that we could sort this you know a to z or z to a if we so choose and we can see all the ones all the twos and whatnot but there's a lot of draws there so we could then we could then try to come up with a table showing how many times each of those cards were drawn and see if that kind of lines up to what we would expect and how far off we are and so on. Let's make a skinny Q column to do that I'm gonna make a skinny S column and so let's say that we have our table again with our assigned number let's start off by just copying the table we did over here right let's copy the table we did over here where we had these three our assigned number let's copy this stuff from L to N I'm just gonna copy the whole column and we'll bring that on over here and I'll paste it in column T pasting it the suits got messed up because I used a formula to get the suits so let's just say the suits let's just type it in here this is going to be spades well let's do this let's hard code the suits so I'm going to go over here and I'm going to copy this whole thing and instead of pasting a formula I'm gonna right-click and paste it one two three so now the suits are hard coded and there's no formula in there okay so there we have that and then I'm gonna say the so these are our our results results from the five thousand and one or five thousand draws that we had so let's do a count of the results so now I'd like to do a count function and I'd like to say I want you to count it if it's a number one so however many times the number one shows up here that's what I want the result to be the number one standing for the ace of spades so I'm going to use our trusty count formula count if brackets and then I'm going to say the range is the first criteria selecting the entire range that should pick up the entire range of the table comma and then the criteria is this number one not the card number because that repeats I want the number that we assigned that has an individual a number per card so it picked up and notice it copied the reference all the way down for us because we're in a table so that's great that's what we wanted to do and so there there's our results so we've got it has seventy nine ones one hundred of the twos of spades spades right and then the count of 28 which represents a two of diamonds ninety of those and so on so if I then I can add to the bottom of the table a total right we'd like to have a total down here so let's go up top and to do that with a table I can go to the table design I can go to the table style options and let's add a total column so there's our total and then when it counts this up it comes out to five thousand and that's correct because that's how many times that's how many how many of these we did how many times we drew one particular card out of the deck of fifty two five thousand times alright so now we can get a percent a percent of total so so how often is that from a percentage basis common calculation when we're doing our statistics it's going to be equal to seventy nine divided by the total which is five thousand enter it copies it down I can't see anything because the cells are not in the format of a percent so I'll select the whole thing home tab numbers percentifying it I can add a couple decimals to it and then if I scroll down we can see that it should sum up I'll choose my table options to summit it should come out to you know a hundred percent number


in this video we're going to talk about will cciv stock reach $30 now of course cciv is rumored to be merging with lucid murders now i'm going to go through my price target my thoughts on where i think this stock could go and again i've got to preface this is this is a highly speculative stock at the moment because it's not confirmed so you've got to preface that with some potential risk especially as it's run up quite a lot already but there's still some upside i think in terms of where it could go towards the future as well so let's go through the information i've got to say i'm not a financial advisor i am a business teacher in my daily life but i'm by no means an expert on the stock market so let's go right into the information if you appreciate the direct approach then do leave a like on the video let's get into it so lucid murders is obviously here one of their car designs here you got a horsepower 480 starting price of 69900 usd in projected range of 406 miles now the two areas that i really like about this car we'll go into one of them later the first one is the design of the cars they look incredibly good in my opinion i think the design of lucid murders is really really good and again it's interesting they are trying to reach a much more shall we say middle high class target market right because of the prices of the cars so they're not going mass market in that sense they're trying to reach a specific target market with some really luxury cars and they're focused in that area and i really do like that because i do believe that any business needs a strategic direction right so whether they're going their target markets going after individuals with more money and creating a better quality product for that market or something more mass market for everyone right so any business needs a strategic strategic direction i think this business has got one right in terms of what they're trying to do and where they're trying to reach their customers so going into this one of the recent users and i just found this quite interesting sometimes with stocks especially when i'm looking at are they expanding are they growing i like to look at if they're actively hiring so that we can tell whether they're actually you know actually growing and they're actually planning to expand and some interesting stuff is that they are actively hiring a lot of positions lucid motors at the minute so they are scaling stuff up to me that would say they're expecting a good cash injection and where can you get a good cash injection from a potential merger right so i'm kind of maybe i'm putting two and two together and coming up with five but i think that obviously lucid motors is going to merge and go go public at some point and and this looks like it's more than likely to happen i'm not saying that it will happen because it's not fully confirmed but it is more than likely i would say now before we go into some of the news that i've got for you i'm going to say thank you for all the support we're trying to reach to 10 000 subscribers as fast as possible so if you're new to the channel then welcome what we do is we cover latest stock news and also penny stocks and a range of other stuff so if you could subscribe to the channel that'd be fantastic and hit the like button and if you're already subscribed make sure you turn on notifications so you get fast to the queue for the latest video okay so i'm going to go right back into the information that's my plug over with right moving on lucid suitor stock sores on report that that basically a merger is near and it says the value of the stock of the blank check company that is reportedly near and a deal to take lucid public more as more than doubled this month okay so it's looking to potentially merge with this particular SPAC okay and there is a lot of rumors going around that is circulating and it's looking more and more likely the more and more we hear about this right and also you've got cciv here cciv stock comparing lucid motors to tesla as merger monday hopes saw many investors are hoping for a confirmation on the lucid motor SPAC merger after the weekend so we're potentially going to get a confirmation soon according to these reports rumors and dreams are sending Churchill capital iv to the moon on friday with investors hoping for confirmation of lucid mer motors SPAC merger soon one reason for all the speculation is the potential for lucid motors to disrupt tesla and its electric vehicle dominance so this merger monday the talk of the town here is what we need to know about cciv stock so the story here is simple minus the lack of merger confirmation bloomberg reported the blank check company was in talks with lucid mer's and bloomberg is fairly reputable right and if they're talking and reporting that then that's it seems to be fairly reputable and investors have been celebrating ever since we've seen pops and drops in the meantime and Churchill capital executive Michael Klanders have been working so looking at this it's more becoming more and more persuasive that it's going to happen and i just want to talk about the stock a little bit itself or lucid mer's themselves so it does look like they go in public right it's more likely going to be cciv but even if it's not them and it's some other through another SPAC right i still think cciv away you need to keep this stock overall on your radar because i think it's a really really good interesting company what i can see so far one of the areas i really like about this company is the personalization factor now what do i mean by that is you can actually personalize your lucid vehicle so you can put like a certain you know model variant on it you can put different colors you can there's a various ways you can personalize your vehicle to your needs and i think that's a really nice personable touch to the company and the consumer buying process right so i just wanted to kind of point that out because nobody's really talking about the fact that there's this personalization aspect to it which i think was quite good now we've also got this other article and this one's from the los angeles times you know and that's incredible because after this article was posted it actually the price shot up even further right so lucid murders prepared to go public thanks to sardine money and SPAC mania again so so it's looking more and more likely in the los angeles times the los angeles times they're now covering it and from that it just shot up even further carried on from this article it says on the los angeles times the well fund invested 1.3 billion in the electric car start-up lucid regained full health now in 2021 the sardine funding lucid founders are poised to cash in by taking advantage of the manic market in so-called blank checks shell companies also known as SPACs in a deal that is near completion according to a source familiar with the negotiations the company would draw a hefty but as of yet undetermined amount of cash to fund its operations if the deal goes off without a hitch lucid executives and board members including chairman andrew levaris a former dow chemical chief executive deep financial ties to sardine would give it get a shot at the big payday in a bull market that the words frothy hardly does justice though increasing numbers of private companies are looking to cash out through special purpose acquisition companies SPACs offer a quicker easier more secretive way to take a private company public versus the conventional initial public offering okay yep so it's just a good way for them to also obviously get out there quicker but also get that cash injection from the SPAC as well and you know like I say it's covered by the los angeles times now this is massive now the current price you can see here is at 2340 aftermarket now I would say if this news continues to happen in terms of the rumors and if more reputable websites start covering this and we also potentially get some sort of confirmation or nearer confirmation right I think this is going to explode past 30 dollars now I want to preface this with saying this is this is risk this is potentially a risky stop because if it comes out that it's not actually merging with CCIV this could plummet it could plummet back down to sort of 12 13 14 dollars and that is the risk so the risk is do you think that it's likely that it's going to merge with CCIV or not I would say it's more likely than it isn't I think it's more likely that it will happen rather than it being more likely that it wouldn't right and so there is that so there is more likeliness that it could potentially pop past 30 dollars but then there's always that chance where you know this isn't confirmed and then it just drops so it depends on your risk tolerance on this stock I certainly wouldn't put a huge chunk of your portfolio in this no matter the upside because it is risky right potentially just as risky as some penny stocks if not even more risky right because it's based upon rumors and news this at least you can base penny stocks off some fundamentals of an actual company that's that's for definite right and so I would I would go with it go in this with caution I'm holding a position in it it's not a massive position but I hold a position I got in like 15 16 dollars so I'm happy if it dips to 13 14 whatever it's not really much of a big deal for me but again I'm thinking that if this news continues this is going past 30 dollars and like I say I do really like the company itself it seems like a really good company anyway so thanks for watching this video if you found this at all interesting or useful or anything like that then do leave a like on the video it does really help out the channel we're trying to reach to 10 000 subscribers as fast as we can and don't forget to support the channel as well by subscribing and also turning on the notification and I'll see everybody in the next video


Welcome back. I'm Dan and I'm Nathan. Today we're going to be talking about API keys. In the last video, if you recall, we had a data frame full of cities and prices of iPhone 5S's. Essentially what we want to do here is, since we're going to eventually want to put these cities on a map, we need to get lat longs for those cities. To do that we're going to use the Google API system, specifically the Google Maps API. So let's go make a key and store it in our vault behind us. Alright, let's go. So the first thing you're going to want to do is pull up console.developers.google.com. It may ask you to sign in. I'm already signed in here. If you don't already have a project established, Google will probably prompt you to start one. So here I'm just going to click create project. What should we call this one? You just give it a project name. It doesn't make too big of a difference. Maybe goat's milk. Goat's milk. There you have it, folks. Okay, goat's milk 144902. We're going to create that. And it's just going to take a couple of minutes to get that created. Once it's created, it'll drop you into the API's key, manager. And from here we can just jump right on down into credential on the left. So yeah, right over here on the left you can see credentials. We'll click on that. And with the new project, we of course don't have any credentials yet. So we're going to create a new credential. Scroll down to the bottom, create credentials. And what we want is an API key in this case. So we'll go ahead and click on that. It's going to create one. This is automatically created for you. And then you can just copy this along. And then we're going to store it inside of the environmental variables so that in case you need it in some public code or anything, it's not just publicly visible. Yes, go ahead and pull up a terminal. The way to do this in a temporary way is just to type in export the name of the environmental variable. So in this case, we'll just call it API key. And set that equal to and I'll just copy and paste that API key that Google put pasted to my clipboard. One thing you do need to get rid of the space between the equal sign and the key, you can go ahead and enter. We can check to make sure that worked by just doing a little simple echo, echo dollar sign API key. And there it the standard output is what I input. So in the way we access this in Python is pretty simple. We use the OS library. It's a little import OS. So import OS and then an OS dot environmental environment. And then you pass in the name of your key API key. And sure enough, and hit enter, we can see we have access to it. And there it is. So moving forward, we'll use this as our key in sight of accessing Google's APIs to find some latitude and longitude of all the cities. Join us next time. Thanks for joining us. And be sure to hit subscribe. We'll see you on the next video.