PREVIEW / stock_5min / 2008-01-15
file: by_date/stock_5min/2008/2008-01-15.parquet size: 4.4 MB rows: 321,393 symbols: 3,244
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-15 04:35:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 2800.0 |
| 2008-01-15 04:45:00 | AAPL | Stock | 6.4143 | 6.4143 | 6.4143 | 6.4143 | 2800.0 |
| 2008-01-15 04:55:00 | AAPL | Stock | 6.4143 | 6.4143 | 6.4143 | 6.4143 | 5600.0 |
| 2008-01-15 05:00:00 | AAPL | Stock | 6.3929 | 6.3929 | 6.3929 | 6.3929 | 8400.0 |
| 2008-01-15 05:05:00 | AAPL | Stock | 6.405 | 6.405 | 6.3864 | 6.3864 | 47040.0 |
| 2008-01-15 05:10:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 2800.0 |
| 2008-01-15 05:15:00 | AAPL | Stock | 6.3854 | 6.3857 | 6.3854 | 6.3857 | 6440.0 |
| 2008-01-15 05:20:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 2800.0 |
| 2008-01-15 05:25:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 20160.0 |
| 2008-01-15 05:45:00 | AAPL | Stock | 6.3739 | 6.375 | 6.3739 | 6.375 | 51940.0 |
| 2008-01-15 06:15:00 | AAPL | Stock | 6.3779 | 6.3779 | 6.3779 | 6.3779 | 28000.0 |
| 2008-01-15 06:20:00 | AAPL | Stock | 6.3779 | 6.3779 | 6.3779 | 6.3779 | 28000.0 |
| 2008-01-15 06:25:00 | AAPL | Stock | 6.3807 | 6.3843 | 6.3807 | 6.3818 | 22400.0 |
| 2008-01-15 06:30:00 | AAPL | Stock | 6.3818 | 6.3893 | 6.3818 | 6.3893 | 40600.0 |
| 2008-01-15 06:35:00 | AAPL | Stock | 6.3925 | 6.3925 | 6.3925 | 6.3925 | 5600.0 |
| 2008-01-15 06:40:00 | AAPL | Stock | 6.3925 | 6.3925 | 6.3925 | 6.3925 | 5600.0 |
| 2008-01-15 06:45:00 | AAPL | Stock | 6.3925 | 6.3925 | 6.3857 | 6.3857 | 28000.0 |
| 2008-01-15 06:50:00 | AAPL | Stock | 6.4143 | 6.4143 | 6.4143 | 6.4143 | 7280.0 |
| 2008-01-15 07:00:00 | AAPL | Stock | 6.3982 | 6.4107 | 6.3789 | 6.3861 | 109200.0 |
| 2008-01-15 07:05:00 | AAPL | Stock | 6.3929 | 6.3929 | 6.3929 | 6.3929 | 5600.0 |
| 2008-01-15 07:10:00 | AAPL | Stock | 6.3929 | 6.3929 | 6.3929 | 6.3929 | 28000.0 |
| 2008-01-15 07:15:00 | AAPL | Stock | 6.3818 | 6.3818 | 6.3818 | 6.3818 | 5600.0 |
| 2008-01-15 07:20:00 | AAPL | Stock | 6.3818 | 6.3925 | 6.3818 | 6.3925 | 47600.0 |
| 2008-01-15 07:25:00 | AAPL | Stock | 6.3925 | 6.3925 | 6.375 | 6.375 | 73248.0 |
| 2008-01-15 07:30:00 | AAPL | Stock | 6.3714 | 6.3775 | 6.3714 | 6.3775 | 39200.0 |
| 2008-01-15 07:35:00 | AAPL | Stock | 6.3786 | 6.3814 | 6.3396 | 6.3632 | 230132.0 |
| 2008-01-15 07:40:00 | AAPL | Stock | 6.3643 | 6.3643 | 6.3579 | 6.3607 | 75600.0 |
| 2008-01-15 07:45:00 | AAPL | Stock | 6.3632 | 6.3632 | 6.3554 | 6.3554 | 31500.0 |
| 2008-01-15 07:50:00 | AAPL | Stock | 6.3486 | 6.3486 | 6.3411 | 6.3482 | 49140.0 |
| 2008-01-15 07:55:00 | AAPL | Stock | 6.3482 | 6.3632 | 6.3482 | 6.3632 | 23100.0 |
| 2008-01-15 08:00:00 | AAPL | Stock | 6.3568 | 6.3646 | 6.3482 | 6.3643 | 882728.0 |
| 2008-01-15 08:05:00 | AAPL | Stock | 6.3571 | 6.3582 | 6.3525 | 6.3536 | 293048.0 |
| 2008-01-15 08:10:00 | AAPL | Stock | 6.3554 | 6.3625 | 6.35 | 6.3625 | 282156.0 |
| 2008-01-15 08:15:00 | AAPL | Stock | 6.3643 | 6.3786 | 6.3621 | 6.3643 | 595896.0 |
| 2008-01-15 08:20:00 | AAPL | Stock | 6.3589 | 6.3711 | 6.3575 | 6.37 | 342188.0 |
| 2008-01-15 08:25:00 | AAPL | Stock | 6.3682 | 6.3696 | 6.3571 | 6.3646 | 370272.0 |
| 2008-01-15 08:30:00 | AAPL | Stock | 6.3646 | 6.375 | 6.3475 | 6.3593 | 2428132.0 |
| 2008-01-15 08:35:00 | AAPL | Stock | 6.3596 | 6.3714 | 6.3586 | 6.3714 | 668360.0 |
| 2008-01-15 08:40:00 | AAPL | Stock | 6.3711 | 6.3893 | 6.3711 | 6.3761 | 1676108.0 |
| 2008-01-15 08:45:00 | AAPL | Stock | 6.3789 | 6.3821 | 6.3707 | 6.3771 | 596316.0 |
| 2008-01-15 08:50:00 | AAPL | Stock | 6.3793 | 6.3796 | 6.3664 | 6.3668 | 380100.0 |
| 2008-01-15 08:55:00 | AAPL | Stock | 6.3664 | 6.3696 | 6.3593 | 6.3614 | 830452.0 |
| 2008-01-15 09:00:00 | AAPL | Stock | 6.3611 | 6.3639 | 6.3393 | 6.3446 | 1477924.0 |
| 2008-01-15 09:05:00 | AAPL | Stock | 6.3457 | 6.3461 | 6.3307 | 6.3379 | 722624.0 |
| 2008-01-15 09:10:00 | AAPL | Stock | 6.3396 | 6.3414 | 6.3296 | 6.3304 | 607964.0 |
| 2008-01-15 09:15:00 | AAPL | Stock | 6.3304 | 6.3393 | 6.3286 | 6.3343 | 496020.0 |
| 2008-01-15 09:20:00 | AAPL | Stock | 6.3357 | 6.3461 | 6.335 | 6.3436 | 383292.0 |
| 2008-01-15 09:25:00 | AAPL | Stock | 6.345 | 6.385 | 6.3279 | 6.3432 | 938812.0 |
| 2008-01-15 09:30:00 | AAPL | Stock | 6.3446 | 6.3546 | 6.3132 | 6.3368 | 33625452.0 |
| 2008-01-15 09:35:00 | AAPL | Stock | 6.3368 | 6.3396 | 6.2893 | 6.3161 | 28951580.0 |
> showing 50 of 321,393 rows — these rows as CSV