PREVIEW / stock_30min / 2007-05-09
file: by_date/stock_30min/2007/2007-05-09.parquet size: 1.0 MB rows: 58,905 symbols: 2,734
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-09 09:30:00 | AAPL | Stock | 3.7468 | 3.7779 | 3.7461 | 3.7714 | 98092848.0 |
| 2007-05-09 10:00:00 | AAPL | Stock | 3.7714 | 3.7943 | 3.7696 | 3.7821 | 71324120.0 |
| 2007-05-09 10:30:00 | AAPL | Stock | 3.7825 | 3.7825 | 3.7704 | 3.78 | 49259980.0 |
| 2007-05-09 11:00:00 | AAPL | Stock | 3.78 | 3.7857 | 3.7704 | 3.7736 | 34062420.0 |
| 2007-05-09 11:30:00 | AAPL | Stock | 3.7736 | 3.775 | 3.7614 | 3.7621 | 31447164.0 |
| 2007-05-09 12:00:00 | AAPL | Stock | 3.7621 | 3.77 | 3.7604 | 3.7679 | 24211936.0 |
| 2007-05-09 12:30:00 | AAPL | Stock | 3.7675 | 3.7779 | 3.7625 | 3.7732 | 20311256.0 |
| 2007-05-09 13:00:00 | AAPL | Stock | 3.7732 | 3.7762 | 3.7707 | 3.7714 | 13082272.0 |
| 2007-05-09 13:30:00 | AAPL | Stock | 3.7718 | 3.7732 | 3.7661 | 3.7668 | 17961160.0 |
| 2007-05-09 14:00:00 | AAPL | Stock | 3.7668 | 3.7886 | 3.7607 | 3.7793 | 57547140.0 |
| 2007-05-09 14:30:00 | AAPL | Stock | 3.7793 | 3.8025 | 3.7725 | 3.7975 | 68231912.0 |
| 2007-05-09 15:00:00 | AAPL | Stock | 3.7978 | 3.8021 | 3.7804 | 3.7932 | 64012620.0 |
| 2007-05-09 15:30:00 | AAPL | Stock | 3.7929 | 3.8196 | 3.7918 | 3.8196 | 106106812.0 |
| 2007-05-09 16:00:00 | AAPL | Stock | 3.82 | 3.82 | 3.8171 | 3.8171 | 2452044.0 |
| 2007-05-09 09:30:00 | MSFT | Stock | 30.7 | 30.93 | 30.57 | 30.7 | 4194451.0 |
| 2007-05-09 10:00:00 | MSFT | Stock | 30.7 | 30.84 | 30.7 | 30.75 | 2801863.0 |
| 2007-05-09 10:30:00 | MSFT | Stock | 30.76 | 30.79 | 30.7 | 30.71 | 2714752.0 |
| 2007-05-09 11:00:00 | MSFT | Stock | 30.71 | 30.81 | 30.7 | 30.74 | 2321927.0 |
| 2007-05-09 11:30:00 | MSFT | Stock | 30.74 | 30.83 | 30.74 | 30.77 | 2780887.0 |
| 2007-05-09 12:00:00 | MSFT | Stock | 30.78 | 30.81 | 30.72 | 30.8 | 1771414.0 |
| 2007-05-09 12:30:00 | MSFT | Stock | 30.79 | 30.83 | 30.75 | 30.8 | 2181570.0 |
| 2007-05-09 13:00:00 | MSFT | Stock | 30.8 | 30.82 | 30.75 | 30.75 | 1741829.0 |
| 2007-05-09 13:30:00 | MSFT | Stock | 30.75 | 30.77 | 30.73 | 30.75 | 2713923.0 |
| 2007-05-09 14:00:00 | MSFT | Stock | 30.75 | 30.89 | 30.7 | 30.77 | 6240558.0 |
| 2007-05-09 14:30:00 | MSFT | Stock | 30.77 | 30.92 | 30.76 | 30.9 | 5257135.0 |
| 2007-05-09 15:00:00 | MSFT | Stock | 30.91 | 30.93 | 30.8 | 30.84 | 4923811.0 |
| 2007-05-09 15:30:00 | MSFT | Stock | 30.83 | 30.9 | 30.77 | 30.77 | 6709232.0 |
| 2007-05-09 16:00:00 | MSFT | Stock | 30.78 | 30.79 | 30.78 | 30.78 | 621112.0 |
| 2007-05-09 08:00:00 | NVDA | Stock | 0.5483 | 0.5483 | 0.5483 | 0.5483 | 6000.0 |
| 2007-05-09 09:00:00 | NVDA | Stock | 0.5495 | 0.5507 | 0.5492 | 0.55 | 521940.0 |
| 2007-05-09 09:30:00 | NVDA | Stock | 0.5508 | 0.5515 | 0.5445 | 0.5487 | 48161700.0 |
| 2007-05-09 10:00:00 | NVDA | Stock | 0.5487 | 0.5542 | 0.5485 | 0.5492 | 37521060.0 |
| 2007-05-09 10:30:00 | NVDA | Stock | 0.5492 | 0.5507 | 0.5472 | 0.549 | 24254220.0 |
| 2007-05-09 11:00:00 | NVDA | Stock | 0.549 | 0.5502 | 0.5482 | 0.5494 | 28385040.0 |
| 2007-05-09 11:30:00 | NVDA | Stock | 0.5493 | 0.5537 | 0.549 | 0.5508 | 25857180.0 |
| 2007-05-09 12:00:00 | NVDA | Stock | 0.5507 | 0.5545 | 0.5507 | 0.5545 | 10075980.0 |
| 2007-05-09 12:30:00 | NVDA | Stock | 0.5547 | 0.557 | 0.552 | 0.556 | 20299500.0 |
| 2007-05-09 13:00:00 | NVDA | Stock | 0.556 | 0.5567 | 0.5552 | 0.5553 | 10739100.0 |
| 2007-05-09 13:30:00 | NVDA | Stock | 0.5555 | 0.556 | 0.5527 | 0.5545 | 12214380.0 |
| 2007-05-09 14:00:00 | NVDA | Stock | 0.5547 | 0.5577 | 0.5508 | 0.5567 | 29468040.0 |
| 2007-05-09 14:30:00 | NVDA | Stock | 0.5565 | 0.56 | 0.5545 | 0.5588 | 38701260.0 |
| 2007-05-09 15:00:00 | NVDA | Stock | 0.5588 | 0.56 | 0.5578 | 0.5592 | 49664280.0 |
| 2007-05-09 15:30:00 | NVDA | Stock | 0.5592 | 0.5605 | 0.5573 | 0.5578 | 57801300.0 |
| 2007-05-09 16:00:00 | NVDA | Stock | 0.5573 | 0.5647 | 0.5573 | 0.5597 | 7863180.0 |
| 2007-05-09 16:30:00 | NVDA | Stock | 0.5603 | 0.5608 | 0.56 | 0.5607 | 96000.0 |
| 2007-05-09 17:00:00 | NVDA | Stock | 0.56 | 0.56 | 0.56 | 0.56 | 6000.0 |
| 2007-05-09 17:30:00 | NVDA | Stock | 0.5625 | 0.5627 | 0.5608 | 0.5608 | 294000.0 |
| 2007-05-09 18:00:00 | NVDA | Stock | 0.5623 | 0.5625 | 0.5608 | 0.5623 | 403140.0 |
| 2007-05-09 18:30:00 | NVDA | Stock | 0.5625 | 0.5625 | 0.561 | 0.561 | 109200.0 |
| 2007-05-09 19:00:00 | NVDA | Stock | 0.5617 | 0.5617 | 0.561 | 0.561 | 61800.0 |
> showing 50 of 58,905 rows — these rows as CSV