PREVIEW / stock_5min / 2008-08-21
file: by_date/stock_5min/2008/2008-08-21.parquet size: 4.2 MB rows: 303,317 symbols: 3,293
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-08-21 04:40:00 | AAPL | Stock | 6.2504 | 6.2504 | 6.2504 | 6.2504 | 5600.0 |
| 2008-08-21 05:55:00 | AAPL | Stock | 6.2236 | 6.2236 | 6.2236 | 6.2236 | 19600.0 |
| 2008-08-21 07:30:00 | AAPL | Stock | 6.2711 | 6.2711 | 6.2711 | 6.2711 | 4200.0 |
| 2008-08-21 07:35:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 11200.0 |
| 2008-08-21 07:50:00 | AAPL | Stock | 6.2393 | 6.2393 | 6.2393 | 6.2393 | 28000.0 |
| 2008-08-21 07:55:00 | AAPL | Stock | 6.2393 | 6.2396 | 6.2393 | 6.2396 | 8400.0 |
| 2008-08-21 08:00:00 | AAPL | Stock | 6.2482 | 6.25 | 6.2404 | 6.2404 | 151256.0 |
| 2008-08-21 08:05:00 | AAPL | Stock | 6.2396 | 6.25 | 6.2396 | 6.25 | 108164.0 |
| 2008-08-21 08:10:00 | AAPL | Stock | 6.2507 | 6.2568 | 6.25 | 6.2568 | 159600.0 |
| 2008-08-21 08:15:00 | AAPL | Stock | 6.2511 | 6.2511 | 6.24 | 6.24 | 30044.0 |
| 2008-08-21 08:20:00 | AAPL | Stock | 6.2521 | 6.2521 | 6.2521 | 6.2521 | 5600.0 |
| 2008-08-21 08:25:00 | AAPL | Stock | 6.2514 | 6.2532 | 6.2457 | 6.2457 | 61600.0 |
| 2008-08-21 08:30:00 | AAPL | Stock | 6.245 | 6.2614 | 6.2439 | 6.2446 | 152600.0 |
| 2008-08-21 08:35:00 | AAPL | Stock | 6.2443 | 6.2464 | 6.2411 | 6.2464 | 120372.0 |
| 2008-08-21 08:40:00 | AAPL | Stock | 6.2482 | 6.25 | 6.2464 | 6.25 | 70812.0 |
| 2008-08-21 08:45:00 | AAPL | Stock | 6.2454 | 6.2454 | 6.2446 | 6.2446 | 8400.0 |
| 2008-08-21 08:50:00 | AAPL | Stock | 6.245 | 6.245 | 6.2364 | 6.2371 | 378140.0 |
| 2008-08-21 08:55:00 | AAPL | Stock | 6.2375 | 6.2436 | 6.2375 | 6.2396 | 40264.0 |
| 2008-08-21 09:00:00 | AAPL | Stock | 6.2411 | 6.2411 | 6.2289 | 6.2321 | 412776.0 |
| 2008-08-21 09:05:00 | AAPL | Stock | 6.23 | 6.2357 | 6.23 | 6.2336 | 67480.0 |
| 2008-08-21 09:10:00 | AAPL | Stock | 6.2386 | 6.2386 | 6.2239 | 6.2275 | 295680.0 |
| 2008-08-21 09:15:00 | AAPL | Stock | 6.2282 | 6.2329 | 6.2279 | 6.2307 | 66920.0 |
| 2008-08-21 09:20:00 | AAPL | Stock | 6.2329 | 6.2407 | 6.2329 | 6.2339 | 78680.0 |
| 2008-08-21 09:25:00 | AAPL | Stock | 6.2386 | 6.2429 | 6.2304 | 6.2311 | 1325800.0 |
| 2008-08-21 09:30:00 | AAPL | Stock | 6.2304 | 6.2504 | 6.2182 | 6.2399 | 15782116.0 |
| 2008-08-21 09:35:00 | AAPL | Stock | 6.2386 | 6.2446 | 6.1704 | 6.2268 | 13306580.0 |
| 2008-08-21 09:40:00 | AAPL | Stock | 6.2275 | 6.2371 | 6.1946 | 6.1961 | 14655620.0 |
| 2008-08-21 09:45:00 | AAPL | Stock | 6.1964 | 6.2286 | 6.1944 | 6.2114 | 13581484.0 |
| 2008-08-21 09:50:00 | AAPL | Stock | 6.2129 | 6.2389 | 6.2121 | 6.2382 | 9670444.0 |
| 2008-08-21 09:55:00 | AAPL | Stock | 6.2379 | 6.2571 | 6.2304 | 6.2471 | 11829020.0 |
| 2008-08-21 10:00:00 | AAPL | Stock | 6.2475 | 6.2661 | 6.2325 | 6.2389 | 13219360.0 |
| 2008-08-21 10:05:00 | AAPL | Stock | 6.2393 | 6.2493 | 6.2186 | 6.2211 | 10774316.0 |
| 2008-08-21 10:10:00 | AAPL | Stock | 6.2214 | 6.2279 | 6.2079 | 6.2143 | 10924788.0 |
| 2008-08-21 10:15:00 | AAPL | Stock | 6.2168 | 6.2311 | 6.2107 | 6.22 | 6488300.0 |
| 2008-08-21 10:20:00 | AAPL | Stock | 6.2204 | 6.225 | 6.2025 | 6.2025 | 9443784.0 |
| 2008-08-21 10:25:00 | AAPL | Stock | 6.2025 | 6.2071 | 6.1864 | 6.1929 | 10041248.0 |
| 2008-08-21 10:30:00 | AAPL | Stock | 6.1932 | 6.1964 | 6.1746 | 6.1811 | 11668132.0 |
| 2008-08-21 10:35:00 | AAPL | Stock | 6.1807 | 6.1929 | 6.175 | 6.1857 | 11096288.0 |
| 2008-08-21 10:40:00 | AAPL | Stock | 6.1861 | 6.1889 | 6.1536 | 6.1564 | 13465984.0 |
| 2008-08-21 10:45:00 | AAPL | Stock | 6.1564 | 6.1689 | 6.1536 | 6.165 | 7792512.0 |
| 2008-08-21 10:50:00 | AAPL | Stock | 6.1654 | 6.1707 | 6.1493 | 6.159 | 7700308.0 |
| 2008-08-21 10:55:00 | AAPL | Stock | 6.1595 | 6.1764 | 6.1554 | 6.1668 | 6957664.0 |
| 2008-08-21 11:00:00 | AAPL | Stock | 6.1675 | 6.1682 | 6.1536 | 6.1568 | 7747432.0 |
| 2008-08-21 11:05:00 | AAPL | Stock | 6.1568 | 6.1571 | 6.1389 | 6.1448 | 10755640.0 |
| 2008-08-21 11:10:00 | AAPL | Stock | 6.1454 | 6.1607 | 6.1454 | 6.1464 | 6372296.0 |
| 2008-08-21 11:15:00 | AAPL | Stock | 6.1464 | 6.1607 | 6.1389 | 6.1575 | 6727252.0 |
| 2008-08-21 11:20:00 | AAPL | Stock | 6.1571 | 6.1618 | 6.1518 | 6.1525 | 4439176.0 |
| 2008-08-21 11:25:00 | AAPL | Stock | 6.1525 | 6.1721 | 6.1518 | 6.1714 | 8162392.0 |
| 2008-08-21 11:30:00 | AAPL | Stock | 6.1718 | 6.1757 | 6.1611 | 6.1689 | 4970028.0 |
| 2008-08-21 11:35:00 | AAPL | Stock | 6.1689 | 6.1711 | 6.1561 | 6.1586 | 4328520.0 |
> showing 50 of 303,317 rows — these rows as CSV