PREVIEW / stock_5min / 2008-10-24
file: by_date/stock_5min/2008/2008-10-24.parquet size: 4.4 MB rows: 313,826 symbols: 3,322
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-10-24 04:15:00 | AAPL | Stock | 3.3964 | 3.3964 | 3.3929 | 3.3929 | 16800.0 |
| 2008-10-24 04:30:00 | AAPL | Stock | 3.2861 | 3.2861 | 3.2861 | 3.2861 | 5320.0 |
| 2008-10-24 04:35:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 8120.0 |
| 2008-10-24 04:40:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 5600.0 |
| 2008-10-24 04:55:00 | AAPL | Stock | 3.2679 | 3.2679 | 3.2679 | 3.2679 | 2800.0 |
| 2008-10-24 05:30:00 | AAPL | Stock | 3.2521 | 3.2521 | 3.2521 | 3.2521 | 3640.0 |
| 2008-10-24 05:40:00 | AAPL | Stock | 3.2504 | 3.2504 | 3.2504 | 3.2504 | 2800.0 |
| 2008-10-24 05:50:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2321 | 3.2321 | 2800.0 |
| 2008-10-24 06:10:00 | AAPL | Stock | 3.2146 | 3.2146 | 3.2146 | 3.2146 | 3164.0 |
| 2008-10-24 07:00:00 | AAPL | Stock | 3.2143 | 3.2857 | 3.2143 | 3.2154 | 75152.0 |
| 2008-10-24 07:05:00 | AAPL | Stock | 3.2164 | 3.2764 | 3.2111 | 3.2764 | 51800.0 |
| 2008-10-24 07:10:00 | AAPL | Stock | 3.2532 | 3.2532 | 3.25 | 3.25 | 79800.0 |
| 2008-10-24 07:15:00 | AAPL | Stock | 3.2493 | 3.2493 | 3.2311 | 3.2389 | 24360.0 |
| 2008-10-24 07:20:00 | AAPL | Stock | 3.2389 | 3.25 | 3.2143 | 3.2143 | 72800.0 |
| 2008-10-24 07:25:00 | AAPL | Stock | 3.2311 | 3.2321 | 3.2311 | 3.2321 | 61376.0 |
| 2008-10-24 07:30:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2232 | 3.2286 | 19600.0 |
| 2008-10-24 07:35:00 | AAPL | Stock | 3.2568 | 3.2607 | 3.2461 | 3.2571 | 138572.0 |
| 2008-10-24 07:40:00 | AAPL | Stock | 3.25 | 3.25 | 3.25 | 3.25 | 76328.0 |
| 2008-10-24 07:45:00 | AAPL | Stock | 3.25 | 3.2607 | 3.25 | 3.25 | 22400.0 |
| 2008-10-24 07:50:00 | AAPL | Stock | 3.2675 | 3.2675 | 3.2525 | 3.2525 | 16800.0 |
| 2008-10-24 07:55:00 | AAPL | Stock | 3.2521 | 3.2521 | 3.25 | 3.25 | 57400.0 |
| 2008-10-24 08:00:00 | AAPL | Stock | 3.2507 | 3.3214 | 3.2143 | 3.2518 | 1311744.0 |
| 2008-10-24 08:05:00 | AAPL | Stock | 3.2554 | 3.2589 | 3.2107 | 3.2182 | 917532.0 |
| 2008-10-24 08:10:00 | AAPL | Stock | 3.2182 | 3.2429 | 3.2182 | 3.2321 | 831264.0 |
| 2008-10-24 08:15:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2214 | 3.2286 | 573440.0 |
| 2008-10-24 08:20:00 | AAPL | Stock | 3.2296 | 3.2304 | 3.2036 | 3.2143 | 689164.0 |
| 2008-10-24 08:25:00 | AAPL | Stock | 3.2107 | 3.2214 | 3.2089 | 3.2093 | 459928.0 |
| 2008-10-24 08:30:00 | AAPL | Stock | 3.2071 | 3.2139 | 3.1982 | 3.2093 | 414344.0 |
| 2008-10-24 08:35:00 | AAPL | Stock | 3.2093 | 3.2136 | 3.2043 | 3.2089 | 222964.0 |
| 2008-10-24 08:40:00 | AAPL | Stock | 3.2079 | 3.2079 | 3.1793 | 3.18 | 681380.0 |
| 2008-10-24 08:45:00 | AAPL | Stock | 3.18 | 3.2036 | 3.1789 | 3.2036 | 518504.0 |
| 2008-10-24 08:50:00 | AAPL | Stock | 3.2039 | 3.2125 | 3.2025 | 3.2086 | 535556.0 |
| 2008-10-24 08:55:00 | AAPL | Stock | 3.2075 | 3.2393 | 3.2054 | 3.23 | 946680.0 |
| 2008-10-24 09:00:00 | AAPL | Stock | 3.2304 | 3.2321 | 3.2143 | 3.2204 | 667996.0 |
| 2008-10-24 09:05:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2071 | 3.2125 | 526428.0 |
| 2008-10-24 09:10:00 | AAPL | Stock | 3.2107 | 3.2214 | 3.2007 | 3.2071 | 726236.0 |
| 2008-10-24 09:15:00 | AAPL | Stock | 3.2039 | 3.2161 | 3.2029 | 3.2161 | 460992.0 |
| 2008-10-24 09:20:00 | AAPL | Stock | 3.2161 | 3.2286 | 3.2139 | 3.215 | 658868.0 |
| 2008-10-24 09:25:00 | AAPL | Stock | 3.2225 | 3.23 | 3.2143 | 3.2254 | 2677668.0 |
| 2008-10-24 09:30:00 | AAPL | Stock | 3.2243 | 3.3286 | 3.2182 | 3.3214 | 43947232.0 |
| 2008-10-24 09:35:00 | AAPL | Stock | 3.3214 | 3.3689 | 3.2679 | 3.3204 | 38660104.0 |
| 2008-10-24 09:40:00 | AAPL | Stock | 3.3175 | 3.35 | 3.2857 | 3.291 | 29004724.0 |
| 2008-10-24 09:45:00 | AAPL | Stock | 3.2911 | 3.35 | 3.2857 | 3.3393 | 37580928.0 |
| 2008-10-24 09:50:00 | AAPL | Stock | 3.3393 | 3.3779 | 3.32 | 3.3714 | 35951944.0 |
| 2008-10-24 09:55:00 | AAPL | Stock | 3.3705 | 3.4286 | 3.3257 | 3.3943 | 45613428.0 |
| 2008-10-24 10:00:00 | AAPL | Stock | 3.3943 | 3.4275 | 3.3654 | 3.3721 | 38448648.0 |
| 2008-10-24 10:05:00 | AAPL | Stock | 3.3736 | 3.4096 | 3.3564 | 3.3759 | 28234724.0 |
| 2008-10-24 10:10:00 | AAPL | Stock | 3.3696 | 3.3761 | 3.3407 | 3.3657 | 25511724.0 |
| 2008-10-24 10:15:00 | AAPL | Stock | 3.3646 | 3.3871 | 3.3457 | 3.3679 | 20908888.0 |
| 2008-10-24 10:20:00 | AAPL | Stock | 3.3671 | 3.3875 | 3.3461 | 3.355 | 18297720.0 |
> showing 50 of 313,826 rows — these rows as CSV