PREVIEW / stock_5min / 2006-06-02
file: by_date/stock_5min/2006/2006-06-02.parquet size: 3.1 MB rows: 228,230 symbols: 2,265
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-02 08:00:00 | AAPL | Stock | 2.2279 | 2.2279 | 2.2246 | 2.2246 | 28000.0 |
| 2006-06-02 08:05:00 | AAPL | Stock | 2.2246 | 2.2304 | 2.2246 | 2.2286 | 196952.0 |
| 2006-06-02 08:10:00 | AAPL | Stock | 2.2286 | 2.2307 | 2.2286 | 2.2289 | 232400.0 |
| 2006-06-02 08:15:00 | AAPL | Stock | 2.2296 | 2.2296 | 2.2279 | 2.2293 | 53200.0 |
| 2006-06-02 08:20:00 | AAPL | Stock | 2.2289 | 2.2289 | 2.225 | 2.225 | 242368.0 |
| 2006-06-02 08:25:00 | AAPL | Stock | 2.225 | 2.2268 | 2.2232 | 2.225 | 76384.0 |
| 2006-06-02 08:30:00 | AAPL | Stock | 2.2268 | 2.2407 | 2.2268 | 2.2404 | 1090376.0 |
| 2006-06-02 08:35:00 | AAPL | Stock | 2.2393 | 2.2407 | 2.2375 | 2.2393 | 552356.0 |
| 2006-06-02 08:40:00 | AAPL | Stock | 2.2382 | 2.2393 | 2.2375 | 2.2393 | 264600.0 |
| 2006-06-02 08:45:00 | AAPL | Stock | 2.2396 | 2.24 | 2.2364 | 2.24 | 298788.0 |
| 2006-06-02 08:50:00 | AAPL | Stock | 2.2404 | 2.2429 | 2.2393 | 2.2404 | 442344.0 |
| 2006-06-02 08:55:00 | AAPL | Stock | 2.2404 | 2.2421 | 2.2393 | 2.2421 | 254800.0 |
| 2006-06-02 09:00:00 | AAPL | Stock | 2.2421 | 2.2446 | 2.2414 | 2.2425 | 343084.0 |
| 2006-06-02 09:05:00 | AAPL | Stock | 2.2429 | 2.2446 | 2.24 | 2.2429 | 246456.0 |
| 2006-06-02 09:10:00 | AAPL | Stock | 2.2429 | 2.2464 | 2.2429 | 2.2464 | 646352.0 |
| 2006-06-02 09:15:00 | AAPL | Stock | 2.2461 | 2.2475 | 2.2429 | 2.2475 | 25200.0 |
| 2006-06-02 09:20:00 | AAPL | Stock | 2.2475 | 2.2475 | 2.2446 | 2.2446 | 372512.0 |
| 2006-06-02 09:25:00 | AAPL | Stock | 2.2429 | 2.2511 | 2.2389 | 2.2511 | 1440992.0 |
| 2006-06-02 09:30:00 | AAPL | Stock | 2.2496 | 2.2536 | 2.24 | 2.2414 | 26831252.0 |
| 2006-06-02 09:35:00 | AAPL | Stock | 2.2407 | 2.2475 | 2.2246 | 2.2296 | 23965452.0 |
| 2006-06-02 09:40:00 | AAPL | Stock | 2.2296 | 2.2314 | 2.2161 | 2.2229 | 22746948.0 |
| 2006-06-02 09:45:00 | AAPL | Stock | 2.2225 | 2.2336 | 2.2204 | 2.2282 | 16478756.0 |
| 2006-06-02 09:50:00 | AAPL | Stock | 2.2282 | 2.23 | 2.2175 | 2.2179 | 11251688.0 |
| 2006-06-02 09:55:00 | AAPL | Stock | 2.2179 | 2.2179 | 2.2004 | 2.2064 | 26212284.0 |
| 2006-06-02 10:00:00 | AAPL | Stock | 2.2061 | 2.2186 | 2.2018 | 2.2171 | 15577632.0 |
| 2006-06-02 10:05:00 | AAPL | Stock | 2.2171 | 2.2271 | 2.2121 | 2.225 | 16943892.0 |
| 2006-06-02 10:10:00 | AAPL | Stock | 2.225 | 2.2286 | 2.2139 | 2.2139 | 16223956.0 |
| 2006-06-02 10:15:00 | AAPL | Stock | 2.2143 | 2.2182 | 2.2082 | 2.2114 | 13429108.0 |
| 2006-06-02 10:20:00 | AAPL | Stock | 2.2125 | 2.2161 | 2.2096 | 2.2104 | 7712992.0 |
| 2006-06-02 10:25:00 | AAPL | Stock | 2.2104 | 2.2179 | 2.2096 | 2.2175 | 9369612.0 |
| 2006-06-02 10:30:00 | AAPL | Stock | 2.2175 | 2.2246 | 2.2161 | 2.2211 | 9291996.0 |
| 2006-06-02 10:35:00 | AAPL | Stock | 2.2211 | 2.2211 | 2.2114 | 2.215 | 8676220.0 |
| 2006-06-02 10:40:00 | AAPL | Stock | 2.2154 | 2.2211 | 2.2146 | 2.2186 | 6803188.0 |
| 2006-06-02 10:45:00 | AAPL | Stock | 2.2182 | 2.225 | 2.2179 | 2.2182 | 9307312.0 |
| 2006-06-02 10:50:00 | AAPL | Stock | 2.2182 | 2.2193 | 2.2146 | 2.2179 | 5312804.0 |
| 2006-06-02 10:55:00 | AAPL | Stock | 2.2175 | 2.2186 | 2.2107 | 2.2132 | 7158424.0 |
| 2006-06-02 11:00:00 | AAPL | Stock | 2.2132 | 2.215 | 2.2107 | 2.2111 | 3587192.0 |
| 2006-06-02 11:05:00 | AAPL | Stock | 2.2111 | 2.2111 | 2.2036 | 2.2111 | 10938648.0 |
| 2006-06-02 11:10:00 | AAPL | Stock | 2.2107 | 2.2136 | 2.2082 | 2.21 | 4580800.0 |
| 2006-06-02 11:15:00 | AAPL | Stock | 2.2096 | 2.2113 | 2.2068 | 2.2068 | 6954696.0 |
| 2006-06-02 11:20:00 | AAPL | Stock | 2.2064 | 2.2468 | 2.2057 | 2.2096 | 4520656.0 |
| 2006-06-02 11:25:00 | AAPL | Stock | 2.21 | 2.2104 | 2.2 | 2.2029 | 11130112.0 |
| 2006-06-02 11:30:00 | AAPL | Stock | 2.2025 | 2.2046 | 2.1946 | 2.1946 | 11947712.0 |
| 2006-06-02 11:35:00 | AAPL | Stock | 2.1946 | 2.1975 | 2.19 | 2.1925 | 13452068.0 |
| 2006-06-02 11:40:00 | AAPL | Stock | 2.1925 | 2.1929 | 2.1796 | 2.185 | 17713556.0 |
| 2006-06-02 11:45:00 | AAPL | Stock | 2.185 | 2.1879 | 2.1814 | 2.1864 | 16616516.0 |
| 2006-06-02 11:50:00 | AAPL | Stock | 2.1864 | 2.1893 | 2.1811 | 2.1878 | 10245928.0 |
| 2006-06-02 11:55:00 | AAPL | Stock | 2.1879 | 2.1893 | 2.1836 | 2.1864 | 6621580.0 |
| 2006-06-02 12:00:00 | AAPL | Stock | 2.185 | 2.1921 | 2.1818 | 2.1868 | 6055980.0 |
| 2006-06-02 12:05:00 | AAPL | Stock | 2.1864 | 2.1946 | 2.1861 | 2.1946 | 5768896.0 |
> showing 50 of 228,230 rows — these rows as CSV