PREVIEW / stock_30min / 2005-09-06
file: by_date/stock_30min/2005/2005-09-06.parquet size: 847 KB rows: 46,307 symbols: 2,067
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-09-06 08:00:00 | AAPL | Stock | 1.6561 | 1.6686 | 1.6561 | 1.6679 | 903700.0 |
| 2005-09-06 08:30:00 | AAPL | Stock | 1.6679 | 1.6679 | 1.6507 | 1.6625 | 409920.0 |
| 2005-09-06 09:00:00 | AAPL | Stock | 1.6507 | 1.6675 | 1.6507 | 1.6675 | 658000.0 |
| 2005-09-06 09:30:00 | AAPL | Stock | 1.6679 | 1.6725 | 1.6625 | 1.6707 | 43428308.0 |
| 2005-09-06 10:00:00 | AAPL | Stock | 1.6704 | 1.7064 | 1.67 | 1.7054 | 71743868.0 |
| 2005-09-06 10:30:00 | AAPL | Stock | 1.7054 | 1.7268 | 1.7025 | 1.7139 | 108159380.0 |
| 2005-09-06 11:00:00 | AAPL | Stock | 1.7139 | 1.7229 | 1.7121 | 1.7221 | 66550036.0 |
| 2005-09-06 11:30:00 | AAPL | Stock | 1.7225 | 1.7396 | 1.7196 | 1.7379 | 114476908.0 |
| 2005-09-06 12:00:00 | AAPL | Stock | 1.7379 | 1.7429 | 1.7329 | 1.7429 | 60782512.0 |
| 2005-09-06 12:30:00 | AAPL | Stock | 1.7429 | 1.7432 | 1.7336 | 1.7368 | 53118800.0 |
| 2005-09-06 13:00:00 | AAPL | Stock | 1.7371 | 1.7382 | 1.7264 | 1.7296 | 53185748.0 |
| 2005-09-06 13:30:00 | AAPL | Stock | 1.7296 | 1.7357 | 1.7275 | 1.7354 | 26826436.0 |
| 2005-09-06 14:00:00 | AAPL | Stock | 1.7354 | 1.7418 | 1.7343 | 1.7396 | 36565620.0 |
| 2005-09-06 14:30:00 | AAPL | Stock | 1.7393 | 1.7396 | 1.7325 | 1.7361 | 33797568.0 |
| 2005-09-06 15:00:00 | AAPL | Stock | 1.7361 | 1.7457 | 1.7346 | 1.7382 | 48655712.0 |
| 2005-09-06 15:30:00 | AAPL | Stock | 1.7379 | 1.7446 | 1.7375 | 1.7429 | 78235248.0 |
| 2005-09-06 16:00:00 | AAPL | Stock | 1.7425 | 1.7471 | 1.7404 | 1.7471 | 5922924.0 |
| 2005-09-06 16:30:00 | AAPL | Stock | 1.7471 | 1.75 | 1.6507 | 1.7482 | 979720.0 |
| 2005-09-06 17:00:00 | AAPL | Stock | 1.7482 | 1.7489 | 1.7468 | 1.7486 | 246008.0 |
| 2005-09-06 17:30:00 | AAPL | Stock | 1.7486 | 1.7489 | 1.7446 | 1.7489 | 245000.0 |
| 2005-09-06 18:00:00 | AAPL | Stock | 1.7428 | 1.7496 | 1.7428 | 1.7493 | 141764.0 |
| 2005-09-06 08:00:00 | MSFT | Stock | 27.08 | 27.14 | 27.02 | 27.12 | 25329.0 |
| 2005-09-06 08:30:00 | MSFT | Stock | 27.13 | 27.14 | 27.02 | 27.11 | 39907.0 |
| 2005-09-06 09:00:00 | MSFT | Stock | 27.11 | 27.13 | 27.0 | 27.06 | 49230.0 |
| 2005-09-06 09:30:00 | MSFT | Stock | 27.06 | 27.13 | 27.02 | 27.11 | 5164738.0 |
| 2005-09-06 10:00:00 | MSFT | Stock | 27.11 | 27.29 | 27.09 | 27.25 | 5004052.0 |
| 2005-09-06 10:30:00 | MSFT | Stock | 27.25 | 27.26 | 27.15 | 27.17 | 4222626.0 |
| 2005-09-06 11:00:00 | MSFT | Stock | 27.17 | 27.2 | 27.15 | 27.2 | 2348003.0 |
| 2005-09-06 11:30:00 | MSFT | Stock | 27.2 | 27.2 | 27.12 | 27.15 | 1955635.0 |
| 2005-09-06 12:00:00 | MSFT | Stock | 27.14 | 27.2 | 27.14 | 27.17 | 1391611.0 |
| 2005-09-06 12:30:00 | MSFT | Stock | 27.16 | 27.17 | 27.12 | 27.16 | 1406213.0 |
| 2005-09-06 13:00:00 | MSFT | Stock | 27.17 | 27.2 | 27.07 | 27.09 | 2029341.0 |
| 2005-09-06 13:30:00 | MSFT | Stock | 27.09 | 27.18 | 27.04 | 27.11 | 1847943.0 |
| 2005-09-06 14:00:00 | MSFT | Stock | 27.12 | 27.13 | 27.08 | 27.09 | 2389504.0 |
| 2005-09-06 14:30:00 | MSFT | Stock | 27.1 | 27.11 | 27.02 | 27.03 | 3378140.0 |
| 2005-09-06 15:00:00 | MSFT | Stock | 27.04 | 27.09 | 27.03 | 27.06 | 2930347.0 |
| 2005-09-06 15:30:00 | MSFT | Stock | 27.06 | 27.06 | 26.98 | 27.01 | 9001192.0 |
| 2005-09-06 16:00:00 | MSFT | Stock | 27.0 | 27.126 | 26.98 | 27.126 | 703335.0 |
| 2005-09-06 16:30:00 | MSFT | Stock | 27.0 | 27.022 | 26.98 | 26.98 | 26496.0 |
| 2005-09-06 17:30:00 | MSFT | Stock | 27.0 | 27.01 | 27.0 | 27.0 | 4657.0 |
| 2005-09-06 18:00:00 | MSFT | Stock | 27.01 | 27.02 | 27.0 | 27.02 | 3700.0 |
| 2005-09-06 08:30:00 | NVDA | Stock | 0.2542 | 0.2542 | 0.2542 | 0.2542 | 144000.0 |
| 2005-09-06 09:00:00 | NVDA | Stock | 0.2516 | 0.2545 | 0.2516 | 0.2525 | 816000.0 |
| 2005-09-06 09:30:00 | NVDA | Stock | 0.2525 | 0.2532 | 0.2487 | 0.2497 | 97324560.0 |
| 2005-09-06 10:00:00 | NVDA | Stock | 0.2498 | 0.2547 | 0.2495 | 0.2547 | 58088640.0 |
| 2005-09-06 10:30:00 | NVDA | Stock | 0.2548 | 0.255 | 0.2526 | 0.2527 | 36722040.0 |
| 2005-09-06 11:00:00 | NVDA | Stock | 0.2528 | 0.2538 | 0.2528 | 0.2532 | 21489960.0 |
| 2005-09-06 11:30:00 | NVDA | Stock | 0.2532 | 0.2536 | 0.2527 | 0.2528 | 17912880.0 |
| 2005-09-06 12:00:00 | NVDA | Stock | 0.2528 | 0.2537 | 0.2527 | 0.2536 | 8538960.0 |
| 2005-09-06 12:30:00 | NVDA | Stock | 0.2533 | 0.2537 | 0.2529 | 0.2535 | 12412920.0 |
> showing 50 of 46,307 rows — these rows as CSV