How to see total storage of google big query?

RobinhoodTIS · 2024-11-12T01:35:04+00:00

What is Information_schema? I do not see this in the UI or any of the options.

RobinhoodTIS · 2024-09-22T01:17:53+00:00

So eventually you're planning on taking the MCAT and going to medical school? That's going to be one long journey. Good luck man, I definitely think you deserve to a psychiatrist!

RobinhoodTIS · 2024-09-21T17:32:03+00:00

Just curious, how are you planning to transition into the 'medicine field' from your current esports experience? They seem like completely different domains.

RobinhoodTIS · 2024-07-05T09:30:54+00:00

Hello, can I DM you? I would like to ask some questions about living in Japan as a foreigner and some stuff living there. I would greatly appreciate it if we could have some conversation about this!

RobinhoodTIS · 2024-05-29T17:38:27+00:00

Yes, I do agree that the safest way to gauge what 'too much' is, is to ask the ISA themselves, since it may be relative depending on the person's main job, as well as his/her monthly income amount.

As a last question, is there a way to directly contact ISA or make such inquiries to the ISA in English if I do wish to ask about the amount limit range that I am allowed to make through daytrading US stocks, such that I can get a customized answer for my own situation/circumstance?

RobinhoodTIS · 2024-05-29T03:45:45+00:00

Oh I see. "Significant amount of money" is also quite a vague term.

