PREVIEW / stock_1min / 2004-01-02
file: by_date/stock_1min/2004/2004-01-02.parquet size: 5.4 MB rows: 441,592 symbols: 1,403
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-02 08:06:00 | AAPL | Stock | 0.3821 | 0.3821 | 0.3821 | 0.3821 | 56000.0 |
| 2004-01-02 09:10:00 | AAPL | Stock | 0.3816 | 0.3816 | 0.3816 | 0.3816 | 912800.0 |
| 2004-01-02 09:20:00 | AAPL | Stock | 0.3838 | 0.3838 | 0.3838 | 0.3838 | 72800.0 |
| 2004-01-02 09:27:00 | AAPL | Stock | 0.3851 | 0.3851 | 0.3851 | 0.3851 | 165200.0 |
| 2004-01-02 09:29:00 | AAPL | Stock | 0.3848 | 0.3859 | 0.3843 | 0.3859 | 1052800.0 |
| 2004-01-02 09:30:00 | AAPL | Stock | 0.3848 | 0.3866 | 0.3846 | 0.3863 | 2066064.0 |
| 2004-01-02 09:31:00 | AAPL | Stock | 0.3862 | 0.3873 | 0.3846 | 0.3868 | 831656.0 |
| 2004-01-02 09:32:00 | AAPL | Stock | 0.3869 | 0.3884 | 0.3863 | 0.3884 | 1121680.0 |
| 2004-01-02 09:33:00 | AAPL | Stock | 0.3882 | 0.3884 | 0.3875 | 0.3877 | 448000.0 |
| 2004-01-02 09:34:00 | AAPL | Stock | 0.3879 | 0.3884 | 0.3875 | 0.3875 | 595616.0 |
| 2004-01-02 09:35:00 | AAPL | Stock | 0.3875 | 0.3875 | 0.3864 | 0.387 | 2665040.0 |
| 2004-01-02 09:36:00 | AAPL | Stock | 0.3875 | 0.3875 | 0.3864 | 0.387 | 2458400.0 |
| 2004-01-02 09:37:00 | AAPL | Stock | 0.3862 | 0.3863 | 0.3854 | 0.3854 | 574112.0 |
| 2004-01-02 09:38:00 | AAPL | Stock | 0.3854 | 0.3861 | 0.3848 | 0.385 | 1883560.0 |
| 2004-01-02 09:39:00 | AAPL | Stock | 0.3848 | 0.385 | 0.3836 | 0.3836 | 963200.0 |
| 2004-01-02 09:40:00 | AAPL | Stock | 0.3836 | 0.3839 | 0.3825 | 0.3832 | 1316000.0 |
| 2004-01-02 09:41:00 | AAPL | Stock | 0.3832 | 0.3843 | 0.383 | 0.383 | 472248.0 |
| 2004-01-02 09:42:00 | AAPL | Stock | 0.3831 | 0.3839 | 0.3823 | 0.383 | 2408000.0 |
| 2004-01-02 09:43:00 | AAPL | Stock | 0.3834 | 0.3839 | 0.3825 | 0.3825 | 1232000.0 |
| 2004-01-02 09:44:00 | AAPL | Stock | 0.3827 | 0.3827 | 0.3818 | 0.3825 | 974400.0 |
| 2004-01-02 09:45:00 | AAPL | Stock | 0.3824 | 0.3824 | 0.382 | 0.382 | 1092000.0 |
| 2004-01-02 09:46:00 | AAPL | Stock | 0.3821 | 0.3821 | 0.382 | 0.3821 | 268520.0 |
| 2004-01-02 09:47:00 | AAPL | Stock | 0.3821 | 0.3821 | 0.382 | 0.382 | 422016.0 |
| 2004-01-02 09:48:00 | AAPL | Stock | 0.3821 | 0.3834 | 0.3821 | 0.383 | 1302112.0 |
| 2004-01-02 09:49:00 | AAPL | Stock | 0.383 | 0.3834 | 0.3821 | 0.3834 | 1005200.0 |
| 2004-01-02 09:50:00 | AAPL | Stock | 0.3836 | 0.3836 | 0.3825 | 0.3828 | 799400.0 |
| 2004-01-02 09:51:00 | AAPL | Stock | 0.3829 | 0.383 | 0.3825 | 0.3825 | 925456.0 |
| 2004-01-02 09:52:00 | AAPL | Stock | 0.3825 | 0.3825 | 0.3821 | 0.3821 | 802816.0 |
| 2004-01-02 09:53:00 | AAPL | Stock | 0.3821 | 0.3821 | 0.3818 | 0.3818 | 548744.0 |
| 2004-01-02 09:54:00 | AAPL | Stock | 0.3818 | 0.382 | 0.3816 | 0.382 | 715064.0 |
| 2004-01-02 09:55:00 | AAPL | Stock | 0.3816 | 0.3823 | 0.3816 | 0.3823 | 1368024.0 |
| 2004-01-02 09:56:00 | AAPL | Stock | 0.3823 | 0.3823 | 0.382 | 0.3821 | 270760.0 |
| 2004-01-02 09:57:00 | AAPL | Stock | 0.382 | 0.3823 | 0.382 | 0.3823 | 347200.0 |
| 2004-01-02 09:58:00 | AAPL | Stock | 0.3823 | 0.3823 | 0.382 | 0.3821 | 595560.0 |
| 2004-01-02 09:59:00 | AAPL | Stock | 0.382 | 0.3825 | 0.3818 | 0.3825 | 463008.0 |
| 2004-01-02 10:00:00 | AAPL | Stock | 0.3823 | 0.383 | 0.382 | 0.382 | 364000.0 |
| 2004-01-02 10:01:00 | AAPL | Stock | 0.3825 | 0.3846 | 0.3824 | 0.3844 | 2859640.0 |
| 2004-01-02 10:02:00 | AAPL | Stock | 0.3844 | 0.3846 | 0.3839 | 0.3843 | 753760.0 |
| 2004-01-02 10:03:00 | AAPL | Stock | 0.3843 | 0.3845 | 0.3841 | 0.3845 | 179200.0 |
| 2004-01-02 10:04:00 | AAPL | Stock | 0.3845 | 0.3846 | 0.3836 | 0.3836 | 1472800.0 |
| 2004-01-02 10:05:00 | AAPL | Stock | 0.3834 | 0.3838 | 0.3827 | 0.3827 | 324800.0 |
| 2004-01-02 10:06:00 | AAPL | Stock | 0.3829 | 0.3832 | 0.3829 | 0.3832 | 252000.0 |
| 2004-01-02 10:07:00 | AAPL | Stock | 0.3832 | 0.3836 | 0.383 | 0.3832 | 67200.0 |
| 2004-01-02 10:08:00 | AAPL | Stock | 0.383 | 0.3832 | 0.383 | 0.3832 | 28000.0 |
| 2004-01-02 10:09:00 | AAPL | Stock | 0.383 | 0.383 | 0.3825 | 0.3825 | 946120.0 |
| 2004-01-02 10:10:00 | AAPL | Stock | 0.3825 | 0.3827 | 0.3825 | 0.3827 | 123200.0 |
| 2004-01-02 10:11:00 | AAPL | Stock | 0.3827 | 0.3839 | 0.3827 | 0.3837 | 1467200.0 |
| 2004-01-02 10:12:00 | AAPL | Stock | 0.3832 | 0.3838 | 0.3829 | 0.3829 | 218400.0 |
| 2004-01-02 10:13:00 | AAPL | Stock | 0.3829 | 0.383 | 0.3827 | 0.383 | 302400.0 |
| 2004-01-02 10:14:00 | AAPL | Stock | 0.383 | 0.383 | 0.383 | 0.383 | 100800.0 |
> showing 50 of 441,592 rows — these rows as CSV