PREVIEW / stock_5min / 2005-03-08
file: by_date/stock_5min/2005/2005-03-08.parquet size: 2.7 MB rows: 193,272 symbols: 1,934
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-08 08:00:00 | AAPL | Stock | 1.5143 | 1.5143 | 1.505 | 1.505 | 165760.0 |
| 2005-03-08 08:05:00 | AAPL | Stock | 1.505 | 1.5089 | 1.505 | 1.5089 | 506436.0 |
| 2005-03-08 08:10:00 | AAPL | Stock | 1.5089 | 1.5107 | 1.5068 | 1.5068 | 502600.0 |
| 2005-03-08 08:15:00 | AAPL | Stock | 1.5071 | 1.5071 | 1.4943 | 1.4996 | 646576.0 |
| 2005-03-08 08:20:00 | AAPL | Stock | 1.4957 | 1.4964 | 1.4911 | 1.4918 | 1033704.0 |
| 2005-03-08 08:25:00 | AAPL | Stock | 1.4914 | 1.4946 | 1.4857 | 1.4943 | 1510684.0 |
| 2005-03-08 08:30:00 | AAPL | Stock | 1.4925 | 1.495 | 1.4925 | 1.4946 | 576464.0 |
| 2005-03-08 08:35:00 | AAPL | Stock | 1.4932 | 1.4957 | 1.4929 | 1.4954 | 351176.0 |
| 2005-03-08 08:40:00 | AAPL | Stock | 1.4979 | 1.4979 | 1.495 | 1.4957 | 833980.0 |
| 2005-03-08 08:45:00 | AAPL | Stock | 1.4954 | 1.4964 | 1.4936 | 1.4939 | 113400.0 |
| 2005-03-08 08:50:00 | AAPL | Stock | 1.4939 | 1.4943 | 1.49 | 1.4943 | 496748.0 |
| 2005-03-08 08:55:00 | AAPL | Stock | 1.4929 | 1.4939 | 1.4889 | 1.4939 | 170100.0 |
| 2005-03-08 09:00:00 | AAPL | Stock | 1.4918 | 1.4946 | 1.4893 | 1.4911 | 821464.0 |
| 2005-03-08 09:05:00 | AAPL | Stock | 1.4911 | 1.5089 | 1.4904 | 1.4943 | 749224.0 |
| 2005-03-08 09:10:00 | AAPL | Stock | 1.4946 | 1.5154 | 1.4911 | 1.4961 | 5841416.0 |
| 2005-03-08 09:15:00 | AAPL | Stock | 1.4946 | 1.4964 | 1.4946 | 1.4946 | 214200.0 |
| 2005-03-08 09:20:00 | AAPL | Stock | 1.4943 | 1.4968 | 1.4918 | 1.4946 | 382956.0 |
| 2005-03-08 09:25:00 | AAPL | Stock | 1.5154 | 1.5164 | 1.4921 | 1.495 | 1524236.0 |
| 2005-03-08 09:30:00 | AAPL | Stock | 1.4964 | 1.4975 | 1.4764 | 1.4911 | 48408248.0 |
| 2005-03-08 09:35:00 | AAPL | Stock | 1.4907 | 1.5036 | 1.4821 | 1.4957 | 28382032.0 |
| 2005-03-08 09:40:00 | AAPL | Stock | 1.4961 | 1.5057 | 1.4954 | 1.4968 | 24890628.0 |
| 2005-03-08 09:45:00 | AAPL | Stock | 1.4968 | 1.4989 | 1.4911 | 1.4954 | 17204992.0 |
| 2005-03-08 09:50:00 | AAPL | Stock | 1.495 | 1.4979 | 1.4921 | 1.495 | 12561696.0 |
| 2005-03-08 09:55:00 | AAPL | Stock | 1.495 | 1.4986 | 1.4929 | 1.4964 | 12044480.0 |
| 2005-03-08 10:00:00 | AAPL | Stock | 1.4964 | 1.4989 | 1.4943 | 1.4946 | 12762792.0 |
| 2005-03-08 10:05:00 | AAPL | Stock | 1.495 | 1.495 | 1.48 | 1.485 | 23604420.0 |
| 2005-03-08 10:10:00 | AAPL | Stock | 1.4843 | 1.4861 | 1.4779 | 1.4789 | 18589452.0 |
| 2005-03-08 10:15:00 | AAPL | Stock | 1.4789 | 1.4843 | 1.4736 | 1.4793 | 25135796.0 |
| 2005-03-08 10:20:00 | AAPL | Stock | 1.4793 | 1.485 | 1.4782 | 1.4793 | 11257092.0 |
| 2005-03-08 10:25:00 | AAPL | Stock | 1.4789 | 1.4793 | 1.4668 | 1.4671 | 33027232.0 |
| 2005-03-08 10:30:00 | AAPL | Stock | 1.4671 | 1.4689 | 1.4386 | 1.4407 | 69129760.0 |
| 2005-03-08 10:35:00 | AAPL | Stock | 1.4407 | 1.4482 | 1.4321 | 1.4454 | 53279604.0 |
| 2005-03-08 10:40:00 | AAPL | Stock | 1.4453 | 1.4557 | 1.4418 | 1.4529 | 34905472.0 |
| 2005-03-08 10:45:00 | AAPL | Stock | 1.4529 | 1.4657 | 1.4482 | 1.4636 | 38968132.0 |
| 2005-03-08 10:50:00 | AAPL | Stock | 1.4639 | 1.465 | 1.4536 | 1.4596 | 25908792.0 |
| 2005-03-08 10:55:00 | AAPL | Stock | 1.4593 | 1.4607 | 1.45 | 1.4525 | 16760380.0 |
| 2005-03-08 11:00:00 | AAPL | Stock | 1.4529 | 1.4557 | 1.4461 | 1.4464 | 12996816.0 |
| 2005-03-08 11:05:00 | AAPL | Stock | 1.4468 | 1.4518 | 1.4436 | 1.445 | 19204360.0 |
| 2005-03-08 11:10:00 | AAPL | Stock | 1.4439 | 1.4554 | 1.4439 | 1.4511 | 14439320.0 |
| 2005-03-08 11:15:00 | AAPL | Stock | 1.4504 | 1.4539 | 1.4489 | 1.4511 | 9736160.0 |
| 2005-03-08 11:20:00 | AAPL | Stock | 1.4507 | 1.4961 | 1.4507 | 1.4557 | 11778480.0 |
| 2005-03-08 11:25:00 | AAPL | Stock | 1.4564 | 1.4568 | 1.4507 | 1.4543 | 10167668.0 |
| 2005-03-08 11:30:00 | AAPL | Stock | 1.4539 | 1.4604 | 1.4532 | 1.46 | 8669948.0 |
| 2005-03-08 11:35:00 | AAPL | Stock | 1.4596 | 1.4632 | 1.4589 | 1.4611 | 8314684.0 |
| 2005-03-08 11:40:00 | AAPL | Stock | 1.4611 | 1.4618 | 1.4593 | 1.4614 | 3999632.0 |
| 2005-03-08 11:45:00 | AAPL | Stock | 1.4614 | 1.4654 | 1.46 | 1.4639 | 6855352.0 |
| 2005-03-08 11:50:00 | AAPL | Stock | 1.4639 | 1.4693 | 1.4625 | 1.4661 | 11878580.0 |
| 2005-03-08 11:55:00 | AAPL | Stock | 1.4664 | 1.4711 | 1.4661 | 1.4696 | 11589228.0 |
| 2005-03-08 12:00:00 | AAPL | Stock | 1.47 | 1.4707 | 1.4632 | 1.4639 | 9359616.0 |
| 2005-03-08 12:05:00 | AAPL | Stock | 1.4632 | 1.4664 | 1.4629 | 1.4661 | 7669844.0 |
> showing 50 of 193,272 rows — these rows as CSV