PREVIEW / stock_30min / 2005-09-23
file: by_date/stock_30min/2005/2005-09-23.parquet size: 826 KB rows: 44,391 symbols: 2,074
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-09-23 08:00:00 | AAPL | Stock | 1.8571 | 1.8682 | 1.855 | 1.8643 | 484064.0 |
| 2005-09-23 08:30:00 | AAPL | Stock | 1.8575 | 1.8643 | 1.8571 | 1.8643 | 503552.0 |
| 2005-09-23 09:00:00 | AAPL | Stock | 1.8643 | 1.8643 | 1.8536 | 1.8607 | 899780.0 |
| 2005-09-23 09:30:00 | AAPL | Stock | 1.8607 | 1.8689 | 1.8514 | 1.8675 | 56638624.0 |
| 2005-09-23 10:00:00 | AAPL | Stock | 1.8671 | 1.8786 | 1.8636 | 1.8775 | 58930704.0 |
| 2005-09-23 10:30:00 | AAPL | Stock | 1.8775 | 1.8779 | 1.8679 | 1.875 | 28928452.0 |
| 2005-09-23 11:00:00 | AAPL | Stock | 1.875 | 1.8907 | 1.8736 | 1.8871 | 53874352.0 |
| 2005-09-23 11:30:00 | AAPL | Stock | 1.8871 | 1.9014 | 1.8854 | 1.8993 | 46575900.0 |
| 2005-09-23 12:00:00 | AAPL | Stock | 1.8993 | 1.9039 | 1.8911 | 1.8911 | 41808480.0 |
| 2005-09-23 12:30:00 | AAPL | Stock | 1.8911 | 1.8918 | 1.8825 | 1.89 | 23822372.0 |
| 2005-09-23 13:00:00 | AAPL | Stock | 1.89 | 1.8979 | 1.8896 | 1.8954 | 27754804.0 |
| 2005-09-23 13:30:00 | AAPL | Stock | 1.8954 | 1.9086 | 1.8918 | 1.9054 | 40428780.0 |
| 2005-09-23 14:00:00 | AAPL | Stock | 1.9054 | 1.9064 | 1.8982 | 1.9036 | 33815012.0 |
| 2005-09-23 14:30:00 | AAPL | Stock | 1.9036 | 1.9107 | 1.9025 | 1.9089 | 27978216.0 |
| 2005-09-23 15:00:00 | AAPL | Stock | 1.9089 | 1.91 | 1.9029 | 1.9075 | 49056420.0 |
| 2005-09-23 15:30:00 | AAPL | Stock | 1.9075 | 1.9089 | 1.8975 | 1.9004 | 57851332.0 |
| 2005-09-23 16:00:00 | AAPL | Stock | 1.9014 | 1.9046 | 1.9 | 1.9018 | 620816.0 |
| 2005-09-23 16:30:00 | AAPL | Stock | 1.905 | 1.905 | 1.9 | 1.9011 | 403648.0 |
| 2005-09-23 17:00:00 | AAPL | Stock | 1.9 | 1.9032 | 1.9 | 1.9032 | 245448.0 |
| 2005-09-23 17:30:00 | AAPL | Stock | 1.9032 | 1.9032 | 1.8982 | 1.9011 | 118356.0 |
| 2005-09-23 18:00:00 | AAPL | Stock | 1.9032 | 1.9032 | 1.9004 | 1.9004 | 46256.0 |
| 2005-09-23 08:00:00 | MSFT | Stock | 25.3 | 25.3 | 25.24 | 25.3 | 27200.0 |
| 2005-09-23 08:30:00 | MSFT | Stock | 25.26 | 25.3 | 25.25 | 25.27 | 8998.0 |
| 2005-09-23 09:00:00 | MSFT | Stock | 25.29 | 25.55 | 25.26 | 25.28 | 172936.0 |
| 2005-09-23 09:30:00 | MSFT | Stock | 25.31 | 25.5 | 25.249 | 25.43 | 6979117.0 |
| 2005-09-23 10:00:00 | MSFT | Stock | 25.43 | 25.54 | 25.35 | 25.4 | 5971755.0 |
| 2005-09-23 10:30:00 | MSFT | Stock | 25.4 | 25.41 | 25.3 | 25.35 | 4143037.0 |
| 2005-09-23 11:00:00 | MSFT | Stock | 25.36 | 25.43 | 25.33 | 25.37 | 4323639.0 |
| 2005-09-23 11:30:00 | MSFT | Stock | 25.37 | 25.4 | 25.35 | 25.38 | 3002446.0 |
| 2005-09-23 12:00:00 | MSFT | Stock | 25.371 | 25.4 | 25.24 | 25.25 | 2630100.0 |
| 2005-09-23 12:30:00 | MSFT | Stock | 25.25 | 25.29 | 25.23 | 25.24 | 2087194.0 |
| 2005-09-23 13:00:00 | MSFT | Stock | 25.24 | 25.4 | 25.23 | 25.23 | 2617269.0 |
| 2005-09-23 13:30:00 | MSFT | Stock | 25.24 | 25.4 | 25.22 | 25.28 | 7795589.0 |
| 2005-09-23 14:00:00 | MSFT | Stock | 25.29 | 25.291 | 25.18 | 25.2 | 5181102.0 |
| 2005-09-23 14:30:00 | MSFT | Stock | 25.19 | 25.23 | 25.16 | 25.2 | 3960796.0 |
| 2005-09-23 15:00:00 | MSFT | Stock | 25.2 | 25.2 | 25.12 | 25.17 | 6093894.0 |
| 2005-09-23 15:30:00 | MSFT | Stock | 25.18 | 25.32 | 25.13 | 25.28 | 9341774.0 |
| 2005-09-23 16:00:00 | MSFT | Stock | 25.28 | 25.3 | 25.25 | 25.28 | 183474.0 |
| 2005-09-23 16:30:00 | MSFT | Stock | 25.3 | 25.35 | 25.27 | 25.31 | 151173.0 |
| 2005-09-23 17:00:00 | MSFT | Stock | 25.27 | 25.36 | 25.27 | 25.36 | 122418.0 |
| 2005-09-23 17:30:00 | MSFT | Stock | 25.31 | 25.32 | 25.27 | 25.27 | 1100.0 |
| 2005-09-23 18:00:00 | MSFT | Stock | 25.3 | 25.31 | 25.27 | 25.31 | 800.0 |
| 2005-09-23 09:00:00 | NVDA | Stock | 0.2684 | 0.2687 | 0.2682 | 0.2686 | 48000.0 |
| 2005-09-23 09:30:00 | NVDA | Stock | 0.2681 | 0.2699 | 0.2658 | 0.2667 | 39872160.0 |
| 2005-09-23 10:00:00 | NVDA | Stock | 0.2667 | 0.2696 | 0.2665 | 0.2696 | 41850960.0 |
| 2005-09-23 10:30:00 | NVDA | Stock | 0.2695 | 0.2706 | 0.2689 | 0.2703 | 28081920.0 |
| 2005-09-23 11:00:00 | NVDA | Stock | 0.2706 | 0.2709 | 0.269 | 0.2701 | 27285240.0 |
| 2005-09-23 11:30:00 | NVDA | Stock | 0.2701 | 0.2711 | 0.27 | 0.2709 | 13907400.0 |
| 2005-09-23 12:00:00 | NVDA | Stock | 0.2708 | 0.271 | 0.2703 | 0.2708 | 5276160.0 |
| 2005-09-23 12:30:00 | NVDA | Stock | 0.2708 | 0.2717 | 0.2707 | 0.2716 | 8769840.0 |
> showing 50 of 44,391 rows — these rows as CSV