PREVIEW / stock_1hour / 2024-02-21
file: by_date/stock_1hour/2024/2024-02-21.parquet size: 1.3 MB rows: 59,763 symbols: 1,127
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-21 04:00:00 | AAPL | Stock | 181.55 | 181.55 | 180.85 | 181.03 | 9959.0 |
| 2024-02-21 05:00:00 | AAPL | Stock | 181.03 | 181.77 | 181.03 | 181.76 | 12235.0 |
| 2024-02-21 06:00:00 | AAPL | Stock | 181.76 | 181.77 | 181.5 | 181.5 | 10862.0 |
| 2024-02-21 07:00:00 | AAPL | Stock | 181.5 | 181.97 | 181.39 | 181.6 | 38739.0 |
| 2024-02-21 08:00:00 | AAPL | Stock | 181.66 | 181.95 | 181.2449 | 181.79 | 87487.0 |
| 2024-02-21 09:00:00 | AAPL | Stock | 181.8 | 182.8888 | 181.45 | 182.54 | 4721489.0 |
| 2024-02-21 10:00:00 | AAPL | Stock | 182.54 | 182.85 | 182.13 | 182.16 | 4344399.0 |
| 2024-02-21 11:00:00 | AAPL | Stock | 182.16 | 182.59 | 181.98 | 182.12 | 3232142.0 |
| 2024-02-21 12:00:00 | AAPL | Stock | 182.12 | 182.125 | 181.18 | 181.5399 | 2759113.0 |
| 2024-02-21 13:00:00 | AAPL | Stock | 181.53 | 181.725 | 181.06 | 181.2935 | 2578670.0 |
| 2024-02-21 14:00:00 | AAPL | Stock | 181.2921 | 181.47 | 180.66 | 181.02 | 3406264.0 |
| 2024-02-21 15:00:00 | AAPL | Stock | 181.01 | 182.39 | 180.96 | 182.32 | 5551561.0 |
| 2024-02-21 16:00:00 | AAPL | Stock | 182.33 | 182.66 | 181.55 | 182.55 | 4464599.0 |
| 2024-02-21 17:00:00 | AAPL | Stock | 182.59 | 182.59 | 182.1 | 182.37 | 88709.0 |
| 2024-02-21 18:00:00 | AAPL | Stock | 182.56 | 182.79 | 182.11 | 182.47 | 447428.0 |
| 2024-02-21 19:00:00 | AAPL | Stock | 182.47 | 182.98 | 182.42 | 182.98 | 64965.0 |
| 2024-02-21 04:00:00 | MSFT | Stock | 400.86 | 401.64 | 400.86 | 401.02 | 3117.0 |
| 2024-02-21 05:00:00 | MSFT | Stock | 401.19 | 401.78 | 401.02 | 401.02 | 1716.0 |
| 2024-02-21 06:00:00 | MSFT | Stock | 401.26 | 401.26 | 400.63 | 400.63 | 887.0 |
| 2024-02-21 07:00:00 | MSFT | Stock | 400.89 | 400.89 | 399.7 | 399.72 | 7776.0 |
| 2024-02-21 08:00:00 | MSFT | Stock | 400.89 | 401.18 | 399.67 | 399.94 | 25412.0 |
| 2024-02-21 09:00:00 | MSFT | Stock | 399.99 | 400.49 | 397.22 | 398.81 | 2090256.0 |
| 2024-02-21 10:00:00 | MSFT | Stock | 398.81 | 400.47 | 398.73 | 399.79 | 1334904.0 |
| 2024-02-21 11:00:00 | MSFT | Stock | 399.766 | 400.71 | 399.174 | 400.02 | 883375.0 |
| 2024-02-21 12:00:00 | MSFT | Stock | 400.05 | 400.16 | 398.71 | 399.58 | 677051.0 |
| 2024-02-21 13:00:00 | MSFT | Stock | 399.57 | 400.0 | 398.61 | 399.02 | 815331.0 |
| 2024-02-21 14:00:00 | MSFT | Stock | 399.01 | 399.98 | 397.56 | 398.76 | 995419.0 |
| 2024-02-21 15:00:00 | MSFT | Stock | 398.77 | 402.29 | 398.14 | 402.18 | 1992805.0 |
| 2024-02-21 16:00:00 | MSFT | Stock | 402.18 | 403.85 | 400.0169 | 402.78 | 3246657.0 |
| 2024-02-21 17:00:00 | MSFT | Stock | 402.82 | 404.01 | 402.7 | 403.35 | 127674.0 |
| 2024-02-21 18:00:00 | MSFT | Stock | 403.25 | 403.5 | 403.0 | 403.45 | 27100.0 |
| 2024-02-21 19:00:00 | MSFT | Stock | 403.5 | 405.0 | 403.5 | 404.85 | 44959.0 |
| 2024-02-21 04:00:00 | NVDA | Stock | 68.131 | 68.58 | 67.879 | 68.4 | 543550.0 |
| 2024-02-21 05:00:00 | NVDA | Stock | 68.47 | 68.59 | 68.301 | 68.45 | 156450.0 |
| 2024-02-21 06:00:00 | NVDA | Stock | 68.425 | 68.48 | 68.19 | 68.48 | 211240.0 |
| 2024-02-21 07:00:00 | NVDA | Stock | 68.4 | 68.463 | 67.95 | 68.23 | 1201490.0 |
| 2024-02-21 08:00:00 | NVDA | Stock | 68.44 | 68.579 | 67.949 | 68.256 | 2885510.0 |
| 2024-02-21 09:00:00 | NVDA | Stock | 68.25 | 68.888 | 67.615 | 68.139 | 59528460.0 |
| 2024-02-21 10:00:00 | NVDA | Stock | 68.18 | 68.44 | 67.766 | 68.0037 | 49042750.0 |
| 2024-02-21 11:00:00 | NVDA | Stock | 67.987 | 68.335 | 67.788 | 67.979 | 33017330.0 |
| 2024-02-21 12:00:00 | NVDA | Stock | 67.978 | 68.025 | 66.613 | 67.371 | 59312210.0 |
| 2024-02-21 13:00:00 | NVDA | Stock | 67.3679 | 67.382 | 66.8695 | 67.038 | 32261940.0 |
| 2024-02-21 14:00:00 | NVDA | Stock | 67.046 | 67.495 | 66.674 | 66.7736 | 42490400.0 |
| 2024-02-21 15:00:00 | NVDA | Stock | 66.766 | 67.6 | 66.248 | 67.485 | 85525220.0 |
| 2024-02-21 16:00:00 | NVDA | Stock | 67.472 | 74.339 | 64.5 | 74.308 | 64229900.0 |
| 2024-02-21 17:00:00 | NVDA | Stock | 74.358 | 74.599 | 71.65 | 72.601 | 22679430.0 |
| 2024-02-21 18:00:00 | NVDA | Stock | 72.56 | 73.154 | 72.3 | 73.057 | 5209370.0 |
| 2024-02-21 19:00:00 | NVDA | Stock | 73.041 | 73.75 | 72.952 | 73.594 | 6888910.0 |
| 2024-02-21 04:00:00 | AMZN | Stock | 168.95 | 169.45 | 168.61 | 169.07 | 18519.0 |
| 2024-02-21 05:00:00 | AMZN | Stock | 169.18 | 169.33 | 168.87 | 169.27 | 34764.0 |
> showing 50 of 59,763 rows — these rows as CSV