PREVIEW / stock_5min / 2011-04-04
file: by_date/stock_5min/2011/2011-04-04.parquet size: 4.9 MB rows: 331,154 symbols: 3,536
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:05:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 2800.0 |
| 2011-04-04 05:15:00 | AAPL | Stock | 12.36 | 12.36 | 12.325 | 12.325 | 6440.0 |
| 2011-04-04 06:50:00 | AAPL | Stock | 12.35 | 12.35 | 12.35 | 12.35 | 10780.0 |
| 2011-04-04 07:10:00 | AAPL | Stock | 12.3575 | 12.3632 | 12.3575 | 12.3632 | 10136.0 |
| 2011-04-04 07:15:00 | AAPL | Stock | 12.3679 | 12.3779 | 12.3679 | 12.3714 | 25200.0 |
| 2011-04-04 07:20:00 | AAPL | Stock | 12.3764 | 12.3764 | 12.3571 | 12.3571 | 5600.0 |
| 2011-04-04 07:25:00 | AAPL | Stock | 12.3679 | 12.3679 | 12.3568 | 12.3568 | 30800.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.3432 | 12.3432 | 31360.0 |
| 2011-04-04 07:40:00 | AAPL | Stock | 12.3464 | 12.3571 | 12.3464 | 12.3571 | 9800.0 |
| 2011-04-04 07:45:00 | AAPL | Stock | 12.355 | 12.3554 | 12.355 | 12.3554 | 5600.0 |
| 2011-04-04 07:50:00 | AAPL | Stock | 12.3546 | 12.3571 | 12.3546 | 12.3571 | 23800.0 |
| 2011-04-04 07:55:00 | AAPL | Stock | 12.3482 | 12.3571 | 12.3482 | 12.3571 | 42000.0 |
| 2011-04-04 08:00:00 | AAPL | Stock | 12.3561 | 12.4468 | 12.3468 | 12.3575 | 637140.0 |
| 2011-04-04 08:05:00 | AAPL | Stock | 12.3543 | 12.3543 | 12.3464 | 12.3518 | 63308.0 |
| 2011-04-04 08:10:00 | AAPL | Stock | 12.3518 | 12.3564 | 12.3464 | 12.3554 | 130060.0 |
| 2011-04-04 08:15:00 | AAPL | Stock | 12.3532 | 12.3532 | 12.35 | 12.35 | 9800.0 |
| 2011-04-04 08:20:00 | AAPL | Stock | 12.3532 | 12.355 | 12.3482 | 12.3518 | 66192.0 |
| 2011-04-04 08:25:00 | AAPL | Stock | 12.3518 | 12.3518 | 12.3518 | 12.3518 | 11200.0 |
| 2011-04-04 08:30:00 | AAPL | Stock | 12.3536 | 12.3536 | 12.3504 | 12.3504 | 104160.0 |
| 2011-04-04 08:35:00 | AAPL | Stock | 12.3493 | 12.3507 | 12.3361 | 12.3361 | 107520.0 |
| 2011-04-04 08:40:00 | AAPL | Stock | 12.33 | 12.3429 | 12.33 | 12.3393 | 25984.0 |
| 2011-04-04 08:45:00 | AAPL | Stock | 12.3393 | 12.3457 | 12.3375 | 12.3457 | 89040.0 |
| 2011-04-04 08:50:00 | AAPL | Stock | 12.35 | 12.3529 | 12.3496 | 12.3529 | 51800.0 |
| 2011-04-04 08:55:00 | AAPL | Stock | 12.3493 | 12.3504 | 12.3443 | 12.3482 | 58800.0 |
| 2011-04-04 09:00:00 | AAPL | Stock | 12.3514 | 12.3514 | 12.3357 | 12.3357 | 59920.0 |
| 2011-04-04 09:05:00 | AAPL | Stock | 12.3393 | 12.3482 | 12.3307 | 12.3461 | 253568.0 |
| 2011-04-04 09:10:00 | AAPL | Stock | 12.3446 | 12.3457 | 12.325 | 12.3286 | 241192.0 |
| 2011-04-04 09:15:00 | AAPL | Stock | 12.3268 | 12.3268 | 12.3014 | 12.3182 | 459312.0 |
| 2011-04-04 09:20:00 | AAPL | Stock | 12.3146 | 12.3214 | 12.3114 | 12.3214 | 279440.0 |
| 2011-04-04 09:25:00 | AAPL | Stock | 12.3214 | 12.3232 | 12.2925 | 12.2968 | 577528.0 |
| 2011-04-04 09:30:00 | AAPL | Stock | 12.3029 | 12.3071 | 12.2364 | 12.2425 | 19798548.0 |
| 2011-04-04 09:35:00 | AAPL | Stock | 12.2425 | 12.2821 | 12.2339 | 12.2821 | 14734188.0 |
| 2011-04-04 09:40:00 | AAPL | Stock | 12.2818 | 12.2939 | 12.2296 | 12.2418 | 13011656.0 |
| 2011-04-04 09:45:00 | AAPL | Stock | 12.2411 | 12.2675 | 12.2071 | 12.2161 | 16305464.0 |
| 2011-04-04 09:50:00 | AAPL | Stock | 12.2189 | 12.2189 | 12.1857 | 12.2045 | 14085820.0 |
| 2011-04-04 09:55:00 | AAPL | Stock | 12.2046 | 12.2061 | 12.1546 | 12.1589 | 14989436.0 |
| 2011-04-04 10:00:00 | AAPL | Stock | 12.1596 | 12.1696 | 12.1175 | 12.1189 | 20680828.0 |
| 2011-04-04 10:05:00 | AAPL | Stock | 12.1193 | 12.13 | 12.0857 | 12.1293 | 21698068.0 |
| 2011-04-04 10:10:00 | AAPL | Stock | 12.13 | 12.1511 | 12.1093 | 12.145 | 13122732.0 |
| 2011-04-04 10:15:00 | AAPL | Stock | 12.1436 | 12.1582 | 12.1432 | 12.1553 | 9395148.0 |
| 2011-04-04 10:20:00 | AAPL | Stock | 12.1564 | 12.1732 | 12.1482 | 12.1732 | 8659924.0 |
| 2011-04-04 10:25:00 | AAPL | Stock | 12.1746 | 12.1746 | 12.1325 | 12.1367 | 8167404.0 |
| 2011-04-04 10:30:00 | AAPL | Stock | 12.1357 | 12.1896 | 12.1357 | 12.1817 | 8116584.0 |
| 2011-04-04 10:35:00 | AAPL | Stock | 12.1811 | 12.1964 | 12.1754 | 12.1768 | 6546288.0 |
| 2011-04-04 10:40:00 | AAPL | Stock | 12.1775 | 12.1864 | 12.1725 | 12.18 | 3882788.0 |
| 2011-04-04 10:45:00 | AAPL | Stock | 12.18 | 12.1804 | 12.1671 | 12.175 | 3961552.0 |
| 2011-04-04 10:50:00 | AAPL | Stock | 12.1746 | 12.1818 | 12.1671 | 12.1725 | 3881780.0 |
| 2011-04-04 10:55:00 | AAPL | Stock | 12.1718 | 12.1726 | 12.1254 | 12.1254 | 7734104.0 |
| 2011-04-04 11:00:00 | AAPL | Stock | 12.1257 | 12.1529 | 12.125 | 12.1414 | 5910632.0 |
> showing 50 of 331,154 rows — these rows as CSV