PREVIEW / stock_30min / 2005-10-28
file: by_date/stock_30min/2005/2005-10-28.parquet size: 857 KB rows: 45,645 symbols: 2,097
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-28 08:00:00 | AAPL | Stock | 1.9821 | 1.9893 | 1.9821 | 1.9864 | 249536.0 |
| 2005-10-28 08:30:00 | AAPL | Stock | 1.9879 | 1.9929 | 1.9857 | 1.9857 | 575568.0 |
| 2005-10-28 09:00:00 | AAPL | Stock | 1.9875 | 2.0014 | 1.9864 | 2.0 | 2734116.0 |
| 2005-10-28 09:30:00 | AAPL | Stock | 2.0014 | 2.0154 | 1.9943 | 2.0036 | 71398488.0 |
| 2005-10-28 10:00:00 | AAPL | Stock | 2.0036 | 2.0064 | 1.9946 | 1.9957 | 49757708.0 |
| 2005-10-28 10:30:00 | AAPL | Stock | 1.9957 | 1.9961 | 1.9368 | 1.9518 | 132112260.0 |
| 2005-10-28 11:00:00 | AAPL | Stock | 1.9521 | 1.9686 | 1.9518 | 1.9671 | 60089932.0 |
| 2005-10-28 11:30:00 | AAPL | Stock | 1.9675 | 1.9907 | 1.9625 | 1.9882 | 56346136.0 |
| 2005-10-28 12:00:00 | AAPL | Stock | 1.9886 | 1.9914 | 1.9696 | 1.9739 | 44986004.0 |
| 2005-10-28 12:30:00 | AAPL | Stock | 1.9739 | 1.9768 | 1.9571 | 1.9589 | 28524412.0 |
| 2005-10-28 13:00:00 | AAPL | Stock | 1.9589 | 1.9654 | 1.9539 | 1.9596 | 32286940.0 |
| 2005-10-28 13:30:00 | AAPL | Stock | 1.96 | 1.9621 | 1.9421 | 1.9468 | 39235560.0 |
| 2005-10-28 14:00:00 | AAPL | Stock | 1.9471 | 1.9571 | 1.9443 | 1.9493 | 47231604.0 |
| 2005-10-28 14:30:00 | AAPL | Stock | 1.9493 | 1.9518 | 1.9425 | 1.9504 | 46071760.0 |
| 2005-10-28 15:00:00 | AAPL | Stock | 1.9504 | 1.9554 | 1.9368 | 1.9368 | 57405236.0 |
| 2005-10-28 15:30:00 | AAPL | Stock | 1.9368 | 1.9507 | 1.9346 | 1.9421 | 85422792.0 |
| 2005-10-28 16:00:00 | AAPL | Stock | 1.9436 | 1.95 | 1.9404 | 1.95 | 1160628.0 |
| 2005-10-28 16:30:00 | AAPL | Stock | 1.9496 | 1.95 | 1.9479 | 1.9496 | 166628.0 |
| 2005-10-28 17:00:00 | AAPL | Stock | 1.9482 | 1.9482 | 1.9429 | 1.9429 | 148540.0 |
| 2005-10-28 17:30:00 | AAPL | Stock | 1.9464 | 1.9464 | 1.9464 | 1.9464 | 53984.0 |
| 2005-10-28 18:00:00 | AAPL | Stock | 1.9479 | 1.9543 | 1.9479 | 1.9482 | 76300.0 |
| 2005-10-28 04:30:00 | MSFT | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 160.0 |
| 2005-10-28 06:30:00 | MSFT | Stock | 25.5 | 25.5 | 24.7 | 24.71 | 35100.0 |
| 2005-10-28 07:00:00 | MSFT | Stock | 24.7 | 24.75 | 24.7 | 24.75 | 21000.0 |
| 2005-10-28 07:30:00 | MSFT | Stock | 24.75 | 24.78 | 24.75 | 24.75 | 4600.0 |
| 2005-10-28 08:00:00 | MSFT | Stock | 24.77 | 25.09 | 24.7 | 24.99 | 1117192.0 |
| 2005-10-28 08:30:00 | MSFT | Stock | 24.98 | 25.03 | 24.95 | 24.96 | 821151.0 |
| 2005-10-28 09:00:00 | MSFT | Stock | 24.96 | 25.13 | 24.96 | 25.1 | 1118833.0 |
| 2005-10-28 09:30:00 | MSFT | Stock | 25.1 | 25.491 | 25.1 | 25.38 | 20688458.0 |
| 2005-10-28 10:00:00 | MSFT | Stock | 25.38 | 25.49 | 25.3 | 25.38 | 11937950.0 |
| 2005-10-28 10:30:00 | MSFT | Stock | 25.38 | 25.4 | 25.3 | 25.36 | 8108455.0 |
| 2005-10-28 11:00:00 | MSFT | Stock | 25.36 | 25.47 | 25.35 | 25.441 | 6560495.0 |
| 2005-10-28 11:30:00 | MSFT | Stock | 25.44 | 25.45 | 25.36 | 25.432 | 6260013.0 |
| 2005-10-28 12:00:00 | MSFT | Stock | 25.44 | 25.46 | 25.35 | 25.35 | 3802171.0 |
| 2005-10-28 12:30:00 | MSFT | Stock | 25.36 | 25.42 | 25.33 | 25.38 | 2442699.0 |
| 2005-10-28 13:00:00 | MSFT | Stock | 25.37 | 25.5 | 25.37 | 25.41 | 3835265.0 |
| 2005-10-28 13:30:00 | MSFT | Stock | 25.42 | 25.46 | 25.35 | 25.41 | 4886567.0 |
| 2005-10-28 14:00:00 | MSFT | Stock | 25.418 | 25.481 | 25.39 | 25.45 | 6397978.0 |
| 2005-10-28 14:30:00 | MSFT | Stock | 25.441 | 25.53 | 25.44 | 25.52 | 5714480.0 |
| 2005-10-28 15:00:00 | MSFT | Stock | 25.53 | 25.6 | 25.46 | 25.48 | 9572694.0 |
| 2005-10-28 15:30:00 | MSFT | Stock | 25.47 | 25.56 | 25.44 | 25.53 | 7902479.0 |
| 2005-10-28 16:00:00 | MSFT | Stock | 25.53 | 25.56 | 25.41 | 25.48 | 758460.0 |
| 2005-10-28 16:30:00 | MSFT | Stock | 25.48 | 25.53 | 25.4 | 25.5 | 19295.0 |
| 2005-10-28 17:00:00 | MSFT | Stock | 25.49 | 25.51 | 25.49 | 25.49 | 7150.0 |
| 2005-10-28 17:30:00 | MSFT | Stock | 25.5 | 25.5 | 25.47 | 25.5 | 9700.0 |
| 2005-10-28 18:00:00 | MSFT | Stock | 25.5 | 25.56 | 25.47 | 25.51 | 1798834.0 |
| 2005-10-28 08:30:00 | NVDA | Stock | 0.2621 | 0.2621 | 0.2621 | 0.2621 | 72000.0 |
| 2005-10-28 09:00:00 | NVDA | Stock | 0.2621 | 0.2621 | 0.262 | 0.2621 | 132000.0 |
| 2005-10-28 09:30:00 | NVDA | Stock | 0.2627 | 0.2638 | 0.2596 | 0.2597 | 50331120.0 |
| 2005-10-28 10:00:00 | NVDA | Stock | 0.2597 | 0.2606 | 0.2562 | 0.2578 | 47566800.0 |
> showing 50 of 45,645 rows — these rows as CSV