PREVIEW / stock_30min / 2007-07-10
file: by_date/stock_30min/2007/2007-07-10.parquet size: 1.1 MB rows: 64,525 symbols: 3,066
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2007-07-10 09:30:00 | AAPL | Stock | 4.6029 | 4.7429 | 4.6004 | 4.7336 | 264353376.0 |
| 2007-07-10 10:00:00 | AAPL | Stock | 4.7332 | 4.8036 | 4.7286 | 4.7707 | 255741500.0 |
| 2007-07-10 10:30:00 | AAPL | Stock | 4.7721 | 4.7893 | 4.7596 | 4.7779 | 94554068.0 |
| 2007-07-10 11:00:00 | AAPL | Stock | 4.7779 | 4.7868 | 4.7671 | 4.7771 | 62011768.0 |
| 2007-07-10 11:30:00 | AAPL | Stock | 4.7771 | 4.7843 | 4.7679 | 4.7732 | 46803652.0 |
| 2007-07-10 12:00:00 | AAPL | Stock | 4.7736 | 4.7764 | 4.7511 | 4.7546 | 48781768.0 |
| 2007-07-10 12:30:00 | AAPL | Stock | 4.7549 | 4.7661 | 4.7023 | 4.7589 | 33992336.0 |
| 2007-07-10 13:00:00 | AAPL | Stock | 4.7593 | 4.7646 | 4.7289 | 4.7386 | 77393540.0 |
| 2007-07-10 13:30:00 | AAPL | Stock | 4.7386 | 4.7486 | 4.7061 | 4.7204 | 79879940.0 |
| 2007-07-10 14:00:00 | AAPL | Stock | 4.7207 | 4.7346 | 4.7107 | 4.7296 | 53017776.0 |
| 2007-07-10 14:30:00 | AAPL | Stock | 4.7296 | 4.7536 | 4.7257 | 4.7336 | 58466744.0 |
| 2007-07-10 15:00:00 | AAPL | Stock | 4.7339 | 4.7354 | 4.7171 | 4.735 | 55776224.0 |
| 2007-07-10 15:30:00 | AAPL | Stock | 4.735 | 4.7354 | 4.7182 | 4.7293 | 70620116.0 |
| 2007-07-10 16:00:00 | AAPL | Stock | 4.7283 | 4.7293 | 4.7268 | 4.7268 | 12811344.0 |
| 2007-07-10 09:30:00 | MSFT | Stock | 29.7 | 29.92 | 29.69 | 29.89 | 3874507.0 |
| 2007-07-10 10:00:00 | MSFT | Stock | 29.89 | 29.99 | 29.86 | 29.892 | 3011688.0 |
| 2007-07-10 10:30:00 | MSFT | Stock | 29.89 | 29.9 | 29.83 | 29.86 | 2979173.0 |
| 2007-07-10 11:00:00 | MSFT | Stock | 29.86 | 29.95 | 29.86 | 29.88 | 2787850.0 |
| 2007-07-10 11:30:00 | MSFT | Stock | 29.87 | 29.89 | 29.8 | 29.825 | 2619706.0 |
| 2007-07-10 12:00:00 | MSFT | Stock | 29.821 | 29.88 | 29.786 | 29.83 | 2418498.0 |
| 2007-07-10 12:30:00 | MSFT | Stock | 29.83 | 29.85 | 29.81 | 29.82 | 1109812.0 |
| 2007-07-10 13:00:00 | MSFT | Stock | 29.825 | 29.84 | 29.76 | 29.77 | 4057830.0 |
| 2007-07-10 13:30:00 | MSFT | Stock | 29.77 | 29.78 | 29.5 | 29.53 | 6355704.0 |
| 2007-07-10 14:00:00 | MSFT | Stock | 29.53 | 29.61 | 29.5 | 29.56 | 4089385.0 |
| 2007-07-10 14:30:00 | MSFT | Stock | 29.56 | 29.57 | 29.35 | 29.42 | 7131580.0 |
| 2007-07-10 15:00:00 | MSFT | Stock | 29.43 | 29.43 | 29.18 | 29.28 | 9572035.0 |
| 2007-07-10 15:30:00 | MSFT | Stock | 29.278 | 29.42 | 29.21 | 29.37 | 10491730.0 |
| 2007-07-10 16:00:00 | MSFT | Stock | 29.37 | 29.37 | 29.33 | 29.33 | 1561563.0 |
| 2007-07-10 09:00:00 | NVDA | Stock | 0.7482 | 0.7488 | 0.7473 | 0.7475 | 334140.0 |
| 2007-07-10 09:30:00 | NVDA | Stock | 0.7483 | 0.7517 | 0.7388 | 0.7508 | 81387180.0 |
| 2007-07-10 10:00:00 | NVDA | Stock | 0.7508 | 0.7588 | 0.7495 | 0.7558 | 78446820.0 |
| 2007-07-10 10:30:00 | NVDA | Stock | 0.7558 | 0.761 | 0.7557 | 0.7598 | 54554040.0 |
| 2007-07-10 11:00:00 | NVDA | Stock | 0.7598 | 0.7625 | 0.7582 | 0.7583 | 38024220.0 |
| 2007-07-10 11:30:00 | NVDA | Stock | 0.7582 | 0.7607 | 0.758 | 0.7597 | 21693120.0 |
| 2007-07-10 12:00:00 | NVDA | Stock | 0.7597 | 0.76 | 0.7517 | 0.758 | 27801120.0 |
| 2007-07-10 12:30:00 | NVDA | Stock | 0.758 | 0.7588 | 0.7568 | 0.7587 | 18995280.0 |
| 2007-07-10 13:00:00 | NVDA | Stock | 0.7587 | 0.7595 | 0.7557 | 0.7562 | 25502760.0 |
| 2007-07-10 13:30:00 | NVDA | Stock | 0.7562 | 0.7575 | 0.752 | 0.7532 | 31958640.0 |
| 2007-07-10 14:00:00 | NVDA | Stock | 0.753 | 0.757 | 0.7515 | 0.7552 | 22156620.0 |
| 2007-07-10 14:30:00 | NVDA | Stock | 0.755 | 0.7563 | 0.7538 | 0.7553 | 23937060.0 |
| 2007-07-10 15:00:00 | NVDA | Stock | 0.7553 | 0.7595 | 0.754 | 0.757 | 45737280.0 |
| 2007-07-10 15:30:00 | NVDA | Stock | 0.7568 | 0.7583 | 0.754 | 0.7582 | 57372060.0 |
| 2007-07-10 16:00:00 | NVDA | Stock | 0.758 | 0.7583 | 0.7549 | 0.7583 | 2584020.0 |
| 2007-07-10 16:30:00 | NVDA | Stock | 0.7583 | 0.7583 | 0.7583 | 0.7583 | 77580.0 |
| 2007-07-10 17:00:00 | NVDA | Stock | 0.7583 | 0.7583 | 0.7575 | 0.7575 | 69120.0 |
| 2007-07-10 17:30:00 | NVDA | Stock | 0.7575 | 0.7575 | 0.7575 | 0.7575 | 15000.0 |
| 2007-07-10 18:00:00 | NVDA | Stock | 0.7592 | 0.7592 | 0.7583 | 0.7583 | 60000.0 |
| 2007-07-10 18:30:00 | NVDA | Stock | 0.7583 | 0.7583 | 0.7583 | 0.7583 | 83100.0 |
| 2007-07-10 19:30:00 | NVDA | Stock | 0.7582 | 0.7582 | 0.7582 | 0.7582 | 12000.0 |
| 2007-07-10 07:00:00 | AMZN | Stock | 3.5805 | 3.5805 | 3.58 | 3.58 | 6500.0 |
> showing 50 of 64,525 rows — these rows as CSV