PREVIEW / stock_5min / 2002-08-23
file: by_date/stock_5min/2002/2002-08-23.parquet size: 1.7 MB rows: 119,580 symbols: 1,463
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-08-23 09:20:00 | AAPL | Stock | 0.2839 | 0.2839 | 0.2839 | 0.2839 | 17696.0 |
| 2002-08-23 09:25:00 | AAPL | Stock | 0.2839 | 0.2839 | 0.2839 | 0.2839 | 16464.0 |
| 2002-08-23 09:30:00 | AAPL | Stock | 0.2839 | 0.2845 | 0.2813 | 0.2827 | 4015200.0 |
| 2002-08-23 09:35:00 | AAPL | Stock | 0.2827 | 0.2838 | 0.2816 | 0.282 | 2325400.0 |
| 2002-08-23 09:40:00 | AAPL | Stock | 0.2821 | 0.283 | 0.2821 | 0.2821 | 3824800.0 |
| 2002-08-23 09:45:00 | AAPL | Stock | 0.2821 | 0.2823 | 0.2814 | 0.2814 | 3044160.0 |
| 2002-08-23 09:50:00 | AAPL | Stock | 0.2816 | 0.283 | 0.2809 | 0.2829 | 2172800.0 |
| 2002-08-23 09:55:00 | AAPL | Stock | 0.2823 | 0.2839 | 0.282 | 0.2838 | 3804360.0 |
| 2002-08-23 10:00:00 | AAPL | Stock | 0.2839 | 0.2839 | 0.2821 | 0.2823 | 2247504.0 |
| 2002-08-23 10:05:00 | AAPL | Stock | 0.2821 | 0.2829 | 0.2807 | 0.2821 | 3427872.0 |
| 2002-08-23 10:10:00 | AAPL | Stock | 0.282 | 0.282 | 0.2807 | 0.2809 | 1752800.0 |
| 2002-08-23 10:15:00 | AAPL | Stock | 0.2809 | 0.2809 | 0.2796 | 0.2805 | 3800160.0 |
| 2002-08-23 10:20:00 | AAPL | Stock | 0.2805 | 0.2813 | 0.2805 | 0.2813 | 1013600.0 |
| 2002-08-23 10:25:00 | AAPL | Stock | 0.2813 | 0.2813 | 0.2798 | 0.2798 | 730800.0 |
| 2002-08-23 10:30:00 | AAPL | Stock | 0.2802 | 0.2811 | 0.2793 | 0.2811 | 1723792.0 |
| 2002-08-23 10:35:00 | AAPL | Stock | 0.2811 | 0.2816 | 0.2802 | 0.2813 | 2688000.0 |
| 2002-08-23 10:40:00 | AAPL | Stock | 0.2814 | 0.282 | 0.2804 | 0.2804 | 756224.0 |
| 2002-08-23 10:45:00 | AAPL | Stock | 0.2804 | 0.2816 | 0.2804 | 0.2813 | 1338400.0 |
| 2002-08-23 10:50:00 | AAPL | Stock | 0.2814 | 0.2816 | 0.2804 | 0.2807 | 1235640.0 |
| 2002-08-23 10:55:00 | AAPL | Stock | 0.2807 | 0.2813 | 0.2802 | 0.2802 | 1008000.0 |
| 2002-08-23 11:00:00 | AAPL | Stock | 0.2802 | 0.2809 | 0.28 | 0.2802 | 1920800.0 |
| 2002-08-23 11:05:00 | AAPL | Stock | 0.28 | 0.28 | 0.2791 | 0.2795 | 1747200.0 |
| 2002-08-23 11:10:00 | AAPL | Stock | 0.2795 | 0.2795 | 0.2777 | 0.2789 | 2966320.0 |
| 2002-08-23 11:15:00 | AAPL | Stock | 0.2789 | 0.2795 | 0.2788 | 0.2791 | 442400.0 |
| 2002-08-23 11:20:00 | AAPL | Stock | 0.2793 | 0.2798 | 0.2791 | 0.2793 | 397600.0 |
| 2002-08-23 11:25:00 | AAPL | Stock | 0.2793 | 0.2795 | 0.2788 | 0.2789 | 403200.0 |
| 2002-08-23 11:30:00 | AAPL | Stock | 0.2789 | 0.2804 | 0.2789 | 0.2793 | 907200.0 |
| 2002-08-23 11:35:00 | AAPL | Stock | 0.2798 | 0.2804 | 0.2789 | 0.2789 | 963200.0 |
| 2002-08-23 11:40:00 | AAPL | Stock | 0.2789 | 0.2793 | 0.2782 | 0.2789 | 1461600.0 |
| 2002-08-23 11:45:00 | AAPL | Stock | 0.2789 | 0.2791 | 0.2786 | 0.2789 | 1148000.0 |
| 2002-08-23 11:50:00 | AAPL | Stock | 0.2788 | 0.2795 | 0.2784 | 0.2793 | 756000.0 |
| 2002-08-23 11:55:00 | AAPL | Stock | 0.2795 | 0.2796 | 0.2786 | 0.2788 | 1181600.0 |
| 2002-08-23 12:00:00 | AAPL | Stock | 0.2788 | 0.2791 | 0.2777 | 0.2777 | 896000.0 |
| 2002-08-23 12:05:00 | AAPL | Stock | 0.2777 | 0.2784 | 0.2771 | 0.278 | 1512000.0 |
| 2002-08-23 12:10:00 | AAPL | Stock | 0.2782 | 0.2786 | 0.278 | 0.2784 | 1265600.0 |
| 2002-08-23 12:15:00 | AAPL | Stock | 0.2782 | 0.2784 | 0.2779 | 0.2782 | 1428000.0 |
| 2002-08-23 12:20:00 | AAPL | Stock | 0.278 | 0.2786 | 0.2773 | 0.2775 | 1114400.0 |
| 2002-08-23 12:25:00 | AAPL | Stock | 0.2773 | 0.2777 | 0.2763 | 0.2764 | 2359896.0 |
| 2002-08-23 12:30:00 | AAPL | Stock | 0.2764 | 0.277 | 0.2759 | 0.2766 | 4304552.0 |
| 2002-08-23 12:35:00 | AAPL | Stock | 0.2766 | 0.2766 | 0.2759 | 0.2763 | 912800.0 |
| 2002-08-23 12:40:00 | AAPL | Stock | 0.2763 | 0.2766 | 0.2759 | 0.2761 | 2066400.0 |
| 2002-08-23 12:45:00 | AAPL | Stock | 0.2761 | 0.277 | 0.2761 | 0.277 | 1355200.0 |
| 2002-08-23 12:50:00 | AAPL | Stock | 0.2768 | 0.277 | 0.2761 | 0.2763 | 935480.0 |
| 2002-08-23 12:55:00 | AAPL | Stock | 0.2763 | 0.2779 | 0.2763 | 0.2779 | 2133600.0 |
| 2002-08-23 13:00:00 | AAPL | Stock | 0.2779 | 0.2795 | 0.2777 | 0.2795 | 3575488.0 |
| 2002-08-23 13:05:00 | AAPL | Stock | 0.2795 | 0.2798 | 0.2789 | 0.2795 | 555296.0 |
| 2002-08-23 13:10:00 | AAPL | Stock | 0.2791 | 0.2795 | 0.2789 | 0.2789 | 968800.0 |
| 2002-08-23 13:15:00 | AAPL | Stock | 0.2789 | 0.2796 | 0.2789 | 0.2795 | 2749600.0 |
| 2002-08-23 13:20:00 | AAPL | Stock | 0.2791 | 0.2793 | 0.2777 | 0.2777 | 1248800.0 |
| 2002-08-23 13:25:00 | AAPL | Stock | 0.2775 | 0.278 | 0.2773 | 0.2777 | 800352.0 |
> showing 50 of 119,580 rows — these rows as CSV