PREVIEW / stock_5min / 2009-09-16
file: by_date/stock_5min/2009/2009-09-16.parquet size: 4.8 MB rows: 328,081 symbols: 3,391
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-09-16 04:15:00 | AAPL | Stock | 6.3389 | 6.3389 | 6.3354 | 6.3389 | 20944.0 |
| 2009-09-16 05:25:00 | AAPL | Stock | 6.3525 | 6.3525 | 6.3525 | 6.3525 | 2800.0 |
| 2009-09-16 05:55:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 2800.0 |
| 2009-09-16 06:20:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3393 | 6.3393 | 15904.0 |
| 2009-09-16 06:40:00 | AAPL | Stock | 6.3425 | 6.3429 | 6.3425 | 6.3429 | 5600.0 |
| 2009-09-16 06:45:00 | AAPL | Stock | 6.3482 | 6.3482 | 6.3432 | 6.3439 | 14000.0 |
| 2009-09-16 06:50:00 | AAPL | Stock | 6.3507 | 6.3571 | 6.3507 | 6.3571 | 5600.0 |
| 2009-09-16 06:55:00 | AAPL | Stock | 6.3611 | 6.3804 | 6.3611 | 6.3804 | 36400.0 |
| 2009-09-16 07:00:00 | AAPL | Stock | 6.3696 | 6.3696 | 6.3611 | 6.3696 | 63588.0 |
| 2009-09-16 07:05:00 | AAPL | Stock | 6.3679 | 6.3689 | 6.3625 | 6.3625 | 88172.0 |
| 2009-09-16 07:10:00 | AAPL | Stock | 6.3625 | 6.3625 | 6.3579 | 6.3579 | 57792.0 |
| 2009-09-16 07:15:00 | AAPL | Stock | 6.3532 | 6.3532 | 6.3514 | 6.3514 | 45920.0 |
| 2009-09-16 07:20:00 | AAPL | Stock | 6.3507 | 6.3554 | 6.3507 | 6.3518 | 131208.0 |
| 2009-09-16 07:25:00 | AAPL | Stock | 6.3511 | 6.3579 | 6.35 | 6.3536 | 44240.0 |
| 2009-09-16 07:30:00 | AAPL | Stock | 6.3518 | 6.3518 | 6.3371 | 6.3371 | 422324.0 |
| 2009-09-16 07:35:00 | AAPL | Stock | 6.34 | 6.34 | 6.335 | 6.3354 | 53228.0 |
| 2009-09-16 07:40:00 | AAPL | Stock | 6.3361 | 6.3443 | 6.3361 | 6.3443 | 74788.0 |
| 2009-09-16 07:45:00 | AAPL | Stock | 6.3443 | 6.3446 | 6.3304 | 6.3311 | 193340.0 |
| 2009-09-16 07:50:00 | AAPL | Stock | 6.3386 | 6.3386 | 6.3354 | 6.3354 | 5600.0 |
| 2009-09-16 07:55:00 | AAPL | Stock | 6.3361 | 6.3414 | 6.3357 | 6.3414 | 68600.0 |
| 2009-09-16 08:00:00 | AAPL | Stock | 6.3443 | 6.3589 | 6.3414 | 6.3571 | 820680.0 |
| 2009-09-16 08:05:00 | AAPL | Stock | 6.3557 | 6.3571 | 6.3529 | 6.3536 | 163688.0 |
| 2009-09-16 08:10:00 | AAPL | Stock | 6.3536 | 6.3643 | 6.3536 | 6.3607 | 392952.0 |
| 2009-09-16 08:15:00 | AAPL | Stock | 6.3607 | 6.3646 | 6.3571 | 6.3643 | 315448.0 |
| 2009-09-16 08:20:00 | AAPL | Stock | 6.3643 | 6.3679 | 6.3629 | 6.3643 | 522508.0 |
| 2009-09-16 08:25:00 | AAPL | Stock | 6.3661 | 6.3679 | 6.3621 | 6.3621 | 352688.0 |
| 2009-09-16 08:30:00 | AAPL | Stock | 6.3625 | 6.3668 | 6.3614 | 6.3668 | 517300.0 |
| 2009-09-16 08:35:00 | AAPL | Stock | 6.3668 | 6.3679 | 6.3625 | 6.3625 | 334488.0 |
| 2009-09-16 08:40:00 | AAPL | Stock | 6.3636 | 6.3643 | 6.3554 | 6.3554 | 369208.0 |
| 2009-09-16 08:45:00 | AAPL | Stock | 6.3554 | 6.3575 | 6.3511 | 6.3543 | 175000.0 |
| 2009-09-16 08:50:00 | AAPL | Stock | 6.3546 | 6.3579 | 6.3536 | 6.3536 | 437780.0 |
| 2009-09-16 08:55:00 | AAPL | Stock | 6.355 | 6.3571 | 6.3518 | 6.3554 | 355096.0 |
| 2009-09-16 09:00:00 | AAPL | Stock | 6.3564 | 6.3571 | 6.3471 | 6.3471 | 452844.0 |
| 2009-09-16 09:05:00 | AAPL | Stock | 6.3475 | 6.3493 | 6.3468 | 6.3482 | 255080.0 |
| 2009-09-16 09:10:00 | AAPL | Stock | 6.3489 | 6.3554 | 6.3489 | 6.3554 | 315392.0 |
| 2009-09-16 09:15:00 | AAPL | Stock | 6.355 | 6.3571 | 6.3532 | 6.3532 | 339080.0 |
| 2009-09-16 09:20:00 | AAPL | Stock | 6.3546 | 6.3571 | 6.3536 | 6.3564 | 503244.0 |
| 2009-09-16 09:25:00 | AAPL | Stock | 6.3554 | 6.3714 | 6.3493 | 6.3571 | 2798180.0 |
| 2009-09-16 09:30:00 | AAPL | Stock | 6.355 | 6.3739 | 6.3529 | 6.3726 | 20821892.0 |
| 2009-09-16 09:35:00 | AAPL | Stock | 6.3729 | 6.375 | 6.355 | 6.3672 | 16509276.0 |
| 2009-09-16 09:40:00 | AAPL | Stock | 6.3661 | 6.4064 | 6.3625 | 6.4043 | 22501192.0 |
| 2009-09-16 09:45:00 | AAPL | Stock | 6.4043 | 6.4214 | 6.3936 | 6.4189 | 25180176.0 |
| 2009-09-16 09:50:00 | AAPL | Stock | 6.4186 | 6.4214 | 6.3907 | 6.3947 | 23412032.0 |
| 2009-09-16 09:55:00 | AAPL | Stock | 6.3936 | 6.4139 | 6.3886 | 6.4111 | 14267792.0 |
| 2009-09-16 10:00:00 | AAPL | Stock | 6.4114 | 6.4257 | 6.4107 | 6.4196 | 13345080.0 |
| 2009-09-16 10:05:00 | AAPL | Stock | 6.4196 | 6.4218 | 6.4107 | 6.415 | 12262068.0 |
| 2009-09-16 10:10:00 | AAPL | Stock | 6.4146 | 6.4179 | 6.4089 | 6.4132 | 8226988.0 |
| 2009-09-16 10:15:00 | AAPL | Stock | 6.4132 | 6.4211 | 6.3964 | 6.3968 | 11259472.0 |
| 2009-09-16 10:20:00 | AAPL | Stock | 6.3968 | 6.4018 | 6.3889 | 6.3979 | 14652512.0 |
| 2009-09-16 10:25:00 | AAPL | Stock | 6.3986 | 6.4061 | 6.3929 | 6.4039 | 5406716.0 |
> showing 50 of 328,081 rows — these rows as CSV