PREVIEW / stock_5min / 2008-12-17
file: by_date/stock_5min/2008/2008-12-17.parquet size: 4.5 MB rows: 324,011 symbols: 3,363
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-17 04:45:00 | AAPL | Stock | 3.3193 | 3.3193 | 3.3193 | 3.3193 | 2800.0 |
| 2008-12-17 05:55:00 | AAPL | Stock | 3.3482 | 3.3482 | 3.3482 | 3.3482 | 2800.0 |
| 2008-12-17 06:30:00 | AAPL | Stock | 3.3232 | 3.3232 | 3.3193 | 3.3207 | 17640.0 |
| 2008-12-17 06:35:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.3036 | 3.3036 | 12600.0 |
| 2008-12-17 06:40:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.2857 | 3.2982 | 113708.0 |
| 2008-12-17 06:45:00 | AAPL | Stock | 3.2861 | 3.2861 | 3.2861 | 3.2861 | 36400.0 |
| 2008-12-17 06:50:00 | AAPL | Stock | 3.2861 | 3.2979 | 3.2861 | 3.2861 | 60592.0 |
| 2008-12-17 06:55:00 | AAPL | Stock | 3.2861 | 3.2861 | 3.2861 | 3.2861 | 142800.0 |
| 2008-12-17 07:00:00 | AAPL | Stock | 3.2982 | 3.3054 | 3.2982 | 3.2982 | 46200.0 |
| 2008-12-17 07:05:00 | AAPL | Stock | 3.2982 | 3.2982 | 3.2982 | 3.2982 | 47600.0 |
| 2008-12-17 07:10:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.2875 | 3.2875 | 40320.0 |
| 2008-12-17 07:15:00 | AAPL | Stock | 3.2875 | 3.2879 | 3.2789 | 3.2789 | 108080.0 |
| 2008-12-17 07:20:00 | AAPL | Stock | 3.2789 | 3.2789 | 3.265 | 3.2675 | 116900.0 |
| 2008-12-17 07:25:00 | AAPL | Stock | 3.2675 | 3.2679 | 3.2661 | 3.2661 | 136500.0 |
| 2008-12-17 07:30:00 | AAPL | Stock | 3.2575 | 3.2836 | 3.2571 | 3.2836 | 78932.0 |
| 2008-12-17 07:35:00 | AAPL | Stock | 3.2818 | 3.2821 | 3.2786 | 3.2786 | 74732.0 |
| 2008-12-17 07:40:00 | AAPL | Stock | 3.2782 | 3.2804 | 3.2721 | 3.2782 | 116788.0 |
| 2008-12-17 07:45:00 | AAPL | Stock | 3.2721 | 3.2782 | 3.2721 | 3.2782 | 19600.0 |
| 2008-12-17 07:50:00 | AAPL | Stock | 3.2782 | 3.2782 | 3.2782 | 3.2782 | 2800.0 |
| 2008-12-17 07:55:00 | AAPL | Stock | 3.2782 | 3.2857 | 3.2768 | 3.2786 | 519540.0 |
| 2008-12-17 08:00:00 | AAPL | Stock | 3.2836 | 3.2857 | 3.2704 | 3.2736 | 1532076.0 |
| 2008-12-17 08:05:00 | AAPL | Stock | 3.275 | 3.2857 | 3.2675 | 3.2714 | 1415904.0 |
| 2008-12-17 08:10:00 | AAPL | Stock | 3.2714 | 3.2764 | 3.2643 | 3.2661 | 407260.0 |
| 2008-12-17 08:15:00 | AAPL | Stock | 3.2646 | 3.2661 | 3.2214 | 3.2321 | 2182656.0 |
| 2008-12-17 08:20:00 | AAPL | Stock | 3.2321 | 3.2614 | 3.2321 | 3.2579 | 1352624.0 |
| 2008-12-17 08:25:00 | AAPL | Stock | 3.2586 | 3.2668 | 3.2571 | 3.2607 | 749952.0 |
| 2008-12-17 08:30:00 | AAPL | Stock | 3.2607 | 3.2632 | 3.2604 | 3.2632 | 599228.0 |
| 2008-12-17 08:35:00 | AAPL | Stock | 3.2632 | 3.2732 | 3.2607 | 3.2625 | 498204.0 |
| 2008-12-17 08:40:00 | AAPL | Stock | 3.2614 | 3.2679 | 3.2589 | 3.2607 | 475888.0 |
| 2008-12-17 08:45:00 | AAPL | Stock | 3.2607 | 3.2679 | 3.2607 | 3.2668 | 447020.0 |
| 2008-12-17 08:50:00 | AAPL | Stock | 3.2661 | 3.2679 | 3.2643 | 3.2679 | 389256.0 |
| 2008-12-17 08:55:00 | AAPL | Stock | 3.2679 | 3.2786 | 3.2654 | 3.2782 | 736680.0 |
| 2008-12-17 09:00:00 | AAPL | Stock | 3.2793 | 3.2814 | 3.2625 | 3.2625 | 912660.0 |
| 2008-12-17 09:05:00 | AAPL | Stock | 3.2625 | 3.2714 | 3.2521 | 3.2554 | 770364.0 |
| 2008-12-17 09:10:00 | AAPL | Stock | 3.2554 | 3.2561 | 3.2436 | 3.2454 | 1517404.0 |
| 2008-12-17 09:15:00 | AAPL | Stock | 3.245 | 3.2571 | 3.245 | 3.2461 | 841680.0 |
| 2008-12-17 09:20:00 | AAPL | Stock | 3.2464 | 3.2543 | 3.245 | 3.2525 | 1270360.0 |
| 2008-12-17 09:25:00 | AAPL | Stock | 3.2507 | 3.2536 | 3.2457 | 3.25 | 4412856.0 |
| 2008-12-17 09:30:00 | AAPL | Stock | 3.2511 | 3.2536 | 3.2179 | 3.2186 | 43835008.0 |
| 2008-12-17 09:35:00 | AAPL | Stock | 3.2186 | 3.2304 | 3.2 | 3.2014 | 60369288.0 |
| 2008-12-17 09:40:00 | AAPL | Stock | 3.2014 | 3.2107 | 3.1911 | 3.2103 | 41274940.0 |
| 2008-12-17 09:45:00 | AAPL | Stock | 3.21 | 3.2321 | 3.2039 | 3.2321 | 33112828.0 |
| 2008-12-17 09:50:00 | AAPL | Stock | 3.2321 | 3.2354 | 3.2075 | 3.2079 | 27223980.0 |
| 2008-12-17 09:55:00 | AAPL | Stock | 3.2075 | 3.2171 | 3.1989 | 3.214 | 24565940.0 |
| 2008-12-17 10:00:00 | AAPL | Stock | 3.2139 | 3.2175 | 3.1857 | 3.1857 | 25028304.0 |
| 2008-12-17 10:05:00 | AAPL | Stock | 3.1861 | 3.1864 | 3.1568 | 3.1621 | 41032572.0 |
| 2008-12-17 10:10:00 | AAPL | Stock | 3.1621 | 3.1632 | 3.1436 | 3.1507 | 31214512.0 |
| 2008-12-17 10:15:00 | AAPL | Stock | 3.1507 | 3.1668 | 3.1475 | 3.1593 | 26078640.0 |
| 2008-12-17 10:20:00 | AAPL | Stock | 3.1593 | 3.1836 | 3.1593 | 3.1814 | 26009200.0 |
| 2008-12-17 10:25:00 | AAPL | Stock | 3.1814 | 3.1889 | 3.1754 | 3.1793 | 21665616.0 |
> showing 50 of 324,011 rows — these rows as CSV