PREVIEW / stock_1hour / 2024-03-20
file: by_date/stock_1hour/2024/2024-03-20.parquet size: 1.3 MB rows: 60,053 symbols: 1,088
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-20 04:00:00 | AAPL | Stock | 175.9 | 176.08 | 175.5 | 175.5 | 17339.0 |
| 2024-03-20 05:00:00 | AAPL | Stock | 175.58 | 175.75 | 175.41 | 175.55 | 11431.0 |
| 2024-03-20 06:00:00 | AAPL | Stock | 175.65 | 175.75 | 175.42 | 175.73 | 5068.0 |
| 2024-03-20 07:00:00 | AAPL | Stock | 175.7 | 176.5 | 175.7 | 176.2 | 30806.0 |
| 2024-03-20 08:00:00 | AAPL | Stock | 175.92 | 176.53 | 175.37 | 175.8779 | 116553.0 |
| 2024-03-20 09:00:00 | AAPL | Stock | 175.88 | 176.1 | 175.09 | 175.685 | 4171676.0 |
| 2024-03-20 10:00:00 | AAPL | Stock | 175.685 | 176.38 | 175.6 | 175.9099 | 4428232.0 |
| 2024-03-20 11:00:00 | AAPL | Stock | 175.9 | 176.205 | 175.72 | 176.16 | 2603222.0 |
| 2024-03-20 12:00:00 | AAPL | Stock | 176.15 | 176.7682 | 176.0575 | 176.7 | 3036948.0 |
| 2024-03-20 13:00:00 | AAPL | Stock | 176.695 | 176.775 | 176.28 | 176.64 | 2715706.0 |
| 2024-03-20 14:00:00 | AAPL | Stock | 176.63 | 178.245 | 176.59 | 177.955 | 8041901.0 |
| 2024-03-20 15:00:00 | AAPL | Stock | 177.97 | 178.67 | 177.81 | 178.65 | 9708662.0 |
| 2024-03-20 16:00:00 | AAPL | Stock | 178.66 | 178.68 | 177.5867 | 177.76 | 7503155.0 |
| 2024-03-20 17:00:00 | AAPL | Stock | 177.77 | 178.67 | 175.83 | 176.65 | 373469.0 |
| 2024-03-20 18:00:00 | AAPL | Stock | 176.65 | 176.93 | 176.27 | 176.4 | 135541.0 |
| 2024-03-20 19:00:00 | AAPL | Stock | 176.41 | 176.7 | 176.25 | 176.4 | 77711.0 |
| 2024-03-20 04:00:00 | MSFT | Stock | 420.88 | 420.99 | 420.41 | 420.55 | 1408.0 |
| 2024-03-20 05:00:00 | MSFT | Stock | 420.8 | 420.94 | 420.8 | 420.94 | 423.0 |
| 2024-03-20 06:00:00 | MSFT | Stock | 421.0 | 421.0 | 421.0 | 421.0 | 800.0 |
| 2024-03-20 07:00:00 | MSFT | Stock | 421.3 | 422.79 | 421.3 | 422.54 | 7296.0 |
| 2024-03-20 08:00:00 | MSFT | Stock | 421.29 | 422.86 | 420.58 | 421.39 | 15383.0 |
| 2024-03-20 09:00:00 | MSFT | Stock | 421.31 | 422.82 | 420.83 | 421.83 | 1124648.0 |
| 2024-03-20 10:00:00 | MSFT | Stock | 421.86 | 422.54 | 420.66 | 420.96 | 1201886.0 |
| 2024-03-20 11:00:00 | MSFT | Stock | 420.96 | 422.79 | 420.92 | 422.4701 | 704334.0 |
| 2024-03-20 12:00:00 | MSFT | Stock | 422.44 | 423.38 | 422.14 | 423.33 | 751978.0 |
| 2024-03-20 13:00:00 | MSFT | Stock | 423.3 | 423.35 | 421.02 | 421.6233 | 609753.0 |
| 2024-03-20 14:00:00 | MSFT | Stock | 421.655 | 425.2 | 421.655 | 424.58 | 1918842.0 |
| 2024-03-20 15:00:00 | MSFT | Stock | 424.7 | 425.96 | 423.71 | 425.17 | 2609031.0 |
| 2024-03-20 16:00:00 | MSFT | Stock | 425.16 | 426.89 | 424.04 | 426.52 | 3360830.0 |
| 2024-03-20 17:00:00 | MSFT | Stock | 426.47 | 426.47 | 425.36 | 426.05 | 10659.0 |
| 2024-03-20 18:00:00 | MSFT | Stock | 426.0 | 426.595 | 425.8004 | 426.2 | 4897.0 |
| 2024-03-20 19:00:00 | MSFT | Stock | 426.65 | 427.56 | 426.45 | 427.0 | 10842.0 |
| 2024-03-20 04:00:00 | NVDA | Stock | 89.022 | 89.448 | 88.951 | 89.001 | 134260.0 |
| 2024-03-20 05:00:00 | NVDA | Stock | 88.925 | 89.286 | 88.753 | 89.25 | 64390.0 |
| 2024-03-20 06:00:00 | NVDA | Stock | 89.3 | 89.355 | 89.054 | 89.1 | 107310.0 |
| 2024-03-20 07:00:00 | NVDA | Stock | 89.101 | 89.702 | 88.882 | 89.613 | 962200.0 |
| 2024-03-20 08:00:00 | NVDA | Stock | 88.9 | 89.875 | 88.852 | 89.2184 | 3019970.0 |
| 2024-03-20 09:00:00 | NVDA | Stock | 89.1764 | 90.41 | 88.257 | 88.6696 | 52088030.0 |
| 2024-03-20 10:00:00 | NVDA | Stock | 88.688 | 89.585 | 88.53 | 88.7335 | 47164510.0 |
| 2024-03-20 11:00:00 | NVDA | Stock | 88.744 | 89.086 | 88.423 | 88.599 | 29938450.0 |
| 2024-03-20 12:00:00 | NVDA | Stock | 88.591 | 88.652 | 88.223 | 88.6394 | 26892660.0 |
| 2024-03-20 13:00:00 | NVDA | Stock | 88.652 | 88.7799 | 88.388 | 88.737 | 17780410.0 |
| 2024-03-20 14:00:00 | NVDA | Stock | 88.7242 | 90.193 | 88.7242 | 89.7807 | 81009270.0 |
| 2024-03-20 15:00:00 | NVDA | Stock | 89.7807 | 90.4 | 89.702 | 90.3525 | 59018800.0 |
| 2024-03-20 16:00:00 | NVDA | Stock | 90.372 | 90.973 | 89.5603 | 90.758 | 17548780.0 |
| 2024-03-20 17:00:00 | NVDA | Stock | 90.7901 | 90.8 | 90.372 | 90.6 | 1286850.0 |
| 2024-03-20 18:00:00 | NVDA | Stock | 90.603 | 90.83 | 90.556 | 90.781 | 1114920.0 |
| 2024-03-20 19:00:00 | NVDA | Stock | 90.776 | 91.2 | 90.776 | 91.2 | 1903110.0 |
| 2024-03-20 04:00:00 | AMZN | Stock | 175.77 | 175.77 | 175.44 | 175.51 | 1948.0 |
| 2024-03-20 05:00:00 | AMZN | Stock | 175.39 | 175.68 | 175.39 | 175.6 | 1609.0 |
> showing 50 of 60,053 rows — these rows as CSV