PREVIEW / stock_1hour / 2004-10-25
file: by_date/stock_1hour/2004/2004-10-25.parquet size: 538 KB rows: 24,832 symbols: 1,846
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-25 08:00:00 | AAPL | Stock | 0.8395 | 0.8395 | 0.8393 | 0.8393 | 61600.0 |
| 2004-10-25 09:00:00 | AAPL | Stock | 0.8402 | 0.8543 | 0.8402 | 0.8448 | 81539640.0 |
| 2004-10-25 10:00:00 | AAPL | Stock | 0.8448 | 0.8518 | 0.8446 | 0.8482 | 78860656.0 |
| 2004-10-25 11:00:00 | AAPL | Stock | 0.848 | 0.8482 | 0.8421 | 0.8443 | 46981536.0 |
| 2004-10-25 12:00:00 | AAPL | Stock | 0.8443 | 0.8464 | 0.842 | 0.8455 | 38694768.0 |
| 2004-10-25 13:00:00 | AAPL | Stock | 0.8452 | 0.8509 | 0.8452 | 0.8457 | 49332472.0 |
| 2004-10-25 14:00:00 | AAPL | Stock | 0.8457 | 0.8488 | 0.8429 | 0.8457 | 38589208.0 |
| 2004-10-25 15:00:00 | AAPL | Stock | 0.8457 | 0.8489 | 0.8446 | 0.848 | 41629728.0 |
| 2004-10-25 16:00:00 | AAPL | Stock | 0.8488 | 0.8518 | 0.8468 | 0.8491 | 4618488.0 |
| 2004-10-25 17:00:00 | AAPL | Stock | 0.8482 | 0.8482 | 0.8482 | 0.8482 | 5600.0 |
| 2004-10-25 18:00:00 | AAPL | Stock | 0.848 | 0.848 | 0.848 | 0.848 | 5600.0 |
| 2004-10-25 08:00:00 | MSFT | Stock | 27.7 | 27.7 | 27.64 | 27.67 | 12999.0 |
| 2004-10-25 09:00:00 | MSFT | Stock | 27.69 | 27.77 | 27.63 | 27.65 | 7921398.0 |
| 2004-10-25 10:00:00 | MSFT | Stock | 27.64 | 27.76 | 27.61 | 27.7 | 8963785.0 |
| 2004-10-25 11:00:00 | MSFT | Stock | 27.69 | 27.71 | 27.59 | 27.64 | 7290062.0 |
| 2004-10-25 12:00:00 | MSFT | Stock | 27.64 | 27.68 | 27.58 | 27.64 | 5906045.0 |
| 2004-10-25 13:00:00 | MSFT | Stock | 27.63 | 27.7 | 27.63 | 27.67 | 4738474.0 |
| 2004-10-25 14:00:00 | MSFT | Stock | 27.67 | 27.69 | 27.58 | 27.59 | 7664752.0 |
| 2004-10-25 15:00:00 | MSFT | Stock | 27.59 | 27.68 | 27.55 | 27.62 | 11069074.0 |
| 2004-10-25 16:00:00 | MSFT | Stock | 27.62 | 27.65 | 27.57 | 27.62 | 5622545.0 |
| 2004-10-25 17:00:00 | MSFT | Stock | 27.6 | 27.63 | 27.6 | 27.63 | 116495.0 |
| 2004-10-25 18:00:00 | MSFT | Stock | 27.62 | 27.62 | 27.6 | 27.61 | 13518.0 |
| 2004-10-25 08:00:00 | NVDA | Stock | 0.1104 | 0.1104 | 0.1104 | 0.1104 | 48000.0 |
| 2004-10-25 09:00:00 | NVDA | Stock | 0.1104 | 0.1136 | 0.1095 | 0.1122 | 87239520.0 |
| 2004-10-25 10:00:00 | NVDA | Stock | 0.1122 | 0.1128 | 0.1109 | 0.1116 | 96826560.0 |
| 2004-10-25 11:00:00 | NVDA | Stock | 0.1116 | 0.1119 | 0.1109 | 0.1117 | 69973320.0 |
| 2004-10-25 12:00:00 | NVDA | Stock | 0.1117 | 0.1123 | 0.1113 | 0.1118 | 53737200.0 |
| 2004-10-25 13:00:00 | NVDA | Stock | 0.1118 | 0.1126 | 0.1117 | 0.112 | 38997120.0 |
| 2004-10-25 14:00:00 | NVDA | Stock | 0.112 | 0.1123 | 0.1107 | 0.111 | 46420080.0 |
| 2004-10-25 15:00:00 | NVDA | Stock | 0.111 | 0.1115 | 0.1107 | 0.111 | 97915320.0 |
| 2004-10-25 16:00:00 | NVDA | Stock | 0.1108 | 0.1112 | 0.1107 | 0.1107 | 3559320.0 |
| 2004-10-25 17:00:00 | NVDA | Stock | 0.1114 | 0.1312 | 0.1113 | 0.124 | 41750760.0 |
| 2004-10-25 18:00:00 | NVDA | Stock | 0.1239 | 0.1264 | 0.1238 | 0.1242 | 10915200.0 |
| 2004-10-25 08:00:00 | AMZN | Stock | 1.72 | 1.7245 | 1.71 | 1.7125 | 1626040.0 |
| 2004-10-25 09:00:00 | AMZN | Stock | 1.71 | 1.7205 | 1.6945 | 1.7005 | 41903360.0 |
| 2004-10-25 10:00:00 | AMZN | Stock | 1.7005 | 1.714 | 1.693 | 1.6955 | 47097720.0 |
| 2004-10-25 11:00:00 | AMZN | Stock | 1.695 | 1.7025 | 1.686 | 1.6915 | 28133460.0 |
| 2004-10-25 12:00:00 | AMZN | Stock | 1.6915 | 1.7075 | 1.6875 | 1.7015 | 17883580.0 |
| 2004-10-25 13:00:00 | AMZN | Stock | 1.702 | 1.708 | 1.6985 | 1.699 | 20663020.0 |
| 2004-10-25 14:00:00 | AMZN | Stock | 1.699 | 1.702 | 1.695 | 1.697 | 13811440.0 |
| 2004-10-25 15:00:00 | AMZN | Stock | 1.6975 | 1.705 | 1.693 | 1.6985 | 30479040.0 |
| 2004-10-25 16:00:00 | AMZN | Stock | 1.699 | 1.7029 | 1.692 | 1.6925 | 4536120.0 |
| 2004-10-25 17:00:00 | AMZN | Stock | 1.6925 | 1.6975 | 1.6925 | 1.697 | 69000.0 |
| 2004-10-25 18:00:00 | AMZN | Stock | 1.693 | 1.693 | 1.693 | 1.693 | 20000.0 |
| 2004-10-25 08:00:00 | CL | Stock | 22.85 | 22.85 | 22.85 | 22.85 | 200.0 |
| 2004-10-25 09:00:00 | CL | Stock | 22.995 | 22.995 | 22.53 | 22.53 | 563800.0 |
| 2004-10-25 10:00:00 | CL | Stock | 22.55 | 22.68 | 22.5395 | 22.62 | 794800.0 |
| 2004-10-25 11:00:00 | CL | Stock | 22.625 | 22.67 | 22.5 | 22.5 | 970000.0 |
| 2004-10-25 12:00:00 | CL | Stock | 22.515 | 22.515 | 22.335 | 22.425 | 1293600.0 |
| 2004-10-25 13:00:00 | CL | Stock | 22.415 | 22.49 | 22.4 | 22.44 | 1048200.0 |
> showing 50 of 24,832 rows — these rows as CSV