PREVIEW / stock_1hour / 2025-03-05
file: by_date/stock_1hour/2025/2025-03-05.parquet size: 1.4 MB rows: 62,418 symbols: 509
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 |
|---|---|---|---|---|---|---|---|
| 2025-03-05 04:00:00 | AAPL | Stock | 237.76 | 237.76 | 236.95 | 237.55 | 19374.0 |
| 2025-03-05 05:00:00 | AAPL | Stock | 237.58 | 237.58 | 236.93 | 236.97 | 10684.0 |
| 2025-03-05 06:00:00 | AAPL | Stock | 236.96 | 237.05 | 236.19 | 236.62 | 11506.0 |
| 2025-03-05 07:00:00 | AAPL | Stock | 236.72 | 236.93 | 236.32 | 236.45 | 11327.0 |
| 2025-03-05 08:00:00 | AAPL | Stock | 236.75 | 237.72 | 235.93 | 236.2801 | 99204.0 |
| 2025-03-05 09:00:00 | AAPL | Stock | 236.29 | 236.6996 | 231.04 | 231.77 | 5202729.0 |
| 2025-03-05 10:00:00 | AAPL | Stock | 231.83 | 233.25 | 230.52 | 232.57 | 5252676.0 |
| 2025-03-05 11:00:00 | AAPL | Stock | 232.565 | 232.63 | 229.23 | 232.2 | 4622636.0 |
| 2025-03-05 12:00:00 | AAPL | Stock | 232.2 | 235.4 | 232.14 | 234.945 | 3538286.0 |
| 2025-03-05 13:00:00 | AAPL | Stock | 234.945 | 235.85 | 234.02 | 235.82 | 2446355.0 |
| 2025-03-05 14:00:00 | AAPL | Stock | 235.835 | 236.55 | 235.15 | 235.49 | 2018020.0 |
| 2025-03-05 15:00:00 | AAPL | Stock | 235.47 | 236.48 | 235.06 | 235.82 | 4077649.0 |
| 2025-03-05 16:00:00 | AAPL | Stock | 235.78 | 236.19 | 235.22 | 236.03 | 5696329.0 |
| 2025-03-05 17:00:00 | AAPL | Stock | 236.03 | 236.3 | 236.0 | 236.1 | 22074.0 |
| 2025-03-05 18:00:00 | AAPL | Stock | 236.1 | 236.41 | 235.74 | 235.74 | 20998.0 |
| 2025-03-05 19:00:00 | AAPL | Stock | 235.74 | 236.29 | 235.5 | 235.7823 | 7226.0 |
| 2025-03-05 04:00:00 | MSFT | Stock | 391.2 | 391.74 | 390.45 | 391.2 | 10847.0 |
| 2025-03-05 05:00:00 | MSFT | Stock | 391.2 | 391.2 | 390.41 | 390.64 | 1529.0 |
| 2025-03-05 06:00:00 | MSFT | Stock | 390.29 | 390.78 | 390.0 | 390.0 | 6003.0 |
| 2025-03-05 07:00:00 | MSFT | Stock | 389.88 | 390.5 | 389.46 | 389.75 | 7847.0 |
| 2025-03-05 08:00:00 | MSFT | Stock | 389.72 | 391.2 | 388.8925 | 389.0001 | 32208.0 |
| 2025-03-05 09:00:00 | MSFT | Stock | 388.88 | 392.31 | 388.5529 | 389.15 | 1564548.0 |
| 2025-03-05 10:00:00 | MSFT | Stock | 389.88 | 393.36 | 389.31 | 392.5 | 1453137.0 |
| 2025-03-05 11:00:00 | MSFT | Stock | 392.49 | 392.75 | 390.12 | 392.12 | 1063729.0 |
| 2025-03-05 12:00:00 | MSFT | Stock | 392.1 | 396.95 | 392.04 | 396.91 | 1310443.0 |
| 2025-03-05 13:00:00 | MSFT | Stock | 396.935 | 397.17 | 394.25 | 396.7 | 1133966.0 |
| 2025-03-05 14:00:00 | MSFT | Stock | 396.7 | 399.99 | 396.2565 | 399.82 | 1865825.0 |
| 2025-03-05 15:00:00 | MSFT | Stock | 399.835 | 401.67 | 398.88 | 401.1 | 3146758.0 |
| 2025-03-05 16:00:00 | MSFT | Stock | 401.1 | 401.1 | 399.28 | 400.15 | 4060633.0 |
| 2025-03-05 17:00:00 | MSFT | Stock | 400.39 | 400.55 | 400.1524 | 400.3501 | 5427.0 |
| 2025-03-05 18:00:00 | MSFT | Stock | 400.35 | 401.02 | 400.0 | 400.0 | 9956.0 |
| 2025-03-05 19:00:00 | MSFT | Stock | 400.0 | 400.98 | 400.0 | 400.0322 | 6481.0 |
| 2025-03-05 04:00:00 | NVDA | Stock | 119.0 | 119.19 | 118.02 | 118.49 | 586754.0 |
| 2025-03-05 05:00:00 | NVDA | Stock | 118.48 | 118.53 | 117.46 | 117.89 | 537364.0 |
| 2025-03-05 06:00:00 | NVDA | Stock | 117.93 | 118.21 | 117.08 | 117.51 | 571793.0 |
| 2025-03-05 07:00:00 | NVDA | Stock | 117.59 | 118.1 | 117.39 | 117.7 | 809035.0 |
| 2025-03-05 08:00:00 | NVDA | Stock | 117.75 | 119.22 | 116.65 | 116.66 | 3028251.0 |
| 2025-03-05 09:00:00 | NVDA | Stock | 116.65 | 118.0 | 114.64 | 115.15 | 37074073.0 |
| 2025-03-05 10:00:00 | NVDA | Stock | 115.16 | 117.0 | 114.7 | 115.92 | 37382344.0 |
| 2025-03-05 11:00:00 | NVDA | Stock | 115.9 | 116.4 | 114.51 | 115.89 | 28513070.0 |
| 2025-03-05 12:00:00 | NVDA | Stock | 115.88 | 117.91 | 115.45 | 117.735 | 24655339.0 |
| 2025-03-05 13:00:00 | NVDA | Stock | 117.72 | 117.91 | 115.82 | 117.33 | 23473721.0 |
| 2025-03-05 14:00:00 | NVDA | Stock | 117.32 | 118.23 | 116.73 | 117.5145 | 22080641.0 |
| 2025-03-05 15:00:00 | NVDA | Stock | 117.5 | 118.2781 | 116.76 | 117.3 | 29938998.0 |
| 2025-03-05 16:00:00 | NVDA | Stock | 117.29 | 117.8 | 116.44 | 117.1801 | 17893765.0 |
| 2025-03-05 17:00:00 | NVDA | Stock | 117.18 | 117.22 | 116.7993 | 116.7993 | 381712.0 |
| 2025-03-05 18:00:00 | NVDA | Stock | 116.78 | 116.93 | 116.6 | 116.65 | 349052.0 |
| 2025-03-05 19:00:00 | NVDA | Stock | 116.65 | 116.82 | 116.5 | 116.5199 | 313865.0 |
| 2025-03-05 04:00:00 | AMZN | Stock | 206.49 | 206.79 | 205.72 | 206.54 | 18801.0 |
| 2025-03-05 05:00:00 | AMZN | Stock | 206.67 | 206.67 | 205.64 | 205.78 | 14293.0 |
> showing 50 of 62,418 rows — these rows as CSV