PREVIEW / stock_30min / 2006-06-19
file: by_date/stock_30min/2006/2006-06-19.parquet size: 928 KB rows: 50,275 symbols: 2,292
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-19 06:30:00 | AAPL | Stock | 2.0625 | 2.0625 | 2.0625 | 2.0625 | 19600.0 |
| 2006-06-19 07:30:00 | AAPL | Stock | 2.0679 | 2.0696 | 2.0679 | 2.0696 | 25200.0 |
| 2006-06-19 08:00:00 | AAPL | Stock | 2.0682 | 2.0743 | 2.0643 | 2.0696 | 1298108.0 |
| 2006-06-19 08:30:00 | AAPL | Stock | 2.0696 | 2.0714 | 2.0668 | 2.0668 | 426496.0 |
| 2006-06-19 09:00:00 | AAPL | Stock | 2.0671 | 2.0679 | 2.0629 | 2.0675 | 647500.0 |
| 2006-06-19 09:30:00 | AAPL | Stock | 2.0654 | 2.0779 | 2.0486 | 2.06 | 95321128.0 |
| 2006-06-19 10:00:00 | AAPL | Stock | 2.0604 | 2.0632 | 2.0386 | 2.0457 | 73085040.0 |
| 2006-06-19 10:30:00 | AAPL | Stock | 2.0457 | 2.0752 | 2.0357 | 2.0511 | 47310060.0 |
| 2006-06-19 11:00:00 | AAPL | Stock | 2.0514 | 2.0721 | 2.0482 | 2.0543 | 51841636.0 |
| 2006-06-19 11:30:00 | AAPL | Stock | 2.0543 | 2.0732 | 2.0521 | 2.0696 | 59690568.0 |
| 2006-06-19 12:00:00 | AAPL | Stock | 2.0696 | 2.0771 | 2.065 | 2.07 | 42155736.0 |
| 2006-06-19 12:30:00 | AAPL | Stock | 2.07 | 2.0771 | 2.0661 | 2.0661 | 27421520.0 |
| 2006-06-19 13:00:00 | AAPL | Stock | 2.0657 | 2.0671 | 2.0482 | 2.0554 | 59994956.0 |
| 2006-06-19 13:30:00 | AAPL | Stock | 2.0554 | 2.0632 | 2.0489 | 2.0589 | 43422988.0 |
| 2006-06-19 14:00:00 | AAPL | Stock | 2.0589 | 2.0632 | 2.0525 | 2.0593 | 35603624.0 |
| 2006-06-19 14:30:00 | AAPL | Stock | 2.0593 | 2.0607 | 2.045 | 2.0457 | 35345044.0 |
| 2006-06-19 15:00:00 | AAPL | Stock | 2.0457 | 2.0621 | 2.0446 | 2.0575 | 41124412.0 |
| 2006-06-19 15:30:00 | AAPL | Stock | 2.0575 | 2.0589 | 2.0414 | 2.0439 | 55668872.0 |
| 2006-06-19 16:00:00 | AAPL | Stock | 2.0432 | 2.0446 | 2.04 | 2.0411 | 3988544.0 |
| 2006-06-19 16:30:00 | AAPL | Stock | 2.0411 | 2.0411 | 2.0393 | 2.0407 | 256060.0 |
| 2006-06-19 17:00:00 | AAPL | Stock | 2.0404 | 2.0429 | 2.0375 | 2.0375 | 756252.0 |
| 2006-06-19 17:30:00 | AAPL | Stock | 2.0375 | 2.0429 | 2.0357 | 2.0393 | 20293140.0 |
| 2006-06-19 18:00:00 | AAPL | Stock | 2.0393 | 2.0429 | 2.0357 | 2.0368 | 17090304.0 |
| 2006-06-19 07:00:00 | MSFT | Stock | 22.2 | 22.2 | 22.16 | 22.16 | 1600.0 |
| 2006-06-19 07:30:00 | MSFT | Stock | 22.11 | 22.15 | 22.11 | 22.15 | 200.0 |
| 2006-06-19 08:00:00 | MSFT | Stock | 22.15 | 22.16 | 22.1 | 22.15 | 33037.0 |
| 2006-06-19 08:30:00 | MSFT | Stock | 22.17 | 22.17 | 22.1 | 22.15 | 14450.0 |
| 2006-06-19 09:00:00 | MSFT | Stock | 22.16 | 22.19 | 22.13 | 22.15 | 125909.0 |
| 2006-06-19 09:30:00 | MSFT | Stock | 22.14 | 22.29 | 22.12 | 22.24 | 11905292.0 |
| 2006-06-19 10:00:00 | MSFT | Stock | 22.23 | 22.32 | 22.22 | 22.292 | 11468080.0 |
| 2006-06-19 10:30:00 | MSFT | Stock | 22.3 | 22.41 | 22.29 | 22.313 | 9746784.0 |
| 2006-06-19 11:00:00 | MSFT | Stock | 22.32 | 22.36 | 22.2 | 22.23 | 7824073.0 |
| 2006-06-19 11:30:00 | MSFT | Stock | 22.23 | 22.4 | 22.21 | 22.4 | 8189223.0 |
| 2006-06-19 12:00:00 | MSFT | Stock | 22.4 | 22.44 | 22.36 | 22.4 | 5642343.0 |
| 2006-06-19 12:30:00 | MSFT | Stock | 22.41 | 22.5 | 22.38 | 22.48 | 7586691.0 |
| 2006-06-19 13:00:00 | MSFT | Stock | 22.49 | 22.52 | 22.4 | 22.42 | 10293178.0 |
| 2006-06-19 13:30:00 | MSFT | Stock | 22.42 | 22.49 | 22.4 | 22.46 | 6619655.0 |
| 2006-06-19 14:00:00 | MSFT | Stock | 22.46 | 22.54 | 22.44 | 22.5 | 10047513.0 |
| 2006-06-19 14:30:00 | MSFT | Stock | 22.51 | 22.54 | 22.36 | 22.36 | 6274941.0 |
| 2006-06-19 15:00:00 | MSFT | Stock | 22.36 | 22.51 | 22.35 | 22.5 | 10907337.0 |
| 2006-06-19 15:30:00 | MSFT | Stock | 22.51 | 22.6 | 22.49 | 22.53 | 17333772.0 |
| 2006-06-19 16:00:00 | MSFT | Stock | 22.52 | 22.55 | 22.3 | 22.55 | 513061.0 |
| 2006-06-19 16:30:00 | MSFT | Stock | 22.55 | 22.55 | 22.52 | 22.55 | 2274300.0 |
| 2006-06-19 17:00:00 | MSFT | Stock | 22.54 | 22.55 | 22.53 | 22.53 | 900.0 |
| 2006-06-19 17:30:00 | MSFT | Stock | 22.53 | 22.55 | 22.53 | 22.55 | 12966.0 |
| 2006-06-19 18:00:00 | MSFT | Stock | 22.6 | 22.6 | 22.53 | 22.54 | 2950.0 |
| 2006-06-19 08:00:00 | NVDA | Stock | 0.3613 | 0.3643 | 0.3613 | 0.3643 | 194400.0 |
| 2006-06-19 08:30:00 | NVDA | Stock | 0.364 | 0.365 | 0.363 | 0.3632 | 362400.0 |
| 2006-06-19 09:00:00 | NVDA | Stock | 0.3645 | 0.3675 | 0.3633 | 0.3668 | 1134000.0 |
| 2006-06-19 09:30:00 | NVDA | Stock | 0.365 | 0.3668 | 0.3547 | 0.358 | 37751940.0 |
> showing 50 of 50,275 rows — these rows as CSV