PREVIEW / stock_5min / 2008-11-14
file: by_date/stock_5min/2008/2008-11-14.parquet size: 4.3 MB rows: 305,513 symbols: 3,296
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-11-14 07:00:00 | AAPL | Stock | 3.4071 | 3.4071 | 3.4071 | 3.4071 | 2800.0 |
| 2008-11-14 07:30:00 | AAPL | Stock | 3.3789 | 3.3789 | 3.3789 | 3.3789 | 2800.0 |
| 2008-11-14 08:00:00 | AAPL | Stock | 3.3954 | 3.4039 | 3.3761 | 3.3761 | 353360.0 |
| 2008-11-14 08:05:00 | AAPL | Stock | 3.3761 | 3.3786 | 3.3461 | 3.3579 | 779576.0 |
| 2008-11-14 08:10:00 | AAPL | Stock | 3.3593 | 3.375 | 3.3582 | 3.375 | 441280.0 |
| 2008-11-14 08:15:00 | AAPL | Stock | 3.3829 | 3.3829 | 3.3536 | 3.3732 | 366520.0 |
| 2008-11-14 08:20:00 | AAPL | Stock | 3.3643 | 3.3732 | 3.3457 | 3.3607 | 521528.0 |
| 2008-11-14 08:25:00 | AAPL | Stock | 3.3593 | 3.3625 | 3.3393 | 3.3554 | 419216.0 |
| 2008-11-14 08:30:00 | AAPL | Stock | 3.3536 | 3.3721 | 3.3532 | 3.3643 | 421848.0 |
| 2008-11-14 08:35:00 | AAPL | Stock | 3.3643 | 3.3671 | 3.3582 | 3.3582 | 85568.0 |
| 2008-11-14 08:40:00 | AAPL | Stock | 3.3589 | 3.3604 | 3.3546 | 3.3546 | 160552.0 |
| 2008-11-14 08:45:00 | AAPL | Stock | 3.3582 | 3.3614 | 3.3571 | 3.3614 | 219520.0 |
| 2008-11-14 08:50:00 | AAPL | Stock | 3.3621 | 3.37 | 3.3621 | 3.3657 | 140980.0 |
| 2008-11-14 08:55:00 | AAPL | Stock | 3.3657 | 3.3732 | 3.3614 | 3.3718 | 424648.0 |
| 2008-11-14 09:00:00 | AAPL | Stock | 3.3707 | 3.3825 | 3.3682 | 3.3725 | 317828.0 |
| 2008-11-14 09:05:00 | AAPL | Stock | 3.3686 | 3.3686 | 3.3546 | 3.3554 | 458780.0 |
| 2008-11-14 09:10:00 | AAPL | Stock | 3.3557 | 3.3657 | 3.3536 | 3.3586 | 784084.0 |
| 2008-11-14 09:15:00 | AAPL | Stock | 3.3568 | 3.3579 | 3.3532 | 3.3579 | 218092.0 |
| 2008-11-14 09:20:00 | AAPL | Stock | 3.3607 | 3.3621 | 3.3571 | 3.3596 | 273560.0 |
| 2008-11-14 09:25:00 | AAPL | Stock | 3.3589 | 3.3661 | 3.3393 | 3.3486 | 1225560.0 |
| 2008-11-14 09:30:00 | AAPL | Stock | 3.3479 | 3.355 | 3.3071 | 3.31 | 44457056.0 |
| 2008-11-14 09:35:00 | AAPL | Stock | 3.3114 | 3.3168 | 3.2725 | 3.2921 | 42996660.0 |
| 2008-11-14 09:40:00 | AAPL | Stock | 3.2911 | 3.3164 | 3.2825 | 3.3061 | 37353484.0 |
| 2008-11-14 09:45:00 | AAPL | Stock | 3.3063 | 3.3129 | 3.2618 | 3.2779 | 36602748.0 |
| 2008-11-14 09:50:00 | AAPL | Stock | 3.2779 | 3.3032 | 3.2721 | 3.2886 | 25211256.0 |
| 2008-11-14 09:55:00 | AAPL | Stock | 3.2893 | 3.3014 | 3.2682 | 3.2875 | 28137116.0 |
| 2008-11-14 10:00:00 | AAPL | Stock | 3.2871 | 3.3086 | 3.2857 | 3.2939 | 24175480.0 |
| 2008-11-14 10:05:00 | AAPL | Stock | 3.2939 | 3.2946 | 3.2411 | 3.2554 | 30517088.0 |
| 2008-11-14 10:10:00 | AAPL | Stock | 3.255 | 3.265 | 3.2468 | 3.2468 | 22088780.0 |
| 2008-11-14 10:15:00 | AAPL | Stock | 3.2468 | 3.2857 | 3.2446 | 3.265 | 25718112.0 |
| 2008-11-14 10:20:00 | AAPL | Stock | 3.2643 | 3.2857 | 3.2636 | 3.2711 | 17197152.0 |
| 2008-11-14 10:25:00 | AAPL | Stock | 3.2714 | 3.2967 | 3.2671 | 3.2853 | 15984612.0 |
| 2008-11-14 10:30:00 | AAPL | Stock | 3.2846 | 3.2854 | 3.2639 | 3.2664 | 13828500.0 |
| 2008-11-14 10:35:00 | AAPL | Stock | 3.2664 | 3.2836 | 3.2593 | 3.2654 | 16044700.0 |
| 2008-11-14 10:40:00 | AAPL | Stock | 3.2657 | 3.2854 | 3.2625 | 3.2807 | 15703352.0 |
| 2008-11-14 10:45:00 | AAPL | Stock | 3.2807 | 3.295 | 3.2661 | 3.2921 | 16575776.0 |
| 2008-11-14 10:50:00 | AAPL | Stock | 3.2921 | 3.2964 | 3.275 | 3.2818 | 12500236.0 |
| 2008-11-14 10:55:00 | AAPL | Stock | 3.2825 | 3.2843 | 3.2721 | 3.2739 | 9899708.0 |
| 2008-11-14 11:00:00 | AAPL | Stock | 3.2743 | 3.2761 | 3.2504 | 3.2575 | 16012332.0 |
| 2008-11-14 11:05:00 | AAPL | Stock | 3.2575 | 3.2704 | 3.2514 | 3.2646 | 12707856.0 |
| 2008-11-14 11:10:00 | AAPL | Stock | 3.2646 | 3.2768 | 3.2593 | 3.2739 | 10561880.0 |
| 2008-11-14 11:15:00 | AAPL | Stock | 3.2736 | 3.2925 | 3.2732 | 3.2911 | 13782524.0 |
| 2008-11-14 11:20:00 | AAPL | Stock | 3.2911 | 3.2918 | 3.2625 | 3.2629 | 11979688.0 |
| 2008-11-14 11:25:00 | AAPL | Stock | 3.2629 | 3.2739 | 3.2554 | 3.2554 | 11792172.0 |
| 2008-11-14 11:30:00 | AAPL | Stock | 3.2554 | 3.2571 | 3.2464 | 3.2536 | 15279488.0 |
| 2008-11-14 11:35:00 | AAPL | Stock | 3.2539 | 3.2646 | 3.25 | 3.2557 | 11558064.0 |
| 2008-11-14 11:40:00 | AAPL | Stock | 3.2567 | 3.2593 | 3.2357 | 3.245 | 15394484.0 |
| 2008-11-14 11:45:00 | AAPL | Stock | 3.2446 | 3.2629 | 3.2414 | 3.2611 | 11930240.0 |
| 2008-11-14 11:50:00 | AAPL | Stock | 3.2614 | 3.2679 | 3.2521 | 3.2521 | 15154412.0 |
| 2008-11-14 11:55:00 | AAPL | Stock | 3.2532 | 3.2568 | 3.2393 | 3.2429 | 11107432.0 |
> showing 50 of 305,513 rows — these rows as CSV