PREVIEW / stock_30min / 2010-12-02
file: by_date/stock_30min/2010/2010-12-02.parquet size: 1.4 MB rows: 75,620 symbols: 3,531
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-12-02 04:00:00 | AAPL | Stock | 11.3539 | 11.3539 | 11.3539 | 11.3539 | 2800.0 |
| 2010-12-02 04:30:00 | AAPL | Stock | 11.3536 | 11.3571 | 11.3464 | 11.3464 | 67200.0 |
| 2010-12-02 05:00:00 | AAPL | Stock | 11.3571 | 11.3571 | 11.3143 | 11.3143 | 28700.0 |
| 2010-12-02 05:30:00 | AAPL | Stock | 11.3143 | 11.3143 | 11.3143 | 11.3143 | 7700.0 |
| 2010-12-02 06:00:00 | AAPL | Stock | 11.3261 | 11.3286 | 11.3214 | 11.3286 | 11648.0 |
| 2010-12-02 06:30:00 | AAPL | Stock | 11.3243 | 11.3286 | 11.3243 | 11.3286 | 36400.0 |
| 2010-12-02 07:00:00 | AAPL | Stock | 11.3218 | 11.3429 | 11.3218 | 11.3429 | 179788.0 |
| 2010-12-02 07:30:00 | AAPL | Stock | 11.3432 | 11.3736 | 11.3432 | 11.3736 | 376180.0 |
| 2010-12-02 08:00:00 | AAPL | Stock | 11.3629 | 11.375 | 11.3429 | 11.3718 | 2226868.0 |
| 2010-12-02 08:30:00 | AAPL | Stock | 11.3693 | 11.375 | 11.3461 | 11.3479 | 4274284.0 |
| 2010-12-02 09:00:00 | AAPL | Stock | 11.3446 | 11.3807 | 11.3257 | 11.3429 | 3410680.0 |
| 2010-12-02 09:30:00 | AAPL | Stock | 11.3436 | 11.3929 | 11.3179 | 11.3525 | 76574764.0 |
| 2010-12-02 10:00:00 | AAPL | Stock | 11.3532 | 11.3786 | 11.3171 | 11.3354 | 48109432.0 |
| 2010-12-02 10:30:00 | AAPL | Stock | 11.3346 | 11.3414 | 11.2461 | 11.2939 | 58864932.0 |
| 2010-12-02 11:00:00 | AAPL | Stock | 11.2925 | 11.3332 | 11.2825 | 11.3182 | 31477768.0 |
| 2010-12-02 11:30:00 | AAPL | Stock | 11.3157 | 11.3375 | 11.3029 | 11.3336 | 17364844.0 |
| 2010-12-02 12:00:00 | AAPL | Stock | 11.3321 | 11.3364 | 11.3057 | 11.3057 | 10469116.0 |
| 2010-12-02 12:30:00 | AAPL | Stock | 11.3057 | 11.3414 | 11.3004 | 11.3354 | 16847208.0 |
| 2010-12-02 13:00:00 | AAPL | Stock | 11.3364 | 11.3604 | 11.3354 | 11.3582 | 22363432.0 |
| 2010-12-02 13:30:00 | AAPL | Stock | 11.3582 | 11.3732 | 11.3511 | 11.3671 | 17157980.0 |
| 2010-12-02 14:00:00 | AAPL | Stock | 11.3686 | 11.3886 | 11.3638 | 11.3729 | 22123864.0 |
| 2010-12-02 14:30:00 | AAPL | Stock | 11.3729 | 11.3839 | 11.3504 | 11.3511 | 25096316.0 |
| 2010-12-02 15:00:00 | AAPL | Stock | 11.3511 | 11.3857 | 11.3507 | 11.3786 | 30822344.0 |
| 2010-12-02 15:30:00 | AAPL | Stock | 11.3793 | 11.3896 | 11.3518 | 11.3618 | 51271948.0 |
| 2010-12-02 16:00:00 | AAPL | Stock | 11.3625 | 11.3729 | 11.3454 | 11.3636 | 18993884.0 |
| 2010-12-02 16:30:00 | AAPL | Stock | 11.3636 | 11.3679 | 11.3561 | 11.3561 | 450352.0 |
| 2010-12-02 17:00:00 | AAPL | Stock | 11.3536 | 11.3625 | 11.3493 | 11.36 | 309344.0 |
| 2010-12-02 17:30:00 | AAPL | Stock | 11.3575 | 11.3625 | 11.3575 | 11.3582 | 103040.0 |
| 2010-12-02 18:00:00 | AAPL | Stock | 11.3571 | 11.3625 | 11.3571 | 11.3571 | 28840.0 |
| 2010-12-02 18:30:00 | AAPL | Stock | 11.3554 | 11.36 | 11.3536 | 11.36 | 53480.0 |
| 2010-12-02 19:00:00 | AAPL | Stock | 11.3564 | 11.3607 | 11.3536 | 11.3536 | 171584.0 |
| 2010-12-02 19:30:00 | AAPL | Stock | 11.3521 | 11.3714 | 11.3486 | 11.3686 | 491176.0 |
| 2010-12-02 04:00:00 | MSFT | Stock | 26.0 | 26.0 | 26.0 | 26.0 | 100.0 |
| 2010-12-02 04:30:00 | MSFT | Stock | 26.11 | 26.11 | 26.11 | 26.11 | 100.0 |
| 2010-12-02 05:30:00 | MSFT | Stock | 26.1 | 26.17 | 26.1 | 26.17 | 200.0 |
| 2010-12-02 07:00:00 | MSFT | Stock | 26.05 | 26.09 | 26.02 | 26.02 | 4700.0 |
| 2010-12-02 07:30:00 | MSFT | Stock | 26.19 | 26.19 | 26.07 | 26.09 | 6200.0 |
| 2010-12-02 08:00:00 | MSFT | Stock | 26.11 | 26.18 | 26.1 | 26.17 | 23604.0 |
| 2010-12-02 08:30:00 | MSFT | Stock | 26.15 | 26.19 | 26.1 | 26.1 | 55263.0 |
| 2010-12-02 09:00:00 | MSFT | Stock | 26.09 | 26.25 | 26.05 | 26.24 | 67518.0 |
| 2010-12-02 09:30:00 | MSFT | Stock | 26.23 | 26.66 | 26.2 | 26.66 | 12735825.0 |
| 2010-12-02 10:00:00 | MSFT | Stock | 26.66 | 26.92 | 26.645 | 26.755 | 17294572.0 |
| 2010-12-02 10:30:00 | MSFT | Stock | 26.75 | 26.76 | 26.55 | 26.63 | 10502602.0 |
| 2010-12-02 11:00:00 | MSFT | Stock | 26.62 | 26.8 | 26.6 | 26.79 | 5830074.0 |
| 2010-12-02 11:30:00 | MSFT | Stock | 26.791 | 26.98 | 26.75 | 26.88 | 5482084.0 |
| 2010-12-02 12:00:00 | MSFT | Stock | 26.88 | 26.885 | 26.82 | 26.82 | 3125310.0 |
| 2010-12-02 12:30:00 | MSFT | Stock | 26.825 | 26.91 | 26.78 | 26.78 | 3450664.0 |
| 2010-12-02 13:00:00 | MSFT | Stock | 26.785 | 26.79 | 26.7 | 26.73 | 1749806.0 |
| 2010-12-02 13:30:00 | MSFT | Stock | 26.738 | 26.79 | 26.7 | 26.76 | 2968302.0 |
| 2010-12-02 14:00:00 | MSFT | Stock | 26.75 | 26.83 | 26.72 | 26.8 | 2192295.0 |
> showing 50 of 75,620 rows — these rows as CSV