PREVIEW / stock_1hour / 2003-10-01
file: by_date/stock_1hour/2003/2003-10-01.parquet size: 484 KB rows: 22,679 symbols: 1,632
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-01 08:00:00 | AAPL | Stock | 0.3695 | 0.3702 | 0.3695 | 0.3702 | 33600.0 |
| 2003-10-01 09:00:00 | AAPL | Stock | 0.3702 | 0.3768 | 0.3695 | 0.3714 | 19054448.0 |
| 2003-10-01 10:00:00 | AAPL | Stock | 0.3714 | 0.3734 | 0.3625 | 0.3625 | 50171296.0 |
| 2003-10-01 11:00:00 | AAPL | Stock | 0.3629 | 0.3673 | 0.3605 | 0.3668 | 36044848.0 |
| 2003-10-01 12:00:00 | AAPL | Stock | 0.367 | 0.3686 | 0.3657 | 0.3677 | 14517720.0 |
| 2003-10-01 13:00:00 | AAPL | Stock | 0.3677 | 0.3698 | 0.3673 | 0.3695 | 16885624.0 |
| 2003-10-01 14:00:00 | AAPL | Stock | 0.3696 | 0.3698 | 0.367 | 0.3671 | 21381024.0 |
| 2003-10-01 15:00:00 | AAPL | Stock | 0.367 | 0.3705 | 0.367 | 0.3698 | 30099664.0 |
| 2003-10-01 16:00:00 | AAPL | Stock | 0.3705 | 0.3721 | 0.3693 | 0.3705 | 2312856.0 |
| 2003-10-01 17:00:00 | AAPL | Stock | 0.3703 | 0.3705 | 0.3682 | 0.3705 | 1996960.0 |
| 2003-10-01 18:00:00 | AAPL | Stock | 0.372 | 0.372 | 0.3682 | 0.3682 | 280000.0 |
| 2003-10-01 08:00:00 | MSFT | Stock | 27.9 | 28.0 | 27.89 | 27.98 | 85550.0 |
| 2003-10-01 09:00:00 | MSFT | Stock | 27.99 | 28.08 | 27.79 | 28.05 | 6411459.0 |
| 2003-10-01 10:00:00 | MSFT | Stock | 28.05 | 28.27 | 27.81 | 27.89 | 10369182.0 |
| 2003-10-01 11:00:00 | MSFT | Stock | 27.88 | 28.1 | 27.87 | 28.05 | 5047240.0 |
| 2003-10-01 12:00:00 | MSFT | Stock | 28.05 | 28.16 | 28.02 | 28.15 | 3656886.0 |
| 2003-10-01 13:00:00 | MSFT | Stock | 28.14 | 28.23 | 28.1 | 28.219 | 4125314.0 |
| 2003-10-01 14:00:00 | MSFT | Stock | 28.22 | 28.25 | 28.1 | 28.17 | 4016796.0 |
| 2003-10-01 15:00:00 | MSFT | Stock | 28.17 | 28.63 | 28.16 | 28.53 | 13362689.0 |
| 2003-10-01 16:00:00 | MSFT | Stock | 28.53 | 28.63 | 28.43 | 28.44 | 996823.0 |
| 2003-10-01 17:00:00 | MSFT | Stock | 28.45 | 28.62 | 28.44 | 28.62 | 1160500.0 |
| 2003-10-01 18:00:00 | MSFT | Stock | 28.47 | 28.47 | 28.46 | 28.46 | 5200.0 |
| 2003-10-01 08:00:00 | NVDA | Stock | 0.1333 | 0.1354 | 0.1333 | 0.1348 | 1608000.0 |
| 2003-10-01 09:00:00 | NVDA | Stock | 0.1353 | 0.1357 | 0.1331 | 0.1348 | 93388440.0 |
| 2003-10-01 10:00:00 | NVDA | Stock | 0.1348 | 0.1356 | 0.133 | 0.1343 | 162863520.0 |
| 2003-10-01 11:00:00 | NVDA | Stock | 0.1342 | 0.1346 | 0.1337 | 0.1343 | 70502520.0 |
| 2003-10-01 12:00:00 | NVDA | Stock | 0.1343 | 0.1346 | 0.1339 | 0.1345 | 61294200.0 |
| 2003-10-01 13:00:00 | NVDA | Stock | 0.1344 | 0.1354 | 0.1344 | 0.135 | 80894520.0 |
| 2003-10-01 14:00:00 | NVDA | Stock | 0.1349 | 0.1352 | 0.1342 | 0.1342 | 75359280.0 |
| 2003-10-01 15:00:00 | NVDA | Stock | 0.1342 | 0.1347 | 0.1339 | 0.1339 | 136890240.0 |
| 2003-10-01 16:00:00 | NVDA | Stock | 0.1342 | 0.1346 | 0.1338 | 0.1344 | 15197280.0 |
| 2003-10-01 17:00:00 | NVDA | Stock | 0.1341 | 0.1342 | 0.1341 | 0.1342 | 2424000.0 |
| 2003-10-01 18:00:00 | NVDA | Stock | 0.1342 | 0.1343 | 0.1339 | 0.1339 | 1164000.0 |
| 2003-10-01 08:00:00 | AMZN | Stock | 2.433 | 2.4335 | 2.422 | 2.422 | 100000.0 |
| 2003-10-01 09:00:00 | AMZN | Stock | 2.4275 | 2.433 | 2.405 | 2.4245 | 34041800.0 |
| 2003-10-01 10:00:00 | AMZN | Stock | 2.4225 | 2.4475 | 2.3755 | 2.379 | 64228060.0 |
| 2003-10-01 11:00:00 | AMZN | Stock | 2.379 | 2.4025 | 2.3755 | 2.3975 | 32456580.0 |
| 2003-10-01 12:00:00 | AMZN | Stock | 2.3975 | 2.4285 | 2.3975 | 2.4215 | 28966640.0 |
| 2003-10-01 13:00:00 | AMZN | Stock | 2.4215 | 2.4421 | 2.418 | 2.441 | 14746160.0 |
| 2003-10-01 14:00:00 | AMZN | Stock | 2.4415 | 2.443 | 2.422 | 2.422 | 11508360.0 |
| 2003-10-01 15:00:00 | AMZN | Stock | 2.422 | 2.464 | 2.422 | 2.456 | 32058080.0 |
| 2003-10-01 16:00:00 | AMZN | Stock | 2.456 | 2.4575 | 2.4505 | 2.4505 | 1473000.0 |
| 2003-10-01 17:00:00 | AMZN | Stock | 2.4505 | 2.458 | 2.4505 | 2.4545 | 164300.0 |
| 2003-10-01 18:00:00 | AMZN | Stock | 2.4545 | 2.455 | 2.4545 | 2.455 | 18000.0 |
| 2003-10-01 09:00:00 | CL | Stock | 28.01 | 28.23 | 27.985 | 28.21 | 190000.0 |
| 2003-10-01 10:00:00 | CL | Stock | 28.2 | 28.27 | 28.155 | 28.2 | 497600.0 |
| 2003-10-01 11:00:00 | CL | Stock | 28.21 | 28.375 | 28.2 | 28.37 | 391000.0 |
| 2003-10-01 12:00:00 | CL | Stock | 28.37 | 28.46 | 28.34 | 28.39 | 268600.0 |
| 2003-10-01 13:00:00 | CL | Stock | 28.385 | 28.45 | 28.34 | 28.44 | 388800.0 |
| 2003-10-01 14:00:00 | CL | Stock | 28.44 | 28.445 | 28.35 | 28.355 | 264600.0 |
> showing 50 of 22,679 rows — these rows as CSV