PREVIEW / stock_5min / 2008-02-27
file: by_date/stock_5min/2008/2008-02-27.parquet size: 4.3 MB rows: 312,276 symbols: 3,243
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-02-27 04:35:00 | AAPL | Stock | 4.2464 | 4.2464 | 4.2446 | 4.2446 | 5600.0 |
| 2008-02-27 04:40:00 | AAPL | Stock | 4.2429 | 4.2432 | 4.2418 | 4.2429 | 16800.0 |
| 2008-02-27 05:25:00 | AAPL | Stock | 4.2429 | 4.2429 | 4.2429 | 4.2429 | 2800.0 |
| 2008-02-27 06:55:00 | AAPL | Stock | 4.25 | 4.25 | 4.25 | 4.25 | 2800.0 |
| 2008-02-27 07:05:00 | AAPL | Stock | 4.2446 | 4.2446 | 4.2446 | 4.2446 | 2800.0 |
| 2008-02-27 07:15:00 | AAPL | Stock | 4.2468 | 4.2468 | 4.2468 | 4.2468 | 8400.0 |
| 2008-02-27 07:25:00 | AAPL | Stock | 4.2518 | 4.2518 | 4.2518 | 4.2518 | 2800.0 |
| 2008-02-27 07:30:00 | AAPL | Stock | 4.25 | 4.2514 | 4.25 | 4.2514 | 8400.0 |
| 2008-02-27 07:35:00 | AAPL | Stock | 4.2464 | 4.2464 | 4.2393 | 4.2464 | 14000.0 |
| 2008-02-27 07:40:00 | AAPL | Stock | 4.2396 | 4.2396 | 4.2393 | 4.2393 | 10332.0 |
| 2008-02-27 07:45:00 | AAPL | Stock | 4.2396 | 4.2396 | 4.2396 | 4.2396 | 2828.0 |
| 2008-02-27 07:50:00 | AAPL | Stock | 4.2396 | 4.2396 | 4.2325 | 4.2325 | 15036.0 |
| 2008-02-27 08:00:00 | AAPL | Stock | 4.2379 | 4.2379 | 4.2214 | 4.225 | 177800.0 |
| 2008-02-27 08:05:00 | AAPL | Stock | 4.2264 | 4.2304 | 4.2214 | 4.2214 | 123116.0 |
| 2008-02-27 08:10:00 | AAPL | Stock | 4.2232 | 4.2254 | 4.2071 | 4.2111 | 173320.0 |
| 2008-02-27 08:15:00 | AAPL | Stock | 4.2057 | 4.2143 | 4.2057 | 4.2075 | 220584.0 |
| 2008-02-27 08:20:00 | AAPL | Stock | 4.2079 | 4.2079 | 4.2032 | 4.2036 | 117264.0 |
| 2008-02-27 08:25:00 | AAPL | Stock | 4.2018 | 4.2057 | 4.1964 | 4.205 | 242200.0 |
| 2008-02-27 08:30:00 | AAPL | Stock | 4.2007 | 4.2082 | 4.1929 | 4.2082 | 445508.0 |
| 2008-02-27 08:35:00 | AAPL | Stock | 4.21 | 4.2143 | 4.2075 | 4.2096 | 223160.0 |
| 2008-02-27 08:40:00 | AAPL | Stock | 4.21 | 4.2164 | 4.2093 | 4.2157 | 235928.0 |
| 2008-02-27 08:45:00 | AAPL | Stock | 4.2157 | 4.2157 | 4.2043 | 4.2057 | 295288.0 |
| 2008-02-27 08:50:00 | AAPL | Stock | 4.2057 | 4.2089 | 4.1982 | 4.2064 | 325080.0 |
| 2008-02-27 08:55:00 | AAPL | Stock | 4.2071 | 4.2114 | 4.2046 | 4.2093 | 322000.0 |
| 2008-02-27 09:00:00 | AAPL | Stock | 4.2082 | 4.2093 | 4.2071 | 4.2093 | 79800.0 |
| 2008-02-27 09:05:00 | AAPL | Stock | 4.2093 | 4.2096 | 4.2071 | 4.2089 | 87080.0 |
| 2008-02-27 09:10:00 | AAPL | Stock | 4.21 | 4.2107 | 4.2064 | 4.2071 | 141680.0 |
| 2008-02-27 09:15:00 | AAPL | Stock | 4.2071 | 4.2089 | 4.2046 | 4.2089 | 119000.0 |
| 2008-02-27 09:20:00 | AAPL | Stock | 4.2089 | 4.2089 | 4.2054 | 4.2071 | 117600.0 |
| 2008-02-27 09:25:00 | AAPL | Stock | 4.2089 | 4.2268 | 4.2075 | 4.2225 | 1338820.0 |
| 2008-02-27 09:30:00 | AAPL | Stock | 4.2221 | 4.2575 | 4.2175 | 4.2482 | 31230276.0 |
| 2008-02-27 09:35:00 | AAPL | Stock | 4.2482 | 4.2589 | 4.2243 | 4.2586 | 28599788.0 |
| 2008-02-27 09:40:00 | AAPL | Stock | 4.2589 | 4.2925 | 4.2509 | 4.2836 | 62493368.0 |
| 2008-02-27 09:45:00 | AAPL | Stock | 4.2843 | 4.2993 | 4.2689 | 4.2875 | 37602180.0 |
| 2008-02-27 09:50:00 | AAPL | Stock | 4.2875 | 4.2964 | 4.2632 | 4.2718 | 25422796.0 |
| 2008-02-27 09:55:00 | AAPL | Stock | 4.2718 | 4.2793 | 4.2561 | 4.2684 | 22583988.0 |
| 2008-02-27 10:00:00 | AAPL | Stock | 4.2686 | 4.2686 | 4.2454 | 4.2561 | 30711856.0 |
| 2008-02-27 10:05:00 | AAPL | Stock | 4.2561 | 4.2639 | 4.2407 | 4.2568 | 21918484.0 |
| 2008-02-27 10:10:00 | AAPL | Stock | 4.2571 | 4.2848 | 4.2564 | 4.2675 | 14675388.0 |
| 2008-02-27 10:15:00 | AAPL | Stock | 4.2675 | 4.2961 | 4.265 | 4.2857 | 26957644.0 |
| 2008-02-27 10:20:00 | AAPL | Stock | 4.2861 | 4.2861 | 4.2682 | 4.27 | 17383884.0 |
| 2008-02-27 10:25:00 | AAPL | Stock | 4.2694 | 4.2796 | 4.2643 | 4.265 | 16051812.0 |
| 2008-02-27 10:30:00 | AAPL | Stock | 4.2652 | 4.2818 | 4.2593 | 4.2786 | 14948668.0 |
| 2008-02-27 10:35:00 | AAPL | Stock | 4.2779 | 4.2932 | 4.2764 | 4.2839 | 22019172.0 |
| 2008-02-27 10:40:00 | AAPL | Stock | 4.2846 | 4.3143 | 4.2839 | 4.2993 | 36698088.0 |
| 2008-02-27 10:45:00 | AAPL | Stock | 4.2993 | 4.3214 | 4.2932 | 4.2975 | 32766188.0 |
| 2008-02-27 10:50:00 | AAPL | Stock | 4.2979 | 4.3129 | 4.2896 | 4.2941 | 20125784.0 |
| 2008-02-27 10:55:00 | AAPL | Stock | 4.2957 | 4.3011 | 4.2821 | 4.2854 | 15165192.0 |
| 2008-02-27 11:00:00 | AAPL | Stock | 4.2854 | 4.2946 | 4.2854 | 4.2904 | 10136252.0 |
| 2008-02-27 11:05:00 | AAPL | Stock | 4.2907 | 4.3068 | 4.29 | 4.3025 | 15734880.0 |
> showing 50 of 312,276 rows — these rows as CSV