PREVIEW / stock_5min / 2008-03-17
file: by_date/stock_5min/2008/2008-03-17.parquet size: 4.4 MB rows: 320,640 symbols: 3,282
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-03-17 05:00:00 | AAPL | Stock | 4.3975 | 4.3975 | 4.3975 | 4.3975 | 2800.0 |
| 2008-03-17 06:30:00 | AAPL | Stock | 4.4014 | 4.4014 | 4.4014 | 4.4014 | 28000.0 |
| 2008-03-17 07:00:00 | AAPL | Stock | 4.4036 | 4.4036 | 4.3929 | 4.3929 | 5600.0 |
| 2008-03-17 07:05:00 | AAPL | Stock | 4.3929 | 4.4171 | 4.3929 | 4.4171 | 25200.0 |
| 2008-03-17 07:15:00 | AAPL | Stock | 4.3929 | 4.3929 | 4.3929 | 4.3929 | 19600.0 |
| 2008-03-17 07:20:00 | AAPL | Stock | 4.3961 | 4.3961 | 4.3961 | 4.3961 | 19600.0 |
| 2008-03-17 07:30:00 | AAPL | Stock | 4.4 | 4.4 | 4.4 | 4.4 | 24920.0 |
| 2008-03-17 07:45:00 | AAPL | Stock | 4.4064 | 4.4064 | 4.4064 | 4.4064 | 2800.0 |
| 2008-03-17 07:50:00 | AAPL | Stock | 4.4071 | 4.4071 | 4.4071 | 4.4071 | 6440.0 |
| 2008-03-17 07:55:00 | AAPL | Stock | 4.4232 | 4.4243 | 4.4232 | 4.4243 | 12040.0 |
| 2008-03-17 08:00:00 | AAPL | Stock | 4.4107 | 4.4264 | 4.4036 | 4.4036 | 1019312.0 |
| 2008-03-17 08:05:00 | AAPL | Stock | 4.3993 | 4.4036 | 4.3964 | 4.4018 | 283640.0 |
| 2008-03-17 08:10:00 | AAPL | Stock | 4.4018 | 4.4018 | 4.3911 | 4.3911 | 240968.0 |
| 2008-03-17 08:15:00 | AAPL | Stock | 4.3911 | 4.3929 | 4.3821 | 4.3893 | 337624.0 |
| 2008-03-17 08:20:00 | AAPL | Stock | 4.3929 | 4.3964 | 4.3857 | 4.3929 | 939400.0 |
| 2008-03-17 08:25:00 | AAPL | Stock | 4.3929 | 4.3929 | 4.3821 | 4.3821 | 388668.0 |
| 2008-03-17 08:30:00 | AAPL | Stock | 4.3814 | 4.3821 | 4.3679 | 4.3704 | 413140.0 |
| 2008-03-17 08:35:00 | AAPL | Stock | 4.3768 | 4.3786 | 4.3679 | 4.3679 | 381724.0 |
| 2008-03-17 08:40:00 | AAPL | Stock | 4.3679 | 4.3679 | 4.3618 | 4.3679 | 249984.0 |
| 2008-03-17 08:45:00 | AAPL | Stock | 4.3679 | 4.3679 | 4.3493 | 4.3529 | 647696.0 |
| 2008-03-17 08:50:00 | AAPL | Stock | 4.3571 | 4.3679 | 4.3536 | 4.3679 | 245056.0 |
| 2008-03-17 08:55:00 | AAPL | Stock | 4.3689 | 4.3746 | 4.3643 | 4.3711 | 142716.0 |
| 2008-03-17 09:00:00 | AAPL | Stock | 4.3714 | 4.375 | 4.3643 | 4.3679 | 296688.0 |
| 2008-03-17 09:05:00 | AAPL | Stock | 4.3686 | 4.3825 | 4.3686 | 4.375 | 148960.0 |
| 2008-03-17 09:10:00 | AAPL | Stock | 4.375 | 4.3846 | 4.375 | 4.3779 | 196896.0 |
| 2008-03-17 09:15:00 | AAPL | Stock | 4.3818 | 4.3857 | 4.3779 | 4.3786 | 193704.0 |
| 2008-03-17 09:20:00 | AAPL | Stock | 4.3786 | 4.3804 | 4.375 | 4.375 | 264796.0 |
| 2008-03-17 09:25:00 | AAPL | Stock | 4.375 | 4.385 | 4.3714 | 4.3793 | 705040.0 |
| 2008-03-17 09:30:00 | AAPL | Stock | 4.3811 | 4.4389 | 4.375 | 4.4239 | 25196668.0 |
| 2008-03-17 09:35:00 | AAPL | Stock | 4.4239 | 4.4582 | 4.4225 | 4.4454 | 22816276.0 |
| 2008-03-17 09:40:00 | AAPL | Stock | 4.4454 | 4.4754 | 4.4443 | 4.4475 | 19654264.0 |
| 2008-03-17 09:45:00 | AAPL | Stock | 4.4468 | 4.4636 | 4.4357 | 4.4582 | 15354108.0 |
| 2008-03-17 09:50:00 | AAPL | Stock | 4.46 | 4.4811 | 4.4464 | 4.4611 | 20229636.0 |
| 2008-03-17 09:55:00 | AAPL | Stock | 4.4607 | 4.4664 | 4.4429 | 4.4564 | 12960724.0 |
| 2008-03-17 10:00:00 | AAPL | Stock | 4.4571 | 4.4725 | 4.4375 | 4.4582 | 12639424.0 |
| 2008-03-17 10:05:00 | AAPL | Stock | 4.4582 | 4.4743 | 4.4493 | 4.4696 | 10872316.0 |
| 2008-03-17 10:10:00 | AAPL | Stock | 4.47 | 4.4814 | 4.4475 | 4.4493 | 12602156.0 |
| 2008-03-17 10:15:00 | AAPL | Stock | 4.4479 | 4.4582 | 4.4296 | 4.4543 | 12942804.0 |
| 2008-03-17 10:20:00 | AAPL | Stock | 4.4546 | 4.4714 | 4.4475 | 4.4614 | 7919492.0 |
| 2008-03-17 10:25:00 | AAPL | Stock | 4.4614 | 4.4911 | 4.4543 | 4.4853 | 14182308.0 |
| 2008-03-17 10:30:00 | AAPL | Stock | 4.4854 | 4.4932 | 4.4482 | 4.4546 | 14550676.0 |
| 2008-03-17 10:35:00 | AAPL | Stock | 4.4546 | 4.4643 | 4.4486 | 4.4575 | 11315528.0 |
| 2008-03-17 10:40:00 | AAPL | Stock | 4.4571 | 4.4786 | 4.4554 | 4.4661 | 14286636.0 |
| 2008-03-17 10:45:00 | AAPL | Stock | 4.4654 | 4.4836 | 4.4614 | 4.4807 | 10458560.0 |
| 2008-03-17 10:50:00 | AAPL | Stock | 4.4807 | 4.5143 | 4.4707 | 4.4964 | 18048296.0 |
| 2008-03-17 10:55:00 | AAPL | Stock | 4.4961 | 4.5143 | 4.4857 | 4.4954 | 15736280.0 |
| 2008-03-17 11:00:00 | AAPL | Stock | 4.495 | 4.5054 | 4.4736 | 4.4829 | 11430692.0 |
| 2008-03-17 11:05:00 | AAPL | Stock | 4.4818 | 4.4996 | 4.4718 | 4.4884 | 8803284.0 |
| 2008-03-17 11:10:00 | AAPL | Stock | 4.4871 | 4.5025 | 4.4661 | 4.4686 | 11845512.0 |
| 2008-03-17 11:15:00 | AAPL | Stock | 4.4679 | 4.4679 | 4.4557 | 4.4646 | 12002508.0 |
> showing 50 of 320,640 rows — these rows as CSV