PREVIEW / stock_5min / 2010-02-22
file: by_date/stock_5min/2010/2010-02-22.parquet size: 4.6 MB rows: 318,069 symbols: 3,472
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-02-22 04:15:00 | AAPL | Stock | 7.21 | 7.21 | 7.21 | 7.21 | 3752.0 |
| 2010-02-22 07:00:00 | AAPL | Stock | 7.2021 | 7.2225 | 7.2021 | 7.2225 | 5600.0 |
| 2010-02-22 07:05:00 | AAPL | Stock | 7.2214 | 7.2214 | 7.2214 | 7.2214 | 2800.0 |
| 2010-02-22 07:15:00 | AAPL | Stock | 7.2171 | 7.2171 | 7.2171 | 7.2171 | 5600.0 |
| 2010-02-22 07:20:00 | AAPL | Stock | 7.2225 | 7.225 | 7.2179 | 7.2179 | 53200.0 |
| 2010-02-22 07:25:00 | AAPL | Stock | 7.2182 | 7.2182 | 7.2143 | 7.2143 | 6104.0 |
| 2010-02-22 07:40:00 | AAPL | Stock | 7.2171 | 7.2175 | 7.2171 | 7.2175 | 19600.0 |
| 2010-02-22 08:00:00 | AAPL | Stock | 7.2214 | 7.2279 | 7.2214 | 7.2279 | 113904.0 |
| 2010-02-22 08:05:00 | AAPL | Stock | 7.2279 | 7.2339 | 7.2279 | 7.2339 | 171752.0 |
| 2010-02-22 08:10:00 | AAPL | Stock | 7.2357 | 7.2364 | 7.2339 | 7.2339 | 84840.0 |
| 2010-02-22 08:15:00 | AAPL | Stock | 7.2329 | 7.2329 | 7.2261 | 7.2261 | 181300.0 |
| 2010-02-22 08:20:00 | AAPL | Stock | 7.2261 | 7.2293 | 7.2193 | 7.225 | 140280.0 |
| 2010-02-22 08:25:00 | AAPL | Stock | 7.225 | 7.2293 | 7.225 | 7.2293 | 75012.0 |
| 2010-02-22 08:30:00 | AAPL | Stock | 7.2268 | 7.2286 | 7.225 | 7.225 | 213640.0 |
| 2010-02-22 08:35:00 | AAPL | Stock | 7.2275 | 7.2286 | 7.2268 | 7.2268 | 63000.0 |
| 2010-02-22 08:40:00 | AAPL | Stock | 7.2275 | 7.2286 | 7.2214 | 7.2229 | 140840.0 |
| 2010-02-22 08:45:00 | AAPL | Stock | 7.2229 | 7.2232 | 7.2218 | 7.2232 | 47600.0 |
| 2010-02-22 08:50:00 | AAPL | Stock | 7.2246 | 7.2261 | 7.2204 | 7.2229 | 106400.0 |
| 2010-02-22 08:55:00 | AAPL | Stock | 7.2229 | 7.2229 | 7.2193 | 7.2214 | 25200.0 |
| 2010-02-22 09:00:00 | AAPL | Stock | 7.2211 | 7.2211 | 7.2211 | 7.2211 | 11200.0 |
| 2010-02-22 09:05:00 | AAPL | Stock | 7.2214 | 7.2234 | 7.2196 | 7.2234 | 65744.0 |
| 2010-02-22 09:10:00 | AAPL | Stock | 7.2229 | 7.2239 | 7.2229 | 7.2239 | 10948.0 |
| 2010-02-22 09:15:00 | AAPL | Stock | 7.2236 | 7.2246 | 7.2204 | 7.2225 | 92344.0 |
| 2010-02-22 09:20:00 | AAPL | Stock | 7.2246 | 7.2275 | 7.2229 | 7.2275 | 477400.0 |
| 2010-02-22 09:25:00 | AAPL | Stock | 7.2275 | 7.2321 | 7.2132 | 7.2279 | 838180.0 |
| 2010-02-22 09:30:00 | AAPL | Stock | 7.2268 | 7.2321 | 7.2021 | 7.2243 | 17424316.0 |
| 2010-02-22 09:35:00 | AAPL | Stock | 7.225 | 7.2257 | 7.2018 | 7.205 | 8029784.0 |
| 2010-02-22 09:40:00 | AAPL | Stock | 7.205 | 7.2086 | 7.1868 | 7.1946 | 12714100.0 |
| 2010-02-22 09:45:00 | AAPL | Stock | 7.1954 | 7.1996 | 7.1682 | 7.1696 | 10105256.0 |
| 2010-02-22 09:50:00 | AAPL | Stock | 7.17 | 7.1711 | 7.1289 | 7.1507 | 27816992.0 |
| 2010-02-22 09:55:00 | AAPL | Stock | 7.1511 | 7.1589 | 7.1429 | 7.1511 | 10325952.0 |
| 2010-02-22 10:00:00 | AAPL | Stock | 7.1511 | 7.1521 | 7.1304 | 7.1425 | 14100016.0 |
| 2010-02-22 10:05:00 | AAPL | Stock | 7.1425 | 7.1482 | 7.1339 | 7.135 | 8699040.0 |
| 2010-02-22 10:10:00 | AAPL | Stock | 7.135 | 7.1479 | 7.1339 | 7.14 | 6479508.0 |
| 2010-02-22 10:15:00 | AAPL | Stock | 7.14 | 7.1539 | 7.1379 | 7.1439 | 6502384.0 |
| 2010-02-22 10:20:00 | AAPL | Stock | 7.1439 | 7.1507 | 7.1429 | 7.1443 | 6732628.0 |
| 2010-02-22 10:25:00 | AAPL | Stock | 7.145 | 7.1461 | 7.1379 | 7.1425 | 4406024.0 |
| 2010-02-22 10:30:00 | AAPL | Stock | 7.1425 | 7.1496 | 7.1404 | 7.1457 | 6378428.0 |
| 2010-02-22 10:35:00 | AAPL | Stock | 7.1446 | 7.1618 | 7.1354 | 7.1607 | 8833636.0 |
| 2010-02-22 10:40:00 | AAPL | Stock | 7.1611 | 7.1664 | 7.1536 | 7.1554 | 6750828.0 |
| 2010-02-22 10:45:00 | AAPL | Stock | 7.1568 | 7.1596 | 7.1464 | 7.1482 | 3604524.0 |
| 2010-02-22 10:50:00 | AAPL | Stock | 7.1479 | 7.1525 | 7.1432 | 7.15 | 2350152.0 |
| 2010-02-22 10:55:00 | AAPL | Stock | 7.1507 | 7.1529 | 7.1432 | 7.1443 | 2703008.0 |
| 2010-02-22 11:00:00 | AAPL | Stock | 7.1439 | 7.1474 | 7.1432 | 7.1443 | 2046660.0 |
| 2010-02-22 11:05:00 | AAPL | Stock | 7.1454 | 7.1464 | 7.1375 | 7.1414 | 4352768.0 |
| 2010-02-22 11:10:00 | AAPL | Stock | 7.1416 | 7.1425 | 7.1254 | 7.1282 | 5339796.0 |
| 2010-02-22 11:15:00 | AAPL | Stock | 7.1275 | 7.1407 | 7.125 | 7.1396 | 3774876.0 |
| 2010-02-22 11:20:00 | AAPL | Stock | 7.1393 | 7.1482 | 7.1393 | 7.1448 | 3086356.0 |
| 2010-02-22 11:25:00 | AAPL | Stock | 7.1443 | 7.1457 | 7.1354 | 7.1393 | 3722880.0 |
| 2010-02-22 11:30:00 | AAPL | Stock | 7.1388 | 7.1418 | 7.1339 | 7.1343 | 3081484.0 |
> showing 50 of 318,069 rows — these rows as CSV