PREVIEW / stock_30min / 2003-08-20
file: by_date/stock_30min/2003/2003-08-20.parquet size: 666 KB rows: 35,986 symbols: 1,611
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-08-20 08:00:00 | AAPL | Stock | 0.3629 | 0.3629 | 0.3605 | 0.3605 | 11200.0 |
| 2003-08-20 09:00:00 | AAPL | Stock | 0.36 | 0.3604 | 0.3593 | 0.3593 | 145600.0 |
| 2003-08-20 09:30:00 | AAPL | Stock | 0.3604 | 0.3675 | 0.3596 | 0.3661 | 26753048.0 |
| 2003-08-20 10:00:00 | AAPL | Stock | 0.3661 | 0.3679 | 0.3643 | 0.3677 | 17234000.0 |
| 2003-08-20 10:30:00 | AAPL | Stock | 0.3677 | 0.3677 | 0.3651 | 0.3673 | 14280952.0 |
| 2003-08-20 11:00:00 | AAPL | Stock | 0.3673 | 0.3709 | 0.367 | 0.3709 | 17187576.0 |
| 2003-08-20 11:30:00 | AAPL | Stock | 0.3711 | 0.3732 | 0.3709 | 0.3729 | 11742192.0 |
| 2003-08-20 12:00:00 | AAPL | Stock | 0.3729 | 0.3734 | 0.3705 | 0.3714 | 10873352.0 |
| 2003-08-20 12:30:00 | AAPL | Stock | 0.3714 | 0.3759 | 0.3707 | 0.3757 | 17766392.0 |
| 2003-08-20 13:00:00 | AAPL | Stock | 0.3755 | 0.3757 | 0.3739 | 0.3755 | 11063024.0 |
| 2003-08-20 13:30:00 | AAPL | Stock | 0.3755 | 0.3768 | 0.3746 | 0.375 | 9926392.0 |
| 2003-08-20 14:00:00 | AAPL | Stock | 0.375 | 0.375 | 0.3727 | 0.3727 | 8535856.0 |
| 2003-08-20 14:30:00 | AAPL | Stock | 0.3726 | 0.3754 | 0.3713 | 0.375 | 20715128.0 |
| 2003-08-20 15:00:00 | AAPL | Stock | 0.3749 | 0.3798 | 0.3745 | 0.3773 | 35252952.0 |
| 2003-08-20 15:30:00 | AAPL | Stock | 0.3773 | 0.3798 | 0.3752 | 0.3754 | 41596352.0 |
| 2003-08-20 16:00:00 | AAPL | Stock | 0.3752 | 0.3768 | 0.3673 | 0.3673 | 9195200.0 |
| 2003-08-20 16:30:00 | AAPL | Stock | 0.3752 | 0.3752 | 0.3725 | 0.3725 | 95200.0 |
| 2003-08-20 17:00:00 | AAPL | Stock | 0.3759 | 0.3759 | 0.3759 | 0.3759 | 50400.0 |
| 2003-08-20 18:00:00 | AAPL | Stock | 0.3732 | 0.3732 | 0.3732 | 0.3732 | 5600.0 |
| 2003-08-20 08:00:00 | MSFT | Stock | 26.52 | 26.53 | 26.4 | 26.439 | 26200.0 |
| 2003-08-20 08:30:00 | MSFT | Stock | 26.4 | 26.439 | 26.35 | 26.36 | 25826.0 |
| 2003-08-20 09:00:00 | MSFT | Stock | 26.37 | 26.376 | 26.25 | 26.3 | 571400.0 |
| 2003-08-20 09:30:00 | MSFT | Stock | 26.3 | 26.388 | 26.14 | 26.18 | 12767898.0 |
| 2003-08-20 10:00:00 | MSFT | Stock | 26.18 | 26.26 | 26.0 | 26.2 | 7072902.0 |
| 2003-08-20 10:30:00 | MSFT | Stock | 26.2 | 26.26 | 26.15 | 26.23 | 2845712.0 |
| 2003-08-20 11:00:00 | MSFT | Stock | 26.25 | 26.34 | 26.2 | 26.33 | 3185364.0 |
| 2003-08-20 11:30:00 | MSFT | Stock | 26.33 | 26.43 | 26.31 | 26.37 | 3735892.0 |
| 2003-08-20 12:00:00 | MSFT | Stock | 26.37 | 26.42 | 26.32 | 26.33 | 3243717.0 |
| 2003-08-20 12:30:00 | MSFT | Stock | 26.33 | 26.41 | 26.32 | 26.39 | 1340740.0 |
| 2003-08-20 13:00:00 | MSFT | Stock | 26.4 | 26.42 | 26.34 | 26.4 | 1251204.0 |
| 2003-08-20 13:30:00 | MSFT | Stock | 26.409 | 26.5 | 26.35 | 26.46 | 2297101.0 |
| 2003-08-20 14:00:00 | MSFT | Stock | 26.46 | 26.5 | 26.39 | 26.42 | 2393713.0 |
| 2003-08-20 14:30:00 | MSFT | Stock | 26.42 | 26.48 | 26.37 | 26.44 | 2653868.0 |
| 2003-08-20 15:00:00 | MSFT | Stock | 26.44 | 26.53 | 26.39 | 26.44 | 2479404.0 |
| 2003-08-20 15:30:00 | MSFT | Stock | 26.44 | 26.46 | 26.35 | 26.44 | 3980149.0 |
| 2003-08-20 16:00:00 | MSFT | Stock | 26.43 | 26.5 | 26.35 | 26.43 | 1283241.0 |
| 2003-08-20 16:30:00 | MSFT | Stock | 26.411 | 26.45 | 26.3156 | 26.43 | 35025.0 |
| 2003-08-20 17:00:00 | MSFT | Stock | 26.42 | 26.43 | 26.42 | 26.43 | 5000.0 |
| 2003-08-20 17:30:00 | MSFT | Stock | 26.42 | 26.43 | 26.41 | 26.41 | 9615.0 |
| 2003-08-20 18:00:00 | MSFT | Stock | 26.4 | 26.41 | 26.4 | 26.41 | 300.0 |
| 2003-08-20 08:00:00 | NVDA | Stock | 0.1457 | 0.1466 | 0.1457 | 0.1466 | 155400.0 |
| 2003-08-20 08:30:00 | NVDA | Stock | 0.1459 | 0.1467 | 0.1456 | 0.1467 | 1188000.0 |
| 2003-08-20 09:00:00 | NVDA | Stock | 0.1461 | 0.147 | 0.145 | 0.1465 | 2528400.0 |
| 2003-08-20 09:30:00 | NVDA | Stock | 0.1471 | 0.1475 | 0.1438 | 0.1457 | 127350600.0 |
| 2003-08-20 10:00:00 | NVDA | Stock | 0.1458 | 0.1458 | 0.1444 | 0.1452 | 87387360.0 |
| 2003-08-20 10:30:00 | NVDA | Stock | 0.1452 | 0.1465 | 0.1447 | 0.1462 | 89191800.0 |
| 2003-08-20 11:00:00 | NVDA | Stock | 0.1462 | 0.1466 | 0.1455 | 0.1466 | 52844400.0 |
| 2003-08-20 11:30:00 | NVDA | Stock | 0.1466 | 0.1474 | 0.1462 | 0.1472 | 50066880.0 |
| 2003-08-20 12:00:00 | NVDA | Stock | 0.1472 | 0.1475 | 0.1464 | 0.1467 | 38799720.0 |
| 2003-08-20 12:30:00 | NVDA | Stock | 0.1467 | 0.147 | 0.1462 | 0.1468 | 21943440.0 |
> showing 50 of 35,986 rows — these rows as CSV