PREVIEW / stock_5min / 2001-03-09
file: by_date/stock_5min/2001/2001-03-09.parquet size: 1.4 MB rows: 99,491 symbols: 1,268
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-09 08:00:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 168000.0 |
| 2001-03-09 08:05:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 61600.0 |
| 2001-03-09 08:15:00 | AAPL | Stock | 0.3683 | 0.3683 | 0.3683 | 0.3683 | 16800.0 |
| 2001-03-09 08:30:00 | AAPL | Stock | 0.3661 | 0.3683 | 0.3661 | 0.3683 | 84000.0 |
| 2001-03-09 08:35:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 112000.0 |
| 2001-03-09 08:45:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 56000.0 |
| 2001-03-09 08:50:00 | AAPL | Stock | 0.3661 | 0.3683 | 0.3661 | 0.3683 | 336000.0 |
| 2001-03-09 09:00:00 | AAPL | Stock | 0.3644 | 0.3672 | 0.3644 | 0.3661 | 156800.0 |
| 2001-03-09 09:05:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 106400.0 |
| 2001-03-09 09:15:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 11200.0 |
| 2001-03-09 09:20:00 | AAPL | Stock | 0.3644 | 0.3661 | 0.3644 | 0.3661 | 173600.0 |
| 2001-03-09 09:25:00 | AAPL | Stock | 0.3661 | 0.3694 | 0.3661 | 0.3672 | 2032800.0 |
| 2001-03-09 09:30:00 | AAPL | Stock | 0.3683 | 0.3694 | 0.3661 | 0.3672 | 7957600.0 |
| 2001-03-09 09:35:00 | AAPL | Stock | 0.3672 | 0.3694 | 0.3672 | 0.3683 | 3740800.0 |
| 2001-03-09 09:40:00 | AAPL | Stock | 0.3683 | 0.3683 | 0.365 | 0.365 | 12107200.0 |
| 2001-03-09 09:45:00 | AAPL | Stock | 0.365 | 0.3661 | 0.3627 | 0.365 | 6456800.0 |
| 2001-03-09 09:50:00 | AAPL | Stock | 0.3638 | 0.365 | 0.3627 | 0.3638 | 11440800.0 |
| 2001-03-09 09:55:00 | AAPL | Stock | 0.3627 | 0.3638 | 0.3616 | 0.3627 | 5219200.0 |
| 2001-03-09 10:00:00 | AAPL | Stock | 0.3616 | 0.3627 | 0.3616 | 0.3616 | 8377600.0 |
| 2001-03-09 10:05:00 | AAPL | Stock | 0.3616 | 0.3627 | 0.3605 | 0.3605 | 6664000.0 |
| 2001-03-09 10:10:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3594 | 0.3599 | 3634400.0 |
| 2001-03-09 10:15:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3594 | 0.3594 | 7599200.0 |
| 2001-03-09 10:20:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3571 | 0.3594 | 4575200.0 |
| 2001-03-09 10:25:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3583 | 0.3605 | 4905600.0 |
| 2001-03-09 10:30:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3594 | 0.3605 | 1260000.0 |
| 2001-03-09 10:35:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3583 | 0.3583 | 8383200.0 |
| 2001-03-09 10:40:00 | AAPL | Stock | 0.3583 | 0.3605 | 0.3571 | 0.3605 | 2172800.0 |
| 2001-03-09 10:45:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3594 | 0.3605 | 2576000.0 |
| 2001-03-09 10:50:00 | AAPL | Stock | 0.3605 | 0.3638 | 0.3605 | 0.3605 | 4984000.0 |
| 2001-03-09 10:55:00 | AAPL | Stock | 0.3616 | 0.3638 | 0.3605 | 0.3638 | 11872000.0 |
| 2001-03-09 11:00:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3627 | 0.3627 | 5812800.0 |
| 2001-03-09 11:05:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3605 | 0.3605 | 4009600.0 |
| 2001-03-09 11:10:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3594 | 0.3605 | 8019200.0 |
| 2001-03-09 11:15:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3583 | 0.3583 | 1831200.0 |
| 2001-03-09 11:20:00 | AAPL | Stock | 0.3594 | 0.3605 | 0.3583 | 0.3594 | 5213600.0 |
| 2001-03-09 11:25:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3594 | 0.3616 | 3393600.0 |
| 2001-03-09 11:30:00 | AAPL | Stock | 0.3611 | 0.3627 | 0.3605 | 0.3616 | 5028800.0 |
| 2001-03-09 11:35:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3605 | 0.3605 | 929600.0 |
| 2001-03-09 11:40:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3605 | 0.3616 | 1915200.0 |
| 2001-03-09 11:45:00 | AAPL | Stock | 0.3605 | 0.3627 | 0.3605 | 0.3627 | 1411200.0 |
| 2001-03-09 11:50:00 | AAPL | Stock | 0.3627 | 0.3638 | 0.3616 | 0.3638 | 2906400.0 |
| 2001-03-09 11:55:00 | AAPL | Stock | 0.3638 | 0.365 | 0.3616 | 0.3616 | 5863200.0 |
| 2001-03-09 12:00:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3616 | 0.3627 | 1226400.0 |
| 2001-03-09 12:05:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3627 | 0.3638 | 2984800.0 |
| 2001-03-09 12:10:00 | AAPL | Stock | 0.3638 | 0.365 | 0.3638 | 0.365 | 1108800.0 |
| 2001-03-09 12:15:00 | AAPL | Stock | 0.3638 | 0.3638 | 0.3627 | 0.3627 | 1103200.0 |
| 2001-03-09 12:20:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3627 | 0.3627 | 649600.0 |
| 2001-03-09 12:25:00 | AAPL | Stock | 0.3616 | 0.3638 | 0.3616 | 0.3616 | 2693600.0 |
| 2001-03-09 12:30:00 | AAPL | Stock | 0.3638 | 0.3638 | 0.3594 | 0.3594 | 5364800.0 |
| 2001-03-09 12:35:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3594 | 0.3616 | 4726400.0 |
> showing 50 of 99,491 rows — these rows as CSV