PREVIEW / stock_1hour / 2024-12-20
file: by_date/stock_1hour/2024/2024-12-20.parquet size: 1.5 MB rows: 65,677 symbols: 663
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-12-20 04:00:00 | AAPL | Stock | 248.01 | 248.29 | 247.17 | 247.52 | 31364.0 |
| 2024-12-20 05:00:00 | AAPL | Stock | 247.37 | 248.14 | 247.34 | 247.64 | 30906.0 |
| 2024-12-20 06:00:00 | AAPL | Stock | 247.6 | 247.8 | 247.34 | 247.45 | 25199.0 |
| 2024-12-20 07:00:00 | AAPL | Stock | 247.48 | 247.9 | 246.74 | 246.99 | 86235.0 |
| 2024-12-20 08:00:00 | AAPL | Stock | 246.95 | 248.71 | 246.75 | 247.68 | 196588.0 |
| 2024-12-20 09:00:00 | AAPL | Stock | 247.69 | 248.91 | 245.69 | 246.8313 | 12752168.0 |
| 2024-12-20 10:00:00 | AAPL | Stock | 246.85 | 250.39 | 246.81 | 249.95 | 4000134.0 |
| 2024-12-20 11:00:00 | AAPL | Stock | 249.985 | 253.39 | 249.86 | 253.115 | 4992594.0 |
| 2024-12-20 12:00:00 | AAPL | Stock | 253.115 | 253.93 | 252.97 | 253.3559 | 3412848.0 |
| 2024-12-20 13:00:00 | AAPL | Stock | 253.3608 | 253.46 | 252.7 | 252.865 | 3020603.0 |
| 2024-12-20 14:00:00 | AAPL | Stock | 252.84 | 253.82 | 252.68 | 253.6028 | 2473777.0 |
| 2024-12-20 15:00:00 | AAPL | Stock | 253.61 | 255.0 | 252.51 | 254.6 | 9186391.0 |
| 2024-12-20 16:00:00 | AAPL | Stock | 254.59 | 255.06 | 254.4895 | 254.95 | 42606162.0 |
| 2024-12-20 17:00:00 | AAPL | Stock | 254.95 | 255.1 | 254.78 | 255.0018 | 60771.0 |
| 2024-12-20 18:00:00 | AAPL | Stock | 255.0013 | 255.57 | 254.49 | 255.31 | 262646.0 |
| 2024-12-20 19:00:00 | AAPL | Stock | 255.31 | 255.53 | 254.49 | 255.35 | 56332.0 |
| 2024-12-20 04:00:00 | MSFT | Stock | 434.3 | 434.3 | 430.75 | 431.96 | 14938.0 |
| 2024-12-20 05:00:00 | MSFT | Stock | 432.21 | 432.42 | 431.35 | 431.38 | 9707.0 |
| 2024-12-20 06:00:00 | MSFT | Stock | 431.33 | 431.52 | 431.0 | 431.52 | 6273.0 |
| 2024-12-20 07:00:00 | MSFT | Stock | 431.69 | 432.55 | 431.35 | 432.51 | 38243.0 |
| 2024-12-20 08:00:00 | MSFT | Stock | 431.61 | 435.938 | 431.27 | 433.4 | 49041.0 |
| 2024-12-20 09:00:00 | MSFT | Stock | 433.3 | 434.73 | 428.63 | 429.11 | 5903215.0 |
| 2024-12-20 10:00:00 | MSFT | Stock | 429.3 | 436.95 | 429.24 | 436.04 | 1669072.0 |
| 2024-12-20 11:00:00 | MSFT | Stock | 436.04 | 442.94 | 435.9353 | 442.03 | 1514482.0 |
| 2024-12-20 12:00:00 | MSFT | Stock | 442.09 | 443.74 | 441.51 | 441.5322 | 1200374.0 |
| 2024-12-20 13:00:00 | MSFT | Stock | 441.52 | 441.91 | 439.08 | 439.21 | 1205561.0 |
| 2024-12-20 14:00:00 | MSFT | Stock | 439.1905 | 440.12 | 437.77 | 437.95 | 1007581.0 |
| 2024-12-20 15:00:00 | MSFT | Stock | 437.995 | 438.13 | 434.84 | 436.97 | 2492601.0 |
| 2024-12-20 16:00:00 | MSFT | Stock | 436.6 | 438.1223 | 435.1001 | 435.6 | 17797111.0 |
| 2024-12-20 17:00:00 | MSFT | Stock | 435.67 | 436.6 | 435.34 | 436.6 | 11348.0 |
| 2024-12-20 18:00:00 | MSFT | Stock | 436.7995 | 437.3376 | 436.6 | 436.9 | 7367.0 |
| 2024-12-20 19:00:00 | MSFT | Stock | 436.97 | 437.3476 | 436.6 | 437.3476 | 14107.0 |
| 2024-12-20 04:00:00 | NVDA | Stock | 129.0 | 129.69 | 127.21 | 127.36 | 963966.0 |
| 2024-12-20 05:00:00 | NVDA | Stock | 127.4 | 128.13 | 127.27 | 127.6 | 532632.0 |
| 2024-12-20 06:00:00 | NVDA | Stock | 127.62 | 127.9 | 126.35 | 127.22 | 705250.0 |
| 2024-12-20 07:00:00 | NVDA | Stock | 127.25 | 127.53 | 126.6 | 127.53 | 1260768.0 |
| 2024-12-20 08:00:00 | NVDA | Stock | 127.3 | 130.72 | 126.44 | 130.08 | 4573146.0 |
| 2024-12-20 09:00:00 | NVDA | Stock | 130.06 | 130.19 | 128.22 | 129.675 | 35171887.0 |
| 2024-12-20 10:00:00 | NVDA | Stock | 129.69 | 133.54 | 129.62 | 132.9453 | 29626294.0 |
| 2024-12-20 11:00:00 | NVDA | Stock | 132.96 | 134.8 | 132.8 | 134.3523 | 22236086.0 |
| 2024-12-20 12:00:00 | NVDA | Stock | 134.36 | 135.28 | 133.97 | 134.45 | 18021867.0 |
| 2024-12-20 13:00:00 | NVDA | Stock | 134.45 | 134.6 | 133.54 | 134.1154 | 15764335.0 |
| 2024-12-20 14:00:00 | NVDA | Stock | 134.09 | 135.03 | 133.95 | 134.4 | 13837245.0 |
| 2024-12-20 15:00:00 | NVDA | Stock | 134.41 | 135.02 | 132.9 | 134.97 | 28295474.0 |
| 2024-12-20 16:00:00 | NVDA | Stock | 134.97 | 135.04 | 134.31 | 134.65 | 57284183.0 |
| 2024-12-20 17:00:00 | NVDA | Stock | 134.64 | 135.28 | 134.58 | 135.26 | 602276.0 |
| 2024-12-20 18:00:00 | NVDA | Stock | 135.28 | 135.6 | 135.1 | 135.59 | 493612.0 |
| 2024-12-20 19:00:00 | NVDA | Stock | 135.58 | 135.88 | 135.16 | 135.24 | 593354.0 |
| 2024-12-20 04:00:00 | AMZN | Stock | 220.31 | 220.5 | 218.72 | 218.92 | 49974.0 |
| 2024-12-20 05:00:00 | AMZN | Stock | 218.84 | 219.28 | 218.0 | 218.78 | 66273.0 |
> showing 50 of 65,677 rows — these rows as CSV