PREVIEW / stock_5min / 2006-03-09
file: by_date/stock_5min/2006/2006-03-09.parquet size: 3.0 MB rows: 219,776 symbols: 2,194
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-09 06:30:00 | AAPL | Stock | 2.3511 | 2.3511 | 2.3511 | 2.3511 | 2800.0 |
| 2006-03-09 07:20:00 | AAPL | Stock | 2.3786 | 2.3786 | 2.3786 | 2.3786 | 25676.0 |
| 2006-03-09 08:00:00 | AAPL | Stock | 2.3561 | 2.3632 | 2.3561 | 2.3625 | 222880.0 |
| 2006-03-09 08:05:00 | AAPL | Stock | 2.36 | 2.3625 | 2.3571 | 2.3625 | 353556.0 |
| 2006-03-09 08:10:00 | AAPL | Stock | 2.3621 | 2.3621 | 2.3589 | 2.3589 | 78400.0 |
| 2006-03-09 08:15:00 | AAPL | Stock | 2.36 | 2.3607 | 2.3579 | 2.3607 | 137200.0 |
| 2006-03-09 08:20:00 | AAPL | Stock | 2.3607 | 2.3625 | 2.3571 | 2.3589 | 194768.0 |
| 2006-03-09 08:25:00 | AAPL | Stock | 2.3571 | 2.3571 | 2.3561 | 2.3571 | 193200.0 |
| 2006-03-09 08:30:00 | AAPL | Stock | 2.3586 | 2.3586 | 2.3536 | 2.3586 | 280952.0 |
| 2006-03-09 08:35:00 | AAPL | Stock | 2.3589 | 2.3607 | 2.3571 | 2.3571 | 98000.0 |
| 2006-03-09 08:40:00 | AAPL | Stock | 2.3586 | 2.3604 | 2.3575 | 2.3575 | 111216.0 |
| 2006-03-09 08:45:00 | AAPL | Stock | 2.36 | 2.36 | 2.3575 | 2.3575 | 134400.0 |
| 2006-03-09 08:50:00 | AAPL | Stock | 2.3596 | 2.36 | 2.3589 | 2.3589 | 28000.0 |
| 2006-03-09 08:55:00 | AAPL | Stock | 2.3589 | 2.3607 | 2.3589 | 2.3596 | 136668.0 |
| 2006-03-09 09:00:00 | AAPL | Stock | 2.3593 | 2.3593 | 2.3571 | 2.3589 | 83580.0 |
| 2006-03-09 09:05:00 | AAPL | Stock | 2.3607 | 2.3607 | 2.3575 | 2.3579 | 144956.0 |
| 2006-03-09 09:10:00 | AAPL | Stock | 2.3579 | 2.3607 | 2.3536 | 2.355 | 602336.0 |
| 2006-03-09 09:15:00 | AAPL | Stock | 2.3546 | 2.3546 | 2.3546 | 2.3546 | 22344.0 |
| 2006-03-09 09:20:00 | AAPL | Stock | 2.3539 | 2.3571 | 2.3539 | 2.3568 | 131460.0 |
| 2006-03-09 09:25:00 | AAPL | Stock | 2.3554 | 2.365 | 2.3543 | 2.3557 | 1517712.0 |
| 2006-03-09 09:30:00 | AAPL | Stock | 2.3564 | 2.3604 | 2.3289 | 2.3421 | 29246728.0 |
| 2006-03-09 09:35:00 | AAPL | Stock | 2.3421 | 2.35 | 2.3336 | 2.3361 | 17386124.0 |
| 2006-03-09 09:40:00 | AAPL | Stock | 2.3364 | 2.3454 | 2.3343 | 2.3446 | 17888108.0 |
| 2006-03-09 09:45:00 | AAPL | Stock | 2.3446 | 2.3564 | 2.3379 | 2.3564 | 19609548.0 |
| 2006-03-09 09:50:00 | AAPL | Stock | 2.3568 | 2.3739 | 2.3464 | 2.3707 | 23499140.0 |
| 2006-03-09 09:55:00 | AAPL | Stock | 2.3711 | 2.3739 | 2.3654 | 2.3711 | 16203068.0 |
| 2006-03-09 10:00:00 | AAPL | Stock | 2.3704 | 2.3707 | 2.3621 | 2.3643 | 11017720.0 |
| 2006-03-09 10:05:00 | AAPL | Stock | 2.3646 | 2.3679 | 2.3582 | 2.3625 | 12052880.0 |
| 2006-03-09 10:10:00 | AAPL | Stock | 2.3621 | 2.3632 | 2.3504 | 2.3557 | 16158408.0 |
| 2006-03-09 10:15:00 | AAPL | Stock | 2.3561 | 2.3593 | 2.3482 | 2.35 | 14871864.0 |
| 2006-03-09 10:20:00 | AAPL | Stock | 2.3496 | 2.3536 | 2.3468 | 2.3514 | 11212152.0 |
| 2006-03-09 10:25:00 | AAPL | Stock | 2.3514 | 2.3571 | 2.3461 | 2.3543 | 16576224.0 |
| 2006-03-09 10:30:00 | AAPL | Stock | 2.3543 | 2.3621 | 2.3539 | 2.3621 | 9326212.0 |
| 2006-03-09 10:35:00 | AAPL | Stock | 2.3618 | 2.3618 | 2.3525 | 2.3536 | 7600992.0 |
| 2006-03-09 10:40:00 | AAPL | Stock | 2.3536 | 2.3579 | 2.3482 | 2.3493 | 7950544.0 |
| 2006-03-09 10:45:00 | AAPL | Stock | 2.3492 | 2.3532 | 2.3461 | 2.3468 | 9495304.0 |
| 2006-03-09 10:50:00 | AAPL | Stock | 2.3468 | 2.35 | 2.3446 | 2.3479 | 11313400.0 |
| 2006-03-09 10:55:00 | AAPL | Stock | 2.3482 | 2.3482 | 2.3407 | 2.3407 | 8606696.0 |
| 2006-03-09 11:00:00 | AAPL | Stock | 2.3407 | 2.3418 | 2.3346 | 2.3371 | 12540976.0 |
| 2006-03-09 11:05:00 | AAPL | Stock | 2.3371 | 2.3439 | 2.3371 | 2.3421 | 6608952.0 |
| 2006-03-09 11:10:00 | AAPL | Stock | 2.3425 | 2.3479 | 2.3379 | 2.3464 | 6458480.0 |
| 2006-03-09 11:15:00 | AAPL | Stock | 2.3468 | 2.3486 | 2.3429 | 2.3436 | 7908488.0 |
| 2006-03-09 11:20:00 | AAPL | Stock | 2.3429 | 2.3454 | 2.3407 | 2.3418 | 2501744.0 |
| 2006-03-09 11:25:00 | AAPL | Stock | 2.3418 | 2.3446 | 2.3417 | 2.3443 | 2103444.0 |
| 2006-03-09 11:30:00 | AAPL | Stock | 2.3443 | 2.3446 | 2.3379 | 2.34 | 3897040.0 |
| 2006-03-09 11:35:00 | AAPL | Stock | 2.3407 | 2.3407 | 2.3321 | 2.3321 | 5164740.0 |
| 2006-03-09 11:40:00 | AAPL | Stock | 2.3321 | 2.3343 | 2.3282 | 2.3332 | 9231320.0 |
| 2006-03-09 11:45:00 | AAPL | Stock | 2.3336 | 2.34 | 2.3336 | 2.3389 | 5226368.0 |
| 2006-03-09 11:50:00 | AAPL | Stock | 2.3386 | 2.3421 | 2.3339 | 2.3357 | 4564532.0 |
| 2006-03-09 11:55:00 | AAPL | Stock | 2.335 | 2.3357 | 2.3304 | 2.3346 | 3968160.0 |
> showing 50 of 219,776 rows — these rows as CSV