PREVIEW / stock_5min / 2010-05-12
file: by_date/stock_5min/2010/2010-05-12.parquet size: 5.0 MB rows: 345,084 symbols: 3,494
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-12 04:20:00 | AAPL | Stock | 9.1614 | 9.1614 | 9.1614 | 9.1614 | 2800.0 |
| 2010-05-12 04:25:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 13580.0 |
| 2010-05-12 04:40:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 2800.0 |
| 2010-05-12 04:45:00 | AAPL | Stock | 9.1518 | 9.1518 | 9.1518 | 9.1518 | 2800.0 |
| 2010-05-12 05:10:00 | AAPL | Stock | 9.1607 | 9.1607 | 9.1607 | 9.1607 | 5600.0 |
| 2010-05-12 05:45:00 | AAPL | Stock | 9.1607 | 9.1607 | 9.1525 | 9.1525 | 6972.0 |
| 2010-05-12 05:55:00 | AAPL | Stock | 9.1821 | 9.1821 | 9.1821 | 9.1821 | 4172.0 |
| 2010-05-12 06:40:00 | AAPL | Stock | 9.1871 | 9.1871 | 9.1871 | 9.1871 | 2800.0 |
| 2010-05-12 07:00:00 | AAPL | Stock | 9.1836 | 9.1836 | 9.1836 | 9.1836 | 5600.0 |
| 2010-05-12 07:05:00 | AAPL | Stock | 9.1839 | 9.1839 | 9.1786 | 9.1839 | 16800.0 |
| 2010-05-12 07:15:00 | AAPL | Stock | 9.1875 | 9.1918 | 9.1839 | 9.1889 | 65520.0 |
| 2010-05-12 07:20:00 | AAPL | Stock | 9.1843 | 9.1896 | 9.1768 | 9.1857 | 39200.0 |
| 2010-05-12 07:25:00 | AAPL | Stock | 9.1886 | 9.2071 | 9.1879 | 9.1961 | 253064.0 |
| 2010-05-12 07:30:00 | AAPL | Stock | 9.1964 | 9.2161 | 9.1964 | 9.2071 | 153524.0 |
| 2010-05-12 07:35:00 | AAPL | Stock | 9.2114 | 9.2143 | 9.2089 | 9.2143 | 27720.0 |
| 2010-05-12 07:40:00 | AAPL | Stock | 9.2071 | 9.2107 | 9.2061 | 9.2089 | 55300.0 |
| 2010-05-12 07:45:00 | AAPL | Stock | 9.2061 | 9.2086 | 9.2061 | 9.2086 | 5600.0 |
| 2010-05-12 07:50:00 | AAPL | Stock | 9.2118 | 9.2429 | 9.2107 | 9.2429 | 242620.0 |
| 2010-05-12 07:55:00 | AAPL | Stock | 9.2321 | 9.2411 | 9.2146 | 9.2321 | 172060.0 |
| 2010-05-12 08:00:00 | AAPL | Stock | 9.2293 | 9.2325 | 9.2143 | 9.2282 | 465556.0 |
| 2010-05-12 08:05:00 | AAPL | Stock | 9.225 | 9.2275 | 9.2093 | 9.2132 | 382508.0 |
| 2010-05-12 08:10:00 | AAPL | Stock | 9.2084 | 9.2207 | 9.2079 | 9.2164 | 238140.0 |
| 2010-05-12 08:15:00 | AAPL | Stock | 9.2196 | 9.2204 | 9.2146 | 9.2204 | 101640.0 |
| 2010-05-12 08:20:00 | AAPL | Stock | 9.2214 | 9.2271 | 9.2204 | 9.225 | 474404.0 |
| 2010-05-12 08:25:00 | AAPL | Stock | 9.225 | 9.2314 | 9.2218 | 9.2243 | 623616.0 |
| 2010-05-12 08:30:00 | AAPL | Stock | 9.2286 | 9.2296 | 9.2245 | 9.2286 | 199360.0 |
| 2010-05-12 08:35:00 | AAPL | Stock | 9.2286 | 9.2332 | 9.2196 | 9.2225 | 629076.0 |
| 2010-05-12 08:40:00 | AAPL | Stock | 9.2204 | 9.225 | 9.2189 | 9.2246 | 150052.0 |
| 2010-05-12 08:45:00 | AAPL | Stock | 9.2257 | 9.2429 | 9.2246 | 9.2429 | 841820.0 |
| 2010-05-12 08:50:00 | AAPL | Stock | 9.2464 | 9.2482 | 9.2179 | 9.2275 | 858592.0 |
| 2010-05-12 08:55:00 | AAPL | Stock | 9.2275 | 9.2443 | 9.2275 | 9.2357 | 777756.0 |
| 2010-05-12 09:00:00 | AAPL | Stock | 9.2361 | 9.2386 | 9.2268 | 9.2343 | 428848.0 |
| 2010-05-12 09:05:00 | AAPL | Stock | 9.2336 | 9.2379 | 9.2286 | 9.2379 | 418040.0 |
| 2010-05-12 09:10:00 | AAPL | Stock | 9.2379 | 9.2457 | 9.2379 | 9.2407 | 760340.0 |
| 2010-05-12 09:15:00 | AAPL | Stock | 9.2414 | 9.2418 | 9.2368 | 9.2389 | 106596.0 |
| 2010-05-12 09:20:00 | AAPL | Stock | 9.2404 | 9.2418 | 9.2386 | 9.2418 | 71876.0 |
| 2010-05-12 09:25:00 | AAPL | Stock | 9.2414 | 9.2646 | 9.2362 | 9.2529 | 855008.0 |
| 2010-05-12 09:30:00 | AAPL | Stock | 9.2496 | 9.2782 | 9.2393 | 9.2532 | 23433256.0 |
| 2010-05-12 09:35:00 | AAPL | Stock | 9.2561 | 9.3436 | 9.25 | 9.3332 | 30603104.0 |
| 2010-05-12 09:40:00 | AAPL | Stock | 9.3311 | 9.3411 | 9.3 | 9.322 | 18447940.0 |
| 2010-05-12 09:45:00 | AAPL | Stock | 9.3207 | 9.3343 | 9.3068 | 9.3236 | 11592672.0 |
| 2010-05-12 09:50:00 | AAPL | Stock | 9.32 | 9.3389 | 9.3096 | 9.3179 | 12185152.0 |
| 2010-05-12 09:55:00 | AAPL | Stock | 9.3179 | 9.3493 | 9.3089 | 9.3393 | 15424192.0 |
| 2010-05-12 10:00:00 | AAPL | Stock | 9.3389 | 9.3464 | 9.3257 | 9.3464 | 10907680.0 |
| 2010-05-12 10:05:00 | AAPL | Stock | 9.3464 | 9.355 | 9.335 | 9.3534 | 12806192.0 |
| 2010-05-12 10:10:00 | AAPL | Stock | 9.3521 | 9.3543 | 9.3357 | 9.3504 | 7725368.0 |
| 2010-05-12 10:15:00 | AAPL | Stock | 9.3507 | 9.3554 | 9.3361 | 9.34 | 9507148.0 |
| 2010-05-12 10:20:00 | AAPL | Stock | 9.3414 | 9.3507 | 9.3361 | 9.3461 | 7652652.0 |
| 2010-05-12 10:25:00 | AAPL | Stock | 9.3454 | 9.3675 | 9.3375 | 9.3639 | 12917772.0 |
| 2010-05-12 10:30:00 | AAPL | Stock | 9.3625 | 9.3882 | 9.3586 | 9.3721 | 18965604.0 |
> showing 50 of 345,084 rows — these rows as CSV