PREVIEW / stock_5min / 2009-10-05
file: by_date/stock_5min/2009/2009-10-05.parquet size: 4.6 MB rows: 318,406 symbols: 3,385
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-10-05 04:50:00 | AAPL | Stock | 6.6393 | 6.6393 | 6.6393 | 6.6393 | 2800.0 |
| 2009-10-05 05:15:00 | AAPL | Stock | 6.6518 | 6.6518 | 6.6518 | 6.6518 | 2800.0 |
| 2009-10-05 07:00:00 | AAPL | Stock | 6.6511 | 6.6511 | 6.6511 | 6.6511 | 8400.0 |
| 2009-10-05 07:10:00 | AAPL | Stock | 6.6393 | 6.6393 | 6.6393 | 6.6393 | 10080.0 |
| 2009-10-05 07:30:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 43820.0 |
| 2009-10-05 07:35:00 | AAPL | Stock | 6.6518 | 6.6518 | 6.6386 | 6.6386 | 6972.0 |
| 2009-10-05 07:40:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 5600.0 |
| 2009-10-05 07:45:00 | AAPL | Stock | 6.6464 | 6.6486 | 6.6429 | 6.6429 | 33600.0 |
| 2009-10-05 07:50:00 | AAPL | Stock | 6.6429 | 6.6464 | 6.6429 | 6.6464 | 5600.0 |
| 2009-10-05 07:55:00 | AAPL | Stock | 6.6464 | 6.6571 | 6.6464 | 6.6571 | 112000.0 |
| 2009-10-05 08:00:00 | AAPL | Stock | 6.6571 | 6.6646 | 6.6539 | 6.6571 | 246120.0 |
| 2009-10-05 08:05:00 | AAPL | Stock | 6.6573 | 6.6643 | 6.6571 | 6.6643 | 118580.0 |
| 2009-10-05 08:10:00 | AAPL | Stock | 6.6643 | 6.6714 | 6.6607 | 6.6632 | 264432.0 |
| 2009-10-05 08:15:00 | AAPL | Stock | 6.6614 | 6.6686 | 6.6589 | 6.6686 | 307272.0 |
| 2009-10-05 08:20:00 | AAPL | Stock | 6.6679 | 6.6761 | 6.6654 | 6.6679 | 352072.0 |
| 2009-10-05 08:25:00 | AAPL | Stock | 6.6696 | 6.6718 | 6.665 | 6.6711 | 41440.0 |
| 2009-10-05 08:30:00 | AAPL | Stock | 6.6654 | 6.675 | 6.6646 | 6.6732 | 230552.0 |
| 2009-10-05 08:35:00 | AAPL | Stock | 6.6732 | 6.6732 | 6.6686 | 6.6707 | 87276.0 |
| 2009-10-05 08:40:00 | AAPL | Stock | 6.6714 | 6.6714 | 6.6654 | 6.6682 | 52248.0 |
| 2009-10-05 08:45:00 | AAPL | Stock | 6.6689 | 6.6707 | 6.6654 | 6.6654 | 147812.0 |
| 2009-10-05 08:50:00 | AAPL | Stock | 6.6675 | 6.6707 | 6.6607 | 6.6607 | 245476.0 |
| 2009-10-05 08:55:00 | AAPL | Stock | 6.6571 | 6.66 | 6.6561 | 6.6568 | 133560.0 |
| 2009-10-05 09:00:00 | AAPL | Stock | 6.6554 | 6.6607 | 6.6554 | 6.6604 | 55720.0 |
| 2009-10-05 09:05:00 | AAPL | Stock | 6.6589 | 6.6668 | 6.6589 | 6.6639 | 194880.0 |
| 2009-10-05 09:10:00 | AAPL | Stock | 6.6639 | 6.6639 | 6.6604 | 6.6607 | 42000.0 |
| 2009-10-05 09:15:00 | AAPL | Stock | 6.6636 | 6.6639 | 6.6582 | 6.6593 | 39200.0 |
| 2009-10-05 09:20:00 | AAPL | Stock | 6.6571 | 6.6604 | 6.6479 | 6.6518 | 222068.0 |
| 2009-10-05 09:25:00 | AAPL | Stock | 6.6518 | 6.6536 | 6.6454 | 6.6529 | 145628.0 |
| 2009-10-05 09:30:00 | AAPL | Stock | 6.6504 | 6.6536 | 6.6325 | 6.6432 | 15033060.0 |
| 2009-10-05 09:35:00 | AAPL | Stock | 6.6432 | 6.6454 | 6.6264 | 6.6443 | 12074020.0 |
| 2009-10-05 09:40:00 | AAPL | Stock | 6.6446 | 6.6679 | 6.6421 | 6.6557 | 15780016.0 |
| 2009-10-05 09:45:00 | AAPL | Stock | 6.6561 | 6.6593 | 6.6346 | 6.6357 | 9371152.0 |
| 2009-10-05 09:50:00 | AAPL | Stock | 6.6364 | 6.6393 | 6.6182 | 6.6229 | 11649568.0 |
| 2009-10-05 09:55:00 | AAPL | Stock | 6.6221 | 6.6354 | 6.6097 | 6.6185 | 12671540.0 |
| 2009-10-05 10:00:00 | AAPL | Stock | 6.6193 | 6.6329 | 6.5896 | 6.5982 | 22055488.0 |
| 2009-10-05 10:05:00 | AAPL | Stock | 6.5993 | 6.6161 | 6.5811 | 6.5929 | 14415408.0 |
| 2009-10-05 10:10:00 | AAPL | Stock | 6.5918 | 6.6132 | 6.5918 | 6.6005 | 11306764.0 |
| 2009-10-05 10:15:00 | AAPL | Stock | 6.6014 | 6.6182 | 6.5871 | 6.6182 | 9127188.0 |
| 2009-10-05 10:20:00 | AAPL | Stock | 6.6182 | 6.6229 | 6.6061 | 6.6114 | 7914676.0 |
| 2009-10-05 10:25:00 | AAPL | Stock | 6.61 | 6.6207 | 6.6043 | 6.6186 | 5234684.0 |
| 2009-10-05 10:30:00 | AAPL | Stock | 6.6186 | 6.6243 | 6.6182 | 6.6204 | 4716824.0 |
| 2009-10-05 10:35:00 | AAPL | Stock | 6.6196 | 6.6354 | 6.6161 | 6.6346 | 7895636.0 |
| 2009-10-05 10:40:00 | AAPL | Stock | 6.6343 | 6.6486 | 6.6286 | 6.6474 | 7597184.0 |
| 2009-10-05 10:45:00 | AAPL | Stock | 6.6468 | 6.65 | 6.6404 | 6.645 | 6642888.0 |
| 2009-10-05 10:50:00 | AAPL | Stock | 6.645 | 6.645 | 6.6343 | 6.6389 | 3232572.0 |
| 2009-10-05 10:55:00 | AAPL | Stock | 6.6389 | 6.6536 | 6.6389 | 6.6521 | 6350736.0 |
| 2009-10-05 11:00:00 | AAPL | Stock | 6.6518 | 6.6564 | 6.6393 | 6.6429 | 7298368.0 |
| 2009-10-05 11:05:00 | AAPL | Stock | 6.6429 | 6.6489 | 6.6386 | 6.6393 | 5290236.0 |
| 2009-10-05 11:10:00 | AAPL | Stock | 6.6403 | 6.6418 | 6.6307 | 6.6346 | 4690056.0 |
| 2009-10-05 11:15:00 | AAPL | Stock | 6.6346 | 6.6389 | 6.6332 | 6.6379 | 2452464.0 |
> showing 50 of 318,406 rows — these rows as CSV