PREVIEW / stock_1hour / 2000-03-02
file: by_date/stock_1hour/2000/2000-03-02.parquet size: 288 KB rows: 14,562 symbols: 1,147
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-02 09:00:00 | AAPL | Stock | 1.1339 | 1.1423 | 1.1004 | 1.1116 | 56347200.0 |
| 2000-03-02 10:00:00 | AAPL | Stock | 1.1105 | 1.1183 | 1.0938 | 1.1038 | 70492800.0 |
| 2000-03-02 11:00:00 | AAPL | Stock | 1.1032 | 1.115 | 1.0982 | 1.101 | 39032000.0 |
| 2000-03-02 12:00:00 | AAPL | Stock | 1.101 | 1.1016 | 1.0882 | 1.0882 | 27406400.0 |
| 2000-03-02 13:00:00 | AAPL | Stock | 1.0893 | 1.1027 | 1.0776 | 1.101 | 38024000.0 |
| 2000-03-02 14:00:00 | AAPL | Stock | 1.101 | 1.1094 | 1.0949 | 1.0971 | 28940800.0 |
| 2000-03-02 15:00:00 | AAPL | Stock | 1.0971 | 1.106 | 1.0893 | 1.0893 | 23945600.0 |
| 2000-03-02 16:00:00 | AAPL | Stock | 1.0893 | 1.0898 | 1.0893 | 1.0893 | 840000.0 |
| 2000-03-02 09:00:00 | MSFT | Stock | 45.9062 | 46.5 | 45.5625 | 46.2969 | 10827200.0 |
| 2000-03-02 10:00:00 | MSFT | Stock | 46.3125 | 47.25 | 46.1562 | 47.0 | 16173800.0 |
| 2000-03-02 11:00:00 | MSFT | Stock | 47.0 | 47.2188 | 46.8125 | 47.0156 | 9502000.0 |
| 2000-03-02 12:00:00 | MSFT | Stock | 47.0312 | 47.0312 | 46.1875 | 46.5 | 11677600.0 |
| 2000-03-02 13:00:00 | MSFT | Stock | 46.5 | 46.75 | 46.375 | 46.4062 | 9683600.0 |
| 2000-03-02 14:00:00 | MSFT | Stock | 46.4062 | 47.6875 | 46.4062 | 47.0625 | 19888200.0 |
| 2000-03-02 15:00:00 | MSFT | Stock | 47.0312 | 47.1562 | 46.4688 | 46.6875 | 23508600.0 |
| 2000-03-02 16:00:00 | MSFT | Stock | 46.6875 | 46.7188 | 46.6875 | 46.6875 | 275000.0 |
| 2000-03-02 09:00:00 | NVDA | Stock | 0.1305 | 0.1305 | 0.1279 | 0.1279 | 9264000.0 |
| 2000-03-02 10:00:00 | NVDA | Stock | 0.1292 | 0.1292 | 0.1275 | 0.1283 | 10704000.0 |
| 2000-03-02 11:00:00 | NVDA | Stock | 0.1283 | 0.1294 | 0.1268 | 0.1275 | 18192000.0 |
| 2000-03-02 12:00:00 | NVDA | Stock | 0.1275 | 0.1281 | 0.1247 | 0.1247 | 13920000.0 |
| 2000-03-02 13:00:00 | NVDA | Stock | 0.1255 | 0.1271 | 0.1208 | 0.1224 | 40416000.0 |
| 2000-03-02 14:00:00 | NVDA | Stock | 0.1224 | 0.1232 | 0.1214 | 0.1224 | 22608000.0 |
| 2000-03-02 15:00:00 | NVDA | Stock | 0.1224 | 0.1224 | 0.1203 | 0.1208 | 46224000.0 |
| 2000-03-02 16:00:00 | NVDA | Stock | 0.1207 | 0.1207 | 0.1207 | 0.1207 | 2544000.0 |
| 2000-03-02 09:00:00 | AMZN | Stock | 3.2469 | 3.25 | 3.1594 | 3.1688 | 17728000.0 |
| 2000-03-02 10:00:00 | AMZN | Stock | 3.1688 | 3.1875 | 3.1344 | 3.1625 | 38526000.0 |
| 2000-03-02 11:00:00 | AMZN | Stock | 3.1594 | 3.1719 | 3.1469 | 3.1625 | 18228000.0 |
| 2000-03-02 12:00:00 | AMZN | Stock | 3.1625 | 3.1656 | 3.1312 | 3.1344 | 13228000.0 |
| 2000-03-02 13:00:00 | AMZN | Stock | 3.1344 | 3.15 | 3.1094 | 3.1375 | 21340000.0 |
| 2000-03-02 14:00:00 | AMZN | Stock | 3.1406 | 3.1625 | 3.1312 | 3.1438 | 16538000.0 |
| 2000-03-02 15:00:00 | AMZN | Stock | 3.1438 | 3.1469 | 3.1125 | 3.125 | 25702000.0 |
| 2000-03-02 16:00:00 | AMZN | Stock | 3.125 | 3.1281 | 3.125 | 3.1281 | 262000.0 |
| 2000-03-02 09:00:00 | CL | Stock | 26.625 | 26.6875 | 26.4375 | 26.5625 | 332200.0 |
| 2000-03-02 10:00:00 | CL | Stock | 26.5625 | 26.5938 | 26.375 | 26.375 | 817400.0 |
| 2000-03-02 11:00:00 | CL | Stock | 26.375 | 26.4062 | 26.25 | 26.3125 | 286200.0 |
| 2000-03-02 12:00:00 | CL | Stock | 26.3438 | 26.3438 | 26.2812 | 26.3125 | 390200.0 |
| 2000-03-02 13:00:00 | CL | Stock | 26.3125 | 26.5 | 26.3125 | 26.4375 | 148800.0 |
| 2000-03-02 14:00:00 | CL | Stock | 26.4375 | 26.4688 | 26.25 | 26.3125 | 544800.0 |
| 2000-03-02 15:00:00 | CL | Stock | 26.3125 | 26.5 | 26.25 | 26.3438 | 501000.0 |
| 2000-03-02 16:00:00 | CL | Stock | 26.3125 | 26.3438 | 26.3125 | 26.3125 | 40000.0 |
> showing 40 of 14,562 rows — these rows as CSV