PREVIEW / stock_5min / 2010-08-12
file: by_date/stock_5min/2010/2010-08-12.parquet size: 4.7 MB rows: 327,509 symbols: 3,466
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-08-12 05:15:00 | AAPL | Stock | 8.8161 | 8.8357 | 8.8161 | 8.8211 | 70000.0 |
| 2010-08-12 06:05:00 | AAPL | Stock | 8.8375 | 8.8375 | 8.8143 | 8.8143 | 5600.0 |
| 2010-08-12 06:10:00 | AAPL | Stock | 8.8393 | 8.8393 | 8.8393 | 8.8393 | 8400.0 |
| 2010-08-12 06:20:00 | AAPL | Stock | 8.8179 | 8.8179 | 8.8179 | 8.8179 | 3640.0 |
| 2010-08-12 06:30:00 | AAPL | Stock | 8.8411 | 8.8411 | 8.8411 | 8.8411 | 2884.0 |
| 2010-08-12 06:35:00 | AAPL | Stock | 8.8411 | 8.8411 | 8.8411 | 8.8411 | 3640.0 |
| 2010-08-12 06:40:00 | AAPL | Stock | 8.8411 | 8.8411 | 8.8411 | 8.8411 | 8344.0 |
| 2010-08-12 06:45:00 | AAPL | Stock | 8.8464 | 8.8464 | 8.8464 | 8.8464 | 3500.0 |
| 2010-08-12 06:50:00 | AAPL | Stock | 8.8571 | 8.8571 | 8.8521 | 8.8521 | 33712.0 |
| 2010-08-12 06:55:00 | AAPL | Stock | 8.8879 | 8.8879 | 8.8714 | 8.8732 | 14980.0 |
| 2010-08-12 07:00:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8714 | 8.8714 | 25032.0 |
| 2010-08-12 07:05:00 | AAPL | Stock | 8.8721 | 8.8768 | 8.8721 | 8.8768 | 27188.0 |
| 2010-08-12 07:10:00 | AAPL | Stock | 8.8843 | 8.8843 | 8.8843 | 8.8843 | 5600.0 |
| 2010-08-12 07:15:00 | AAPL | Stock | 8.8875 | 8.8929 | 8.8875 | 8.8929 | 35700.0 |
| 2010-08-12 07:20:00 | AAPL | Stock | 8.8929 | 8.8929 | 8.8929 | 8.8929 | 14000.0 |
| 2010-08-12 07:25:00 | AAPL | Stock | 8.8893 | 8.8893 | 8.8732 | 8.8732 | 22400.0 |
| 2010-08-12 07:30:00 | AAPL | Stock | 8.8732 | 8.8814 | 8.865 | 8.8814 | 20356.0 |
| 2010-08-12 07:40:00 | AAPL | Stock | 8.8679 | 8.8679 | 8.8679 | 8.8679 | 16800.0 |
| 2010-08-12 07:45:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 2800.0 |
| 2010-08-12 07:55:00 | AAPL | Stock | 8.8575 | 8.8643 | 8.8571 | 8.8643 | 12936.0 |
| 2010-08-12 08:00:00 | AAPL | Stock | 8.8661 | 8.875 | 8.8571 | 8.8696 | 203784.0 |
| 2010-08-12 08:05:00 | AAPL | Stock | 8.8714 | 8.8929 | 8.8693 | 8.8764 | 260344.0 |
| 2010-08-12 08:10:00 | AAPL | Stock | 8.8782 | 8.8871 | 8.875 | 8.88 | 333088.0 |
| 2010-08-12 08:15:00 | AAPL | Stock | 8.8821 | 8.8868 | 8.8743 | 8.8786 | 411824.0 |
| 2010-08-12 08:20:00 | AAPL | Stock | 8.8779 | 8.8857 | 8.8768 | 8.8857 | 63588.0 |
| 2010-08-12 08:25:00 | AAPL | Stock | 8.8861 | 8.9 | 8.8857 | 8.8921 | 303968.0 |
| 2010-08-12 08:30:00 | AAPL | Stock | 8.8918 | 8.8964 | 8.8761 | 8.8875 | 1411032.0 |
| 2010-08-12 08:35:00 | AAPL | Stock | 8.8825 | 8.8925 | 8.8811 | 8.8818 | 175700.0 |
| 2010-08-12 08:40:00 | AAPL | Stock | 8.8825 | 8.8836 | 8.8614 | 8.8661 | 912772.0 |
| 2010-08-12 08:45:00 | AAPL | Stock | 8.8625 | 8.8661 | 8.8507 | 8.8514 | 918652.0 |
| 2010-08-12 08:50:00 | AAPL | Stock | 8.8554 | 8.8571 | 8.845 | 8.845 | 303520.0 |
| 2010-08-12 08:55:00 | AAPL | Stock | 8.8421 | 8.8429 | 8.8164 | 8.8286 | 688072.0 |
| 2010-08-12 09:00:00 | AAPL | Stock | 8.8304 | 8.835 | 8.8196 | 8.8218 | 274232.0 |
| 2010-08-12 09:05:00 | AAPL | Stock | 8.8218 | 8.825 | 8.8143 | 8.825 | 462224.0 |
| 2010-08-12 09:10:00 | AAPL | Stock | 8.8221 | 8.8271 | 8.8061 | 8.8061 | 414904.0 |
| 2010-08-12 09:15:00 | AAPL | Stock | 8.8061 | 8.8125 | 8.8014 | 8.8061 | 349608.0 |
| 2010-08-12 09:20:00 | AAPL | Stock | 8.8071 | 8.8175 | 8.8068 | 8.8143 | 163800.0 |
| 2010-08-12 09:25:00 | AAPL | Stock | 8.8164 | 8.8343 | 8.8071 | 8.8104 | 524440.0 |
| 2010-08-12 09:30:00 | AAPL | Stock | 8.8089 | 8.8393 | 8.79 | 8.8364 | 28318108.0 |
| 2010-08-12 09:35:00 | AAPL | Stock | 8.8373 | 8.8893 | 8.8146 | 8.8839 | 23573900.0 |
| 2010-08-12 09:40:00 | AAPL | Stock | 8.8839 | 8.9057 | 8.8775 | 8.9007 | 17797136.0 |
| 2010-08-12 09:45:00 | AAPL | Stock | 8.9014 | 8.9025 | 8.8786 | 8.8907 | 14112756.0 |
| 2010-08-12 09:50:00 | AAPL | Stock | 8.8907 | 8.9207 | 8.8871 | 8.9121 | 13757296.0 |
| 2010-08-12 09:55:00 | AAPL | Stock | 8.9121 | 8.9278 | 8.8939 | 8.9125 | 12871208.0 |
| 2010-08-12 10:00:00 | AAPL | Stock | 8.9127 | 8.9539 | 8.9079 | 8.9532 | 16271808.0 |
| 2010-08-12 10:05:00 | AAPL | Stock | 8.9507 | 8.995 | 8.9482 | 8.9843 | 24036012.0 |
| 2010-08-12 10:10:00 | AAPL | Stock | 8.9832 | 8.9964 | 8.9571 | 8.9704 | 15501696.0 |
| 2010-08-12 10:15:00 | AAPL | Stock | 8.9704 | 8.9911 | 8.9664 | 8.9732 | 8631140.0 |
| 2010-08-12 10:20:00 | AAPL | Stock | 8.9732 | 8.9857 | 8.9686 | 8.9818 | 6229300.0 |
| 2010-08-12 10:25:00 | AAPL | Stock | 8.9807 | 8.985 | 8.9589 | 8.9671 | 9085104.0 |
> showing 50 of 327,509 rows — these rows as CSV