PREVIEW / stock_5min / 2003-03-19
file: by_date/stock_5min/2003/2003-03-19.parquet size: 1.9 MB rows: 136,791 symbols: 1,564
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-19 08:00:00 | AAPL | Stock | 0.2682 | 0.2682 | 0.2682 | 0.2682 | 123200.0 |
| 2003-03-19 08:05:00 | AAPL | Stock | 0.2682 | 0.2682 | 0.2682 | 0.2682 | 128800.0 |
| 2003-03-19 08:10:00 | AAPL | Stock | 0.268 | 0.268 | 0.268 | 0.268 | 162400.0 |
| 2003-03-19 08:15:00 | AAPL | Stock | 0.268 | 0.268 | 0.268 | 0.268 | 61600.0 |
| 2003-03-19 08:20:00 | AAPL | Stock | 0.268 | 0.268 | 0.268 | 0.268 | 61600.0 |
| 2003-03-19 08:25:00 | AAPL | Stock | 0.268 | 0.268 | 0.268 | 0.268 | 72800.0 |
| 2003-03-19 08:40:00 | AAPL | Stock | 0.2691 | 0.2691 | 0.2691 | 0.2691 | 44800.0 |
| 2003-03-19 09:10:00 | AAPL | Stock | 0.2688 | 0.2688 | 0.2688 | 0.2688 | 72800.0 |
| 2003-03-19 09:15:00 | AAPL | Stock | 0.2684 | 0.2689 | 0.2683 | 0.2689 | 207200.0 |
| 2003-03-19 09:20:00 | AAPL | Stock | 0.2686 | 0.2686 | 0.2686 | 0.2686 | 156800.0 |
| 2003-03-19 09:25:00 | AAPL | Stock | 0.2686 | 0.2686 | 0.2682 | 0.2686 | 89600.0 |
| 2003-03-19 09:30:00 | AAPL | Stock | 0.2691 | 0.2705 | 0.2677 | 0.2704 | 9570848.0 |
| 2003-03-19 09:35:00 | AAPL | Stock | 0.2696 | 0.2705 | 0.267 | 0.2686 | 4360720.0 |
| 2003-03-19 09:40:00 | AAPL | Stock | 0.2688 | 0.2696 | 0.268 | 0.2688 | 1957200.0 |
| 2003-03-19 09:45:00 | AAPL | Stock | 0.2686 | 0.2691 | 0.2682 | 0.2684 | 3361568.0 |
| 2003-03-19 09:50:00 | AAPL | Stock | 0.2682 | 0.2686 | 0.2677 | 0.2686 | 2886968.0 |
| 2003-03-19 09:55:00 | AAPL | Stock | 0.2686 | 0.2688 | 0.2679 | 0.2688 | 1806448.0 |
| 2003-03-19 10:00:00 | AAPL | Stock | 0.2686 | 0.2691 | 0.2684 | 0.2688 | 2347912.0 |
| 2003-03-19 10:05:00 | AAPL | Stock | 0.2688 | 0.2694 | 0.2686 | 0.2691 | 1778112.0 |
| 2003-03-19 10:10:00 | AAPL | Stock | 0.2691 | 0.2691 | 0.2684 | 0.2686 | 1428000.0 |
| 2003-03-19 10:15:00 | AAPL | Stock | 0.2688 | 0.2688 | 0.2679 | 0.2682 | 1708000.0 |
| 2003-03-19 10:20:00 | AAPL | Stock | 0.2682 | 0.2689 | 0.2679 | 0.2682 | 1758400.0 |
| 2003-03-19 10:25:00 | AAPL | Stock | 0.2684 | 0.2695 | 0.268 | 0.2693 | 2353400.0 |
| 2003-03-19 10:30:00 | AAPL | Stock | 0.2693 | 0.2698 | 0.2691 | 0.2693 | 2248344.0 |
| 2003-03-19 10:35:00 | AAPL | Stock | 0.2695 | 0.2695 | 0.268 | 0.2682 | 2382352.0 |
| 2003-03-19 10:40:00 | AAPL | Stock | 0.268 | 0.2684 | 0.2677 | 0.2682 | 1749888.0 |
| 2003-03-19 10:45:00 | AAPL | Stock | 0.2682 | 0.2688 | 0.2679 | 0.268 | 1803760.0 |
| 2003-03-19 10:50:00 | AAPL | Stock | 0.2679 | 0.268 | 0.2677 | 0.2679 | 1596000.0 |
| 2003-03-19 10:55:00 | AAPL | Stock | 0.2679 | 0.268 | 0.2677 | 0.2677 | 324800.0 |
| 2003-03-19 11:00:00 | AAPL | Stock | 0.2677 | 0.2677 | 0.2663 | 0.2663 | 2541896.0 |
| 2003-03-19 11:05:00 | AAPL | Stock | 0.2664 | 0.2666 | 0.2663 | 0.2664 | 1458800.0 |
| 2003-03-19 11:10:00 | AAPL | Stock | 0.2664 | 0.2664 | 0.2652 | 0.2652 | 2266600.0 |
| 2003-03-19 11:15:00 | AAPL | Stock | 0.2652 | 0.2657 | 0.2644 | 0.2657 | 2168152.0 |
| 2003-03-19 11:20:00 | AAPL | Stock | 0.2657 | 0.2659 | 0.2654 | 0.2657 | 268800.0 |
| 2003-03-19 11:25:00 | AAPL | Stock | 0.2657 | 0.2661 | 0.2657 | 0.2661 | 2148776.0 |
| 2003-03-19 11:30:00 | AAPL | Stock | 0.2661 | 0.2661 | 0.2657 | 0.2657 | 815976.0 |
| 2003-03-19 11:35:00 | AAPL | Stock | 0.2655 | 0.2659 | 0.2648 | 0.2648 | 2279704.0 |
| 2003-03-19 11:40:00 | AAPL | Stock | 0.2648 | 0.2652 | 0.2641 | 0.2651 | 2084656.0 |
| 2003-03-19 11:45:00 | AAPL | Stock | 0.265 | 0.2652 | 0.2646 | 0.2652 | 1174152.0 |
| 2003-03-19 11:50:00 | AAPL | Stock | 0.265 | 0.2652 | 0.265 | 0.265 | 320712.0 |
| 2003-03-19 11:55:00 | AAPL | Stock | 0.2648 | 0.2648 | 0.2643 | 0.2645 | 1736280.0 |
| 2003-03-19 12:00:00 | AAPL | Stock | 0.2646 | 0.2654 | 0.2645 | 0.2654 | 767200.0 |
| 2003-03-19 12:05:00 | AAPL | Stock | 0.2654 | 0.2659 | 0.2652 | 0.2657 | 1276800.0 |
| 2003-03-19 12:10:00 | AAPL | Stock | 0.2655 | 0.2655 | 0.2646 | 0.265 | 880040.0 |
| 2003-03-19 12:15:00 | AAPL | Stock | 0.2648 | 0.2654 | 0.2648 | 0.2654 | 246120.0 |
| 2003-03-19 12:20:00 | AAPL | Stock | 0.2654 | 0.2654 | 0.2652 | 0.2654 | 779016.0 |
| 2003-03-19 12:25:00 | AAPL | Stock | 0.2654 | 0.2668 | 0.2654 | 0.2668 | 1917328.0 |
| 2003-03-19 12:30:00 | AAPL | Stock | 0.2666 | 0.2668 | 0.2659 | 0.2659 | 728560.0 |
| 2003-03-19 12:35:00 | AAPL | Stock | 0.2662 | 0.2668 | 0.2661 | 0.2664 | 782096.0 |
| 2003-03-19 12:40:00 | AAPL | Stock | 0.2666 | 0.2671 | 0.2666 | 0.267 | 733488.0 |
> showing 50 of 136,791 rows — these rows as CSV