This is the first time I'm saying it on camera, but it's the worst thing when somebody says unicorn because it goes and tickles somebody's... that hurts us. So we would rather nobody noticed our valuation.


Welcome to the 2016 Lucas Oil and CHA Superstakes. I'm here with the winner of the classic amateur final, Parker Greason, who rode Ruma Hazard and scored a 2-18 and a half. Congratulations, Parker. Thank you. Thank you very much. Now, I hear that you haven't been cutting very long. Take us through that story.  And he said, I think I got one for the fertility that you could get bought decent and go learn a little bit. And so I thought, you bet. I'll go try it on. And it ended up being pretty good. She's a nice filly. So you chose the biggest event of the year to go do your first cutting. Well, I'd showed a little bit on the weekends growing up, but no, never hear it to call Sam. So we got more decent. And just a few months later, you've won a major title. Yes, ma'am. I've always been exciting, for sure. Take us through your run. You know, I can't even hardly recall now I've had to show today, but it was a good run. I knew we had three good cows picked out in there and I cut all three of them. I was able to cut all three and that horse was good. He really felt like he was tuned into what was going on. So he felt good and he really let me ask him for it and he came right on back. So how did you find the cows overall? They were good. Yep, they were good. Had a lot of fill. They headed good and kind of let me get worked in that middle third of the arena. Now rumor has it. Great name. Tell us about your horse. It's actually my mom's horse. We raised it. My mom and dad raised it. And she's been showing it. It's four year old year. And then she showed it in the non-pro up here. And she asked me before the cattlemen's if I wanted to show him a little bit. And I said you bet. So I showed him the cattlemen's and then here. So what's next? You've got more finals to compete in? I'm going to show my four year old in the non-pro next week and then next thing will be the BI. Some weekend shows in between with the BI will be next. So I take it you're kind of addicted now? I do like it. Yes ma'am. I do enjoy it. Lots of people are really great to be around. Well congratulations and thanks for joining us. Yes ma'am. Thank you.


