PREVIEW / stock_5min / 2002-07-24
file: by_date/stock_5min/2002/2002-07-24.parquet size: 2.0 MB rows: 137,656 symbols: 1,465
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-24 09:30:00 | AAPL | Stock | 0.2559 | 0.2589 | 0.2545 | 0.2571 | 10392088.0 |
| 2002-07-24 09:35:00 | AAPL | Stock | 0.2571 | 0.2589 | 0.2556 | 0.2579 | 7175560.0 |
| 2002-07-24 09:40:00 | AAPL | Stock | 0.2577 | 0.2632 | 0.257 | 0.2616 | 7789600.0 |
| 2002-07-24 09:45:00 | AAPL | Stock | 0.262 | 0.2654 | 0.2609 | 0.2636 | 7387296.0 |
| 2002-07-24 09:50:00 | AAPL | Stock | 0.2645 | 0.2645 | 0.2575 | 0.2577 | 13227928.0 |
| 2002-07-24 09:55:00 | AAPL | Stock | 0.258 | 0.2595 | 0.2557 | 0.258 | 5913880.0 |
| 2002-07-24 10:00:00 | AAPL | Stock | 0.2582 | 0.2614 | 0.2573 | 0.2614 | 7698712.0 |
| 2002-07-24 10:05:00 | AAPL | Stock | 0.2616 | 0.2638 | 0.2605 | 0.2615 | 5656000.0 |
| 2002-07-24 10:10:00 | AAPL | Stock | 0.2609 | 0.2613 | 0.2589 | 0.2605 | 3878560.0 |
| 2002-07-24 10:15:00 | AAPL | Stock | 0.2605 | 0.2623 | 0.2596 | 0.2609 | 3231200.0 |
| 2002-07-24 10:20:00 | AAPL | Stock | 0.2609 | 0.2618 | 0.2598 | 0.26 | 3601920.0 |
| 2002-07-24 10:25:00 | AAPL | Stock | 0.26 | 0.2648 | 0.26 | 0.2641 | 5403664.0 |
| 2002-07-24 10:30:00 | AAPL | Stock | 0.2643 | 0.2677 | 0.2638 | 0.2666 | 8185352.0 |
| 2002-07-24 10:35:00 | AAPL | Stock | 0.2666 | 0.2668 | 0.2634 | 0.2634 | 2498496.0 |
| 2002-07-24 10:40:00 | AAPL | Stock | 0.2634 | 0.267 | 0.2634 | 0.2662 | 6414800.0 |
| 2002-07-24 10:45:00 | AAPL | Stock | 0.2657 | 0.2666 | 0.2648 | 0.2652 | 2712864.0 |
| 2002-07-24 10:50:00 | AAPL | Stock | 0.2652 | 0.2663 | 0.2632 | 0.2634 | 2604952.0 |
| 2002-07-24 10:55:00 | AAPL | Stock | 0.2636 | 0.2645 | 0.2616 | 0.262 | 3032400.0 |
| 2002-07-24 11:00:00 | AAPL | Stock | 0.2621 | 0.2638 | 0.2582 | 0.2586 | 4135264.0 |
| 2002-07-24 11:05:00 | AAPL | Stock | 0.2586 | 0.2598 | 0.2584 | 0.2597 | 2479960.0 |
| 2002-07-24 11:10:00 | AAPL | Stock | 0.2593 | 0.2616 | 0.2591 | 0.26 | 2224544.0 |
| 2002-07-24 11:15:00 | AAPL | Stock | 0.2602 | 0.2629 | 0.2602 | 0.2605 | 2738400.0 |
| 2002-07-24 11:20:00 | AAPL | Stock | 0.2607 | 0.2638 | 0.2595 | 0.2636 | 3017112.0 |
| 2002-07-24 11:25:00 | AAPL | Stock | 0.2625 | 0.2661 | 0.2625 | 0.2645 | 4261152.0 |
| 2002-07-24 11:30:00 | AAPL | Stock | 0.2643 | 0.2668 | 0.2641 | 0.2666 | 6138328.0 |
| 2002-07-24 11:35:00 | AAPL | Stock | 0.2666 | 0.2668 | 0.2643 | 0.2648 | 5873000.0 |
| 2002-07-24 11:40:00 | AAPL | Stock | 0.2645 | 0.2661 | 0.262 | 0.262 | 3429104.0 |
| 2002-07-24 11:45:00 | AAPL | Stock | 0.262 | 0.2632 | 0.2616 | 0.2632 | 2072000.0 |
| 2002-07-24 11:50:00 | AAPL | Stock | 0.2636 | 0.2661 | 0.2634 | 0.2657 | 3164000.0 |
| 2002-07-24 11:55:00 | AAPL | Stock | 0.2661 | 0.2666 | 0.2636 | 0.2638 | 6468000.0 |
| 2002-07-24 12:00:00 | AAPL | Stock | 0.2638 | 0.2666 | 0.2636 | 0.2655 | 4341232.0 |
| 2002-07-24 12:05:00 | AAPL | Stock | 0.2661 | 0.2664 | 0.2646 | 0.2647 | 3584000.0 |
| 2002-07-24 12:10:00 | AAPL | Stock | 0.2652 | 0.2667 | 0.263 | 0.2638 | 8714384.0 |
| 2002-07-24 12:15:00 | AAPL | Stock | 0.2638 | 0.2643 | 0.2629 | 0.2639 | 2206400.0 |
| 2002-07-24 12:20:00 | AAPL | Stock | 0.2639 | 0.2645 | 0.262 | 0.2638 | 4177600.0 |
| 2002-07-24 12:25:00 | AAPL | Stock | 0.2639 | 0.2655 | 0.2629 | 0.2634 | 3703280.0 |
| 2002-07-24 12:30:00 | AAPL | Stock | 0.2636 | 0.2643 | 0.262 | 0.262 | 7548968.0 |
| 2002-07-24 12:35:00 | AAPL | Stock | 0.262 | 0.2634 | 0.2616 | 0.2623 | 4939536.0 |
| 2002-07-24 12:40:00 | AAPL | Stock | 0.262 | 0.2648 | 0.262 | 0.2638 | 2326464.0 |
| 2002-07-24 12:45:00 | AAPL | Stock | 0.2639 | 0.2647 | 0.2621 | 0.2632 | 3225600.0 |
| 2002-07-24 12:50:00 | AAPL | Stock | 0.263 | 0.2646 | 0.2621 | 0.2645 | 8274560.0 |
| 2002-07-24 12:55:00 | AAPL | Stock | 0.2643 | 0.2654 | 0.263 | 0.2643 | 1690640.0 |
| 2002-07-24 13:00:00 | AAPL | Stock | 0.2645 | 0.2655 | 0.2629 | 0.2639 | 1194760.0 |
| 2002-07-24 13:05:00 | AAPL | Stock | 0.2639 | 0.2655 | 0.2639 | 0.2646 | 7054320.0 |
| 2002-07-24 13:10:00 | AAPL | Stock | 0.2646 | 0.2655 | 0.263 | 0.263 | 2064160.0 |
| 2002-07-24 13:15:00 | AAPL | Stock | 0.263 | 0.2636 | 0.2613 | 0.2627 | 6403600.0 |
| 2002-07-24 13:20:00 | AAPL | Stock | 0.2625 | 0.2629 | 0.2616 | 0.2623 | 921984.0 |
| 2002-07-24 13:25:00 | AAPL | Stock | 0.2623 | 0.2646 | 0.2613 | 0.2629 | 9198840.0 |
| 2002-07-24 13:30:00 | AAPL | Stock | 0.2627 | 0.2643 | 0.2625 | 0.2636 | 1361920.0 |
| 2002-07-24 13:35:00 | AAPL | Stock | 0.2636 | 0.2661 | 0.2636 | 0.2648 | 3485104.0 |
> showing 50 of 137,656 rows — these rows as CSV