PREVIEW / stock_5min / 2003-07-09
file: by_date/stock_5min/2003/2003-07-09.parquet size: 2.2 MB rows: 159,383 symbols: 1,586
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-09 08:35:00 | AAPL | Stock | 0.3588 | 0.3595 | 0.3588 | 0.3595 | 78400.0 |
| 2003-07-09 08:45:00 | AAPL | Stock | 0.3593 | 0.3595 | 0.3593 | 0.3595 | 11200.0 |
| 2003-07-09 08:50:00 | AAPL | Stock | 0.3595 | 0.3595 | 0.3595 | 0.3595 | 5600.0 |
| 2003-07-09 08:55:00 | AAPL | Stock | 0.36 | 0.3607 | 0.36 | 0.3607 | 22400.0 |
| 2003-07-09 09:00:00 | AAPL | Stock | 0.3613 | 0.3613 | 0.3613 | 0.3613 | 28000.0 |
| 2003-07-09 09:05:00 | AAPL | Stock | 0.3613 | 0.3634 | 0.3613 | 0.3634 | 16800.0 |
| 2003-07-09 09:15:00 | AAPL | Stock | 0.3634 | 0.3643 | 0.3625 | 0.3625 | 235200.0 |
| 2003-07-09 09:20:00 | AAPL | Stock | 0.3625 | 0.3625 | 0.3625 | 0.3625 | 78400.0 |
| 2003-07-09 09:25:00 | AAPL | Stock | 0.3643 | 0.3643 | 0.3609 | 0.3609 | 151200.0 |
| 2003-07-09 09:30:00 | AAPL | Stock | 0.3609 | 0.3641 | 0.3604 | 0.3636 | 10758216.0 |
| 2003-07-09 09:35:00 | AAPL | Stock | 0.3636 | 0.3652 | 0.3632 | 0.3648 | 3836000.0 |
| 2003-07-09 09:40:00 | AAPL | Stock | 0.3648 | 0.3648 | 0.3618 | 0.362 | 11127200.0 |
| 2003-07-09 09:45:00 | AAPL | Stock | 0.3623 | 0.3625 | 0.3605 | 0.362 | 2225160.0 |
| 2003-07-09 09:50:00 | AAPL | Stock | 0.362 | 0.3643 | 0.362 | 0.3639 | 2159304.0 |
| 2003-07-09 09:55:00 | AAPL | Stock | 0.3639 | 0.3643 | 0.3616 | 0.3616 | 2499280.0 |
| 2003-07-09 10:00:00 | AAPL | Stock | 0.3618 | 0.3625 | 0.3593 | 0.3611 | 4053728.0 |
| 2003-07-09 10:05:00 | AAPL | Stock | 0.3611 | 0.3634 | 0.3611 | 0.3629 | 2352000.0 |
| 2003-07-09 10:10:00 | AAPL | Stock | 0.3625 | 0.3632 | 0.362 | 0.3627 | 2396800.0 |
| 2003-07-09 10:15:00 | AAPL | Stock | 0.3625 | 0.365 | 0.3623 | 0.3645 | 2028488.0 |
| 2003-07-09 10:20:00 | AAPL | Stock | 0.3642 | 0.3646 | 0.3632 | 0.3636 | 2216704.0 |
| 2003-07-09 10:25:00 | AAPL | Stock | 0.3636 | 0.3638 | 0.3621 | 0.3623 | 2539488.0 |
| 2003-07-09 10:30:00 | AAPL | Stock | 0.3627 | 0.3629 | 0.3602 | 0.3604 | 1982400.0 |
| 2003-07-09 10:35:00 | AAPL | Stock | 0.3607 | 0.3627 | 0.3604 | 0.3604 | 4876312.0 |
| 2003-07-09 10:40:00 | AAPL | Stock | 0.3604 | 0.3616 | 0.3604 | 0.3609 | 744800.0 |
| 2003-07-09 10:45:00 | AAPL | Stock | 0.3609 | 0.362 | 0.3602 | 0.3602 | 1789704.0 |
| 2003-07-09 10:50:00 | AAPL | Stock | 0.3604 | 0.3607 | 0.3589 | 0.3593 | 3235736.0 |
| 2003-07-09 10:55:00 | AAPL | Stock | 0.3593 | 0.3598 | 0.3577 | 0.3577 | 2372160.0 |
| 2003-07-09 11:00:00 | AAPL | Stock | 0.3577 | 0.3586 | 0.3577 | 0.3579 | 2527672.0 |
| 2003-07-09 11:05:00 | AAPL | Stock | 0.358 | 0.3586 | 0.3575 | 0.3577 | 3423728.0 |
| 2003-07-09 11:10:00 | AAPL | Stock | 0.3577 | 0.358 | 0.3573 | 0.358 | 1595776.0 |
| 2003-07-09 11:15:00 | AAPL | Stock | 0.358 | 0.3591 | 0.358 | 0.3589 | 2346960.0 |
| 2003-07-09 11:20:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3584 | 0.3584 | 1187816.0 |
| 2003-07-09 11:25:00 | AAPL | Stock | 0.3584 | 0.3591 | 0.3582 | 0.3586 | 1148000.0 |
| 2003-07-09 11:30:00 | AAPL | Stock | 0.3586 | 0.3607 | 0.3586 | 0.36 | 1387400.0 |
| 2003-07-09 11:35:00 | AAPL | Stock | 0.3602 | 0.3613 | 0.36 | 0.3605 | 1935808.0 |
| 2003-07-09 11:40:00 | AAPL | Stock | 0.3605 | 0.362 | 0.3605 | 0.362 | 3523408.0 |
| 2003-07-09 11:45:00 | AAPL | Stock | 0.3614 | 0.3621 | 0.3611 | 0.3616 | 3355968.0 |
| 2003-07-09 11:50:00 | AAPL | Stock | 0.3616 | 0.362 | 0.3611 | 0.3613 | 4894792.0 |
| 2003-07-09 11:55:00 | AAPL | Stock | 0.3614 | 0.3616 | 0.3597 | 0.3609 | 2766400.0 |
| 2003-07-09 12:00:00 | AAPL | Stock | 0.3604 | 0.3604 | 0.3584 | 0.3586 | 2043104.0 |
| 2003-07-09 12:05:00 | AAPL | Stock | 0.3588 | 0.3593 | 0.3586 | 0.3588 | 1736224.0 |
| 2003-07-09 12:10:00 | AAPL | Stock | 0.3588 | 0.3589 | 0.3586 | 0.3588 | 2228800.0 |
| 2003-07-09 12:15:00 | AAPL | Stock | 0.3588 | 0.3588 | 0.358 | 0.3582 | 1375136.0 |
| 2003-07-09 12:20:00 | AAPL | Stock | 0.358 | 0.3605 | 0.358 | 0.3602 | 1741600.0 |
| 2003-07-09 12:25:00 | AAPL | Stock | 0.3603 | 0.3604 | 0.3591 | 0.3595 | 1260000.0 |
| 2003-07-09 12:30:00 | AAPL | Stock | 0.3595 | 0.3598 | 0.3589 | 0.3598 | 2400608.0 |
| 2003-07-09 12:35:00 | AAPL | Stock | 0.3598 | 0.36 | 0.3591 | 0.3591 | 869232.0 |
| 2003-07-09 12:40:00 | AAPL | Stock | 0.3593 | 0.3598 | 0.3591 | 0.3596 | 1024800.0 |
| 2003-07-09 12:45:00 | AAPL | Stock | 0.3596 | 0.3599 | 0.3591 | 0.3595 | 1629600.0 |
| 2003-07-09 12:50:00 | AAPL | Stock | 0.3595 | 0.3596 | 0.3595 | 0.3596 | 700000.0 |
> showing 50 of 159,383 rows — these rows as CSV