PREVIEW / stock_5min / 2013-10-30
file: by_date/stock_5min/2013/2013-10-30.parquet size: 5.2 MB rows: 345,040 symbols: 3,535
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-30 04:35:00 | AAPL | Stock | 18.5679 | 18.5679 | 18.5679 | 18.5679 | 6440.0 |
| 2013-10-30 05:00:00 | AAPL | Stock | 18.5625 | 18.5625 | 18.5625 | 18.5625 | 5600.0 |
| 2013-10-30 05:10:00 | AAPL | Stock | 18.5321 | 18.5589 | 18.5321 | 18.5589 | 5600.0 |
| 2013-10-30 05:15:00 | AAPL | Stock | 18.5321 | 18.5321 | 18.5321 | 18.5321 | 2800.0 |
| 2013-10-30 05:30:00 | AAPL | Stock | 18.5321 | 18.5321 | 18.5321 | 18.5321 | 8372.0 |
| 2013-10-30 05:35:00 | AAPL | Stock | 18.5321 | 18.5321 | 18.5321 | 18.5321 | 5600.0 |
| 2013-10-30 05:45:00 | AAPL | Stock | 18.5464 | 18.5464 | 18.5464 | 18.5464 | 5600.0 |
| 2013-10-30 05:55:00 | AAPL | Stock | 18.5625 | 18.5625 | 18.5625 | 18.5625 | 16800.0 |
| 2013-10-30 06:00:00 | AAPL | Stock | 18.5761 | 18.5761 | 18.5607 | 18.5607 | 16800.0 |
| 2013-10-30 06:05:00 | AAPL | Stock | 18.5714 | 18.5779 | 18.5714 | 18.5714 | 34300.0 |
| 2013-10-30 06:10:00 | AAPL | Stock | 18.5411 | 18.5696 | 18.5411 | 18.5696 | 5600.0 |
| 2013-10-30 06:30:00 | AAPL | Stock | 18.5679 | 18.5786 | 18.5679 | 18.5714 | 53088.0 |
| 2013-10-30 06:35:00 | AAPL | Stock | 18.5707 | 18.5707 | 18.5536 | 18.5536 | 5600.0 |
| 2013-10-30 06:40:00 | AAPL | Stock | 18.5421 | 18.5661 | 18.5421 | 18.5661 | 5600.0 |
| 2013-10-30 06:45:00 | AAPL | Stock | 18.5618 | 18.5618 | 18.5618 | 18.5618 | 5600.0 |
| 2013-10-30 06:50:00 | AAPL | Stock | 18.5696 | 18.5696 | 18.5643 | 18.5643 | 8400.0 |
| 2013-10-30 06:55:00 | AAPL | Stock | 18.5711 | 18.575 | 18.5711 | 18.575 | 21084.0 |
| 2013-10-30 07:00:00 | AAPL | Stock | 18.5714 | 18.5789 | 18.5714 | 18.5714 | 42560.0 |
| 2013-10-30 07:05:00 | AAPL | Stock | 18.5643 | 18.5643 | 18.5643 | 18.5643 | 4200.0 |
| 2013-10-30 07:10:00 | AAPL | Stock | 18.5643 | 18.5714 | 18.5643 | 18.5714 | 23632.0 |
| 2013-10-30 07:15:00 | AAPL | Stock | 18.5696 | 18.5711 | 18.5486 | 18.5711 | 108248.0 |
| 2013-10-30 07:20:00 | AAPL | Stock | 18.5707 | 18.5707 | 18.5464 | 18.5704 | 64428.0 |
| 2013-10-30 07:25:00 | AAPL | Stock | 18.5468 | 18.5954 | 18.5468 | 18.5821 | 172872.0 |
| 2013-10-30 07:30:00 | AAPL | Stock | 18.5893 | 18.6 | 18.5464 | 18.5464 | 119868.0 |
| 2013-10-30 07:35:00 | AAPL | Stock | 18.5536 | 18.5539 | 18.5536 | 18.5536 | 29400.0 |
| 2013-10-30 07:40:00 | AAPL | Stock | 18.5621 | 18.5714 | 18.5621 | 18.5696 | 39620.0 |
| 2013-10-30 07:45:00 | AAPL | Stock | 18.5625 | 18.5625 | 18.5179 | 18.5357 | 107520.0 |
| 2013-10-30 07:50:00 | AAPL | Stock | 18.5357 | 18.5429 | 18.5357 | 18.5429 | 31920.0 |
| 2013-10-30 07:55:00 | AAPL | Stock | 18.5396 | 18.5396 | 18.5396 | 18.5396 | 2800.0 |
| 2013-10-30 08:00:00 | AAPL | Stock | 18.5429 | 18.5893 | 18.5271 | 18.5446 | 363552.0 |
| 2013-10-30 08:05:00 | AAPL | Stock | 18.5425 | 18.5539 | 18.5357 | 18.5493 | 159852.0 |
| 2013-10-30 08:10:00 | AAPL | Stock | 18.5518 | 18.5714 | 18.5504 | 18.5654 | 257880.0 |
| 2013-10-30 08:15:00 | AAPL | Stock | 18.5511 | 18.5643 | 18.5507 | 18.5636 | 102480.0 |
| 2013-10-30 08:20:00 | AAPL | Stock | 18.5643 | 18.5714 | 18.5589 | 18.5714 | 197540.0 |
| 2013-10-30 08:25:00 | AAPL | Stock | 18.5696 | 18.5714 | 18.5618 | 18.5668 | 221536.0 |
| 2013-10-30 08:30:00 | AAPL | Stock | 18.5664 | 18.5675 | 18.5357 | 18.5525 | 413336.0 |
| 2013-10-30 08:35:00 | AAPL | Stock | 18.5536 | 18.5714 | 18.5364 | 18.5568 | 488040.0 |
| 2013-10-30 08:40:00 | AAPL | Stock | 18.5561 | 18.5714 | 18.5561 | 18.5693 | 74760.0 |
| 2013-10-30 08:45:00 | AAPL | Stock | 18.5704 | 18.5789 | 18.5686 | 18.5686 | 239624.0 |
| 2013-10-30 08:50:00 | AAPL | Stock | 18.5675 | 18.575 | 18.5643 | 18.575 | 163492.0 |
| 2013-10-30 08:55:00 | AAPL | Stock | 18.5718 | 18.5718 | 18.5643 | 18.5707 | 126560.0 |
| 2013-10-30 09:00:00 | AAPL | Stock | 18.5679 | 18.5679 | 18.545 | 18.545 | 403872.0 |
| 2013-10-30 09:05:00 | AAPL | Stock | 18.5443 | 18.5714 | 18.5396 | 18.5714 | 350560.0 |
| 2013-10-30 09:10:00 | AAPL | Stock | 18.5714 | 18.5782 | 18.5661 | 18.5764 | 132412.0 |
| 2013-10-30 09:15:00 | AAPL | Stock | 18.5721 | 18.5739 | 18.5654 | 18.5654 | 73332.0 |
| 2013-10-30 09:20:00 | AAPL | Stock | 18.5696 | 18.5729 | 18.5593 | 18.5729 | 274260.0 |
| 2013-10-30 09:25:00 | AAPL | Stock | 18.5714 | 18.575 | 18.5464 | 18.5464 | 149156.0 |
| 2013-10-30 09:30:00 | AAPL | Stock | 18.5575 | 18.5829 | 18.465 | 18.4907 | 18427976.0 |
| 2013-10-30 09:35:00 | AAPL | Stock | 18.4961 | 18.5893 | 18.4714 | 18.5425 | 12713232.0 |
| 2013-10-30 09:40:00 | AAPL | Stock | 18.5314 | 18.6221 | 18.5314 | 18.5846 | 8755404.0 |
> showing 50 of 345,040 rows — these rows as CSV