PREVIEW / stock_5min / 2005-08-25
file: by_date/stock_5min/2005/2005-08-25.parquet size: 2.6 MB rows: 196,126 symbols: 2,069
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-08-25 08:00:00 | AAPL | Stock | 1.6411 | 1.6411 | 1.6393 | 1.6411 | 72800.0 |
| 2005-08-25 08:05:00 | AAPL | Stock | 1.6411 | 1.6429 | 1.6411 | 1.6425 | 58800.0 |
| 2005-08-25 08:15:00 | AAPL | Stock | 1.6464 | 1.65 | 1.6464 | 1.65 | 61600.0 |
| 2005-08-25 08:20:00 | AAPL | Stock | 1.65 | 1.6536 | 1.65 | 1.6529 | 162400.0 |
| 2005-08-25 08:25:00 | AAPL | Stock | 1.65 | 1.6518 | 1.6479 | 1.6518 | 47880.0 |
| 2005-08-25 08:30:00 | AAPL | Stock | 1.65 | 1.6536 | 1.65 | 1.6525 | 123200.0 |
| 2005-08-25 08:35:00 | AAPL | Stock | 1.6486 | 1.6486 | 1.6468 | 1.6468 | 96880.0 |
| 2005-08-25 08:40:00 | AAPL | Stock | 1.6464 | 1.6468 | 1.6464 | 1.6468 | 25200.0 |
| 2005-08-25 08:45:00 | AAPL | Stock | 1.6486 | 1.6496 | 1.6468 | 1.6496 | 75600.0 |
| 2005-08-25 08:50:00 | AAPL | Stock | 1.6468 | 1.6471 | 1.6464 | 1.6464 | 53200.0 |
| 2005-08-25 08:55:00 | AAPL | Stock | 1.6464 | 1.6464 | 1.6443 | 1.6446 | 70560.0 |
| 2005-08-25 09:00:00 | AAPL | Stock | 1.6457 | 1.6457 | 1.6446 | 1.6446 | 48160.0 |
| 2005-08-25 09:05:00 | AAPL | Stock | 1.6436 | 1.6464 | 1.6436 | 1.6454 | 37660.0 |
| 2005-08-25 09:10:00 | AAPL | Stock | 1.6454 | 1.6464 | 1.6454 | 1.6464 | 63280.0 |
| 2005-08-25 09:15:00 | AAPL | Stock | 1.6479 | 1.6479 | 1.6454 | 1.6454 | 45920.0 |
| 2005-08-25 09:20:00 | AAPL | Stock | 1.6454 | 1.6479 | 1.6454 | 1.6464 | 200480.0 |
| 2005-08-25 09:25:00 | AAPL | Stock | 1.6429 | 1.6471 | 1.6429 | 1.6471 | 179200.0 |
| 2005-08-25 09:30:00 | AAPL | Stock | 1.6471 | 1.6518 | 1.6446 | 1.6479 | 10524444.0 |
| 2005-08-25 09:35:00 | AAPL | Stock | 1.6475 | 1.6604 | 1.6411 | 1.6561 | 13258392.0 |
| 2005-08-25 09:40:00 | AAPL | Stock | 1.6568 | 1.6604 | 1.65 | 1.6504 | 10934868.0 |
| 2005-08-25 09:45:00 | AAPL | Stock | 1.65 | 1.6564 | 1.6479 | 1.6486 | 8186416.0 |
| 2005-08-25 09:50:00 | AAPL | Stock | 1.6482 | 1.6522 | 1.6436 | 1.6479 | 13458760.0 |
| 2005-08-25 09:55:00 | AAPL | Stock | 1.6482 | 1.6504 | 1.6468 | 1.6486 | 6371456.0 |
| 2005-08-25 10:00:00 | AAPL | Stock | 1.6486 | 1.6518 | 1.6482 | 1.6504 | 3541244.0 |
| 2005-08-25 10:05:00 | AAPL | Stock | 1.6504 | 1.6554 | 1.6475 | 1.6536 | 6015688.0 |
| 2005-08-25 10:10:00 | AAPL | Stock | 1.6536 | 1.6539 | 1.6486 | 1.6511 | 6405980.0 |
| 2005-08-25 10:15:00 | AAPL | Stock | 1.6511 | 1.6529 | 1.6489 | 1.6489 | 5012308.0 |
| 2005-08-25 10:20:00 | AAPL | Stock | 1.6496 | 1.6525 | 1.6489 | 1.6507 | 3226020.0 |
| 2005-08-25 10:25:00 | AAPL | Stock | 1.6507 | 1.6525 | 1.6493 | 1.6518 | 3831912.0 |
| 2005-08-25 10:30:00 | AAPL | Stock | 1.6521 | 1.6561 | 1.6521 | 1.6543 | 7446068.0 |
| 2005-08-25 10:35:00 | AAPL | Stock | 1.6543 | 1.6546 | 1.6521 | 1.6525 | 3334436.0 |
| 2005-08-25 10:40:00 | AAPL | Stock | 1.6525 | 1.6564 | 1.6525 | 1.6557 | 3368568.0 |
| 2005-08-25 10:45:00 | AAPL | Stock | 1.6557 | 1.6564 | 1.6514 | 1.6525 | 3385088.0 |
| 2005-08-25 10:50:00 | AAPL | Stock | 1.6525 | 1.6529 | 1.6504 | 1.6525 | 2780568.0 |
| 2005-08-25 10:55:00 | AAPL | Stock | 1.6518 | 1.6561 | 1.6518 | 1.6539 | 4590544.0 |
| 2005-08-25 11:00:00 | AAPL | Stock | 1.6543 | 1.6554 | 1.6536 | 1.6536 | 1516984.0 |
| 2005-08-25 11:05:00 | AAPL | Stock | 1.6536 | 1.6543 | 1.6529 | 1.6529 | 3424400.0 |
| 2005-08-25 11:10:00 | AAPL | Stock | 1.6529 | 1.6536 | 1.6507 | 1.6535 | 2478532.0 |
| 2005-08-25 11:15:00 | AAPL | Stock | 1.6536 | 1.6539 | 1.6511 | 1.6514 | 2616516.0 |
| 2005-08-25 11:20:00 | AAPL | Stock | 1.6517 | 1.6525 | 1.6503 | 1.6521 | 3190264.0 |
| 2005-08-25 11:25:00 | AAPL | Stock | 1.6521 | 1.6539 | 1.6518 | 1.6525 | 3062220.0 |
| 2005-08-25 11:30:00 | AAPL | Stock | 1.6525 | 1.6529 | 1.65 | 1.6514 | 5572700.0 |
| 2005-08-25 11:35:00 | AAPL | Stock | 1.6514 | 1.6514 | 1.6432 | 1.6432 | 7475636.0 |
| 2005-08-25 11:40:00 | AAPL | Stock | 1.6436 | 1.6461 | 1.6421 | 1.6435 | 4313288.0 |
| 2005-08-25 11:45:00 | AAPL | Stock | 1.6436 | 1.6457 | 1.6429 | 1.6453 | 3306884.0 |
| 2005-08-25 11:50:00 | AAPL | Stock | 1.6454 | 1.6475 | 1.6439 | 1.6454 | 3793580.0 |
| 2005-08-25 11:55:00 | AAPL | Stock | 1.6457 | 1.6475 | 1.6454 | 1.6457 | 1482824.0 |
| 2005-08-25 12:00:00 | AAPL | Stock | 1.6454 | 1.6454 | 1.6429 | 1.6439 | 1434916.0 |
| 2005-08-25 12:05:00 | AAPL | Stock | 1.6439 | 1.6439 | 1.6414 | 1.6425 | 2630376.0 |
| 2005-08-25 12:10:00 | AAPL | Stock | 1.6425 | 1.6425 | 1.6411 | 1.6411 | 1136884.0 |
> showing 50 of 196,126 rows — these rows as CSV