PREVIEW / stock_5min / 2008-02-28
file: by_date/stock_5min/2008/2008-02-28.parquet size: 4.3 MB rows: 316,400 symbols: 3,262
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-28 04:05:00 | AAPL | Stock | 4.5586 | 4.5586 | 4.5586 | 4.5586 | 2800.0 |
| 2008-02-28 04:20:00 | AAPL | Stock | 4.5539 | 4.5539 | 4.5539 | 4.5539 | 2800.0 |
| 2008-02-28 04:35:00 | AAPL | Stock | 4.5486 | 4.5486 | 4.5486 | 4.5486 | 5600.0 |
| 2008-02-28 05:35:00 | AAPL | Stock | 4.5468 | 4.5468 | 4.5468 | 4.5468 | 2800.0 |
| 2008-02-28 05:50:00 | AAPL | Stock | 4.5296 | 4.5296 | 4.5296 | 4.5296 | 5600.0 |
| 2008-02-28 06:10:00 | AAPL | Stock | 4.5389 | 4.5468 | 4.5389 | 4.5468 | 8400.0 |
| 2008-02-28 06:20:00 | AAPL | Stock | 4.5321 | 4.5357 | 4.5321 | 4.5357 | 16800.0 |
| 2008-02-28 06:35:00 | AAPL | Stock | 4.5536 | 4.5536 | 4.5536 | 4.5536 | 28000.0 |
| 2008-02-28 06:55:00 | AAPL | Stock | 4.5418 | 4.5418 | 4.5357 | 4.5357 | 21420.0 |
| 2008-02-28 07:00:00 | AAPL | Stock | 4.5357 | 4.5357 | 4.5357 | 4.5357 | 28000.0 |
| 2008-02-28 07:05:00 | AAPL | Stock | 4.5321 | 4.5393 | 4.5286 | 4.5361 | 640780.0 |
| 2008-02-28 07:10:00 | AAPL | Stock | 4.5364 | 4.5411 | 4.5286 | 4.5286 | 699692.0 |
| 2008-02-28 07:15:00 | AAPL | Stock | 4.5286 | 4.5304 | 4.515 | 4.5225 | 217476.0 |
| 2008-02-28 07:20:00 | AAPL | Stock | 4.5232 | 4.5246 | 4.5107 | 4.5107 | 188328.0 |
| 2008-02-28 07:25:00 | AAPL | Stock | 4.5143 | 4.5229 | 4.5 | 4.5079 | 352996.0 |
| 2008-02-28 07:30:00 | AAPL | Stock | 4.5071 | 4.5107 | 4.5071 | 4.5089 | 376460.0 |
| 2008-02-28 07:35:00 | AAPL | Stock | 4.5089 | 4.5089 | 4.5018 | 4.5032 | 269668.0 |
| 2008-02-28 07:40:00 | AAPL | Stock | 4.5036 | 4.5125 | 4.5032 | 4.5125 | 233660.0 |
| 2008-02-28 07:45:00 | AAPL | Stock | 4.5107 | 4.5196 | 4.5054 | 4.5093 | 282856.0 |
| 2008-02-28 07:50:00 | AAPL | Stock | 4.5143 | 4.5143 | 4.5086 | 4.5118 | 89600.0 |
| 2008-02-28 07:55:00 | AAPL | Stock | 4.5125 | 4.5129 | 4.5054 | 4.5086 | 151732.0 |
| 2008-02-28 08:00:00 | AAPL | Stock | 4.5082 | 4.5464 | 4.4843 | 4.5221 | 1834140.0 |
| 2008-02-28 08:05:00 | AAPL | Stock | 4.5246 | 4.5286 | 4.5093 | 4.5107 | 888216.0 |
| 2008-02-28 08:10:00 | AAPL | Stock | 4.51 | 4.5175 | 4.5036 | 4.5114 | 735504.0 |
| 2008-02-28 08:15:00 | AAPL | Stock | 4.5129 | 4.5129 | 4.4946 | 4.4964 | 675696.0 |
| 2008-02-28 08:20:00 | AAPL | Stock | 4.4979 | 4.5071 | 4.49 | 4.5054 | 1323252.0 |
| 2008-02-28 08:25:00 | AAPL | Stock | 4.5036 | 4.5179 | 4.5018 | 4.5179 | 873516.0 |
| 2008-02-28 08:30:00 | AAPL | Stock | 4.5157 | 4.5175 | 4.5036 | 4.5111 | 1004836.0 |
| 2008-02-28 08:35:00 | AAPL | Stock | 4.5125 | 4.5179 | 4.5064 | 4.5107 | 816732.0 |
| 2008-02-28 08:40:00 | AAPL | Stock | 4.5107 | 4.5229 | 4.5082 | 4.5179 | 1517376.0 |
| 2008-02-28 08:45:00 | AAPL | Stock | 4.5179 | 4.5268 | 4.5143 | 4.5268 | 1193276.0 |
| 2008-02-28 08:50:00 | AAPL | Stock | 4.5257 | 4.5375 | 4.5239 | 4.5375 | 2283792.0 |
| 2008-02-28 08:55:00 | AAPL | Stock | 4.5357 | 4.5389 | 4.5307 | 4.535 | 2251508.0 |
| 2008-02-28 09:00:00 | AAPL | Stock | 4.5343 | 4.5379 | 4.5271 | 4.5375 | 1889328.0 |
| 2008-02-28 09:05:00 | AAPL | Stock | 4.5364 | 4.5386 | 4.5282 | 4.5293 | 2084040.0 |
| 2008-02-28 09:10:00 | AAPL | Stock | 4.5293 | 4.5332 | 4.5232 | 4.5268 | 1457120.0 |
| 2008-02-28 09:15:00 | AAPL | Stock | 4.5254 | 4.5286 | 4.525 | 4.5268 | 466676.0 |
| 2008-02-28 09:20:00 | AAPL | Stock | 4.5268 | 4.5368 | 4.525 | 4.5325 | 725284.0 |
| 2008-02-28 09:25:00 | AAPL | Stock | 4.5314 | 4.5475 | 4.5296 | 4.5432 | 5206992.0 |
| 2008-02-28 09:30:00 | AAPL | Stock | 4.5432 | 4.5571 | 4.4918 | 4.5179 | 72712360.0 |
| 2008-02-28 09:35:00 | AAPL | Stock | 4.5179 | 4.5739 | 4.5175 | 4.5736 | 62439832.0 |
| 2008-02-28 09:40:00 | AAPL | Stock | 4.5732 | 4.585 | 4.555 | 4.5557 | 48043520.0 |
| 2008-02-28 09:45:00 | AAPL | Stock | 4.5557 | 4.5743 | 4.5464 | 4.5714 | 34495412.0 |
| 2008-02-28 09:50:00 | AAPL | Stock | 4.5711 | 4.5864 | 4.5636 | 4.5757 | 37973460.0 |
| 2008-02-28 09:55:00 | AAPL | Stock | 4.5761 | 4.5768 | 4.5507 | 4.5675 | 27213592.0 |
| 2008-02-28 10:00:00 | AAPL | Stock | 4.5671 | 4.5771 | 4.5571 | 4.5595 | 25251660.0 |
| 2008-02-28 10:05:00 | AAPL | Stock | 4.5611 | 4.5654 | 4.5464 | 4.5468 | 26620860.0 |
| 2008-02-28 10:10:00 | AAPL | Stock | 4.5464 | 4.5621 | 4.5404 | 4.545 | 23398508.0 |
| 2008-02-28 10:15:00 | AAPL | Stock | 4.545 | 4.5625 | 4.5425 | 4.5525 | 21502236.0 |
| 2008-02-28 10:20:00 | AAPL | Stock | 4.5525 | 4.5714 | 4.55 | 4.5693 | 18815720.0 |
> showing 50 of 316,400 rows — these rows as CSV