PREVIEW / stock_5min / 2008-03-10
file: by_date/stock_5min/2008/2008-03-10.parquet size: 4.4 MB rows: 321,605 symbols: 3,290
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-03-10 05:20:00 | AAPL | Stock | 4.3746 | 4.3746 | 4.3746 | 4.3746 | 11200.0 |
| 2008-03-10 05:40:00 | AAPL | Stock | 4.3746 | 4.3746 | 4.3746 | 4.3746 | 2800.0 |
| 2008-03-10 06:30:00 | AAPL | Stock | 4.3921 | 4.3921 | 4.3921 | 4.3921 | 2800.0 |
| 2008-03-10 07:00:00 | AAPL | Stock | 4.39 | 4.3921 | 4.39 | 4.3921 | 19600.0 |
| 2008-03-10 07:10:00 | AAPL | Stock | 4.3929 | 4.3929 | 4.3929 | 4.3929 | 21000.0 |
| 2008-03-10 07:20:00 | AAPL | Stock | 4.3975 | 4.4104 | 4.3975 | 4.4104 | 16800.0 |
| 2008-03-10 07:30:00 | AAPL | Stock | 4.3975 | 4.3975 | 4.3975 | 4.3975 | 5600.0 |
| 2008-03-10 07:35:00 | AAPL | Stock | 4.3975 | 4.4089 | 4.3975 | 4.4089 | 61600.0 |
| 2008-03-10 07:40:00 | AAPL | Stock | 4.4075 | 4.4118 | 4.4075 | 4.4118 | 109872.0 |
| 2008-03-10 07:50:00 | AAPL | Stock | 4.3929 | 4.3929 | 4.3929 | 4.3929 | 2800.0 |
| 2008-03-10 07:55:00 | AAPL | Stock | 4.3936 | 4.3964 | 4.3936 | 4.3964 | 16800.0 |
| 2008-03-10 08:00:00 | AAPL | Stock | 4.3964 | 4.4025 | 4.3661 | 4.375 | 444724.0 |
| 2008-03-10 08:05:00 | AAPL | Stock | 4.375 | 4.3814 | 4.3664 | 4.375 | 145012.0 |
| 2008-03-10 08:10:00 | AAPL | Stock | 4.3754 | 4.3911 | 4.3754 | 4.3857 | 120400.0 |
| 2008-03-10 08:15:00 | AAPL | Stock | 4.3804 | 4.3839 | 4.3671 | 4.3714 | 154560.0 |
| 2008-03-10 08:20:00 | AAPL | Stock | 4.375 | 4.3754 | 4.3689 | 4.3714 | 155820.0 |
| 2008-03-10 08:25:00 | AAPL | Stock | 4.3714 | 4.3718 | 4.3696 | 4.3714 | 68600.0 |
| 2008-03-10 08:30:00 | AAPL | Stock | 4.3696 | 4.3743 | 4.3664 | 4.3689 | 97440.0 |
| 2008-03-10 08:35:00 | AAPL | Stock | 4.3664 | 4.3696 | 4.35 | 4.3511 | 211960.0 |
| 2008-03-10 08:40:00 | AAPL | Stock | 4.3511 | 4.3521 | 4.3396 | 4.3461 | 239596.0 |
| 2008-03-10 08:45:00 | AAPL | Stock | 4.3464 | 4.3568 | 4.3464 | 4.3529 | 234136.0 |
| 2008-03-10 08:50:00 | AAPL | Stock | 4.3511 | 4.3521 | 4.3486 | 4.3518 | 44800.0 |
| 2008-03-10 08:55:00 | AAPL | Stock | 4.3525 | 4.3625 | 4.3525 | 4.3607 | 167888.0 |
| 2008-03-10 09:00:00 | AAPL | Stock | 4.3607 | 4.3643 | 4.3582 | 4.3643 | 35000.0 |
| 2008-03-10 09:05:00 | AAPL | Stock | 4.3643 | 4.3661 | 4.3643 | 4.3654 | 128800.0 |
| 2008-03-10 09:10:00 | AAPL | Stock | 4.3643 | 4.3668 | 4.3621 | 4.3668 | 358932.0 |
| 2008-03-10 09:15:00 | AAPL | Stock | 4.3661 | 4.3661 | 4.3661 | 4.3661 | 2800.0 |
| 2008-03-10 09:20:00 | AAPL | Stock | 4.3657 | 4.3657 | 4.3636 | 4.3636 | 51800.0 |
| 2008-03-10 09:25:00 | AAPL | Stock | 4.3657 | 4.3657 | 4.3557 | 4.3607 | 289352.0 |
| 2008-03-10 09:30:00 | AAPL | Stock | 4.3564 | 4.3711 | 4.3261 | 4.3411 | 18331600.0 |
| 2008-03-10 09:35:00 | AAPL | Stock | 4.3407 | 4.38 | 4.3307 | 4.3768 | 22661184.0 |
| 2008-03-10 09:40:00 | AAPL | Stock | 4.3768 | 4.4011 | 4.3582 | 4.4 | 25567360.0 |
| 2008-03-10 09:45:00 | AAPL | Stock | 4.4004 | 4.4004 | 4.3732 | 4.3732 | 18078872.0 |
| 2008-03-10 09:50:00 | AAPL | Stock | 4.3736 | 4.3821 | 4.3589 | 4.3718 | 16177644.0 |
| 2008-03-10 09:55:00 | AAPL | Stock | 4.3721 | 4.3811 | 4.36 | 4.3771 | 13588708.0 |
| 2008-03-10 10:00:00 | AAPL | Stock | 4.3771 | 4.3921 | 4.3714 | 4.3761 | 20044612.0 |
| 2008-03-10 10:05:00 | AAPL | Stock | 4.3761 | 4.3843 | 4.3571 | 4.3714 | 17089380.0 |
| 2008-03-10 10:10:00 | AAPL | Stock | 4.3711 | 4.3818 | 4.3639 | 4.3786 | 12181820.0 |
| 2008-03-10 10:15:00 | AAPL | Stock | 4.3786 | 4.3846 | 4.3525 | 4.358 | 16390416.0 |
| 2008-03-10 10:20:00 | AAPL | Stock | 4.3586 | 4.3661 | 4.345 | 4.3545 | 12912788.0 |
| 2008-03-10 10:25:00 | AAPL | Stock | 4.355 | 4.3604 | 4.3464 | 4.3482 | 10353168.0 |
| 2008-03-10 10:30:00 | AAPL | Stock | 4.3483 | 4.3604 | 4.3464 | 4.3586 | 11210920.0 |
| 2008-03-10 10:35:00 | AAPL | Stock | 4.3589 | 4.3729 | 4.3539 | 4.3704 | 14246680.0 |
| 2008-03-10 10:40:00 | AAPL | Stock | 4.3704 | 4.3807 | 4.3586 | 4.3775 | 16793280.0 |
| 2008-03-10 10:45:00 | AAPL | Stock | 4.3775 | 4.3954 | 4.3729 | 4.3864 | 17764544.0 |
| 2008-03-10 10:50:00 | AAPL | Stock | 4.3864 | 4.3996 | 4.3818 | 4.3941 | 13811224.0 |
| 2008-03-10 10:55:00 | AAPL | Stock | 4.3941 | 4.4093 | 4.3846 | 4.3896 | 18431112.0 |
| 2008-03-10 11:00:00 | AAPL | Stock | 4.3896 | 4.4021 | 4.385 | 4.385 | 15010744.0 |
| 2008-03-10 11:05:00 | AAPL | Stock | 4.3854 | 4.3929 | 4.3793 | 4.3793 | 10011036.0 |
| 2008-03-10 11:10:00 | AAPL | Stock | 4.3793 | 4.3886 | 4.3768 | 4.3843 | 10638488.0 |
> showing 50 of 321,605 rows — these rows as CSV