PREVIEW / stock_1hour / 2024-03-27
file: by_date/stock_1hour/2024/2024-03-27.parquet size: 1.3 MB rows: 59,646 symbols: 1,047
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-03-27 04:00:00 | AAPL | Stock | 170.0 | 170.12 | 169.7 | 169.99 | 14021.0 |
| 2024-03-27 05:00:00 | AAPL | Stock | 170.07 | 170.2 | 170.07 | 170.15 | 5045.0 |
| 2024-03-27 06:00:00 | AAPL | Stock | 170.22 | 170.61 | 170.16 | 170.44 | 18780.0 |
| 2024-03-27 07:00:00 | AAPL | Stock | 170.5 | 170.55 | 170.28 | 170.5 | 19677.0 |
| 2024-03-27 08:00:00 | AAPL | Stock | 170.238 | 170.86 | 169.96 | 170.7787 | 92540.0 |
| 2024-03-27 09:00:00 | AAPL | Stock | 170.75 | 172.88 | 170.11 | 172.7152 | 7723893.0 |
| 2024-03-27 10:00:00 | AAPL | Stock | 172.72 | 173.12 | 171.94 | 172.455 | 7734184.0 |
| 2024-03-27 11:00:00 | AAPL | Stock | 172.44 | 172.76 | 172.05 | 172.06 | 4204032.0 |
| 2024-03-27 12:00:00 | AAPL | Stock | 172.07 | 172.3499 | 171.86 | 172.165 | 3348508.0 |
| 2024-03-27 13:00:00 | AAPL | Stock | 172.17 | 172.49 | 172.0 | 172.288 | 2749217.0 |
| 2024-03-27 14:00:00 | AAPL | Stock | 172.28 | 172.82 | 172.23 | 172.7 | 3471211.0 |
| 2024-03-27 15:00:00 | AAPL | Stock | 172.7 | 173.6 | 172.62 | 173.41 | 10105645.0 |
| 2024-03-27 16:00:00 | AAPL | Stock | 173.41 | 173.69 | 173.09 | 173.15 | 9424264.0 |
| 2024-03-27 17:00:00 | AAPL | Stock | 173.12 | 173.25 | 173.01 | 173.09 | 41179.0 |
| 2024-03-27 18:00:00 | AAPL | Stock | 173.08 | 173.31 | 172.88 | 172.93 | 53496.0 |
| 2024-03-27 19:00:00 | AAPL | Stock | 172.89 | 173.0 | 172.87 | 172.9 | 20625.0 |
| 2024-03-27 04:00:00 | MSFT | Stock | 422.07 | 422.3 | 421.46 | 421.46 | 6666.0 |
| 2024-03-27 05:00:00 | MSFT | Stock | 421.79 | 422.33 | 421.5 | 422.11 | 1804.0 |
| 2024-03-27 06:00:00 | MSFT | Stock | 422.2 | 422.74 | 422.0 | 422.7 | 3059.0 |
| 2024-03-27 07:00:00 | MSFT | Stock | 422.75 | 422.88 | 422.15 | 422.43 | 6294.0 |
| 2024-03-27 08:00:00 | MSFT | Stock | 422.54 | 423.575 | 422.0 | 423.4 | 15004.0 |
| 2024-03-27 09:00:00 | MSFT | Stock | 423.3 | 424.45 | 421.89 | 422.4 | 931949.0 |
| 2024-03-27 10:00:00 | MSFT | Stock | 422.35 | 422.5099 | 420.2735 | 420.79 | 1509920.0 |
| 2024-03-27 11:00:00 | MSFT | Stock | 420.79 | 420.97 | 419.29 | 419.31 | 951164.0 |
| 2024-03-27 12:00:00 | MSFT | Stock | 419.32 | 420.47 | 419.28 | 420.2475 | 637385.0 |
| 2024-03-27 13:00:00 | MSFT | Stock | 420.24 | 420.4099 | 419.31 | 419.58 | 569792.0 |
| 2024-03-27 14:00:00 | MSFT | Stock | 419.5982 | 420.29 | 419.23 | 419.41 | 637484.0 |
| 2024-03-27 15:00:00 | MSFT | Stock | 419.4 | 422.05 | 419.01 | 421.48 | 2017413.0 |
| 2024-03-27 16:00:00 | MSFT | Stock | 421.43 | 422.02 | 421.43 | 421.73 | 3757329.0 |
| 2024-03-27 17:00:00 | MSFT | Stock | 421.65 | 421.65 | 421.49 | 421.65 | 3649.0 |
| 2024-03-27 18:00:00 | MSFT | Stock | 421.52 | 421.52 | 420.95 | 420.9596 | 3934.0 |
| 2024-03-27 19:00:00 | MSFT | Stock | 421.03 | 421.23 | 420.96 | 421.05 | 6450.0 |
| 2024-03-27 04:00:00 | NVDA | Stock | 92.816 | 93.65 | 92.797 | 93.45 | 284270.0 |
| 2024-03-27 05:00:00 | NVDA | Stock | 93.497 | 93.55 | 93.15 | 93.25 | 90050.0 |
| 2024-03-27 06:00:00 | NVDA | Stock | 93.3 | 93.5 | 93.29 | 93.387 | 76690.0 |
| 2024-03-27 07:00:00 | NVDA | Stock | 93.41 | 93.41 | 92.9 | 92.9 | 755780.0 |
| 2024-03-27 08:00:00 | NVDA | Stock | 93.263 | 93.4 | 92.759 | 93.05 | 1949790.0 |
| 2024-03-27 09:00:00 | NVDA | Stock | 93.068 | 93.24 | 90.118 | 90.2 | 80942660.0 |
| 2024-03-27 10:00:00 | NVDA | Stock | 90.191 | 90.485 | 89.123 | 90.052 | 100382510.0 |
| 2024-03-27 11:00:00 | NVDA | Stock | 90.056 | 90.228 | 89.313 | 89.786 | 45154520.0 |
| 2024-03-27 12:00:00 | NVDA | Stock | 89.7803 | 90.439 | 89.727 | 90.226 | 39112500.0 |
| 2024-03-27 13:00:00 | NVDA | Stock | 90.232 | 90.699 | 89.9331 | 90.5696 | 32821670.0 |
| 2024-03-27 14:00:00 | NVDA | Stock | 90.5799 | 90.599 | 89.5102 | 89.7448 | 39775450.0 |
| 2024-03-27 15:00:00 | NVDA | Stock | 89.764 | 90.54 | 89.135 | 90.256 | 64435480.0 |
| 2024-03-27 16:00:00 | NVDA | Stock | 90.25 | 90.566 | 90.06 | 90.101 | 21321900.0 |
| 2024-03-27 17:00:00 | NVDA | Stock | 90.113 | 90.2 | 90.0187 | 90.13 | 392100.0 |
| 2024-03-27 18:00:00 | NVDA | Stock | 90.141 | 90.25 | 89.93 | 89.983 | 564880.0 |
| 2024-03-27 19:00:00 | NVDA | Stock | 89.99 | 90.038 | 89.888 | 89.89 | 471830.0 |
| 2024-03-27 04:00:00 | AMZN | Stock | 179.03 | 179.1 | 178.96 | 179.1 | 3700.0 |
| 2024-03-27 05:00:00 | AMZN | Stock | 179.08 | 179.08 | 178.75 | 178.94 | 3444.0 |
> showing 50 of 59,646 rows — these rows as CSV