PREVIEW / stock_1min / 2003-07-18
file: by_date/stock_1min/2003/2003-07-18.parquet size: 4.8 MB rows: 391,684 symbols: 1,302
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-18 08:00:00 | AAPL | Stock | 0.3736 | 0.3736 | 0.3736 | 0.3736 | 380800.0 |
| 2003-07-18 08:01:00 | AAPL | Stock | 0.375 | 0.375 | 0.375 | 0.375 | 5600.0 |
| 2003-07-18 09:06:00 | AAPL | Stock | 0.3734 | 0.3734 | 0.3734 | 0.3734 | 28000.0 |
| 2003-07-18 09:10:00 | AAPL | Stock | 0.3732 | 0.3732 | 0.3732 | 0.3732 | 28000.0 |
| 2003-07-18 09:11:00 | AAPL | Stock | 0.3734 | 0.3734 | 0.3734 | 0.3734 | 56000.0 |
| 2003-07-18 09:15:00 | AAPL | Stock | 0.3732 | 0.375 | 0.3732 | 0.375 | 25200.0 |
| 2003-07-18 09:20:00 | AAPL | Stock | 0.3732 | 0.3732 | 0.3732 | 0.3732 | 28000.0 |
| 2003-07-18 09:22:00 | AAPL | Stock | 0.3732 | 0.3732 | 0.3732 | 0.3732 | 28000.0 |
| 2003-07-18 09:23:00 | AAPL | Stock | 0.3732 | 0.3746 | 0.3732 | 0.3732 | 89600.0 |
| 2003-07-18 09:25:00 | AAPL | Stock | 0.3714 | 0.3714 | 0.3714 | 0.3714 | 56000.0 |
| 2003-07-18 09:26:00 | AAPL | Stock | 0.3705 | 0.3713 | 0.3705 | 0.3713 | 168000.0 |
| 2003-07-18 09:27:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3705 | 0.3705 | 84000.0 |
| 2003-07-18 09:28:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3705 | 0.3705 | 67200.0 |
| 2003-07-18 09:29:00 | AAPL | Stock | 0.3705 | 0.3723 | 0.37 | 0.3723 | 1416800.0 |
| 2003-07-18 09:30:00 | AAPL | Stock | 0.3732 | 0.3739 | 0.3688 | 0.3732 | 9372496.0 |
| 2003-07-18 09:31:00 | AAPL | Stock | 0.3702 | 0.3727 | 0.3688 | 0.3698 | 1679496.0 |
| 2003-07-18 09:32:00 | AAPL | Stock | 0.3702 | 0.3714 | 0.3688 | 0.3714 | 2693096.0 |
| 2003-07-18 09:33:00 | AAPL | Stock | 0.3716 | 0.3718 | 0.3688 | 0.3705 | 1315328.0 |
| 2003-07-18 09:34:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3688 | 0.3691 | 1023960.0 |
| 2003-07-18 09:35:00 | AAPL | Stock | 0.3689 | 0.3696 | 0.368 | 0.3682 | 1153264.0 |
| 2003-07-18 09:36:00 | AAPL | Stock | 0.368 | 0.3705 | 0.3679 | 0.3684 | 1786736.0 |
| 2003-07-18 09:37:00 | AAPL | Stock | 0.3684 | 0.3696 | 0.3684 | 0.3684 | 772800.0 |
| 2003-07-18 09:38:00 | AAPL | Stock | 0.3686 | 0.3695 | 0.368 | 0.3686 | 789600.0 |
| 2003-07-18 09:39:00 | AAPL | Stock | 0.3686 | 0.3705 | 0.3681 | 0.3702 | 2559200.0 |
| 2003-07-18 09:40:00 | AAPL | Stock | 0.3702 | 0.3702 | 0.3698 | 0.37 | 1338400.0 |
| 2003-07-18 09:41:00 | AAPL | Stock | 0.37 | 0.3702 | 0.3693 | 0.3695 | 1192800.0 |
| 2003-07-18 09:42:00 | AAPL | Stock | 0.3693 | 0.3696 | 0.3688 | 0.3689 | 2396800.0 |
| 2003-07-18 09:43:00 | AAPL | Stock | 0.3689 | 0.3691 | 0.3686 | 0.3689 | 744800.0 |
| 2003-07-18 09:44:00 | AAPL | Stock | 0.3691 | 0.3696 | 0.3689 | 0.3695 | 448000.0 |
| 2003-07-18 09:45:00 | AAPL | Stock | 0.3695 | 0.3695 | 0.3691 | 0.3695 | 750400.0 |
| 2003-07-18 09:46:00 | AAPL | Stock | 0.3691 | 0.3695 | 0.3686 | 0.3691 | 2648688.0 |
| 2003-07-18 09:47:00 | AAPL | Stock | 0.3691 | 0.3714 | 0.3689 | 0.3711 | 828800.0 |
| 2003-07-18 09:48:00 | AAPL | Stock | 0.3709 | 0.3714 | 0.3682 | 0.3686 | 1778280.0 |
| 2003-07-18 09:49:00 | AAPL | Stock | 0.3686 | 0.3705 | 0.3686 | 0.3705 | 1198400.0 |
| 2003-07-18 09:50:00 | AAPL | Stock | 0.3707 | 0.3707 | 0.3705 | 0.3705 | 1310400.0 |
| 2003-07-18 09:51:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3696 | 0.3698 | 1243200.0 |
| 2003-07-18 09:52:00 | AAPL | Stock | 0.3698 | 0.37 | 0.3696 | 0.37 | 1540000.0 |
| 2003-07-18 09:53:00 | AAPL | Stock | 0.3698 | 0.37 | 0.3691 | 0.3698 | 371000.0 |
| 2003-07-18 09:54:00 | AAPL | Stock | 0.3696 | 0.3698 | 0.3686 | 0.3689 | 1097600.0 |
| 2003-07-18 09:55:00 | AAPL | Stock | 0.3691 | 0.37 | 0.3688 | 0.3696 | 946400.0 |
| 2003-07-18 09:56:00 | AAPL | Stock | 0.37 | 0.3704 | 0.3688 | 0.3689 | 1506400.0 |
| 2003-07-18 09:57:00 | AAPL | Stock | 0.3689 | 0.3691 | 0.3686 | 0.3689 | 638400.0 |
| 2003-07-18 09:58:00 | AAPL | Stock | 0.3689 | 0.3691 | 0.3686 | 0.3688 | 801920.0 |
| 2003-07-18 09:59:00 | AAPL | Stock | 0.3686 | 0.369 | 0.3686 | 0.3686 | 931672.0 |
| 2003-07-18 10:00:00 | AAPL | Stock | 0.3686 | 0.3693 | 0.3684 | 0.3686 | 946400.0 |
| 2003-07-18 10:01:00 | AAPL | Stock | 0.3688 | 0.3691 | 0.3688 | 0.3689 | 112000.0 |
| 2003-07-18 10:02:00 | AAPL | Stock | 0.3689 | 0.3691 | 0.368 | 0.3684 | 1254400.0 |
| 2003-07-18 10:03:00 | AAPL | Stock | 0.3684 | 0.3691 | 0.3682 | 0.3688 | 616000.0 |
| 2003-07-18 10:04:00 | AAPL | Stock | 0.3686 | 0.3689 | 0.3682 | 0.3686 | 1220800.0 |
| 2003-07-18 10:05:00 | AAPL | Stock | 0.3691 | 0.3691 | 0.368 | 0.3681 | 812000.0 |
> showing 50 of 391,684 rows — these rows as CSV