PREVIEW / stock_30min / 2010-08-02
file: by_date/stock_30min/2010/2010-08-02.parquet size: 1.4 MB rows: 74,808 symbols: 3,500
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-08-02 04:00:00 | AAPL | Stock | 9.2339 | 9.2643 | 9.2339 | 9.2643 | 11200.0 |
| 2010-08-02 06:00:00 | AAPL | Stock | 9.2764 | 9.2764 | 9.2764 | 9.2764 | 2884.0 |
| 2010-08-02 06:30:00 | AAPL | Stock | 9.2611 | 9.2611 | 9.2611 | 9.2611 | 2800.0 |
| 2010-08-02 07:00:00 | AAPL | Stock | 9.2607 | 9.2607 | 9.2393 | 9.2464 | 148232.0 |
| 2010-08-02 07:30:00 | AAPL | Stock | 9.2496 | 9.2536 | 9.2418 | 9.2525 | 164696.0 |
| 2010-08-02 08:00:00 | AAPL | Stock | 9.2521 | 9.2729 | 9.2464 | 9.2679 | 1329580.0 |
| 2010-08-02 08:30:00 | AAPL | Stock | 9.2679 | 9.2714 | 9.1875 | 9.2668 | 759836.0 |
| 2010-08-02 09:00:00 | AAPL | Stock | 9.2711 | 9.3 | 9.2686 | 9.2971 | 2804564.0 |
| 2010-08-02 09:30:00 | AAPL | Stock | 9.2993 | 9.3339 | 9.2721 | 9.2854 | 59642884.0 |
| 2010-08-02 10:00:00 | AAPL | Stock | 9.2854 | 9.3736 | 9.2839 | 9.3593 | 70569380.0 |
| 2010-08-02 10:30:00 | AAPL | Stock | 9.3614 | 9.3782 | 9.3429 | 9.3703 | 44412536.0 |
| 2010-08-02 11:00:00 | AAPL | Stock | 9.3721 | 9.3779 | 9.3486 | 9.3646 | 22608208.0 |
| 2010-08-02 11:30:00 | AAPL | Stock | 9.365 | 9.3739 | 9.3554 | 9.3679 | 19320672.0 |
| 2010-08-02 12:00:00 | AAPL | Stock | 9.3679 | 9.3732 | 9.35 | 9.3518 | 15597316.0 |
| 2010-08-02 12:30:00 | AAPL | Stock | 9.3521 | 9.37 | 9.35 | 9.3657 | 12729836.0 |
| 2010-08-02 13:00:00 | AAPL | Stock | 9.3646 | 9.3661 | 9.35 | 9.3507 | 12766936.0 |
| 2010-08-02 13:30:00 | AAPL | Stock | 9.3507 | 9.351 | 9.3161 | 9.3389 | 29317064.0 |
| 2010-08-02 14:00:00 | AAPL | Stock | 9.34 | 9.3621 | 9.3389 | 9.3561 | 20475112.0 |
| 2010-08-02 14:30:00 | AAPL | Stock | 9.3561 | 9.3686 | 9.3511 | 9.3589 | 27627768.0 |
| 2010-08-02 15:00:00 | AAPL | Stock | 9.3593 | 9.3685 | 9.3493 | 9.3593 | 22180648.0 |
| 2010-08-02 15:30:00 | AAPL | Stock | 9.36 | 9.3661 | 9.34 | 9.3489 | 48319852.0 |
| 2010-08-02 16:00:00 | AAPL | Stock | 9.3518 | 9.36 | 9.3099 | 9.3099 | 11995256.0 |
| 2010-08-02 16:30:00 | AAPL | Stock | 9.3482 | 9.3657 | 9.3468 | 9.3475 | 255640.0 |
| 2010-08-02 17:00:00 | AAPL | Stock | 9.1875 | 9.3511 | 9.1875 | 9.3489 | 135016.0 |
| 2010-08-02 17:30:00 | AAPL | Stock | 9.3493 | 9.3514 | 9.3411 | 9.3432 | 199052.0 |
| 2010-08-02 18:00:00 | AAPL | Stock | 9.3432 | 9.3518 | 9.3432 | 9.3475 | 155008.0 |
| 2010-08-02 18:30:00 | AAPL | Stock | 9.3482 | 9.3529 | 9.3482 | 9.3525 | 83412.0 |
| 2010-08-02 19:00:00 | AAPL | Stock | 9.3518 | 9.3518 | 9.3496 | 9.3518 | 130032.0 |
| 2010-08-02 19:30:00 | AAPL | Stock | 9.35 | 9.3532 | 9.35 | 9.3532 | 146216.0 |
| 2010-08-02 06:00:00 | MSFT | Stock | 26.02 | 26.02 | 26.02 | 26.02 | 1000.0 |
| 2010-08-02 07:00:00 | MSFT | Stock | 25.98 | 26.07 | 25.98 | 26.02 | 11700.0 |
| 2010-08-02 07:30:00 | MSFT | Stock | 26.0 | 26.01 | 25.96 | 25.96 | 5290.0 |
| 2010-08-02 08:00:00 | MSFT | Stock | 25.96 | 26.0 | 25.93 | 25.94 | 29077.0 |
| 2010-08-02 08:30:00 | MSFT | Stock | 25.93 | 25.97 | 25.92 | 25.96 | 14700.0 |
| 2010-08-02 09:00:00 | MSFT | Stock | 25.95 | 26.05 | 25.91 | 25.96 | 95842.0 |
| 2010-08-02 09:30:00 | MSFT | Stock | 25.98 | 26.01 | 25.75 | 25.97 | 8185611.0 |
| 2010-08-02 10:00:00 | MSFT | Stock | 25.97 | 26.27 | 25.96 | 26.23 | 4795873.0 |
| 2010-08-02 10:30:00 | MSFT | Stock | 26.235 | 26.28 | 26.16 | 26.242 | 3318133.0 |
| 2010-08-02 11:00:00 | MSFT | Stock | 26.245 | 26.295 | 26.2 | 26.2 | 3291475.0 |
| 2010-08-02 11:30:00 | MSFT | Stock | 26.21 | 26.28 | 26.16 | 26.201 | 3415963.0 |
| 2010-08-02 12:00:00 | MSFT | Stock | 26.205 | 26.22 | 26.18 | 26.19 | 1668686.0 |
| 2010-08-02 12:30:00 | MSFT | Stock | 26.19 | 26.22 | 26.17 | 26.2 | 1811190.0 |
| 2010-08-02 13:00:00 | MSFT | Stock | 26.208 | 26.22 | 26.16 | 26.192 | 1877753.0 |
| 2010-08-02 13:30:00 | MSFT | Stock | 26.19 | 26.24 | 26.14 | 26.19 | 2842771.0 |
| 2010-08-02 14:00:00 | MSFT | Stock | 26.19 | 26.26 | 26.17 | 26.26 | 2136622.0 |
| 2010-08-02 14:30:00 | MSFT | Stock | 26.26 | 26.38 | 26.25 | 26.33 | 2847673.0 |
| 2010-08-02 15:00:00 | MSFT | Stock | 26.34 | 26.349 | 26.27 | 26.32 | 2525348.0 |
| 2010-08-02 15:30:00 | MSFT | Stock | 26.32 | 26.35 | 26.25 | 26.32 | 7445848.0 |
| 2010-08-02 16:00:00 | MSFT | Stock | 26.32 | 26.332 | 25.81 | 26.27 | 7816603.0 |
| 2010-08-02 16:30:00 | MSFT | Stock | 26.27 | 26.32 | 26.26 | 26.26 | 22540.0 |
> showing 50 of 74,808 rows — these rows as CSV