PREVIEW / stock_5min / 2005-05-18
file: by_date/stock_5min/2005/2005-05-18.parquet size: 2.8 MB rows: 200,816 symbols: 1,986
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-18 08:00:00 | AAPL | Stock | 1.2607 | 1.2625 | 1.2596 | 1.2607 | 290920.0 |
| 2005-05-18 08:05:00 | AAPL | Stock | 1.2607 | 1.2607 | 1.2604 | 1.2604 | 14000.0 |
| 2005-05-18 08:10:00 | AAPL | Stock | 1.2596 | 1.2607 | 1.2596 | 1.26 | 84000.0 |
| 2005-05-18 08:15:00 | AAPL | Stock | 1.2607 | 1.2607 | 1.2607 | 1.2607 | 28000.0 |
| 2005-05-18 08:25:00 | AAPL | Stock | 1.2625 | 1.2625 | 1.2625 | 1.2625 | 47600.0 |
| 2005-05-18 08:30:00 | AAPL | Stock | 1.2657 | 1.2696 | 1.2657 | 1.2661 | 204400.0 |
| 2005-05-18 08:35:00 | AAPL | Stock | 1.2661 | 1.2686 | 1.2661 | 1.2686 | 75600.0 |
| 2005-05-18 08:40:00 | AAPL | Stock | 1.2686 | 1.2707 | 1.2686 | 1.2689 | 490000.0 |
| 2005-05-18 08:45:00 | AAPL | Stock | 1.2689 | 1.2689 | 1.2689 | 1.2689 | 22400.0 |
| 2005-05-18 08:50:00 | AAPL | Stock | 1.2689 | 1.2689 | 1.2679 | 1.2679 | 98000.0 |
| 2005-05-18 08:55:00 | AAPL | Stock | 1.2686 | 1.2686 | 1.2682 | 1.2682 | 25200.0 |
| 2005-05-18 09:00:00 | AAPL | Stock | 1.2689 | 1.2689 | 1.2682 | 1.2689 | 100800.0 |
| 2005-05-18 09:05:00 | AAPL | Stock | 1.2689 | 1.2693 | 1.2686 | 1.2693 | 189280.0 |
| 2005-05-18 09:10:00 | AAPL | Stock | 1.2693 | 1.2696 | 1.2661 | 1.2696 | 288400.0 |
| 2005-05-18 09:15:00 | AAPL | Stock | 1.2693 | 1.2714 | 1.2679 | 1.2696 | 1515360.0 |
| 2005-05-18 09:20:00 | AAPL | Stock | 1.2696 | 1.2696 | 1.2693 | 1.2693 | 38080.0 |
| 2005-05-18 09:25:00 | AAPL | Stock | 1.2679 | 1.2704 | 1.2661 | 1.2664 | 886172.0 |
| 2005-05-18 09:30:00 | AAPL | Stock | 1.2661 | 1.2679 | 1.2632 | 1.2643 | 15883280.0 |
| 2005-05-18 09:35:00 | AAPL | Stock | 1.2643 | 1.2661 | 1.2557 | 1.2579 | 19898228.0 |
| 2005-05-18 09:40:00 | AAPL | Stock | 1.2582 | 1.2679 | 1.2554 | 1.2607 | 13859048.0 |
| 2005-05-18 09:45:00 | AAPL | Stock | 1.2604 | 1.2621 | 1.2511 | 1.2518 | 14856212.0 |
| 2005-05-18 09:50:00 | AAPL | Stock | 1.2521 | 1.2575 | 1.2496 | 1.2571 | 21826980.0 |
| 2005-05-18 09:55:00 | AAPL | Stock | 1.2571 | 1.2575 | 1.2543 | 1.2568 | 7977172.0 |
| 2005-05-18 10:00:00 | AAPL | Stock | 1.2568 | 1.2575 | 1.2539 | 1.2566 | 15101968.0 |
| 2005-05-18 10:05:00 | AAPL | Stock | 1.2564 | 1.2621 | 1.2554 | 1.2621 | 11365144.0 |
| 2005-05-18 10:10:00 | AAPL | Stock | 1.2621 | 1.2661 | 1.2604 | 1.2618 | 11246564.0 |
| 2005-05-18 10:15:00 | AAPL | Stock | 1.2621 | 1.2625 | 1.2561 | 1.2586 | 9273628.0 |
| 2005-05-18 10:20:00 | AAPL | Stock | 1.2586 | 1.2589 | 1.255 | 1.2557 | 5871152.0 |
| 2005-05-18 10:25:00 | AAPL | Stock | 1.2561 | 1.2614 | 1.2561 | 1.2586 | 8257144.0 |
| 2005-05-18 10:30:00 | AAPL | Stock | 1.2586 | 1.2625 | 1.2568 | 1.2625 | 11206748.0 |
| 2005-05-18 10:35:00 | AAPL | Stock | 1.2629 | 1.2629 | 1.2589 | 1.2593 | 4602612.0 |
| 2005-05-18 10:40:00 | AAPL | Stock | 1.2593 | 1.2604 | 1.2582 | 1.2596 | 5383532.0 |
| 2005-05-18 10:45:00 | AAPL | Stock | 1.2596 | 1.2596 | 1.2536 | 1.2557 | 9620828.0 |
| 2005-05-18 10:50:00 | AAPL | Stock | 1.2554 | 1.2589 | 1.2554 | 1.2568 | 4879476.0 |
| 2005-05-18 10:55:00 | AAPL | Stock | 1.2568 | 1.2593 | 1.2564 | 1.2582 | 3649268.0 |
| 2005-05-18 11:00:00 | AAPL | Stock | 1.2582 | 1.2589 | 1.2568 | 1.2582 | 4031216.0 |
| 2005-05-18 11:05:00 | AAPL | Stock | 1.2586 | 1.2621 | 1.2582 | 1.2618 | 6999020.0 |
| 2005-05-18 11:10:00 | AAPL | Stock | 1.2621 | 1.2629 | 1.2589 | 1.2596 | 3957016.0 |
| 2005-05-18 11:15:00 | AAPL | Stock | 1.26 | 1.2671 | 1.2596 | 1.2661 | 9971472.0 |
| 2005-05-18 11:20:00 | AAPL | Stock | 1.2661 | 1.2675 | 1.2632 | 1.2654 | 8360324.0 |
| 2005-05-18 11:25:00 | AAPL | Stock | 1.2657 | 1.2664 | 1.2629 | 1.2654 | 3159016.0 |
| 2005-05-18 11:30:00 | AAPL | Stock | 1.265 | 1.2661 | 1.2643 | 1.2661 | 4238864.0 |
| 2005-05-18 11:35:00 | AAPL | Stock | 1.2661 | 1.2664 | 1.2646 | 1.265 | 2738932.0 |
| 2005-05-18 11:40:00 | AAPL | Stock | 1.2646 | 1.2646 | 1.2607 | 1.2632 | 4968964.0 |
| 2005-05-18 11:45:00 | AAPL | Stock | 1.2632 | 1.2639 | 1.2611 | 1.2632 | 2077460.0 |
| 2005-05-18 11:50:00 | AAPL | Stock | 1.2632 | 1.2675 | 1.2629 | 1.2671 | 5705196.0 |
| 2005-05-18 11:55:00 | AAPL | Stock | 1.2671 | 1.2671 | 1.2636 | 1.2643 | 4023292.0 |
| 2005-05-18 12:00:00 | AAPL | Stock | 1.2639 | 1.2675 | 1.2636 | 1.2664 | 5049744.0 |
| 2005-05-18 12:05:00 | AAPL | Stock | 1.2664 | 1.2682 | 1.2654 | 1.2671 | 5975732.0 |
| 2005-05-18 12:10:00 | AAPL | Stock | 1.2675 | 1.2707 | 1.2625 | 1.2693 | 11727100.0 |
> showing 50 of 200,816 rows — these rows as CSV