PREVIEW / stock_1hour / 2004-10-07
file: by_date/stock_1hour/2004/2004-10-07.parquet size: 521 KB rows: 24,733 symbols: 1,834
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-07 08:00:00 | AAPL | Stock | 0.7286 | 0.7286 | 0.7218 | 0.7268 | 324800.0 |
| 2004-10-07 09:00:00 | AAPL | Stock | 0.7261 | 0.7309 | 0.7229 | 0.723 | 68850824.0 |
| 2004-10-07 10:00:00 | AAPL | Stock | 0.723 | 0.723 | 0.7182 | 0.7214 | 85968120.0 |
| 2004-10-07 11:00:00 | AAPL | Stock | 0.7211 | 0.722 | 0.7154 | 0.7168 | 42334824.0 |
| 2004-10-07 12:00:00 | AAPL | Stock | 0.7166 | 0.7177 | 0.7105 | 0.7134 | 39728976.0 |
| 2004-10-07 13:00:00 | AAPL | Stock | 0.7132 | 0.7171 | 0.713 | 0.7141 | 35524888.0 |
| 2004-10-07 14:00:00 | AAPL | Stock | 0.7139 | 0.7161 | 0.7113 | 0.7121 | 38991904.0 |
| 2004-10-07 15:00:00 | AAPL | Stock | 0.712 | 0.7123 | 0.7046 | 0.707 | 101736376.0 |
| 2004-10-07 16:00:00 | AAPL | Stock | 0.707 | 0.7161 | 0.707 | 0.7075 | 1690808.0 |
| 2004-10-07 17:00:00 | AAPL | Stock | 0.7071 | 0.7075 | 0.7071 | 0.7075 | 125496.0 |
| 2004-10-07 18:00:00 | AAPL | Stock | 0.7075 | 0.7086 | 0.7075 | 0.7086 | 447328.0 |
| 2004-10-07 08:00:00 | MSFT | Stock | 28.52 | 28.6 | 28.45 | 28.53 | 11688.0 |
| 2004-10-07 09:00:00 | MSFT | Stock | 28.52 | 28.59 | 28.43 | 28.45 | 6953882.0 |
| 2004-10-07 10:00:00 | MSFT | Stock | 28.46 | 28.53 | 28.4 | 28.42 | 5229634.0 |
| 2004-10-07 11:00:00 | MSFT | Stock | 28.42 | 28.43 | 28.33 | 28.37 | 5090951.0 |
| 2004-10-07 12:00:00 | MSFT | Stock | 28.38 | 28.41 | 28.26 | 28.31 | 3734829.0 |
| 2004-10-07 13:00:00 | MSFT | Stock | 28.31 | 28.39 | 28.3 | 28.32 | 3105626.0 |
| 2004-10-07 14:00:00 | MSFT | Stock | 28.32 | 28.42 | 28.3 | 28.32 | 3539031.0 |
| 2004-10-07 15:00:00 | MSFT | Stock | 28.32 | 28.35 | 28.16 | 28.18 | 9392044.0 |
| 2004-10-07 16:00:00 | MSFT | Stock | 28.18 | 28.3 | 28.17 | 28.17 | 414324.0 |
| 2004-10-07 17:00:00 | MSFT | Stock | 28.19 | 28.3922 | 28.16 | 28.17 | 137840.0 |
| 2004-10-07 18:00:00 | MSFT | Stock | 28.18 | 28.21 | 28.15 | 28.21 | 250208.0 |
| 2004-10-07 08:00:00 | NVDA | Stock | 0.1279 | 0.1323 | 0.1279 | 0.1318 | 11335920.0 |
| 2004-10-07 09:00:00 | NVDA | Stock | 0.1318 | 0.1322 | 0.1272 | 0.13 | 191628480.0 |
| 2004-10-07 10:00:00 | NVDA | Stock | 0.13 | 0.1324 | 0.1294 | 0.1312 | 170865240.0 |
| 2004-10-07 11:00:00 | NVDA | Stock | 0.1311 | 0.1312 | 0.1302 | 0.1307 | 105050520.0 |
| 2004-10-07 12:00:00 | NVDA | Stock | 0.1307 | 0.1311 | 0.1296 | 0.1304 | 59788440.0 |
| 2004-10-07 13:00:00 | NVDA | Stock | 0.1304 | 0.1308 | 0.1296 | 0.1296 | 40901760.0 |
| 2004-10-07 14:00:00 | NVDA | Stock | 0.1297 | 0.1304 | 0.1296 | 0.1298 | 44955360.0 |
| 2004-10-07 15:00:00 | NVDA | Stock | 0.1298 | 0.1299 | 0.1272 | 0.1278 | 152588520.0 |
| 2004-10-07 16:00:00 | NVDA | Stock | 0.1278 | 0.1305 | 0.1278 | 0.1305 | 6606840.0 |
| 2004-10-07 17:00:00 | NVDA | Stock | 0.1282 | 0.1282 | 0.1279 | 0.1282 | 103800.0 |
| 2004-10-07 18:00:00 | NVDA | Stock | 0.1282 | 0.1282 | 0.1279 | 0.1279 | 557160.0 |
| 2004-10-07 08:00:00 | AMZN | Stock | 2.0275 | 2.065 | 2.0275 | 2.065 | 44000.0 |
| 2004-10-07 09:00:00 | AMZN | Stock | 2.065 | 2.135 | 2.0605 | 2.1145 | 43538780.0 |
| 2004-10-07 10:00:00 | AMZN | Stock | 2.114 | 2.1195 | 2.093 | 2.098 | 37343180.0 |
| 2004-10-07 11:00:00 | AMZN | Stock | 2.0975 | 2.0975 | 2.0685 | 2.0775 | 19643060.0 |
| 2004-10-07 12:00:00 | AMZN | Stock | 2.077 | 2.08 | 2.0425 | 2.053 | 20598860.0 |
| 2004-10-07 13:00:00 | AMZN | Stock | 2.053 | 2.0665 | 2.051 | 2.061 | 12679340.0 |
| 2004-10-07 14:00:00 | AMZN | Stock | 2.0605 | 2.091 | 2.0605 | 2.071 | 22696300.0 |
| 2004-10-07 15:00:00 | AMZN | Stock | 2.071 | 2.073 | 2.049 | 2.0545 | 25484660.0 |
| 2004-10-07 16:00:00 | AMZN | Stock | 2.0545 | 2.058 | 2.0505 | 2.0545 | 699240.0 |
| 2004-10-07 17:00:00 | AMZN | Stock | 2.0575 | 2.0575 | 2.0505 | 2.0505 | 197100.0 |
| 2004-10-07 09:00:00 | CL | Stock | 22.31 | 22.33 | 22.255 | 22.325 | 523200.0 |
| 2004-10-07 10:00:00 | CL | Stock | 22.33 | 22.445 | 22.33 | 22.375 | 1080400.0 |
| 2004-10-07 11:00:00 | CL | Stock | 22.375 | 22.505 | 22.335 | 22.465 | 987200.0 |
| 2004-10-07 12:00:00 | CL | Stock | 22.455 | 22.465 | 22.34 | 22.375 | 651800.0 |
| 2004-10-07 13:00:00 | CL | Stock | 22.37 | 22.375 | 22.295 | 22.295 | 345600.0 |
| 2004-10-07 14:00:00 | CL | Stock | 22.29 | 22.35 | 22.29 | 22.339 | 420400.0 |
| 2004-10-07 15:00:00 | CL | Stock | 22.34 | 22.345 | 22.195 | 22.22 | 1498400.0 |
> showing 50 of 24,733 rows — these rows as CSV