PREVIEW / stock_5min / 2005-03-18
file: by_date/stock_5min/2005/2005-03-18.parquet size: 2.7 MB rows: 197,198 symbols: 1,939
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-18 08:00:00 | AAPL | Stock | 1.5571 | 1.5675 | 1.5436 | 1.5625 | 3955168.0 |
| 2005-03-18 08:05:00 | AAPL | Stock | 1.5621 | 1.5675 | 1.5621 | 1.5625 | 1945132.0 |
| 2005-03-18 08:10:00 | AAPL | Stock | 1.5618 | 1.5639 | 1.5536 | 1.5557 | 2624076.0 |
| 2005-03-18 08:15:00 | AAPL | Stock | 1.5571 | 1.5604 | 1.555 | 1.56 | 630924.0 |
| 2005-03-18 08:20:00 | AAPL | Stock | 1.5589 | 1.5621 | 1.5554 | 1.56 | 1122240.0 |
| 2005-03-18 08:25:00 | AAPL | Stock | 1.5589 | 1.5607 | 1.5568 | 1.5568 | 377720.0 |
| 2005-03-18 08:30:00 | AAPL | Stock | 1.5568 | 1.5568 | 1.5482 | 1.5529 | 1107960.0 |
| 2005-03-18 08:35:00 | AAPL | Stock | 1.5536 | 1.5557 | 1.5514 | 1.555 | 321020.0 |
| 2005-03-18 08:40:00 | AAPL | Stock | 1.5546 | 1.5611 | 1.5546 | 1.5586 | 1587600.0 |
| 2005-03-18 08:45:00 | AAPL | Stock | 1.5582 | 1.5607 | 1.5582 | 1.5589 | 271012.0 |
| 2005-03-18 08:50:00 | AAPL | Stock | 1.56 | 1.5614 | 1.5557 | 1.5568 | 663068.0 |
| 2005-03-18 08:55:00 | AAPL | Stock | 1.5571 | 1.5571 | 1.5536 | 1.5543 | 366296.0 |
| 2005-03-18 09:00:00 | AAPL | Stock | 1.5539 | 1.5571 | 1.5536 | 1.5571 | 557200.0 |
| 2005-03-18 09:05:00 | AAPL | Stock | 1.5571 | 1.5571 | 1.5525 | 1.5532 | 2764580.0 |
| 2005-03-18 09:10:00 | AAPL | Stock | 1.5536 | 1.5557 | 1.5507 | 1.5514 | 945364.0 |
| 2005-03-18 09:15:00 | AAPL | Stock | 1.5511 | 1.5532 | 1.5496 | 1.5532 | 733460.0 |
| 2005-03-18 09:20:00 | AAPL | Stock | 1.5525 | 1.5525 | 1.5482 | 1.5486 | 2203460.0 |
| 2005-03-18 09:25:00 | AAPL | Stock | 1.5336 | 1.5536 | 1.5179 | 1.5475 | 5403832.0 |
| 2005-03-18 09:30:00 | AAPL | Stock | 1.5475 | 1.5514 | 1.5421 | 1.5464 | 64652168.0 |
| 2005-03-18 09:35:00 | AAPL | Stock | 1.5464 | 1.5475 | 1.5357 | 1.5371 | 31939852.0 |
| 2005-03-18 09:40:00 | AAPL | Stock | 1.5364 | 1.5446 | 1.5332 | 1.5425 | 40698728.0 |
| 2005-03-18 09:45:00 | AAPL | Stock | 1.5425 | 1.5454 | 1.5375 | 1.5375 | 22277024.0 |
| 2005-03-18 09:50:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5336 | 1.5354 | 23792804.0 |
| 2005-03-18 09:55:00 | AAPL | Stock | 1.5354 | 1.5386 | 1.5214 | 1.5279 | 33490520.0 |
| 2005-03-18 10:00:00 | AAPL | Stock | 1.5279 | 1.5321 | 1.525 | 1.5321 | 25531240.0 |
| 2005-03-18 10:05:00 | AAPL | Stock | 1.5314 | 1.5357 | 1.53 | 1.5343 | 16969092.0 |
| 2005-03-18 10:10:00 | AAPL | Stock | 1.5343 | 1.5375 | 1.5311 | 1.5321 | 22244852.0 |
| 2005-03-18 10:15:00 | AAPL | Stock | 1.5332 | 1.5339 | 1.5307 | 1.5329 | 11572008.0 |
| 2005-03-18 10:20:00 | AAPL | Stock | 1.5329 | 1.5354 | 1.5286 | 1.5336 | 11351452.0 |
| 2005-03-18 10:25:00 | AAPL | Stock | 1.5336 | 1.5346 | 1.5296 | 1.5314 | 9054248.0 |
| 2005-03-18 10:30:00 | AAPL | Stock | 1.5314 | 1.5329 | 1.525 | 1.5257 | 11356268.0 |
| 2005-03-18 10:35:00 | AAPL | Stock | 1.5254 | 1.5307 | 1.5254 | 1.53 | 7862232.0 |
| 2005-03-18 10:40:00 | AAPL | Stock | 1.53 | 1.5346 | 1.5296 | 1.5321 | 11153100.0 |
| 2005-03-18 10:45:00 | AAPL | Stock | 1.5321 | 1.5332 | 1.5293 | 1.53 | 10310776.0 |
| 2005-03-18 10:50:00 | AAPL | Stock | 1.5296 | 1.5339 | 1.5296 | 1.5339 | 4905348.0 |
| 2005-03-18 10:55:00 | AAPL | Stock | 1.5339 | 1.5354 | 1.5325 | 1.535 | 8753976.0 |
| 2005-03-18 11:00:00 | AAPL | Stock | 1.5354 | 1.5379 | 1.5325 | 1.5368 | 11580100.0 |
| 2005-03-18 11:05:00 | AAPL | Stock | 1.5375 | 1.5414 | 1.5364 | 1.5383 | 12333020.0 |
| 2005-03-18 11:10:00 | AAPL | Stock | 1.5382 | 1.5393 | 1.5318 | 1.5318 | 7882840.0 |
| 2005-03-18 11:15:00 | AAPL | Stock | 1.5318 | 1.5375 | 1.5318 | 1.5343 | 6633760.0 |
| 2005-03-18 11:20:00 | AAPL | Stock | 1.5343 | 1.5379 | 1.5342 | 1.5375 | 6567708.0 |
| 2005-03-18 11:25:00 | AAPL | Stock | 1.5371 | 1.5375 | 1.5354 | 1.5357 | 7372400.0 |
| 2005-03-18 11:30:00 | AAPL | Stock | 1.5357 | 1.5361 | 1.53 | 1.5304 | 12065956.0 |
| 2005-03-18 11:35:00 | AAPL | Stock | 1.5307 | 1.5329 | 1.53 | 1.5314 | 5147660.0 |
| 2005-03-18 11:40:00 | AAPL | Stock | 1.5318 | 1.5329 | 1.5314 | 1.5329 | 1538012.0 |
| 2005-03-18 11:45:00 | AAPL | Stock | 1.5325 | 1.5332 | 1.5314 | 1.5321 | 2361800.0 |
| 2005-03-18 11:50:00 | AAPL | Stock | 1.5321 | 1.5354 | 1.5321 | 1.5339 | 2985136.0 |
| 2005-03-18 11:55:00 | AAPL | Stock | 1.5343 | 1.5354 | 1.5329 | 1.5329 | 2692172.0 |
| 2005-03-18 12:00:00 | AAPL | Stock | 1.5332 | 1.5332 | 1.5304 | 1.5321 | 4320876.0 |
| 2005-03-18 12:05:00 | AAPL | Stock | 1.5325 | 1.5332 | 1.53 | 1.5321 | 2888676.0 |
> showing 50 of 197,198 rows — these rows as CSV