PREVIEW / stock_1hour / 2001-05-25
file: by_date/stock_1hour/2001/2001-05-25.parquet size: 359 KB rows: 17,153 symbols: 1,298
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-25 08:00:00 | AAPL | Stock | 0.4157 | 0.4166 | 0.4116 | 0.4159 | 386400.0 |
| 2001-05-25 09:00:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4095 | 0.4095 | 17404800.0 |
| 2001-05-25 10:00:00 | AAPL | Stock | 0.4095 | 0.4098 | 0.4036 | 0.4084 | 32110400.0 |
| 2001-05-25 11:00:00 | AAPL | Stock | 0.4082 | 0.4098 | 0.4073 | 0.4084 | 13031200.0 |
| 2001-05-25 12:00:00 | AAPL | Stock | 0.4084 | 0.4098 | 0.4079 | 0.4084 | 15752800.0 |
| 2001-05-25 13:00:00 | AAPL | Stock | 0.4084 | 0.4089 | 0.4038 | 0.407 | 20440000.0 |
| 2001-05-25 14:00:00 | AAPL | Stock | 0.4066 | 0.4091 | 0.4036 | 0.4054 | 19521600.0 |
| 2001-05-25 15:00:00 | AAPL | Stock | 0.405 | 0.4086 | 0.4027 | 0.4064 | 28291200.0 |
| 2001-05-25 16:00:00 | AAPL | Stock | 0.4064 | 0.4077 | 0.4039 | 0.4064 | 4188800.0 |
| 2001-05-25 17:00:00 | AAPL | Stock | 0.4064 | 0.4064 | 0.4063 | 0.4063 | 554400.0 |
| 2001-05-25 18:00:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 16800.0 |
| 2001-05-25 08:00:00 | MSFT | Stock | 35.88 | 36.025 | 35.75 | 35.93 | 193800.0 |
| 2001-05-25 09:00:00 | MSFT | Stock | 35.93 | 35.945 | 35.46 | 35.585 | 9556400.0 |
| 2001-05-25 10:00:00 | MSFT | Stock | 35.575 | 35.67 | 35.18 | 35.275 | 12785600.0 |
| 2001-05-25 11:00:00 | MSFT | Stock | 35.28 | 35.725 | 35.275 | 35.505 | 7947000.0 |
| 2001-05-25 12:00:00 | MSFT | Stock | 35.5 | 35.605 | 35.4 | 35.58 | 2833400.0 |
| 2001-05-25 13:00:00 | MSFT | Stock | 35.595 | 35.615 | 35.435 | 35.595 | 3268400.0 |
| 2001-05-25 14:00:00 | MSFT | Stock | 35.595 | 35.725 | 35.5 | 35.54 | 3388000.0 |
| 2001-05-25 15:00:00 | MSFT | Stock | 35.54 | 35.7 | 35.405 | 35.45 | 5362800.0 |
| 2001-05-25 16:00:00 | MSFT | Stock | 35.45 | 35.67 | 35.425 | 35.655 | 5190800.0 |
| 2001-05-25 17:00:00 | MSFT | Stock | 35.455 | 35.675 | 35.2 | 35.5 | 93200.0 |
| 2001-05-25 18:00:00 | MSFT | Stock | 35.615 | 35.65 | 35.52 | 35.65 | 4800.0 |
| 2001-05-25 08:00:00 | NVDA | Stock | 0.4 | 0.4 | 0.3833 | 0.3844 | 7536000.0 |
| 2001-05-25 09:00:00 | NVDA | Stock | 0.3833 | 0.3843 | 0.3767 | 0.3789 | 231288000.0 |
| 2001-05-25 10:00:00 | NVDA | Stock | 0.379 | 0.3836 | 0.375 | 0.3817 | 226944000.0 |
| 2001-05-25 11:00:00 | NVDA | Stock | 0.3819 | 0.3857 | 0.3791 | 0.3821 | 119952000.0 |
| 2001-05-25 12:00:00 | NVDA | Stock | 0.382 | 0.3848 | 0.3805 | 0.3834 | 49608000.0 |
| 2001-05-25 13:00:00 | NVDA | Stock | 0.3835 | 0.3837 | 0.3807 | 0.3829 | 40272000.0 |
| 2001-05-25 14:00:00 | NVDA | Stock | 0.3829 | 0.3873 | 0.3817 | 0.3828 | 127944000.0 |
| 2001-05-25 15:00:00 | NVDA | Stock | 0.3828 | 0.3835 | 0.3787 | 0.3821 | 95256000.0 |
| 2001-05-25 16:00:00 | NVDA | Stock | 0.382 | 0.3833 | 0.3807 | 0.3833 | 15768000.0 |
| 2001-05-25 17:00:00 | NVDA | Stock | 0.3821 | 0.3821 | 0.3808 | 0.381 | 312000.0 |
| 2001-05-25 08:00:00 | AMZN | Stock | 0.8625 | 0.8625 | 0.835 | 0.835 | 248000.0 |
| 2001-05-25 09:00:00 | AMZN | Stock | 0.831 | 0.8465 | 0.8185 | 0.843 | 11802000.0 |
| 2001-05-25 10:00:00 | AMZN | Stock | 0.84 | 0.8435 | 0.821 | 0.826 | 17804000.0 |
| 2001-05-25 11:00:00 | AMZN | Stock | 0.826 | 0.8535 | 0.825 | 0.849 | 18254000.0 |
| 2001-05-25 12:00:00 | AMZN | Stock | 0.8495 | 0.8625 | 0.842 | 0.8625 | 15966000.0 |
| 2001-05-25 13:00:00 | AMZN | Stock | 0.8625 | 0.865 | 0.8505 | 0.86 | 18432000.0 |
| 2001-05-25 14:00:00 | AMZN | Stock | 0.859 | 0.8765 | 0.8565 | 0.8685 | 28246000.0 |
| 2001-05-25 15:00:00 | AMZN | Stock | 0.8685 | 0.8715 | 0.8505 | 0.8555 | 17322000.0 |
| 2001-05-25 16:00:00 | AMZN | Stock | 0.855 | 0.855 | 0.84 | 0.84 | 1340000.0 |
| 2001-05-25 17:00:00 | AMZN | Stock | 0.855 | 0.8575 | 0.855 | 0.8575 | 38000.0 |
| 2001-05-25 09:00:00 | CL | Stock | 28.475 | 28.625 | 28.475 | 28.535 | 223600.0 |
| 2001-05-25 10:00:00 | CL | Stock | 28.535 | 28.535 | 28.3 | 28.335 | 321400.0 |
| 2001-05-25 11:00:00 | CL | Stock | 28.345 | 28.38 | 28.205 | 28.37 | 142800.0 |
| 2001-05-25 12:00:00 | CL | Stock | 28.375 | 28.375 | 28.275 | 28.315 | 78200.0 |
| 2001-05-25 13:00:00 | CL | Stock | 28.34 | 28.36 | 28.255 | 28.34 | 90600.0 |
| 2001-05-25 14:00:00 | CL | Stock | 28.36 | 28.525 | 28.33 | 28.425 | 196200.0 |
| 2001-05-25 15:00:00 | CL | Stock | 28.425 | 28.525 | 28.32 | 28.385 | 221000.0 |
| 2001-05-25 16:00:00 | CL | Stock | 28.385 | 28.47 | 28.385 | 28.47 | 61800.0 |
> showing 50 of 17,153 rows — these rows as CSV