PREVIEW / stock_5min / 2002-07-19
file: by_date/stock_5min/2002/2002-07-19.parquet size: 1.9 MB rows: 131,335 symbols: 1,452
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-19 08:00:00 | AAPL | Stock | 0.2675 | 0.2675 | 0.2675 | 0.2675 | 5600.0 |
| 2002-07-19 08:05:00 | AAPL | Stock | 0.2645 | 0.2646 | 0.2634 | 0.2634 | 50400.0 |
| 2002-07-19 08:20:00 | AAPL | Stock | 0.2636 | 0.2652 | 0.2636 | 0.2652 | 61600.0 |
| 2002-07-19 08:25:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 5600.0 |
| 2002-07-19 08:35:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 11200.0 |
| 2002-07-19 08:45:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 28000.0 |
| 2002-07-19 08:50:00 | AAPL | Stock | 0.2632 | 0.2632 | 0.2632 | 0.2632 | 5600.0 |
| 2002-07-19 08:55:00 | AAPL | Stock | 0.2632 | 0.2632 | 0.2632 | 0.2632 | 5600.0 |
| 2002-07-19 09:00:00 | AAPL | Stock | 0.2629 | 0.2632 | 0.2629 | 0.2632 | 28000.0 |
| 2002-07-19 09:10:00 | AAPL | Stock | 0.2629 | 0.2629 | 0.2629 | 0.2629 | 5600.0 |
| 2002-07-19 09:15:00 | AAPL | Stock | 0.2632 | 0.2632 | 0.2632 | 0.2632 | 44800.0 |
| 2002-07-19 09:20:00 | AAPL | Stock | 0.2625 | 0.2625 | 0.2625 | 0.2625 | 448000.0 |
| 2002-07-19 09:25:00 | AAPL | Stock | 0.2629 | 0.2629 | 0.2627 | 0.2627 | 380800.0 |
| 2002-07-19 09:30:00 | AAPL | Stock | 0.2625 | 0.263 | 0.2595 | 0.2627 | 22450400.0 |
| 2002-07-19 09:35:00 | AAPL | Stock | 0.2627 | 0.2645 | 0.2616 | 0.2645 | 7100800.0 |
| 2002-07-19 09:40:00 | AAPL | Stock | 0.2645 | 0.2663 | 0.2625 | 0.2638 | 9178400.0 |
| 2002-07-19 09:45:00 | AAPL | Stock | 0.2638 | 0.2646 | 0.2627 | 0.2627 | 5706400.0 |
| 2002-07-19 09:50:00 | AAPL | Stock | 0.2627 | 0.2634 | 0.2611 | 0.2625 | 6322400.0 |
| 2002-07-19 09:55:00 | AAPL | Stock | 0.262 | 0.2655 | 0.262 | 0.2643 | 12577600.0 |
| 2002-07-19 10:00:00 | AAPL | Stock | 0.2643 | 0.2664 | 0.2634 | 0.2661 | 15153600.0 |
| 2002-07-19 10:05:00 | AAPL | Stock | 0.2664 | 0.2707 | 0.2652 | 0.2707 | 12594400.0 |
| 2002-07-19 10:10:00 | AAPL | Stock | 0.2707 | 0.2709 | 0.2671 | 0.2679 | 5555200.0 |
| 2002-07-19 10:15:00 | AAPL | Stock | 0.2686 | 0.2695 | 0.2671 | 0.2677 | 3096800.0 |
| 2002-07-19 10:20:00 | AAPL | Stock | 0.2679 | 0.268 | 0.267 | 0.2678 | 3628800.0 |
| 2002-07-19 10:25:00 | AAPL | Stock | 0.2677 | 0.2679 | 0.2654 | 0.2654 | 3925600.0 |
| 2002-07-19 10:30:00 | AAPL | Stock | 0.2656 | 0.267 | 0.2654 | 0.2657 | 8349600.0 |
| 2002-07-19 10:35:00 | AAPL | Stock | 0.2655 | 0.2657 | 0.2643 | 0.2655 | 2788800.0 |
| 2002-07-19 10:40:00 | AAPL | Stock | 0.2655 | 0.268 | 0.2652 | 0.2679 | 2044000.0 |
| 2002-07-19 10:45:00 | AAPL | Stock | 0.2679 | 0.2686 | 0.2661 | 0.267 | 3141600.0 |
| 2002-07-19 10:50:00 | AAPL | Stock | 0.2675 | 0.2682 | 0.2661 | 0.2682 | 996800.0 |
| 2002-07-19 10:55:00 | AAPL | Stock | 0.2681 | 0.2695 | 0.2664 | 0.2666 | 2357600.0 |
| 2002-07-19 11:00:00 | AAPL | Stock | 0.2661 | 0.2668 | 0.2652 | 0.2659 | 2290400.0 |
| 2002-07-19 11:05:00 | AAPL | Stock | 0.2663 | 0.2684 | 0.2654 | 0.268 | 2654400.0 |
| 2002-07-19 11:10:00 | AAPL | Stock | 0.2684 | 0.2693 | 0.2675 | 0.2689 | 2626400.0 |
| 2002-07-19 11:15:00 | AAPL | Stock | 0.2684 | 0.2688 | 0.2679 | 0.2679 | 963200.0 |
| 2002-07-19 11:20:00 | AAPL | Stock | 0.2682 | 0.2684 | 0.2679 | 0.2679 | 7162400.0 |
| 2002-07-19 11:25:00 | AAPL | Stock | 0.268 | 0.2686 | 0.2666 | 0.2686 | 1780800.0 |
| 2002-07-19 11:30:00 | AAPL | Stock | 0.2686 | 0.2686 | 0.2671 | 0.2673 | 1344000.0 |
| 2002-07-19 11:35:00 | AAPL | Stock | 0.2675 | 0.2679 | 0.2671 | 0.2675 | 1926400.0 |
| 2002-07-19 11:40:00 | AAPL | Stock | 0.2677 | 0.2679 | 0.267 | 0.2671 | 1248800.0 |
| 2002-07-19 11:45:00 | AAPL | Stock | 0.2671 | 0.2677 | 0.2668 | 0.267 | 3690400.0 |
| 2002-07-19 11:50:00 | AAPL | Stock | 0.2672 | 0.2677 | 0.2671 | 0.2675 | 548800.0 |
| 2002-07-19 11:55:00 | AAPL | Stock | 0.2677 | 0.268 | 0.2673 | 0.2677 | 1097600.0 |
| 2002-07-19 12:00:00 | AAPL | Stock | 0.2677 | 0.2689 | 0.267 | 0.2689 | 3925600.0 |
| 2002-07-19 12:05:00 | AAPL | Stock | 0.2689 | 0.2695 | 0.2677 | 0.268 | 3500000.0 |
| 2002-07-19 12:10:00 | AAPL | Stock | 0.2686 | 0.2693 | 0.2684 | 0.2693 | 3466400.0 |
| 2002-07-19 12:15:00 | AAPL | Stock | 0.2693 | 0.2695 | 0.2684 | 0.2686 | 1192800.0 |
| 2002-07-19 12:20:00 | AAPL | Stock | 0.2688 | 0.2688 | 0.2679 | 0.2682 | 2592800.0 |
| 2002-07-19 12:25:00 | AAPL | Stock | 0.2679 | 0.268 | 0.2671 | 0.2671 | 4524800.0 |
| 2002-07-19 12:30:00 | AAPL | Stock | 0.2671 | 0.268 | 0.2668 | 0.267 | 7190400.0 |
> showing 50 of 131,335 rows — these rows as CSV