PREVIEW / stock_5min / 2007-01-05
file: by_date/stock_5min/2007/2007-01-05.parquet size: 3.4 MB rows: 247,917 symbols: 2,482
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-01-05 06:25:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0714 | 3.0714 | 14000.0 |
| 2007-01-05 06:40:00 | AAPL | Stock | 3.0596 | 3.0596 | 3.0586 | 3.0586 | 58240.0 |
| 2007-01-05 07:00:00 | AAPL | Stock | 3.0671 | 3.0682 | 3.0671 | 3.0682 | 33600.0 |
| 2007-01-05 07:05:00 | AAPL | Stock | 3.0571 | 3.0571 | 3.0571 | 3.0571 | 2800.0 |
| 2007-01-05 07:15:00 | AAPL | Stock | 3.0571 | 3.0571 | 3.0536 | 3.0536 | 16800.0 |
| 2007-01-05 07:25:00 | AAPL | Stock | 3.0536 | 3.0536 | 3.0536 | 3.0536 | 28000.0 |
| 2007-01-05 07:30:00 | AAPL | Stock | 3.0593 | 3.0593 | 3.0593 | 3.0593 | 2800.0 |
| 2007-01-05 07:35:00 | AAPL | Stock | 3.0571 | 3.0571 | 3.0571 | 3.0571 | 16800.0 |
| 2007-01-05 07:40:00 | AAPL | Stock | 3.0571 | 3.0571 | 3.05 | 3.0536 | 39424.0 |
| 2007-01-05 07:45:00 | AAPL | Stock | 3.05 | 3.05 | 3.05 | 3.05 | 2800.0 |
| 2007-01-05 07:50:00 | AAPL | Stock | 3.0479 | 3.05 | 3.0479 | 3.05 | 18340.0 |
| 2007-01-05 07:55:00 | AAPL | Stock | 3.0489 | 3.05 | 3.0464 | 3.05 | 60200.0 |
| 2007-01-05 08:00:00 | AAPL | Stock | 3.05 | 3.0639 | 3.0464 | 3.0536 | 1288672.0 |
| 2007-01-05 08:05:00 | AAPL | Stock | 3.0504 | 3.0571 | 3.0389 | 3.0443 | 867160.0 |
| 2007-01-05 08:10:00 | AAPL | Stock | 3.0443 | 3.0518 | 3.0407 | 3.05 | 308560.0 |
| 2007-01-05 08:15:00 | AAPL | Stock | 3.05 | 3.0518 | 3.0446 | 3.0464 | 210980.0 |
| 2007-01-05 08:20:00 | AAPL | Stock | 3.0464 | 3.0514 | 3.0446 | 3.0446 | 155400.0 |
| 2007-01-05 08:25:00 | AAPL | Stock | 3.0464 | 3.0536 | 3.0464 | 3.05 | 241444.0 |
| 2007-01-05 08:30:00 | AAPL | Stock | 3.0518 | 3.0593 | 3.0464 | 3.0557 | 1012676.0 |
| 2007-01-05 08:35:00 | AAPL | Stock | 3.0543 | 3.0593 | 3.0525 | 3.0554 | 643132.0 |
| 2007-01-05 08:40:00 | AAPL | Stock | 3.0589 | 3.0593 | 3.0536 | 3.0571 | 238840.0 |
| 2007-01-05 08:45:00 | AAPL | Stock | 3.0571 | 3.0579 | 3.0536 | 3.0536 | 167020.0 |
| 2007-01-05 08:50:00 | AAPL | Stock | 3.0536 | 3.0561 | 3.0525 | 3.0536 | 139524.0 |
| 2007-01-05 08:55:00 | AAPL | Stock | 3.0536 | 3.0568 | 3.05 | 3.05 | 214200.0 |
| 2007-01-05 09:00:00 | AAPL | Stock | 3.0518 | 3.0518 | 3.05 | 3.05 | 78400.0 |
| 2007-01-05 09:05:00 | AAPL | Stock | 3.0532 | 3.0536 | 3.0482 | 3.0482 | 353136.0 |
| 2007-01-05 09:10:00 | AAPL | Stock | 3.0482 | 3.0504 | 3.0464 | 3.05 | 247800.0 |
| 2007-01-05 09:15:00 | AAPL | Stock | 3.05 | 3.0518 | 3.05 | 3.0518 | 128800.0 |
| 2007-01-05 09:20:00 | AAPL | Stock | 3.0518 | 3.0554 | 3.0504 | 3.0507 | 729512.0 |
| 2007-01-05 09:25:00 | AAPL | Stock | 3.0539 | 3.0661 | 3.05 | 3.0632 | 3182620.0 |
| 2007-01-05 09:30:00 | AAPL | Stock | 3.0632 | 3.0771 | 3.0543 | 3.0721 | 39248720.0 |
| 2007-01-05 09:35:00 | AAPL | Stock | 3.0711 | 3.0786 | 3.0607 | 3.0643 | 30208528.0 |
| 2007-01-05 09:40:00 | AAPL | Stock | 3.0643 | 3.0675 | 3.0454 | 3.0518 | 30820188.0 |
| 2007-01-05 09:45:00 | AAPL | Stock | 3.05 | 3.0657 | 3.0371 | 3.0521 | 28456708.0 |
| 2007-01-05 09:50:00 | AAPL | Stock | 3.0521 | 3.0679 | 3.0518 | 3.0614 | 22972740.0 |
| 2007-01-05 09:55:00 | AAPL | Stock | 3.0611 | 3.0629 | 3.0518 | 3.0524 | 13102880.0 |
| 2007-01-05 10:00:00 | AAPL | Stock | 3.0518 | 3.0657 | 3.0464 | 3.0586 | 14839692.0 |
| 2007-01-05 10:05:00 | AAPL | Stock | 3.0579 | 3.0661 | 3.0578 | 3.0636 | 19618312.0 |
| 2007-01-05 10:10:00 | AAPL | Stock | 3.0636 | 3.0668 | 3.0489 | 3.0532 | 21412048.0 |
| 2007-01-05 10:15:00 | AAPL | Stock | 3.0532 | 3.0657 | 3.0489 | 3.0539 | 13362860.0 |
| 2007-01-05 10:20:00 | AAPL | Stock | 3.0539 | 3.0629 | 3.0446 | 3.0478 | 12246164.0 |
| 2007-01-05 10:25:00 | AAPL | Stock | 3.0482 | 3.0586 | 3.0404 | 3.0457 | 14277592.0 |
| 2007-01-05 10:30:00 | AAPL | Stock | 3.046 | 3.0546 | 3.04 | 3.0418 | 10168592.0 |
| 2007-01-05 10:35:00 | AAPL | Stock | 3.0421 | 3.0507 | 3.0361 | 3.0421 | 13996388.0 |
| 2007-01-05 10:40:00 | AAPL | Stock | 3.0421 | 3.0464 | 3.0389 | 3.0393 | 11292736.0 |
| 2007-01-05 10:45:00 | AAPL | Stock | 3.0389 | 3.0429 | 3.0357 | 3.041 | 10941308.0 |
| 2007-01-05 10:50:00 | AAPL | Stock | 3.0407 | 3.045 | 3.04 | 3.0411 | 6841408.0 |
| 2007-01-05 10:55:00 | AAPL | Stock | 3.0411 | 3.0425 | 3.0311 | 3.0318 | 17365068.0 |
| 2007-01-05 11:00:00 | AAPL | Stock | 3.0321 | 3.0436 | 3.0315 | 3.0343 | 10068016.0 |
| 2007-01-05 11:05:00 | AAPL | Stock | 3.0336 | 3.0389 | 3.0236 | 3.0261 | 17628212.0 |
> showing 50 of 247,917 rows — these rows as CSV