PREVIEW / stock_1hour / 2009-08-19
file: by_date/stock_1hour/2009/2009-08-19.parquet size: 850 KB rows: 41,508 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 |
|---|---|---|---|---|---|---|---|
| 2009-08-19 04:00:00 | AAPL | Stock | 5.79 | 5.79 | 5.79 | 5.79 | 14000.0 |
| 2009-08-19 05:00:00 | AAPL | Stock | 5.7857 | 5.7857 | 5.7857 | 5.7857 | 16800.0 |
| 2009-08-19 06:00:00 | AAPL | Stock | 5.7875 | 5.8107 | 5.7857 | 5.8107 | 34160.0 |
| 2009-08-19 07:00:00 | AAPL | Stock | 5.8061 | 5.8179 | 5.8 | 5.8036 | 333704.0 |
| 2009-08-19 08:00:00 | AAPL | Stock | 5.8036 | 5.8196 | 5.8014 | 5.8121 | 2326408.0 |
| 2009-08-19 09:00:00 | AAPL | Stock | 5.8107 | 5.8636 | 5.8018 | 5.8575 | 71740704.0 |
| 2009-08-19 10:00:00 | AAPL | Stock | 5.8586 | 5.9036 | 5.8575 | 5.8679 | 84898940.0 |
| 2009-08-19 11:00:00 | AAPL | Stock | 5.8679 | 5.8732 | 5.8457 | 5.8682 | 45636780.0 |
| 2009-08-19 12:00:00 | AAPL | Stock | 5.8686 | 5.8821 | 5.8607 | 5.8686 | 47636204.0 |
| 2009-08-19 13:00:00 | AAPL | Stock | 5.8682 | 5.8846 | 5.8643 | 5.8846 | 30066176.0 |
| 2009-08-19 14:00:00 | AAPL | Stock | 5.8846 | 5.8886 | 5.8683 | 5.8786 | 30525096.0 |
| 2009-08-19 15:00:00 | AAPL | Stock | 5.8786 | 5.8789 | 5.8557 | 5.8786 | 63501928.0 |
| 2009-08-19 16:00:00 | AAPL | Stock | 5.8786 | 5.8821 | 5.856 | 5.8804 | 27664784.0 |
| 2009-08-19 17:00:00 | AAPL | Stock | 5.8804 | 5.8821 | 5.863 | 5.8818 | 310576.0 |
| 2009-08-19 18:00:00 | AAPL | Stock | 5.8818 | 5.8836 | 5.8786 | 5.8807 | 815808.0 |
| 2009-08-19 19:00:00 | AAPL | Stock | 5.8789 | 5.8857 | 5.8786 | 5.8857 | 227332.0 |
| 2009-08-19 07:00:00 | MSFT | Stock | 23.34 | 23.34 | 23.34 | 23.34 | 400.0 |
| 2009-08-19 08:00:00 | MSFT | Stock | 23.36 | 23.39 | 23.21 | 23.25 | 55631.0 |
| 2009-08-19 09:00:00 | MSFT | Stock | 23.32 | 23.385 | 23.25 | 23.35 | 6357155.0 |
| 2009-08-19 10:00:00 | MSFT | Stock | 23.36 | 23.49 | 23.28 | 23.312 | 7066082.0 |
| 2009-08-19 11:00:00 | MSFT | Stock | 23.309 | 23.56 | 23.29 | 23.56 | 4942066.0 |
| 2009-08-19 12:00:00 | MSFT | Stock | 23.56 | 23.705 | 23.53 | 23.65 | 5875964.0 |
| 2009-08-19 13:00:00 | MSFT | Stock | 23.66 | 23.72 | 23.63 | 23.685 | 3803372.0 |
| 2009-08-19 14:00:00 | MSFT | Stock | 23.69 | 23.71 | 23.59 | 23.655 | 4100550.0 |
| 2009-08-19 15:00:00 | MSFT | Stock | 23.65 | 23.67 | 23.473 | 23.65 | 7288610.0 |
| 2009-08-19 16:00:00 | MSFT | Stock | 23.64 | 23.68 | 23.502 | 23.68 | 1724019.0 |
| 2009-08-19 17:00:00 | MSFT | Stock | 23.64 | 23.66 | 23.64 | 23.65 | 11453.0 |
| 2009-08-19 18:00:00 | MSFT | Stock | 23.65 | 23.65 | 23.65 | 23.65 | 2207.0 |
| 2009-08-19 19:00:00 | MSFT | Stock | 23.65 | 23.65 | 23.59 | 23.59 | 5563.0 |
| 2009-08-19 07:00:00 | NVDA | Stock | 0.3275 | 0.3275 | 0.3275 | 0.3275 | 20000.0 |
| 2009-08-19 08:00:00 | NVDA | Stock | 0.331 | 0.3315 | 0.3265 | 0.3265 | 696000.0 |
| 2009-08-19 09:00:00 | NVDA | Stock | 0.3275 | 0.3295 | 0.325 | 0.327 | 50546760.0 |
| 2009-08-19 10:00:00 | NVDA | Stock | 0.327 | 0.33 | 0.3255 | 0.3268 | 138659800.0 |
| 2009-08-19 11:00:00 | NVDA | Stock | 0.3268 | 0.3303 | 0.3263 | 0.33 | 50255720.0 |
| 2009-08-19 12:00:00 | NVDA | Stock | 0.33 | 0.3315 | 0.33 | 0.3308 | 54197120.0 |
| 2009-08-19 13:00:00 | NVDA | Stock | 0.3307 | 0.3313 | 0.3293 | 0.3305 | 60334400.0 |
| 2009-08-19 14:00:00 | NVDA | Stock | 0.3308 | 0.331 | 0.3285 | 0.33 | 72771960.0 |
| 2009-08-19 15:00:00 | NVDA | Stock | 0.3299 | 0.33 | 0.327 | 0.3295 | 113644480.0 |
| 2009-08-19 16:00:00 | NVDA | Stock | 0.3295 | 0.3298 | 0.3285 | 0.3295 | 2872120.0 |
| 2009-08-19 18:00:00 | NVDA | Stock | 0.3295 | 0.3295 | 0.3295 | 0.3295 | 13400.0 |
| 2009-08-19 19:00:00 | NVDA | Stock | 0.3295 | 0.3298 | 0.329 | 0.329 | 21760.0 |
| 2009-08-19 04:00:00 | AMZN | Stock | 4.06 | 4.06 | 4.06 | 4.06 | 2000.0 |
| 2009-08-19 08:00:00 | AMZN | Stock | 4.086 | 4.086 | 4.05 | 4.0745 | 169520.0 |
| 2009-08-19 09:00:00 | AMZN | Stock | 4.074 | 4.0815 | 4.0245 | 4.0575 | 18556820.0 |
| 2009-08-19 10:00:00 | AMZN | Stock | 4.058 | 4.102 | 4.0575 | 4.0685 | 18422400.0 |
| 2009-08-19 11:00:00 | AMZN | Stock | 4.069 | 4.1074 | 4.058 | 4.1015 | 10774600.0 |
| 2009-08-19 12:00:00 | AMZN | Stock | 4.1015 | 4.1335 | 4.101 | 4.125 | 10221480.0 |
| 2009-08-19 13:00:00 | AMZN | Stock | 4.125 | 4.15 | 4.1215 | 4.137 | 12619020.0 |
| 2009-08-19 14:00:00 | AMZN | Stock | 4.1375 | 4.1405 | 4.112 | 4.126 | 8621660.0 |
| 2009-08-19 15:00:00 | AMZN | Stock | 4.126 | 4.127 | 4.1085 | 4.1205 | 19479600.0 |
> showing 50 of 41,508 rows — these rows as CSV