PREVIEW / stock_5min / 2002-09-17
file: by_date/stock_5min/2002/2002-09-17.parquet size: 1.8 MB rows: 123,797 symbols: 1,468
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-09-17 08:00:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2616 | 0.2616 | 11200.0 |
| 2002-09-17 08:20:00 | AAPL | Stock | 0.2632 | 0.2638 | 0.2632 | 0.2638 | 39200.0 |
| 2002-09-17 08:25:00 | AAPL | Stock | 0.2643 | 0.2643 | 0.2643 | 0.2643 | 28000.0 |
| 2002-09-17 08:30:00 | AAPL | Stock | 0.2645 | 0.2645 | 0.2645 | 0.2645 | 33600.0 |
| 2002-09-17 08:35:00 | AAPL | Stock | 0.2641 | 0.2646 | 0.2641 | 0.2643 | 56000.0 |
| 2002-09-17 08:40:00 | AAPL | Stock | 0.2645 | 0.2645 | 0.2639 | 0.2639 | 28000.0 |
| 2002-09-17 08:50:00 | AAPL | Stock | 0.2643 | 0.2643 | 0.2643 | 0.2643 | 28000.0 |
| 2002-09-17 09:10:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 67200.0 |
| 2002-09-17 09:15:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 5600.0 |
| 2002-09-17 09:25:00 | AAPL | Stock | 0.2613 | 0.2614 | 0.2604 | 0.2604 | 504000.0 |
| 2002-09-17 09:30:00 | AAPL | Stock | 0.2604 | 0.2629 | 0.2602 | 0.2629 | 7316400.0 |
| 2002-09-17 09:35:00 | AAPL | Stock | 0.2629 | 0.2639 | 0.2625 | 0.2639 | 8051848.0 |
| 2002-09-17 09:40:00 | AAPL | Stock | 0.2639 | 0.2639 | 0.2625 | 0.2627 | 9284408.0 |
| 2002-09-17 09:45:00 | AAPL | Stock | 0.2627 | 0.2643 | 0.2625 | 0.2634 | 9402400.0 |
| 2002-09-17 09:50:00 | AAPL | Stock | 0.2634 | 0.2641 | 0.263 | 0.2638 | 5473552.0 |
| 2002-09-17 09:55:00 | AAPL | Stock | 0.2637 | 0.2652 | 0.2637 | 0.2652 | 5737480.0 |
| 2002-09-17 10:00:00 | AAPL | Stock | 0.2645 | 0.2663 | 0.2645 | 0.2663 | 11600400.0 |
| 2002-09-17 10:05:00 | AAPL | Stock | 0.2663 | 0.2666 | 0.2645 | 0.2652 | 11105136.0 |
| 2002-09-17 10:10:00 | AAPL | Stock | 0.2652 | 0.2654 | 0.2636 | 0.2639 | 12760664.0 |
| 2002-09-17 10:15:00 | AAPL | Stock | 0.2636 | 0.2639 | 0.263 | 0.2636 | 6434400.0 |
| 2002-09-17 10:20:00 | AAPL | Stock | 0.2638 | 0.2639 | 0.2625 | 0.2629 | 8055712.0 |
| 2002-09-17 10:25:00 | AAPL | Stock | 0.2629 | 0.2641 | 0.2627 | 0.263 | 3651368.0 |
| 2002-09-17 10:30:00 | AAPL | Stock | 0.263 | 0.2634 | 0.2621 | 0.2623 | 7626864.0 |
| 2002-09-17 10:35:00 | AAPL | Stock | 0.2627 | 0.2638 | 0.2625 | 0.2638 | 3779440.0 |
| 2002-09-17 10:40:00 | AAPL | Stock | 0.2638 | 0.2642 | 0.2632 | 0.2641 | 2570400.0 |
| 2002-09-17 10:45:00 | AAPL | Stock | 0.2641 | 0.2652 | 0.2641 | 0.2646 | 2382464.0 |
| 2002-09-17 10:50:00 | AAPL | Stock | 0.2645 | 0.2648 | 0.2645 | 0.2645 | 1176504.0 |
| 2002-09-17 10:55:00 | AAPL | Stock | 0.2646 | 0.2657 | 0.2646 | 0.2654 | 7711200.0 |
| 2002-09-17 11:00:00 | AAPL | Stock | 0.2654 | 0.2655 | 0.2652 | 0.2654 | 10612000.0 |
| 2002-09-17 11:05:00 | AAPL | Stock | 0.2654 | 0.2654 | 0.2646 | 0.2652 | 5000800.0 |
| 2002-09-17 11:10:00 | AAPL | Stock | 0.265 | 0.2654 | 0.2648 | 0.2648 | 3644312.0 |
| 2002-09-17 11:15:00 | AAPL | Stock | 0.2648 | 0.2655 | 0.2648 | 0.2654 | 2618000.0 |
| 2002-09-17 11:20:00 | AAPL | Stock | 0.2652 | 0.2655 | 0.2652 | 0.2655 | 2088800.0 |
| 2002-09-17 11:25:00 | AAPL | Stock | 0.2655 | 0.2661 | 0.2654 | 0.2659 | 4278792.0 |
| 2002-09-17 11:30:00 | AAPL | Stock | 0.2661 | 0.2664 | 0.2655 | 0.2659 | 2615200.0 |
| 2002-09-17 11:35:00 | AAPL | Stock | 0.2659 | 0.2661 | 0.2654 | 0.2659 | 1691200.0 |
| 2002-09-17 11:40:00 | AAPL | Stock | 0.2655 | 0.2675 | 0.2655 | 0.2673 | 5806920.0 |
| 2002-09-17 11:45:00 | AAPL | Stock | 0.2671 | 0.2682 | 0.267 | 0.2682 | 6187328.0 |
| 2002-09-17 11:50:00 | AAPL | Stock | 0.2682 | 0.2682 | 0.2673 | 0.2677 | 2020200.0 |
| 2002-09-17 11:55:00 | AAPL | Stock | 0.2675 | 0.2679 | 0.267 | 0.267 | 17578960.0 |
| 2002-09-17 12:00:00 | AAPL | Stock | 0.267 | 0.2671 | 0.2661 | 0.2663 | 3590160.0 |
| 2002-09-17 12:05:00 | AAPL | Stock | 0.2663 | 0.2664 | 0.2661 | 0.2663 | 4311552.0 |
| 2002-09-17 12:10:00 | AAPL | Stock | 0.2663 | 0.2664 | 0.2661 | 0.2661 | 2094400.0 |
| 2002-09-17 12:15:00 | AAPL | Stock | 0.2661 | 0.2668 | 0.2661 | 0.2663 | 3812144.0 |
| 2002-09-17 12:20:00 | AAPL | Stock | 0.2666 | 0.2666 | 0.2657 | 0.2659 | 7683872.0 |
| 2002-09-17 12:25:00 | AAPL | Stock | 0.2661 | 0.2663 | 0.2657 | 0.2657 | 2772000.0 |
| 2002-09-17 12:30:00 | AAPL | Stock | 0.2657 | 0.266 | 0.2652 | 0.2652 | 1528800.0 |
| 2002-09-17 12:35:00 | AAPL | Stock | 0.2655 | 0.266 | 0.2648 | 0.2652 | 4152680.0 |
| 2002-09-17 12:40:00 | AAPL | Stock | 0.2652 | 0.2657 | 0.265 | 0.2652 | 2066400.0 |
| 2002-09-17 12:45:00 | AAPL | Stock | 0.2654 | 0.2655 | 0.2648 | 0.2652 | 3169600.0 |
> showing 50 of 123,797 rows — these rows as CSV