PREVIEW / stock_1hour / 2009-11-10
file: by_date/stock_1hour/2009/2009-11-10.parquet size: 889 KB rows: 42,255 symbols: 3,411
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-11-10 05:00:00 | AAPL | Stock | 7.1918 | 7.1918 | 7.1811 | 7.1811 | 5600.0 |
| 2009-11-10 07:00:00 | AAPL | Stock | 7.1825 | 7.1982 | 7.1807 | 7.1807 | 71036.0 |
| 2009-11-10 08:00:00 | AAPL | Stock | 7.1929 | 7.1948 | 7.1721 | 7.1829 | 968884.0 |
| 2009-11-10 09:00:00 | AAPL | Stock | 7.1829 | 7.3207 | 7.175 | 7.2539 | 91587776.0 |
| 2009-11-10 10:00:00 | AAPL | Stock | 7.2532 | 7.2679 | 7.1982 | 7.2129 | 84549024.0 |
| 2009-11-10 11:00:00 | AAPL | Stock | 7.2126 | 7.2221 | 7.1789 | 7.2018 | 47443620.0 |
| 2009-11-10 12:00:00 | AAPL | Stock | 7.2018 | 7.2193 | 7.1886 | 7.2189 | 30425080.0 |
| 2009-11-10 13:00:00 | AAPL | Stock | 7.2186 | 7.2482 | 7.2154 | 7.248 | 34414128.0 |
| 2009-11-10 14:00:00 | AAPL | Stock | 7.2468 | 7.2607 | 7.2382 | 7.2493 | 40577432.0 |
| 2009-11-10 15:00:00 | AAPL | Stock | 7.2496 | 7.26 | 7.2221 | 7.2493 | 56927472.0 |
| 2009-11-10 16:00:00 | AAPL | Stock | 7.2493 | 7.25 | 7.2338 | 7.2464 | 4730544.0 |
| 2009-11-10 17:00:00 | AAPL | Stock | 7.2464 | 7.2521 | 7.245 | 7.25 | 160328.0 |
| 2009-11-10 18:00:00 | AAPL | Stock | 7.25 | 7.2536 | 7.2493 | 7.2504 | 353724.0 |
| 2009-11-10 19:00:00 | AAPL | Stock | 7.2529 | 7.2625 | 7.2529 | 7.26 | 329392.0 |
| 2009-11-10 07:00:00 | MSFT | Stock | 28.85 | 28.97 | 28.85 | 28.87 | 2781.0 |
| 2009-11-10 08:00:00 | MSFT | Stock | 28.9 | 28.97 | 28.81 | 28.89 | 8063.0 |
| 2009-11-10 09:00:00 | MSFT | Stock | 28.9 | 29.25 | 28.84 | 29.243 | 11152062.0 |
| 2009-11-10 10:00:00 | MSFT | Stock | 29.241 | 29.28 | 28.98 | 28.993 | 11589037.0 |
| 2009-11-10 11:00:00 | MSFT | Stock | 28.993 | 29.12 | 28.94 | 28.95 | 7299077.0 |
| 2009-11-10 12:00:00 | MSFT | Stock | 28.95 | 29.0 | 28.81 | 28.938 | 6669310.0 |
| 2009-11-10 13:00:00 | MSFT | Stock | 28.94 | 29.02 | 28.87 | 28.995 | 6799442.0 |
| 2009-11-10 14:00:00 | MSFT | Stock | 28.992 | 29.05 | 28.96 | 28.998 | 7451863.0 |
| 2009-11-10 15:00:00 | MSFT | Stock | 28.99 | 29.01 | 28.9 | 29.0 | 11392868.0 |
| 2009-11-10 16:00:00 | MSFT | Stock | 29.0 | 29.024 | 28.868 | 28.98 | 2517988.0 |
| 2009-11-10 17:00:00 | MSFT | Stock | 28.99 | 29.044 | 28.97 | 29.0 | 47912.0 |
| 2009-11-10 18:00:00 | MSFT | Stock | 28.98 | 29.02 | 28.98 | 29.0 | 29300.0 |
| 2009-11-10 19:00:00 | MSFT | Stock | 29.01 | 29.09 | 29.01 | 29.09 | 3530.0 |
| 2009-11-10 08:00:00 | NVDA | Stock | 0.3375 | 0.3395 | 0.3373 | 0.3373 | 150680.0 |
| 2009-11-10 09:00:00 | NVDA | Stock | 0.3378 | 0.3378 | 0.3322 | 0.3322 | 108892080.0 |
| 2009-11-10 10:00:00 | NVDA | Stock | 0.3322 | 0.3355 | 0.3278 | 0.3285 | 144730760.0 |
| 2009-11-10 11:00:00 | NVDA | Stock | 0.3285 | 0.3298 | 0.324 | 0.3288 | 142523320.0 |
| 2009-11-10 12:00:00 | NVDA | Stock | 0.3288 | 0.3293 | 0.327 | 0.3283 | 47213760.0 |
| 2009-11-10 13:00:00 | NVDA | Stock | 0.3283 | 0.329 | 0.3268 | 0.3278 | 74093040.0 |
| 2009-11-10 14:00:00 | NVDA | Stock | 0.3279 | 0.3308 | 0.3278 | 0.3303 | 82763080.0 |
| 2009-11-10 15:00:00 | NVDA | Stock | 0.3302 | 0.3303 | 0.327 | 0.3283 | 159433080.0 |
| 2009-11-10 16:00:00 | NVDA | Stock | 0.3283 | 0.3299 | 0.327 | 0.3278 | 7078640.0 |
| 2009-11-10 17:00:00 | NVDA | Stock | 0.3365 | 0.3365 | 0.3263 | 0.3263 | 482640.0 |
| 2009-11-10 18:00:00 | NVDA | Stock | 0.3278 | 0.3278 | 0.3278 | 0.3278 | 76000.0 |
| 2009-11-10 19:00:00 | NVDA | Stock | 0.3285 | 0.3285 | 0.3275 | 0.3285 | 162760.0 |
| 2009-11-10 07:00:00 | AMZN | Stock | 6.326 | 6.326 | 6.325 | 6.325 | 8000.0 |
| 2009-11-10 08:00:00 | AMZN | Stock | 6.347 | 6.3515 | 6.3305 | 6.3515 | 85880.0 |
| 2009-11-10 09:00:00 | AMZN | Stock | 6.35 | 6.3555 | 6.3 | 6.3385 | 19241460.0 |
| 2009-11-10 10:00:00 | AMZN | Stock | 6.338 | 6.4465 | 6.3355 | 6.3945 | 40104180.0 |
| 2009-11-10 11:00:00 | AMZN | Stock | 6.3945 | 6.4145 | 6.36 | 6.3935 | 22462160.0 |
| 2009-11-10 12:00:00 | AMZN | Stock | 6.3938 | 6.4105 | 6.3335 | 6.4105 | 11662880.0 |
| 2009-11-10 13:00:00 | AMZN | Stock | 6.4105 | 6.419 | 6.3975 | 6.4125 | 16929160.0 |
| 2009-11-10 14:00:00 | AMZN | Stock | 6.4125 | 6.4985 | 6.406 | 6.4985 | 31433300.0 |
| 2009-11-10 15:00:00 | AMZN | Stock | 6.4985 | 6.5305 | 6.488 | 6.5055 | 51216860.0 |
| 2009-11-10 16:00:00 | AMZN | Stock | 6.5035 | 6.518 | 6.4305 | 6.51 | 1038700.0 |
| 2009-11-10 17:00:00 | AMZN | Stock | 6.3335 | 6.527 | 6.3335 | 6.51 | 351340.0 |
> showing 50 of 42,255 rows — these rows as CSV