PREVIEW / stock_5min / 2006-01-17
file: by_date/stock_5min/2006/2006-01-17.parquet size: 3.0 MB rows: 218,204 symbols: 2,184
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-01-17 04:15:00 | AAPL | Stock | 3.0571 | 3.0571 | 3.0571 | 3.0571 | 2800.0 |
| 2006-01-17 04:55:00 | AAPL | Stock | 3.0518 | 3.0518 | 3.0518 | 3.0518 | 56000.0 |
| 2006-01-17 05:00:00 | AAPL | Stock | 3.0446 | 3.0446 | 3.0446 | 3.0446 | 2800.0 |
| 2006-01-17 05:40:00 | AAPL | Stock | 3.0482 | 3.0482 | 3.0482 | 3.0482 | 5600.0 |
| 2006-01-17 06:25:00 | AAPL | Stock | 3.0411 | 3.0411 | 3.0411 | 3.0411 | 11200.0 |
| 2006-01-17 06:40:00 | AAPL | Stock | 3.0446 | 3.0446 | 3.0446 | 3.0446 | 16800.0 |
| 2006-01-17 07:05:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 14000.0 |
| 2006-01-17 07:10:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 13440.0 |
| 2006-01-17 07:15:00 | AAPL | Stock | 3.0464 | 3.0464 | 3.0464 | 3.0464 | 56000.0 |
| 2006-01-17 07:20:00 | AAPL | Stock | 3.0446 | 3.0446 | 3.0446 | 3.0446 | 2800.0 |
| 2006-01-17 07:25:00 | AAPL | Stock | 3.0464 | 3.0464 | 3.0429 | 3.0429 | 95200.0 |
| 2006-01-17 07:30:00 | AAPL | Stock | 3.04 | 3.0464 | 3.0357 | 3.0464 | 47600.0 |
| 2006-01-17 07:40:00 | AAPL | Stock | 3.0446 | 3.0464 | 3.0446 | 3.0464 | 14000.0 |
| 2006-01-17 07:50:00 | AAPL | Stock | 3.0482 | 3.0482 | 3.0482 | 3.0482 | 2800.0 |
| 2006-01-17 08:00:00 | AAPL | Stock | 3.0454 | 3.0604 | 3.0454 | 3.0536 | 1083460.0 |
| 2006-01-17 08:05:00 | AAPL | Stock | 3.0532 | 3.0571 | 3.0496 | 3.0496 | 341488.0 |
| 2006-01-17 08:10:00 | AAPL | Stock | 3.0493 | 3.05 | 3.0464 | 3.05 | 428736.0 |
| 2006-01-17 08:15:00 | AAPL | Stock | 3.0493 | 3.05 | 3.0475 | 3.0496 | 235760.0 |
| 2006-01-17 08:20:00 | AAPL | Stock | 3.0511 | 3.0511 | 3.0464 | 3.0482 | 567616.0 |
| 2006-01-17 08:25:00 | AAPL | Stock | 3.0471 | 3.0486 | 3.0464 | 3.0475 | 339164.0 |
| 2006-01-17 08:30:00 | AAPL | Stock | 3.0471 | 3.0475 | 3.0446 | 3.0446 | 331800.0 |
| 2006-01-17 08:35:00 | AAPL | Stock | 3.0439 | 3.0461 | 3.0393 | 3.0404 | 263956.0 |
| 2006-01-17 08:40:00 | AAPL | Stock | 3.0407 | 3.0468 | 3.0407 | 3.0457 | 341768.0 |
| 2006-01-17 08:45:00 | AAPL | Stock | 3.0457 | 3.05 | 3.0457 | 3.0482 | 518000.0 |
| 2006-01-17 08:50:00 | AAPL | Stock | 3.0479 | 3.0536 | 3.0479 | 3.0525 | 589568.0 |
| 2006-01-17 08:55:00 | AAPL | Stock | 3.0518 | 3.0529 | 3.0482 | 3.0489 | 378700.0 |
| 2006-01-17 09:00:00 | AAPL | Stock | 3.0482 | 3.0496 | 3.0464 | 3.0471 | 397656.0 |
| 2006-01-17 09:05:00 | AAPL | Stock | 3.0471 | 3.0504 | 3.0471 | 3.0471 | 147224.0 |
| 2006-01-17 09:10:00 | AAPL | Stock | 3.0475 | 3.0511 | 3.0461 | 3.0468 | 249844.0 |
| 2006-01-17 09:15:00 | AAPL | Stock | 3.0461 | 3.05 | 3.0461 | 3.0482 | 114464.0 |
| 2006-01-17 09:20:00 | AAPL | Stock | 3.0471 | 3.0489 | 3.0471 | 3.0482 | 187320.0 |
| 2006-01-17 09:25:00 | AAPL | Stock | 3.0468 | 3.0639 | 3.0468 | 3.0621 | 2967720.0 |
| 2006-01-17 09:30:00 | AAPL | Stock | 3.0607 | 3.0686 | 3.0571 | 3.06 | 30840376.0 |
| 2006-01-17 09:35:00 | AAPL | Stock | 3.06 | 3.0671 | 3.0511 | 3.0671 | 19878824.0 |
| 2006-01-17 09:40:00 | AAPL | Stock | 3.0671 | 3.085 | 3.0664 | 3.0743 | 32890648.0 |
| 2006-01-17 09:45:00 | AAPL | Stock | 3.0746 | 3.0746 | 3.0571 | 3.0614 | 17704456.0 |
| 2006-01-17 09:50:00 | AAPL | Stock | 3.0607 | 3.0664 | 3.0571 | 3.0618 | 14117320.0 |
| 2006-01-17 09:55:00 | AAPL | Stock | 3.0621 | 3.0654 | 3.0575 | 3.0607 | 11704168.0 |
| 2006-01-17 10:00:00 | AAPL | Stock | 3.0604 | 3.0643 | 3.0568 | 3.0614 | 11708704.0 |
| 2006-01-17 10:05:00 | AAPL | Stock | 3.0614 | 3.0654 | 3.0582 | 3.0607 | 11525108.0 |
| 2006-01-17 10:10:00 | AAPL | Stock | 3.0607 | 3.0614 | 3.0536 | 3.0536 | 13405084.0 |
| 2006-01-17 10:15:00 | AAPL | Stock | 3.0536 | 3.0571 | 3.0411 | 3.0471 | 28852740.0 |
| 2006-01-17 10:20:00 | AAPL | Stock | 3.0471 | 3.0507 | 3.0418 | 3.0489 | 10697848.0 |
| 2006-01-17 10:25:00 | AAPL | Stock | 3.0486 | 3.0554 | 3.0461 | 3.0529 | 12875016.0 |
| 2006-01-17 10:30:00 | AAPL | Stock | 3.0532 | 3.0536 | 3.0464 | 3.0504 | 7680316.0 |
| 2006-01-17 10:35:00 | AAPL | Stock | 3.0504 | 3.0597 | 3.0454 | 3.0461 | 8903664.0 |
| 2006-01-17 10:40:00 | AAPL | Stock | 3.0461 | 3.0714 | 3.0389 | 3.0393 | 10342892.0 |
| 2006-01-17 10:45:00 | AAPL | Stock | 3.0393 | 3.0407 | 3.0321 | 3.0389 | 16805656.0 |
| 2006-01-17 10:50:00 | AAPL | Stock | 3.0389 | 3.0454 | 3.035 | 3.0371 | 10407768.0 |
| 2006-01-17 10:55:00 | AAPL | Stock | 3.0368 | 3.0375 | 3.025 | 3.0282 | 18542916.0 |
> showing 50 of 218,204 rows — these rows as CSV