PREVIEW / stock_5min / 2002-11-27
file: by_date/stock_5min/2002/2002-11-27.parquet size: 1.9 MB rows: 132,922 symbols: 1,517
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-27 08:15:00 | AAPL | Stock | 0.2777 | 0.2777 | 0.2777 | 0.2777 | 33600.0 |
| 2002-11-27 08:20:00 | AAPL | Stock | 0.2779 | 0.2803 | 0.2779 | 0.2803 | 140000.0 |
| 2002-11-27 08:45:00 | AAPL | Stock | 0.2803 | 0.2804 | 0.2803 | 0.2804 | 16800.0 |
| 2002-11-27 09:05:00 | AAPL | Stock | 0.2795 | 0.2795 | 0.2795 | 0.2795 | 67200.0 |
| 2002-11-27 09:10:00 | AAPL | Stock | 0.2795 | 0.2795 | 0.2795 | 0.2795 | 16800.0 |
| 2002-11-27 09:20:00 | AAPL | Stock | 0.2789 | 0.2789 | 0.2789 | 0.2789 | 22400.0 |
| 2002-11-27 09:25:00 | AAPL | Stock | 0.2786 | 0.2789 | 0.2754 | 0.2786 | 1002400.0 |
| 2002-11-27 09:30:00 | AAPL | Stock | 0.2786 | 0.2786 | 0.2768 | 0.2786 | 4986744.0 |
| 2002-11-27 09:35:00 | AAPL | Stock | 0.2786 | 0.2786 | 0.2779 | 0.2782 | 3763200.0 |
| 2002-11-27 09:40:00 | AAPL | Stock | 0.278 | 0.2786 | 0.2775 | 0.2786 | 2987600.0 |
| 2002-11-27 09:45:00 | AAPL | Stock | 0.2784 | 0.2786 | 0.2759 | 0.2764 | 6330800.0 |
| 2002-11-27 09:50:00 | AAPL | Stock | 0.2764 | 0.278 | 0.2763 | 0.2771 | 5777296.0 |
| 2002-11-27 09:55:00 | AAPL | Stock | 0.2768 | 0.2777 | 0.2759 | 0.2765 | 4093600.0 |
| 2002-11-27 10:00:00 | AAPL | Stock | 0.277 | 0.2777 | 0.2759 | 0.2773 | 7313656.0 |
| 2002-11-27 10:05:00 | AAPL | Stock | 0.2773 | 0.2786 | 0.2764 | 0.2784 | 5706624.0 |
| 2002-11-27 10:10:00 | AAPL | Stock | 0.2782 | 0.2784 | 0.2771 | 0.2773 | 1731856.0 |
| 2002-11-27 10:15:00 | AAPL | Stock | 0.2774 | 0.2782 | 0.2773 | 0.2782 | 3203648.0 |
| 2002-11-27 10:20:00 | AAPL | Stock | 0.2782 | 0.2786 | 0.278 | 0.2782 | 3100664.0 |
| 2002-11-27 10:25:00 | AAPL | Stock | 0.2782 | 0.2784 | 0.278 | 0.2782 | 1947120.0 |
| 2002-11-27 10:30:00 | AAPL | Stock | 0.2784 | 0.2786 | 0.2782 | 0.2786 | 5298832.0 |
| 2002-11-27 10:35:00 | AAPL | Stock | 0.2786 | 0.2788 | 0.2784 | 0.2784 | 1904000.0 |
| 2002-11-27 10:40:00 | AAPL | Stock | 0.2782 | 0.2788 | 0.278 | 0.2786 | 1948800.0 |
| 2002-11-27 10:45:00 | AAPL | Stock | 0.2786 | 0.2787 | 0.2784 | 0.2787 | 1416800.0 |
| 2002-11-27 10:50:00 | AAPL | Stock | 0.2786 | 0.2791 | 0.2779 | 0.2789 | 2240000.0 |
| 2002-11-27 10:55:00 | AAPL | Stock | 0.2789 | 0.2793 | 0.2779 | 0.2793 | 2646000.0 |
| 2002-11-27 11:00:00 | AAPL | Stock | 0.2795 | 0.2804 | 0.2786 | 0.2795 | 4384800.0 |
| 2002-11-27 11:05:00 | AAPL | Stock | 0.2795 | 0.28 | 0.2795 | 0.2796 | 1120616.0 |
| 2002-11-27 11:10:00 | AAPL | Stock | 0.2796 | 0.2802 | 0.2795 | 0.2795 | 3485776.0 |
| 2002-11-27 11:15:00 | AAPL | Stock | 0.2796 | 0.2796 | 0.2786 | 0.2789 | 823200.0 |
| 2002-11-27 11:20:00 | AAPL | Stock | 0.2789 | 0.2789 | 0.2788 | 0.2789 | 394296.0 |
| 2002-11-27 11:25:00 | AAPL | Stock | 0.2788 | 0.2791 | 0.2786 | 0.2789 | 1153600.0 |
| 2002-11-27 11:30:00 | AAPL | Stock | 0.2788 | 0.2789 | 0.278 | 0.2789 | 2027200.0 |
| 2002-11-27 11:35:00 | AAPL | Stock | 0.2789 | 0.2789 | 0.2784 | 0.2788 | 1660792.0 |
| 2002-11-27 11:40:00 | AAPL | Stock | 0.2789 | 0.2789 | 0.2775 | 0.2779 | 4104800.0 |
| 2002-11-27 11:45:00 | AAPL | Stock | 0.2779 | 0.2786 | 0.2777 | 0.2784 | 1926120.0 |
| 2002-11-27 11:50:00 | AAPL | Stock | 0.2782 | 0.2784 | 0.277 | 0.2771 | 1749720.0 |
| 2002-11-27 11:55:00 | AAPL | Stock | 0.2775 | 0.278 | 0.2773 | 0.2779 | 1401680.0 |
| 2002-11-27 12:00:00 | AAPL | Stock | 0.278 | 0.2788 | 0.2773 | 0.2779 | 3207120.0 |
| 2002-11-27 12:05:00 | AAPL | Stock | 0.2779 | 0.2784 | 0.2777 | 0.2779 | 30823800.0 |
| 2002-11-27 12:10:00 | AAPL | Stock | 0.2779 | 0.2786 | 0.2779 | 0.2786 | 1114400.0 |
| 2002-11-27 12:15:00 | AAPL | Stock | 0.2786 | 0.2791 | 0.2784 | 0.2786 | 3430000.0 |
| 2002-11-27 12:20:00 | AAPL | Stock | 0.2786 | 0.2786 | 0.2775 | 0.2777 | 3186400.0 |
| 2002-11-27 12:25:00 | AAPL | Stock | 0.2777 | 0.2779 | 0.2773 | 0.2777 | 2084320.0 |
| 2002-11-27 12:30:00 | AAPL | Stock | 0.2777 | 0.2791 | 0.2775 | 0.2791 | 1276520.0 |
| 2002-11-27 12:35:00 | AAPL | Stock | 0.2791 | 0.2795 | 0.2784 | 0.2795 | 2856000.0 |
| 2002-11-27 12:40:00 | AAPL | Stock | 0.2795 | 0.2796 | 0.2782 | 0.2795 | 2383696.0 |
| 2002-11-27 12:45:00 | AAPL | Stock | 0.2795 | 0.2811 | 0.2795 | 0.2805 | 2309384.0 |
| 2002-11-27 12:50:00 | AAPL | Stock | 0.2805 | 0.2816 | 0.28 | 0.2814 | 3052000.0 |
| 2002-11-27 12:55:00 | AAPL | Stock | 0.2813 | 0.2821 | 0.2809 | 0.282 | 3274208.0 |
| 2002-11-27 13:00:00 | AAPL | Stock | 0.282 | 0.2832 | 0.2818 | 0.2827 | 3211600.0 |
> showing 50 of 132,922 rows — these rows as CSV