PREVIEW / stock_5min / 2003-11-19
file: by_date/stock_5min/2003/2003-11-19.parquet size: 2.2 MB rows: 162,378 symbols: 1,671
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-11-19 09:20:00 | AAPL | Stock | 0.3643 | 0.3643 | 0.3643 | 0.3643 | 5600.0 |
| 2003-11-19 09:25:00 | AAPL | Stock | 0.3661 | 0.3675 | 0.3661 | 0.367 | 470400.0 |
| 2003-11-19 09:30:00 | AAPL | Stock | 0.3671 | 0.3671 | 0.3625 | 0.3639 | 5913320.0 |
| 2003-11-19 09:35:00 | AAPL | Stock | 0.3642 | 0.3648 | 0.3639 | 0.3648 | 1850408.0 |
| 2003-11-19 09:40:00 | AAPL | Stock | 0.3648 | 0.3664 | 0.3645 | 0.3659 | 2838136.0 |
| 2003-11-19 09:45:00 | AAPL | Stock | 0.3659 | 0.3663 | 0.3618 | 0.3636 | 2846088.0 |
| 2003-11-19 09:50:00 | AAPL | Stock | 0.3636 | 0.3641 | 0.3627 | 0.3636 | 2631832.0 |
| 2003-11-19 09:55:00 | AAPL | Stock | 0.3636 | 0.3638 | 0.3623 | 0.3625 | 2177784.0 |
| 2003-11-19 10:00:00 | AAPL | Stock | 0.3625 | 0.3645 | 0.3621 | 0.3645 | 2771496.0 |
| 2003-11-19 10:05:00 | AAPL | Stock | 0.3645 | 0.3661 | 0.3645 | 0.3655 | 2935016.0 |
| 2003-11-19 10:10:00 | AAPL | Stock | 0.3655 | 0.3659 | 0.3641 | 0.3659 | 1837080.0 |
| 2003-11-19 10:15:00 | AAPL | Stock | 0.3659 | 0.3659 | 0.3641 | 0.3645 | 2827496.0 |
| 2003-11-19 10:20:00 | AAPL | Stock | 0.3645 | 0.3657 | 0.3641 | 0.3643 | 5524288.0 |
| 2003-11-19 10:25:00 | AAPL | Stock | 0.3643 | 0.3652 | 0.3634 | 0.3652 | 2830240.0 |
| 2003-11-19 10:30:00 | AAPL | Stock | 0.3652 | 0.3658 | 0.365 | 0.3652 | 2230928.0 |
| 2003-11-19 10:35:00 | AAPL | Stock | 0.3652 | 0.3663 | 0.365 | 0.3663 | 4615408.0 |
| 2003-11-19 10:40:00 | AAPL | Stock | 0.3661 | 0.3664 | 0.3654 | 0.3663 | 4167912.0 |
| 2003-11-19 10:45:00 | AAPL | Stock | 0.3666 | 0.3668 | 0.3655 | 0.3666 | 7265496.0 |
| 2003-11-19 10:50:00 | AAPL | Stock | 0.3668 | 0.3668 | 0.3646 | 0.3652 | 10192000.0 |
| 2003-11-19 10:55:00 | AAPL | Stock | 0.3652 | 0.3663 | 0.3643 | 0.3663 | 2513000.0 |
| 2003-11-19 11:00:00 | AAPL | Stock | 0.3661 | 0.3663 | 0.3655 | 0.3663 | 4201680.0 |
| 2003-11-19 11:05:00 | AAPL | Stock | 0.3661 | 0.3663 | 0.3659 | 0.3661 | 4583600.0 |
| 2003-11-19 11:10:00 | AAPL | Stock | 0.3659 | 0.3664 | 0.3655 | 0.3664 | 6255200.0 |
| 2003-11-19 11:15:00 | AAPL | Stock | 0.3663 | 0.3688 | 0.3663 | 0.368 | 3125360.0 |
| 2003-11-19 11:20:00 | AAPL | Stock | 0.368 | 0.368 | 0.3675 | 0.3679 | 851200.0 |
| 2003-11-19 11:25:00 | AAPL | Stock | 0.3679 | 0.3686 | 0.3677 | 0.3677 | 1228360.0 |
| 2003-11-19 11:30:00 | AAPL | Stock | 0.3675 | 0.3679 | 0.3675 | 0.3675 | 1663200.0 |
| 2003-11-19 11:35:00 | AAPL | Stock | 0.3677 | 0.3682 | 0.3675 | 0.3675 | 6158320.0 |
| 2003-11-19 11:40:00 | AAPL | Stock | 0.3675 | 0.3675 | 0.3661 | 0.3662 | 3593408.0 |
| 2003-11-19 11:45:00 | AAPL | Stock | 0.3661 | 0.367 | 0.3659 | 0.3659 | 7512568.0 |
| 2003-11-19 11:50:00 | AAPL | Stock | 0.3659 | 0.3663 | 0.3657 | 0.3657 | 2438240.0 |
| 2003-11-19 11:55:00 | AAPL | Stock | 0.3658 | 0.3663 | 0.3657 | 0.3659 | 1813952.0 |
| 2003-11-19 12:00:00 | AAPL | Stock | 0.3659 | 0.3668 | 0.3659 | 0.3664 | 4558176.0 |
| 2003-11-19 12:05:00 | AAPL | Stock | 0.3664 | 0.3664 | 0.3659 | 0.3661 | 5846456.0 |
| 2003-11-19 12:10:00 | AAPL | Stock | 0.3659 | 0.3663 | 0.3659 | 0.3659 | 1257816.0 |
| 2003-11-19 12:15:00 | AAPL | Stock | 0.3655 | 0.3659 | 0.3636 | 0.3652 | 8390144.0 |
| 2003-11-19 12:20:00 | AAPL | Stock | 0.3652 | 0.3654 | 0.3641 | 0.3643 | 4132800.0 |
| 2003-11-19 12:25:00 | AAPL | Stock | 0.3643 | 0.365 | 0.3641 | 0.365 | 1581552.0 |
| 2003-11-19 12:30:00 | AAPL | Stock | 0.3652 | 0.3657 | 0.3645 | 0.3652 | 2547720.0 |
| 2003-11-19 12:35:00 | AAPL | Stock | 0.3652 | 0.3655 | 0.3645 | 0.3652 | 3178952.0 |
| 2003-11-19 12:40:00 | AAPL | Stock | 0.3652 | 0.3657 | 0.3652 | 0.3657 | 4843272.0 |
| 2003-11-19 12:45:00 | AAPL | Stock | 0.3657 | 0.3657 | 0.365 | 0.3652 | 4541936.0 |
| 2003-11-19 12:50:00 | AAPL | Stock | 0.3655 | 0.3659 | 0.3652 | 0.3655 | 2828840.0 |
| 2003-11-19 12:55:00 | AAPL | Stock | 0.3655 | 0.3657 | 0.3641 | 0.3643 | 8069376.0 |
| 2003-11-19 13:00:00 | AAPL | Stock | 0.3641 | 0.365 | 0.3641 | 0.365 | 1125768.0 |
| 2003-11-19 13:05:00 | AAPL | Stock | 0.3646 | 0.3648 | 0.3641 | 0.3648 | 993048.0 |
| 2003-11-19 13:10:00 | AAPL | Stock | 0.3646 | 0.3648 | 0.3641 | 0.3641 | 520240.0 |
| 2003-11-19 13:15:00 | AAPL | Stock | 0.3641 | 0.365 | 0.3641 | 0.3645 | 1398096.0 |
| 2003-11-19 13:20:00 | AAPL | Stock | 0.3648 | 0.3657 | 0.3646 | 0.3657 | 1255800.0 |
| 2003-11-19 13:25:00 | AAPL | Stock | 0.3655 | 0.3668 | 0.3652 | 0.3661 | 3273648.0 |
> showing 50 of 162,378 rows — these rows as CSV