PREVIEW / stock_30min / 2009-09-02
file: by_date/stock_30min/2009/2009-09-02.parquet size: 1.3 MB rows: 73,844 symbols: 3,359
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-09-02 04:30:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8214 | 5.8214 | 28000.0 |
| 2009-09-02 05:30:00 | AAPL | Stock | 5.8482 | 5.8482 | 5.8482 | 5.8482 | 2800.0 |
| 2009-09-02 06:30:00 | AAPL | Stock | 5.8682 | 5.8754 | 5.8675 | 5.875 | 47544.0 |
| 2009-09-02 07:00:00 | AAPL | Stock | 5.8757 | 5.8839 | 5.8757 | 5.8821 | 57400.0 |
| 2009-09-02 07:30:00 | AAPL | Stock | 5.8821 | 5.8911 | 5.8821 | 5.8911 | 28000.0 |
| 2009-09-02 08:00:00 | AAPL | Stock | 5.8929 | 5.8964 | 5.8843 | 5.8907 | 352072.0 |
| 2009-09-02 08:30:00 | AAPL | Stock | 5.8911 | 5.9 | 5.8839 | 5.8954 | 295372.0 |
| 2009-09-02 09:00:00 | AAPL | Stock | 5.8964 | 5.9 | 5.8711 | 5.8757 | 866180.0 |
| 2009-09-02 09:30:00 | AAPL | Stock | 5.8793 | 5.9782 | 5.8611 | 5.9318 | 80959900.0 |
| 2009-09-02 10:00:00 | AAPL | Stock | 5.9318 | 5.9643 | 5.9011 | 5.9467 | 53193420.0 |
| 2009-09-02 10:30:00 | AAPL | Stock | 5.9468 | 5.9861 | 5.9429 | 5.9704 | 35332332.0 |
| 2009-09-02 11:00:00 | AAPL | Stock | 5.9707 | 5.9732 | 5.9489 | 5.9686 | 21053844.0 |
| 2009-09-02 11:30:00 | AAPL | Stock | 5.9693 | 5.9739 | 5.9379 | 5.9407 | 17132528.0 |
| 2009-09-02 12:00:00 | AAPL | Stock | 5.9404 | 5.9618 | 5.9289 | 5.9575 | 16436868.0 |
| 2009-09-02 12:30:00 | AAPL | Stock | 5.9579 | 5.9618 | 5.9457 | 5.9464 | 12500488.0 |
| 2009-09-02 13:00:00 | AAPL | Stock | 5.9464 | 5.9482 | 5.9314 | 5.9432 | 8640716.0 |
| 2009-09-02 13:30:00 | AAPL | Stock | 5.9436 | 5.9439 | 5.9144 | 5.9171 | 15735244.0 |
| 2009-09-02 14:00:00 | AAPL | Stock | 5.9171 | 5.9264 | 5.9111 | 5.9204 | 16955176.0 |
| 2009-09-02 14:30:00 | AAPL | Stock | 5.9204 | 5.9325 | 5.9193 | 5.925 | 16561720.0 |
| 2009-09-02 15:00:00 | AAPL | Stock | 5.925 | 5.9396 | 5.9132 | 5.9311 | 24266900.0 |
| 2009-09-02 15:30:00 | AAPL | Stock | 5.9318 | 5.9343 | 5.8939 | 5.8982 | 27885536.0 |
| 2009-09-02 16:00:00 | AAPL | Stock | 5.8989 | 5.9363 | 5.885 | 5.8993 | 5068840.0 |
| 2009-09-02 16:30:00 | AAPL | Stock | 5.9018 | 5.9329 | 5.8975 | 5.9064 | 478520.0 |
| 2009-09-02 17:00:00 | AAPL | Stock | 5.9064 | 5.9068 | 5.9043 | 5.9043 | 27664.0 |
| 2009-09-02 17:30:00 | AAPL | Stock | 5.9064 | 5.9089 | 5.9064 | 5.9089 | 12320.0 |
| 2009-09-02 18:00:00 | AAPL | Stock | 5.9086 | 5.9089 | 5.8993 | 5.9054 | 286020.0 |
| 2009-09-02 18:30:00 | AAPL | Stock | 5.9018 | 5.9054 | 5.8979 | 5.9054 | 30800.0 |
| 2009-09-02 19:00:00 | AAPL | Stock | 5.9036 | 5.9064 | 5.9036 | 5.9064 | 28000.0 |
| 2009-09-02 19:30:00 | AAPL | Stock | 5.9032 | 5.9089 | 5.9032 | 5.9089 | 77448.0 |
| 2009-09-02 07:30:00 | MSFT | Stock | 23.86 | 23.86 | 23.86 | 23.86 | 200.0 |
| 2009-09-02 08:00:00 | MSFT | Stock | 23.96 | 23.96 | 23.9 | 23.9 | 3416.0 |
| 2009-09-02 08:30:00 | MSFT | Stock | 23.9 | 24.0 | 23.88 | 23.88 | 6716.0 |
| 2009-09-02 09:00:00 | MSFT | Stock | 24.0 | 24.0 | 23.8 | 23.82 | 26019.0 |
| 2009-09-02 09:30:00 | MSFT | Stock | 23.82 | 24.04 | 23.78 | 23.99 | 7943669.0 |
| 2009-09-02 10:00:00 | MSFT | Stock | 23.99 | 24.04 | 23.94 | 23.97 | 4129576.0 |
| 2009-09-02 10:30:00 | MSFT | Stock | 23.98 | 24.13 | 23.9 | 24.11 | 3293541.0 |
| 2009-09-02 11:00:00 | MSFT | Stock | 24.11 | 24.13 | 24.04 | 24.12 | 1727288.0 |
| 2009-09-02 11:30:00 | MSFT | Stock | 24.12 | 24.14 | 23.96 | 23.998 | 2418906.0 |
| 2009-09-02 12:00:00 | MSFT | Stock | 23.993 | 24.04 | 23.95 | 24.017 | 2197076.0 |
| 2009-09-02 12:30:00 | MSFT | Stock | 24.01 | 24.04 | 23.97 | 23.977 | 1819828.0 |
| 2009-09-02 13:00:00 | MSFT | Stock | 23.97 | 24.0 | 23.94 | 23.975 | 2257966.0 |
| 2009-09-02 13:30:00 | MSFT | Stock | 23.977 | 24.0 | 23.96 | 23.97 | 997059.0 |
| 2009-09-02 14:00:00 | MSFT | Stock | 23.961 | 24.0 | 23.95 | 23.98 | 1338334.0 |
| 2009-09-02 14:30:00 | MSFT | Stock | 23.98 | 24.01 | 23.95 | 23.961 | 1787726.0 |
| 2009-09-02 15:00:00 | MSFT | Stock | 23.961 | 24.03 | 23.95 | 23.98 | 2332422.0 |
| 2009-09-02 15:30:00 | MSFT | Stock | 23.99 | 24.0 | 23.86 | 23.86 | 6021160.0 |
| 2009-09-02 16:00:00 | MSFT | Stock | 23.86 | 24.093 | 23.76 | 23.8 | 1897121.0 |
| 2009-09-02 16:30:00 | MSFT | Stock | 23.8 | 23.987 | 23.8 | 23.86 | 23786.0 |
| 2009-09-02 17:00:00 | MSFT | Stock | 23.86 | 23.86 | 23.86 | 23.86 | 1000.0 |
| 2009-09-02 18:00:00 | MSFT | Stock | 23.86 | 23.88 | 23.86 | 23.88 | 3087.0 |
> showing 50 of 73,844 rows — these rows as CSV