PREVIEW / stock_1hour / 2024-03-14
file: by_date/stock_1hour/2024/2024-03-14.parquet size: 1.3 MB rows: 59,778 symbols: 1,072
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-03-14 04:00:00 | AAPL | Stock | 171.6 | 172.14 | 171.6 | 172.14 | 12706.0 |
| 2024-03-14 05:00:00 | AAPL | Stock | 172.18 | 172.53 | 172.15 | 172.45 | 28234.0 |
| 2024-03-14 06:00:00 | AAPL | Stock | 172.51 | 172.65 | 172.28 | 172.5 | 18910.0 |
| 2024-03-14 07:00:00 | AAPL | Stock | 172.51 | 172.55 | 172.03 | 172.25 | 51951.0 |
| 2024-03-14 08:00:00 | AAPL | Stock | 172.25 | 172.51 | 171.51 | 172.0 | 252441.0 |
| 2024-03-14 09:00:00 | AAPL | Stock | 172.0 | 173.275 | 171.9001 | 172.81 | 6926275.0 |
| 2024-03-14 10:00:00 | AAPL | Stock | 172.8 | 173.89 | 172.38 | 173.84 | 8172482.0 |
| 2024-03-14 11:00:00 | AAPL | Stock | 173.85 | 174.3078 | 173.06 | 173.19 | 6691415.0 |
| 2024-03-14 12:00:00 | AAPL | Stock | 173.18 | 173.36 | 172.29 | 172.36 | 4863809.0 |
| 2024-03-14 13:00:00 | AAPL | Stock | 172.37 | 173.86 | 172.24 | 173.695 | 8106840.0 |
| 2024-03-14 14:00:00 | AAPL | Stock | 173.7 | 174.0 | 172.88 | 172.92 | 4782139.0 |
| 2024-03-14 15:00:00 | AAPL | Stock | 172.92 | 173.2825 | 172.22 | 173.08 | 9608105.0 |
| 2024-03-14 16:00:00 | AAPL | Stock | 173.09 | 173.56 | 172.57 | 173.5 | 9879858.0 |
| 2024-03-14 17:00:00 | AAPL | Stock | 173.5 | 173.5 | 173.0 | 173.42 | 50354.0 |
| 2024-03-14 18:00:00 | AAPL | Stock | 173.45 | 173.6899 | 173.42 | 173.42 | 33699.0 |
| 2024-03-14 19:00:00 | AAPL | Stock | 173.42 | 173.42 | 173.09 | 173.25 | 38002.0 |
| 2024-03-14 04:00:00 | MSFT | Stock | 416.72 | 418.24 | 416.72 | 418.17 | 2649.0 |
| 2024-03-14 05:00:00 | MSFT | Stock | 417.95 | 418.1 | 417.7 | 418.0 | 3868.0 |
| 2024-03-14 06:00:00 | MSFT | Stock | 418.44 | 418.8 | 418.44 | 418.8 | 4245.0 |
| 2024-03-14 07:00:00 | MSFT | Stock | 418.55 | 419.18 | 418.55 | 418.7 | 12982.0 |
| 2024-03-14 08:00:00 | MSFT | Stock | 418.76 | 419.3 | 417.0 | 418.0523 | 66734.0 |
| 2024-03-14 09:00:00 | MSFT | Stock | 418.5 | 424.95 | 417.0019 | 422.7 | 4671560.0 |
| 2024-03-14 10:00:00 | MSFT | Stock | 422.59 | 426.88 | 420.81 | 425.3701 | 3869383.0 |
| 2024-03-14 11:00:00 | MSFT | Stock | 425.41 | 427.82 | 424.85 | 425.33 | 2779029.0 |
| 2024-03-14 12:00:00 | MSFT | Stock | 425.324 | 425.5899 | 423.62 | 424.63 | 1639994.0 |
| 2024-03-14 13:00:00 | MSFT | Stock | 424.61 | 425.52 | 422.7101 | 425.4496 | 1666389.0 |
| 2024-03-14 14:00:00 | MSFT | Stock | 425.46 | 427.18 | 425.43 | 425.75 | 1792605.0 |
| 2024-03-14 15:00:00 | MSFT | Stock | 425.73 | 425.73 | 422.63 | 425.49 | 3572789.0 |
| 2024-03-14 16:00:00 | MSFT | Stock | 425.487 | 427.0 | 425.22 | 426.44 | 4567195.0 |
| 2024-03-14 17:00:00 | MSFT | Stock | 426.34 | 426.38 | 425.22 | 426.2 | 17703.0 |
| 2024-03-14 18:00:00 | MSFT | Stock | 426.26 | 427.0 | 426.26 | 426.77 | 15997.0 |
| 2024-03-14 19:00:00 | MSFT | Stock | 426.77 | 426.7999 | 425.9 | 426.7999 | 13360.0 |
| 2024-03-14 04:00:00 | NVDA | Stock | 90.7 | 90.93 | 90.2 | 90.26 | 172450.0 |
| 2024-03-14 05:00:00 | NVDA | Stock | 90.295 | 90.6 | 90.295 | 90.52 | 91210.0 |
| 2024-03-14 06:00:00 | NVDA | Stock | 90.55 | 90.62 | 89.81 | 90.004 | 274540.0 |
| 2024-03-14 07:00:00 | NVDA | Stock | 90.1 | 90.6 | 89.033 | 89.4 | 2078300.0 |
| 2024-03-14 08:00:00 | NVDA | Stock | 89.4 | 90.99 | 88.902 | 89.4 | 4723100.0 |
| 2024-03-14 09:00:00 | NVDA | Stock | 89.388 | 90.646 | 87.535 | 88.08 | 75977950.0 |
| 2024-03-14 10:00:00 | NVDA | Stock | 88.0835 | 88.971 | 87.456 | 88.2963 | 68056320.0 |
| 2024-03-14 11:00:00 | NVDA | Stock | 88.3 | 88.62 | 87.516 | 87.7155 | 46128190.0 |
| 2024-03-14 12:00:00 | NVDA | Stock | 87.707 | 88.008 | 86.6 | 87.4187 | 58504150.0 |
| 2024-03-14 13:00:00 | NVDA | Stock | 87.4289 | 88.3 | 86.807 | 88.2365 | 42971380.0 |
| 2024-03-14 14:00:00 | NVDA | Stock | 88.25 | 88.62 | 87.717 | 87.9265 | 43740300.0 |
| 2024-03-14 15:00:00 | NVDA | Stock | 87.9 | 88.166 | 86.906 | 88.026 | 61975460.0 |
| 2024-03-14 16:00:00 | NVDA | Stock | 88.038 | 88.041 | 87.503 | 87.6 | 24226540.0 |
| 2024-03-14 17:00:00 | NVDA | Stock | 87.6 | 87.682 | 87.21 | 87.525 | 730160.0 |
| 2024-03-14 18:00:00 | NVDA | Stock | 87.52 | 87.7 | 87.35 | 87.4346 | 351500.0 |
| 2024-03-14 19:00:00 | NVDA | Stock | 87.4316 | 87.473 | 87.23 | 87.298 | 682250.0 |
| 2024-03-14 04:00:00 | AMZN | Stock | 177.24 | 177.69 | 176.87 | 177.69 | 15731.0 |
| 2024-03-14 05:00:00 | AMZN | Stock | 177.64 | 177.69 | 177.6 | 177.6 | 3269.0 |
> showing 50 of 59,778 rows — these rows as CSV