PREVIEW / stock_1min / 2011-05-03
file: by_date/stock_1min/2011/2011-05-03.parquet size: 13.9 MB rows: 1,031,579 symbols: 2,883
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-03 04:02:00 | AAPL | Stock | 12.3493 | 12.3507 | 12.3493 | 12.3507 | 5600.0 |
| 2011-05-03 04:42:00 | AAPL | Stock | 12.34 | 12.34 | 12.34 | 12.34 | 2800.0 |
| 2011-05-03 04:51:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 5600.0 |
| 2011-05-03 05:39:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 5600.0 |
| 2011-05-03 06:02:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 8400.0 |
| 2011-05-03 06:13:00 | AAPL | Stock | 12.3404 | 12.3404 | 12.3404 | 12.3404 | 2800.0 |
| 2011-05-03 06:36:00 | AAPL | Stock | 12.34 | 12.34 | 12.34 | 12.34 | 2800.0 |
| 2011-05-03 06:39:00 | AAPL | Stock | 12.34 | 12.34 | 12.34 | 12.34 | 2800.0 |
| 2011-05-03 06:44:00 | AAPL | Stock | 12.34 | 12.34 | 12.34 | 12.34 | 2800.0 |
| 2011-05-03 06:45:00 | AAPL | Stock | 12.34 | 12.34 | 12.34 | 12.34 | 2800.0 |
| 2011-05-03 06:50:00 | AAPL | Stock | 12.3254 | 12.3254 | 12.3254 | 12.3254 | 2800.0 |
| 2011-05-03 06:59:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 13160.0 |
| 2011-05-03 07:00:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 2800.0 |
| 2011-05-03 07:08:00 | AAPL | Stock | 12.3311 | 12.3311 | 12.3311 | 12.3311 | 5600.0 |
| 2011-05-03 07:17:00 | AAPL | Stock | 12.35 | 12.35 | 12.35 | 12.35 | 2800.0 |
| 2011-05-03 07:21:00 | AAPL | Stock | 12.3396 | 12.3396 | 12.3379 | 12.3393 | 28000.0 |
| 2011-05-03 07:40:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 2800.0 |
| 2011-05-03 07:43:00 | AAPL | Stock | 12.3436 | 12.3443 | 12.3436 | 12.3443 | 5600.0 |
| 2011-05-03 07:51:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3411 | 12.3411 | 9800.0 |
| 2011-05-03 07:59:00 | AAPL | Stock | 12.3496 | 12.35 | 12.3411 | 12.3411 | 20132.0 |
| 2011-05-03 08:00:00 | AAPL | Stock | 12.35 | 12.3743 | 12.35 | 12.3561 | 33376.0 |
| 2011-05-03 08:01:00 | AAPL | Stock | 12.3729 | 12.3732 | 12.3729 | 12.3732 | 7084.0 |
| 2011-05-03 08:02:00 | AAPL | Stock | 12.3886 | 12.3904 | 12.3646 | 12.3704 | 75600.0 |
| 2011-05-03 08:03:00 | AAPL | Stock | 12.3754 | 12.3779 | 12.3668 | 12.3779 | 176204.0 |
| 2011-05-03 08:04:00 | AAPL | Stock | 12.375 | 12.3821 | 12.375 | 12.3821 | 29400.0 |
| 2011-05-03 08:05:00 | AAPL | Stock | 12.3857 | 12.3875 | 12.3857 | 12.3857 | 29400.0 |
| 2011-05-03 08:06:00 | AAPL | Stock | 12.3789 | 12.3789 | 12.3754 | 12.3754 | 13524.0 |
| 2011-05-03 08:08:00 | AAPL | Stock | 12.3857 | 12.3929 | 12.3857 | 12.3929 | 81284.0 |
| 2011-05-03 08:09:00 | AAPL | Stock | 12.4104 | 12.4104 | 12.3839 | 12.3839 | 84560.0 |
| 2011-05-03 08:10:00 | AAPL | Stock | 12.3946 | 12.3946 | 12.3925 | 12.3925 | 14868.0 |
| 2011-05-03 08:11:00 | AAPL | Stock | 12.3911 | 12.3911 | 12.3911 | 12.3911 | 16800.0 |
| 2011-05-03 08:12:00 | AAPL | Stock | 12.3911 | 12.3929 | 12.3911 | 12.3929 | 36904.0 |
| 2011-05-03 08:13:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 2800.0 |
| 2011-05-03 08:14:00 | AAPL | Stock | 12.4029 | 12.4029 | 12.3964 | 12.3964 | 13160.0 |
| 2011-05-03 08:15:00 | AAPL | Stock | 12.3946 | 12.3964 | 12.3946 | 12.3964 | 5600.0 |
| 2011-05-03 08:16:00 | AAPL | Stock | 12.3982 | 12.3982 | 12.3982 | 12.3982 | 2800.0 |
| 2011-05-03 08:17:00 | AAPL | Stock | 12.4014 | 12.4029 | 12.4014 | 12.4029 | 16800.0 |
| 2011-05-03 08:19:00 | AAPL | Stock | 12.3954 | 12.3954 | 12.3929 | 12.3929 | 67088.0 |
| 2011-05-03 08:20:00 | AAPL | Stock | 12.3964 | 12.3989 | 12.3964 | 12.3989 | 19600.0 |
| 2011-05-03 08:21:00 | AAPL | Stock | 12.3968 | 12.3968 | 12.3968 | 12.3968 | 2800.0 |
| 2011-05-03 08:22:00 | AAPL | Stock | 12.4007 | 12.4018 | 12.4007 | 12.4018 | 26180.0 |
| 2011-05-03 08:23:00 | AAPL | Stock | 12.3989 | 12.3989 | 12.3989 | 12.3989 | 2800.0 |
| 2011-05-03 08:24:00 | AAPL | Stock | 12.3989 | 12.3989 | 12.3989 | 12.3989 | 2800.0 |
| 2011-05-03 08:25:00 | AAPL | Stock | 12.3964 | 12.4 | 12.3964 | 12.3989 | 35000.0 |
| 2011-05-03 08:26:00 | AAPL | Stock | 12.4 | 12.4 | 12.3989 | 12.4 | 25452.0 |
| 2011-05-03 08:27:00 | AAPL | Stock | 12.3964 | 12.3964 | 12.3964 | 12.3964 | 2800.0 |
| 2011-05-03 08:28:00 | AAPL | Stock | 12.3964 | 12.3964 | 12.3964 | 12.3964 | 7560.0 |
| 2011-05-03 08:31:00 | AAPL | Stock | 12.3964 | 12.4 | 12.3964 | 12.4 | 81900.0 |
| 2011-05-03 08:32:00 | AAPL | Stock | 12.3929 | 12.3996 | 12.3929 | 12.3996 | 33600.0 |
| 2011-05-03 08:33:00 | AAPL | Stock | 12.3936 | 12.3936 | 12.3843 | 12.3843 | 59220.0 |
> showing 50 of 1,031,579 rows — these rows as CSV