PREVIEW / stock_1min / 2005-07-11
file: by_date/stock_1min/2005/2005-07-11.parquet size: 7.2 MB rows: 604,464 symbols: 1,668
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-11 08:00:00 | AAPL | Stock | 1.375 | 1.375 | 1.375 | 1.375 | 3920.0 |
| 2005-07-11 08:01:00 | AAPL | Stock | 1.3721 | 1.3721 | 1.3721 | 1.3721 | 317660.0 |
| 2005-07-11 08:04:00 | AAPL | Stock | 1.3839 | 1.3857 | 1.3839 | 1.3857 | 11480.0 |
| 2005-07-11 08:07:00 | AAPL | Stock | 1.3768 | 1.3804 | 1.3768 | 1.3804 | 44800.0 |
| 2005-07-11 08:08:00 | AAPL | Stock | 1.3807 | 1.3854 | 1.3807 | 1.3854 | 58800.0 |
| 2005-07-11 08:10:00 | AAPL | Stock | 1.3821 | 1.3839 | 1.3821 | 1.3839 | 122080.0 |
| 2005-07-11 08:11:00 | AAPL | Stock | 1.3839 | 1.3839 | 1.3821 | 1.3821 | 82320.0 |
| 2005-07-11 08:12:00 | AAPL | Stock | 1.3854 | 1.3854 | 1.3854 | 1.3854 | 26880.0 |
| 2005-07-11 08:13:00 | AAPL | Stock | 1.3839 | 1.3854 | 1.3821 | 1.3854 | 44800.0 |
| 2005-07-11 08:14:00 | AAPL | Stock | 1.3829 | 1.3829 | 1.3829 | 1.3829 | 14000.0 |
| 2005-07-11 08:15:00 | AAPL | Stock | 1.3836 | 1.3836 | 1.3836 | 1.3836 | 8400.0 |
| 2005-07-11 08:16:00 | AAPL | Stock | 1.3821 | 1.3821 | 1.3821 | 1.3821 | 64400.0 |
| 2005-07-11 08:18:00 | AAPL | Stock | 1.3821 | 1.3836 | 1.3818 | 1.3818 | 98000.0 |
| 2005-07-11 08:22:00 | AAPL | Stock | 1.3821 | 1.3821 | 1.3821 | 1.3821 | 11200.0 |
| 2005-07-11 08:23:00 | AAPL | Stock | 1.3821 | 1.3821 | 1.3821 | 1.3821 | 2800.0 |
| 2005-07-11 08:27:00 | AAPL | Stock | 1.3821 | 1.3821 | 1.3821 | 1.3821 | 5600.0 |
| 2005-07-11 08:28:00 | AAPL | Stock | 1.3821 | 1.3821 | 1.3821 | 1.3821 | 5600.0 |
| 2005-07-11 08:29:00 | AAPL | Stock | 1.3796 | 1.3796 | 1.3796 | 1.3796 | 2800.0 |
| 2005-07-11 08:30:00 | AAPL | Stock | 1.3796 | 1.3796 | 1.3796 | 1.3796 | 2800.0 |
| 2005-07-11 08:33:00 | AAPL | Stock | 1.3814 | 1.3814 | 1.3814 | 1.3814 | 2800.0 |
| 2005-07-11 08:35:00 | AAPL | Stock | 1.3814 | 1.3814 | 1.3814 | 1.3814 | 5600.0 |
| 2005-07-11 08:36:00 | AAPL | Stock | 1.3814 | 1.3814 | 1.3814 | 1.3814 | 8400.0 |
| 2005-07-11 08:37:00 | AAPL | Stock | 1.3811 | 1.3814 | 1.3811 | 1.3814 | 5600.0 |
| 2005-07-11 08:39:00 | AAPL | Stock | 1.3814 | 1.3821 | 1.3796 | 1.3796 | 84000.0 |
| 2005-07-11 08:41:00 | AAPL | Stock | 1.3796 | 1.3796 | 1.3796 | 1.3796 | 19600.0 |
| 2005-07-11 08:42:00 | AAPL | Stock | 1.3793 | 1.3793 | 1.3789 | 1.3789 | 11200.0 |
| 2005-07-11 08:43:00 | AAPL | Stock | 1.3789 | 1.3804 | 1.3789 | 1.3804 | 131600.0 |
| 2005-07-11 08:45:00 | AAPL | Stock | 1.3775 | 1.3775 | 1.3775 | 1.3775 | 4900.0 |
| 2005-07-11 08:46:00 | AAPL | Stock | 1.3775 | 1.3775 | 1.3768 | 1.3768 | 8400.0 |
| 2005-07-11 08:50:00 | AAPL | Stock | 1.3782 | 1.3786 | 1.3768 | 1.3768 | 40964.0 |
| 2005-07-11 08:52:00 | AAPL | Stock | 1.3768 | 1.3768 | 1.3768 | 1.3768 | 15428.0 |
| 2005-07-11 08:53:00 | AAPL | Stock | 1.3768 | 1.3768 | 1.3768 | 1.3768 | 4172.0 |
| 2005-07-11 08:54:00 | AAPL | Stock | 1.3757 | 1.3757 | 1.3754 | 1.3754 | 32172.0 |
| 2005-07-11 08:58:00 | AAPL | Stock | 1.3757 | 1.3757 | 1.3757 | 1.3757 | 14000.0 |
| 2005-07-11 08:59:00 | AAPL | Stock | 1.3757 | 1.3757 | 1.3757 | 1.3757 | 7028.0 |
| 2005-07-11 09:00:00 | AAPL | Stock | 1.3754 | 1.3754 | 1.375 | 1.375 | 98000.0 |
| 2005-07-11 09:01:00 | AAPL | Stock | 1.375 | 1.3754 | 1.375 | 1.3754 | 19600.0 |
| 2005-07-11 09:02:00 | AAPL | Stock | 1.3754 | 1.3754 | 1.3754 | 1.3754 | 5600.0 |
| 2005-07-11 09:03:00 | AAPL | Stock | 1.375 | 1.375 | 1.375 | 1.375 | 22400.0 |
| 2005-07-11 09:04:00 | AAPL | Stock | 1.375 | 1.375 | 1.3746 | 1.375 | 53200.0 |
| 2005-07-11 09:05:00 | AAPL | Stock | 1.3746 | 1.3746 | 1.3746 | 1.3746 | 2800.0 |
| 2005-07-11 09:06:00 | AAPL | Stock | 1.375 | 1.375 | 1.375 | 1.375 | 2800.0 |
| 2005-07-11 09:07:00 | AAPL | Stock | 1.375 | 1.375 | 1.375 | 1.375 | 5600.0 |
| 2005-07-11 09:08:00 | AAPL | Stock | 1.3746 | 1.3746 | 1.3746 | 1.3746 | 5600.0 |
| 2005-07-11 09:09:00 | AAPL | Stock | 1.3746 | 1.375 | 1.3743 | 1.3743 | 31248.0 |
| 2005-07-11 09:11:00 | AAPL | Stock | 1.3732 | 1.3746 | 1.3732 | 1.3746 | 36400.0 |
| 2005-07-11 09:12:00 | AAPL | Stock | 1.3746 | 1.3746 | 1.3746 | 1.3746 | 2800.0 |
| 2005-07-11 09:13:00 | AAPL | Stock | 1.375 | 1.375 | 1.375 | 1.375 | 47600.0 |
| 2005-07-11 09:14:00 | AAPL | Stock | 1.3746 | 1.3768 | 1.3746 | 1.3746 | 536200.0 |
| 2005-07-11 09:15:00 | AAPL | Stock | 1.3768 | 1.3768 | 1.3768 | 1.3768 | 5124.0 |
> showing 50 of 604,464 rows — these rows as CSV