PREVIEW / stock_5min / 2007-08-24
file: by_date/stock_5min/2007/2007-08-24.parquet size: 3.9 MB rows: 292,150 symbols: 3,101
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-24 09:30:00 | AAPL | Stock | 4.6618 | 4.6839 | 4.6468 | 4.6604 | 22752408.0 |
| 2007-08-24 09:35:00 | AAPL | Stock | 4.6611 | 4.6661 | 4.6361 | 4.645 | 12056548.0 |
| 2007-08-24 09:40:00 | AAPL | Stock | 4.6454 | 4.6618 | 4.6411 | 4.6532 | 9381988.0 |
| 2007-08-24 09:45:00 | AAPL | Stock | 4.6525 | 4.675 | 4.6482 | 4.6675 | 11764872.0 |
| 2007-08-24 09:50:00 | AAPL | Stock | 4.6679 | 4.6989 | 4.6671 | 4.6871 | 17799684.0 |
| 2007-08-24 09:55:00 | AAPL | Stock | 4.6868 | 4.6954 | 4.6793 | 4.6893 | 10582852.0 |
| 2007-08-24 10:00:00 | AAPL | Stock | 4.6893 | 4.7143 | 4.6893 | 4.7071 | 27382040.0 |
| 2007-08-24 10:05:00 | AAPL | Stock | 4.7075 | 4.7379 | 4.7 | 4.73 | 27096244.0 |
| 2007-08-24 10:10:00 | AAPL | Stock | 4.7296 | 4.7429 | 4.7236 | 4.7254 | 20521704.0 |
| 2007-08-24 10:15:00 | AAPL | Stock | 4.7257 | 4.7436 | 4.72 | 4.7404 | 17228680.0 |
| 2007-08-24 10:20:00 | AAPL | Stock | 4.7406 | 4.7475 | 4.7332 | 4.7404 | 18440996.0 |
| 2007-08-24 10:25:00 | AAPL | Stock | 4.7404 | 4.7407 | 4.7071 | 4.7304 | 14523992.0 |
| 2007-08-24 10:30:00 | AAPL | Stock | 4.7311 | 4.7407 | 4.7286 | 4.7321 | 10339784.0 |
| 2007-08-24 10:35:00 | AAPL | Stock | 4.7321 | 4.7375 | 4.7321 | 4.7321 | 7917252.0 |
| 2007-08-24 10:40:00 | AAPL | Stock | 4.7321 | 4.7393 | 4.73 | 4.7354 | 10539732.0 |
| 2007-08-24 10:45:00 | AAPL | Stock | 4.7357 | 4.7446 | 4.7304 | 4.7379 | 10866716.0 |
| 2007-08-24 10:50:00 | AAPL | Stock | 4.7371 | 4.7425 | 4.7325 | 4.7421 | 8130388.0 |
| 2007-08-24 10:55:00 | AAPL | Stock | 4.7411 | 4.7707 | 4.74 | 4.7629 | 27879852.0 |
| 2007-08-24 11:00:00 | AAPL | Stock | 4.7625 | 4.7746 | 4.7557 | 4.7718 | 14491680.0 |
| 2007-08-24 11:05:00 | AAPL | Stock | 4.7707 | 4.7929 | 4.77 | 4.7918 | 27352780.0 |
| 2007-08-24 11:10:00 | AAPL | Stock | 4.7911 | 4.8021 | 4.7829 | 4.8014 | 21777588.0 |
| 2007-08-24 11:15:00 | AAPL | Stock | 4.8014 | 4.8025 | 4.7882 | 4.7895 | 16833376.0 |
| 2007-08-24 11:20:00 | AAPL | Stock | 4.7901 | 4.8 | 4.7839 | 4.7962 | 11597040.0 |
| 2007-08-24 11:25:00 | AAPL | Stock | 4.7961 | 4.8054 | 4.7811 | 4.7818 | 18668524.0 |
| 2007-08-24 11:30:00 | AAPL | Stock | 4.7811 | 4.7904 | 4.7782 | 4.7846 | 15053920.0 |
| 2007-08-24 11:35:00 | AAPL | Stock | 4.7829 | 4.7929 | 4.7786 | 4.7814 | 9308656.0 |
| 2007-08-24 11:40:00 | AAPL | Stock | 4.7811 | 4.7929 | 4.7707 | 4.7793 | 11657772.0 |
| 2007-08-24 11:45:00 | AAPL | Stock | 4.7793 | 4.7854 | 4.775 | 4.7852 | 5943476.0 |
| 2007-08-24 11:50:00 | AAPL | Stock | 4.7857 | 4.7986 | 4.7843 | 4.7896 | 10594948.0 |
| 2007-08-24 11:55:00 | AAPL | Stock | 4.7889 | 4.7979 | 4.7874 | 4.7932 | 6051752.0 |
| 2007-08-24 12:00:00 | AAPL | Stock | 4.7936 | 4.7939 | 4.7811 | 4.7839 | 6261752.0 |
| 2007-08-24 12:05:00 | AAPL | Stock | 4.7843 | 4.79 | 4.7818 | 4.7825 | 6048252.0 |
| 2007-08-24 12:10:00 | AAPL | Stock | 4.7829 | 4.7829 | 4.7732 | 4.7818 | 6655824.0 |
| 2007-08-24 12:15:00 | AAPL | Stock | 4.7814 | 4.7952 | 4.7786 | 4.7907 | 9944844.0 |
| 2007-08-24 12:20:00 | AAPL | Stock | 4.7907 | 4.8054 | 4.7907 | 4.8029 | 15446088.0 |
| 2007-08-24 12:25:00 | AAPL | Stock | 4.8029 | 4.8143 | 4.8014 | 4.8032 | 14599928.0 |
| 2007-08-24 12:30:00 | AAPL | Stock | 4.8032 | 4.8086 | 4.7989 | 4.8057 | 11746672.0 |
| 2007-08-24 12:35:00 | AAPL | Stock | 4.8057 | 4.8107 | 4.7875 | 4.8054 | 7014196.0 |
| 2007-08-24 12:40:00 | AAPL | Stock | 4.8064 | 4.8071 | 4.7993 | 4.8011 | 5913572.0 |
| 2007-08-24 12:45:00 | AAPL | Stock | 4.8002 | 4.8029 | 4.7932 | 4.8004 | 5724208.0 |
| 2007-08-24 12:50:00 | AAPL | Stock | 4.8004 | 4.8093 | 4.7996 | 4.8086 | 7615020.0 |
| 2007-08-24 12:55:00 | AAPL | Stock | 4.8086 | 4.8089 | 4.8025 | 4.8071 | 6793612.0 |
| 2007-08-24 13:00:00 | AAPL | Stock | 4.8071 | 4.8107 | 4.8054 | 4.81 | 4179448.0 |
| 2007-08-24 13:05:00 | AAPL | Stock | 4.8096 | 4.8104 | 4.8011 | 4.8036 | 7193452.0 |
| 2007-08-24 13:10:00 | AAPL | Stock | 4.8036 | 4.8125 | 4.8034 | 4.8082 | 7340004.0 |
| 2007-08-24 13:15:00 | AAPL | Stock | 4.8086 | 4.8121 | 4.8064 | 4.8064 | 4235280.0 |
| 2007-08-24 13:20:00 | AAPL | Stock | 4.8061 | 4.8064 | 4.7985 | 4.8018 | 7873544.0 |
| 2007-08-24 13:25:00 | AAPL | Stock | 4.8029 | 4.8086 | 4.8011 | 4.8046 | 5779536.0 |
| 2007-08-24 13:30:00 | AAPL | Stock | 4.804 | 4.8054 | 4.7979 | 4.7993 | 5080096.0 |
| 2007-08-24 13:35:00 | AAPL | Stock | 4.7993 | 4.8 | 4.7946 | 4.7989 | 6257552.0 |
> showing 50 of 292,150 rows — these rows as CSV