PREVIEW / stock_5min / 2009-07-28
file: by_date/stock_5min/2009/2009-07-28.parquet size: 4.6 MB rows: 317,071 symbols: 3,353
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-07-28 07:00:00 | AAPL | Stock | 5.6804 | 5.6804 | 5.6804 | 5.6804 | 47264.0 |
| 2009-07-28 07:30:00 | AAPL | Stock | 5.675 | 5.675 | 5.675 | 5.675 | 5600.0 |
| 2009-07-28 07:35:00 | AAPL | Stock | 5.675 | 5.675 | 5.675 | 5.675 | 26404.0 |
| 2009-07-28 07:40:00 | AAPL | Stock | 5.6782 | 5.6782 | 5.6782 | 5.6782 | 2800.0 |
| 2009-07-28 07:45:00 | AAPL | Stock | 5.6782 | 5.6786 | 5.6771 | 5.6786 | 44800.0 |
| 2009-07-28 08:00:00 | AAPL | Stock | 5.67 | 5.6893 | 5.6696 | 5.6736 | 107296.0 |
| 2009-07-28 08:05:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6786 | 5.6786 | 94360.0 |
| 2009-07-28 08:10:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6725 | 5.6775 | 11620.0 |
| 2009-07-28 08:15:00 | AAPL | Stock | 5.6714 | 5.675 | 5.6714 | 5.6714 | 45556.0 |
| 2009-07-28 08:20:00 | AAPL | Stock | 5.6782 | 5.6782 | 5.675 | 5.6757 | 21000.0 |
| 2009-07-28 08:25:00 | AAPL | Stock | 5.6782 | 5.6786 | 5.675 | 5.6786 | 138740.0 |
| 2009-07-28 08:30:00 | AAPL | Stock | 5.6779 | 5.6786 | 5.6718 | 5.6718 | 63560.0 |
| 2009-07-28 08:35:00 | AAPL | Stock | 5.6732 | 5.6732 | 5.6718 | 5.6718 | 18536.0 |
| 2009-07-28 08:40:00 | AAPL | Stock | 5.6771 | 5.6771 | 5.675 | 5.6757 | 45080.0 |
| 2009-07-28 08:45:00 | AAPL | Stock | 5.6732 | 5.6732 | 5.6725 | 5.6732 | 36400.0 |
| 2009-07-28 08:50:00 | AAPL | Stock | 5.6746 | 5.6746 | 5.6714 | 5.6714 | 42252.0 |
| 2009-07-28 08:55:00 | AAPL | Stock | 5.6714 | 5.7179 | 5.67 | 5.6718 | 272328.0 |
| 2009-07-28 09:00:00 | AAPL | Stock | 5.6721 | 5.6746 | 5.6679 | 5.6718 | 143920.0 |
| 2009-07-28 09:05:00 | AAPL | Stock | 5.6721 | 5.6782 | 5.6721 | 5.675 | 99176.0 |
| 2009-07-28 09:10:00 | AAPL | Stock | 5.6768 | 5.6768 | 5.675 | 5.6764 | 49840.0 |
| 2009-07-28 09:15:00 | AAPL | Stock | 5.6771 | 5.6771 | 5.6768 | 5.6768 | 51940.0 |
| 2009-07-28 09:20:00 | AAPL | Stock | 5.6771 | 5.6786 | 5.6718 | 5.6718 | 150500.0 |
| 2009-07-28 09:25:00 | AAPL | Stock | 5.6725 | 5.6779 | 5.6721 | 5.6761 | 64400.0 |
| 2009-07-28 09:30:00 | AAPL | Stock | 5.6771 | 5.6957 | 5.6636 | 5.6711 | 12595492.0 |
| 2009-07-28 09:35:00 | AAPL | Stock | 5.6714 | 5.6771 | 5.6436 | 5.6604 | 15656984.0 |
| 2009-07-28 09:40:00 | AAPL | Stock | 5.6614 | 5.6707 | 5.6582 | 5.6643 | 8927632.0 |
| 2009-07-28 09:45:00 | AAPL | Stock | 5.665 | 5.6857 | 5.6557 | 5.6857 | 10327380.0 |
| 2009-07-28 09:50:00 | AAPL | Stock | 5.6857 | 5.6875 | 5.6636 | 5.6704 | 7950572.0 |
| 2009-07-28 09:55:00 | AAPL | Stock | 5.6704 | 5.6825 | 5.6636 | 5.6736 | 6564628.0 |
| 2009-07-28 10:00:00 | AAPL | Stock | 5.6736 | 5.6757 | 5.6593 | 5.6618 | 9200464.0 |
| 2009-07-28 10:05:00 | AAPL | Stock | 5.6618 | 5.6679 | 5.655 | 5.66 | 5039440.0 |
| 2009-07-28 10:10:00 | AAPL | Stock | 5.6604 | 5.6682 | 5.6486 | 5.6514 | 6068020.0 |
| 2009-07-28 10:15:00 | AAPL | Stock | 5.6514 | 5.6636 | 5.645 | 5.6614 | 6021344.0 |
| 2009-07-28 10:20:00 | AAPL | Stock | 5.662 | 5.6707 | 5.6571 | 5.6579 | 4673368.0 |
| 2009-07-28 10:25:00 | AAPL | Stock | 5.6579 | 5.6714 | 5.6561 | 5.6654 | 3486756.0 |
| 2009-07-28 10:30:00 | AAPL | Stock | 5.6654 | 5.6746 | 5.6639 | 5.6646 | 4207224.0 |
| 2009-07-28 10:35:00 | AAPL | Stock | 5.6654 | 5.6696 | 5.6589 | 5.6619 | 4042416.0 |
| 2009-07-28 10:40:00 | AAPL | Stock | 5.6611 | 5.6657 | 5.6525 | 5.6632 | 3069668.0 |
| 2009-07-28 10:45:00 | AAPL | Stock | 5.6639 | 5.6721 | 5.6611 | 5.6693 | 2272312.0 |
| 2009-07-28 10:50:00 | AAPL | Stock | 5.6682 | 5.6689 | 5.6614 | 5.6614 | 1473416.0 |
| 2009-07-28 10:55:00 | AAPL | Stock | 5.6614 | 5.6636 | 5.6589 | 5.66 | 1704780.0 |
| 2009-07-28 11:00:00 | AAPL | Stock | 5.6593 | 5.6596 | 5.6457 | 5.6539 | 3461948.0 |
| 2009-07-28 11:05:00 | AAPL | Stock | 5.6525 | 5.6593 | 5.6518 | 5.6543 | 3010364.0 |
| 2009-07-28 11:10:00 | AAPL | Stock | 5.6542 | 5.6564 | 5.6504 | 5.6532 | 3201856.0 |
| 2009-07-28 11:15:00 | AAPL | Stock | 5.6537 | 5.6543 | 5.6496 | 5.6518 | 2660672.0 |
| 2009-07-28 11:20:00 | AAPL | Stock | 5.6507 | 5.6536 | 5.6446 | 5.6471 | 4079488.0 |
| 2009-07-28 11:25:00 | AAPL | Stock | 5.6461 | 5.6464 | 5.6375 | 5.6414 | 6804952.0 |
| 2009-07-28 11:30:00 | AAPL | Stock | 5.6414 | 5.6429 | 5.6321 | 5.6322 | 5133604.0 |
| 2009-07-28 11:35:00 | AAPL | Stock | 5.6321 | 5.6393 | 5.6293 | 5.6346 | 5525548.0 |
| 2009-07-28 11:40:00 | AAPL | Stock | 5.6339 | 5.6379 | 5.6286 | 5.6331 | 3688776.0 |
> showing 50 of 317,071 rows — these rows as CSV