PREVIEW / stock_1min / 2011-04-04
file: by_date/stock_1min/2011/2011-04-04.parquet size: 13.2 MB rows: 984,275 symbols: 2,864
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-04-04 05:07:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 2800.0 |
| 2011-04-04 05:16:00 | AAPL | Stock | 12.36 | 12.36 | 12.36 | 12.36 | 3640.0 |
| 2011-04-04 05:17:00 | AAPL | Stock | 12.325 | 12.325 | 12.325 | 12.325 | 2800.0 |
| 2011-04-04 06:54:00 | AAPL | Stock | 12.35 | 12.35 | 12.35 | 12.35 | 10780.0 |
| 2011-04-04 07:10:00 | AAPL | Stock | 12.3575 | 12.3575 | 12.3575 | 12.3575 | 2800.0 |
| 2011-04-04 07:14:00 | AAPL | Stock | 12.3629 | 12.3632 | 12.3629 | 12.3632 | 7336.0 |
| 2011-04-04 07:16:00 | AAPL | Stock | 12.3679 | 12.3779 | 12.3679 | 12.3779 | 8400.0 |
| 2011-04-04 07:18:00 | AAPL | Stock | 12.3714 | 12.3714 | 12.3714 | 12.3714 | 2800.0 |
| 2011-04-04 07:19:00 | AAPL | Stock | 12.3714 | 12.3714 | 12.3714 | 12.3714 | 14000.0 |
| 2011-04-04 07:20:00 | AAPL | Stock | 12.3764 | 12.3764 | 12.3764 | 12.3764 | 2800.0 |
| 2011-04-04 07:22:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 2800.0 |
| 2011-04-04 07:25:00 | AAPL | Stock | 12.3679 | 12.3679 | 12.3679 | 12.3679 | 2800.0 |
| 2011-04-04 07:26:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 14000.0 |
| 2011-04-04 07:27:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3568 | 12.3568 | 11200.0 |
| 2011-04-04 07:28:00 | AAPL | Stock | 12.3568 | 12.3568 | 12.3568 | 12.3568 | 2800.0 |
| 2011-04-04 07:30:00 | AAPL | Stock | 12.3507 | 12.3568 | 12.35 | 12.3568 | 44800.0 |
| 2011-04-04 07:35:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3464 | 12.3464 | 11200.0 |
| 2011-04-04 07:36:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 17360.0 |
| 2011-04-04 07:38:00 | AAPL | Stock | 12.3432 | 12.3432 | 12.3432 | 12.3432 | 2800.0 |
| 2011-04-04 07:41:00 | AAPL | Stock | 12.3464 | 12.3464 | 12.3464 | 12.3464 | 2800.0 |
| 2011-04-04 07:43:00 | AAPL | Stock | 12.3564 | 12.3571 | 12.3564 | 12.3571 | 7000.0 |
| 2011-04-04 07:48:00 | AAPL | Stock | 12.355 | 12.3554 | 12.355 | 12.3554 | 5600.0 |
| 2011-04-04 07:52:00 | AAPL | Stock | 12.3546 | 12.3571 | 12.3546 | 12.3571 | 23800.0 |
| 2011-04-04 07:57:00 | AAPL | Stock | 12.3482 | 12.3482 | 12.3482 | 12.3482 | 2800.0 |
| 2011-04-04 07:58:00 | AAPL | Stock | 12.355 | 12.355 | 12.355 | 12.355 | 2800.0 |
| 2011-04-04 07:59:00 | AAPL | Stock | 12.3536 | 12.3571 | 12.3536 | 12.3571 | 36400.0 |
| 2011-04-04 08:00:00 | AAPL | Stock | 12.3561 | 12.3661 | 12.3468 | 12.3575 | 75740.0 |
| 2011-04-04 08:01:00 | AAPL | Stock | 12.3625 | 12.3643 | 12.3607 | 12.3643 | 195720.0 |
| 2011-04-04 08:02:00 | AAPL | Stock | 12.365 | 12.3657 | 12.3546 | 12.3575 | 218960.0 |
| 2011-04-04 08:04:00 | AAPL | Stock | 12.3575 | 12.4468 | 12.3575 | 12.3575 | 146720.0 |
| 2011-04-04 08:05:00 | AAPL | Stock | 12.3543 | 12.3543 | 12.3518 | 12.3518 | 14000.0 |
| 2011-04-04 08:06:00 | AAPL | Stock | 12.3518 | 12.3518 | 12.3518 | 12.3518 | 5600.0 |
| 2011-04-04 08:08:00 | AAPL | Stock | 12.3536 | 12.3536 | 12.3489 | 12.3489 | 17388.0 |
| 2011-04-04 08:09:00 | AAPL | Stock | 12.3489 | 12.3518 | 12.3464 | 12.3518 | 26320.0 |
| 2011-04-04 08:10:00 | AAPL | Stock | 12.3518 | 12.3557 | 12.3496 | 12.3496 | 41860.0 |
| 2011-04-04 08:11:00 | AAPL | Stock | 12.3536 | 12.3564 | 12.3536 | 12.3564 | 9800.0 |
| 2011-04-04 08:12:00 | AAPL | Stock | 12.35 | 12.35 | 12.35 | 12.35 | 7000.0 |
| 2011-04-04 08:13:00 | AAPL | Stock | 12.35 | 12.3536 | 12.35 | 12.3536 | 50400.0 |
| 2011-04-04 08:14:00 | AAPL | Stock | 12.3511 | 12.3554 | 12.3464 | 12.3554 | 21000.0 |
| 2011-04-04 08:16:00 | AAPL | Stock | 12.3532 | 12.3532 | 12.35 | 12.35 | 7000.0 |
| 2011-04-04 08:17:00 | AAPL | Stock | 12.35 | 12.35 | 12.35 | 12.35 | 2800.0 |
| 2011-04-04 08:20:00 | AAPL | Stock | 12.3532 | 12.3536 | 12.3482 | 12.3482 | 31920.0 |
| 2011-04-04 08:21:00 | AAPL | Stock | 12.3539 | 12.355 | 12.3539 | 12.355 | 14952.0 |
| 2011-04-04 08:24:00 | AAPL | Stock | 12.3518 | 12.3518 | 12.3518 | 12.3518 | 19320.0 |
| 2011-04-04 08:25:00 | AAPL | Stock | 12.3518 | 12.3518 | 12.3518 | 12.3518 | 2800.0 |
| 2011-04-04 08:26:00 | AAPL | Stock | 12.3518 | 12.3518 | 12.3518 | 12.3518 | 2800.0 |
| 2011-04-04 08:27:00 | AAPL | Stock | 12.3518 | 12.3518 | 12.3518 | 12.3518 | 5600.0 |
| 2011-04-04 08:31:00 | AAPL | Stock | 12.3536 | 12.3536 | 12.3532 | 12.3536 | 8960.0 |
| 2011-04-04 08:32:00 | AAPL | Stock | 12.3532 | 12.3536 | 12.3532 | 12.3536 | 35000.0 |
| 2011-04-04 08:33:00 | AAPL | Stock | 12.3511 | 12.3511 | 12.3511 | 12.3511 | 5600.0 |
> showing 50 of 984,275 rows — these rows as CSV