PREVIEW / stock_5min / 2009-10-23
file: by_date/stock_5min/2009/2009-10-23.parquet size: 4.7 MB rows: 317,365 symbols: 3,369
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-23 04:15:00 | AAPL | Stock | 7.3214 | 7.3214 | 7.3214 | 7.3214 | 2800.0 |
| 2009-10-23 05:00:00 | AAPL | Stock | 7.3057 | 7.3057 | 7.3057 | 7.3057 | 2800.0 |
| 2009-10-23 05:15:00 | AAPL | Stock | 7.325 | 7.325 | 7.325 | 7.325 | 5600.0 |
| 2009-10-23 05:25:00 | AAPL | Stock | 7.325 | 7.325 | 7.325 | 7.325 | 2800.0 |
| 2009-10-23 06:25:00 | AAPL | Stock | 7.3375 | 7.3375 | 7.3375 | 7.3375 | 14000.0 |
| 2009-10-23 06:30:00 | AAPL | Stock | 7.3357 | 7.3357 | 7.3357 | 7.3357 | 7364.0 |
| 2009-10-23 06:55:00 | AAPL | Stock | 7.3321 | 7.3321 | 7.3321 | 7.3321 | 2800.0 |
| 2009-10-23 07:00:00 | AAPL | Stock | 7.3286 | 7.3321 | 7.3286 | 7.3321 | 19600.0 |
| 2009-10-23 07:10:00 | AAPL | Stock | 7.3357 | 7.3357 | 7.3357 | 7.3357 | 5600.0 |
| 2009-10-23 07:15:00 | AAPL | Stock | 7.3443 | 7.3571 | 7.3443 | 7.3568 | 49504.0 |
| 2009-10-23 07:20:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 22400.0 |
| 2009-10-23 07:25:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3511 | 7.3511 | 5600.0 |
| 2009-10-23 07:30:00 | AAPL | Stock | 7.3546 | 7.3568 | 7.3479 | 7.3479 | 63000.0 |
| 2009-10-23 07:35:00 | AAPL | Stock | 7.3479 | 7.3536 | 7.3479 | 7.3536 | 11200.0 |
| 2009-10-23 07:40:00 | AAPL | Stock | 7.3536 | 7.3543 | 7.3536 | 7.3543 | 25200.0 |
| 2009-10-23 07:55:00 | AAPL | Stock | 7.35 | 7.3536 | 7.35 | 7.3536 | 14000.0 |
| 2009-10-23 08:00:00 | AAPL | Stock | 7.3564 | 7.3568 | 7.3461 | 7.3464 | 87444.0 |
| 2009-10-23 08:05:00 | AAPL | Stock | 7.3471 | 7.3471 | 7.3279 | 7.3286 | 109900.0 |
| 2009-10-23 08:10:00 | AAPL | Stock | 7.3321 | 7.3393 | 7.3246 | 7.3375 | 194880.0 |
| 2009-10-23 08:15:00 | AAPL | Stock | 7.3375 | 7.3468 | 7.3321 | 7.3321 | 274400.0 |
| 2009-10-23 08:20:00 | AAPL | Stock | 7.3407 | 7.3432 | 7.3329 | 7.3329 | 74200.0 |
| 2009-10-23 08:25:00 | AAPL | Stock | 7.3321 | 7.3343 | 7.33 | 7.3304 | 120064.0 |
| 2009-10-23 08:30:00 | AAPL | Stock | 7.3321 | 7.3557 | 7.3321 | 7.3529 | 710500.0 |
| 2009-10-23 08:35:00 | AAPL | Stock | 7.3504 | 7.3536 | 7.3393 | 7.3536 | 422268.0 |
| 2009-10-23 08:40:00 | AAPL | Stock | 7.3532 | 7.3804 | 7.3532 | 7.3786 | 718004.0 |
| 2009-10-23 08:45:00 | AAPL | Stock | 7.3786 | 7.3811 | 7.3643 | 7.3675 | 416080.0 |
| 2009-10-23 08:50:00 | AAPL | Stock | 7.3714 | 7.3714 | 7.3643 | 7.3679 | 313460.0 |
| 2009-10-23 08:55:00 | AAPL | Stock | 7.3675 | 7.3679 | 7.3643 | 7.3675 | 104692.0 |
| 2009-10-23 09:00:00 | AAPL | Stock | 7.3661 | 7.3696 | 7.3643 | 7.3664 | 275688.0 |
| 2009-10-23 09:05:00 | AAPL | Stock | 7.3664 | 7.3664 | 7.3582 | 7.3586 | 173460.0 |
| 2009-10-23 09:10:00 | AAPL | Stock | 7.3607 | 7.3607 | 7.35 | 7.3571 | 395136.0 |
| 2009-10-23 09:15:00 | AAPL | Stock | 7.3571 | 7.3571 | 7.35 | 7.3521 | 115472.0 |
| 2009-10-23 09:20:00 | AAPL | Stock | 7.3554 | 7.3661 | 7.3525 | 7.365 | 201264.0 |
| 2009-10-23 09:25:00 | AAPL | Stock | 7.365 | 7.3668 | 7.3318 | 7.3439 | 1387288.0 |
| 2009-10-23 09:30:00 | AAPL | Stock | 7.3514 | 7.3536 | 7.3214 | 7.3289 | 24195640.0 |
| 2009-10-23 09:35:00 | AAPL | Stock | 7.3294 | 7.3386 | 7.3 | 7.3121 | 18521496.0 |
| 2009-10-23 09:40:00 | AAPL | Stock | 7.3129 | 7.3279 | 7.2968 | 7.3143 | 10341436.0 |
| 2009-10-23 09:45:00 | AAPL | Stock | 7.3136 | 7.3159 | 7.3014 | 7.3093 | 7779408.0 |
| 2009-10-23 09:50:00 | AAPL | Stock | 7.3104 | 7.3189 | 7.3054 | 7.31 | 9589692.0 |
| 2009-10-23 09:55:00 | AAPL | Stock | 7.3107 | 7.3186 | 7.2957 | 7.3178 | 11118940.0 |
| 2009-10-23 10:00:00 | AAPL | Stock | 7.3175 | 7.3286 | 7.2857 | 7.2864 | 16536464.0 |
| 2009-10-23 10:05:00 | AAPL | Stock | 7.2864 | 7.3107 | 7.2861 | 7.3028 | 9043608.0 |
| 2009-10-23 10:10:00 | AAPL | Stock | 7.3025 | 7.3214 | 7.2968 | 7.3211 | 7752864.0 |
| 2009-10-23 10:15:00 | AAPL | Stock | 7.32 | 7.3421 | 7.3179 | 7.3379 | 8833244.0 |
| 2009-10-23 10:20:00 | AAPL | Stock | 7.3378 | 7.3393 | 7.325 | 7.3368 | 6751892.0 |
| 2009-10-23 10:25:00 | AAPL | Stock | 7.3354 | 7.3375 | 7.3279 | 7.3296 | 6216700.0 |
| 2009-10-23 10:30:00 | AAPL | Stock | 7.3304 | 7.3332 | 7.3196 | 7.3214 | 5911696.0 |
| 2009-10-23 10:35:00 | AAPL | Stock | 7.3214 | 7.3214 | 7.3139 | 7.3196 | 4088308.0 |
| 2009-10-23 10:40:00 | AAPL | Stock | 7.3204 | 7.3211 | 7.3136 | 7.3136 | 2170168.0 |
| 2009-10-23 10:45:00 | AAPL | Stock | 7.3143 | 7.3171 | 7.3039 | 7.3064 | 3645012.0 |
> showing 50 of 317,365 rows — these rows as CSV