PREVIEW / stock_1min / 2007-08-21
file: by_date/stock_1min/2007/2007-08-21.parquet size: 11.4 MB rows: 931,092 symbols: 2,559
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-21 09:30:00 | AAPL | Stock | 4.3646 | 4.3646 | 4.3443 | 4.3486 | 5760132.0 |
| 2007-08-21 09:31:00 | AAPL | Stock | 4.3486 | 4.3629 | 4.3425 | 4.3482 | 3023748.0 |
| 2007-08-21 09:32:00 | AAPL | Stock | 4.3482 | 4.3482 | 4.3429 | 4.3454 | 1948548.0 |
| 2007-08-21 09:33:00 | AAPL | Stock | 4.3454 | 4.3482 | 4.3214 | 4.3389 | 5026196.0 |
| 2007-08-21 09:34:00 | AAPL | Stock | 4.3389 | 4.3646 | 4.3311 | 4.3421 | 2731400.0 |
| 2007-08-21 09:35:00 | AAPL | Stock | 4.3425 | 4.3436 | 4.3364 | 4.3382 | 1888152.0 |
| 2007-08-21 09:36:00 | AAPL | Stock | 4.3382 | 4.3421 | 4.3382 | 4.3407 | 780276.0 |
| 2007-08-21 09:37:00 | AAPL | Stock | 4.3411 | 4.3479 | 4.3393 | 4.3455 | 2020312.0 |
| 2007-08-21 09:38:00 | AAPL | Stock | 4.346 | 4.3482 | 4.3446 | 4.347 | 1946868.0 |
| 2007-08-21 09:39:00 | AAPL | Stock | 4.3464 | 4.3564 | 4.3464 | 4.3564 | 2444120.0 |
| 2007-08-21 09:40:00 | AAPL | Stock | 4.3564 | 4.3668 | 4.3564 | 4.3621 | 2420348.0 |
| 2007-08-21 09:41:00 | AAPL | Stock | 4.3611 | 4.3643 | 4.3529 | 4.3643 | 2413040.0 |
| 2007-08-21 09:42:00 | AAPL | Stock | 4.3643 | 4.3904 | 4.3622 | 4.3725 | 4322080.0 |
| 2007-08-21 09:43:00 | AAPL | Stock | 4.3729 | 4.3764 | 4.3636 | 4.3696 | 2192400.0 |
| 2007-08-21 09:44:00 | AAPL | Stock | 4.3701 | 4.3746 | 4.3618 | 4.3718 | 1603784.0 |
| 2007-08-21 09:45:00 | AAPL | Stock | 4.3718 | 4.3821 | 4.3693 | 4.3754 | 2182488.0 |
| 2007-08-21 09:46:00 | AAPL | Stock | 4.375 | 4.3754 | 4.3589 | 4.3629 | 1714300.0 |
| 2007-08-21 09:47:00 | AAPL | Stock | 4.3618 | 4.3682 | 4.3514 | 4.3654 | 2797536.0 |
| 2007-08-21 09:48:00 | AAPL | Stock | 4.3647 | 4.3664 | 4.3536 | 4.3604 | 1540084.0 |
| 2007-08-21 09:49:00 | AAPL | Stock | 4.36 | 4.3629 | 4.3536 | 4.3536 | 1289036.0 |
| 2007-08-21 09:50:00 | AAPL | Stock | 4.3536 | 4.3779 | 4.3536 | 4.3746 | 4186784.0 |
| 2007-08-21 09:51:00 | AAPL | Stock | 4.3732 | 4.3839 | 4.3732 | 4.375 | 2644936.0 |
| 2007-08-21 09:52:00 | AAPL | Stock | 4.375 | 4.3807 | 4.3711 | 4.3796 | 1874432.0 |
| 2007-08-21 09:53:00 | AAPL | Stock | 4.3793 | 4.3818 | 4.375 | 4.3755 | 1463756.0 |
| 2007-08-21 09:54:00 | AAPL | Stock | 4.375 | 4.3757 | 4.3661 | 4.3687 | 2937704.0 |
| 2007-08-21 09:55:00 | AAPL | Stock | 4.3689 | 4.3764 | 4.3679 | 4.375 | 1106196.0 |
| 2007-08-21 09:56:00 | AAPL | Stock | 4.3764 | 4.3846 | 4.3746 | 4.3825 | 2066764.0 |
| 2007-08-21 09:57:00 | AAPL | Stock | 4.3825 | 4.3929 | 4.3821 | 4.3929 | 4305084.0 |
| 2007-08-21 09:58:00 | AAPL | Stock | 4.3929 | 4.4068 | 4.3904 | 4.3925 | 5144804.0 |
| 2007-08-21 09:59:00 | AAPL | Stock | 4.392 | 4.3964 | 4.3868 | 4.3929 | 2309104.0 |
| 2007-08-21 10:00:00 | AAPL | Stock | 4.3929 | 4.3996 | 4.3904 | 4.3939 | 2879688.0 |
| 2007-08-21 10:01:00 | AAPL | Stock | 4.3939 | 4.3966 | 4.385 | 4.3893 | 2664060.0 |
| 2007-08-21 10:02:00 | AAPL | Stock | 4.3889 | 4.39 | 4.3818 | 4.3839 | 2943500.0 |
| 2007-08-21 10:03:00 | AAPL | Stock | 4.3843 | 4.3896 | 4.3796 | 4.3896 | 2141384.0 |
| 2007-08-21 10:04:00 | AAPL | Stock | 4.3896 | 4.3914 | 4.3854 | 4.3904 | 1116696.0 |
| 2007-08-21 10:05:00 | AAPL | Stock | 4.3893 | 4.3964 | 4.3864 | 4.395 | 2108848.0 |
| 2007-08-21 10:06:00 | AAPL | Stock | 4.395 | 4.3964 | 4.3893 | 4.3921 | 1574804.0 |
| 2007-08-21 10:07:00 | AAPL | Stock | 4.3921 | 4.3979 | 4.3918 | 4.394 | 1445304.0 |
| 2007-08-21 10:08:00 | AAPL | Stock | 4.3936 | 4.3936 | 4.3882 | 4.3904 | 1485344.0 |
| 2007-08-21 10:09:00 | AAPL | Stock | 4.39 | 4.3904 | 4.3811 | 4.3839 | 3362856.0 |
| 2007-08-21 10:10:00 | AAPL | Stock | 4.3839 | 4.3839 | 4.3693 | 4.3696 | 3069976.0 |
| 2007-08-21 10:11:00 | AAPL | Stock | 4.3693 | 4.3761 | 4.3654 | 4.3732 | 2954532.0 |
| 2007-08-21 10:12:00 | AAPL | Stock | 4.3721 | 4.3761 | 4.37 | 4.3729 | 2203264.0 |
| 2007-08-21 10:13:00 | AAPL | Stock | 4.3736 | 4.3843 | 4.3732 | 4.3839 | 1890196.0 |
| 2007-08-21 10:14:00 | AAPL | Stock | 4.3839 | 4.3854 | 4.3754 | 4.3789 | 1513568.0 |
| 2007-08-21 10:15:00 | AAPL | Stock | 4.3793 | 4.3846 | 4.3771 | 4.3804 | 2069368.0 |
| 2007-08-21 10:16:00 | AAPL | Stock | 4.3804 | 4.3911 | 4.3779 | 4.3904 | 1981028.0 |
| 2007-08-21 10:17:00 | AAPL | Stock | 4.3911 | 4.3911 | 4.3821 | 4.3846 | 1712564.0 |
| 2007-08-21 10:18:00 | AAPL | Stock | 4.385 | 4.3857 | 4.3811 | 4.3857 | 1882188.0 |
| 2007-08-21 10:19:00 | AAPL | Stock | 4.3846 | 4.385 | 4.3811 | 4.3839 | 858396.0 |
> showing 50 of 931,092 rows — these rows as CSV