PREVIEW / stock_5min / 2005-09-02
file: by_date/stock_5min/2005/2005-09-02.parquet size: 2.6 MB rows: 191,677 symbols: 2,067
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-09-02 08:00:00 | AAPL | Stock | 1.65 | 1.6536 | 1.65 | 1.6532 | 21000.0 |
| 2005-09-02 08:05:00 | AAPL | Stock | 1.6532 | 1.6532 | 1.6518 | 1.6518 | 9800.0 |
| 2005-09-02 08:20:00 | AAPL | Stock | 1.6525 | 1.6525 | 1.6525 | 1.6525 | 28000.0 |
| 2005-09-02 08:30:00 | AAPL | Stock | 1.6536 | 1.6536 | 1.6536 | 1.6536 | 2800.0 |
| 2005-09-02 08:35:00 | AAPL | Stock | 1.6521 | 1.6536 | 1.6521 | 1.6536 | 100996.0 |
| 2005-09-02 08:55:00 | AAPL | Stock | 1.6571 | 1.6571 | 1.6571 | 1.6571 | 28000.0 |
| 2005-09-02 09:05:00 | AAPL | Stock | 1.6521 | 1.6521 | 1.6521 | 1.6521 | 5600.0 |
| 2005-09-02 09:10:00 | AAPL | Stock | 1.6554 | 1.6568 | 1.6554 | 1.6568 | 11480.0 |
| 2005-09-02 09:15:00 | AAPL | Stock | 1.6571 | 1.6571 | 1.6571 | 1.6571 | 5600.0 |
| 2005-09-02 09:20:00 | AAPL | Stock | 1.6571 | 1.6571 | 1.6571 | 1.6571 | 8400.0 |
| 2005-09-02 09:25:00 | AAPL | Stock | 1.6557 | 1.66 | 1.6518 | 1.6554 | 624820.0 |
| 2005-09-02 09:30:00 | AAPL | Stock | 1.6536 | 1.6714 | 1.6536 | 1.665 | 17565940.0 |
| 2005-09-02 09:35:00 | AAPL | Stock | 1.665 | 1.6675 | 1.6614 | 1.6639 | 6794564.0 |
| 2005-09-02 09:40:00 | AAPL | Stock | 1.6639 | 1.6639 | 1.6593 | 1.6621 | 4542104.0 |
| 2005-09-02 09:45:00 | AAPL | Stock | 1.6618 | 1.6625 | 1.6571 | 1.66 | 4961460.0 |
| 2005-09-02 09:50:00 | AAPL | Stock | 1.6596 | 1.66 | 1.6554 | 1.6582 | 3972976.0 |
| 2005-09-02 09:55:00 | AAPL | Stock | 1.6582 | 1.6593 | 1.6554 | 1.6593 | 3541804.0 |
| 2005-09-02 10:00:00 | AAPL | Stock | 1.6589 | 1.6629 | 1.6579 | 1.6611 | 6340852.0 |
| 2005-09-02 10:05:00 | AAPL | Stock | 1.6614 | 1.6643 | 1.6593 | 1.6596 | 7894992.0 |
| 2005-09-02 10:10:00 | AAPL | Stock | 1.66 | 1.6639 | 1.6596 | 1.6629 | 4632488.0 |
| 2005-09-02 10:15:00 | AAPL | Stock | 1.6629 | 1.6636 | 1.6593 | 1.6629 | 4296096.0 |
| 2005-09-02 10:20:00 | AAPL | Stock | 1.6629 | 1.6643 | 1.66 | 1.6607 | 2540468.0 |
| 2005-09-02 10:25:00 | AAPL | Stock | 1.6611 | 1.6625 | 1.6571 | 1.6575 | 4036732.0 |
| 2005-09-02 10:30:00 | AAPL | Stock | 1.6575 | 1.6593 | 1.6536 | 1.6554 | 5667900.0 |
| 2005-09-02 10:35:00 | AAPL | Stock | 1.6557 | 1.6575 | 1.6536 | 1.6539 | 4564616.0 |
| 2005-09-02 10:40:00 | AAPL | Stock | 1.6536 | 1.6571 | 1.6536 | 1.6561 | 3109484.0 |
| 2005-09-02 10:45:00 | AAPL | Stock | 1.6561 | 1.66 | 1.6557 | 1.6596 | 2558920.0 |
| 2005-09-02 10:50:00 | AAPL | Stock | 1.6593 | 1.6604 | 1.6564 | 1.6586 | 3540208.0 |
| 2005-09-02 10:55:00 | AAPL | Stock | 1.6586 | 1.6586 | 1.6546 | 1.6561 | 2785916.0 |
| 2005-09-02 11:00:00 | AAPL | Stock | 1.6557 | 1.6589 | 1.6557 | 1.6564 | 2650452.0 |
| 2005-09-02 11:05:00 | AAPL | Stock | 1.6561 | 1.6575 | 1.655 | 1.6568 | 1629740.0 |
| 2005-09-02 11:10:00 | AAPL | Stock | 1.6568 | 1.6589 | 1.6561 | 1.6564 | 2330272.0 |
| 2005-09-02 11:15:00 | AAPL | Stock | 1.6568 | 1.6589 | 1.6568 | 1.6582 | 1654968.0 |
| 2005-09-02 11:20:00 | AAPL | Stock | 1.6582 | 1.6582 | 1.6554 | 1.656 | 1945720.0 |
| 2005-09-02 11:25:00 | AAPL | Stock | 1.6557 | 1.6582 | 1.6557 | 1.6564 | 1910776.0 |
| 2005-09-02 11:30:00 | AAPL | Stock | 1.6564 | 1.6579 | 1.655 | 1.6571 | 2159528.0 |
| 2005-09-02 11:35:00 | AAPL | Stock | 1.6567 | 1.6575 | 1.6518 | 1.6525 | 4733792.0 |
| 2005-09-02 11:40:00 | AAPL | Stock | 1.6525 | 1.6561 | 1.6521 | 1.6546 | 2324448.0 |
| 2005-09-02 11:45:00 | AAPL | Stock | 1.6546 | 1.6554 | 1.6536 | 1.6539 | 1344644.0 |
| 2005-09-02 11:50:00 | AAPL | Stock | 1.6539 | 1.6546 | 1.6532 | 1.6536 | 871192.0 |
| 2005-09-02 11:55:00 | AAPL | Stock | 1.6539 | 1.6546 | 1.6521 | 1.6543 | 1640464.0 |
| 2005-09-02 12:00:00 | AAPL | Stock | 1.6543 | 1.6554 | 1.6532 | 1.6532 | 937104.0 |
| 2005-09-02 12:05:00 | AAPL | Stock | 1.6532 | 1.6554 | 1.6529 | 1.6539 | 1880732.0 |
| 2005-09-02 12:10:00 | AAPL | Stock | 1.6539 | 1.655 | 1.6532 | 1.6539 | 1139936.0 |
| 2005-09-02 12:15:00 | AAPL | Stock | 1.6539 | 1.6539 | 1.6521 | 1.6529 | 1138760.0 |
| 2005-09-02 12:20:00 | AAPL | Stock | 1.6525 | 1.6532 | 1.6511 | 1.6514 | 1993152.0 |
| 2005-09-02 12:25:00 | AAPL | Stock | 1.6514 | 1.6527 | 1.6507 | 1.6525 | 3183236.0 |
| 2005-09-02 12:30:00 | AAPL | Stock | 1.6525 | 1.6546 | 1.6521 | 1.6543 | 1731604.0 |
| 2005-09-02 12:35:00 | AAPL | Stock | 1.6543 | 1.6543 | 1.6525 | 1.6532 | 1195124.0 |
| 2005-09-02 12:40:00 | AAPL | Stock | 1.6529 | 1.6532 | 1.6504 | 1.6507 | 3843448.0 |
> showing 50 of 191,677 rows — these rows as CSV