PREVIEW / stock_5min / 2010-10-04
file: by_date/stock_5min/2010/2010-10-04.parquet size: 4.7 MB rows: 326,243 symbols: 3,488
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-04 04:30:00 | AAPL | Stock | 10.0396 | 10.0396 | 10.0396 | 10.0396 | 2800.0 |
| 2010-10-04 05:10:00 | AAPL | Stock | 10.0357 | 10.0357 | 10.0357 | 10.0357 | 2800.0 |
| 2010-10-04 05:20:00 | AAPL | Stock | 10.0375 | 10.0375 | 10.0375 | 10.0375 | 2800.0 |
| 2010-10-04 05:45:00 | AAPL | Stock | 10.0357 | 10.0357 | 10.0357 | 10.0357 | 2800.0 |
| 2010-10-04 06:30:00 | AAPL | Stock | 10.0321 | 10.0321 | 10.0321 | 10.0321 | 2800.0 |
| 2010-10-04 06:35:00 | AAPL | Stock | 10.0321 | 10.0321 | 10.0321 | 10.0321 | 14000.0 |
| 2010-10-04 07:00:00 | AAPL | Stock | 10.0679 | 10.0679 | 10.0643 | 10.0643 | 10080.0 |
| 2010-10-04 07:10:00 | AAPL | Stock | 10.0621 | 10.0621 | 10.0621 | 10.0621 | 2800.0 |
| 2010-10-04 07:15:00 | AAPL | Stock | 10.0607 | 10.0607 | 10.0607 | 10.0607 | 5600.0 |
| 2010-10-04 07:20:00 | AAPL | Stock | 10.0643 | 10.0714 | 10.0643 | 10.0714 | 9800.0 |
| 2010-10-04 07:25:00 | AAPL | Stock | 10.0775 | 10.0775 | 10.0775 | 10.0775 | 14000.0 |
| 2010-10-04 07:35:00 | AAPL | Stock | 10.0714 | 10.0768 | 10.0714 | 10.0768 | 5600.0 |
| 2010-10-04 07:40:00 | AAPL | Stock | 10.07 | 10.07 | 10.0696 | 10.0696 | 13300.0 |
| 2010-10-04 07:50:00 | AAPL | Stock | 10.0464 | 10.0464 | 10.0464 | 10.0464 | 5600.0 |
| 2010-10-04 07:55:00 | AAPL | Stock | 10.0539 | 10.0543 | 10.0539 | 10.0543 | 33600.0 |
| 2010-10-04 08:00:00 | AAPL | Stock | 10.0636 | 10.0871 | 10.0539 | 10.0854 | 294392.0 |
| 2010-10-04 08:05:00 | AAPL | Stock | 10.085 | 10.085 | 10.0671 | 10.0671 | 205380.0 |
| 2010-10-04 08:10:00 | AAPL | Stock | 10.0682 | 10.0682 | 10.0636 | 10.0636 | 101024.0 |
| 2010-10-04 08:15:00 | AAPL | Stock | 10.0711 | 10.0711 | 10.0632 | 10.0632 | 50148.0 |
| 2010-10-04 08:20:00 | AAPL | Stock | 10.0607 | 10.0614 | 10.0607 | 10.0614 | 8400.0 |
| 2010-10-04 08:25:00 | AAPL | Stock | 10.0614 | 10.0618 | 10.0536 | 10.0554 | 107464.0 |
| 2010-10-04 08:30:00 | AAPL | Stock | 10.0554 | 10.0643 | 10.0546 | 10.0607 | 252336.0 |
| 2010-10-04 08:35:00 | AAPL | Stock | 10.0543 | 10.055 | 10.0429 | 10.055 | 147336.0 |
| 2010-10-04 08:40:00 | AAPL | Stock | 10.05 | 10.0571 | 10.05 | 10.0521 | 51352.0 |
| 2010-10-04 08:45:00 | AAPL | Stock | 10.05 | 10.0621 | 10.05 | 10.0571 | 84000.0 |
| 2010-10-04 08:50:00 | AAPL | Stock | 10.06 | 10.0604 | 10.0586 | 10.0604 | 30100.0 |
| 2010-10-04 08:55:00 | AAPL | Stock | 10.0561 | 10.0589 | 10.0561 | 10.0561 | 47600.0 |
| 2010-10-04 09:00:00 | AAPL | Stock | 10.0543 | 10.0596 | 10.0532 | 10.0596 | 25200.0 |
| 2010-10-04 09:05:00 | AAPL | Stock | 10.0554 | 10.0575 | 10.0518 | 10.0539 | 186228.0 |
| 2010-10-04 09:10:00 | AAPL | Stock | 10.0536 | 10.0554 | 10.0504 | 10.0554 | 50400.0 |
| 2010-10-04 09:15:00 | AAPL | Stock | 10.0557 | 10.0561 | 10.05 | 10.0521 | 78400.0 |
| 2010-10-04 09:20:00 | AAPL | Stock | 10.0536 | 10.0539 | 10.0521 | 10.0532 | 270760.0 |
| 2010-10-04 09:25:00 | AAPL | Stock | 10.0532 | 10.0536 | 10.0464 | 10.0529 | 222852.0 |
| 2010-10-04 09:30:00 | AAPL | Stock | 10.0571 | 10.0679 | 10.0233 | 10.0575 | 14335720.0 |
| 2010-10-04 09:35:00 | AAPL | Stock | 10.0561 | 10.0718 | 10.0204 | 10.0416 | 14558600.0 |
| 2010-10-04 09:40:00 | AAPL | Stock | 10.0416 | 10.098 | 10.0143 | 10.0914 | 16295776.0 |
| 2010-10-04 09:45:00 | AAPL | Stock | 10.0917 | 10.1036 | 10.0643 | 10.0743 | 13612788.0 |
| 2010-10-04 09:50:00 | AAPL | Stock | 10.0771 | 10.0975 | 10.0471 | 10.0518 | 10394468.0 |
| 2010-10-04 09:55:00 | AAPL | Stock | 10.0523 | 10.0761 | 10.0432 | 10.0625 | 8061508.0 |
| 2010-10-04 10:00:00 | AAPL | Stock | 10.0632 | 10.0786 | 10.0393 | 10.0504 | 12991272.0 |
| 2010-10-04 10:05:00 | AAPL | Stock | 10.05 | 10.0629 | 10.0429 | 10.0561 | 5552708.0 |
| 2010-10-04 10:10:00 | AAPL | Stock | 10.0561 | 10.0632 | 10.045 | 10.0518 | 3751860.0 |
| 2010-10-04 10:15:00 | AAPL | Stock | 10.0517 | 10.0779 | 10.0489 | 10.0707 | 5462604.0 |
| 2010-10-04 10:20:00 | AAPL | Stock | 10.0694 | 10.0768 | 10.0611 | 10.0725 | 4948104.0 |
| 2010-10-04 10:25:00 | AAPL | Stock | 10.0737 | 10.0737 | 10.0564 | 10.0614 | 2933364.0 |
| 2010-10-04 10:30:00 | AAPL | Stock | 10.0587 | 10.0693 | 10.0546 | 10.0568 | 3489444.0 |
| 2010-10-04 10:35:00 | AAPL | Stock | 10.0561 | 10.0593 | 10.0482 | 10.0564 | 4360356.0 |
| 2010-10-04 10:40:00 | AAPL | Stock | 10.0521 | 10.0564 | 10.0421 | 10.0421 | 3534440.0 |
| 2010-10-04 10:45:00 | AAPL | Stock | 10.0421 | 10.0518 | 10.0414 | 10.0473 | 5720848.0 |
| 2010-10-04 10:50:00 | AAPL | Stock | 10.0464 | 10.0521 | 10.0414 | 10.0471 | 3886344.0 |
> showing 50 of 326,243 rows — these rows as CSV