PREVIEW / stock_1min / 2009-04-22
file: by_date/stock_1min/2009/2009-04-22.parquet size: 12.7 MB rows: 962,941 symbols: 2,691
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-22 05:09:00 | AAPL | Stock | 4.3171 | 4.3171 | 4.3171 | 4.3171 | 5600.0 |
| 2009-04-22 06:35:00 | AAPL | Stock | 4.3125 | 4.3125 | 4.3125 | 4.3125 | 14000.0 |
| 2009-04-22 06:59:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3214 | 4.3214 | 5600.0 |
| 2009-04-22 07:08:00 | AAPL | Stock | 4.3325 | 4.3325 | 4.3325 | 4.3325 | 2800.0 |
| 2009-04-22 07:09:00 | AAPL | Stock | 4.3325 | 4.3325 | 4.3325 | 4.3325 | 5600.0 |
| 2009-04-22 07:14:00 | AAPL | Stock | 4.3268 | 4.3268 | 4.325 | 4.325 | 16520.0 |
| 2009-04-22 07:19:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3214 | 4.3214 | 2800.0 |
| 2009-04-22 07:21:00 | AAPL | Stock | 4.3196 | 4.3196 | 4.3196 | 4.3196 | 2800.0 |
| 2009-04-22 07:32:00 | AAPL | Stock | 4.3482 | 4.3482 | 4.3393 | 4.3482 | 30772.0 |
| 2009-04-22 07:33:00 | AAPL | Stock | 4.3375 | 4.3375 | 4.3375 | 4.3375 | 2800.0 |
| 2009-04-22 07:34:00 | AAPL | Stock | 4.3375 | 4.3571 | 4.3375 | 4.3568 | 71400.0 |
| 2009-04-22 07:41:00 | AAPL | Stock | 4.3568 | 4.3568 | 4.3568 | 4.3568 | 2800.0 |
| 2009-04-22 07:42:00 | AAPL | Stock | 4.3482 | 4.3482 | 4.3482 | 4.3482 | 8400.0 |
| 2009-04-22 08:00:00 | AAPL | Stock | 4.3429 | 4.3646 | 4.3361 | 4.3571 | 77280.0 |
| 2009-04-22 08:02:00 | AAPL | Stock | 4.3571 | 4.3571 | 4.3393 | 4.3446 | 21000.0 |
| 2009-04-22 08:04:00 | AAPL | Stock | 4.3482 | 4.3482 | 4.3482 | 4.3482 | 4844.0 |
| 2009-04-22 08:05:00 | AAPL | Stock | 4.3482 | 4.3489 | 4.3482 | 4.3489 | 45360.0 |
| 2009-04-22 08:06:00 | AAPL | Stock | 4.3489 | 4.3536 | 4.3446 | 4.3446 | 78960.0 |
| 2009-04-22 08:07:00 | AAPL | Stock | 4.3482 | 4.3482 | 4.3482 | 4.3482 | 13160.0 |
| 2009-04-22 08:08:00 | AAPL | Stock | 4.3482 | 4.3482 | 4.3482 | 4.3482 | 72352.0 |
| 2009-04-22 08:09:00 | AAPL | Stock | 4.35 | 4.35 | 4.3482 | 4.35 | 658420.0 |
| 2009-04-22 08:10:00 | AAPL | Stock | 4.3482 | 4.35 | 4.3482 | 4.35 | 29960.0 |
| 2009-04-22 08:11:00 | AAPL | Stock | 4.35 | 4.35 | 4.3482 | 4.3482 | 49140.0 |
| 2009-04-22 08:12:00 | AAPL | Stock | 4.35 | 4.35 | 4.35 | 4.35 | 44520.0 |
| 2009-04-22 08:13:00 | AAPL | Stock | 4.35 | 4.3518 | 4.3482 | 4.35 | 90580.0 |
| 2009-04-22 08:14:00 | AAPL | Stock | 4.35 | 4.3643 | 4.35 | 4.3643 | 116060.0 |
| 2009-04-22 08:15:00 | AAPL | Stock | 4.3661 | 4.3661 | 4.3661 | 4.3661 | 4480.0 |
| 2009-04-22 08:16:00 | AAPL | Stock | 4.3607 | 4.3607 | 4.3607 | 4.3607 | 8400.0 |
| 2009-04-22 08:17:00 | AAPL | Stock | 4.3571 | 4.3571 | 4.3507 | 4.3507 | 22400.0 |
| 2009-04-22 08:18:00 | AAPL | Stock | 4.3518 | 4.3518 | 4.3493 | 4.35 | 29400.0 |
| 2009-04-22 08:19:00 | AAPL | Stock | 4.35 | 4.35 | 4.35 | 4.35 | 6300.0 |
| 2009-04-22 08:21:00 | AAPL | Stock | 4.35 | 4.35 | 4.35 | 4.35 | 19320.0 |
| 2009-04-22 08:22:00 | AAPL | Stock | 4.35 | 4.3507 | 4.35 | 4.35 | 53760.0 |
| 2009-04-22 08:23:00 | AAPL | Stock | 4.35 | 4.35 | 4.35 | 4.35 | 5600.0 |
| 2009-04-22 08:24:00 | AAPL | Stock | 4.3518 | 4.3536 | 4.3518 | 4.3536 | 19600.0 |
| 2009-04-22 08:25:00 | AAPL | Stock | 4.3536 | 4.3625 | 4.3536 | 4.3625 | 72408.0 |
| 2009-04-22 08:26:00 | AAPL | Stock | 4.3571 | 4.3571 | 4.3536 | 4.3536 | 43540.0 |
| 2009-04-22 08:27:00 | AAPL | Stock | 4.3536 | 4.3536 | 4.3536 | 4.3536 | 2800.0 |
| 2009-04-22 08:32:00 | AAPL | Stock | 4.3575 | 4.3575 | 4.3571 | 4.3571 | 29008.0 |
| 2009-04-22 08:33:00 | AAPL | Stock | 4.3632 | 4.3643 | 4.3607 | 4.3643 | 16912.0 |
| 2009-04-22 08:34:00 | AAPL | Stock | 4.3661 | 4.3661 | 4.3654 | 4.3654 | 26208.0 |
| 2009-04-22 08:35:00 | AAPL | Stock | 4.3675 | 4.3675 | 4.3661 | 4.3661 | 37100.0 |
| 2009-04-22 08:36:00 | AAPL | Stock | 4.3661 | 4.3764 | 4.3654 | 4.3764 | 117180.0 |
| 2009-04-22 08:37:00 | AAPL | Stock | 4.3768 | 4.3857 | 4.3689 | 4.3796 | 114800.0 |
| 2009-04-22 08:38:00 | AAPL | Stock | 4.3796 | 4.3882 | 4.3796 | 4.3804 | 86520.0 |
| 2009-04-22 08:39:00 | AAPL | Stock | 4.3793 | 4.3793 | 4.3696 | 4.3696 | 37940.0 |
| 2009-04-22 08:40:00 | AAPL | Stock | 4.3704 | 4.3714 | 4.3696 | 4.37 | 22400.0 |
| 2009-04-22 08:41:00 | AAPL | Stock | 4.375 | 4.3764 | 4.375 | 4.3757 | 8400.0 |
| 2009-04-22 08:42:00 | AAPL | Stock | 4.3718 | 4.3718 | 4.3714 | 4.3714 | 30800.0 |
| 2009-04-22 08:43:00 | AAPL | Stock | 4.3732 | 4.375 | 4.3714 | 4.3732 | 107800.0 |
> showing 50 of 962,941 rows — these rows as CSV