PREVIEW / stock_5min / 2010-10-20
file: by_date/stock_5min/2010/2010-10-20.parquet size: 4.7 MB rows: 322,014 symbols: 3,493
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-20 04:05:00 | AAPL | Stock | 11.0318 | 11.0571 | 11.0318 | 11.0571 | 16800.0 |
| 2010-10-20 04:10:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.0321 | 11.0321 | 5600.0 |
| 2010-10-20 05:00:00 | AAPL | Stock | 11.0446 | 11.0446 | 11.0446 | 11.0446 | 2800.0 |
| 2010-10-20 05:05:00 | AAPL | Stock | 11.0489 | 11.0489 | 11.0489 | 11.0489 | 2800.0 |
| 2010-10-20 05:40:00 | AAPL | Stock | 11.0346 | 11.0346 | 11.0346 | 11.0346 | 19880.0 |
| 2010-10-20 05:55:00 | AAPL | Stock | 11.0346 | 11.0346 | 11.0346 | 11.0346 | 11172.0 |
| 2010-10-20 06:05:00 | AAPL | Stock | 11.0446 | 11.0446 | 11.0446 | 11.0446 | 8400.0 |
| 2010-10-20 06:10:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.0536 | 11.0536 | 2800.0 |
| 2010-10-20 06:15:00 | AAPL | Stock | 11.0446 | 11.0446 | 11.0446 | 11.0446 | 5600.0 |
| 2010-10-20 06:25:00 | AAPL | Stock | 11.0446 | 11.0446 | 11.0318 | 11.0368 | 25200.0 |
| 2010-10-20 06:30:00 | AAPL | Stock | 11.0293 | 11.0536 | 11.0179 | 11.0179 | 45836.0 |
| 2010-10-20 06:35:00 | AAPL | Stock | 11.0229 | 11.0357 | 11.0229 | 11.0357 | 11200.0 |
| 2010-10-20 07:00:00 | AAPL | Stock | 11.0268 | 11.0268 | 11.0232 | 11.0268 | 42000.0 |
| 2010-10-20 07:05:00 | AAPL | Stock | 11.0325 | 11.0343 | 11.0318 | 11.0343 | 64400.0 |
| 2010-10-20 07:10:00 | AAPL | Stock | 11.0389 | 11.0439 | 11.0375 | 11.0393 | 84140.0 |
| 2010-10-20 07:15:00 | AAPL | Stock | 11.0425 | 11.0432 | 11.0411 | 11.0411 | 47600.0 |
| 2010-10-20 07:20:00 | AAPL | Stock | 11.0418 | 11.0418 | 11.0357 | 11.0357 | 28224.0 |
| 2010-10-20 07:25:00 | AAPL | Stock | 11.0418 | 11.0418 | 11.0418 | 11.0418 | 2800.0 |
| 2010-10-20 07:30:00 | AAPL | Stock | 11.0411 | 11.0418 | 11.035 | 11.0357 | 148820.0 |
| 2010-10-20 07:35:00 | AAPL | Stock | 11.0375 | 11.0382 | 11.0357 | 11.0361 | 49000.0 |
| 2010-10-20 07:40:00 | AAPL | Stock | 11.0357 | 11.0446 | 11.0357 | 11.0411 | 22400.0 |
| 2010-10-20 07:45:00 | AAPL | Stock | 11.0464 | 11.0639 | 11.045 | 11.0618 | 136892.0 |
| 2010-10-20 07:50:00 | AAPL | Stock | 11.0539 | 11.0568 | 11.045 | 11.0529 | 120120.0 |
| 2010-10-20 07:55:00 | AAPL | Stock | 11.0564 | 11.0571 | 11.0482 | 11.0536 | 36260.0 |
| 2010-10-20 08:00:00 | AAPL | Stock | 11.05 | 11.0536 | 11.03 | 11.0446 | 412356.0 |
| 2010-10-20 08:05:00 | AAPL | Stock | 11.0446 | 11.0679 | 11.0429 | 11.0679 | 355292.0 |
| 2010-10-20 08:10:00 | AAPL | Stock | 11.0679 | 11.0686 | 11.0518 | 11.0571 | 363916.0 |
| 2010-10-20 08:15:00 | AAPL | Stock | 11.0607 | 11.0607 | 11.0221 | 11.0293 | 859880.0 |
| 2010-10-20 08:20:00 | AAPL | Stock | 11.0286 | 11.0411 | 11.0225 | 11.0321 | 458864.0 |
| 2010-10-20 08:25:00 | AAPL | Stock | 11.0304 | 11.0318 | 11.0196 | 11.0268 | 539560.0 |
| 2010-10-20 08:30:00 | AAPL | Stock | 11.0261 | 11.0296 | 11.025 | 11.0282 | 256172.0 |
| 2010-10-20 08:35:00 | AAPL | Stock | 11.0268 | 11.0275 | 11.0 | 11.0054 | 678244.0 |
| 2010-10-20 08:40:00 | AAPL | Stock | 11.0079 | 11.0214 | 11.0004 | 11.0143 | 681240.0 |
| 2010-10-20 08:45:00 | AAPL | Stock | 11.0139 | 11.0407 | 11.0125 | 11.0393 | 788816.0 |
| 2010-10-20 08:50:00 | AAPL | Stock | 11.0393 | 11.0421 | 11.0296 | 11.0296 | 832664.0 |
| 2010-10-20 08:55:00 | AAPL | Stock | 11.0293 | 11.0314 | 11.0229 | 11.0279 | 260204.0 |
| 2010-10-20 09:00:00 | AAPL | Stock | 11.0275 | 11.0379 | 11.0275 | 11.0379 | 276836.0 |
| 2010-10-20 09:05:00 | AAPL | Stock | 11.0339 | 11.0382 | 11.0318 | 11.0357 | 112000.0 |
| 2010-10-20 09:10:00 | AAPL | Stock | 11.0339 | 11.0486 | 11.0321 | 11.0421 | 252364.0 |
| 2010-10-20 09:15:00 | AAPL | Stock | 11.0407 | 11.0414 | 11.0321 | 11.0321 | 223552.0 |
| 2010-10-20 09:20:00 | AAPL | Stock | 11.0321 | 11.0321 | 11.0189 | 11.025 | 408968.0 |
| 2010-10-20 09:25:00 | AAPL | Stock | 11.0282 | 11.0446 | 11.025 | 11.0354 | 308476.0 |
| 2010-10-20 09:30:00 | AAPL | Stock | 11.0357 | 11.1 | 11.0257 | 11.0754 | 25103680.0 |
| 2010-10-20 09:35:00 | AAPL | Stock | 11.0747 | 11.0875 | 11.0 | 11.0061 | 21599844.0 |
| 2010-10-20 09:40:00 | AAPL | Stock | 11.0075 | 11.0711 | 11.0004 | 11.0643 | 15714272.0 |
| 2010-10-20 09:45:00 | AAPL | Stock | 11.0657 | 11.0714 | 11.0129 | 11.0207 | 13238344.0 |
| 2010-10-20 09:50:00 | AAPL | Stock | 11.0214 | 11.0464 | 10.9968 | 11.0164 | 12616968.0 |
| 2010-10-20 09:55:00 | AAPL | Stock | 11.0143 | 11.0364 | 11.0136 | 11.0314 | 10031812.0 |
| 2010-10-20 10:00:00 | AAPL | Stock | 11.0321 | 11.0432 | 11.02 | 11.0261 | 9754136.0 |
| 2010-10-20 10:05:00 | AAPL | Stock | 11.0261 | 11.0396 | 11.0007 | 11.0036 | 11445868.0 |
> showing 50 of 322,014 rows — these rows as CSV