PREVIEW / stock_5min / 2008-08-12
file: by_date/stock_5min/2008/2008-08-12.parquet size: 4.4 MB rows: 318,985 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-08-12 06:35:00 | AAPL | Stock | 6.18 | 6.18 | 6.18 | 6.18 | 5600.0 |
| 2008-08-12 06:50:00 | AAPL | Stock | 6.1854 | 6.1854 | 6.1854 | 6.1854 | 5600.0 |
| 2008-08-12 07:00:00 | AAPL | Stock | 6.2043 | 6.2043 | 6.2043 | 6.2043 | 12600.0 |
| 2008-08-12 07:05:00 | AAPL | Stock | 6.1961 | 6.1961 | 6.1961 | 6.1961 | 5600.0 |
| 2008-08-12 07:10:00 | AAPL | Stock | 6.1964 | 6.1964 | 6.1964 | 6.1964 | 8400.0 |
| 2008-08-12 07:15:00 | AAPL | Stock | 6.1993 | 6.1993 | 6.1789 | 6.1789 | 5600.0 |
| 2008-08-12 07:20:00 | AAPL | Stock | 6.2054 | 6.2286 | 6.2054 | 6.2286 | 36400.0 |
| 2008-08-12 07:25:00 | AAPL | Stock | 6.2307 | 6.2461 | 6.2282 | 6.2461 | 353052.0 |
| 2008-08-12 07:30:00 | AAPL | Stock | 6.2496 | 6.2546 | 6.2496 | 6.25 | 136164.0 |
| 2008-08-12 07:35:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 47740.0 |
| 2008-08-12 07:40:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 147112.0 |
| 2008-08-12 07:50:00 | AAPL | Stock | 6.2339 | 6.2343 | 6.2339 | 6.2343 | 64400.0 |
| 2008-08-12 07:55:00 | AAPL | Stock | 6.2339 | 6.2339 | 6.2339 | 6.2339 | 33600.0 |
| 2008-08-12 08:00:00 | AAPL | Stock | 6.2443 | 6.2443 | 6.2171 | 6.2171 | 408660.0 |
| 2008-08-12 08:05:00 | AAPL | Stock | 6.2196 | 6.2261 | 6.2196 | 6.2246 | 212940.0 |
| 2008-08-12 08:10:00 | AAPL | Stock | 6.2261 | 6.2289 | 6.2257 | 6.2289 | 18928.0 |
| 2008-08-12 08:15:00 | AAPL | Stock | 6.2304 | 6.2304 | 6.2207 | 6.2214 | 184632.0 |
| 2008-08-12 08:20:00 | AAPL | Stock | 6.2204 | 6.2207 | 6.2107 | 6.2143 | 262920.0 |
| 2008-08-12 08:25:00 | AAPL | Stock | 6.2107 | 6.2143 | 6.2043 | 6.2071 | 158900.0 |
| 2008-08-12 08:30:00 | AAPL | Stock | 6.2089 | 6.2246 | 6.2089 | 6.2236 | 219940.0 |
| 2008-08-12 08:35:00 | AAPL | Stock | 6.2193 | 6.2193 | 6.2089 | 6.2089 | 158648.0 |
| 2008-08-12 08:40:00 | AAPL | Stock | 6.2093 | 6.2121 | 6.2025 | 6.2075 | 117600.0 |
| 2008-08-12 08:45:00 | AAPL | Stock | 6.2046 | 6.2046 | 6.1896 | 6.1925 | 345800.0 |
| 2008-08-12 08:50:00 | AAPL | Stock | 6.1925 | 6.2 | 6.1875 | 6.1875 | 250292.0 |
| 2008-08-12 08:55:00 | AAPL | Stock | 6.1879 | 6.1893 | 6.1768 | 6.1875 | 314216.0 |
| 2008-08-12 09:00:00 | AAPL | Stock | 6.1825 | 6.1868 | 6.1746 | 6.1857 | 333284.0 |
| 2008-08-12 09:05:00 | AAPL | Stock | 6.1889 | 6.1943 | 6.1821 | 6.185 | 249816.0 |
| 2008-08-12 09:10:00 | AAPL | Stock | 6.1836 | 6.1839 | 6.1786 | 6.1804 | 80528.0 |
| 2008-08-12 09:15:00 | AAPL | Stock | 6.1789 | 6.1986 | 6.1746 | 6.1889 | 362460.0 |
| 2008-08-12 09:20:00 | AAPL | Stock | 6.1939 | 6.2125 | 6.1904 | 6.1932 | 496496.0 |
| 2008-08-12 09:25:00 | AAPL | Stock | 6.1932 | 6.2114 | 6.1875 | 6.1986 | 546840.0 |
| 2008-08-12 09:30:00 | AAPL | Stock | 6.1986 | 6.2564 | 6.1968 | 6.2482 | 24602508.0 |
| 2008-08-12 09:35:00 | AAPL | Stock | 6.2489 | 6.2893 | 6.2487 | 6.2611 | 30774800.0 |
| 2008-08-12 09:40:00 | AAPL | Stock | 6.2611 | 6.2782 | 6.2607 | 6.2743 | 16927456.0 |
| 2008-08-12 09:45:00 | AAPL | Stock | 6.2746 | 6.3036 | 6.2734 | 6.2804 | 22607732.0 |
| 2008-08-12 09:50:00 | AAPL | Stock | 6.2807 | 6.3171 | 6.2696 | 6.3054 | 19116776.0 |
| 2008-08-12 09:55:00 | AAPL | Stock | 6.3039 | 6.3214 | 6.2936 | 6.3125 | 18002348.0 |
| 2008-08-12 10:00:00 | AAPL | Stock | 6.3132 | 6.3554 | 6.3071 | 6.3524 | 22193948.0 |
| 2008-08-12 10:05:00 | AAPL | Stock | 6.3521 | 6.3732 | 6.3514 | 6.3621 | 25749528.0 |
| 2008-08-12 10:10:00 | AAPL | Stock | 6.3625 | 6.385 | 6.3482 | 6.3757 | 21211120.0 |
| 2008-08-12 10:15:00 | AAPL | Stock | 6.375 | 6.4032 | 6.3662 | 6.3964 | 24858848.0 |
| 2008-08-12 10:20:00 | AAPL | Stock | 6.3964 | 6.3992 | 6.3704 | 6.3725 | 16853452.0 |
| 2008-08-12 10:25:00 | AAPL | Stock | 6.3721 | 6.3786 | 6.325 | 6.3257 | 22522668.0 |
| 2008-08-12 10:30:00 | AAPL | Stock | 6.3246 | 6.3382 | 6.3139 | 6.3361 | 20848660.0 |
| 2008-08-12 10:35:00 | AAPL | Stock | 6.3369 | 6.3654 | 6.3357 | 6.3464 | 17151680.0 |
| 2008-08-12 10:40:00 | AAPL | Stock | 6.3471 | 6.3625 | 6.3421 | 6.3518 | 12300260.0 |
| 2008-08-12 10:45:00 | AAPL | Stock | 6.3518 | 6.3686 | 6.3504 | 6.3568 | 10422832.0 |
| 2008-08-12 10:50:00 | AAPL | Stock | 6.3568 | 6.3679 | 6.35 | 6.3579 | 7412692.0 |
| 2008-08-12 10:55:00 | AAPL | Stock | 6.3586 | 6.375 | 6.3586 | 6.3732 | 9381484.0 |
| 2008-08-12 11:00:00 | AAPL | Stock | 6.3736 | 6.3768 | 6.3575 | 6.3618 | 9452324.0 |
> showing 50 of 318,985 rows — these rows as CSV