PREVIEW / stock_30min / 2009-07-02
file: by_date/stock_30min/2009/2009-07-02.parquet size: 1.3 MB rows: 75,782 symbols: 3,314
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-07-02 07:00:00 | AAPL | Stock | 5.05 | 5.05 | 5.05 | 5.05 | 2800.0 |
| 2009-07-02 07:30:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0714 | 5.0714 | 2800.0 |
| 2009-07-02 08:00:00 | AAPL | Stock | 5.0768 | 5.0975 | 5.0714 | 5.0964 | 418936.0 |
| 2009-07-02 08:30:00 | AAPL | Stock | 5.0818 | 5.0818 | 5.0393 | 5.04 | 1100680.0 |
| 2009-07-02 09:00:00 | AAPL | Stock | 5.0411 | 5.0518 | 5.0318 | 5.0471 | 1606780.0 |
| 2009-07-02 09:30:00 | AAPL | Stock | 5.0446 | 5.0468 | 4.9929 | 5.0004 | 68036164.0 |
| 2009-07-02 10:00:00 | AAPL | Stock | 5.0025 | 5.0318 | 5.0017 | 5.0204 | 54385996.0 |
| 2009-07-02 10:30:00 | AAPL | Stock | 5.0204 | 5.0357 | 5.01 | 5.0171 | 32698512.0 |
| 2009-07-02 11:00:00 | AAPL | Stock | 5.0178 | 5.0178 | 4.9971 | 5.0021 | 27582688.0 |
| 2009-07-02 11:30:00 | AAPL | Stock | 5.0018 | 5.0146 | 4.9925 | 5.0136 | 26842004.0 |
| 2009-07-02 12:00:00 | AAPL | Stock | 5.0136 | 5.0232 | 5.0061 | 5.0071 | 20498856.0 |
| 2009-07-02 12:30:00 | AAPL | Stock | 5.0071 | 5.0171 | 5.0025 | 5.0061 | 12515244.0 |
| 2009-07-02 13:00:00 | AAPL | Stock | 5.0071 | 5.0193 | 5.0061 | 5.0189 | 11636212.0 |
| 2009-07-02 13:30:00 | AAPL | Stock | 5.0189 | 5.0189 | 5.0075 | 5.0093 | 11524940.0 |
| 2009-07-02 14:00:00 | AAPL | Stock | 5.0089 | 5.0204 | 5.0071 | 5.0146 | 10407600.0 |
| 2009-07-02 14:30:00 | AAPL | Stock | 5.0143 | 5.0264 | 5.0132 | 5.0204 | 13653948.0 |
| 2009-07-02 15:00:00 | AAPL | Stock | 5.0196 | 5.0204 | 5.0036 | 5.0054 | 17893232.0 |
| 2009-07-02 15:30:00 | AAPL | Stock | 5.0054 | 5.0161 | 5.0007 | 5.0011 | 41732040.0 |
| 2009-07-02 16:00:00 | AAPL | Stock | 5.0011 | 5.0126 | 4.9964 | 5.0 | 8897840.0 |
| 2009-07-02 16:30:00 | AAPL | Stock | 5.0 | 5.0018 | 4.9936 | 5.0018 | 363132.0 |
| 2009-07-02 17:00:00 | AAPL | Stock | 5.0127 | 5.0127 | 4.9896 | 4.9946 | 2548588.0 |
| 2009-07-02 17:30:00 | AAPL | Stock | 4.9932 | 4.9986 | 4.9932 | 4.9939 | 53060.0 |
| 2009-07-02 18:00:00 | AAPL | Stock | 5.0007 | 5.0007 | 4.9982 | 4.9982 | 911792.0 |
| 2009-07-02 18:30:00 | AAPL | Stock | 4.9989 | 4.9996 | 4.9932 | 4.9996 | 32900.0 |
| 2009-07-02 19:00:00 | AAPL | Stock | 4.9964 | 4.9964 | 4.9964 | 4.9964 | 33180.0 |
| 2009-07-02 19:30:00 | AAPL | Stock | 4.9957 | 4.9957 | 4.9929 | 4.9929 | 56896.0 |
| 2009-07-02 08:00:00 | MSFT | Stock | 23.99 | 23.99 | 23.88 | 23.9 | 12151.0 |
| 2009-07-02 08:30:00 | MSFT | Stock | 23.9 | 23.9 | 23.72 | 23.75 | 20343.0 |
| 2009-07-02 09:00:00 | MSFT | Stock | 23.8 | 23.82 | 23.71 | 23.76 | 16554.0 |
| 2009-07-02 09:30:00 | MSFT | Stock | 23.76 | 23.79 | 23.25 | 23.32 | 9107399.0 |
| 2009-07-02 10:00:00 | MSFT | Stock | 23.31 | 23.42 | 23.25 | 23.41 | 6782627.0 |
| 2009-07-02 10:30:00 | MSFT | Stock | 23.4 | 23.44 | 23.3 | 23.41 | 4872345.0 |
| 2009-07-02 11:00:00 | MSFT | Stock | 23.41 | 23.43 | 23.35 | 23.35 | 2353674.0 |
| 2009-07-02 11:30:00 | MSFT | Stock | 23.355 | 23.38 | 23.21 | 23.3 | 4540676.0 |
| 2009-07-02 12:00:00 | MSFT | Stock | 23.3 | 23.31 | 23.25 | 23.305 | 1707481.0 |
| 2009-07-02 12:30:00 | MSFT | Stock | 23.305 | 23.36 | 23.24 | 23.34 | 3294583.0 |
| 2009-07-02 13:00:00 | MSFT | Stock | 23.34 | 23.42 | 23.33 | 23.35 | 2919587.0 |
| 2009-07-02 13:30:00 | MSFT | Stock | 23.35 | 23.42 | 23.31 | 23.37 | 2352957.0 |
| 2009-07-02 14:00:00 | MSFT | Stock | 23.37 | 23.44 | 23.36 | 23.41 | 3364056.0 |
| 2009-07-02 14:30:00 | MSFT | Stock | 23.41 | 23.42 | 23.32 | 23.32 | 3910942.0 |
| 2009-07-02 15:00:00 | MSFT | Stock | 23.325 | 23.44 | 23.31 | 23.37 | 5404162.0 |
| 2009-07-02 15:30:00 | MSFT | Stock | 23.37 | 23.52 | 23.32 | 23.36 | 9753127.0 |
| 2009-07-02 16:00:00 | MSFT | Stock | 23.34 | 23.41 | 23.32 | 23.389 | 1891829.0 |
| 2009-07-02 16:30:00 | MSFT | Stock | 23.4 | 23.4 | 23.36 | 23.37 | 83206.0 |
| 2009-07-02 17:00:00 | MSFT | Stock | 23.39 | 23.39 | 23.37 | 23.38 | 892669.0 |
| 2009-07-02 17:30:00 | MSFT | Stock | 23.38 | 23.39 | 23.38 | 23.39 | 657.0 |
| 2009-07-02 18:00:00 | MSFT | Stock | 23.39 | 23.39 | 23.37 | 23.37 | 33087.0 |
| 2009-07-02 18:30:00 | MSFT | Stock | 23.38 | 23.38 | 23.37 | 23.37 | 900.0 |
| 2009-07-02 19:00:00 | MSFT | Stock | 23.39 | 23.39 | 23.39 | 23.39 | 200.0 |
| 2009-07-02 19:30:00 | MSFT | Stock | 23.39 | 23.39 | 23.37 | 23.38 | 505.0 |
> showing 50 of 75,782 rows — these rows as CSV