PREVIEW / stock_5min / 2008-08-06
file: by_date/stock_5min/2008/2008-08-06.parquet size: 4.5 MB rows: 321,962 symbols: 3,322
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-06 07:30:00 | AAPL | Stock | 5.7411 | 5.75 | 5.7411 | 5.75 | 15680.0 |
| 2008-08-06 07:35:00 | AAPL | Stock | 5.7518 | 5.7518 | 5.75 | 5.75 | 8400.0 |
| 2008-08-06 07:55:00 | AAPL | Stock | 5.75 | 5.75 | 5.75 | 5.75 | 16800.0 |
| 2008-08-06 08:00:00 | AAPL | Stock | 5.7171 | 5.7321 | 5.7171 | 5.7304 | 56000.0 |
| 2008-08-06 08:05:00 | AAPL | Stock | 5.7246 | 5.7282 | 5.7179 | 5.7268 | 263900.0 |
| 2008-08-06 08:10:00 | AAPL | Stock | 5.7264 | 5.7346 | 5.7232 | 5.7346 | 372400.0 |
| 2008-08-06 08:15:00 | AAPL | Stock | 5.7286 | 5.735 | 5.7229 | 5.7339 | 131012.0 |
| 2008-08-06 08:20:00 | AAPL | Stock | 5.7339 | 5.7339 | 5.7229 | 5.7236 | 212352.0 |
| 2008-08-06 08:25:00 | AAPL | Stock | 5.7264 | 5.7264 | 5.7221 | 5.7221 | 14000.0 |
| 2008-08-06 08:30:00 | AAPL | Stock | 5.7229 | 5.7229 | 5.7132 | 5.7143 | 216552.0 |
| 2008-08-06 08:35:00 | AAPL | Stock | 5.7107 | 5.7204 | 5.7107 | 5.7107 | 79688.0 |
| 2008-08-06 08:40:00 | AAPL | Stock | 5.7107 | 5.715 | 5.7107 | 5.7143 | 77644.0 |
| 2008-08-06 08:45:00 | AAPL | Stock | 5.7143 | 5.7175 | 5.7143 | 5.7175 | 61600.0 |
| 2008-08-06 08:50:00 | AAPL | Stock | 5.7171 | 5.7175 | 5.7125 | 5.7139 | 87920.0 |
| 2008-08-06 08:55:00 | AAPL | Stock | 5.7175 | 5.7175 | 5.7139 | 5.7143 | 103600.0 |
| 2008-08-06 09:00:00 | AAPL | Stock | 5.7164 | 5.7193 | 5.7107 | 5.7143 | 262192.0 |
| 2008-08-06 09:05:00 | AAPL | Stock | 5.7193 | 5.7193 | 5.71 | 5.7125 | 108864.0 |
| 2008-08-06 09:10:00 | AAPL | Stock | 5.7121 | 5.7121 | 5.7096 | 5.7114 | 98700.0 |
| 2008-08-06 09:15:00 | AAPL | Stock | 5.7107 | 5.7146 | 5.7107 | 5.7146 | 8400.0 |
| 2008-08-06 09:20:00 | AAPL | Stock | 5.7146 | 5.7257 | 5.7146 | 5.7257 | 67452.0 |
| 2008-08-06 09:25:00 | AAPL | Stock | 5.7257 | 5.7268 | 5.7118 | 5.7118 | 391832.0 |
| 2008-08-06 09:30:00 | AAPL | Stock | 5.7132 | 5.715 | 5.6789 | 5.7007 | 17429944.0 |
| 2008-08-06 09:35:00 | AAPL | Stock | 5.7007 | 5.7014 | 5.6696 | 5.68 | 12897220.0 |
| 2008-08-06 09:40:00 | AAPL | Stock | 5.6814 | 5.7054 | 5.6668 | 5.6839 | 16806356.0 |
| 2008-08-06 09:45:00 | AAPL | Stock | 5.6843 | 5.6964 | 5.67 | 5.6768 | 12115684.0 |
| 2008-08-06 09:50:00 | AAPL | Stock | 5.6764 | 5.6911 | 5.6718 | 5.6782 | 9430204.0 |
| 2008-08-06 09:55:00 | AAPL | Stock | 5.6786 | 5.7018 | 5.6786 | 5.6882 | 13739488.0 |
| 2008-08-06 10:00:00 | AAPL | Stock | 5.6882 | 5.6954 | 5.645 | 5.6475 | 13383888.0 |
| 2008-08-06 10:05:00 | AAPL | Stock | 5.6475 | 5.6571 | 5.6429 | 5.6496 | 11504864.0 |
| 2008-08-06 10:10:00 | AAPL | Stock | 5.6496 | 5.6564 | 5.6436 | 5.6521 | 6957888.0 |
| 2008-08-06 10:15:00 | AAPL | Stock | 5.6525 | 5.6811 | 5.6479 | 5.6783 | 10590888.0 |
| 2008-08-06 10:20:00 | AAPL | Stock | 5.6789 | 5.6961 | 5.6764 | 5.6957 | 12077856.0 |
| 2008-08-06 10:25:00 | AAPL | Stock | 5.6961 | 5.7089 | 5.6957 | 5.6975 | 16450672.0 |
| 2008-08-06 10:30:00 | AAPL | Stock | 5.6964 | 5.7043 | 5.6704 | 5.6804 | 13257636.0 |
| 2008-08-06 10:35:00 | AAPL | Stock | 5.68 | 5.7018 | 5.6682 | 5.6757 | 9483684.0 |
| 2008-08-06 10:40:00 | AAPL | Stock | 5.675 | 5.6814 | 5.6668 | 5.6732 | 5468064.0 |
| 2008-08-06 10:45:00 | AAPL | Stock | 5.6725 | 5.6893 | 5.6718 | 5.6825 | 5926620.0 |
| 2008-08-06 10:50:00 | AAPL | Stock | 5.6829 | 5.6914 | 5.6786 | 5.6797 | 6308036.0 |
| 2008-08-06 10:55:00 | AAPL | Stock | 5.6811 | 5.6911 | 5.6746 | 5.6821 | 5972288.0 |
| 2008-08-06 11:00:00 | AAPL | Stock | 5.6814 | 5.6849 | 5.6621 | 5.6732 | 6039348.0 |
| 2008-08-06 11:05:00 | AAPL | Stock | 5.6722 | 5.6907 | 5.6714 | 5.685 | 6091988.0 |
| 2008-08-06 11:10:00 | AAPL | Stock | 5.6855 | 5.7071 | 5.6825 | 5.6989 | 10401020.0 |
| 2008-08-06 11:15:00 | AAPL | Stock | 5.6996 | 5.7268 | 5.6961 | 5.7237 | 13576136.0 |
| 2008-08-06 11:20:00 | AAPL | Stock | 5.7236 | 5.7482 | 5.7214 | 5.7389 | 15697444.0 |
| 2008-08-06 11:25:00 | AAPL | Stock | 5.7396 | 5.7764 | 5.7391 | 5.7757 | 21127120.0 |
| 2008-08-06 11:30:00 | AAPL | Stock | 5.7761 | 5.7761 | 5.7589 | 5.7611 | 12438244.0 |
| 2008-08-06 11:35:00 | AAPL | Stock | 5.7621 | 5.7929 | 5.7546 | 5.7907 | 11823196.0 |
| 2008-08-06 11:40:00 | AAPL | Stock | 5.7907 | 5.7989 | 5.7811 | 5.7961 | 12704748.0 |
| 2008-08-06 11:45:00 | AAPL | Stock | 5.7964 | 5.7968 | 5.7804 | 5.7946 | 9612960.0 |
| 2008-08-06 11:50:00 | AAPL | Stock | 5.7946 | 5.8154 | 5.7836 | 5.8082 | 12129124.0 |
> showing 50 of 321,962 rows — these rows as CSV