PREVIEW / stock_30min / 2005-09-09
file: by_date/stock_30min/2005/2005-09-09.parquet size: 831 KB rows: 45,250 symbols: 2,071
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-09 08:00:00 | AAPL | Stock | 1.7854 | 1.7854 | 1.7804 | 1.7804 | 146720.0 |
| 2005-09-09 08:30:00 | AAPL | Stock | 1.7789 | 1.7818 | 1.7789 | 1.78 | 637756.0 |
| 2005-09-09 09:00:00 | AAPL | Stock | 1.78 | 1.7871 | 1.7786 | 1.7871 | 1435392.0 |
| 2005-09-09 09:30:00 | AAPL | Stock | 1.7882 | 1.7943 | 1.7782 | 1.7882 | 91969864.0 |
| 2005-09-09 10:00:00 | AAPL | Stock | 1.7882 | 1.7982 | 1.7836 | 1.7975 | 50684088.0 |
| 2005-09-09 10:30:00 | AAPL | Stock | 1.7971 | 1.8018 | 1.7936 | 1.7989 | 55795264.0 |
| 2005-09-09 11:00:00 | AAPL | Stock | 1.7989 | 1.8136 | 1.7979 | 1.81 | 67589704.0 |
| 2005-09-09 11:30:00 | AAPL | Stock | 1.8097 | 1.8214 | 1.8097 | 1.8211 | 59510052.0 |
| 2005-09-09 12:00:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.8114 | 1.8154 | 39312616.0 |
| 2005-09-09 12:30:00 | AAPL | Stock | 1.8154 | 1.8196 | 1.8096 | 1.8139 | 19321428.0 |
| 2005-09-09 13:00:00 | AAPL | Stock | 1.8139 | 1.8204 | 1.8136 | 1.8175 | 27164844.0 |
| 2005-09-09 13:30:00 | AAPL | Stock | 1.8175 | 1.8211 | 1.8164 | 1.8193 | 20139616.0 |
| 2005-09-09 14:00:00 | AAPL | Stock | 1.8193 | 1.8196 | 1.815 | 1.8161 | 17897936.0 |
| 2005-09-09 14:30:00 | AAPL | Stock | 1.8164 | 1.8179 | 1.8129 | 1.8157 | 19632312.0 |
| 2005-09-09 15:00:00 | AAPL | Stock | 1.8161 | 1.8264 | 1.8146 | 1.8246 | 35318836.0 |
| 2005-09-09 15:30:00 | AAPL | Stock | 1.8246 | 1.8339 | 1.8243 | 1.8314 | 97731284.0 |
| 2005-09-09 16:00:00 | AAPL | Stock | 1.8321 | 1.8329 | 1.8282 | 1.8307 | 2750580.0 |
| 2005-09-09 16:30:00 | AAPL | Stock | 1.8307 | 1.8325 | 1.8293 | 1.8314 | 546700.0 |
| 2005-09-09 17:00:00 | AAPL | Stock | 1.8321 | 1.8339 | 1.8321 | 1.8339 | 113400.0 |
| 2005-09-09 17:30:00 | AAPL | Stock | 1.8364 | 1.8375 | 1.835 | 1.8364 | 56000.0 |
| 2005-09-09 18:00:00 | AAPL | Stock | 1.8357 | 1.8393 | 1.8346 | 1.8357 | 255920.0 |
| 2005-09-09 08:00:00 | MSFT | Stock | 26.65 | 26.65 | 26.62 | 26.62 | 14210.0 |
| 2005-09-09 08:30:00 | MSFT | Stock | 26.63 | 26.68 | 26.51 | 26.63 | 36186.0 |
| 2005-09-09 09:00:00 | MSFT | Stock | 26.63 | 26.65 | 26.61 | 26.63 | 37629.0 |
| 2005-09-09 09:30:00 | MSFT | Stock | 26.62 | 26.75 | 26.61 | 26.71 | 3724742.0 |
| 2005-09-09 10:00:00 | MSFT | Stock | 26.71 | 26.75 | 26.68 | 26.72 | 1993735.0 |
| 2005-09-09 10:30:00 | MSFT | Stock | 26.71 | 26.77 | 26.67 | 26.74 | 2630763.0 |
| 2005-09-09 11:00:00 | MSFT | Stock | 26.74 | 26.78 | 26.73 | 26.76 | 2658140.0 |
| 2005-09-09 11:30:00 | MSFT | Stock | 26.75 | 26.81 | 26.72 | 26.8 | 2714441.0 |
| 2005-09-09 12:00:00 | MSFT | Stock | 26.79 | 26.82 | 26.75 | 26.78 | 2401270.0 |
| 2005-09-09 12:30:00 | MSFT | Stock | 26.78 | 26.79 | 26.72 | 26.721 | 1252596.0 |
| 2005-09-09 13:00:00 | MSFT | Stock | 26.73 | 26.73 | 26.68 | 26.701 | 3150691.0 |
| 2005-09-09 13:30:00 | MSFT | Stock | 26.7 | 26.701 | 26.63 | 26.65 | 3097290.0 |
| 2005-09-09 14:00:00 | MSFT | Stock | 26.658 | 26.66 | 26.55 | 26.57 | 2927152.0 |
| 2005-09-09 14:30:00 | MSFT | Stock | 26.57 | 26.64 | 26.53 | 26.629 | 3750086.0 |
| 2005-09-09 15:00:00 | MSFT | Stock | 26.62 | 26.65 | 26.55 | 26.6 | 3418292.0 |
| 2005-09-09 15:30:00 | MSFT | Stock | 26.6 | 26.69 | 26.55 | 26.6 | 5168000.0 |
| 2005-09-09 16:00:00 | MSFT | Stock | 26.6 | 26.666 | 26.56 | 26.6 | 576953.0 |
| 2005-09-09 16:30:00 | MSFT | Stock | 26.59 | 26.61 | 26.57 | 26.57 | 1500.0 |
| 2005-09-09 17:00:00 | MSFT | Stock | 26.59 | 26.59 | 26.57 | 26.58 | 2677.0 |
| 2005-09-09 17:30:00 | MSFT | Stock | 26.59 | 26.724 | 26.58 | 26.724 | 19788.0 |
| 2005-09-09 18:00:00 | MSFT | Stock | 26.632 | 26.632 | 26.57 | 26.6 | 22346.0 |
| 2005-09-09 08:00:00 | NVDA | Stock | 0.265 | 0.265 | 0.265 | 0.265 | 12000.0 |
| 2005-09-09 08:30:00 | NVDA | Stock | 0.2677 | 0.2677 | 0.2677 | 0.2677 | 12000.0 |
| 2005-09-09 09:00:00 | NVDA | Stock | 0.2658 | 0.2677 | 0.2658 | 0.2677 | 516000.0 |
| 2005-09-09 09:30:00 | NVDA | Stock | 0.2677 | 0.2678 | 0.2633 | 0.2656 | 74209920.0 |
| 2005-09-09 10:00:00 | NVDA | Stock | 0.2656 | 0.2665 | 0.2649 | 0.2663 | 28167360.0 |
| 2005-09-09 10:30:00 | NVDA | Stock | 0.2662 | 0.2663 | 0.2653 | 0.2659 | 42891840.0 |
| 2005-09-09 11:00:00 | NVDA | Stock | 0.2659 | 0.2675 | 0.265 | 0.2667 | 49931040.0 |
| 2005-09-09 11:30:00 | NVDA | Stock | 0.2667 | 0.2677 | 0.2667 | 0.2674 | 26183040.0 |
> showing 50 of 45,250 rows — these rows as CSV