PREVIEW / stock_5min / 2012-02-03
file: by_date/stock_5min/2012/2012-02-03.parquet size: 5.2 MB rows: 347,107 symbols: 3,543
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-03 04:30:00 | AAPL | Stock | 16.2661 | 16.2661 | 16.2661 | 16.2661 | 2800.0 |
| 2012-02-03 06:00:00 | AAPL | Stock | 16.2714 | 16.2714 | 16.2714 | 16.2714 | 7140.0 |
| 2012-02-03 06:40:00 | AAPL | Stock | 16.2714 | 16.2714 | 16.2714 | 16.2714 | 11200.0 |
| 2012-02-03 06:55:00 | AAPL | Stock | 16.2714 | 16.2714 | 16.2714 | 16.2714 | 2800.0 |
| 2012-02-03 07:00:00 | AAPL | Stock | 16.275 | 16.275 | 16.2714 | 16.2714 | 28700.0 |
| 2012-02-03 07:10:00 | AAPL | Stock | 16.2736 | 16.2736 | 16.2714 | 16.2714 | 15260.0 |
| 2012-02-03 07:25:00 | AAPL | Stock | 16.2714 | 16.2714 | 16.2714 | 16.2714 | 2800.0 |
| 2012-02-03 07:30:00 | AAPL | Stock | 16.2607 | 16.2607 | 16.2607 | 16.2607 | 2800.0 |
| 2012-02-03 07:40:00 | AAPL | Stock | 16.2696 | 16.2696 | 16.2696 | 16.2696 | 13496.0 |
| 2012-02-03 07:45:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2679 | 16.2679 | 2800.0 |
| 2012-02-03 07:50:00 | AAPL | Stock | 16.2607 | 16.2679 | 16.2589 | 16.2589 | 58800.0 |
| 2012-02-03 08:00:00 | AAPL | Stock | 16.2639 | 16.2639 | 16.25 | 16.25 | 118132.0 |
| 2012-02-03 08:05:00 | AAPL | Stock | 16.2429 | 16.25 | 16.2414 | 16.2414 | 39340.0 |
| 2012-02-03 08:10:00 | AAPL | Stock | 16.2393 | 16.2393 | 16.2136 | 16.2371 | 236348.0 |
| 2012-02-03 08:15:00 | AAPL | Stock | 16.2371 | 16.2421 | 16.2371 | 16.2421 | 28700.0 |
| 2012-02-03 08:20:00 | AAPL | Stock | 16.2339 | 16.2361 | 16.2339 | 16.2361 | 14756.0 |
| 2012-02-03 08:25:00 | AAPL | Stock | 16.2339 | 16.2507 | 16.2339 | 16.2489 | 60452.0 |
| 2012-02-03 08:30:00 | AAPL | Stock | 16.25 | 16.3279 | 16.2364 | 16.325 | 1901676.0 |
| 2012-02-03 08:35:00 | AAPL | Stock | 16.325 | 16.3571 | 16.2543 | 16.3393 | 1225672.0 |
| 2012-02-03 08:40:00 | AAPL | Stock | 16.3418 | 16.3464 | 16.325 | 16.3464 | 462728.0 |
| 2012-02-03 08:45:00 | AAPL | Stock | 16.3418 | 16.3475 | 16.3261 | 16.3264 | 370944.0 |
| 2012-02-03 08:50:00 | AAPL | Stock | 16.3268 | 16.3364 | 16.325 | 16.325 | 438256.0 |
| 2012-02-03 08:55:00 | AAPL | Stock | 16.325 | 16.3382 | 16.3179 | 16.3311 | 205520.0 |
| 2012-02-03 09:00:00 | AAPL | Stock | 16.3375 | 16.3375 | 16.3321 | 16.3357 | 156800.0 |
| 2012-02-03 09:05:00 | AAPL | Stock | 16.3339 | 16.3393 | 16.3268 | 16.3268 | 125860.0 |
| 2012-02-03 09:10:00 | AAPL | Stock | 16.3257 | 16.3321 | 16.3196 | 16.3321 | 212324.0 |
| 2012-02-03 09:15:00 | AAPL | Stock | 16.335 | 16.3357 | 16.3321 | 16.3339 | 31612.0 |
| 2012-02-03 09:20:00 | AAPL | Stock | 16.3321 | 16.3321 | 16.3243 | 16.3286 | 255696.0 |
| 2012-02-03 09:25:00 | AAPL | Stock | 16.3321 | 16.3364 | 16.3218 | 16.3321 | 295176.0 |
| 2012-02-03 09:30:00 | AAPL | Stock | 16.3289 | 16.3375 | 16.2786 | 16.281 | 12194700.0 |
| 2012-02-03 09:35:00 | AAPL | Stock | 16.2821 | 16.3032 | 16.27 | 16.29 | 5049352.0 |
| 2012-02-03 09:40:00 | AAPL | Stock | 16.2929 | 16.3 | 16.2757 | 16.2889 | 5760916.0 |
| 2012-02-03 09:45:00 | AAPL | Stock | 16.2911 | 16.3 | 16.2871 | 16.3 | 5341952.0 |
| 2012-02-03 09:50:00 | AAPL | Stock | 16.3 | 16.3171 | 16.2993 | 16.3164 | 4741296.0 |
| 2012-02-03 09:55:00 | AAPL | Stock | 16.3171 | 16.3225 | 16.3089 | 16.3179 | 4758740.0 |
| 2012-02-03 10:00:00 | AAPL | Stock | 16.3143 | 16.3314 | 16.3107 | 16.3296 | 5692036.0 |
| 2012-02-03 10:05:00 | AAPL | Stock | 16.328 | 16.3557 | 16.3204 | 16.3557 | 6777960.0 |
| 2012-02-03 10:10:00 | AAPL | Stock | 16.3557 | 16.3871 | 16.3504 | 16.3836 | 9808176.0 |
| 2012-02-03 10:15:00 | AAPL | Stock | 16.3839 | 16.3857 | 16.3679 | 16.3757 | 5317144.0 |
| 2012-02-03 10:20:00 | AAPL | Stock | 16.3771 | 16.3893 | 16.3754 | 16.3789 | 4482492.0 |
| 2012-02-03 10:25:00 | AAPL | Stock | 16.3757 | 16.3757 | 16.3571 | 16.3589 | 5833632.0 |
| 2012-02-03 10:30:00 | AAPL | Stock | 16.3593 | 16.3697 | 16.3568 | 16.3579 | 4031944.0 |
| 2012-02-03 10:35:00 | AAPL | Stock | 16.3604 | 16.3704 | 16.3507 | 16.3554 | 4932452.0 |
| 2012-02-03 10:40:00 | AAPL | Stock | 16.3564 | 16.3739 | 16.3482 | 16.3679 | 4231584.0 |
| 2012-02-03 10:45:00 | AAPL | Stock | 16.3689 | 16.3714 | 16.3571 | 16.37 | 2908696.0 |
| 2012-02-03 10:50:00 | AAPL | Stock | 16.3711 | 16.3768 | 16.3689 | 16.375 | 3486224.0 |
| 2012-02-03 10:55:00 | AAPL | Stock | 16.3754 | 16.3796 | 16.375 | 16.3789 | 3357032.0 |
| 2012-02-03 11:00:00 | AAPL | Stock | 16.3779 | 16.3857 | 16.375 | 16.3821 | 4186224.0 |
| 2012-02-03 11:05:00 | AAPL | Stock | 16.3825 | 16.3825 | 16.3579 | 16.3645 | 3533936.0 |
| 2012-02-03 11:10:00 | AAPL | Stock | 16.3657 | 16.3679 | 16.3604 | 16.3671 | 1814764.0 |
> showing 50 of 347,107 rows — these rows as CSV