PREVIEW / stock_1hour / 2008-10-02
file: by_date/stock_1hour/2008/2008-10-02.parquet size: 819 KB rows: 40,842 symbols: 3,354
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-10-02 05:00:00 | AAPL | Stock | 3.9643 | 3.9643 | 3.9643 | 3.9643 | 2800.0 |
| 2008-10-02 06:00:00 | AAPL | Stock | 3.9643 | 3.9643 | 3.9464 | 3.9464 | 5600.0 |
| 2008-10-02 07:00:00 | AAPL | Stock | 3.9357 | 3.9443 | 3.8679 | 3.875 | 356328.0 |
| 2008-10-02 08:00:00 | AAPL | Stock | 3.8929 | 3.8929 | 3.8307 | 3.8504 | 2033668.0 |
| 2008-10-02 09:00:00 | AAPL | Stock | 3.8443 | 3.8854 | 3.8036 | 3.8136 | 125647648.0 |
| 2008-10-02 10:00:00 | AAPL | Stock | 3.8125 | 3.8136 | 3.6021 | 3.6529 | 297629556.0 |
| 2008-10-02 11:00:00 | AAPL | Stock | 3.6534 | 3.7536 | 3.6207 | 3.7496 | 184075668.0 |
| 2008-10-02 12:00:00 | AAPL | Stock | 3.7496 | 3.7679 | 3.7096 | 3.74 | 122959368.0 |
| 2008-10-02 13:00:00 | AAPL | Stock | 3.74 | 3.7407 | 3.6357 | 3.6811 | 205695140.0 |
| 2008-10-02 14:00:00 | AAPL | Stock | 3.6807 | 3.715 | 3.6036 | 3.6396 | 240388204.0 |
| 2008-10-02 15:00:00 | AAPL | Stock | 3.6386 | 3.6432 | 3.5714 | 3.575 | 391380332.0 |
| 2008-10-02 16:00:00 | AAPL | Stock | 3.575 | 3.6762 | 3.5736 | 3.5964 | 28097832.0 |
| 2008-10-02 17:00:00 | AAPL | Stock | 3.5929 | 3.6781 | 3.5911 | 3.5986 | 665784.0 |
| 2008-10-02 18:00:00 | AAPL | Stock | 3.5986 | 3.6071 | 3.5954 | 3.6064 | 791056.0 |
| 2008-10-02 19:00:00 | AAPL | Stock | 3.6039 | 3.6346 | 3.6036 | 3.6143 | 643020.0 |
| 2008-10-02 07:00:00 | MSFT | Stock | 26.31 | 26.31 | 26.11 | 26.16 | 1500.0 |
| 2008-10-02 08:00:00 | MSFT | Stock | 26.2 | 26.6 | 26.18 | 26.18 | 27056.0 |
| 2008-10-02 09:00:00 | MSFT | Stock | 26.18 | 26.28 | 25.83 | 25.87 | 9033380.0 |
| 2008-10-02 10:00:00 | MSFT | Stock | 25.86 | 26.05 | 25.7 | 25.91 | 14668456.0 |
| 2008-10-02 11:00:00 | MSFT | Stock | 25.9 | 26.2 | 25.87 | 26.16 | 8699844.0 |
| 2008-10-02 12:00:00 | MSFT | Stock | 26.15 | 26.17 | 25.91 | 26.06 | 6980234.0 |
| 2008-10-02 13:00:00 | MSFT | Stock | 26.063 | 26.38 | 25.89 | 26.3 | 9980745.0 |
| 2008-10-02 14:00:00 | MSFT | Stock | 26.3 | 26.49 | 26.14 | 26.27 | 10426221.0 |
| 2008-10-02 15:00:00 | MSFT | Stock | 26.27 | 26.53 | 26.04 | 26.3 | 26781137.0 |
| 2008-10-02 16:00:00 | MSFT | Stock | 26.323 | 26.57 | 26.05 | 26.38 | 4169107.0 |
| 2008-10-02 17:00:00 | MSFT | Stock | 26.25 | 26.45 | 26.23 | 26.276 | 723392.0 |
| 2008-10-02 18:00:00 | MSFT | Stock | 26.26 | 26.33 | 26.25 | 26.3 | 4099.0 |
| 2008-10-02 19:00:00 | MSFT | Stock | 26.22 | 26.26 | 26.19 | 26.19 | 8069.0 |
| 2008-10-02 08:00:00 | NVDA | Stock | 0.2603 | 0.2603 | 0.2598 | 0.2598 | 60000.0 |
| 2008-10-02 09:00:00 | NVDA | Stock | 0.2575 | 0.262 | 0.2493 | 0.2503 | 64852880.0 |
| 2008-10-02 10:00:00 | NVDA | Stock | 0.25 | 0.2513 | 0.2425 | 0.2453 | 139661240.0 |
| 2008-10-02 11:00:00 | NVDA | Stock | 0.2454 | 0.2495 | 0.2425 | 0.249 | 71176440.0 |
| 2008-10-02 12:00:00 | NVDA | Stock | 0.2493 | 0.2505 | 0.2458 | 0.2473 | 87749680.0 |
| 2008-10-02 13:00:00 | NVDA | Stock | 0.2471 | 0.2473 | 0.2415 | 0.2422 | 105920560.0 |
| 2008-10-02 14:00:00 | NVDA | Stock | 0.2422 | 0.243 | 0.2345 | 0.2374 | 125107120.0 |
| 2008-10-02 15:00:00 | NVDA | Stock | 0.2375 | 0.2375 | 0.232 | 0.2332 | 175537640.0 |
| 2008-10-02 16:00:00 | NVDA | Stock | 0.2335 | 0.2428 | 0.2332 | 0.2355 | 2839880.0 |
| 2008-10-02 17:00:00 | NVDA | Stock | 0.2355 | 0.2375 | 0.2355 | 0.2375 | 80000.0 |
| 2008-10-02 18:00:00 | NVDA | Stock | 0.2332 | 0.2395 | 0.2332 | 0.2395 | 216080.0 |
| 2008-10-02 19:00:00 | NVDA | Stock | 0.2352 | 0.2355 | 0.2338 | 0.2338 | 153240.0 |
| 2008-10-02 04:00:00 | AMZN | Stock | 3.4405 | 3.4405 | 3.4405 | 3.4405 | 2000.0 |
| 2008-10-02 08:00:00 | AMZN | Stock | 3.5265 | 3.566 | 3.43 | 3.4325 | 238240.0 |
| 2008-10-02 09:00:00 | AMZN | Stock | 3.4315 | 3.448 | 3.3125 | 3.3455 | 21535160.0 |
| 2008-10-02 10:00:00 | AMZN | Stock | 3.3455 | 3.35 | 3.2705 | 3.3255 | 38190760.0 |
| 2008-10-02 11:00:00 | AMZN | Stock | 3.327 | 3.3555 | 3.2865 | 3.3245 | 16405060.0 |
| 2008-10-02 12:00:00 | AMZN | Stock | 3.325 | 3.3725 | 3.31 | 3.3585 | 11814740.0 |
| 2008-10-02 13:00:00 | AMZN | Stock | 3.357 | 3.3645 | 3.32 | 3.363 | 18342200.0 |
| 2008-10-02 14:00:00 | AMZN | Stock | 3.362 | 3.3925 | 3.3 | 3.366 | 23274200.0 |
| 2008-10-02 15:00:00 | AMZN | Stock | 3.3645 | 3.395 | 3.3325 | 3.3685 | 35207120.0 |
| 2008-10-02 16:00:00 | AMZN | Stock | 3.3675 | 3.399 | 3.3386 | 3.399 | 6388880.0 |
> showing 50 of 40,842 rows — these rows as CSV