PREVIEW / stock_1hour / 2024-02-16
file: by_date/stock_1hour/2024/2024-02-16.parquet size: 1.4 MB rows: 60,039 symbols: 1,116
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-16 04:00:00 | AAPL | Stock | 184.69 | 184.87 | 184.42 | 184.7 | 22672.0 |
| 2024-02-16 05:00:00 | AAPL | Stock | 184.74 | 185.4 | 184.74 | 185.25 | 22894.0 |
| 2024-02-16 06:00:00 | AAPL | Stock | 185.25 | 185.33 | 184.41 | 184.53 | 42106.0 |
| 2024-02-16 07:00:00 | AAPL | Stock | 184.55 | 184.55 | 184.0 | 184.01 | 61639.0 |
| 2024-02-16 08:00:00 | AAPL | Stock | 184.17 | 184.55 | 182.52 | 182.99 | 489611.0 |
| 2024-02-16 09:00:00 | AAPL | Stock | 182.95 | 184.85 | 182.27 | 182.3 | 6846733.0 |
| 2024-02-16 10:00:00 | AAPL | Stock | 182.3 | 183.36 | 181.86 | 183.0599 | 6953571.0 |
| 2024-02-16 11:00:00 | AAPL | Stock | 183.06 | 183.4473 | 182.84 | 183.1 | 3415250.0 |
| 2024-02-16 12:00:00 | AAPL | Stock | 183.09 | 183.15 | 182.635 | 182.74 | 2390186.0 |
| 2024-02-16 13:00:00 | AAPL | Stock | 182.7314 | 182.91 | 182.48 | 182.8972 | 3044924.0 |
| 2024-02-16 14:00:00 | AAPL | Stock | 182.9 | 183.1975 | 182.03 | 182.1999 | 3271738.0 |
| 2024-02-16 15:00:00 | AAPL | Stock | 182.19 | 182.42 | 181.665 | 182.29 | 5936549.0 |
| 2024-02-16 16:00:00 | AAPL | Stock | 182.31 | 182.31 | 181.9605 | 182.13 | 6674353.0 |
| 2024-02-16 17:00:00 | AAPL | Stock | 182.1393 | 182.19 | 182.08 | 182.0817 | 31221.0 |
| 2024-02-16 18:00:00 | AAPL | Stock | 182.11 | 182.18 | 182.0315 | 182.05 | 16033.0 |
| 2024-02-16 19:00:00 | AAPL | Stock | 182.06 | 182.1 | 181.91 | 181.95 | 20116.0 |
| 2024-02-16 04:00:00 | MSFT | Stock | 408.8 | 408.8 | 407.56 | 408.46 | 8930.0 |
| 2024-02-16 05:00:00 | MSFT | Stock | 408.49 | 408.6 | 408.17 | 408.5 | 6634.0 |
| 2024-02-16 06:00:00 | MSFT | Stock | 408.47 | 408.55 | 408.33 | 408.55 | 3482.0 |
| 2024-02-16 07:00:00 | MSFT | Stock | 408.55 | 408.6 | 407.13 | 408.1 | 43646.0 |
| 2024-02-16 08:00:00 | MSFT | Stock | 408.46 | 408.6 | 406.06 | 406.9 | 108299.0 |
| 2024-02-16 09:00:00 | MSFT | Stock | 406.87 | 408.35 | 403.53 | 404.68 | 2889778.0 |
| 2024-02-16 10:00:00 | MSFT | Stock | 404.63 | 405.76 | 403.57 | 405.66 | 1666781.0 |
| 2024-02-16 11:00:00 | MSFT | Stock | 405.67 | 406.52 | 405.16 | 405.99 | 984502.0 |
| 2024-02-16 12:00:00 | MSFT | Stock | 405.97 | 406.205 | 405.48 | 405.7295 | 651708.0 |
| 2024-02-16 13:00:00 | MSFT | Stock | 405.7 | 406.3448 | 404.755 | 406.3358 | 724371.0 |
| 2024-02-16 14:00:00 | MSFT | Stock | 406.34 | 407.45 | 404.445 | 404.808 | 1119798.0 |
| 2024-02-16 15:00:00 | MSFT | Stock | 404.82 | 405.0 | 403.44 | 404.06 | 1985947.0 |
| 2024-02-16 16:00:00 | MSFT | Stock | 404.06 | 404.06 | 403.5 | 403.79 | 3075670.0 |
| 2024-02-16 17:00:00 | MSFT | Stock | 404.06 | 404.06 | 403.51 | 403.51 | 125664.0 |
| 2024-02-16 18:00:00 | MSFT | Stock | 403.51 | 403.52 | 403.35 | 403.36 | 10037.0 |
| 2024-02-16 19:00:00 | MSFT | Stock | 403.36 | 403.3899 | 403.15 | 403.25 | 2801.0 |
| 2024-02-16 04:00:00 | NVDA | Stock | 73.2 | 73.775 | 73.2 | 73.71 | 513560.0 |
| 2024-02-16 05:00:00 | NVDA | Stock | 73.717 | 73.92 | 73.71 | 73.851 | 283170.0 |
| 2024-02-16 06:00:00 | NVDA | Stock | 73.838 | 73.99 | 73.795 | 73.828 | 204400.0 |
| 2024-02-16 07:00:00 | NVDA | Stock | 73.806 | 73.85 | 73.63 | 73.8 | 1013040.0 |
| 2024-02-16 08:00:00 | NVDA | Stock | 73.753 | 74.224 | 73.11 | 74.101 | 6132170.0 |
| 2024-02-16 09:00:00 | NVDA | Stock | 74.115 | 74.402 | 72.718 | 72.9849 | 73535960.0 |
| 2024-02-16 10:00:00 | NVDA | Stock | 72.976 | 73.485 | 72.504 | 73.2675 | 63821810.0 |
| 2024-02-16 11:00:00 | NVDA | Stock | 73.28 | 74.137 | 73.225 | 73.875 | 47915820.0 |
| 2024-02-16 12:00:00 | NVDA | Stock | 73.874 | 73.991 | 73.7 | 73.817 | 21688430.0 |
| 2024-02-16 13:00:00 | NVDA | Stock | 73.8158 | 73.823 | 73.0411 | 73.7605 | 39231850.0 |
| 2024-02-16 14:00:00 | NVDA | Stock | 73.767 | 74.095 | 73.2 | 73.4 | 40048870.0 |
| 2024-02-16 15:00:00 | NVDA | Stock | 73.403 | 73.451 | 72.501 | 72.6005 | 55119530.0 |
| 2024-02-16 16:00:00 | NVDA | Stock | 72.6005 | 72.742 | 72.5 | 72.572 | 15432270.0 |
| 2024-02-16 17:00:00 | NVDA | Stock | 72.565 | 72.73 | 72.53 | 72.69 | 471020.0 |
| 2024-02-16 18:00:00 | NVDA | Stock | 72.698 | 72.77 | 72.639 | 72.72 | 549550.0 |
| 2024-02-16 19:00:00 | NVDA | Stock | 72.73 | 72.768 | 72.703 | 72.72 | 463440.0 |
| 2024-02-16 04:00:00 | AMZN | Stock | 170.1 | 170.39 | 169.79 | 170.25 | 12047.0 |
| 2024-02-16 05:00:00 | AMZN | Stock | 170.28 | 170.49 | 170.21 | 170.41 | 10103.0 |
> showing 50 of 60,039 rows — these rows as CSV