PREVIEW / stock_30min / 2008-08-01
file: by_date/stock_30min/2008/2008-08-01.parquet size: 1.2 MB rows: 67,939 symbols: 3,300
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-01 06:30:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6786 | 5.6786 | 5600.0 |
| 2008-08-01 08:00:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6632 | 5.6718 | 981232.0 |
| 2008-08-01 08:30:00 | AAPL | Stock | 5.6779 | 5.7421 | 5.6768 | 5.7086 | 4087636.0 |
| 2008-08-01 09:00:00 | AAPL | Stock | 5.7104 | 5.7246 | 5.71 | 5.7107 | 633976.0 |
| 2008-08-01 09:30:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.5625 | 5.6011 | 95582900.0 |
| 2008-08-01 10:00:00 | AAPL | Stock | 5.6011 | 5.6243 | 5.5682 | 5.5921 | 63543592.0 |
| 2008-08-01 10:30:00 | AAPL | Stock | 5.5929 | 5.6336 | 5.5896 | 5.6054 | 40240452.0 |
| 2008-08-01 11:00:00 | AAPL | Stock | 5.6054 | 5.6237 | 5.5729 | 5.6104 | 32752580.0 |
| 2008-08-01 11:30:00 | AAPL | Stock | 5.6104 | 5.6482 | 5.61 | 5.6414 | 34248844.0 |
| 2008-08-01 12:00:00 | AAPL | Stock | 5.6393 | 5.6421 | 5.5993 | 5.6064 | 23847180.0 |
| 2008-08-01 12:30:00 | AAPL | Stock | 5.6061 | 5.6143 | 5.5725 | 5.5879 | 28059724.0 |
| 2008-08-01 13:00:00 | AAPL | Stock | 5.5871 | 5.6336 | 5.5829 | 5.6196 | 24850196.0 |
| 2008-08-01 13:30:00 | AAPL | Stock | 5.62 | 5.6289 | 5.5971 | 5.6093 | 24398108.0 |
| 2008-08-01 14:00:00 | AAPL | Stock | 5.6089 | 5.6161 | 5.5757 | 5.5957 | 26118624.0 |
| 2008-08-01 14:30:00 | AAPL | Stock | 5.5954 | 5.6221 | 5.5786 | 5.6139 | 31257016.0 |
| 2008-08-01 15:00:00 | AAPL | Stock | 5.6143 | 5.6268 | 5.6032 | 5.6107 | 28963956.0 |
| 2008-08-01 15:30:00 | AAPL | Stock | 5.6111 | 5.6339 | 5.5825 | 5.595 | 50206968.0 |
| 2008-08-01 16:00:00 | AAPL | Stock | 5.595 | 5.6768 | 5.5896 | 5.5993 | 6513836.0 |
| 2008-08-01 16:30:00 | AAPL | Stock | 5.6057 | 5.6109 | 5.595 | 5.6011 | 1636432.0 |
| 2008-08-01 17:00:00 | AAPL | Stock | 5.6061 | 5.6068 | 5.6029 | 5.6064 | 69580.0 |
| 2008-08-01 17:30:00 | AAPL | Stock | 5.6068 | 5.6111 | 5.595 | 5.6043 | 21688436.0 |
| 2008-08-01 18:00:00 | AAPL | Stock | 5.6025 | 5.6025 | 5.6025 | 5.6025 | 11200.0 |
| 2008-08-01 18:30:00 | AAPL | Stock | 5.6036 | 5.6036 | 5.6036 | 5.6036 | 4900.0 |
| 2008-08-01 19:00:00 | AAPL | Stock | 5.6032 | 5.6032 | 5.5821 | 5.5893 | 161672.0 |
| 2008-08-01 19:30:00 | AAPL | Stock | 5.5996 | 5.5996 | 5.5982 | 5.5982 | 9184.0 |
| 2008-08-01 07:30:00 | MSFT | Stock | 25.85 | 25.85 | 25.85 | 25.85 | 500.0 |
| 2008-08-01 08:00:00 | MSFT | Stock | 25.86 | 25.95 | 25.82 | 25.95 | 5080.0 |
| 2008-08-01 08:30:00 | MSFT | Stock | 25.9 | 25.94 | 25.9 | 25.9 | 1600.0 |
| 2008-08-01 09:00:00 | MSFT | Stock | 25.9 | 26.0 | 25.89 | 25.92 | 21350.0 |
| 2008-08-01 09:30:00 | MSFT | Stock | 25.92 | 25.95 | 25.07 | 25.24 | 10262419.0 |
| 2008-08-01 10:00:00 | MSFT | Stock | 25.24 | 25.37 | 25.18 | 25.25 | 11950815.0 |
| 2008-08-01 10:30:00 | MSFT | Stock | 25.259 | 25.34 | 25.2 | 25.25 | 6724278.0 |
| 2008-08-01 11:00:00 | MSFT | Stock | 25.25 | 25.27 | 25.18 | 25.2 | 5020815.0 |
| 2008-08-01 11:30:00 | MSFT | Stock | 25.21 | 25.27 | 25.2 | 25.24 | 4277195.0 |
| 2008-08-01 12:00:00 | MSFT | Stock | 25.248 | 25.25 | 25.19 | 25.22 | 4016111.0 |
| 2008-08-01 12:30:00 | MSFT | Stock | 25.23 | 25.27 | 25.19 | 25.25 | 3207461.0 |
| 2008-08-01 13:00:00 | MSFT | Stock | 25.24 | 25.415 | 25.23 | 25.39 | 3860357.0 |
| 2008-08-01 13:30:00 | MSFT | Stock | 25.38 | 25.48 | 25.3 | 25.39 | 4547056.0 |
| 2008-08-01 14:00:00 | MSFT | Stock | 25.38 | 25.45 | 25.3 | 25.432 | 3571292.0 |
| 2008-08-01 14:30:00 | MSFT | Stock | 25.44 | 25.51 | 25.25 | 25.49 | 5655731.0 |
| 2008-08-01 15:00:00 | MSFT | Stock | 25.48 | 25.52 | 25.37 | 25.44 | 4659271.0 |
| 2008-08-01 15:30:00 | MSFT | Stock | 25.43 | 25.502 | 25.39 | 25.44 | 7807431.0 |
| 2008-08-01 16:00:00 | MSFT | Stock | 25.44 | 25.53 | 25.322 | 25.4 | 1972929.0 |
| 2008-08-01 16:30:00 | MSFT | Stock | 25.44 | 25.44 | 25.44 | 25.44 | 200726.0 |
| 2008-08-01 17:30:00 | MSFT | Stock | 25.44 | 25.44 | 25.342 | 25.44 | 3280430.0 |
| 2008-08-01 18:30:00 | MSFT | Stock | 25.42 | 25.42 | 25.41 | 25.41 | 950.0 |
| 2008-08-01 19:30:00 | MSFT | Stock | 25.45 | 25.45 | 25.41 | 25.41 | 3910.0 |
| 2008-08-01 08:00:00 | NVDA | Stock | 0.286 | 0.286 | 0.286 | 0.286 | 40000.0 |
| 2008-08-01 08:30:00 | NVDA | Stock | 0.286 | 0.288 | 0.286 | 0.2862 | 464000.0 |
| 2008-08-01 09:00:00 | NVDA | Stock | 0.286 | 0.286 | 0.2775 | 0.2785 | 3224600.0 |
> showing 50 of 67,939 rows — these rows as CSV