Hi, everybody. Thanks for coming. Welcome to this month's Mother Vault demo days meeting. For those who are new here, haven't attended in a while. Once every month, the Starfleet and Endress teams and beyond get together to share progress in their projects in the format of a demo. This is also an opportunity for those in the community to share their own projects. First off, we have Jackson with Magna. Hi, everyone. My name is Jackson. I am with Magna. For those who are familiar, we are a token cap table management, as well as on-chain vesting solution. We're working with various projects who are in need of distributing their token, whether that be to employees, investors, advisors. We automate all those vesting schedules on-chain through our custom-built smart contracts. I'll be walking you through today what our platform looks like and how you'd be able to manage it. This view that you're seeing right here is essentially you as the project or whoever the admin is. You'd have this view to see all your different stakeholders, how many tokens that you've allocated to each one, and then you get additional details from our system as well. You can see up here with Karthik, he has over 91,000 tokens that have been unlocked, but he hasn't claimed any. Our system will prompt you that there's a claim available, whether you want to nudge your stakeholder through Telegram or you want to do it through Magna, you can let them know there's tokens available to claim. Whereas someone like Marcy here has claimed all of our tokens, the system will let you know that's up to date. And then we'll also prompt you if there's any missing information like a wallet address. So you could see here, you could easily add a wallet address for your stakeholder or they could log in to add the wallet address themselves. So I just want to give you now a look on what it would be like for your stakeholder logging in. So while this portal is loading, again, whether it's an investor, an employee, advisor, contributor, whoever that stakeholder may be, they want to be able to log in so they can view their token allocation and ultimately claim their tokens that unlock. So when they do log in, they'll get this nice detailed view, which is we include this token timeline. So with the token timeline, you could really track all of your unlock dates, how many tokens are unlocking on each date, and then ultimately how many tokens you've claimed. So it's a nice easy way to stay on top of your unlock schedule, making sure you don't miss any sort of unlock dates to claim your tokens. And the claiming would all happen right here within Magna. So whenever there's a claim available, all your stakeholder has to do is connect their wallet and then they're withdrawing their tokens direct from Magna to their connected wallet. And then one more view I just wanted to show everyone is in here. We'll also write it out for you and your stakeholders. So it's very clear all the specific dates on what you have tokens unlocking and how many tokens in total are unlocking on those dates, the unlock terms, so you could really understand the duration and details around the unlock schedule.  So whether on the project side, you want to upload SAFs or token moorants, or if on the stakeholder side, there's like 83B elections or you know, whatever the investment document may be. It's very easy to have documents live here in Magna. So that way, both you and your stakeholders can make sure whatever agreements you have off chain or corresponding to whatever you see here on chain within Magna. And then, you know, in terms of the projects, it's super easy to invite anyone else in to Magna. So you can control, you know, other users, whether you want to make them just have viewing permissions or full permissions to edit stakeholders. So you have the flexibility there. And then we'll also have a transaction page for you so you could keep up to date with all of your on chain, you know, transactions and executions. So that's a, you know, kind of quick run through if anyone wants to, you know, reach out directly and talk in more detail around Magna. Happy to, happy to chat. Awesome. Thank you so much, Jackson. Up next, we have from the Sentinel team, Bertie. Cool. This is Bertie. I'm an engineer manager at Sentinel team. So our team provides software services and data set for monitoring and analysis of the Filecoin blockchain. So we have been working on an effort to store all the historical blockchain data in BigQuery using our software and the full archival snapshot since Genesis. So in this demo, I will just quickly demonstrate how can we query the data. So the data set in BigQuery is a public data set. So anyone with the URL and a valid Google Cloud account should be able to open that query. But you will be, you will need to pay for the compute since we, we don't want to be responsible for anyone's compute expenses. So once you have access to a data set, you can see it's this one, Lily. Lily. So it has all the tables extracted from our Lily software. So we'll go, we'll, we'll use the most common use one, derived gas output. So this table contains all the gas consumption for every single message that's, that's happened on our blockchain. Okay. So here's the table schema. If you'd like to learn more about table schema, feel free to go to our Lily documentation website. It has a very comprehensive model of documents here. Okay, let's go back here. So here I will try to demonstrate how we want, we can get the base fee and the average base fee and then average total cost per message for every single day since Genesis. So I'm not sure how people familiar familiar with SQL query, but here we try to group the height by, by date. So we divided by 2,880 and then times, times it back. So all the message are happening the same day will be grouped together. And then we, we calculated the average base fee round and the total cost, total cost is calculated by adding base fee minor tips and overestimate appearance. And we divide, and since the unit here is the atone field, so we divided by 10 to 18. And also the work condition here, we only want to filter the successfully accepted messages. So the exit code is zero. Okay, so we can run the query here. Okay, so here's the result. Let's look at the drop information. So you can see that this query scan all the, does a full table scan of the right, the gas output. So it's getting around 60 gig of data. And if you're interested, you can check out the execution graph to see how many rows you scan here. You can see that we scan 1 billion rows from the table. And it does aggregation, basic computation and aggregation, and then generate the results. Okay, so for the result, we can easily visualize the data. We can explore with sheet, connect with the BigQuery result in the Google spreadsheet. Here we can create a chart. That's creating a new new sheet, set line graph, time, and we select both the metrics. Let's sort it by time and see how it renders. But you can see, it's a little bit weird because in the beginning of the network, the fee might not look normal. So let's try to add some filtering here. So we expect the average cost should be, should not be more than one field. So that's filtered anything beyond that. Apply the filter. So here it is. It's a full historical data for the average gas fee. So you can see after the FEVN launch, we do see an uptick train. But keeping in mind that this query is just for demo purpose, you usually want to filter it by the type of message that's applied to the blockchain, instead of doing the average across all messages. Let's look at another example. So we have FEVN specific tables here. You can see the FEVN, active states, block headers, contract, etc. So let's see, let's say we want to know how many FEVN transactions per day since the network upgrade, FEVN launch. So here we do a similar query but just counting the number of rows. And here we filter out the height based on the FEVN launch epoch. So let's run this. Okay, we have the result. Let's check it out in the Google sheet. Again, let's pick our chart, no stacking, transaction sorted by time. Here's all the number of transactions per day. There's some missing dates where I'm still backfilling the data, but it should be complete very, very soon. Cool. I think that some of the demo today from party, feel free to reach out on Slack, feel dash sentinel, or ping me directly on Slack via email. I'll be more than happy to answer your question. Thanks, Bertie. All right. And then last but not least, we have Patrick. So I'm Patrick from the D-Round team. For those of you that aren't familiar with D-Round, we are a network for distributed randomness, which currently does create random numbers for Filecoin leader election and some proofs and a bunch of other stuff. And we're a team inside PL. Last year, we shipped time-op encryption on top of the D-Round network, essentially the ability to encrypt something now that can't be decrypted until some time in the future has come. So with that in mind, we've been building a bunch of different tools and applications on top of that. And today, I will be presenting the V0.0.1 version of Pacelock. Some of you may be familiar with the website Pacepin. Essentially, you upload some bit of text and other people can find it or use it. The Pacelock is kind of the same idea, but for time-lock encrypting data, it's somewhat of a social app, you might say. So here, we've got on the right-hand side, a bunch of things have recently been decrypted and a few things are going to be decrypted soon. I see Eric already uploaded a cypher text, but timed it slightly incorrectly. So it was already decrypted by the time the demo started. But fear not, we will encrypt something else. So the time is 1921 now. Let us encrypt something from 1922. We can add some times like hello, and welcome to the mother of all demo days. We can upload that now. Oh, the demo effect not in session. We can see it's appeared here because it's coming up pretty soon. And in a few moments of time, we'll see it get decrypted. But in the interim, we can also do things like search by tag, everything you might expect. So let's search for E-Round. We can see that was me testing PSLock ahead of the demo day. It worked then, not working out, thank goodness. We can see our cypher text on the right here has automatically been decrypted. And we can see the original cypher text and the plain text that has come out of it. Unfortunately, this isn't quite as beautiful as Magna's web app because this is the V001. So it'll get prettier. If you have any things you want to stash online for people to see, you should use PSLock. Maybe if you were a journalist that has a scoop on something and you're afraid of getting assassinated, stick it on PSLock. And even if you get assassinated, the world will still know what you had. So yeah, I welcome you all to try out, put anything you want up there. This is based on top of our Timelock Encryption Library, T-Lock.js. There's also a goo library and the community have built a whole bunch of different Rust libraries to do it because we have a lot of Rustations within the DRan community. And that was a nice quick demo. That's basically everything. If anyone has any questions, I would be happy to field them now. A great use case indeed, but a use case nonetheless. Cool. Well, with that in mind, you can find the DRan team in the DRan channel on Filecoin Slack. We also have our own DRan Slack workspace, which you can find a link to on the DRan website, which is DRan.love. In case the text was too small, because I've got an ultra-wide Super 4K, all singing, all dancing monitor, the URL for PSLock is PSLock.DRan.love. Thank you very much. You can find it on Slack. Awesome. Thanks so much, Patrick. All right. Well, that concludes our Mother of All Demo days. Thank you so much to all of our presenters. For those interested in demoing the next month, we are scheduled for the 20th of July. So I strongly encourage those who have any projects they want to share progress on or anything that's shipped. We would love to see you there. And I'll be sharing the recording after this once it's up. And thank you again, guys. Have a great day.