PREVIEW / stock_30min / 2005-08-18
file: by_date/stock_30min/2005/2005-08-18.parquet size: 824 KB rows: 44,804 symbols: 2,060
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-08-18 08:00:00 | AAPL | Stock | 1.6821 | 1.6857 | 1.6786 | 1.6786 | 25452.0 |
| 2005-08-18 08:30:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6768 | 1.6768 | 19600.0 |
| 2005-08-18 09:00:00 | AAPL | Stock | 1.6768 | 1.6804 | 1.675 | 1.675 | 1204056.0 |
| 2005-08-18 09:30:00 | AAPL | Stock | 1.6754 | 1.6786 | 1.6525 | 1.6586 | 63494900.0 |
| 2005-08-18 10:00:00 | AAPL | Stock | 1.6589 | 1.6618 | 1.6529 | 1.6557 | 37029384.0 |
| 2005-08-18 10:30:00 | AAPL | Stock | 1.6557 | 1.6596 | 1.6371 | 1.6386 | 59070676.0 |
| 2005-08-18 11:00:00 | AAPL | Stock | 1.6386 | 1.65 | 1.6339 | 1.6475 | 51855552.0 |
| 2005-08-18 11:30:00 | AAPL | Stock | 1.6471 | 1.6471 | 1.6404 | 1.6411 | 19921356.0 |
| 2005-08-18 12:00:00 | AAPL | Stock | 1.6407 | 1.6464 | 1.6404 | 1.6429 | 13105680.0 |
| 2005-08-18 12:30:00 | AAPL | Stock | 1.6429 | 1.6443 | 1.6407 | 1.6436 | 13029772.0 |
| 2005-08-18 13:00:00 | AAPL | Stock | 1.6436 | 1.6532 | 1.6414 | 1.6529 | 19802776.0 |
| 2005-08-18 13:30:00 | AAPL | Stock | 1.6529 | 1.6604 | 1.6482 | 1.6561 | 42410844.0 |
| 2005-08-18 14:00:00 | AAPL | Stock | 1.6557 | 1.6557 | 1.6482 | 1.6486 | 20370812.0 |
| 2005-08-18 14:30:00 | AAPL | Stock | 1.6496 | 1.6571 | 1.6439 | 1.6479 | 26491136.0 |
| 2005-08-18 15:00:00 | AAPL | Stock | 1.6475 | 1.6518 | 1.6421 | 1.6446 | 21640584.0 |
| 2005-08-18 15:30:00 | AAPL | Stock | 1.645 | 1.6561 | 1.6446 | 1.6529 | 40898088.0 |
| 2005-08-18 16:00:00 | AAPL | Stock | 1.6536 | 1.6543 | 1.6518 | 1.6532 | 1769656.0 |
| 2005-08-18 16:30:00 | AAPL | Stock | 1.6536 | 1.6546 | 1.6536 | 1.6546 | 386064.0 |
| 2005-08-18 17:00:00 | AAPL | Stock | 1.6529 | 1.6529 | 1.6529 | 1.6529 | 21000.0 |
| 2005-08-18 18:00:00 | AAPL | Stock | 1.6546 | 1.6564 | 1.6546 | 1.6546 | 27496.0 |
| 2005-08-18 08:00:00 | MSFT | Stock | 26.93 | 26.93 | 26.9 | 26.9 | 2440.0 |
| 2005-08-18 08:30:00 | MSFT | Stock | 26.9 | 26.9 | 26.8 | 26.87 | 7417.0 |
| 2005-08-18 09:00:00 | MSFT | Stock | 26.87 | 26.92 | 26.82 | 26.87 | 43627.0 |
| 2005-08-18 09:30:00 | MSFT | Stock | 26.89 | 26.96 | 26.84 | 26.89 | 3897362.0 |
| 2005-08-18 10:00:00 | MSFT | Stock | 26.9 | 26.96 | 26.86 | 26.93 | 2897677.0 |
| 2005-08-18 10:30:00 | MSFT | Stock | 26.92 | 26.96 | 26.86 | 26.89 | 2870703.0 |
| 2005-08-18 11:00:00 | MSFT | Stock | 26.88 | 26.952 | 26.85 | 26.86 | 1871309.0 |
| 2005-08-18 11:30:00 | MSFT | Stock | 26.85 | 26.93 | 26.84 | 26.88 | 1719947.0 |
| 2005-08-18 12:00:00 | MSFT | Stock | 26.89 | 26.95 | 26.87 | 26.94 | 2437228.0 |
| 2005-08-18 12:30:00 | MSFT | Stock | 26.94 | 26.96 | 26.89 | 26.92 | 1307258.0 |
| 2005-08-18 13:00:00 | MSFT | Stock | 26.92 | 27.02 | 26.9 | 27.02 | 1529390.0 |
| 2005-08-18 13:30:00 | MSFT | Stock | 27.02 | 27.08 | 26.99 | 27.01 | 2276701.0 |
| 2005-08-18 14:00:00 | MSFT | Stock | 27.0 | 27.01 | 26.86 | 26.88 | 4637162.0 |
| 2005-08-18 14:30:00 | MSFT | Stock | 26.88 | 26.93 | 26.85 | 26.92 | 1783025.0 |
| 2005-08-18 15:00:00 | MSFT | Stock | 26.91 | 26.92 | 26.8 | 26.82 | 4148180.0 |
| 2005-08-18 15:30:00 | MSFT | Stock | 26.83 | 26.9 | 26.81 | 26.81 | 6184185.0 |
| 2005-08-18 16:00:00 | MSFT | Stock | 26.82 | 26.821 | 26.76 | 26.82 | 1432782.0 |
| 2005-08-18 16:30:00 | MSFT | Stock | 26.81 | 26.82 | 26.8 | 26.81 | 69808.0 |
| 2005-08-18 17:00:00 | MSFT | Stock | 26.81 | 26.81 | 26.81 | 26.81 | 4760.0 |
| 2005-08-18 17:30:00 | MSFT | Stock | 26.8 | 26.81 | 26.78 | 26.81 | 5200.0 |
| 2005-08-18 18:00:00 | MSFT | Stock | 26.81 | 26.81 | 26.75 | 26.77 | 7990.0 |
| 2005-08-18 08:30:00 | NVDA | Stock | 0.2522 | 0.2522 | 0.2522 | 0.2522 | 24000.0 |
| 2005-08-18 09:00:00 | NVDA | Stock | 0.2512 | 0.2512 | 0.2497 | 0.2497 | 432000.0 |
| 2005-08-18 09:30:00 | NVDA | Stock | 0.2497 | 0.2509 | 0.247 | 0.2483 | 88053720.0 |
| 2005-08-18 10:00:00 | NVDA | Stock | 0.2482 | 0.2493 | 0.2462 | 0.249 | 89304960.0 |
| 2005-08-18 10:30:00 | NVDA | Stock | 0.249 | 0.2499 | 0.2464 | 0.2487 | 72919800.0 |
| 2005-08-18 11:00:00 | NVDA | Stock | 0.2487 | 0.2487 | 0.2479 | 0.2479 | 42858360.0 |
| 2005-08-18 11:30:00 | NVDA | Stock | 0.2479 | 0.2483 | 0.2468 | 0.2473 | 31332960.0 |
| 2005-08-18 12:00:00 | NVDA | Stock | 0.2473 | 0.2485 | 0.2472 | 0.2482 | 23940600.0 |
| 2005-08-18 12:30:00 | NVDA | Stock | 0.2482 | 0.2484 | 0.2475 | 0.2477 | 28963440.0 |
> showing 50 of 44,804 rows — these rows as CSV