PREVIEW / stock_1hour / 2009-10-09
file: by_date/stock_1hour/2009/2009-10-09.parquet size: 872 KB rows: 41,648 symbols: 3,381
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-09 04:00:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 2800.0 |
| 2009-10-09 06:00:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 8820.0 |
| 2009-10-09 07:00:00 | AAPL | Stock | 6.7714 | 6.7721 | 6.7679 | 6.7714 | 30800.0 |
| 2009-10-09 08:00:00 | AAPL | Stock | 6.7718 | 6.7732 | 6.7332 | 6.7429 | 1092700.0 |
| 2009-10-09 09:00:00 | AAPL | Stock | 6.7429 | 6.8107 | 6.7325 | 6.7929 | 61575752.0 |
| 2009-10-09 10:00:00 | AAPL | Stock | 6.7929 | 6.8054 | 6.7757 | 6.7829 | 48983564.0 |
| 2009-10-09 11:00:00 | AAPL | Stock | 6.7829 | 6.7968 | 6.7679 | 6.7679 | 32271484.0 |
| 2009-10-09 12:00:00 | AAPL | Stock | 6.7679 | 6.78 | 6.7614 | 6.7789 | 28214508.0 |
| 2009-10-09 13:00:00 | AAPL | Stock | 6.7782 | 6.7929 | 6.7768 | 6.7849 | 24344936.0 |
| 2009-10-09 14:00:00 | AAPL | Stock | 6.785 | 6.7979 | 6.775 | 6.7925 | 26299308.0 |
| 2009-10-09 15:00:00 | AAPL | Stock | 6.7925 | 6.8021 | 6.7821 | 6.8018 | 54283964.0 |
| 2009-10-09 16:00:00 | AAPL | Stock | 6.8011 | 6.8026 | 6.7596 | 6.8007 | 10908044.0 |
| 2009-10-09 17:00:00 | AAPL | Stock | 6.7802 | 6.8025 | 6.7802 | 6.7996 | 205464.0 |
| 2009-10-09 18:00:00 | AAPL | Stock | 6.7982 | 6.8036 | 6.7982 | 6.8018 | 262360.0 |
| 2009-10-09 19:00:00 | AAPL | Stock | 6.8036 | 6.805 | 6.8018 | 6.805 | 65212.0 |
| 2009-10-09 07:00:00 | MSFT | Stock | 25.85 | 25.85 | 25.77 | 25.77 | 1700.0 |
| 2009-10-09 08:00:00 | MSFT | Stock | 25.77 | 25.8 | 25.6 | 25.6 | 60362.0 |
| 2009-10-09 09:00:00 | MSFT | Stock | 25.62 | 25.79 | 25.53 | 25.733 | 4491096.0 |
| 2009-10-09 10:00:00 | MSFT | Stock | 25.73 | 25.74 | 25.47 | 25.54 | 7361186.0 |
| 2009-10-09 11:00:00 | MSFT | Stock | 25.54 | 25.69 | 25.52 | 25.665 | 4461568.0 |
| 2009-10-09 12:00:00 | MSFT | Stock | 25.67 | 25.68 | 25.53 | 25.545 | 2843079.0 |
| 2009-10-09 13:00:00 | MSFT | Stock | 25.545 | 25.6 | 25.47 | 25.492 | 2901178.0 |
| 2009-10-09 14:00:00 | MSFT | Stock | 25.5 | 25.56 | 25.46 | 25.557 | 3138570.0 |
| 2009-10-09 15:00:00 | MSFT | Stock | 25.55 | 25.6 | 25.52 | 25.58 | 7790421.0 |
| 2009-10-09 16:00:00 | MSFT | Stock | 25.57 | 25.67 | 25.5 | 25.56 | 4849602.0 |
| 2009-10-09 17:00:00 | MSFT | Stock | 25.56 | 25.6 | 25.56 | 25.6 | 440.0 |
| 2009-10-09 18:00:00 | MSFT | Stock | 25.55 | 25.59 | 25.55 | 25.58 | 18570.0 |
| 2009-10-09 19:00:00 | MSFT | Stock | 25.6 | 25.6 | 25.58 | 25.6 | 1556.0 |
| 2009-10-09 08:00:00 | NVDA | Stock | 0.3473 | 0.3473 | 0.3468 | 0.3468 | 32000.0 |
| 2009-10-09 09:00:00 | NVDA | Stock | 0.3485 | 0.3548 | 0.3473 | 0.3542 | 150337800.0 |
| 2009-10-09 10:00:00 | NVDA | Stock | 0.3545 | 0.3545 | 0.352 | 0.3525 | 134655080.0 |
| 2009-10-09 11:00:00 | NVDA | Stock | 0.3527 | 0.3535 | 0.3521 | 0.3528 | 102288320.0 |
| 2009-10-09 12:00:00 | NVDA | Stock | 0.3528 | 0.3533 | 0.3518 | 0.3522 | 38998520.0 |
| 2009-10-09 13:00:00 | NVDA | Stock | 0.3522 | 0.353 | 0.3515 | 0.3522 | 44327960.0 |
| 2009-10-09 14:00:00 | NVDA | Stock | 0.3522 | 0.3538 | 0.3515 | 0.3538 | 42729160.0 |
| 2009-10-09 15:00:00 | NVDA | Stock | 0.3538 | 0.3548 | 0.3528 | 0.354 | 90532120.0 |
| 2009-10-09 16:00:00 | NVDA | Stock | 0.3538 | 0.3548 | 0.3498 | 0.3548 | 10064280.0 |
| 2009-10-09 18:00:00 | NVDA | Stock | 0.3542 | 0.3548 | 0.3542 | 0.3548 | 48000.0 |
| 2009-10-09 19:00:00 | NVDA | Stock | 0.3542 | 0.3542 | 0.3538 | 0.3538 | 18400.0 |
| 2009-10-09 08:00:00 | AMZN | Stock | 4.751 | 4.755 | 4.74 | 4.7495 | 80000.0 |
| 2009-10-09 09:00:00 | AMZN | Stock | 4.747 | 4.785 | 4.713 | 4.763 | 18284720.0 |
| 2009-10-09 10:00:00 | AMZN | Stock | 4.763 | 4.7885 | 4.741 | 4.7835 | 15946400.0 |
| 2009-10-09 11:00:00 | AMZN | Stock | 4.7835 | 4.7865 | 4.7675 | 4.773 | 8432380.0 |
| 2009-10-09 12:00:00 | AMZN | Stock | 4.7725 | 4.778 | 4.75 | 4.777 | 6715060.0 |
| 2009-10-09 13:00:00 | AMZN | Stock | 4.777 | 4.7975 | 4.7705 | 4.775 | 9575740.0 |
| 2009-10-09 14:00:00 | AMZN | Stock | 4.775 | 4.7775 | 4.758 | 4.777 | 7495020.0 |
| 2009-10-09 15:00:00 | AMZN | Stock | 4.776 | 4.7945 | 4.76 | 4.785 | 19221240.0 |
| 2009-10-09 16:00:00 | AMZN | Stock | 4.7855 | 4.795 | 4.7678 | 4.778 | 6836320.0 |
| 2009-10-09 17:00:00 | AMZN | Stock | 4.7855 | 4.7855 | 4.78 | 4.78 | 4800.0 |
| 2009-10-09 18:00:00 | AMZN | Stock | 4.7825 | 4.7855 | 4.7825 | 4.784 | 21860.0 |
> showing 50 of 41,648 rows — these rows as CSV