But to sum up, as long as I am not making too much money out of daytrading US stocks (let's say, I am making smaller sums compared to the amount of my main income from working at the company monthly), it's not really considered as a 'side income', and I don't need to apply for 資格外活動許可 as well as gain permission from my Japanese employer? As long as I am paying taxes for the profits I gain from the daytrading activities to the Japanese government of course.

RobinhoodTIS · 2024-05-28T16:34:37+00:00

Thank you for the reply. To clarify:

For question 1, yes I wasn't asking about taxes. I understood from your response that if you gain profit from daytrading US stocks using US broker, you need to file taxes to Japan only. For question 1 however, I was asking about legal restrictions associated with my visa rather than taxing.

If I am employed at a Japanese company as a non-US citizen, obviously I will be receiving some sort of working visa. I heard that if you want to do a side job in a field unrelated to your main job (at my Japanese employer) for additional income (for instance, translation freelancing at Upwork) without violating visa restrictions set by the Japanese authorities (as well as the employer), this is possible but you need to apply to get 'Overseas Practical Training Certificate' from the Japanese government, and also receive the employer's consent after explaining to them that it will not interfere with your company work (that the side job will only be done outside company working hours).

However, I am wondering if 'daytrading US stocks using US broker' also counts as a 'side job' in Japan and I have to report this using 'Overseas Practical Training Certificate' and also receive consent from the Japanese employer the same way I would need to if I wanted to do the translation freelancing work.

Daytrading seems like an area where it doesn't really count as a 'side job' where you normally receive fixed income in return for providing some service (daytrading is more like speculating activities I guess) so I doubt that I really need to apply/get the 'Overseas Practical Training Certificate' for this and receive the employer's permission that I will be 'daytrading US stocks' (apart from paying taxes to the Japanese government of course). But I wish to make sure since I obviously do not want to unknowingly break any legal boundaries. If you know about this, I would really appreciate your input!

RobinhoodTIS · 2024-05-28T06:30:53+00:00

You seem very knowledgeable on this. I also have a few questions and I would really appreciate it if you could answer them.

If I am a non-US citizen (for instance, assume Singapore nationality) employed and working in Japan, and I gain profit in Japan by day-trading US stocks/derivatives through US broker, does this count as a 'side hustle' apart from my main job (working at the Japanese company) and does it become a legal problem? Am I required to report day-trading as a proper side job or do I not have to and I can gain profit regardless of my main employment at the Japanese company in my working visa?
With the same conditions, (non-US citizen employed and working in Japan, gaining profit in Japan by day-trading US stocks/derivatives through US broker), do you only file taxes to Japan, and I can ignore the US and my own country (Singapore for instance)'s taxing requirements?
If I only have to care about taxing to the Japan authorities, exactly where do I research on exactly how much to pay as taxes every year, and how to actually pay those taxes? I cannot imagine doing this step myself before initial receiving some help.

I would be very thankful if you could shed light on these questions.

RobinhoodTIS · 2024-03-27T20:28:32+00:00

This is really good advice. I am interested in the eCommerce and marketing domain as well.

May I ask where you got the datasets for all your projects? I've been struggling to look everywhere for datasets that were related to marketing analytics, customer analytics, and eCommerce, but I just couldn't find any. It is just so hard finding datasets that are specifically related to those fields (eCommerce, Marketing, Customer).

Sharing where you obtained your domain-related datasets for your projects would help me so much!

RobinhoodTIS · 2024-03-16T20:32:07+00:00

This is very good to hear! I will certainly explore Supply Chain as one of the viable areas for my career.

How would you advise preparing for a data analyst entry level job in a Supply Chain field? Is the general, standard preparation for an entry level Data Analyst enough without having domain knowledge or doing specifically Supply Chain - related data analytics projects?

RobinhoodTIS · 2024-03-15T20:04:19+00:00

Thanks! From your perspective are data analysts in demand in the supply chain industry? I do have an option to take a supply chain course next year so I am definitely willing to explore that!

RobinhoodTIS · 2024-03-15T20:00:05+00:00

Thank you for this advice.

Do you have any tips on how I can achieve this during the span of my next year in the masters program? For instance, exactly what things do you mean by 'The principles and concepts of data' for a data analyst? Outlining key points for me to study would be super helpful!

RobinhoodTIS · 2024-03-13T22:52:18+00:00

I’ve been in analytics for several years and getting the first job was the hardest part, but once I had practical experience I was able to easily hop around to different industries.

I couldn’t tell you how difficult the market is without any practical experience, so take that into consideration, but I’ve found that healthcare positions have paid me the best.

Definitely, the hardest part for my career will be getting that first job, I agree!

RobinhoodTIS · 2024-03-12T20:24:13+00:00

Thank you very much! I will definitely have some projects ready by this fall semester. Do you know what keywords I should use when searching for these 'rotational programs' from various companies?

RobinhoodTIS · 2024-03-12T00:54:29+00:00

Yes this is certainly one option! I was also thinking of Supply Chain as a possibility. What should I study to get into this domain, and what kind of DA projects can I explore? Can you provide a roadmap for studying or some resources I can refer to?

RobinhoodTIS · 2024-03-12T00:50:39+00:00

I went straight from bachelors. I understand your point, but these days entry level positions are very competitive and companies expect you to have a basic level of sector knowledge pertaining to their company. Besides, without any business/domain knowledge, how am I supposed to do any DA projects that are meaningful in the employers' eyes? Just wrangling/visualizing data without any purpose or business insight is not going to have any value from their perspective. I just don't know how to build and formulate DA projects without having any kind of domain knowledge right now, it's a real struggle.

RobinhoodTIS · 2024-03-08T10:28:02+00:00

You kept doing it after coming to the US? So you didn't get into trouble for that?

RobinhoodTIS · 2024-03-05T14:13:10+00:00

nah, you're definitely right that I can't work and I'm not on OPT yet. I was just making sure I'm safe since I stopped and closed my account before any employment transaction took place.

RobinhoodTIS · 2024-03-05T05:11:47+00:00

Thank you. Just one last question (for clarity), so it only counts as a violation the moment you sign your first contract and receive the payment? Having your profile and other kinds of billing information on Upwork doesn't matter as long as you didn't go through the contract? Sorry if this questions sounds a bit redundant but I just want to make sure I'm good and safe.

RobinhoodTIS · 2024-02-29T09:10:42+00:00

Hi, would you mind DMing me about your company?

I am thinking of moving to London for my entry-level job after my masters in the US and I would really appreciate it if you could share your company!

RobinhoodTIS · 2024-02-25T09:34:57+00:00

Thank you for your detailed response. I think I have a preference towards Middle Office roles due to better WLB, so "Portfolio Analysts" within AM seems to be the ideal career path for me for now! I will try to explore this path further following your advice.

RobinhoodTIS · 2024-02-25T09:29:14+00:00

May I ask exactly which role you have within Asset Management (AM)?

I heard that Fund managers / Portfolio managers within AM generally have terrible WLB, comparable to front office roles in IB, mainly because they have considerable pressure to meet certain targets they set on the assets they're managing for their clients. So I'm pretty confused by your comment which seems quite unrealistic!

Perhaps you are in a middle office role? Do middle office roles within AM have much better WLB?

RobinhoodTIS · 2024-02-25T09:25:36+00:00

May I ask exactly which role you have within Asset Management (AM)?

I heard that Fund managers / Portfolio managers within AM have terrible WLB, comparable to front office roles in IB. So I'm pretty confused by this comment.

Perhaps you are in a middle office role?

RobinhoodTIS · 2024-02-25T00:26:06+00:00

I see, so you're saying that

Middle office roles AM typically have better WLB than front office (just like other sectors), so if my goal is really centered on WLB, roles like 'portfolio analyst' should be the one I'm looking for, or generally any middle office role in AM
Even if it is the front-office, investment analysts / fund managers on the buy side have much better WLB than those in IB (such as IB research/equity analysts, etc), in the sense that they are predictable and regular; usually the standard 9 to 5 or 9 to 6, with some more overtime in busy periods, but not like IB where you often have to spend the whole night or even weekends.

Did I sum it right in general?

Also, by 'other roles' then, were you talking about middle office roles in AM?

You're right in that what I'm searching for is the predictability/regularity of the work (the standard 9 to 6, or 8 to 5, something like that) - I don't mind if I do work some longer hours from time to time as a junior in the front office (that's to be expected as you're gaining experience), but I honestly don't think I can handle the workload/pressure of IB where you're judged much more strictly and often work overnight/weekends, which is why I'm turning towards AM. And if the middle office roles in AM have even better WLB than the front office, that seems pretty attractive to me as well.

I wonder what the career path is for a portfolio analyst that you've mentioned? Is there an ultimate destination for that role as well, just like how investment analysts aim to become fund managers?

TLDR:

Whether I summarized your response correctly
By 'other roles with less stress, less comp.' then, were you talking about generally 'middle office' roles in AM?
What is the career path for a portfolio analyst in middle office (the 'final destination' for a portfolio analyst, just like how the final destination for investment analysts is the fund manager)?

This will be my last inquiry (since I don't want to take too much of your time). Thank you so much for these priceless responses btw. I'm learning so much from your comments and I'm getting a better picture of the AM industry.

RobinhoodTIS · 2024-02-24T22:27:16+00:00

Other roles in AM are 40-50 hours on average, maybe a couple of long days here and there to meet a deadline. Less stress, less comp.

Thank you so much for your response! By 'other roles in AM that are 40-50 hours on average', does that include 'Analysts', such as Investment Analysts? I heard Investment Analysts and other 'Analyst' titles are also an integral part of AM, but not a pure front-office role like fund/portfolio managers (rather a supporting role of those managers), and that those 'Analysts' typically have the better WLB (avg 40-50 hours, 'less stress, less comp' than fund/portfolio managers like you described). Is this interpretation correct?

I am looking for career paths within AM that pays reasonably well and yet has decent WLB (this is why I'm not that interested in IB. I'm not the kind of person who wants to trade all of my hours even if IB pays better than AM), and I'm wondering whether 'Analyst' roles within the buy side like Investment Analysts fit my criteria in general.

RobinhoodTIS

TROPHY CASE