PREVIEW / stock_5min / 2010-04-15
file: by_date/stock_5min/2010/2010-04-15.parquet size: 4.9 MB rows: 332,290 symbols: 3,496
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-04-15 04:15:00 | AAPL | Stock | 8.7454 | 8.7454 | 8.745 | 8.745 | 16800.0 |
| 2010-04-15 04:40:00 | AAPL | Stock | 8.75 | 8.75 | 8.75 | 8.75 | 14000.0 |
| 2010-04-15 05:35:00 | AAPL | Stock | 8.7411 | 8.7411 | 8.7411 | 8.7411 | 3108.0 |
| 2010-04-15 05:40:00 | AAPL | Stock | 8.7411 | 8.7411 | 8.7411 | 8.7411 | 5320.0 |
| 2010-04-15 05:50:00 | AAPL | Stock | 8.7411 | 8.7411 | 8.7393 | 8.7393 | 7672.0 |
| 2010-04-15 06:00:00 | AAPL | Stock | 8.7393 | 8.7393 | 8.7393 | 8.7393 | 3080.0 |
| 2010-04-15 06:05:00 | AAPL | Stock | 8.7393 | 8.7393 | 8.7393 | 8.7393 | 4200.0 |
| 2010-04-15 07:00:00 | AAPL | Stock | 8.75 | 8.7518 | 8.75 | 8.7518 | 21000.0 |
| 2010-04-15 07:05:00 | AAPL | Stock | 8.75 | 8.75 | 8.75 | 8.75 | 4200.0 |
| 2010-04-15 07:10:00 | AAPL | Stock | 8.7589 | 8.7589 | 8.7589 | 8.7589 | 12600.0 |
| 2010-04-15 07:15:00 | AAPL | Stock | 8.7589 | 8.7589 | 8.7589 | 8.7589 | 19600.0 |
| 2010-04-15 07:20:00 | AAPL | Stock | 8.7507 | 8.7507 | 8.7507 | 8.7507 | 2800.0 |
| 2010-04-15 07:30:00 | AAPL | Stock | 8.7536 | 8.7536 | 8.7536 | 8.7536 | 11200.0 |
| 2010-04-15 07:40:00 | AAPL | Stock | 8.7536 | 8.7536 | 8.7536 | 8.7536 | 5684.0 |
| 2010-04-15 07:45:00 | AAPL | Stock | 8.7589 | 8.7589 | 8.7589 | 8.7589 | 16800.0 |
| 2010-04-15 07:55:00 | AAPL | Stock | 8.7589 | 8.7589 | 8.7571 | 8.7571 | 13860.0 |
| 2010-04-15 08:00:00 | AAPL | Stock | 8.7586 | 8.7589 | 8.7536 | 8.7589 | 159040.0 |
| 2010-04-15 08:05:00 | AAPL | Stock | 8.7589 | 8.7657 | 8.7589 | 8.7657 | 179060.0 |
| 2010-04-15 08:10:00 | AAPL | Stock | 8.7643 | 8.7643 | 8.7596 | 8.7625 | 82628.0 |
| 2010-04-15 08:15:00 | AAPL | Stock | 8.7607 | 8.7611 | 8.7589 | 8.7607 | 179060.0 |
| 2010-04-15 08:20:00 | AAPL | Stock | 8.76 | 8.7625 | 8.7589 | 8.7625 | 159600.0 |
| 2010-04-15 08:25:00 | AAPL | Stock | 8.7625 | 8.7664 | 8.7625 | 8.7664 | 104580.0 |
| 2010-04-15 08:30:00 | AAPL | Stock | 8.7664 | 8.7664 | 8.7546 | 8.7589 | 665364.0 |
| 2010-04-15 08:35:00 | AAPL | Stock | 8.7604 | 8.7632 | 8.7582 | 8.7632 | 40320.0 |
| 2010-04-15 08:40:00 | AAPL | Stock | 8.7629 | 8.7643 | 8.7593 | 8.7632 | 79716.0 |
| 2010-04-15 08:45:00 | AAPL | Stock | 8.7607 | 8.7657 | 8.7607 | 8.7657 | 89600.0 |
| 2010-04-15 08:50:00 | AAPL | Stock | 8.7657 | 8.7679 | 8.7643 | 8.7679 | 71400.0 |
| 2010-04-15 08:55:00 | AAPL | Stock | 8.7682 | 8.7682 | 8.7668 | 8.7668 | 33600.0 |
| 2010-04-15 09:00:00 | AAPL | Stock | 8.7679 | 8.7718 | 8.7679 | 8.7686 | 92400.0 |
| 2010-04-15 09:05:00 | AAPL | Stock | 8.7671 | 8.7682 | 8.7661 | 8.7682 | 75740.0 |
| 2010-04-15 09:10:00 | AAPL | Stock | 8.7679 | 8.7721 | 8.7679 | 8.7689 | 61460.0 |
| 2010-04-15 09:15:00 | AAPL | Stock | 8.7679 | 8.7679 | 8.7657 | 8.7657 | 72184.0 |
| 2010-04-15 09:20:00 | AAPL | Stock | 8.765 | 8.765 | 8.7607 | 8.7618 | 412356.0 |
| 2010-04-15 09:25:00 | AAPL | Stock | 8.7611 | 8.7836 | 8.7604 | 8.7804 | 875756.0 |
| 2010-04-15 09:30:00 | AAPL | Stock | 8.7775 | 8.785 | 8.7682 | 8.7808 | 10412052.0 |
| 2010-04-15 09:35:00 | AAPL | Stock | 8.7811 | 8.7893 | 8.7771 | 8.7861 | 8351504.0 |
| 2010-04-15 09:40:00 | AAPL | Stock | 8.7861 | 8.7954 | 8.7825 | 8.7946 | 7700504.0 |
| 2010-04-15 09:45:00 | AAPL | Stock | 8.7943 | 8.8086 | 8.7914 | 8.8079 | 8669444.0 |
| 2010-04-15 09:50:00 | AAPL | Stock | 8.8079 | 8.8107 | 8.8036 | 8.8064 | 7327880.0 |
| 2010-04-15 09:55:00 | AAPL | Stock | 8.8057 | 8.8089 | 8.7946 | 8.797 | 6197828.0 |
| 2010-04-15 10:00:00 | AAPL | Stock | 8.7971 | 8.7989 | 8.7918 | 8.7964 | 6420596.0 |
| 2010-04-15 10:05:00 | AAPL | Stock | 8.7964 | 8.8025 | 8.7964 | 8.7997 | 5003012.0 |
| 2010-04-15 10:10:00 | AAPL | Stock | 8.8004 | 8.8025 | 8.7929 | 8.8025 | 4618964.0 |
| 2010-04-15 10:15:00 | AAPL | Stock | 8.8025 | 8.8086 | 8.8007 | 8.8007 | 4952612.0 |
| 2010-04-15 10:20:00 | AAPL | Stock | 8.8014 | 8.8021 | 8.7954 | 8.8004 | 4116728.0 |
| 2010-04-15 10:25:00 | AAPL | Stock | 8.8011 | 8.8043 | 8.7976 | 8.8039 | 3437028.0 |
| 2010-04-15 10:30:00 | AAPL | Stock | 8.8039 | 8.8079 | 8.8004 | 8.8079 | 4240264.0 |
| 2010-04-15 10:35:00 | AAPL | Stock | 8.8082 | 8.8082 | 8.8032 | 8.8061 | 4063416.0 |
| 2010-04-15 10:40:00 | AAPL | Stock | 8.8061 | 8.8204 | 8.8025 | 8.82 | 8858108.0 |
| 2010-04-15 10:45:00 | AAPL | Stock | 8.82 | 8.8204 | 8.8125 | 8.8168 | 4958940.0 |
> showing 50 of 332,290 rows — these rows as CSV