PREVIEW / stock_5min / 2002-11-20
file: by_date/stock_5min/2002/2002-11-20.parquet size: 1.9 MB rows: 134,369 symbols: 1,514
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-11-20 08:30:00 | AAPL | Stock | 0.2732 | 0.2732 | 0.2732 | 0.2732 | 11200.0 |
| 2002-11-20 08:50:00 | AAPL | Stock | 0.2732 | 0.2732 | 0.273 | 0.273 | 22400.0 |
| 2002-11-20 09:05:00 | AAPL | Stock | 0.273 | 0.2732 | 0.273 | 0.2732 | 89600.0 |
| 2002-11-20 09:10:00 | AAPL | Stock | 0.2732 | 0.2732 | 0.2732 | 0.2732 | 56000.0 |
| 2002-11-20 09:25:00 | AAPL | Stock | 0.2732 | 0.2732 | 0.2732 | 0.2732 | 123200.0 |
| 2002-11-20 09:30:00 | AAPL | Stock | 0.2732 | 0.275 | 0.2732 | 0.2741 | 3164000.0 |
| 2002-11-20 09:35:00 | AAPL | Stock | 0.2736 | 0.2757 | 0.2729 | 0.2736 | 3082912.0 |
| 2002-11-20 09:40:00 | AAPL | Stock | 0.2732 | 0.2748 | 0.2732 | 0.2734 | 1433600.0 |
| 2002-11-20 09:45:00 | AAPL | Stock | 0.2734 | 0.2743 | 0.2723 | 0.2736 | 1377600.0 |
| 2002-11-20 09:50:00 | AAPL | Stock | 0.2736 | 0.2764 | 0.2736 | 0.2759 | 2047472.0 |
| 2002-11-20 09:55:00 | AAPL | Stock | 0.2759 | 0.2762 | 0.273 | 0.2736 | 1663200.0 |
| 2002-11-20 10:00:00 | AAPL | Stock | 0.2738 | 0.2745 | 0.273 | 0.2738 | 3970400.0 |
| 2002-11-20 10:05:00 | AAPL | Stock | 0.2738 | 0.2746 | 0.2738 | 0.2746 | 3096800.0 |
| 2002-11-20 10:10:00 | AAPL | Stock | 0.2743 | 0.2748 | 0.2743 | 0.2743 | 2103304.0 |
| 2002-11-20 10:15:00 | AAPL | Stock | 0.2748 | 0.275 | 0.2741 | 0.2746 | 2217600.0 |
| 2002-11-20 10:20:00 | AAPL | Stock | 0.2746 | 0.2748 | 0.2739 | 0.2748 | 932400.0 |
| 2002-11-20 10:25:00 | AAPL | Stock | 0.2748 | 0.2754 | 0.2746 | 0.2754 | 3192000.0 |
| 2002-11-20 10:30:00 | AAPL | Stock | 0.2754 | 0.2761 | 0.2752 | 0.2754 | 2258200.0 |
| 2002-11-20 10:35:00 | AAPL | Stock | 0.2754 | 0.2763 | 0.2754 | 0.2761 | 1892800.0 |
| 2002-11-20 10:40:00 | AAPL | Stock | 0.2761 | 0.2766 | 0.2755 | 0.2759 | 3130400.0 |
| 2002-11-20 10:45:00 | AAPL | Stock | 0.2761 | 0.2761 | 0.2754 | 0.2757 | 4606840.0 |
| 2002-11-20 10:50:00 | AAPL | Stock | 0.2757 | 0.2768 | 0.2755 | 0.2761 | 2536800.0 |
| 2002-11-20 10:55:00 | AAPL | Stock | 0.2759 | 0.2766 | 0.2759 | 0.2766 | 1920800.0 |
| 2002-11-20 11:00:00 | AAPL | Stock | 0.2766 | 0.2777 | 0.2759 | 0.2761 | 2941904.0 |
| 2002-11-20 11:05:00 | AAPL | Stock | 0.2764 | 0.2766 | 0.2759 | 0.2761 | 973504.0 |
| 2002-11-20 11:10:00 | AAPL | Stock | 0.2761 | 0.2766 | 0.2759 | 0.2763 | 1758400.0 |
| 2002-11-20 11:15:00 | AAPL | Stock | 0.2763 | 0.2764 | 0.2761 | 0.2763 | 918400.0 |
| 2002-11-20 11:20:00 | AAPL | Stock | 0.2763 | 0.2764 | 0.2759 | 0.2759 | 845600.0 |
| 2002-11-20 11:25:00 | AAPL | Stock | 0.2761 | 0.2764 | 0.2759 | 0.2764 | 851200.0 |
| 2002-11-20 11:30:00 | AAPL | Stock | 0.2766 | 0.2766 | 0.2763 | 0.2763 | 865200.0 |
| 2002-11-20 11:35:00 | AAPL | Stock | 0.2763 | 0.2766 | 0.2763 | 0.2766 | 225120.0 |
| 2002-11-20 11:40:00 | AAPL | Stock | 0.2766 | 0.2777 | 0.2764 | 0.2768 | 2520000.0 |
| 2002-11-20 11:45:00 | AAPL | Stock | 0.277 | 0.2773 | 0.2766 | 0.2766 | 1282400.0 |
| 2002-11-20 11:50:00 | AAPL | Stock | 0.2768 | 0.2768 | 0.2766 | 0.2766 | 1796984.0 |
| 2002-11-20 11:55:00 | AAPL | Stock | 0.2766 | 0.277 | 0.2763 | 0.2766 | 1114400.0 |
| 2002-11-20 12:00:00 | AAPL | Stock | 0.2766 | 0.277 | 0.2766 | 0.277 | 2441600.0 |
| 2002-11-20 12:05:00 | AAPL | Stock | 0.277 | 0.2775 | 0.2764 | 0.277 | 2307816.0 |
| 2002-11-20 12:10:00 | AAPL | Stock | 0.2768 | 0.2773 | 0.2768 | 0.2773 | 235200.0 |
| 2002-11-20 12:15:00 | AAPL | Stock | 0.2775 | 0.2775 | 0.2764 | 0.2773 | 2808288.0 |
| 2002-11-20 12:20:00 | AAPL | Stock | 0.2771 | 0.2773 | 0.2763 | 0.2773 | 3679200.0 |
| 2002-11-20 12:25:00 | AAPL | Stock | 0.2773 | 0.2773 | 0.277 | 0.2772 | 823200.0 |
| 2002-11-20 12:30:00 | AAPL | Stock | 0.2771 | 0.2777 | 0.2771 | 0.2777 | 1302224.0 |
| 2002-11-20 12:35:00 | AAPL | Stock | 0.2777 | 0.2785 | 0.2764 | 0.2782 | 3343816.0 |
| 2002-11-20 12:40:00 | AAPL | Stock | 0.278 | 0.2784 | 0.2771 | 0.278 | 2514400.0 |
| 2002-11-20 12:45:00 | AAPL | Stock | 0.278 | 0.278 | 0.2771 | 0.2777 | 1439200.0 |
| 2002-11-20 12:50:00 | AAPL | Stock | 0.2775 | 0.2784 | 0.2775 | 0.2779 | 2217600.0 |
| 2002-11-20 12:55:00 | AAPL | Stock | 0.2779 | 0.278 | 0.2777 | 0.2777 | 848288.0 |
| 2002-11-20 13:00:00 | AAPL | Stock | 0.2779 | 0.2779 | 0.2773 | 0.2773 | 1136800.0 |
| 2002-11-20 13:05:00 | AAPL | Stock | 0.2773 | 0.2776 | 0.2773 | 0.2776 | 1528240.0 |
| 2002-11-20 13:10:00 | AAPL | Stock | 0.2775 | 0.2779 | 0.2768 | 0.2775 | 2947280.0 |
> showing 50 of 134,369 rows — these rows as CSV