PREVIEW / stock_5min / 2007-08-10
file: by_date/stock_5min/2007/2007-08-10.parquet size: 4.5 MB rows: 317,385 symbols: 3,126
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-10 09:30:00 | AAPL | Stock | 4.3971 | 4.4132 | 4.3393 | 4.4129 | 76268640.0 |
| 2007-08-10 09:35:00 | AAPL | Stock | 4.4118 | 4.4171 | 4.3775 | 4.3896 | 32856852.0 |
| 2007-08-10 09:40:00 | AAPL | Stock | 4.3911 | 4.3929 | 4.3414 | 4.3493 | 34715072.0 |
| 2007-08-10 09:45:00 | AAPL | Stock | 4.3482 | 4.3929 | 4.3468 | 4.3929 | 18752188.0 |
| 2007-08-10 09:50:00 | AAPL | Stock | 4.3929 | 4.4236 | 4.3879 | 4.4229 | 29558032.0 |
| 2007-08-10 09:55:00 | AAPL | Stock | 4.4232 | 4.4232 | 4.3807 | 4.3889 | 21893004.0 |
| 2007-08-10 10:00:00 | AAPL | Stock | 4.3889 | 4.4007 | 4.3536 | 4.3546 | 22436848.0 |
| 2007-08-10 10:05:00 | AAPL | Stock | 4.3546 | 4.3693 | 4.35 | 4.3519 | 13170836.0 |
| 2007-08-10 10:10:00 | AAPL | Stock | 4.3518 | 4.4007 | 4.3514 | 4.3975 | 23040500.0 |
| 2007-08-10 10:15:00 | AAPL | Stock | 4.3957 | 4.4036 | 4.3671 | 4.3729 | 16386860.0 |
| 2007-08-10 10:20:00 | AAPL | Stock | 4.3729 | 4.3925 | 4.3618 | 4.3734 | 14528976.0 |
| 2007-08-10 10:25:00 | AAPL | Stock | 4.3736 | 4.3821 | 4.35 | 4.3507 | 18861836.0 |
| 2007-08-10 10:30:00 | AAPL | Stock | 4.3504 | 4.3621 | 4.3179 | 4.3179 | 27230644.0 |
| 2007-08-10 10:35:00 | AAPL | Stock | 4.3189 | 4.3346 | 4.2964 | 4.3082 | 31898524.0 |
| 2007-08-10 10:40:00 | AAPL | Stock | 4.3082 | 4.3321 | 4.3036 | 4.3321 | 19773096.0 |
| 2007-08-10 10:45:00 | AAPL | Stock | 4.3307 | 4.3471 | 4.3146 | 4.3371 | 18782652.0 |
| 2007-08-10 10:50:00 | AAPL | Stock | 4.3357 | 4.3529 | 4.3236 | 4.3364 | 16923032.0 |
| 2007-08-10 10:55:00 | AAPL | Stock | 4.3364 | 4.355 | 4.3289 | 4.35 | 17057292.0 |
| 2007-08-10 11:00:00 | AAPL | Stock | 4.3493 | 4.375 | 4.3489 | 4.3747 | 22186556.0 |
| 2007-08-10 11:05:00 | AAPL | Stock | 4.3739 | 4.3996 | 4.3643 | 4.3675 | 21399756.0 |
| 2007-08-10 11:10:00 | AAPL | Stock | 4.3689 | 4.3961 | 4.3679 | 4.3943 | 10300472.0 |
| 2007-08-10 11:15:00 | AAPL | Stock | 4.394 | 4.4161 | 4.3932 | 4.4071 | 21477092.0 |
| 2007-08-10 11:20:00 | AAPL | Stock | 4.4068 | 4.445 | 4.4032 | 4.4229 | 29145452.0 |
| 2007-08-10 11:25:00 | AAPL | Stock | 4.4229 | 4.4329 | 4.4136 | 4.4168 | 17932908.0 |
| 2007-08-10 11:30:00 | AAPL | Stock | 4.4157 | 4.45 | 4.4 | 4.4464 | 22533168.0 |
| 2007-08-10 11:35:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4204 | 4.4218 | 15898344.0 |
| 2007-08-10 11:40:00 | AAPL | Stock | 4.4225 | 4.4393 | 4.4211 | 4.4307 | 11071788.0 |
| 2007-08-10 11:45:00 | AAPL | Stock | 4.4304 | 4.4668 | 4.43 | 4.4614 | 21274456.0 |
| 2007-08-10 11:50:00 | AAPL | Stock | 4.4621 | 4.4821 | 4.4543 | 4.4668 | 20465844.0 |
| 2007-08-10 11:55:00 | AAPL | Stock | 4.4667 | 4.4796 | 4.4504 | 4.4746 | 22144780.0 |
| 2007-08-10 12:00:00 | AAPL | Stock | 4.4746 | 4.4836 | 4.4557 | 4.4725 | 18632236.0 |
| 2007-08-10 12:05:00 | AAPL | Stock | 4.4714 | 4.4982 | 4.4679 | 4.4818 | 19952688.0 |
| 2007-08-10 12:10:00 | AAPL | Stock | 4.4818 | 4.4829 | 4.4557 | 4.4639 | 17442908.0 |
| 2007-08-10 12:15:00 | AAPL | Stock | 4.4639 | 4.5143 | 4.4571 | 4.5089 | 20954276.0 |
| 2007-08-10 12:20:00 | AAPL | Stock | 4.5086 | 4.5625 | 4.5075 | 4.5557 | 37541168.0 |
| 2007-08-10 12:25:00 | AAPL | Stock | 4.5568 | 4.5625 | 4.5118 | 4.5318 | 26006008.0 |
| 2007-08-10 12:30:00 | AAPL | Stock | 4.5318 | 4.5393 | 4.4018 | 4.4946 | 19840436.0 |
| 2007-08-10 12:35:00 | AAPL | Stock | 4.4949 | 4.5064 | 4.4782 | 4.5032 | 16591820.0 |
| 2007-08-10 12:40:00 | AAPL | Stock | 4.5056 | 4.5104 | 4.4846 | 4.4932 | 14917336.0 |
| 2007-08-10 12:45:00 | AAPL | Stock | 4.4934 | 4.4982 | 4.4664 | 4.4729 | 12263580.0 |
| 2007-08-10 12:50:00 | AAPL | Stock | 4.4732 | 4.4961 | 4.4679 | 4.4811 | 11139184.0 |
| 2007-08-10 12:55:00 | AAPL | Stock | 4.4804 | 4.4836 | 4.4557 | 4.4611 | 10881892.0 |
| 2007-08-10 13:00:00 | AAPL | Stock | 4.4611 | 4.4768 | 4.46 | 4.4754 | 8693132.0 |
| 2007-08-10 13:05:00 | AAPL | Stock | 4.4744 | 4.485 | 4.4686 | 4.4789 | 9047416.0 |
| 2007-08-10 13:10:00 | AAPL | Stock | 4.4786 | 4.4939 | 4.4375 | 4.4861 | 7336840.0 |
| 2007-08-10 13:15:00 | AAPL | Stock | 4.4861 | 4.5 | 4.47 | 4.4989 | 8929424.0 |
| 2007-08-10 13:20:00 | AAPL | Stock | 4.4991 | 4.5307 | 4.4982 | 4.5157 | 16363928.0 |
| 2007-08-10 13:25:00 | AAPL | Stock | 4.5171 | 4.5174 | 4.4729 | 4.4818 | 10301312.0 |
| 2007-08-10 13:30:00 | AAPL | Stock | 4.4807 | 4.4925 | 4.4754 | 4.4754 | 7949900.0 |
| 2007-08-10 13:35:00 | AAPL | Stock | 4.4754 | 4.4911 | 4.475 | 4.4775 | 8067192.0 |
> showing 50 of 317,385 rows — these rows as CSV