PREVIEW / stock_5min / 2005-12-09
file: by_date/stock_5min/2005/2005-12-09.parquet size: 2.7 MB rows: 191,434 symbols: 2,053
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-12-09 06:55:00 | AAPL | Stock | 2.6496 | 2.6496 | 2.6496 | 2.6496 | 5600.0 |
| 2005-12-09 07:50:00 | AAPL | Stock | 2.6339 | 2.6339 | 2.6339 | 2.6339 | 5152.0 |
| 2005-12-09 08:00:00 | AAPL | Stock | 2.6375 | 2.6429 | 2.6339 | 2.6379 | 105336.0 |
| 2005-12-09 08:05:00 | AAPL | Stock | 2.6375 | 2.6407 | 2.6357 | 2.6357 | 130900.0 |
| 2005-12-09 08:10:00 | AAPL | Stock | 2.6357 | 2.6375 | 2.6357 | 2.6375 | 87976.0 |
| 2005-12-09 08:15:00 | AAPL | Stock | 2.6368 | 2.64 | 2.6368 | 2.64 | 68600.0 |
| 2005-12-09 08:20:00 | AAPL | Stock | 2.6379 | 2.6464 | 2.6379 | 2.6429 | 270032.0 |
| 2005-12-09 08:25:00 | AAPL | Stock | 2.6464 | 2.65 | 2.6464 | 2.65 | 95844.0 |
| 2005-12-09 08:30:00 | AAPL | Stock | 2.65 | 2.65 | 2.65 | 2.65 | 14000.0 |
| 2005-12-09 08:35:00 | AAPL | Stock | 2.6471 | 2.6518 | 2.6471 | 2.6496 | 163828.0 |
| 2005-12-09 08:40:00 | AAPL | Stock | 2.6496 | 2.6496 | 2.6471 | 2.6471 | 156800.0 |
| 2005-12-09 08:45:00 | AAPL | Stock | 2.6475 | 2.65 | 2.6475 | 2.65 | 313600.0 |
| 2005-12-09 08:50:00 | AAPL | Stock | 2.65 | 2.65 | 2.6486 | 2.65 | 118412.0 |
| 2005-12-09 08:55:00 | AAPL | Stock | 2.6489 | 2.6496 | 2.6486 | 2.6486 | 136500.0 |
| 2005-12-09 09:00:00 | AAPL | Stock | 2.6486 | 2.6486 | 2.6479 | 2.6479 | 185388.0 |
| 2005-12-09 09:05:00 | AAPL | Stock | 2.6464 | 2.6464 | 2.6439 | 2.6439 | 142800.0 |
| 2005-12-09 09:10:00 | AAPL | Stock | 2.6443 | 2.6446 | 2.6429 | 2.6436 | 226772.0 |
| 2005-12-09 09:15:00 | AAPL | Stock | 2.6429 | 2.6489 | 2.6429 | 2.6489 | 114380.0 |
| 2005-12-09 09:20:00 | AAPL | Stock | 2.6446 | 2.6457 | 2.6446 | 2.6457 | 35056.0 |
| 2005-12-09 09:25:00 | AAPL | Stock | 2.6464 | 2.6507 | 2.6464 | 2.6507 | 476168.0 |
| 2005-12-09 09:30:00 | AAPL | Stock | 2.6504 | 2.6554 | 2.6386 | 2.6504 | 16813524.0 |
| 2005-12-09 09:35:00 | AAPL | Stock | 2.65 | 2.6589 | 2.6482 | 2.6568 | 17114020.0 |
| 2005-12-09 09:40:00 | AAPL | Stock | 2.6564 | 2.6639 | 2.6446 | 2.6479 | 19157264.0 |
| 2005-12-09 09:45:00 | AAPL | Stock | 2.6479 | 2.6504 | 2.6396 | 2.6436 | 13638016.0 |
| 2005-12-09 09:50:00 | AAPL | Stock | 2.6436 | 2.6464 | 2.6346 | 2.6411 | 13884836.0 |
| 2005-12-09 09:55:00 | AAPL | Stock | 2.6411 | 2.6411 | 2.6336 | 2.6375 | 10459932.0 |
| 2005-12-09 10:00:00 | AAPL | Stock | 2.6371 | 2.6393 | 2.6314 | 2.6371 | 10558660.0 |
| 2005-12-09 10:05:00 | AAPL | Stock | 2.6368 | 2.6511 | 2.6354 | 2.6411 | 8541260.0 |
| 2005-12-09 10:10:00 | AAPL | Stock | 2.6411 | 2.6418 | 2.6354 | 2.6361 | 6000036.0 |
| 2005-12-09 10:15:00 | AAPL | Stock | 2.6364 | 2.6418 | 2.6357 | 2.6389 | 5998692.0 |
| 2005-12-09 10:20:00 | AAPL | Stock | 2.6389 | 2.6407 | 2.6346 | 2.6357 | 6170528.0 |
| 2005-12-09 10:25:00 | AAPL | Stock | 2.6357 | 2.6382 | 2.6329 | 2.6368 | 6399680.0 |
| 2005-12-09 10:30:00 | AAPL | Stock | 2.6371 | 2.6393 | 2.6332 | 2.6364 | 5385296.0 |
| 2005-12-09 10:35:00 | AAPL | Stock | 2.6364 | 2.6364 | 2.6218 | 2.6275 | 15526168.0 |
| 2005-12-09 10:40:00 | AAPL | Stock | 2.6275 | 2.6293 | 2.6236 | 2.6243 | 5905956.0 |
| 2005-12-09 10:45:00 | AAPL | Stock | 2.6243 | 2.6304 | 2.6196 | 2.6293 | 9179520.0 |
| 2005-12-09 10:50:00 | AAPL | Stock | 2.6293 | 2.6332 | 2.6286 | 2.6318 | 5068728.0 |
| 2005-12-09 10:55:00 | AAPL | Stock | 2.6321 | 2.6364 | 2.6304 | 2.6343 | 4470732.0 |
| 2005-12-09 11:00:00 | AAPL | Stock | 2.6339 | 2.6379 | 2.6332 | 2.6357 | 3710000.0 |
| 2005-12-09 11:05:00 | AAPL | Stock | 2.6357 | 2.6489 | 2.6343 | 2.6482 | 10566752.0 |
| 2005-12-09 11:10:00 | AAPL | Stock | 2.6489 | 2.6539 | 2.6468 | 2.6471 | 14461468.0 |
| 2005-12-09 11:15:00 | AAPL | Stock | 2.6468 | 2.6471 | 2.6357 | 2.6361 | 7870800.0 |
| 2005-12-09 11:20:00 | AAPL | Stock | 2.6357 | 2.6393 | 2.6343 | 2.6371 | 6886656.0 |
| 2005-12-09 11:25:00 | AAPL | Stock | 2.6371 | 2.6389 | 2.635 | 2.6354 | 4069632.0 |
| 2005-12-09 11:30:00 | AAPL | Stock | 2.6354 | 2.6375 | 2.6321 | 2.6346 | 5269152.0 |
| 2005-12-09 11:35:00 | AAPL | Stock | 2.6346 | 2.6389 | 2.6346 | 2.6379 | 4949644.0 |
| 2005-12-09 11:40:00 | AAPL | Stock | 2.6375 | 2.6382 | 2.6314 | 2.6346 | 6162240.0 |
| 2005-12-09 11:45:00 | AAPL | Stock | 2.635 | 2.6357 | 2.6311 | 2.6314 | 2096024.0 |
| 2005-12-09 11:50:00 | AAPL | Stock | 2.6318 | 2.635 | 2.6314 | 2.6336 | 2091404.0 |
| 2005-12-09 11:55:00 | AAPL | Stock | 2.6336 | 2.6336 | 2.625 | 2.6282 | 6871844.0 |
> showing 50 of 191,434 rows — these rows as CSV