PREVIEW / stock_30min / 2002-07-23
file: by_date/stock_30min/2002/2002-07-23.parquet size: 605 KB rows: 31,275 symbols: 1,462
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-23 09:30:00 | AAPL | Stock | 0.2661 | 0.2702 | 0.2634 | 0.2691 | 38140704.0 |
| 2002-07-23 10:00:00 | AAPL | Stock | 0.2691 | 0.2693 | 0.2638 | 0.2686 | 39599784.0 |
| 2002-07-23 10:30:00 | AAPL | Stock | 0.2686 | 0.2691 | 0.2661 | 0.267 | 16475144.0 |
| 2002-07-23 11:00:00 | AAPL | Stock | 0.267 | 0.2686 | 0.2652 | 0.2679 | 18503912.0 |
| 2002-07-23 11:30:00 | AAPL | Stock | 0.2677 | 0.2682 | 0.2659 | 0.2671 | 10192896.0 |
| 2002-07-23 12:00:00 | AAPL | Stock | 0.2671 | 0.2677 | 0.263 | 0.2638 | 14620648.0 |
| 2002-07-23 12:30:00 | AAPL | Stock | 0.2636 | 0.2654 | 0.2632 | 0.2645 | 28201432.0 |
| 2002-07-23 13:00:00 | AAPL | Stock | 0.265 | 0.265 | 0.2618 | 0.2629 | 35175448.0 |
| 2002-07-23 13:30:00 | AAPL | Stock | 0.2627 | 0.2638 | 0.2602 | 0.2621 | 19293736.0 |
| 2002-07-23 14:00:00 | AAPL | Stock | 0.2613 | 0.2634 | 0.2589 | 0.2609 | 37925328.0 |
| 2002-07-23 14:30:00 | AAPL | Stock | 0.2611 | 0.265 | 0.2607 | 0.2616 | 27076168.0 |
| 2002-07-23 15:00:00 | AAPL | Stock | 0.2616 | 0.2641 | 0.2607 | 0.2618 | 21966280.0 |
| 2002-07-23 15:30:00 | AAPL | Stock | 0.2618 | 0.2632 | 0.2582 | 0.2582 | 63154280.0 |
| 2002-07-23 16:00:00 | AAPL | Stock | 0.2582 | 0.2584 | 0.2582 | 0.2582 | 554400.0 |
| 2002-07-23 09:30:00 | MSFT | Stock | 23.245 | 23.4025 | 22.755 | 23.23 | 23478644.0 |
| 2002-07-23 10:00:00 | MSFT | Stock | 23.23 | 23.2965 | 22.8645 | 23.225 | 14688802.0 |
| 2002-07-23 10:30:00 | MSFT | Stock | 23.105 | 23.26 | 22.76 | 22.89 | 11306164.0 |
| 2002-07-23 11:00:00 | MSFT | Stock | 22.8895 | 22.897 | 22.555 | 22.8105 | 11679252.0 |
| 2002-07-23 11:30:00 | MSFT | Stock | 22.815 | 22.99 | 22.675 | 22.865 | 6351396.0 |
| 2002-07-23 12:00:00 | MSFT | Stock | 22.87 | 22.95 | 22.555 | 22.605 | 6127128.0 |
| 2002-07-23 12:30:00 | MSFT | Stock | 22.575 | 22.605 | 22.35 | 22.43 | 11654108.0 |
| 2002-07-23 13:00:00 | MSFT | Stock | 22.435 | 22.45 | 22.155 | 22.195 | 10288686.0 |
| 2002-07-23 13:30:00 | MSFT | Stock | 22.195 | 22.39 | 22.015 | 22.3505 | 9941404.0 |
| 2002-07-23 14:00:00 | MSFT | Stock | 22.35 | 22.585 | 22.05 | 22.48 | 11419474.0 |
| 2002-07-23 14:30:00 | MSFT | Stock | 22.46 | 22.75 | 22.1 | 22.1 | 13220684.0 |
| 2002-07-23 15:00:00 | MSFT | Stock | 22.1 | 22.235 | 21.865 | 21.9505 | 13188264.0 |
| 2002-07-23 15:30:00 | MSFT | Stock | 21.9435 | 22.09 | 21.485 | 21.525 | 16737684.0 |
| 2002-07-23 16:00:00 | MSFT | Stock | 21.495 | 23.4 | 21.485 | 21.505 | 128923000.0 |
| 2002-07-23 09:30:00 | NVDA | Stock | 0.1449 | 0.1458 | 0.1381 | 0.1414 | 183647400.0 |
| 2002-07-23 10:00:00 | NVDA | Stock | 0.1414 | 0.1414 | 0.1365 | 0.1396 | 121510680.0 |
| 2002-07-23 10:30:00 | NVDA | Stock | 0.1396 | 0.1402 | 0.1358 | 0.1361 | 108325920.0 |
| 2002-07-23 11:00:00 | NVDA | Stock | 0.1362 | 0.1364 | 0.1337 | 0.136 | 91998240.0 |
| 2002-07-23 11:30:00 | NVDA | Stock | 0.136 | 0.1366 | 0.1334 | 0.1341 | 68779200.0 |
| 2002-07-23 12:00:00 | NVDA | Stock | 0.1341 | 0.1349 | 0.1334 | 0.134 | 45207840.0 |
| 2002-07-23 12:30:00 | NVDA | Stock | 0.1338 | 0.1346 | 0.1329 | 0.1338 | 117262200.0 |
| 2002-07-23 13:00:00 | NVDA | Stock | 0.1337 | 0.135 | 0.1329 | 0.1346 | 99534720.0 |
| 2002-07-23 13:30:00 | NVDA | Stock | 0.1345 | 0.1358 | 0.1334 | 0.1351 | 59956680.0 |
| 2002-07-23 14:00:00 | NVDA | Stock | 0.1352 | 0.1352 | 0.1334 | 0.1346 | 59788200.0 |
| 2002-07-23 14:30:00 | NVDA | Stock | 0.1346 | 0.1367 | 0.1331 | 0.1336 | 112721280.0 |
| 2002-07-23 15:00:00 | NVDA | Stock | 0.1338 | 0.1342 | 0.1319 | 0.132 | 96326280.0 |
| 2002-07-23 15:30:00 | NVDA | Stock | 0.132 | 0.1342 | 0.1284 | 0.1333 | 198951480.0 |
| 2002-07-23 16:00:00 | NVDA | Stock | 0.1336 | 0.1458 | 0.1284 | 0.1333 | 1134072000.0 |
| 2002-07-23 09:30:00 | AMZN | Stock | 0.777 | 0.794 | 0.777 | 0.7816 | 22600420.0 |
| 2002-07-23 10:00:00 | AMZN | Stock | 0.782 | 0.7825 | 0.754 | 0.76 | 20967920.0 |
| 2002-07-23 10:30:00 | AMZN | Stock | 0.76 | 0.766 | 0.755 | 0.7625 | 20295960.0 |
| 2002-07-23 11:00:00 | AMZN | Stock | 0.7625 | 0.765 | 0.7345 | 0.752 | 20063980.0 |
| 2002-07-23 11:30:00 | AMZN | Stock | 0.752 | 0.757 | 0.741 | 0.7475 | 9330700.0 |
| 2002-07-23 12:00:00 | AMZN | Stock | 0.7475 | 0.749 | 0.74 | 0.7445 | 4311320.0 |
| 2002-07-23 12:30:00 | AMZN | Stock | 0.744 | 0.7515 | 0.7275 | 0.75 | 13356780.0 |
| 2002-07-23 13:00:00 | AMZN | Stock | 0.75 | 0.7505 | 0.7325 | 0.7325 | 10071280.0 |
> showing 50 of 31,275 rows — these rows as CSV