PREVIEW / stock_30min / 2001-07-20
file: by_date/stock_30min/2001/2001-07-20.parquet size: 524 KB rows: 27,517 symbols: 1,309
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-20 08:00:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3482 | 0.3554 | 560000.0 |
| 2001-07-20 08:30:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3532 | 0.3532 | 128800.0 |
| 2001-07-20 09:00:00 | AAPL | Stock | 0.3554 | 0.3554 | 0.3505 | 0.3505 | 1080800.0 |
| 2001-07-20 09:30:00 | AAPL | Stock | 0.3518 | 0.3563 | 0.348 | 0.3552 | 58525600.0 |
| 2001-07-20 10:00:00 | AAPL | Stock | 0.3554 | 0.3563 | 0.3507 | 0.3548 | 86419200.0 |
| 2001-07-20 10:30:00 | AAPL | Stock | 0.3548 | 0.3582 | 0.3536 | 0.3573 | 39480000.0 |
| 2001-07-20 11:00:00 | AAPL | Stock | 0.3571 | 0.358 | 0.3563 | 0.3571 | 37548000.0 |
| 2001-07-20 11:30:00 | AAPL | Stock | 0.357 | 0.3579 | 0.3545 | 0.3554 | 16609600.0 |
| 2001-07-20 12:00:00 | AAPL | Stock | 0.355 | 0.3555 | 0.3541 | 0.3545 | 8719200.0 |
| 2001-07-20 12:30:00 | AAPL | Stock | 0.3545 | 0.3568 | 0.3545 | 0.3545 | 19308800.0 |
| 2001-07-20 13:00:00 | AAPL | Stock | 0.3545 | 0.3554 | 0.3536 | 0.3543 | 21778400.0 |
| 2001-07-20 13:30:00 | AAPL | Stock | 0.3545 | 0.3545 | 0.3536 | 0.3539 | 23570400.0 |
| 2001-07-20 14:00:00 | AAPL | Stock | 0.3539 | 0.3577 | 0.3536 | 0.3573 | 21789600.0 |
| 2001-07-20 14:30:00 | AAPL | Stock | 0.3573 | 0.3582 | 0.3563 | 0.357 | 21582400.0 |
| 2001-07-20 15:00:00 | AAPL | Stock | 0.357 | 0.3577 | 0.3563 | 0.357 | 13703200.0 |
| 2001-07-20 15:30:00 | AAPL | Stock | 0.357 | 0.3575 | 0.3543 | 0.3568 | 42795200.0 |
| 2001-07-20 16:00:00 | AAPL | Stock | 0.3568 | 0.3575 | 0.3489 | 0.3548 | 16139200.0 |
| 2001-07-20 16:30:00 | AAPL | Stock | 0.357 | 0.357 | 0.357 | 0.357 | 16800.0 |
| 2001-07-20 17:00:00 | AAPL | Stock | 0.3573 | 0.3573 | 0.3568 | 0.3568 | 28000.0 |
| 2001-07-20 17:30:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3563 | 0.3563 | 33600.0 |
| 2001-07-20 18:00:00 | AAPL | Stock | 0.3563 | 0.3563 | 0.3563 | 0.3563 | 5600.0 |
| 2001-07-20 08:00:00 | MSFT | Stock | 34.44 | 34.8 | 34.175 | 34.51 | 1116000.0 |
| 2001-07-20 08:30:00 | MSFT | Stock | 34.51 | 34.625 | 34.25 | 34.425 | 1937200.0 |
| 2001-07-20 09:00:00 | MSFT | Stock | 34.4 | 35.35 | 32.02 | 34.01 | 6410600.0 |
| 2001-07-20 09:30:00 | MSFT | Stock | 34.015 | 34.37 | 33.9 | 34.09 | 29888600.0 |
| 2001-07-20 10:00:00 | MSFT | Stock | 34.09 | 34.19 | 33.95 | 34.18 | 17060000.0 |
| 2001-07-20 10:30:00 | MSFT | Stock | 34.18 | 34.345 | 34.1 | 34.24 | 12015200.0 |
| 2001-07-20 11:00:00 | MSFT | Stock | 34.24 | 34.46 | 34.16 | 34.455 | 5611000.0 |
| 2001-07-20 11:30:00 | MSFT | Stock | 34.455 | 34.7 | 34.405 | 34.455 | 7818800.0 |
| 2001-07-20 12:00:00 | MSFT | Stock | 34.5 | 34.56 | 34.405 | 34.45 | 3360600.0 |
| 2001-07-20 12:30:00 | MSFT | Stock | 34.45 | 34.525 | 34.39 | 34.47 | 3118000.0 |
| 2001-07-20 13:00:00 | MSFT | Stock | 34.47 | 34.475 | 34.25 | 34.255 | 2453400.0 |
| 2001-07-20 13:30:00 | MSFT | Stock | 34.26 | 34.46 | 34.25 | 34.405 | 2357400.0 |
| 2001-07-20 14:00:00 | MSFT | Stock | 34.405 | 34.5 | 34.285 | 34.435 | 3115000.0 |
| 2001-07-20 14:30:00 | MSFT | Stock | 34.435 | 34.48 | 34.35 | 34.415 | 3805600.0 |
| 2001-07-20 15:00:00 | MSFT | Stock | 34.415 | 34.475 | 34.325 | 34.415 | 6497800.0 |
| 2001-07-20 15:30:00 | MSFT | Stock | 34.41 | 34.625 | 34.35 | 34.6 | 8198000.0 |
| 2001-07-20 16:00:00 | MSFT | Stock | 34.6 | 34.65 | 34.005 | 34.625 | 1912600.0 |
| 2001-07-20 16:30:00 | MSFT | Stock | 34.585 | 34.7 | 34.015 | 34.665 | 507000.0 |
| 2001-07-20 17:00:00 | MSFT | Stock | 34.655 | 34.655 | 34.47 | 34.585 | 78600.0 |
| 2001-07-20 17:30:00 | MSFT | Stock | 34.6 | 34.625 | 34.5 | 34.625 | 8600.0 |
| 2001-07-20 18:00:00 | MSFT | Stock | 34.625 | 34.625 | 34.625 | 34.625 | 400.0 |
| 2001-07-20 08:00:00 | NVDA | Stock | 0.3125 | 0.3167 | 0.3125 | 0.3135 | 4392000.0 |
| 2001-07-20 08:30:00 | NVDA | Stock | 0.3167 | 0.3167 | 0.3125 | 0.3163 | 2832000.0 |
| 2001-07-20 09:00:00 | NVDA | Stock | 0.3167 | 0.3177 | 0.3126 | 0.3126 | 2040000.0 |
| 2001-07-20 09:30:00 | NVDA | Stock | 0.3133 | 0.3204 | 0.3125 | 0.3148 | 85056000.0 |
| 2001-07-20 10:00:00 | NVDA | Stock | 0.3147 | 0.315 | 0.3083 | 0.3128 | 106632000.0 |
| 2001-07-20 10:30:00 | NVDA | Stock | 0.3128 | 0.3162 | 0.3124 | 0.3144 | 68712000.0 |
| 2001-07-20 11:00:00 | NVDA | Stock | 0.3144 | 0.3144 | 0.3099 | 0.3119 | 49896000.0 |
| 2001-07-20 11:30:00 | NVDA | Stock | 0.312 | 0.3125 | 0.3073 | 0.308 | 50400000.0 |
> showing 50 of 27,517 rows — these rows as CSV