PREVIEW / stock_5min / 2007-04-10
file: by_date/stock_5min/2007/2007-04-10.parquet size: 3.5 MB rows: 251,312 symbols: 2,579
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-10 08:00:00 | AAPL | Stock | 3.3471 | 3.3479 | 3.3454 | 3.3454 | 48048.0 |
| 2007-04-10 08:05:00 | AAPL | Stock | 3.3446 | 3.3446 | 3.3443 | 3.3443 | 109060.0 |
| 2007-04-10 08:10:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3411 | 3.3418 | 16800.0 |
| 2007-04-10 08:15:00 | AAPL | Stock | 3.3418 | 3.3429 | 3.3418 | 3.3418 | 74676.0 |
| 2007-04-10 08:20:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3429 | 3.3429 | 20524.0 |
| 2007-04-10 08:25:00 | AAPL | Stock | 3.3429 | 3.3446 | 3.3429 | 3.3446 | 56000.0 |
| 2007-04-10 08:35:00 | AAPL | Stock | 3.3454 | 3.3454 | 3.3454 | 3.3454 | 30800.0 |
| 2007-04-10 08:40:00 | AAPL | Stock | 3.3461 | 3.3461 | 3.3461 | 3.3461 | 2800.0 |
| 2007-04-10 08:55:00 | AAPL | Stock | 3.3468 | 3.3479 | 3.3464 | 3.3479 | 81200.0 |
| 2007-04-10 09:00:00 | AAPL | Stock | 3.3461 | 3.3518 | 3.3461 | 3.35 | 70000.0 |
| 2007-04-10 09:05:00 | AAPL | Stock | 3.35 | 3.3518 | 3.3482 | 3.3482 | 269500.0 |
| 2007-04-10 09:10:00 | AAPL | Stock | 3.35 | 3.3518 | 3.3482 | 3.3482 | 134120.0 |
| 2007-04-10 09:20:00 | AAPL | Stock | 3.3493 | 3.3493 | 3.3493 | 3.3493 | 6720.0 |
| 2007-04-10 09:25:00 | AAPL | Stock | 3.35 | 3.35 | 3.3446 | 3.345 | 159488.0 |
| 2007-04-10 09:30:00 | AAPL | Stock | 3.3454 | 3.3554 | 3.3407 | 3.3471 | 10692500.0 |
| 2007-04-10 09:35:00 | AAPL | Stock | 3.3468 | 3.36 | 3.3468 | 3.3557 | 9093224.0 |
| 2007-04-10 09:40:00 | AAPL | Stock | 3.3554 | 3.3575 | 3.3543 | 3.3543 | 5081524.0 |
| 2007-04-10 09:45:00 | AAPL | Stock | 3.3543 | 3.3546 | 3.3443 | 3.3468 | 11886224.0 |
| 2007-04-10 09:50:00 | AAPL | Stock | 3.3468 | 3.3525 | 3.3464 | 3.3518 | 5326832.0 |
| 2007-04-10 09:55:00 | AAPL | Stock | 3.3514 | 3.3525 | 3.3504 | 3.3514 | 4933880.0 |
| 2007-04-10 10:00:00 | AAPL | Stock | 3.3511 | 3.3532 | 3.3468 | 3.3514 | 5335204.0 |
| 2007-04-10 10:05:00 | AAPL | Stock | 3.3514 | 3.3525 | 3.3446 | 3.3482 | 5991916.0 |
| 2007-04-10 10:10:00 | AAPL | Stock | 3.3482 | 3.3539 | 3.3454 | 3.3531 | 5239108.0 |
| 2007-04-10 10:15:00 | AAPL | Stock | 3.3529 | 3.3557 | 3.3518 | 3.3518 | 4321660.0 |
| 2007-04-10 10:20:00 | AAPL | Stock | 3.3521 | 3.3525 | 3.3493 | 3.3514 | 2914940.0 |
| 2007-04-10 10:25:00 | AAPL | Stock | 3.3511 | 3.3521 | 3.3493 | 3.3493 | 3086272.0 |
| 2007-04-10 10:30:00 | AAPL | Stock | 3.3493 | 3.3532 | 3.3489 | 3.3514 | 4799508.0 |
| 2007-04-10 10:35:00 | AAPL | Stock | 3.3514 | 3.3517 | 3.3457 | 3.3482 | 5800564.0 |
| 2007-04-10 10:40:00 | AAPL | Stock | 3.3486 | 3.3507 | 3.3468 | 3.3489 | 2811396.0 |
| 2007-04-10 10:45:00 | AAPL | Stock | 3.3486 | 3.3504 | 3.3464 | 3.3478 | 2750916.0 |
| 2007-04-10 10:50:00 | AAPL | Stock | 3.3471 | 3.3471 | 3.3432 | 3.3471 | 5227992.0 |
| 2007-04-10 10:55:00 | AAPL | Stock | 3.3471 | 3.3482 | 3.3454 | 3.3464 | 4443348.0 |
| 2007-04-10 11:00:00 | AAPL | Stock | 3.3468 | 3.3486 | 3.3429 | 3.3432 | 3167528.0 |
| 2007-04-10 11:05:00 | AAPL | Stock | 3.3429 | 3.3461 | 3.34 | 3.3457 | 9204720.0 |
| 2007-04-10 11:10:00 | AAPL | Stock | 3.3454 | 3.3482 | 3.3432 | 3.345 | 5327784.0 |
| 2007-04-10 11:15:00 | AAPL | Stock | 3.345 | 3.3482 | 3.3432 | 3.3471 | 4429488.0 |
| 2007-04-10 11:20:00 | AAPL | Stock | 3.3475 | 3.3482 | 3.3446 | 3.3468 | 2667112.0 |
| 2007-04-10 11:25:00 | AAPL | Stock | 3.3468 | 3.3471 | 3.3443 | 3.3454 | 2254756.0 |
| 2007-04-10 11:30:00 | AAPL | Stock | 3.3454 | 3.3475 | 3.345 | 3.3471 | 2135784.0 |
| 2007-04-10 11:35:00 | AAPL | Stock | 3.3471 | 3.3471 | 3.3411 | 3.3414 | 3534972.0 |
| 2007-04-10 11:40:00 | AAPL | Stock | 3.3418 | 3.3464 | 3.3414 | 3.3425 | 3421320.0 |
| 2007-04-10 11:45:00 | AAPL | Stock | 3.3425 | 3.3461 | 3.3421 | 3.3429 | 2788380.0 |
| 2007-04-10 11:50:00 | AAPL | Stock | 3.3429 | 3.3439 | 3.3396 | 3.3407 | 5020092.0 |
| 2007-04-10 11:55:00 | AAPL | Stock | 3.3407 | 3.3432 | 3.3393 | 3.3421 | 4791724.0 |
| 2007-04-10 12:00:00 | AAPL | Stock | 3.3418 | 3.3425 | 3.3407 | 3.3411 | 2563820.0 |
| 2007-04-10 12:05:00 | AAPL | Stock | 3.3411 | 3.3464 | 3.3411 | 3.3436 | 5672940.0 |
| 2007-04-10 12:10:00 | AAPL | Stock | 3.3436 | 3.3446 | 3.3414 | 3.3443 | 2752288.0 |
| 2007-04-10 12:15:00 | AAPL | Stock | 3.3446 | 3.3457 | 3.3432 | 3.3454 | 2734480.0 |
| 2007-04-10 12:20:00 | AAPL | Stock | 3.345 | 3.3475 | 3.345 | 3.3468 | 3843924.0 |
| 2007-04-10 12:25:00 | AAPL | Stock | 3.3464 | 3.3468 | 3.3446 | 3.3454 | 1404928.0 |
> showing 50 of 251,312 rows — these rows as CSV