PREVIEW / stock_5min / 2012-04-30
file: by_date/stock_5min/2012/2012-04-30.parquet size: 4.8 MB rows: 325,242 symbols: 3,551
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 |
|---|---|---|---|---|---|---|---|
| 2012-04-30 04:00:00 | AAPL | Stock | 21.6071 | 21.6071 | 21.6071 | 21.6071 | 2800.0 |
| 2012-04-30 05:35:00 | AAPL | Stock | 21.5643 | 21.5643 | 21.5643 | 21.5643 | 2800.0 |
| 2012-04-30 05:40:00 | AAPL | Stock | 21.5643 | 21.5643 | 21.5643 | 21.5643 | 2800.0 |
| 2012-04-30 05:45:00 | AAPL | Stock | 21.5643 | 21.5643 | 21.5643 | 21.5643 | 2800.0 |
| 2012-04-30 05:50:00 | AAPL | Stock | 21.5782 | 21.5782 | 21.5782 | 21.5782 | 2800.0 |
| 2012-04-30 06:05:00 | AAPL | Stock | 21.5643 | 21.5643 | 21.5643 | 21.5643 | 11200.0 |
| 2012-04-30 06:20:00 | AAPL | Stock | 21.5643 | 21.5643 | 21.5643 | 21.5643 | 2800.0 |
| 2012-04-30 06:30:00 | AAPL | Stock | 21.5539 | 21.5539 | 21.5143 | 21.5143 | 22400.0 |
| 2012-04-30 06:35:00 | AAPL | Stock | 21.5143 | 21.5143 | 21.5143 | 21.5143 | 2800.0 |
| 2012-04-30 06:45:00 | AAPL | Stock | 21.5111 | 21.5357 | 21.5107 | 21.5357 | 11200.0 |
| 2012-04-30 07:05:00 | AAPL | Stock | 21.5354 | 21.5354 | 21.5354 | 21.5354 | 2800.0 |
| 2012-04-30 07:10:00 | AAPL | Stock | 21.5036 | 21.505 | 21.5 | 21.5 | 33600.0 |
| 2012-04-30 07:25:00 | AAPL | Stock | 21.5 | 21.5 | 21.4821 | 21.4821 | 39200.0 |
| 2012-04-30 07:30:00 | AAPL | Stock | 21.4821 | 21.4821 | 21.4643 | 21.4643 | 20216.0 |
| 2012-04-30 07:35:00 | AAPL | Stock | 21.4661 | 21.4661 | 21.4471 | 21.4471 | 84896.0 |
| 2012-04-30 07:40:00 | AAPL | Stock | 21.4464 | 21.4554 | 21.4289 | 21.4321 | 65772.0 |
| 2012-04-30 07:45:00 | AAPL | Stock | 21.4321 | 21.4443 | 21.4289 | 21.4357 | 43120.0 |
| 2012-04-30 07:50:00 | AAPL | Stock | 21.4464 | 21.4464 | 21.4361 | 21.4446 | 42000.0 |
| 2012-04-30 07:55:00 | AAPL | Stock | 21.4436 | 21.4436 | 21.3911 | 21.3911 | 272076.0 |
| 2012-04-30 08:00:00 | AAPL | Stock | 21.4068 | 21.5 | 21.3571 | 21.3571 | 521248.0 |
| 2012-04-30 08:05:00 | AAPL | Stock | 21.3589 | 21.3871 | 21.3429 | 21.3532 | 283248.0 |
| 2012-04-30 08:10:00 | AAPL | Stock | 21.3532 | 21.3714 | 21.3343 | 21.3393 | 394408.0 |
| 2012-04-30 08:15:00 | AAPL | Stock | 21.3393 | 21.3571 | 21.3286 | 21.3286 | 638260.0 |
| 2012-04-30 08:20:00 | AAPL | Stock | 21.3289 | 21.3461 | 21.3161 | 21.3393 | 387380.0 |
| 2012-04-30 08:25:00 | AAPL | Stock | 21.3393 | 21.3471 | 21.3214 | 21.3289 | 382956.0 |
| 2012-04-30 08:30:00 | AAPL | Stock | 21.3311 | 21.3429 | 21.3161 | 21.3357 | 322364.0 |
| 2012-04-30 08:35:00 | AAPL | Stock | 21.3393 | 21.3625 | 21.3218 | 21.3589 | 245812.0 |
| 2012-04-30 08:40:00 | AAPL | Stock | 21.3607 | 21.3607 | 21.3414 | 21.3521 | 270592.0 |
| 2012-04-30 08:45:00 | AAPL | Stock | 21.3571 | 21.3929 | 21.3446 | 21.3929 | 551152.0 |
| 2012-04-30 08:50:00 | AAPL | Stock | 21.3929 | 21.4036 | 21.3875 | 21.3943 | 303184.0 |
| 2012-04-30 08:55:00 | AAPL | Stock | 21.3939 | 21.3943 | 21.3786 | 21.3861 | 216636.0 |
| 2012-04-30 09:00:00 | AAPL | Stock | 21.3861 | 21.3861 | 21.3557 | 21.3571 | 297780.0 |
| 2012-04-30 09:05:00 | AAPL | Stock | 21.3564 | 21.3714 | 21.35 | 21.36 | 169960.0 |
| 2012-04-30 09:10:00 | AAPL | Stock | 21.3557 | 21.3582 | 21.3482 | 21.3571 | 232680.0 |
| 2012-04-30 09:15:00 | AAPL | Stock | 21.3564 | 21.3657 | 21.3482 | 21.3496 | 118776.0 |
| 2012-04-30 09:20:00 | AAPL | Stock | 21.3561 | 21.3654 | 21.3343 | 21.3357 | 422716.0 |
| 2012-04-30 09:25:00 | AAPL | Stock | 21.3393 | 21.3579 | 21.3268 | 21.3546 | 902160.0 |
| 2012-04-30 09:30:00 | AAPL | Stock | 21.35 | 21.3714 | 21.2536 | 21.2711 | 20113996.0 |
| 2012-04-30 09:35:00 | AAPL | Stock | 21.2707 | 21.3568 | 21.2611 | 21.3171 | 11953760.0 |
| 2012-04-30 09:40:00 | AAPL | Stock | 21.3161 | 21.335 | 21.1964 | 21.2182 | 11951100.0 |
| 2012-04-30 09:45:00 | AAPL | Stock | 21.2164 | 21.2593 | 21.1282 | 21.1625 | 19146484.0 |
| 2012-04-30 09:50:00 | AAPL | Stock | 21.1554 | 21.1975 | 21.1429 | 21.1564 | 11758656.0 |
| 2012-04-30 09:55:00 | AAPL | Stock | 21.1532 | 21.1686 | 21.0182 | 21.045 | 22743000.0 |
| 2012-04-30 10:00:00 | AAPL | Stock | 21.0443 | 21.125 | 21.0229 | 21.1218 | 18124988.0 |
| 2012-04-30 10:05:00 | AAPL | Stock | 21.1204 | 21.1429 | 21.0786 | 21.1167 | 12297124.0 |
| 2012-04-30 10:10:00 | AAPL | Stock | 21.1211 | 21.1282 | 21.0564 | 21.0936 | 8737092.0 |
| 2012-04-30 10:15:00 | AAPL | Stock | 21.0875 | 21.1143 | 21.0357 | 21.0361 | 7528388.0 |
| 2012-04-30 10:20:00 | AAPL | Stock | 21.0364 | 21.0686 | 21.0089 | 21.0668 | 7657300.0 |
| 2012-04-30 10:25:00 | AAPL | Stock | 21.0661 | 21.09 | 21.0504 | 21.0707 | 6268192.0 |
| 2012-04-30 10:30:00 | AAPL | Stock | 21.0686 | 21.0714 | 21.0261 | 21.058 | 6387388.0 |
> showing 50 of 325,242 rows — these rows as CSV