PREVIEW / stock_5min / 2009-05-15
file: by_date/stock_5min/2009/2009-05-15.parquet size: 4.6 MB rows: 319,467 symbols: 3,333
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-15 08:10:00 | AAPL | Stock | 4.3746 | 4.3754 | 4.3746 | 4.375 | 21196.0 |
| 2009-05-15 08:15:00 | AAPL | Stock | 4.3779 | 4.3821 | 4.3775 | 4.3821 | 67116.0 |
| 2009-05-15 08:25:00 | AAPL | Stock | 4.3754 | 4.3832 | 4.3754 | 4.3832 | 18200.0 |
| 2009-05-15 08:30:00 | AAPL | Stock | 4.3832 | 4.3893 | 4.3832 | 4.3893 | 39620.0 |
| 2009-05-15 08:35:00 | AAPL | Stock | 4.3907 | 4.3907 | 4.3782 | 4.3889 | 39620.0 |
| 2009-05-15 08:40:00 | AAPL | Stock | 4.3875 | 4.3886 | 4.3804 | 4.3804 | 46872.0 |
| 2009-05-15 08:45:00 | AAPL | Stock | 4.3804 | 4.3804 | 4.3721 | 4.375 | 106400.0 |
| 2009-05-15 08:50:00 | AAPL | Stock | 4.3754 | 4.3793 | 4.3754 | 4.3793 | 5600.0 |
| 2009-05-15 08:55:00 | AAPL | Stock | 4.385 | 4.385 | 4.3786 | 4.3786 | 37800.0 |
| 2009-05-15 09:00:00 | AAPL | Stock | 4.385 | 4.3871 | 4.3804 | 4.3804 | 39200.0 |
| 2009-05-15 09:05:00 | AAPL | Stock | 4.3786 | 4.3796 | 4.3786 | 4.3789 | 49812.0 |
| 2009-05-15 09:10:00 | AAPL | Stock | 4.3786 | 4.3789 | 4.3775 | 4.3775 | 38332.0 |
| 2009-05-15 09:15:00 | AAPL | Stock | 4.3732 | 4.3771 | 4.3721 | 4.3771 | 51800.0 |
| 2009-05-15 09:20:00 | AAPL | Stock | 4.3775 | 4.3814 | 4.3775 | 4.3775 | 51380.0 |
| 2009-05-15 09:25:00 | AAPL | Stock | 4.3775 | 4.3818 | 4.3646 | 4.3646 | 1131900.0 |
| 2009-05-15 09:30:00 | AAPL | Stock | 4.3654 | 4.3807 | 4.3432 | 4.3764 | 30410772.0 |
| 2009-05-15 09:35:00 | AAPL | Stock | 4.3768 | 4.3911 | 4.3668 | 4.3692 | 15586900.0 |
| 2009-05-15 09:40:00 | AAPL | Stock | 4.3696 | 4.3796 | 4.3596 | 4.3679 | 6765892.0 |
| 2009-05-15 09:45:00 | AAPL | Stock | 4.3707 | 4.3911 | 4.3691 | 4.3896 | 6513248.0 |
| 2009-05-15 09:50:00 | AAPL | Stock | 4.3907 | 4.4121 | 4.3839 | 4.4111 | 7177100.0 |
| 2009-05-15 09:55:00 | AAPL | Stock | 4.4111 | 4.4293 | 4.4075 | 4.4132 | 10966592.0 |
| 2009-05-15 10:00:00 | AAPL | Stock | 4.4125 | 4.4146 | 4.3979 | 4.4104 | 7448168.0 |
| 2009-05-15 10:05:00 | AAPL | Stock | 4.4107 | 4.4314 | 4.41 | 4.4286 | 9415756.0 |
| 2009-05-15 10:10:00 | AAPL | Stock | 4.4286 | 4.43 | 4.4137 | 4.4268 | 5252660.0 |
| 2009-05-15 10:15:00 | AAPL | Stock | 4.4271 | 4.4396 | 4.4239 | 4.435 | 8540056.0 |
| 2009-05-15 10:20:00 | AAPL | Stock | 4.4371 | 4.4411 | 4.4329 | 4.4371 | 5203408.0 |
| 2009-05-15 10:25:00 | AAPL | Stock | 4.4375 | 4.4461 | 4.4321 | 4.4354 | 5998356.0 |
| 2009-05-15 10:30:00 | AAPL | Stock | 4.4354 | 4.45 | 4.4354 | 4.4493 | 5636792.0 |
| 2009-05-15 10:35:00 | AAPL | Stock | 4.4496 | 4.4507 | 4.4386 | 4.4457 | 5493684.0 |
| 2009-05-15 10:40:00 | AAPL | Stock | 4.4461 | 4.4475 | 4.4355 | 4.4361 | 3550456.0 |
| 2009-05-15 10:45:00 | AAPL | Stock | 4.4354 | 4.44 | 4.4307 | 4.4354 | 3933104.0 |
| 2009-05-15 10:50:00 | AAPL | Stock | 4.4354 | 4.4429 | 4.4339 | 4.4354 | 3111780.0 |
| 2009-05-15 10:55:00 | AAPL | Stock | 4.4361 | 4.4461 | 4.4339 | 4.4421 | 3097640.0 |
| 2009-05-15 11:00:00 | AAPL | Stock | 4.4407 | 4.4475 | 4.4268 | 4.4304 | 5905032.0 |
| 2009-05-15 11:05:00 | AAPL | Stock | 4.4307 | 4.4314 | 4.4121 | 4.4179 | 6704460.0 |
| 2009-05-15 11:10:00 | AAPL | Stock | 4.4179 | 4.4271 | 4.4179 | 4.4236 | 3310496.0 |
| 2009-05-15 11:15:00 | AAPL | Stock | 4.4243 | 4.4386 | 4.4239 | 4.4357 | 3968440.0 |
| 2009-05-15 11:20:00 | AAPL | Stock | 4.4371 | 4.4371 | 4.4225 | 4.4293 | 2507512.0 |
| 2009-05-15 11:25:00 | AAPL | Stock | 4.4289 | 4.4289 | 4.4204 | 4.4264 | 1582616.0 |
| 2009-05-15 11:30:00 | AAPL | Stock | 4.4268 | 4.4314 | 4.42 | 4.4218 | 2630544.0 |
| 2009-05-15 11:35:00 | AAPL | Stock | 4.4218 | 4.4286 | 4.4132 | 4.4157 | 2356872.0 |
| 2009-05-15 11:40:00 | AAPL | Stock | 4.4154 | 4.4193 | 4.4121 | 4.4161 | 1705620.0 |
| 2009-05-15 11:45:00 | AAPL | Stock | 4.4161 | 4.4211 | 4.4128 | 4.4157 | 1699404.0 |
| 2009-05-15 11:50:00 | AAPL | Stock | 4.4164 | 4.4196 | 4.4121 | 4.4196 | 2152052.0 |
| 2009-05-15 11:55:00 | AAPL | Stock | 4.4196 | 4.4254 | 4.4121 | 4.4125 | 4079460.0 |
| 2009-05-15 12:00:00 | AAPL | Stock | 4.4121 | 4.4125 | 4.4011 | 4.4064 | 4990048.0 |
| 2009-05-15 12:05:00 | AAPL | Stock | 4.4061 | 4.4121 | 4.4041 | 4.4089 | 2372244.0 |
| 2009-05-15 12:10:00 | AAPL | Stock | 4.4089 | 4.421 | 4.4089 | 4.4182 | 2158324.0 |
| 2009-05-15 12:15:00 | AAPL | Stock | 4.4188 | 4.4189 | 4.4054 | 4.4064 | 1920716.0 |
| 2009-05-15 12:20:00 | AAPL | Stock | 4.4061 | 4.4192 | 4.4054 | 4.4189 | 1559880.0 |
> showing 50 of 319,467 rows — these rows as CSV