PREVIEW / stock_5min / 2009-07-17
file: by_date/stock_5min/2009/2009-07-17.parquet size: 4.3 MB rows: 302,343 symbols: 3,337
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-07-17 05:05:00 | AAPL | Stock | 5.2686 | 5.2686 | 5.2686 | 5.2686 | 2800.0 |
| 2009-07-17 06:30:00 | AAPL | Stock | 5.2664 | 5.2664 | 5.2664 | 5.2664 | 5600.0 |
| 2009-07-17 07:00:00 | AAPL | Stock | 5.2575 | 5.2575 | 5.2575 | 5.2575 | 2800.0 |
| 2009-07-17 07:05:00 | AAPL | Stock | 5.2629 | 5.2714 | 5.2539 | 5.2539 | 34440.0 |
| 2009-07-17 07:10:00 | AAPL | Stock | 5.2571 | 5.2571 | 5.2571 | 5.2571 | 19600.0 |
| 2009-07-17 07:15:00 | AAPL | Stock | 5.2571 | 5.2579 | 5.2571 | 5.2579 | 17192.0 |
| 2009-07-17 07:25:00 | AAPL | Stock | 5.2571 | 5.2571 | 5.2571 | 5.2571 | 9464.0 |
| 2009-07-17 07:35:00 | AAPL | Stock | 5.2536 | 5.2536 | 5.2536 | 5.2536 | 10136.0 |
| 2009-07-17 07:40:00 | AAPL | Stock | 5.2536 | 5.2589 | 5.2504 | 5.2589 | 112000.0 |
| 2009-07-17 07:45:00 | AAPL | Stock | 5.2507 | 5.2536 | 5.2507 | 5.2536 | 5600.0 |
| 2009-07-17 07:55:00 | AAPL | Stock | 5.2518 | 5.2529 | 5.2518 | 5.2525 | 19544.0 |
| 2009-07-17 08:00:00 | AAPL | Stock | 5.2571 | 5.2754 | 5.2511 | 5.2611 | 92400.0 |
| 2009-07-17 08:05:00 | AAPL | Stock | 5.2621 | 5.2664 | 5.2611 | 5.2664 | 22400.0 |
| 2009-07-17 08:10:00 | AAPL | Stock | 5.2664 | 5.2754 | 5.2664 | 5.2754 | 172620.0 |
| 2009-07-17 08:15:00 | AAPL | Stock | 5.2782 | 5.2804 | 5.2754 | 5.2779 | 66780.0 |
| 2009-07-17 08:20:00 | AAPL | Stock | 5.275 | 5.275 | 5.2732 | 5.2732 | 52864.0 |
| 2009-07-17 08:25:00 | AAPL | Stock | 5.2696 | 5.2746 | 5.2696 | 5.27 | 32200.0 |
| 2009-07-17 08:30:00 | AAPL | Stock | 5.2743 | 5.275 | 5.2736 | 5.275 | 83832.0 |
| 2009-07-17 08:35:00 | AAPL | Stock | 5.2757 | 5.2893 | 5.2754 | 5.2893 | 264964.0 |
| 2009-07-17 08:40:00 | AAPL | Stock | 5.2918 | 5.2936 | 5.2896 | 5.2936 | 91364.0 |
| 2009-07-17 08:45:00 | AAPL | Stock | 5.2936 | 5.2946 | 5.2911 | 5.2946 | 111328.0 |
| 2009-07-17 08:50:00 | AAPL | Stock | 5.2957 | 5.2961 | 5.2929 | 5.2936 | 155092.0 |
| 2009-07-17 08:55:00 | AAPL | Stock | 5.2936 | 5.3193 | 5.2929 | 5.3107 | 172872.0 |
| 2009-07-17 09:00:00 | AAPL | Stock | 5.3107 | 5.3143 | 5.3014 | 5.3107 | 342748.0 |
| 2009-07-17 09:05:00 | AAPL | Stock | 5.3107 | 5.3207 | 5.3104 | 5.3207 | 239680.0 |
| 2009-07-17 09:10:00 | AAPL | Stock | 5.3189 | 5.3268 | 5.3189 | 5.3243 | 302064.0 |
| 2009-07-17 09:15:00 | AAPL | Stock | 5.3243 | 5.325 | 5.315 | 5.3193 | 289800.0 |
| 2009-07-17 09:20:00 | AAPL | Stock | 5.3154 | 5.3164 | 5.3125 | 5.3139 | 127540.0 |
| 2009-07-17 09:25:00 | AAPL | Stock | 5.3111 | 5.3332 | 5.3107 | 5.325 | 1255100.0 |
| 2009-07-17 09:30:00 | AAPL | Stock | 5.3243 | 5.3304 | 5.3082 | 5.3221 | 51379048.0 |
| 2009-07-17 09:35:00 | AAPL | Stock | 5.3214 | 5.3386 | 5.3214 | 5.325 | 17089128.0 |
| 2009-07-17 09:40:00 | AAPL | Stock | 5.3254 | 5.3429 | 5.325 | 5.3375 | 16264108.0 |
| 2009-07-17 09:45:00 | AAPL | Stock | 5.3386 | 5.3464 | 5.3364 | 5.3375 | 11828740.0 |
| 2009-07-17 09:50:00 | AAPL | Stock | 5.3379 | 5.35 | 5.3343 | 5.3464 | 13831384.0 |
| 2009-07-17 09:55:00 | AAPL | Stock | 5.3461 | 5.3471 | 5.3393 | 5.3414 | 10025064.0 |
| 2009-07-17 10:00:00 | AAPL | Stock | 5.3414 | 5.3432 | 5.3289 | 5.3393 | 9674532.0 |
| 2009-07-17 10:05:00 | AAPL | Stock | 5.3393 | 5.3521 | 5.3371 | 5.3479 | 14034188.0 |
| 2009-07-17 10:10:00 | AAPL | Stock | 5.3482 | 5.3554 | 5.345 | 5.3521 | 10867024.0 |
| 2009-07-17 10:15:00 | AAPL | Stock | 5.3518 | 5.3568 | 5.3504 | 5.3555 | 9331896.0 |
| 2009-07-17 10:20:00 | AAPL | Stock | 5.3554 | 5.3654 | 5.3529 | 5.3643 | 20062588.0 |
| 2009-07-17 10:25:00 | AAPL | Stock | 5.3643 | 5.3711 | 5.3614 | 5.3707 | 10616816.0 |
| 2009-07-17 10:30:00 | AAPL | Stock | 5.3711 | 5.3714 | 5.3618 | 5.3672 | 7949872.0 |
| 2009-07-17 10:35:00 | AAPL | Stock | 5.3675 | 5.3732 | 5.3614 | 5.3625 | 11911508.0 |
| 2009-07-17 10:40:00 | AAPL | Stock | 5.3621 | 5.3654 | 5.3554 | 5.3611 | 7351820.0 |
| 2009-07-17 10:45:00 | AAPL | Stock | 5.3607 | 5.3657 | 5.3546 | 5.3546 | 6675172.0 |
| 2009-07-17 10:50:00 | AAPL | Stock | 5.3561 | 5.3607 | 5.3543 | 5.3575 | 7684908.0 |
| 2009-07-17 10:55:00 | AAPL | Stock | 5.3577 | 5.36 | 5.3554 | 5.3576 | 3350788.0 |
| 2009-07-17 11:00:00 | AAPL | Stock | 5.3576 | 5.3636 | 5.3554 | 5.3582 | 3829140.0 |
| 2009-07-17 11:05:00 | AAPL | Stock | 5.3582 | 5.3629 | 5.3571 | 5.3589 | 2716812.0 |
| 2009-07-17 11:10:00 | AAPL | Stock | 5.3589 | 5.3611 | 5.3554 | 5.3575 | 3816484.0 |
> showing 50 of 302,343 rows — these rows as CSV