PREVIEW / stock_5min / 2011-08-29
file: by_date/stock_5min/2011/2011-08-29.parquet size: 4.8 MB rows: 326,567 symbols: 3,537
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-29 04:00:00 | AAPL | Stock | 13.8086 | 13.8214 | 13.8086 | 13.81 | 16240.0 |
| 2011-08-29 04:05:00 | AAPL | Stock | 13.8546 | 13.8546 | 13.81 | 13.81 | 5600.0 |
| 2011-08-29 04:25:00 | AAPL | Stock | 13.825 | 13.825 | 13.825 | 13.825 | 5600.0 |
| 2011-08-29 04:55:00 | AAPL | Stock | 13.8136 | 13.8136 | 13.8136 | 13.8136 | 2800.0 |
| 2011-08-29 05:05:00 | AAPL | Stock | 13.8571 | 13.8571 | 13.8571 | 13.8571 | 5600.0 |
| 2011-08-29 05:10:00 | AAPL | Stock | 13.8493 | 13.8493 | 13.8493 | 13.8493 | 2800.0 |
| 2011-08-29 05:20:00 | AAPL | Stock | 13.8493 | 13.8493 | 13.8493 | 13.8493 | 2800.0 |
| 2011-08-29 06:05:00 | AAPL | Stock | 13.8393 | 13.8393 | 13.8393 | 13.8393 | 2800.0 |
| 2011-08-29 06:10:00 | AAPL | Stock | 13.8386 | 13.8386 | 13.8386 | 13.8386 | 2800.0 |
| 2011-08-29 06:25:00 | AAPL | Stock | 13.8204 | 13.8204 | 13.8204 | 13.8204 | 2800.0 |
| 2011-08-29 06:30:00 | AAPL | Stock | 13.8204 | 13.8204 | 13.8204 | 13.8204 | 5600.0 |
| 2011-08-29 06:40:00 | AAPL | Stock | 13.8204 | 13.8204 | 13.8204 | 13.8204 | 2800.0 |
| 2011-08-29 06:50:00 | AAPL | Stock | 13.8204 | 13.8204 | 13.8204 | 13.8204 | 14000.0 |
| 2011-08-29 06:55:00 | AAPL | Stock | 13.8204 | 13.8204 | 13.8204 | 13.8204 | 5600.0 |
| 2011-08-29 07:00:00 | AAPL | Stock | 13.8079 | 13.82 | 13.8079 | 13.82 | 33600.0 |
| 2011-08-29 07:05:00 | AAPL | Stock | 13.8211 | 13.8332 | 13.8211 | 13.8218 | 68908.0 |
| 2011-08-29 07:10:00 | AAPL | Stock | 13.8218 | 13.8421 | 13.8175 | 13.8354 | 92624.0 |
| 2011-08-29 07:15:00 | AAPL | Stock | 13.8343 | 13.8482 | 13.8343 | 13.8404 | 99708.0 |
| 2011-08-29 07:20:00 | AAPL | Stock | 13.8464 | 13.8464 | 13.8357 | 13.8393 | 230860.0 |
| 2011-08-29 07:25:00 | AAPL | Stock | 13.8429 | 13.8471 | 13.8396 | 13.8432 | 44044.0 |
| 2011-08-29 07:30:00 | AAPL | Stock | 13.8429 | 13.8482 | 13.8343 | 13.8468 | 201600.0 |
| 2011-08-29 07:35:00 | AAPL | Stock | 13.84 | 13.8536 | 13.84 | 13.8536 | 24920.0 |
| 2011-08-29 07:40:00 | AAPL | Stock | 13.8571 | 13.8625 | 13.8479 | 13.8625 | 112784.0 |
| 2011-08-29 07:45:00 | AAPL | Stock | 13.8679 | 13.8679 | 13.8539 | 13.8539 | 50400.0 |
| 2011-08-29 07:50:00 | AAPL | Stock | 13.8439 | 13.8482 | 13.8439 | 13.8482 | 8400.0 |
| 2011-08-29 07:55:00 | AAPL | Stock | 13.85 | 13.85 | 13.8286 | 13.8286 | 86744.0 |
| 2011-08-29 08:00:00 | AAPL | Stock | 13.8461 | 13.8539 | 13.8171 | 13.8393 | 513800.0 |
| 2011-08-29 08:05:00 | AAPL | Stock | 13.84 | 13.8714 | 13.8393 | 13.8664 | 314216.0 |
| 2011-08-29 08:10:00 | AAPL | Stock | 13.8664 | 13.8714 | 13.8607 | 13.8714 | 235704.0 |
| 2011-08-29 08:15:00 | AAPL | Stock | 13.8714 | 13.8793 | 13.8696 | 13.8736 | 333144.0 |
| 2011-08-29 08:20:00 | AAPL | Stock | 13.8746 | 13.8786 | 13.8714 | 13.8729 | 163492.0 |
| 2011-08-29 08:25:00 | AAPL | Stock | 13.8725 | 13.8839 | 13.8661 | 13.8804 | 568540.0 |
| 2011-08-29 08:30:00 | AAPL | Stock | 13.8804 | 13.8832 | 13.875 | 13.8832 | 140700.0 |
| 2011-08-29 08:35:00 | AAPL | Stock | 13.8836 | 13.8864 | 13.8804 | 13.8864 | 147924.0 |
| 2011-08-29 08:40:00 | AAPL | Stock | 13.8864 | 13.8864 | 13.8768 | 13.8771 | 142800.0 |
| 2011-08-29 08:45:00 | AAPL | Stock | 13.8768 | 13.8796 | 13.8661 | 13.875 | 212436.0 |
| 2011-08-29 08:50:00 | AAPL | Stock | 13.8743 | 13.8864 | 13.8693 | 13.8814 | 182784.0 |
| 2011-08-29 08:55:00 | AAPL | Stock | 13.8821 | 13.8875 | 13.8711 | 13.8757 | 202020.0 |
| 2011-08-29 09:00:00 | AAPL | Stock | 13.875 | 13.8864 | 13.8718 | 13.8846 | 137200.0 |
| 2011-08-29 09:05:00 | AAPL | Stock | 13.8846 | 13.8929 | 13.8846 | 13.8893 | 538580.0 |
| 2011-08-29 09:10:00 | AAPL | Stock | 13.8871 | 13.8893 | 13.8825 | 13.8843 | 171220.0 |
| 2011-08-29 09:15:00 | AAPL | Stock | 13.8857 | 13.8896 | 13.8786 | 13.8786 | 237860.0 |
| 2011-08-29 09:20:00 | AAPL | Stock | 13.8804 | 13.8839 | 13.875 | 13.8768 | 143752.0 |
| 2011-08-29 09:25:00 | AAPL | Stock | 13.8768 | 13.8771 | 13.8482 | 13.8596 | 337176.0 |
| 2011-08-29 09:30:00 | AAPL | Stock | 13.8636 | 13.9107 | 13.8571 | 13.8796 | 18049668.0 |
| 2011-08-29 09:35:00 | AAPL | Stock | 13.8796 | 13.9179 | 13.8693 | 13.9007 | 15861440.0 |
| 2011-08-29 09:40:00 | AAPL | Stock | 13.9018 | 13.9275 | 13.8893 | 13.9275 | 14751184.0 |
| 2011-08-29 09:45:00 | AAPL | Stock | 13.9264 | 13.9786 | 13.9254 | 13.9781 | 18629128.0 |
| 2011-08-29 09:50:00 | AAPL | Stock | 13.9762 | 13.9821 | 13.9539 | 13.9657 | 13833708.0 |
| 2011-08-29 09:55:00 | AAPL | Stock | 13.965 | 13.9714 | 13.9411 | 13.9511 | 8365672.0 |
> showing 50 of 326,567 rows — these rows as CSV