PREVIEW / stock_5min / 2011-02-18
file: by_date/stock_5min/2011/2011-02-18.parquet size: 4.9 MB rows: 332,163 symbols: 3,539
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-18 04:00:00 | AAPL | Stock | 12.675 | 12.675 | 12.6464 | 12.675 | 29400.0 |
| 2011-02-18 04:05:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 22400.0 |
| 2011-02-18 04:10:00 | AAPL | Stock | 12.6689 | 12.6689 | 12.6357 | 12.6357 | 11200.0 |
| 2011-02-18 04:15:00 | AAPL | Stock | 12.6568 | 12.6704 | 12.6568 | 12.6704 | 8400.0 |
| 2011-02-18 04:20:00 | AAPL | Stock | 12.6568 | 12.6568 | 12.6393 | 12.6436 | 16240.0 |
| 2011-02-18 04:30:00 | AAPL | Stock | 12.6789 | 12.6914 | 12.6789 | 12.6914 | 36400.0 |
| 2011-02-18 04:35:00 | AAPL | Stock | 12.6918 | 12.6918 | 12.6918 | 12.6918 | 11200.0 |
| 2011-02-18 04:55:00 | AAPL | Stock | 12.6768 | 12.6786 | 12.6768 | 12.6786 | 8400.0 |
| 2011-02-18 05:00:00 | AAPL | Stock | 12.6829 | 12.6829 | 12.6829 | 12.6829 | 2800.0 |
| 2011-02-18 05:05:00 | AAPL | Stock | 12.6746 | 12.6761 | 12.6746 | 12.6761 | 8400.0 |
| 2011-02-18 05:10:00 | AAPL | Stock | 12.6704 | 12.6704 | 12.6679 | 12.6679 | 5600.0 |
| 2011-02-18 05:15:00 | AAPL | Stock | 12.6429 | 12.6429 | 12.6429 | 12.6429 | 5600.0 |
| 2011-02-18 05:25:00 | AAPL | Stock | 12.6429 | 12.6761 | 12.6429 | 12.6429 | 11200.0 |
| 2011-02-18 05:30:00 | AAPL | Stock | 12.6589 | 12.6589 | 12.6589 | 12.6589 | 2800.0 |
| 2011-02-18 05:35:00 | AAPL | Stock | 12.6571 | 12.6571 | 12.6571 | 12.6571 | 2800.0 |
| 2011-02-18 05:40:00 | AAPL | Stock | 12.6429 | 12.6589 | 12.6357 | 12.6357 | 53760.0 |
| 2011-02-18 05:50:00 | AAPL | Stock | 12.6607 | 12.6607 | 12.6607 | 12.6607 | 7000.0 |
| 2011-02-18 05:55:00 | AAPL | Stock | 12.6618 | 12.6714 | 12.6607 | 12.6714 | 28000.0 |
| 2011-02-18 06:10:00 | AAPL | Stock | 12.6696 | 12.6696 | 12.6696 | 12.6696 | 2800.0 |
| 2011-02-18 06:20:00 | AAPL | Stock | 12.6461 | 12.6786 | 12.6461 | 12.6786 | 11200.0 |
| 2011-02-18 06:25:00 | AAPL | Stock | 12.6686 | 12.6686 | 12.6521 | 12.6521 | 12600.0 |
| 2011-02-18 06:35:00 | AAPL | Stock | 12.6686 | 12.6686 | 12.6686 | 12.6686 | 2800.0 |
| 2011-02-18 06:45:00 | AAPL | Stock | 12.6768 | 12.6864 | 12.6768 | 12.6864 | 20020.0 |
| 2011-02-18 06:50:00 | AAPL | Stock | 12.6964 | 12.7086 | 12.6964 | 12.6964 | 39480.0 |
| 2011-02-18 07:00:00 | AAPL | Stock | 12.7061 | 12.7482 | 12.7061 | 12.7464 | 204456.0 |
| 2011-02-18 07:05:00 | AAPL | Stock | 12.75 | 12.7679 | 12.7482 | 12.7671 | 119476.0 |
| 2011-02-18 07:10:00 | AAPL | Stock | 12.7679 | 12.7682 | 12.7582 | 12.7639 | 61600.0 |
| 2011-02-18 07:15:00 | AAPL | Stock | 12.765 | 12.7711 | 12.7589 | 12.7711 | 108360.0 |
| 2011-02-18 07:20:00 | AAPL | Stock | 12.7682 | 12.7811 | 12.7664 | 12.7721 | 94612.0 |
| 2011-02-18 07:25:00 | AAPL | Stock | 12.7679 | 12.7768 | 12.7643 | 12.7725 | 85400.0 |
| 2011-02-18 07:30:00 | AAPL | Stock | 12.7796 | 12.7796 | 12.7707 | 12.775 | 22540.0 |
| 2011-02-18 07:35:00 | AAPL | Stock | 12.775 | 12.785 | 12.775 | 12.7768 | 44800.0 |
| 2011-02-18 07:40:00 | AAPL | Stock | 12.7764 | 12.7768 | 12.7704 | 12.7714 | 50400.0 |
| 2011-02-18 07:45:00 | AAPL | Stock | 12.7746 | 12.7804 | 12.77 | 12.7804 | 103600.0 |
| 2011-02-18 07:50:00 | AAPL | Stock | 12.7768 | 12.7936 | 12.7754 | 12.7782 | 121632.0 |
| 2011-02-18 07:55:00 | AAPL | Stock | 12.7936 | 12.7936 | 12.7861 | 12.7861 | 14000.0 |
| 2011-02-18 08:00:00 | AAPL | Stock | 12.7861 | 12.8289 | 12.7829 | 12.8214 | 570780.0 |
| 2011-02-18 08:05:00 | AAPL | Stock | 12.8211 | 12.8375 | 12.8175 | 12.8375 | 286076.0 |
| 2011-02-18 08:10:00 | AAPL | Stock | 12.8375 | 12.8418 | 12.8232 | 12.8357 | 342216.0 |
| 2011-02-18 08:15:00 | AAPL | Stock | 12.8325 | 12.8464 | 12.8271 | 12.8393 | 337092.0 |
| 2011-02-18 08:20:00 | AAPL | Stock | 12.8343 | 12.8375 | 12.8304 | 12.8339 | 175224.0 |
| 2011-02-18 08:25:00 | AAPL | Stock | 12.8339 | 12.8393 | 12.8339 | 12.8357 | 477260.0 |
| 2011-02-18 08:30:00 | AAPL | Stock | 12.8321 | 12.8339 | 12.8286 | 12.8314 | 255500.0 |
| 2011-02-18 08:35:00 | AAPL | Stock | 12.8318 | 12.8393 | 12.8304 | 12.8321 | 154644.0 |
| 2011-02-18 08:40:00 | AAPL | Stock | 12.8304 | 12.8375 | 12.8293 | 12.8321 | 172760.0 |
| 2011-02-18 08:45:00 | AAPL | Stock | 12.8321 | 12.835 | 12.8289 | 12.8321 | 187600.0 |
| 2011-02-18 08:50:00 | AAPL | Stock | 12.8321 | 12.8393 | 12.8289 | 12.8393 | 287084.0 |
| 2011-02-18 08:55:00 | AAPL | Stock | 12.8396 | 12.8461 | 12.8396 | 12.8432 | 215740.0 |
| 2011-02-18 09:00:00 | AAPL | Stock | 12.8461 | 12.85 | 12.8461 | 12.8486 | 369460.0 |
| 2011-02-18 09:05:00 | AAPL | Stock | 12.8493 | 12.8525 | 12.8464 | 12.85 | 370440.0 |
> showing 50 of 332,163 rows — these rows as CSV