PREVIEW / stock_5min / 2009-03-02
file: by_date/stock_5min/2009/2009-03-02.parquet size: 4.6 MB rows: 320,883 symbols: 3,354
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-02 07:20:00 | AAPL | Stock | 3.1214 | 3.1279 | 3.1214 | 3.1279 | 33600.0 |
| 2009-03-02 07:25:00 | AAPL | Stock | 3.1214 | 3.1214 | 3.1214 | 3.1214 | 5600.0 |
| 2009-03-02 07:45:00 | AAPL | Stock | 3.1214 | 3.1214 | 3.1214 | 3.1214 | 8400.0 |
| 2009-03-02 07:50:00 | AAPL | Stock | 3.1314 | 3.1314 | 3.1314 | 3.1314 | 18900.0 |
| 2009-03-02 08:00:00 | AAPL | Stock | 3.1314 | 3.1429 | 3.1311 | 3.1339 | 93940.0 |
| 2009-03-02 08:05:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1386 | 3.1429 | 40040.0 |
| 2009-03-02 08:10:00 | AAPL | Stock | 3.1429 | 3.1429 | 3.1404 | 3.1429 | 67872.0 |
| 2009-03-02 08:15:00 | AAPL | Stock | 3.1446 | 3.1446 | 3.1446 | 3.1446 | 2800.0 |
| 2009-03-02 08:20:00 | AAPL | Stock | 3.1482 | 3.1482 | 3.1414 | 3.1439 | 77560.0 |
| 2009-03-02 08:25:00 | AAPL | Stock | 3.1443 | 3.1443 | 3.1393 | 3.1411 | 115696.0 |
| 2009-03-02 08:30:00 | AAPL | Stock | 3.1407 | 3.1429 | 3.1343 | 3.1418 | 182308.0 |
| 2009-03-02 08:35:00 | AAPL | Stock | 3.1418 | 3.1464 | 3.1379 | 3.1464 | 71456.0 |
| 2009-03-02 08:40:00 | AAPL | Stock | 3.1475 | 3.1475 | 3.1429 | 3.1475 | 61600.0 |
| 2009-03-02 08:45:00 | AAPL | Stock | 3.1429 | 3.1468 | 3.1429 | 3.1432 | 25200.0 |
| 2009-03-02 08:50:00 | AAPL | Stock | 3.1461 | 3.1471 | 3.1461 | 3.1464 | 14000.0 |
| 2009-03-02 08:55:00 | AAPL | Stock | 3.1475 | 3.1489 | 3.1475 | 3.1486 | 88480.0 |
| 2009-03-02 09:00:00 | AAPL | Stock | 3.1489 | 3.1489 | 3.1489 | 3.1489 | 66332.0 |
| 2009-03-02 09:05:00 | AAPL | Stock | 3.1475 | 3.1475 | 3.1464 | 3.1475 | 22120.0 |
| 2009-03-02 09:10:00 | AAPL | Stock | 3.1475 | 3.15 | 3.1475 | 3.15 | 111216.0 |
| 2009-03-02 09:15:00 | AAPL | Stock | 3.1554 | 3.1554 | 3.1432 | 3.1432 | 140644.0 |
| 2009-03-02 09:20:00 | AAPL | Stock | 3.1446 | 3.1532 | 3.1446 | 3.1529 | 143640.0 |
| 2009-03-02 09:25:00 | AAPL | Stock | 3.1525 | 3.1693 | 3.1429 | 3.1429 | 451500.0 |
| 2009-03-02 09:30:00 | AAPL | Stock | 3.1486 | 3.2107 | 3.1357 | 3.1793 | 20185396.0 |
| 2009-03-02 09:35:00 | AAPL | Stock | 3.18 | 3.2052 | 3.1789 | 3.2011 | 13976312.0 |
| 2009-03-02 09:40:00 | AAPL | Stock | 3.2011 | 3.2246 | 3.2007 | 3.2132 | 20134940.0 |
| 2009-03-02 09:45:00 | AAPL | Stock | 3.2136 | 3.2429 | 3.2114 | 3.2382 | 15383620.0 |
| 2009-03-02 09:50:00 | AAPL | Stock | 3.2382 | 3.2571 | 3.2361 | 3.2482 | 18487784.0 |
| 2009-03-02 09:55:00 | AAPL | Stock | 3.2486 | 3.2521 | 3.2279 | 3.2321 | 12266716.0 |
| 2009-03-02 10:00:00 | AAPL | Stock | 3.2311 | 3.2486 | 3.2232 | 3.2286 | 11919544.0 |
| 2009-03-02 10:05:00 | AAPL | Stock | 3.2286 | 3.2389 | 3.2193 | 3.2325 | 9901024.0 |
| 2009-03-02 10:10:00 | AAPL | Stock | 3.2329 | 3.2393 | 3.1993 | 3.2014 | 12591796.0 |
| 2009-03-02 10:15:00 | AAPL | Stock | 3.2011 | 3.2114 | 3.2 | 3.2039 | 10915240.0 |
| 2009-03-02 10:20:00 | AAPL | Stock | 3.2043 | 3.2186 | 3.1989 | 3.2171 | 9494128.0 |
| 2009-03-02 10:25:00 | AAPL | Stock | 3.2168 | 3.2211 | 3.2111 | 3.2169 | 7093660.0 |
| 2009-03-02 10:30:00 | AAPL | Stock | 3.2171 | 3.2236 | 3.2089 | 3.2214 | 5884536.0 |
| 2009-03-02 10:35:00 | AAPL | Stock | 3.2215 | 3.2296 | 3.2107 | 3.2129 | 6838748.0 |
| 2009-03-02 10:40:00 | AAPL | Stock | 3.2125 | 3.2125 | 3.1964 | 3.2061 | 10829420.0 |
| 2009-03-02 10:45:00 | AAPL | Stock | 3.2068 | 3.2107 | 3.2029 | 3.2057 | 4874576.0 |
| 2009-03-02 10:50:00 | AAPL | Stock | 3.2054 | 3.2071 | 3.1957 | 3.1975 | 5250420.0 |
| 2009-03-02 10:55:00 | AAPL | Stock | 3.1971 | 3.2068 | 3.195 | 3.1982 | 7329728.0 |
| 2009-03-02 11:00:00 | AAPL | Stock | 3.1982 | 3.2064 | 3.1975 | 3.2061 | 8040396.0 |
| 2009-03-02 11:05:00 | AAPL | Stock | 3.2057 | 3.2068 | 3.1936 | 3.2057 | 8623020.0 |
| 2009-03-02 11:10:00 | AAPL | Stock | 3.2054 | 3.2168 | 3.1607 | 3.2164 | 10308200.0 |
| 2009-03-02 11:15:00 | AAPL | Stock | 3.2168 | 3.2304 | 3.2146 | 3.2304 | 11557028.0 |
| 2009-03-02 11:20:00 | AAPL | Stock | 3.2293 | 3.2411 | 3.2286 | 3.2332 | 10125332.0 |
| 2009-03-02 11:25:00 | AAPL | Stock | 3.2329 | 3.2354 | 3.2154 | 3.2179 | 8963864.0 |
| 2009-03-02 11:30:00 | AAPL | Stock | 3.2186 | 3.2232 | 3.2107 | 3.2132 | 8608292.0 |
| 2009-03-02 11:35:00 | AAPL | Stock | 3.2132 | 3.2143 | 3.1429 | 3.2021 | 12669944.0 |
| 2009-03-02 11:40:00 | AAPL | Stock | 3.2018 | 3.2125 | 3.195 | 3.1964 | 7600992.0 |
| 2009-03-02 11:45:00 | AAPL | Stock | 3.1968 | 3.1989 | 3.1811 | 3.1857 | 7268968.0 |
> showing 50 of 320,883 rows — these rows as CSV