PREVIEW / stock_5min / 2007-02-22
file: by_date/stock_5min/2007/2007-02-22.parquet size: 3.4 MB rows: 250,740 symbols: 2,525
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-22 04:15:00 | AAPL | Stock | 3.1964 | 3.2 | 3.1964 | 3.2 | 24640.0 |
| 2007-02-22 04:20:00 | AAPL | Stock | 3.2 | 3.2 | 3.2 | 3.2 | 2800.0 |
| 2007-02-22 04:40:00 | AAPL | Stock | 3.2 | 3.2 | 3.2 | 3.2 | 39200.0 |
| 2007-02-22 05:20:00 | AAPL | Stock | 3.2007 | 3.2007 | 3.2 | 3.2 | 14000.0 |
| 2007-02-22 06:35:00 | AAPL | Stock | 3.2036 | 3.2036 | 3.2036 | 3.2036 | 67200.0 |
| 2007-02-22 06:45:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 2800.0 |
| 2007-02-22 06:50:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 2800.0 |
| 2007-02-22 06:55:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 25200.0 |
| 2007-02-22 07:00:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2018 | 3.2018 | 38780.0 |
| 2007-02-22 07:05:00 | AAPL | Stock | 3.2071 | 3.2089 | 3.2071 | 3.2089 | 105700.0 |
| 2007-02-22 07:10:00 | AAPL | Stock | 3.2121 | 3.2139 | 3.2121 | 3.2139 | 44800.0 |
| 2007-02-22 07:15:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2071 | 3.2071 | 47600.0 |
| 2007-02-22 07:30:00 | AAPL | Stock | 3.2007 | 3.2007 | 3.2 | 3.2 | 16800.0 |
| 2007-02-22 07:35:00 | AAPL | Stock | 3.2014 | 3.2064 | 3.2011 | 3.2054 | 182000.0 |
| 2007-02-22 07:40:00 | AAPL | Stock | 3.2054 | 3.2211 | 3.2043 | 3.2179 | 534940.0 |
| 2007-02-22 07:45:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2071 | 3.2071 | 250600.0 |
| 2007-02-22 07:50:00 | AAPL | Stock | 3.2089 | 3.2107 | 3.2071 | 3.2096 | 232400.0 |
| 2007-02-22 07:55:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2043 | 3.2071 | 123200.0 |
| 2007-02-22 08:00:00 | AAPL | Stock | 3.2082 | 3.2286 | 3.2036 | 3.2286 | 2929724.0 |
| 2007-02-22 08:05:00 | AAPL | Stock | 3.2286 | 3.2382 | 3.2268 | 3.2357 | 2624524.0 |
| 2007-02-22 08:10:00 | AAPL | Stock | 3.2371 | 3.2429 | 3.2304 | 3.2321 | 1992228.0 |
| 2007-02-22 08:15:00 | AAPL | Stock | 3.2339 | 3.2411 | 3.2304 | 3.2304 | 1506288.0 |
| 2007-02-22 08:20:00 | AAPL | Stock | 3.2321 | 3.2375 | 3.2286 | 3.2321 | 891800.0 |
| 2007-02-22 08:25:00 | AAPL | Stock | 3.2304 | 3.2382 | 3.2289 | 3.235 | 1410248.0 |
| 2007-02-22 08:30:00 | AAPL | Stock | 3.235 | 3.2375 | 3.2318 | 3.2346 | 789236.0 |
| 2007-02-22 08:35:00 | AAPL | Stock | 3.2339 | 3.2375 | 3.2325 | 3.2325 | 617932.0 |
| 2007-02-22 08:40:00 | AAPL | Stock | 3.2329 | 3.2329 | 3.2286 | 3.2289 | 710864.0 |
| 2007-02-22 08:45:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2254 | 3.2254 | 1171744.0 |
| 2007-02-22 08:50:00 | AAPL | Stock | 3.2257 | 3.235 | 3.2254 | 3.2339 | 815976.0 |
| 2007-02-22 08:55:00 | AAPL | Stock | 3.2339 | 3.235 | 3.2289 | 3.2304 | 902468.0 |
| 2007-02-22 09:00:00 | AAPL | Stock | 3.2304 | 3.2321 | 3.2293 | 3.2321 | 496748.0 |
| 2007-02-22 09:05:00 | AAPL | Stock | 3.2321 | 3.2339 | 3.2314 | 3.2321 | 645176.0 |
| 2007-02-22 09:10:00 | AAPL | Stock | 3.2321 | 3.2336 | 3.2304 | 3.2325 | 484204.0 |
| 2007-02-22 09:15:00 | AAPL | Stock | 3.2321 | 3.2336 | 3.2318 | 3.2325 | 481320.0 |
| 2007-02-22 09:20:00 | AAPL | Stock | 3.2321 | 3.2371 | 3.2321 | 3.235 | 975716.0 |
| 2007-02-22 09:25:00 | AAPL | Stock | 3.2343 | 3.2432 | 3.2339 | 3.2429 | 3332000.0 |
| 2007-02-22 09:30:00 | AAPL | Stock | 3.2429 | 3.2432 | 3.2254 | 3.2318 | 56734440.0 |
| 2007-02-22 09:35:00 | AAPL | Stock | 3.2318 | 3.2429 | 3.2193 | 3.2243 | 33403944.0 |
| 2007-02-22 09:40:00 | AAPL | Stock | 3.2243 | 3.2268 | 3.2161 | 3.2246 | 23881732.0 |
| 2007-02-22 09:45:00 | AAPL | Stock | 3.2246 | 3.23 | 3.2186 | 3.2229 | 23569252.0 |
| 2007-02-22 09:50:00 | AAPL | Stock | 3.2229 | 3.2232 | 3.2089 | 3.2139 | 33679576.0 |
| 2007-02-22 09:55:00 | AAPL | Stock | 3.2139 | 3.2164 | 3.1996 | 3.2021 | 24901632.0 |
| 2007-02-22 10:00:00 | AAPL | Stock | 3.2025 | 3.2104 | 3.2004 | 3.2093 | 22489376.0 |
| 2007-02-22 10:05:00 | AAPL | Stock | 3.2093 | 3.2107 | 3.2039 | 3.2079 | 19438916.0 |
| 2007-02-22 10:10:00 | AAPL | Stock | 3.2075 | 3.2079 | 3.2004 | 3.2029 | 14107884.0 |
| 2007-02-22 10:15:00 | AAPL | Stock | 3.2029 | 3.2046 | 3.1946 | 3.1993 | 20946996.0 |
| 2007-02-22 10:20:00 | AAPL | Stock | 3.1996 | 3.2071 | 3.1964 | 3.2057 | 21342944.0 |
| 2007-02-22 10:25:00 | AAPL | Stock | 3.2057 | 3.2225 | 3.2025 | 3.2029 | 16673412.0 |
| 2007-02-22 10:30:00 | AAPL | Stock | 3.2029 | 3.2029 | 3.1896 | 3.1909 | 17405864.0 |
| 2007-02-22 10:35:00 | AAPL | Stock | 3.1904 | 3.2 | 3.1893 | 3.1932 | 15075620.0 |
> showing 50 of 250,740 rows — these rows as CSV