PREVIEW / stock_5min / 2007-04-24
file: by_date/stock_5min/2007/2007-04-24.parquet size: 3.6 MB rows: 258,384 symbols: 2,598
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 |
|---|---|---|---|---|---|---|---|
| 2007-04-24 07:10:00 | AAPL | Stock | 3.3482 | 3.3529 | 3.3482 | 3.3529 | 64400.0 |
| 2007-04-24 07:15:00 | AAPL | Stock | 3.3507 | 3.3507 | 3.3507 | 3.3507 | 14000.0 |
| 2007-04-24 07:20:00 | AAPL | Stock | 3.35 | 3.3532 | 3.3411 | 3.3411 | 77672.0 |
| 2007-04-24 07:25:00 | AAPL | Stock | 3.35 | 3.35 | 3.35 | 3.35 | 2800.0 |
| 2007-04-24 07:35:00 | AAPL | Stock | 3.3536 | 3.3564 | 3.3536 | 3.3564 | 70000.0 |
| 2007-04-24 07:40:00 | AAPL | Stock | 3.3564 | 3.3571 | 3.3561 | 3.3571 | 224000.0 |
| 2007-04-24 07:45:00 | AAPL | Stock | 3.3571 | 3.3596 | 3.3571 | 3.3596 | 91952.0 |
| 2007-04-24 07:55:00 | AAPL | Stock | 3.3571 | 3.3607 | 3.3564 | 3.3564 | 47600.0 |
| 2007-04-24 08:00:00 | AAPL | Stock | 3.3539 | 3.3607 | 3.3536 | 3.3604 | 516096.0 |
| 2007-04-24 08:05:00 | AAPL | Stock | 3.3589 | 3.3604 | 3.3554 | 3.3593 | 513212.0 |
| 2007-04-24 08:10:00 | AAPL | Stock | 3.3589 | 3.3607 | 3.3561 | 3.3586 | 449568.0 |
| 2007-04-24 08:15:00 | AAPL | Stock | 3.3571 | 3.3625 | 3.3571 | 3.3621 | 525896.0 |
| 2007-04-24 08:20:00 | AAPL | Stock | 3.3625 | 3.3632 | 3.3571 | 3.3607 | 258440.0 |
| 2007-04-24 08:25:00 | AAPL | Stock | 3.3575 | 3.3596 | 3.3557 | 3.3557 | 222600.0 |
| 2007-04-24 08:30:00 | AAPL | Stock | 3.3554 | 3.3568 | 3.3536 | 3.3568 | 209300.0 |
| 2007-04-24 08:35:00 | AAPL | Stock | 3.3568 | 3.3571 | 3.3568 | 3.3571 | 187600.0 |
| 2007-04-24 08:40:00 | AAPL | Stock | 3.3557 | 3.3568 | 3.3554 | 3.3568 | 58800.0 |
| 2007-04-24 08:45:00 | AAPL | Stock | 3.3571 | 3.3571 | 3.3557 | 3.3568 | 151200.0 |
| 2007-04-24 08:50:00 | AAPL | Stock | 3.3557 | 3.3557 | 3.3539 | 3.3543 | 184464.0 |
| 2007-04-24 08:55:00 | AAPL | Stock | 3.3543 | 3.3557 | 3.3539 | 3.3554 | 129696.0 |
| 2007-04-24 09:00:00 | AAPL | Stock | 3.3554 | 3.3554 | 3.3543 | 3.3554 | 91000.0 |
| 2007-04-24 09:05:00 | AAPL | Stock | 3.3543 | 3.3571 | 3.3543 | 3.3571 | 265132.0 |
| 2007-04-24 09:10:00 | AAPL | Stock | 3.3561 | 3.3589 | 3.3554 | 3.3571 | 359492.0 |
| 2007-04-24 09:15:00 | AAPL | Stock | 3.355 | 3.3571 | 3.3546 | 3.3546 | 57064.0 |
| 2007-04-24 09:20:00 | AAPL | Stock | 3.3543 | 3.3557 | 3.3543 | 3.3546 | 114240.0 |
| 2007-04-24 09:25:00 | AAPL | Stock | 3.3546 | 3.3568 | 3.3536 | 3.3557 | 325920.0 |
| 2007-04-24 09:30:00 | AAPL | Stock | 3.3557 | 3.3607 | 3.3439 | 3.3471 | 25582648.0 |
| 2007-04-24 09:35:00 | AAPL | Stock | 3.3475 | 3.3571 | 3.2607 | 3.3254 | 24217564.0 |
| 2007-04-24 09:40:00 | AAPL | Stock | 3.325 | 3.3329 | 3.3243 | 3.3296 | 9882824.0 |
| 2007-04-24 09:45:00 | AAPL | Stock | 3.3293 | 3.3304 | 3.3168 | 3.3196 | 17733772.0 |
| 2007-04-24 09:50:00 | AAPL | Stock | 3.3196 | 3.3418 | 3.3168 | 3.3375 | 16918188.0 |
| 2007-04-24 09:55:00 | AAPL | Stock | 3.3375 | 3.3486 | 3.3343 | 3.3479 | 15133188.0 |
| 2007-04-24 10:00:00 | AAPL | Stock | 3.3475 | 3.3479 | 3.3354 | 3.3354 | 15613192.0 |
| 2007-04-24 10:05:00 | AAPL | Stock | 3.3354 | 3.3579 | 3.3214 | 3.3232 | 13015548.0 |
| 2007-04-24 10:10:00 | AAPL | Stock | 3.3236 | 3.3311 | 3.3221 | 3.3254 | 7805280.0 |
| 2007-04-24 10:15:00 | AAPL | Stock | 3.3254 | 3.3286 | 3.315 | 3.3189 | 9536240.0 |
| 2007-04-24 10:20:00 | AAPL | Stock | 3.3189 | 3.3204 | 3.3143 | 3.3168 | 9955848.0 |
| 2007-04-24 10:25:00 | AAPL | Stock | 3.3161 | 3.3196 | 3.3129 | 3.3184 | 7838712.0 |
| 2007-04-24 10:30:00 | AAPL | Stock | 3.3179 | 3.3182 | 3.3121 | 3.3171 | 7718004.0 |
| 2007-04-24 10:35:00 | AAPL | Stock | 3.3171 | 3.3254 | 3.3143 | 3.3246 | 8782676.0 |
| 2007-04-24 10:40:00 | AAPL | Stock | 3.3243 | 3.3268 | 3.3186 | 3.3204 | 7026404.0 |
| 2007-04-24 10:45:00 | AAPL | Stock | 3.3196 | 3.3257 | 3.3189 | 3.3243 | 4522952.0 |
| 2007-04-24 10:50:00 | AAPL | Stock | 3.3242 | 3.3242 | 3.3196 | 3.3236 | 5045516.0 |
| 2007-04-24 10:55:00 | AAPL | Stock | 3.3236 | 3.3272 | 3.3211 | 3.3246 | 4219656.0 |
| 2007-04-24 11:00:00 | AAPL | Stock | 3.3246 | 3.325 | 3.3218 | 3.3224 | 3234616.0 |
| 2007-04-24 11:05:00 | AAPL | Stock | 3.3221 | 3.3254 | 3.3221 | 3.3221 | 4264456.0 |
| 2007-04-24 11:10:00 | AAPL | Stock | 3.3218 | 3.3243 | 3.3182 | 3.3182 | 5194980.0 |
| 2007-04-24 11:15:00 | AAPL | Stock | 3.3182 | 3.3186 | 3.3143 | 3.3179 | 6780788.0 |
| 2007-04-24 11:20:00 | AAPL | Stock | 3.3175 | 3.32 | 3.3161 | 3.3168 | 5021240.0 |
| 2007-04-24 11:25:00 | AAPL | Stock | 3.3164 | 3.3268 | 3.3164 | 3.3268 | 7315028.0 |
> showing 50 of 258,384 rows — these rows as CSV