PREVIEW / stock_1hour / 2009-10-22
file: by_date/stock_1hour/2009/2009-10-22.parquet size: 894 KB rows: 42,464 symbols: 3,390
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-22 04:00:00 | AAPL | Stock | 7.2893 | 7.2893 | 7.2679 | 7.2689 | 30800.0 |
| 2009-10-22 05:00:00 | AAPL | Stock | 7.2507 | 7.2589 | 7.25 | 7.25 | 23716.0 |
| 2009-10-22 06:00:00 | AAPL | Stock | 7.2746 | 7.2875 | 7.2746 | 7.2875 | 20440.0 |
| 2009-10-22 07:00:00 | AAPL | Stock | 7.3057 | 7.3214 | 7.2929 | 7.2964 | 180516.0 |
| 2009-10-22 08:00:00 | AAPL | Stock | 7.3 | 7.3861 | 7.3 | 7.3607 | 8352960.0 |
| 2009-10-22 09:00:00 | AAPL | Stock | 7.3607 | 7.4232 | 7.3 | 7.3611 | 159853288.0 |
| 2009-10-22 10:00:00 | AAPL | Stock | 7.3617 | 7.3968 | 7.3129 | 7.3546 | 165717496.0 |
| 2009-10-22 11:00:00 | AAPL | Stock | 7.3546 | 7.3621 | 7.2636 | 7.2636 | 104818840.0 |
| 2009-10-22 12:00:00 | AAPL | Stock | 7.2639 | 7.3214 | 7.2632 | 7.3114 | 63626164.0 |
| 2009-10-22 13:00:00 | AAPL | Stock | 7.3111 | 7.3211 | 7.2504 | 7.2675 | 71776180.0 |
| 2009-10-22 14:00:00 | AAPL | Stock | 7.2679 | 7.3318 | 7.2325 | 7.3257 | 96617836.0 |
| 2009-10-22 15:00:00 | AAPL | Stock | 7.3259 | 7.3464 | 7.3139 | 7.3286 | 102203332.0 |
| 2009-10-22 16:00:00 | AAPL | Stock | 7.3286 | 7.3464 | 7.3179 | 7.3418 | 9521260.0 |
| 2009-10-22 17:00:00 | AAPL | Stock | 7.3414 | 7.35 | 7.3414 | 7.35 | 839804.0 |
| 2009-10-22 18:00:00 | AAPL | Stock | 7.345 | 7.3564 | 7.3171 | 7.3539 | 408968.0 |
| 2009-10-22 19:00:00 | AAPL | Stock | 7.3543 | 7.3571 | 7.3286 | 7.3518 | 518000.0 |
| 2009-10-22 20:00:00 | AAPL | Stock | 7.2846 | 7.2846 | 7.2846 | 7.2846 | 5600.0 |
| 2009-10-22 05:00:00 | MSFT | Stock | 26.63 | 26.63 | 26.63 | 26.63 | 2000.0 |
| 2009-10-22 07:00:00 | MSFT | Stock | 26.63 | 26.75 | 26.63 | 26.72 | 13003.0 |
| 2009-10-22 08:00:00 | MSFT | Stock | 26.77 | 26.77 | 26.58 | 26.7 | 193102.0 |
| 2009-10-22 09:00:00 | MSFT | Stock | 26.7 | 26.72 | 26.35 | 26.46 | 6389558.0 |
| 2009-10-22 10:00:00 | MSFT | Stock | 26.46 | 26.47 | 26.17 | 26.2 | 9878808.0 |
| 2009-10-22 11:00:00 | MSFT | Stock | 26.2 | 26.3 | 26.13 | 26.29 | 7496063.0 |
| 2009-10-22 12:00:00 | MSFT | Stock | 26.28 | 26.44 | 26.25 | 26.41 | 5261571.0 |
| 2009-10-22 13:00:00 | MSFT | Stock | 26.42 | 26.49 | 26.32 | 26.41 | 4795910.0 |
| 2009-10-22 14:00:00 | MSFT | Stock | 26.41 | 26.6 | 26.41 | 26.538 | 7517016.0 |
| 2009-10-22 15:00:00 | MSFT | Stock | 26.54 | 26.61 | 26.45 | 26.59 | 14740559.0 |
| 2009-10-22 16:00:00 | MSFT | Stock | 26.59 | 26.63 | 26.419 | 26.62 | 3934622.0 |
| 2009-10-22 17:00:00 | MSFT | Stock | 26.63 | 26.92 | 26.63 | 26.87 | 369284.0 |
| 2009-10-22 18:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.59 | 26.83 | 128295.0 |
| 2009-10-22 19:00:00 | MSFT | Stock | 26.88 | 26.93 | 26.82 | 26.92 | 81785.0 |
| 2009-10-22 20:00:00 | MSFT | Stock | 26.36 | 26.36 | 26.36 | 26.36 | 6400.0 |
| 2009-10-22 08:00:00 | NVDA | Stock | 0.3338 | 0.3348 | 0.3338 | 0.3338 | 22800.0 |
| 2009-10-22 09:00:00 | NVDA | Stock | 0.3328 | 0.3338 | 0.327 | 0.3283 | 44502880.0 |
| 2009-10-22 10:00:00 | NVDA | Stock | 0.3285 | 0.331 | 0.3273 | 0.3308 | 113944360.0 |
| 2009-10-22 11:00:00 | NVDA | Stock | 0.3308 | 0.333 | 0.3305 | 0.331 | 30716760.0 |
| 2009-10-22 12:00:00 | NVDA | Stock | 0.3308 | 0.334 | 0.3308 | 0.3338 | 25463920.0 |
| 2009-10-22 13:00:00 | NVDA | Stock | 0.3338 | 0.335 | 0.3322 | 0.3333 | 38770680.0 |
| 2009-10-22 14:00:00 | NVDA | Stock | 0.3333 | 0.337 | 0.3333 | 0.336 | 36508000.0 |
| 2009-10-22 15:00:00 | NVDA | Stock | 0.336 | 0.3385 | 0.3358 | 0.3368 | 71614680.0 |
| 2009-10-22 16:00:00 | NVDA | Stock | 0.3362 | 0.3368 | 0.3305 | 0.3368 | 16593760.0 |
| 2009-10-22 18:00:00 | NVDA | Stock | 0.335 | 0.3388 | 0.335 | 0.3388 | 38000.0 |
| 2009-10-22 19:00:00 | NVDA | Stock | 0.3385 | 0.3385 | 0.3385 | 0.3385 | 20000.0 |
| 2009-10-22 04:00:00 | AMZN | Stock | 4.65 | 4.65 | 4.65 | 4.65 | 4000.0 |
| 2009-10-22 07:00:00 | AMZN | Stock | 4.688 | 4.688 | 4.688 | 4.688 | 2000.0 |
| 2009-10-22 08:00:00 | AMZN | Stock | 4.675 | 4.71 | 4.6745 | 4.68 | 214780.0 |
| 2009-10-22 09:00:00 | AMZN | Stock | 4.6825 | 4.686 | 4.585 | 4.6345 | 27162880.0 |
| 2009-10-22 10:00:00 | AMZN | Stock | 4.6365 | 4.642 | 4.5935 | 4.6175 | 28244420.0 |
| 2009-10-22 11:00:00 | AMZN | Stock | 4.6168 | 4.625 | 4.5925 | 4.5975 | 21128580.0 |
| 2009-10-22 12:00:00 | AMZN | Stock | 4.599 | 4.618 | 4.597 | 4.611 | 14407660.0 |
> showing 50 of 42,464 rows — these rows as CSV