PREVIEW / stock_30min / 2005-08-31
file: by_date/stock_30min/2005/2005-08-31.parquet size: 870 KB rows: 46,131 symbols: 2,073
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-31 08:00:00 | AAPL | Stock | 1.6632 | 1.6743 | 1.6632 | 1.6696 | 189392.0 |
| 2005-08-31 08:30:00 | AAPL | Stock | 1.67 | 1.67 | 1.6646 | 1.665 | 359800.0 |
| 2005-08-31 09:00:00 | AAPL | Stock | 1.6679 | 1.6718 | 1.665 | 1.6696 | 730296.0 |
| 2005-08-31 09:30:00 | AAPL | Stock | 1.6736 | 1.6771 | 1.6586 | 1.6632 | 67531212.0 |
| 2005-08-31 10:00:00 | AAPL | Stock | 1.6632 | 1.6725 | 1.6525 | 1.6614 | 52742788.0 |
| 2005-08-31 10:30:00 | AAPL | Stock | 1.6614 | 1.67 | 1.6571 | 1.6639 | 32426912.0 |
| 2005-08-31 11:00:00 | AAPL | Stock | 1.6639 | 1.6696 | 1.6614 | 1.6668 | 30301516.0 |
| 2005-08-31 11:30:00 | AAPL | Stock | 1.6671 | 1.6704 | 1.665 | 1.6654 | 13988940.0 |
| 2005-08-31 12:00:00 | AAPL | Stock | 1.665 | 1.667 | 1.6611 | 1.6639 | 16946104.0 |
| 2005-08-31 12:30:00 | AAPL | Stock | 1.6639 | 1.6639 | 1.6571 | 1.6575 | 19221076.0 |
| 2005-08-31 13:00:00 | AAPL | Stock | 1.6575 | 1.6636 | 1.6564 | 1.6604 | 17894576.0 |
| 2005-08-31 13:30:00 | AAPL | Stock | 1.6604 | 1.6671 | 1.6586 | 1.665 | 17133060.0 |
| 2005-08-31 14:00:00 | AAPL | Stock | 1.6654 | 1.6654 | 1.6593 | 1.6621 | 16985668.0 |
| 2005-08-31 14:30:00 | AAPL | Stock | 1.6621 | 1.6675 | 1.6618 | 1.6668 | 15534232.0 |
| 2005-08-31 15:00:00 | AAPL | Stock | 1.6668 | 1.6732 | 1.6643 | 1.6721 | 22984696.0 |
| 2005-08-31 15:30:00 | AAPL | Stock | 1.6721 | 1.6796 | 1.6714 | 1.6757 | 44289952.0 |
| 2005-08-31 16:00:00 | AAPL | Stock | 1.675 | 1.6761 | 1.6661 | 1.675 | 10640728.0 |
| 2005-08-31 16:30:00 | AAPL | Stock | 1.6732 | 1.6732 | 1.6689 | 1.6696 | 58800.0 |
| 2005-08-31 17:30:00 | AAPL | Stock | 1.6761 | 1.6761 | 1.6721 | 1.6721 | 30548.0 |
| 2005-08-31 18:00:00 | AAPL | Stock | 1.6732 | 1.6746 | 1.6732 | 1.6746 | 38640.0 |
| 2005-08-31 07:00:00 | MSFT | Stock | 27.18 | 27.18 | 27.18 | 27.18 | 150.0 |
| 2005-08-31 07:30:00 | MSFT | Stock | 27.18 | 27.18 | 27.18 | 27.18 | 1850.0 |
| 2005-08-31 08:00:00 | MSFT | Stock | 27.17 | 27.24 | 27.17 | 27.24 | 19025.0 |
| 2005-08-31 08:30:00 | MSFT | Stock | 27.25 | 27.25 | 27.17 | 27.18 | 19459.0 |
| 2005-08-31 09:00:00 | MSFT | Stock | 27.18 | 27.23 | 27.17 | 27.18 | 40650.0 |
| 2005-08-31 09:30:00 | MSFT | Stock | 27.17 | 27.24 | 27.11 | 27.12 | 3948583.0 |
| 2005-08-31 10:00:00 | MSFT | Stock | 27.12 | 27.2 | 27.06 | 27.1 | 6867124.0 |
| 2005-08-31 10:30:00 | MSFT | Stock | 27.1 | 27.16 | 27.04 | 27.06 | 4573958.0 |
| 2005-08-31 11:00:00 | MSFT | Stock | 27.06 | 27.17 | 27.05 | 27.12 | 3007461.0 |
| 2005-08-31 11:30:00 | MSFT | Stock | 27.13 | 27.16 | 27.09 | 27.11 | 2642328.0 |
| 2005-08-31 12:00:00 | MSFT | Stock | 27.12 | 27.22 | 27.11 | 27.15 | 3356637.0 |
| 2005-08-31 12:30:00 | MSFT | Stock | 27.15 | 27.17 | 27.14 | 27.15 | 2045542.0 |
| 2005-08-31 13:00:00 | MSFT | Stock | 27.15 | 27.25 | 27.1 | 27.25 | 5317642.0 |
| 2005-08-31 13:30:00 | MSFT | Stock | 27.25 | 27.33 | 27.24 | 27.26 | 5095313.0 |
| 2005-08-31 14:00:00 | MSFT | Stock | 27.26 | 27.29 | 27.179 | 27.27 | 5220410.0 |
| 2005-08-31 14:30:00 | MSFT | Stock | 27.26 | 27.33 | 27.24 | 27.28 | 3330661.0 |
| 2005-08-31 15:00:00 | MSFT | Stock | 27.28 | 27.4 | 27.26 | 27.39 | 6197377.0 |
| 2005-08-31 15:30:00 | MSFT | Stock | 27.39 | 27.44 | 27.34 | 27.38 | 9135524.0 |
| 2005-08-31 16:00:00 | MSFT | Stock | 27.39 | 27.41 | 27.29 | 27.38 | 1635837.0 |
| 2005-08-31 16:30:00 | MSFT | Stock | 27.37 | 27.38 | 27.37 | 27.37 | 4600.0 |
| 2005-08-31 17:00:00 | MSFT | Stock | 27.37 | 27.4 | 27.36 | 27.4 | 15782.0 |
| 2005-08-31 17:30:00 | MSFT | Stock | 27.37 | 27.4 | 27.37 | 27.39 | 1191.0 |
| 2005-08-31 18:00:00 | MSFT | Stock | 27.37 | 27.37 | 27.37 | 27.37 | 750.0 |
| 2005-08-31 08:30:00 | NVDA | Stock | 0.2508 | 0.2518 | 0.2508 | 0.2518 | 2868000.0 |
| 2005-08-31 09:00:00 | NVDA | Stock | 0.2514 | 0.2516 | 0.2488 | 0.2495 | 1920000.0 |
| 2005-08-31 09:30:00 | NVDA | Stock | 0.2495 | 0.2539 | 0.2487 | 0.2523 | 82952640.0 |
| 2005-08-31 10:00:00 | NVDA | Stock | 0.2523 | 0.2548 | 0.2517 | 0.2547 | 113936520.0 |
| 2005-08-31 10:30:00 | NVDA | Stock | 0.2547 | 0.2568 | 0.2546 | 0.2562 | 134077560.0 |
| 2005-08-31 11:00:00 | NVDA | Stock | 0.2562 | 0.2588 | 0.2562 | 0.258 | 104875320.0 |
| 2005-08-31 11:30:00 | NVDA | Stock | 0.2582 | 0.2586 | 0.2568 | 0.2572 | 65021760.0 |
> showing 50 of 46,131 rows — these rows as CSV