PREVIEW / stock_1hour / 2024-02-26
file: by_date/stock_1hour/2024/2024-02-26.parquet size: 1.4 MB rows: 60,394 symbols: 1,153
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 |
|---|---|---|---|---|---|---|---|
| 2024-02-26 04:00:00 | AAPL | Stock | 182.27 | 182.3 | 181.99 | 182.2 | 4842.0 |
| 2024-02-26 05:00:00 | AAPL | Stock | 182.11 | 182.24 | 182.1 | 182.18 | 3774.0 |
| 2024-02-26 06:00:00 | AAPL | Stock | 182.14 | 182.18 | 181.82 | 181.92 | 6445.0 |
| 2024-02-26 07:00:00 | AAPL | Stock | 181.9 | 182.17 | 181.9 | 182.06 | 23465.0 |
| 2024-02-26 08:00:00 | AAPL | Stock | 182.15 | 182.5 | 181.76 | 182.44 | 85731.0 |
| 2024-02-26 09:00:00 | AAPL | Stock | 182.49 | 182.76 | 181.1484 | 181.515 | 4686361.0 |
| 2024-02-26 10:00:00 | AAPL | Stock | 181.52 | 181.85 | 181.2 | 181.24 | 4394705.0 |
| 2024-02-26 11:00:00 | AAPL | Stock | 181.235 | 181.27 | 180.74 | 181.205 | 4206693.0 |
| 2024-02-26 12:00:00 | AAPL | Stock | 181.205 | 181.21 | 180.65 | 180.805 | 2744394.0 |
| 2024-02-26 13:00:00 | AAPL | Stock | 180.805 | 181.39 | 180.71 | 181.3899 | 3193176.0 |
| 2024-02-26 14:00:00 | AAPL | Stock | 181.3854 | 181.78 | 181.335 | 181.49 | 2908337.0 |
| 2024-02-26 15:00:00 | AAPL | Stock | 181.5 | 181.61 | 181.075 | 181.14 | 4884983.0 |
| 2024-02-26 16:00:00 | AAPL | Stock | 181.16 | 181.19 | 181.02 | 181.07 | 6395703.0 |
| 2024-02-26 17:00:00 | AAPL | Stock | 181.09 | 181.14 | 181.05 | 181.06 | 9975.0 |
| 2024-02-26 18:00:00 | AAPL | Stock | 181.05 | 181.16 | 181.02 | 181.04 | 14991.0 |
| 2024-02-26 19:00:00 | AAPL | Stock | 181.13 | 181.13 | 181.0 | 181.03 | 19780.0 |
| 2024-02-26 04:00:00 | MSFT | Stock | 410.44 | 410.46 | 409.95 | 409.95 | 2266.0 |
| 2024-02-26 05:00:00 | MSFT | Stock | 410.19 | 410.63 | 410.1 | 410.56 | 1531.0 |
| 2024-02-26 06:00:00 | MSFT | Stock | 410.82 | 411.51 | 410.77 | 410.83 | 5248.0 |
| 2024-02-26 07:00:00 | MSFT | Stock | 410.81 | 410.99 | 410.3 | 410.3 | 9758.0 |
| 2024-02-26 08:00:00 | MSFT | Stock | 410.6 | 411.45 | 409.75 | 411.3 | 26059.0 |
| 2024-02-26 09:00:00 | MSFT | Stock | 411.2271 | 412.16 | 408.62 | 408.68 | 1562022.0 |
| 2024-02-26 10:00:00 | MSFT | Stock | 408.71 | 410.3105 | 408.3 | 409.45 | 1331136.0 |
| 2024-02-26 11:00:00 | MSFT | Stock | 409.465 | 409.73 | 408.01 | 409.03 | 933725.0 |
| 2024-02-26 12:00:00 | MSFT | Stock | 409.02 | 409.6 | 408.49 | 408.7227 | 621535.0 |
| 2024-02-26 13:00:00 | MSFT | Stock | 408.7225 | 409.43 | 408.3 | 409.4 | 680806.0 |
| 2024-02-26 14:00:00 | MSFT | Stock | 409.41 | 409.46 | 408.74 | 408.74 | 725131.0 |
| 2024-02-26 15:00:00 | MSFT | Stock | 408.77 | 409.01 | 407.36 | 407.48 | 1456095.0 |
| 2024-02-26 16:00:00 | MSFT | Stock | 407.54 | 407.76 | 406.83 | 406.93 | 3858098.0 |
| 2024-02-26 17:00:00 | MSFT | Stock | 407.04 | 407.05 | 406.88 | 406.94 | 4209.0 |
| 2024-02-26 18:00:00 | MSFT | Stock | 407.06 | 407.25 | 406.88 | 407.2 | 7962.0 |
| 2024-02-26 19:00:00 | MSFT | Stock | 407.0 | 407.24 | 406.62 | 407.0 | 4108.0 |
| 2024-02-26 04:00:00 | NVDA | Stock | 79.09 | 80.1 | 78.787 | 80.05 | 649570.0 |
| 2024-02-26 05:00:00 | NVDA | Stock | 80.007 | 80.007 | 79.712 | 79.723 | 163650.0 |
| 2024-02-26 06:00:00 | NVDA | Stock | 79.72 | 79.797 | 79.57 | 79.6 | 148010.0 |
| 2024-02-26 07:00:00 | NVDA | Stock | 79.631 | 79.765 | 79.316 | 79.493 | 919900.0 |
| 2024-02-26 08:00:00 | NVDA | Stock | 79.535 | 79.8 | 78.626 | 79.78 | 3578120.0 |
| 2024-02-26 09:00:00 | NVDA | Stock | 79.7789 | 80.646 | 78.505 | 79.1075 | 77451520.0 |
| 2024-02-26 10:00:00 | NVDA | Stock | 79.094 | 80.1144 | 78.803 | 79.7645 | 62373990.0 |
| 2024-02-26 11:00:00 | NVDA | Stock | 79.7645 | 80.286 | 79.454 | 79.8035 | 44766630.0 |
| 2024-02-26 12:00:00 | NVDA | Stock | 79.8077 | 80.247 | 79.603 | 80.063 | 31940450.0 |
| 2024-02-26 13:00:00 | NVDA | Stock | 80.067 | 80.263 | 79.4 | 79.548 | 32475540.0 |
| 2024-02-26 14:00:00 | NVDA | Stock | 79.546 | 79.697 | 79.119 | 79.229 | 42133120.0 |
| 2024-02-26 15:00:00 | NVDA | Stock | 79.229 | 79.386 | 78.795 | 79.0911 | 50402460.0 |
| 2024-02-26 16:00:00 | NVDA | Stock | 79.092 | 79.147 | 78.6225 | 78.778 | 15132410.0 |
| 2024-02-26 17:00:00 | NVDA | Stock | 78.797 | 78.828 | 78.5 | 78.74 | 907060.0 |
| 2024-02-26 18:00:00 | NVDA | Stock | 78.717 | 78.988 | 78.65 | 78.94 | 603820.0 |
| 2024-02-26 19:00:00 | NVDA | Stock | 78.94 | 79.0 | 78.76 | 78.95 | 556710.0 |
| 2024-02-26 04:00:00 | AMZN | Stock | 174.43 | 175.34 | 174.43 | 175.34 | 2378.0 |
| 2024-02-26 05:00:00 | AMZN | Stock | 175.35 | 175.54 | 175.28 | 175.41 | 9169.0 |
> showing 50 of 60,394 rows — these rows as CSV