PREVIEW / stock_30min / 2008-07-29
file: by_date/stock_30min/2008/2008-07-29.parquet size: 1.3 MB rows: 69,349 symbols: 3,325
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-07-29 07:00:00 | AAPL | Stock | 5.5357 | 5.5421 | 5.5186 | 5.5421 | 70980.0 |
| 2008-07-29 07:30:00 | AAPL | Stock | 5.5446 | 5.5471 | 5.5446 | 5.5471 | 60200.0 |
| 2008-07-29 08:00:00 | AAPL | Stock | 5.5357 | 5.5464 | 5.5357 | 5.5375 | 1156848.0 |
| 2008-07-29 08:30:00 | AAPL | Stock | 5.5386 | 5.5607 | 5.535 | 5.5536 | 2074744.0 |
| 2008-07-29 09:00:00 | AAPL | Stock | 5.555 | 5.5661 | 5.5375 | 5.5468 | 878724.0 |
| 2008-07-29 09:30:00 | AAPL | Stock | 5.5482 | 5.5996 | 5.4875 | 5.5736 | 102884404.0 |
| 2008-07-29 10:00:00 | AAPL | Stock | 5.5736 | 5.6521 | 5.5725 | 5.6161 | 93969148.0 |
| 2008-07-29 10:30:00 | AAPL | Stock | 5.6161 | 5.6946 | 5.615 | 5.6675 | 74688432.0 |
| 2008-07-29 11:00:00 | AAPL | Stock | 5.6682 | 5.6829 | 5.6546 | 5.6632 | 35271068.0 |
| 2008-07-29 11:30:00 | AAPL | Stock | 5.6636 | 5.675 | 5.6393 | 5.6539 | 33400192.0 |
| 2008-07-29 12:00:00 | AAPL | Stock | 5.6546 | 5.6764 | 5.6268 | 5.6407 | 37928296.0 |
| 2008-07-29 12:30:00 | AAPL | Stock | 5.64 | 5.6529 | 5.6279 | 5.6429 | 33330304.0 |
| 2008-07-29 13:00:00 | AAPL | Stock | 5.6425 | 5.6746 | 5.6307 | 5.6746 | 25108608.0 |
| 2008-07-29 13:30:00 | AAPL | Stock | 5.6729 | 5.675 | 5.6504 | 5.6618 | 22398572.0 |
| 2008-07-29 14:00:00 | AAPL | Stock | 5.662 | 5.6625 | 5.6304 | 5.6475 | 35294868.0 |
| 2008-07-29 14:30:00 | AAPL | Stock | 5.6482 | 5.6536 | 5.6107 | 5.6146 | 39868024.0 |
| 2008-07-29 15:00:00 | AAPL | Stock | 5.6147 | 5.6421 | 5.5893 | 5.6307 | 52449012.0 |
| 2008-07-29 15:30:00 | AAPL | Stock | 5.6307 | 5.6343 | 5.5914 | 5.6071 | 62133064.0 |
| 2008-07-29 16:00:00 | AAPL | Stock | 5.6066 | 5.6355 | 5.6064 | 5.6139 | 14316456.0 |
| 2008-07-29 16:30:00 | AAPL | Stock | 5.6114 | 5.6226 | 5.6089 | 5.6125 | 8449056.0 |
| 2008-07-29 17:00:00 | AAPL | Stock | 5.6107 | 5.6125 | 5.6071 | 5.6071 | 65464.0 |
| 2008-07-29 17:30:00 | AAPL | Stock | 5.6071 | 5.61 | 5.6071 | 5.61 | 49280.0 |
| 2008-07-29 18:00:00 | AAPL | Stock | 5.6107 | 5.6143 | 5.6089 | 5.6143 | 205184.0 |
| 2008-07-29 18:30:00 | AAPL | Stock | 5.6125 | 5.6143 | 5.6125 | 5.6125 | 51940.0 |
| 2008-07-29 19:00:00 | AAPL | Stock | 5.6139 | 5.6143 | 5.6082 | 5.6107 | 25704.0 |
| 2008-07-29 19:30:00 | AAPL | Stock | 5.6111 | 5.6125 | 5.6071 | 5.6071 | 68264.0 |
| 2008-07-29 20:00:00 | AAPL | Stock | 5.6379 | 5.6379 | 5.6379 | 5.6379 | 34384.0 |
| 2008-07-29 07:00:00 | MSFT | Stock | 25.65 | 25.65 | 25.65 | 25.65 | 100.0 |
| 2008-07-29 07:30:00 | MSFT | Stock | 25.65 | 25.65 | 25.64 | 25.64 | 645.0 |
| 2008-07-29 08:00:00 | MSFT | Stock | 25.56 | 25.65 | 25.56 | 25.64 | 25005.0 |
| 2008-07-29 08:30:00 | MSFT | Stock | 25.62 | 25.65 | 25.6 | 25.65 | 16636.0 |
| 2008-07-29 09:00:00 | MSFT | Stock | 25.67 | 25.7 | 25.49 | 25.52 | 60101.0 |
| 2008-07-29 09:30:00 | MSFT | Stock | 25.56 | 25.87 | 25.4 | 25.86 | 5561606.0 |
| 2008-07-29 10:00:00 | MSFT | Stock | 25.86 | 26.06 | 25.85 | 26.0 | 6015127.0 |
| 2008-07-29 10:30:00 | MSFT | Stock | 26.0 | 26.11 | 25.96 | 26.03 | 4687066.0 |
| 2008-07-29 11:00:00 | MSFT | Stock | 26.03 | 26.19 | 26.03 | 26.052 | 4871342.0 |
| 2008-07-29 11:30:00 | MSFT | Stock | 26.05 | 26.11 | 26.0 | 26.1 | 3163161.0 |
| 2008-07-29 12:00:00 | MSFT | Stock | 26.1 | 26.18 | 26.07 | 26.14 | 4458082.0 |
| 2008-07-29 12:30:00 | MSFT | Stock | 26.15 | 26.15 | 26.0 | 26.05 | 3445729.0 |
| 2008-07-29 13:00:00 | MSFT | Stock | 26.04 | 26.05 | 25.94 | 26.04 | 3933768.0 |
| 2008-07-29 13:30:00 | MSFT | Stock | 26.04 | 26.14 | 26.03 | 26.11 | 2491899.0 |
| 2008-07-29 14:00:00 | MSFT | Stock | 26.11 | 26.13 | 25.95 | 25.98 | 4191137.0 |
| 2008-07-29 14:30:00 | MSFT | Stock | 25.98 | 26.015 | 25.94 | 26.0 | 2596331.0 |
| 2008-07-29 15:00:00 | MSFT | Stock | 25.998 | 26.12 | 25.99 | 26.08 | 3242803.0 |
| 2008-07-29 15:30:00 | MSFT | Stock | 26.08 | 26.15 | 26.03 | 26.1 | 7692765.0 |
| 2008-07-29 16:00:00 | MSFT | Stock | 26.11 | 26.12 | 26.0 | 26.0 | 5559765.0 |
| 2008-07-29 16:30:00 | MSFT | Stock | 26.112 | 26.112 | 26.07 | 26.07 | 3026028.0 |
| 2008-07-29 17:00:00 | MSFT | Stock | 26.07 | 26.07 | 26.07 | 26.07 | 200.0 |
| 2008-07-29 18:00:00 | MSFT | Stock | 26.07 | 26.11 | 26.06 | 26.11 | 37652.0 |
| 2008-07-29 19:00:00 | MSFT | Stock | 26.07 | 26.07 | 26.06 | 26.06 | 800.0 |
> showing 50 of 69,349 rows — these rows as CSV