PREVIEW / stock_30min / 2010-07-02
file: by_date/stock_30min/2010/2010-07-02.parquet size: 1.3 MB rows: 71,264 symbols: 3,457
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-02 04:00:00 | AAPL | Stock | 8.9107 | 8.9107 | 8.9107 | 8.9107 | 2800.0 |
| 2010-07-02 05:30:00 | AAPL | Stock | 8.9661 | 8.975 | 8.9661 | 8.975 | 5600.0 |
| 2010-07-02 06:00:00 | AAPL | Stock | 8.975 | 8.9786 | 8.9746 | 8.9786 | 8400.0 |
| 2010-07-02 06:30:00 | AAPL | Stock | 8.9607 | 8.9643 | 8.9393 | 8.9461 | 43400.0 |
| 2010-07-02 07:00:00 | AAPL | Stock | 8.9364 | 8.9364 | 8.8929 | 8.9014 | 186480.0 |
| 2010-07-02 07:30:00 | AAPL | Stock | 8.9004 | 8.9214 | 8.9 | 8.9157 | 345604.0 |
| 2010-07-02 08:00:00 | AAPL | Stock | 8.9196 | 8.9225 | 8.85 | 8.89 | 1826188.0 |
| 2010-07-02 08:30:00 | AAPL | Stock | 8.89 | 8.9593 | 8.8507 | 8.8829 | 6319628.0 |
| 2010-07-02 09:00:00 | AAPL | Stock | 8.8843 | 8.9596 | 8.8836 | 8.9471 | 3512684.0 |
| 2010-07-02 09:30:00 | AAPL | Stock | 8.9464 | 8.9618 | 8.8668 | 8.9029 | 119061544.0 |
| 2010-07-02 10:00:00 | AAPL | Stock | 8.9021 | 8.9082 | 8.8391 | 8.8829 | 53005960.0 |
| 2010-07-02 10:30:00 | AAPL | Stock | 8.8839 | 8.8875 | 8.8121 | 8.8161 | 35363832.0 |
| 2010-07-02 11:00:00 | AAPL | Stock | 8.8152 | 8.8357 | 8.7932 | 8.8075 | 33205060.0 |
| 2010-07-02 11:30:00 | AAPL | Stock | 8.8068 | 8.8161 | 8.7536 | 8.7725 | 44172856.0 |
| 2010-07-02 12:00:00 | AAPL | Stock | 8.7746 | 8.7993 | 8.75 | 8.7718 | 38144092.0 |
| 2010-07-02 12:30:00 | AAPL | Stock | 8.7718 | 8.7768 | 8.7196 | 8.7257 | 38114132.0 |
| 2010-07-02 13:00:00 | AAPL | Stock | 8.7236 | 8.7264 | 8.6857 | 8.704 | 48124860.0 |
| 2010-07-02 13:30:00 | AAPL | Stock | 8.7056 | 8.7714 | 8.7007 | 8.7696 | 36046444.0 |
| 2010-07-02 14:00:00 | AAPL | Stock | 8.7689 | 8.7854 | 8.7442 | 8.7674 | 53684232.0 |
| 2010-07-02 14:30:00 | AAPL | Stock | 8.7679 | 8.7889 | 8.745 | 8.7836 | 25516316.0 |
| 2010-07-02 15:00:00 | AAPL | Stock | 8.7839 | 8.8489 | 8.765 | 8.8304 | 51012892.0 |
| 2010-07-02 15:30:00 | AAPL | Stock | 8.8288 | 8.9071 | 8.8119 | 8.8214 | 87101504.0 |
| 2010-07-02 16:00:00 | AAPL | Stock | 8.8214 | 8.9411 | 8.7941 | 8.8125 | 13477240.0 |
| 2010-07-02 16:30:00 | AAPL | Stock | 8.8125 | 8.8761 | 8.8118 | 8.8125 | 513940.0 |
| 2010-07-02 17:00:00 | AAPL | Stock | 8.8111 | 8.8143 | 8.7946 | 8.8 | 347396.0 |
| 2010-07-02 17:30:00 | AAPL | Stock | 8.7986 | 8.8018 | 8.7914 | 8.7968 | 179312.0 |
| 2010-07-02 18:00:00 | AAPL | Stock | 8.7971 | 8.8193 | 8.7857 | 8.7929 | 223160.0 |
| 2010-07-02 18:30:00 | AAPL | Stock | 8.7996 | 8.8 | 8.7918 | 8.7964 | 122024.0 |
| 2010-07-02 19:00:00 | AAPL | Stock | 8.7996 | 8.805 | 8.7964 | 8.805 | 65968.0 |
| 2010-07-02 19:30:00 | AAPL | Stock | 8.8071 | 8.8071 | 8.7904 | 8.7929 | 112392.0 |
| 2010-07-02 07:00:00 | MSFT | Stock | 23.2 | 23.2 | 23.2 | 23.2 | 286.0 |
| 2010-07-02 07:30:00 | MSFT | Stock | 23.28 | 23.28 | 23.28 | 23.28 | 100.0 |
| 2010-07-02 08:00:00 | MSFT | Stock | 23.16 | 23.28 | 23.15 | 23.28 | 64698.0 |
| 2010-07-02 08:30:00 | MSFT | Stock | 23.27 | 23.54 | 23.17 | 23.24 | 190214.0 |
| 2010-07-02 09:00:00 | MSFT | Stock | 23.24 | 23.39 | 23.21 | 23.35 | 233052.0 |
| 2010-07-02 09:30:00 | MSFT | Stock | 23.35 | 23.37 | 23.06 | 23.15 | 7986213.0 |
| 2010-07-02 10:00:00 | MSFT | Stock | 23.14 | 23.239 | 23.05 | 23.15 | 4666335.0 |
| 2010-07-02 10:30:00 | MSFT | Stock | 23.145 | 23.21 | 23.11 | 23.16 | 2977453.0 |
| 2010-07-02 11:00:00 | MSFT | Stock | 23.16 | 23.25 | 23.145 | 23.231 | 4221065.0 |
| 2010-07-02 11:30:00 | MSFT | Stock | 23.235 | 23.25 | 23.15 | 23.172 | 3938459.0 |
| 2010-07-02 12:00:00 | MSFT | Stock | 23.18 | 23.24 | 23.13 | 23.166 | 2355972.0 |
| 2010-07-02 12:30:00 | MSFT | Stock | 23.16 | 23.19 | 23.13 | 23.15 | 2360072.0 |
| 2010-07-02 13:00:00 | MSFT | Stock | 23.14 | 23.17 | 23.06 | 23.102 | 3786484.0 |
| 2010-07-02 13:30:00 | MSFT | Stock | 23.1 | 23.17 | 23.09 | 23.158 | 2027109.0 |
| 2010-07-02 14:00:00 | MSFT | Stock | 23.155 | 23.19 | 23.111 | 23.126 | 1941825.0 |
| 2010-07-02 14:30:00 | MSFT | Stock | 23.13 | 23.19 | 23.09 | 23.19 | 2451969.0 |
| 2010-07-02 15:00:00 | MSFT | Stock | 23.18 | 23.28 | 23.16 | 23.255 | 4458744.0 |
| 2010-07-02 15:30:00 | MSFT | Stock | 23.25 | 23.48 | 23.23 | 23.27 | 10988068.0 |
| 2010-07-02 16:00:00 | MSFT | Stock | 23.25 | 23.324 | 23.206 | 23.23 | 4116091.0 |
| 2010-07-02 16:30:00 | MSFT | Stock | 23.23 | 23.413 | 23.22 | 23.26 | 34880.0 |
> showing 50 of 71,264 rows — these rows as CSV