PREVIEW / stock_5min / 2009-02-27
file: by_date/stock_5min/2009/2009-02-27.parquet size: 4.6 MB rows: 315,454 symbols: 3,333
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-02-27 07:15:00 | AAPL | Stock | 3.1518 | 3.1518 | 3.1429 | 3.1429 | 16800.0 |
| 2009-02-27 07:30:00 | AAPL | Stock | 3.1418 | 3.1418 | 3.1418 | 3.1418 | 26600.0 |
| 2009-02-27 08:00:00 | AAPL | Stock | 3.1493 | 3.1493 | 3.1336 | 3.1339 | 64400.0 |
| 2009-02-27 08:05:00 | AAPL | Stock | 3.1339 | 3.1429 | 3.1339 | 3.1429 | 34440.0 |
| 2009-02-27 08:10:00 | AAPL | Stock | 3.1368 | 3.1368 | 3.1368 | 3.1368 | 2800.0 |
| 2009-02-27 08:15:00 | AAPL | Stock | 3.1429 | 3.1446 | 3.1393 | 3.1393 | 20160.0 |
| 2009-02-27 08:20:00 | AAPL | Stock | 3.1357 | 3.1357 | 3.125 | 3.125 | 112112.0 |
| 2009-02-27 08:25:00 | AAPL | Stock | 3.125 | 3.1304 | 3.125 | 3.1268 | 68600.0 |
| 2009-02-27 08:30:00 | AAPL | Stock | 3.1279 | 3.1339 | 3.1268 | 3.1318 | 98224.0 |
| 2009-02-27 08:35:00 | AAPL | Stock | 3.1339 | 3.1339 | 3.1268 | 3.1268 | 92960.0 |
| 2009-02-27 08:40:00 | AAPL | Stock | 3.1268 | 3.1404 | 3.1268 | 3.1393 | 67200.0 |
| 2009-02-27 08:45:00 | AAPL | Stock | 3.1375 | 3.1486 | 3.1357 | 3.1482 | 293468.0 |
| 2009-02-27 08:50:00 | AAPL | Stock | 3.1461 | 3.15 | 3.1461 | 3.15 | 118244.0 |
| 2009-02-27 08:55:00 | AAPL | Stock | 3.1486 | 3.1486 | 3.1464 | 3.1482 | 87332.0 |
| 2009-02-27 09:00:00 | AAPL | Stock | 3.1471 | 3.1482 | 3.1468 | 3.1482 | 19040.0 |
| 2009-02-27 09:05:00 | AAPL | Stock | 3.1464 | 3.1464 | 3.1386 | 3.1404 | 136360.0 |
| 2009-02-27 09:10:00 | AAPL | Stock | 3.1411 | 3.1418 | 3.1357 | 3.1418 | 154700.0 |
| 2009-02-27 09:15:00 | AAPL | Stock | 3.1307 | 3.1386 | 3.1304 | 3.1386 | 58660.0 |
| 2009-02-27 09:20:00 | AAPL | Stock | 3.1386 | 3.1393 | 3.1339 | 3.1339 | 75600.0 |
| 2009-02-27 09:25:00 | AAPL | Stock | 3.135 | 3.1464 | 3.1346 | 3.1361 | 214872.0 |
| 2009-02-27 09:30:00 | AAPL | Stock | 3.1357 | 3.1764 | 3.1311 | 3.1321 | 14844928.0 |
| 2009-02-27 09:35:00 | AAPL | Stock | 3.1325 | 3.1821 | 3.1325 | 3.1482 | 18500664.0 |
| 2009-02-27 09:40:00 | AAPL | Stock | 3.1479 | 3.1889 | 3.14 | 3.1796 | 14216300.0 |
| 2009-02-27 09:45:00 | AAPL | Stock | 3.1796 | 3.2132 | 3.1793 | 3.2082 | 18729144.0 |
| 2009-02-27 09:50:00 | AAPL | Stock | 3.2079 | 3.2232 | 3.2068 | 3.2225 | 18432652.0 |
| 2009-02-27 09:55:00 | AAPL | Stock | 3.2221 | 3.2357 | 3.2154 | 3.2204 | 14952784.0 |
| 2009-02-27 10:00:00 | AAPL | Stock | 3.22 | 3.2314 | 3.2132 | 3.2261 | 11597124.0 |
| 2009-02-27 10:05:00 | AAPL | Stock | 3.2264 | 3.2339 | 3.1964 | 3.2 | 9260244.0 |
| 2009-02-27 10:10:00 | AAPL | Stock | 3.2 | 3.2168 | 3.1968 | 3.215 | 6950244.0 |
| 2009-02-27 10:15:00 | AAPL | Stock | 3.215 | 3.2286 | 3.2071 | 3.2279 | 8571780.0 |
| 2009-02-27 10:20:00 | AAPL | Stock | 3.2279 | 3.2554 | 3.2271 | 3.2504 | 15006628.0 |
| 2009-02-27 10:25:00 | AAPL | Stock | 3.2511 | 3.2607 | 3.2464 | 3.2464 | 11870600.0 |
| 2009-02-27 10:30:00 | AAPL | Stock | 3.2471 | 3.2482 | 3.2389 | 3.2393 | 7843920.0 |
| 2009-02-27 10:35:00 | AAPL | Stock | 3.2393 | 3.2393 | 3.22 | 3.2257 | 7584052.0 |
| 2009-02-27 10:40:00 | AAPL | Stock | 3.2271 | 3.2371 | 3.2186 | 3.2271 | 8231860.0 |
| 2009-02-27 10:45:00 | AAPL | Stock | 3.2271 | 3.2318 | 3.2125 | 3.2235 | 7539476.0 |
| 2009-02-27 10:50:00 | AAPL | Stock | 3.2235 | 3.2275 | 3.2093 | 3.2132 | 7522872.0 |
| 2009-02-27 10:55:00 | AAPL | Stock | 3.2129 | 3.2168 | 3.2043 | 3.2111 | 7670488.0 |
| 2009-02-27 11:00:00 | AAPL | Stock | 3.2107 | 3.2136 | 3.1964 | 3.2007 | 7883876.0 |
| 2009-02-27 11:05:00 | AAPL | Stock | 3.2004 | 3.2079 | 3.1975 | 3.2021 | 5984804.0 |
| 2009-02-27 11:10:00 | AAPL | Stock | 3.2018 | 3.2064 | 3.1889 | 3.1893 | 6963964.0 |
| 2009-02-27 11:15:00 | AAPL | Stock | 3.1882 | 3.1932 | 3.1821 | 3.1868 | 7991564.0 |
| 2009-02-27 11:20:00 | AAPL | Stock | 3.1868 | 3.1957 | 3.1839 | 3.1946 | 7755160.0 |
| 2009-02-27 11:25:00 | AAPL | Stock | 3.1946 | 3.2014 | 3.1871 | 3.1993 | 6440560.0 |
| 2009-02-27 11:30:00 | AAPL | Stock | 3.1993 | 3.2096 | 3.1957 | 3.1993 | 5957252.0 |
| 2009-02-27 11:35:00 | AAPL | Stock | 3.1996 | 3.2025 | 3.1921 | 3.2004 | 3062080.0 |
| 2009-02-27 11:40:00 | AAPL | Stock | 3.2014 | 3.2304 | 3.2004 | 3.2296 | 9317084.0 |
| 2009-02-27 11:45:00 | AAPL | Stock | 3.2293 | 3.2318 | 3.2232 | 3.2296 | 7300860.0 |
| 2009-02-27 11:50:00 | AAPL | Stock | 3.2296 | 3.235 | 3.2189 | 3.225 | 8072512.0 |
| 2009-02-27 11:55:00 | AAPL | Stock | 3.2243 | 3.2304 | 3.2132 | 3.2243 | 7273896.0 |
> showing 50 of 315,454 rows — these rows as CSV