PREVIEW / stock_5min / 2011-02-24
file: by_date/stock_5min/2011/2011-02-24.parquet size: 5.0 MB rows: 336,375 symbols: 3,530
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-24 04:35:00 | AAPL | Stock | 12.2625 | 12.2625 | 12.2625 | 12.2625 | 2800.0 |
| 2011-02-24 05:00:00 | AAPL | Stock | 12.2436 | 12.2436 | 12.2429 | 12.2429 | 5600.0 |
| 2011-02-24 05:10:00 | AAPL | Stock | 12.25 | 12.25 | 12.25 | 12.25 | 2800.0 |
| 2011-02-24 05:15:00 | AAPL | Stock | 12.2429 | 12.2429 | 12.2429 | 12.2429 | 2800.0 |
| 2011-02-24 06:20:00 | AAPL | Stock | 12.2107 | 12.2107 | 12.2107 | 12.2107 | 11200.0 |
| 2011-02-24 06:40:00 | AAPL | Stock | 12.2179 | 12.2179 | 12.2179 | 12.2179 | 2800.0 |
| 2011-02-24 06:45:00 | AAPL | Stock | 12.225 | 12.225 | 12.2125 | 12.2125 | 22400.0 |
| 2011-02-24 06:50:00 | AAPL | Stock | 12.2125 | 12.215 | 12.2125 | 12.2125 | 33600.0 |
| 2011-02-24 06:55:00 | AAPL | Stock | 12.215 | 12.215 | 12.2125 | 12.2125 | 19600.0 |
| 2011-02-24 07:00:00 | AAPL | Stock | 12.2125 | 12.2125 | 12.1789 | 12.1789 | 11200.0 |
| 2011-02-24 07:05:00 | AAPL | Stock | 12.1946 | 12.2071 | 12.1946 | 12.2071 | 16800.0 |
| 2011-02-24 07:10:00 | AAPL | Stock | 12.21 | 12.21 | 12.2071 | 12.2071 | 5600.0 |
| 2011-02-24 07:15:00 | AAPL | Stock | 12.1964 | 12.215 | 12.1964 | 12.1964 | 35000.0 |
| 2011-02-24 07:20:00 | AAPL | Stock | 12.1982 | 12.215 | 12.1982 | 12.2121 | 53200.0 |
| 2011-02-24 07:30:00 | AAPL | Stock | 12.1993 | 12.2061 | 12.1993 | 12.2004 | 12600.0 |
| 2011-02-24 07:35:00 | AAPL | Stock | 12.2 | 12.2 | 12.1971 | 12.1971 | 15400.0 |
| 2011-02-24 07:40:00 | AAPL | Stock | 12.1904 | 12.1904 | 12.1725 | 12.1725 | 33600.0 |
| 2011-02-24 07:45:00 | AAPL | Stock | 12.1786 | 12.1786 | 12.1786 | 12.1786 | 2800.0 |
| 2011-02-24 07:50:00 | AAPL | Stock | 12.1864 | 12.1932 | 12.1754 | 12.1786 | 22400.0 |
| 2011-02-24 08:00:00 | AAPL | Stock | 12.1911 | 12.2464 | 12.175 | 12.1993 | 537320.0 |
| 2011-02-24 08:05:00 | AAPL | Stock | 12.2007 | 12.2321 | 12.2007 | 12.2232 | 161448.0 |
| 2011-02-24 08:10:00 | AAPL | Stock | 12.2321 | 12.2321 | 12.2143 | 12.2143 | 95760.0 |
| 2011-02-24 08:15:00 | AAPL | Stock | 12.2057 | 12.2143 | 12.19 | 12.2143 | 128800.0 |
| 2011-02-24 08:20:00 | AAPL | Stock | 12.2304 | 12.2393 | 12.2143 | 12.2275 | 126308.0 |
| 2011-02-24 08:25:00 | AAPL | Stock | 12.2321 | 12.2393 | 12.2321 | 12.2321 | 136948.0 |
| 2011-02-24 08:30:00 | AAPL | Stock | 12.2382 | 12.2532 | 12.2293 | 12.2464 | 424256.0 |
| 2011-02-24 08:35:00 | AAPL | Stock | 12.2461 | 12.2843 | 12.2329 | 12.2818 | 470568.0 |
| 2011-02-24 08:40:00 | AAPL | Stock | 12.2818 | 12.2839 | 12.275 | 12.2804 | 144928.0 |
| 2011-02-24 08:45:00 | AAPL | Stock | 12.2775 | 12.2811 | 12.2743 | 12.2779 | 58072.0 |
| 2011-02-24 08:50:00 | AAPL | Stock | 12.2786 | 12.2829 | 12.2732 | 12.2786 | 200900.0 |
| 2011-02-24 08:55:00 | AAPL | Stock | 12.2761 | 12.2786 | 12.2725 | 12.2739 | 68600.0 |
| 2011-02-24 09:00:00 | AAPL | Stock | 12.2768 | 12.3057 | 12.2768 | 12.3057 | 499660.0 |
| 2011-02-24 09:05:00 | AAPL | Stock | 12.3036 | 12.3332 | 12.3036 | 12.3243 | 509740.0 |
| 2011-02-24 09:10:00 | AAPL | Stock | 12.3225 | 12.3275 | 12.3036 | 12.3114 | 800184.0 |
| 2011-02-24 09:15:00 | AAPL | Stock | 12.315 | 12.32 | 12.3118 | 12.3189 | 103740.0 |
| 2011-02-24 09:20:00 | AAPL | Stock | 12.32 | 12.3214 | 12.3143 | 12.3143 | 158704.0 |
| 2011-02-24 09:25:00 | AAPL | Stock | 12.3118 | 12.3146 | 12.2857 | 12.2857 | 527688.0 |
| 2011-02-24 09:30:00 | AAPL | Stock | 12.2871 | 12.3268 | 12.2857 | 12.3086 | 19910184.0 |
| 2011-02-24 09:35:00 | AAPL | Stock | 12.3093 | 12.3129 | 12.2557 | 12.2611 | 16231936.0 |
| 2011-02-24 09:40:00 | AAPL | Stock | 12.2611 | 12.2961 | 12.2521 | 12.2907 | 11587268.0 |
| 2011-02-24 09:45:00 | AAPL | Stock | 12.2922 | 12.2932 | 12.2557 | 12.2711 | 8133664.0 |
| 2011-02-24 09:50:00 | AAPL | Stock | 12.2757 | 12.2814 | 12.2554 | 12.2707 | 5494972.0 |
| 2011-02-24 09:55:00 | AAPL | Stock | 12.2721 | 12.2954 | 12.2629 | 12.2839 | 5148248.0 |
| 2011-02-24 10:00:00 | AAPL | Stock | 12.2839 | 12.2854 | 12.2339 | 12.2421 | 10207512.0 |
| 2011-02-24 10:05:00 | AAPL | Stock | 12.2432 | 12.2818 | 12.2411 | 12.275 | 7313264.0 |
| 2011-02-24 10:10:00 | AAPL | Stock | 12.2725 | 12.2754 | 12.2501 | 12.2645 | 4408908.0 |
| 2011-02-24 10:15:00 | AAPL | Stock | 12.2602 | 12.285 | 12.2425 | 12.278 | 7194824.0 |
| 2011-02-24 10:20:00 | AAPL | Stock | 12.2781 | 12.2943 | 12.2686 | 12.2821 | 6509496.0 |
| 2011-02-24 10:25:00 | AAPL | Stock | 12.2818 | 12.2834 | 12.2654 | 12.2782 | 4207308.0 |
| 2011-02-24 10:30:00 | AAPL | Stock | 12.2782 | 12.28 | 12.2575 | 12.2614 | 4020520.0 |
> showing 50 of 336,375 rows — these rows as CSV