PREVIEW / stock_5min / 2011-01-19
file: by_date/stock_5min/2011/2011-01-19.parquet size: 5.1 MB rows: 346,562 symbols: 3,524
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-19 04:00:00 | AAPL | Stock | 12.3314 | 12.3336 | 12.3257 | 12.3257 | 11200.0 |
| 2011-01-19 04:05:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 2800.0 |
| 2011-01-19 04:10:00 | AAPL | Stock | 12.3393 | 12.3429 | 12.3393 | 12.3429 | 11200.0 |
| 2011-01-19 04:15:00 | AAPL | Stock | 12.3396 | 12.3396 | 12.3396 | 12.3396 | 2800.0 |
| 2011-01-19 04:30:00 | AAPL | Stock | 12.3475 | 12.3532 | 12.3475 | 12.3532 | 5600.0 |
| 2011-01-19 04:45:00 | AAPL | Stock | 12.3543 | 12.3571 | 12.3543 | 12.3571 | 33600.0 |
| 2011-01-19 04:50:00 | AAPL | Stock | 12.3468 | 12.3468 | 12.3468 | 12.3468 | 8400.0 |
| 2011-01-19 04:55:00 | AAPL | Stock | 12.3489 | 12.3607 | 12.3489 | 12.3489 | 30800.0 |
| 2011-01-19 05:00:00 | AAPL | Stock | 12.375 | 12.375 | 12.3439 | 12.3439 | 5600.0 |
| 2011-01-19 05:10:00 | AAPL | Stock | 12.375 | 12.375 | 12.375 | 12.375 | 2800.0 |
| 2011-01-19 05:20:00 | AAPL | Stock | 12.3482 | 12.3482 | 12.3482 | 12.3482 | 2800.0 |
| 2011-01-19 05:25:00 | AAPL | Stock | 12.3739 | 12.3739 | 12.3739 | 12.3739 | 14000.0 |
| 2011-01-19 05:30:00 | AAPL | Stock | 12.375 | 12.375 | 12.375 | 12.375 | 5600.0 |
| 2011-01-19 05:35:00 | AAPL | Stock | 12.3857 | 12.4104 | 12.3857 | 12.4104 | 46676.0 |
| 2011-01-19 05:40:00 | AAPL | Stock | 12.3929 | 12.3936 | 12.3929 | 12.3936 | 5600.0 |
| 2011-01-19 05:45:00 | AAPL | Stock | 12.3936 | 12.3936 | 12.3846 | 12.3846 | 5600.0 |
| 2011-01-19 05:50:00 | AAPL | Stock | 12.3839 | 12.3839 | 12.3729 | 12.375 | 39200.0 |
| 2011-01-19 05:55:00 | AAPL | Stock | 12.3793 | 12.3793 | 12.3686 | 12.3686 | 22400.0 |
| 2011-01-19 06:05:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3571 | 12.3571 | 98280.0 |
| 2011-01-19 06:10:00 | AAPL | Stock | 12.3536 | 12.3536 | 12.3393 | 12.3393 | 77000.0 |
| 2011-01-19 06:15:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3464 | 12.3464 | 39200.0 |
| 2011-01-19 06:20:00 | AAPL | Stock | 12.3518 | 12.3518 | 12.3204 | 12.3264 | 19600.0 |
| 2011-01-19 06:25:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 2800.0 |
| 2011-01-19 06:30:00 | AAPL | Stock | 12.3204 | 12.3204 | 12.3125 | 12.3143 | 36400.0 |
| 2011-01-19 06:35:00 | AAPL | Stock | 12.3 | 12.3036 | 12.3 | 12.3036 | 8400.0 |
| 2011-01-19 06:40:00 | AAPL | Stock | 12.3025 | 12.3036 | 12.275 | 12.2857 | 76020.0 |
| 2011-01-19 06:45:00 | AAPL | Stock | 12.275 | 12.3036 | 12.2471 | 12.3036 | 173600.0 |
| 2011-01-19 06:50:00 | AAPL | Stock | 12.3004 | 12.3004 | 12.2804 | 12.2857 | 25200.0 |
| 2011-01-19 06:55:00 | AAPL | Stock | 12.2857 | 12.305 | 12.2786 | 12.2964 | 123760.0 |
| 2011-01-19 07:00:00 | AAPL | Stock | 12.3064 | 12.3518 | 12.3064 | 12.3382 | 404208.0 |
| 2011-01-19 07:05:00 | AAPL | Stock | 12.3357 | 12.3518 | 12.325 | 12.3482 | 216300.0 |
| 2011-01-19 07:10:00 | AAPL | Stock | 12.3482 | 12.3886 | 12.3482 | 12.3886 | 328244.0 |
| 2011-01-19 07:15:00 | AAPL | Stock | 12.3893 | 12.4036 | 12.3686 | 12.3739 | 699608.0 |
| 2011-01-19 07:20:00 | AAPL | Stock | 12.3679 | 12.3721 | 12.3571 | 12.3643 | 155568.0 |
| 2011-01-19 07:25:00 | AAPL | Stock | 12.3643 | 12.3729 | 12.3589 | 12.3714 | 489748.0 |
| 2011-01-19 07:30:00 | AAPL | Stock | 12.3711 | 12.3925 | 12.3693 | 12.3839 | 835716.0 |
| 2011-01-19 07:35:00 | AAPL | Stock | 12.3875 | 12.4107 | 12.3839 | 12.4004 | 942928.0 |
| 2011-01-19 07:40:00 | AAPL | Stock | 12.4004 | 12.4071 | 12.3946 | 12.3964 | 176708.0 |
| 2011-01-19 07:45:00 | AAPL | Stock | 12.3986 | 12.4079 | 12.3929 | 12.4036 | 598668.0 |
| 2011-01-19 07:50:00 | AAPL | Stock | 12.4043 | 12.4104 | 12.3868 | 12.3868 | 472584.0 |
| 2011-01-19 07:55:00 | AAPL | Stock | 12.3879 | 12.3975 | 12.3796 | 12.3904 | 221900.0 |
| 2011-01-19 08:00:00 | AAPL | Stock | 12.3921 | 12.4018 | 12.3205 | 12.3786 | 1873620.0 |
| 2011-01-19 08:05:00 | AAPL | Stock | 12.3786 | 12.3911 | 12.3546 | 12.3857 | 1166256.0 |
| 2011-01-19 08:10:00 | AAPL | Stock | 12.3821 | 12.3839 | 12.3661 | 12.3818 | 509852.0 |
| 2011-01-19 08:15:00 | AAPL | Stock | 12.3764 | 12.4011 | 12.375 | 12.4011 | 1126888.0 |
| 2011-01-19 08:20:00 | AAPL | Stock | 12.4018 | 12.4107 | 12.3839 | 12.3946 | 2045484.0 |
| 2011-01-19 08:25:00 | AAPL | Stock | 12.3946 | 12.4104 | 12.3879 | 12.4036 | 955892.0 |
| 2011-01-19 08:30:00 | AAPL | Stock | 12.4036 | 12.4443 | 12.4021 | 12.4443 | 3979640.0 |
| 2011-01-19 08:35:00 | AAPL | Stock | 12.4439 | 12.4789 | 12.4429 | 12.4671 | 4172140.0 |
| 2011-01-19 08:40:00 | AAPL | Stock | 12.4704 | 12.5 | 12.4664 | 12.4961 | 5007016.0 |
> showing 50 of 346,562 rows — these rows as CSV