PREVIEW / stock_1hour / 2025-03-31
file: by_date/stock_1hour/2025/2025-03-31.parquet size: 1.4 MB rows: 63,486 symbols: 468
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-31 04:00:00 | AAPL | Stock | 215.74 | 216.85 | 215.0 | 215.93 | 34267.0 |
| 2025-03-31 05:00:00 | AAPL | Stock | 215.78 | 216.32 | 215.38 | 216.0 | 15704.0 |
| 2025-03-31 06:00:00 | AAPL | Stock | 216.07 | 216.75 | 216.05 | 216.32 | 33476.0 |
| 2025-03-31 07:00:00 | AAPL | Stock | 216.27 | 216.79 | 215.9 | 216.71 | 62038.0 |
| 2025-03-31 08:00:00 | AAPL | Stock | 216.25 | 217.9 | 215.33 | 217.1091 | 184738.0 |
| 2025-03-31 09:00:00 | AAPL | Stock | 217.11 | 218.5 | 215.5 | 217.11 | 7250753.0 |
| 2025-03-31 10:00:00 | AAPL | Stock | 217.14 | 219.69 | 217.01 | 219.25 | 4613869.0 |
| 2025-03-31 11:00:00 | AAPL | Stock | 219.28 | 220.58 | 218.8852 | 220.35 | 3499425.0 |
| 2025-03-31 12:00:00 | AAPL | Stock | 220.36 | 221.02 | 219.56 | 220.1 | 2438013.0 |
| 2025-03-31 13:00:00 | AAPL | Stock | 220.09 | 220.76 | 219.24 | 219.49 | 1969515.0 |
| 2025-03-31 14:00:00 | AAPL | Stock | 219.49 | 221.21 | 219.455 | 220.58 | 2490654.0 |
| 2025-03-31 15:00:00 | AAPL | Stock | 220.57 | 225.62 | 220.55 | 221.995 | 10578534.0 |
| 2025-03-31 16:00:00 | AAPL | Stock | 222.13 | 222.99 | 221.45 | 221.7404 | 15834426.0 |
| 2025-03-31 17:00:00 | AAPL | Stock | 221.7996 | 222.13 | 221.42 | 221.51 | 38762.0 |
| 2025-03-31 18:00:00 | AAPL | Stock | 221.51 | 221.55 | 220.81 | 221.2836 | 15647.0 |
| 2025-03-31 19:00:00 | AAPL | Stock | 221.33 | 221.7 | 221.08 | 221.1999 | 15687.0 |
| 2025-03-31 04:00:00 | MSFT | Stock | 373.94 | 376.41 | 373.27 | 373.42 | 10553.0 |
| 2025-03-31 05:00:00 | MSFT | Stock | 372.53 | 373.35 | 372.37 | 372.52 | 7610.0 |
| 2025-03-31 06:00:00 | MSFT | Stock | 372.52 | 373.4 | 372.25 | 373.22 | 12816.0 |
| 2025-03-31 07:00:00 | MSFT | Stock | 373.42 | 374.05 | 372.36 | 372.6 | 26068.0 |
| 2025-03-31 08:00:00 | MSFT | Stock | 373.51 | 377.853 | 372.18 | 374.0 | 55905.0 |
| 2025-03-31 09:00:00 | MSFT | Stock | 374.0 | 374.0 | 368.29 | 370.44 | 2912035.0 |
| 2025-03-31 10:00:00 | MSFT | Stock | 370.465 | 371.1 | 367.24 | 368.1 | 2036838.0 |
| 2025-03-31 11:00:00 | MSFT | Stock | 368.11 | 371.8 | 367.7 | 370.96 | 1614966.0 |
| 2025-03-31 12:00:00 | MSFT | Stock | 370.9336 | 372.1799 | 369.78 | 369.84 | 963503.0 |
| 2025-03-31 13:00:00 | MSFT | Stock | 369.84 | 372.43 | 369.68 | 370.44 | 1405725.0 |
| 2025-03-31 14:00:00 | MSFT | Stock | 370.45 | 373.04 | 370.35 | 371.93 | 1119929.0 |
| 2025-03-31 15:00:00 | MSFT | Stock | 371.94 | 377.07 | 371.86 | 374.87 | 4220372.0 |
| 2025-03-31 16:00:00 | MSFT | Stock | 374.87 | 376.41 | 374.52 | 375.49 | 9006961.0 |
| 2025-03-31 17:00:00 | MSFT | Stock | 375.48 | 375.5815 | 375.01 | 375.02 | 36540.0 |
| 2025-03-31 18:00:00 | MSFT | Stock | 375.02 | 375.02 | 373.71 | 374.0 | 6558.0 |
| 2025-03-31 19:00:00 | MSFT | Stock | 374.26 | 374.5 | 373.7 | 373.9936 | 8607.0 |
| 2025-03-31 04:00:00 | NVDA | Stock | 106.48 | 107.5 | 105.88 | 106.01 | 827651.0 |
| 2025-03-31 05:00:00 | NVDA | Stock | 106.0 | 106.2 | 105.59 | 105.8 | 462056.0 |
| 2025-03-31 06:00:00 | NVDA | Stock | 105.8 | 106.03 | 105.25 | 105.77 | 455294.0 |
| 2025-03-31 07:00:00 | NVDA | Stock | 105.79 | 106.0 | 104.7 | 105.01 | 1630682.0 |
| 2025-03-31 08:00:00 | NVDA | Stock | 105.0 | 109.396 | 104.7 | 105.88 | 3878404.0 |
| 2025-03-31 09:00:00 | NVDA | Stock | 105.9 | 106.13 | 103.65 | 104.8001 | 42986033.0 |
| 2025-03-31 10:00:00 | NVDA | Stock | 104.8 | 106.01 | 103.7701 | 104.6801 | 39663798.0 |
| 2025-03-31 11:00:00 | NVDA | Stock | 104.69 | 105.67 | 104.35 | 105.175 | 28379027.0 |
| 2025-03-31 12:00:00 | NVDA | Stock | 105.18 | 106.25 | 104.77 | 105.375 | 19608416.0 |
| 2025-03-31 13:00:00 | NVDA | Stock | 105.38 | 106.16 | 105.31 | 105.64 | 14007594.0 |
| 2025-03-31 14:00:00 | NVDA | Stock | 105.64 | 108.14 | 105.6 | 107.1801 | 28053379.0 |
| 2025-03-31 15:00:00 | NVDA | Stock | 107.185 | 108.96 | 107.12 | 108.77 | 37611190.0 |
| 2025-03-31 16:00:00 | NVDA | Stock | 108.765 | 108.77 | 106.0304 | 107.9105 | 27200871.0 |
| 2025-03-31 17:00:00 | NVDA | Stock | 107.93 | 107.94 | 107.7 | 107.9 | 249291.0 |
| 2025-03-31 18:00:00 | NVDA | Stock | 107.9 | 107.9 | 107.56 | 107.75 | 267892.0 |
| 2025-03-31 19:00:00 | NVDA | Stock | 107.73 | 107.87 | 107.37 | 107.5195 | 317742.0 |
| 2025-03-31 04:00:00 | AMZN | Stock | 191.35 | 191.7 | 189.0 | 189.2 | 60376.0 |
| 2025-03-31 05:00:00 | AMZN | Stock | 189.1 | 189.4 | 188.61 | 189.29 | 55013.0 |
> showing 50 of 63,486 rows — these rows as CSV