PREVIEW / stock_5min / 2013-05-15
file: by_date/stock_5min/2013/2013-05-15.parquet size: 5.2 MB rows: 341,253 symbols: 3,517
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-05-15 04:00:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 5600.0 |
| 2013-05-15 04:35:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7857 | 15.7857 | 2800.0 |
| 2013-05-15 05:35:00 | AAPL | Stock | 15.7879 | 15.7879 | 15.7857 | 15.7857 | 8400.0 |
| 2013-05-15 06:05:00 | AAPL | Stock | 15.7864 | 15.7864 | 15.7864 | 15.7864 | 5264.0 |
| 2013-05-15 06:10:00 | AAPL | Stock | 15.7968 | 15.7968 | 15.7968 | 15.7968 | 2800.0 |
| 2013-05-15 06:30:00 | AAPL | Stock | 15.8018 | 15.8018 | 15.8018 | 15.8018 | 3556.0 |
| 2013-05-15 06:40:00 | AAPL | Stock | 15.8161 | 15.8161 | 15.8161 | 15.8161 | 5600.0 |
| 2013-05-15 06:50:00 | AAPL | Stock | 15.7957 | 15.7957 | 15.7957 | 15.7957 | 2800.0 |
| 2013-05-15 07:00:00 | AAPL | Stock | 15.8129 | 15.8129 | 15.7857 | 15.7857 | 21364.0 |
| 2013-05-15 07:05:00 | AAPL | Stock | 15.7857 | 15.7857 | 15.7689 | 15.7689 | 11200.0 |
| 2013-05-15 07:10:00 | AAPL | Stock | 15.75 | 15.7679 | 15.75 | 15.7679 | 33964.0 |
| 2013-05-15 07:15:00 | AAPL | Stock | 15.7693 | 15.7732 | 15.7679 | 15.7679 | 28000.0 |
| 2013-05-15 07:20:00 | AAPL | Stock | 15.7714 | 15.7714 | 15.7679 | 15.7679 | 41636.0 |
| 2013-05-15 07:25:00 | AAPL | Stock | 15.7821 | 15.7857 | 15.7789 | 15.7857 | 19600.0 |
| 2013-05-15 07:40:00 | AAPL | Stock | 15.7964 | 15.8 | 15.7964 | 15.8 | 5600.0 |
| 2013-05-15 07:45:00 | AAPL | Stock | 15.8014 | 15.82 | 15.8014 | 15.82 | 33600.0 |
| 2013-05-15 07:50:00 | AAPL | Stock | 15.8218 | 15.8225 | 15.8036 | 15.8036 | 81200.0 |
| 2013-05-15 07:55:00 | AAPL | Stock | 15.8011 | 15.8071 | 15.8011 | 15.8071 | 11200.0 |
| 2013-05-15 08:00:00 | AAPL | Stock | 15.8036 | 15.8214 | 15.75 | 15.8168 | 197680.0 |
| 2013-05-15 08:05:00 | AAPL | Stock | 15.8179 | 15.8332 | 15.8179 | 15.8332 | 38640.0 |
| 2013-05-15 08:10:00 | AAPL | Stock | 15.8286 | 15.8286 | 15.825 | 15.8268 | 71288.0 |
| 2013-05-15 08:15:00 | AAPL | Stock | 15.8214 | 15.8225 | 15.815 | 15.8225 | 75712.0 |
| 2013-05-15 08:20:00 | AAPL | Stock | 15.8214 | 15.8357 | 15.8214 | 15.8214 | 146692.0 |
| 2013-05-15 08:25:00 | AAPL | Stock | 15.8214 | 15.8379 | 15.8214 | 15.8221 | 72968.0 |
| 2013-05-15 08:30:00 | AAPL | Stock | 15.8218 | 15.8225 | 15.8036 | 15.8071 | 154560.0 |
| 2013-05-15 08:35:00 | AAPL | Stock | 15.8104 | 15.8104 | 15.8064 | 15.8064 | 28000.0 |
| 2013-05-15 08:40:00 | AAPL | Stock | 15.8071 | 15.8071 | 15.7739 | 15.7739 | 177996.0 |
| 2013-05-15 08:45:00 | AAPL | Stock | 15.7818 | 15.7821 | 15.7589 | 15.7589 | 121212.0 |
| 2013-05-15 08:50:00 | AAPL | Stock | 15.7593 | 15.7779 | 15.7582 | 15.7721 | 156660.0 |
| 2013-05-15 08:55:00 | AAPL | Stock | 15.7679 | 15.7679 | 15.7411 | 15.7411 | 190260.0 |
| 2013-05-15 09:00:00 | AAPL | Stock | 15.7386 | 15.75 | 15.7268 | 15.7393 | 225904.0 |
| 2013-05-15 09:05:00 | AAPL | Stock | 15.74 | 15.7489 | 15.7257 | 15.7321 | 186284.0 |
| 2013-05-15 09:10:00 | AAPL | Stock | 15.7371 | 15.7371 | 15.7143 | 15.7321 | 566104.0 |
| 2013-05-15 09:15:00 | AAPL | Stock | 15.7246 | 15.7339 | 15.7179 | 15.7268 | 198184.0 |
| 2013-05-15 09:20:00 | AAPL | Stock | 15.7268 | 15.7268 | 15.7075 | 15.7075 | 276220.0 |
| 2013-05-15 09:25:00 | AAPL | Stock | 15.7111 | 15.7179 | 15.6764 | 15.6786 | 700924.0 |
| 2013-05-15 09:30:00 | AAPL | Stock | 15.6843 | 15.75 | 15.6386 | 15.7036 | 27861988.0 |
| 2013-05-15 09:35:00 | AAPL | Stock | 15.6993 | 15.7236 | 15.5893 | 15.6094 | 24220952.0 |
| 2013-05-15 09:40:00 | AAPL | Stock | 15.6113 | 15.6696 | 15.605 | 15.6354 | 13569724.0 |
| 2013-05-15 09:45:00 | AAPL | Stock | 15.6321 | 15.6511 | 15.6089 | 15.6214 | 9244116.0 |
| 2013-05-15 09:50:00 | AAPL | Stock | 15.6204 | 15.6346 | 15.5664 | 15.5679 | 14912576.0 |
| 2013-05-15 09:55:00 | AAPL | Stock | 15.5675 | 15.5893 | 15.5182 | 15.5307 | 16263296.0 |
| 2013-05-15 10:00:00 | AAPL | Stock | 15.5282 | 15.5357 | 15.4821 | 15.4872 | 17398948.0 |
| 2013-05-15 10:05:00 | AAPL | Stock | 15.4861 | 15.6054 | 15.4857 | 15.5671 | 16405340.0 |
| 2013-05-15 10:10:00 | AAPL | Stock | 15.5679 | 15.5704 | 15.4889 | 15.5168 | 9594816.0 |
| 2013-05-15 10:15:00 | AAPL | Stock | 15.5125 | 15.5589 | 15.5043 | 15.54 | 6868260.0 |
| 2013-05-15 10:20:00 | AAPL | Stock | 15.5375 | 15.5893 | 15.5296 | 15.5714 | 5973660.0 |
| 2013-05-15 10:25:00 | AAPL | Stock | 15.5699 | 15.5707 | 15.5246 | 15.5264 | 5115236.0 |
| 2013-05-15 10:30:00 | AAPL | Stock | 15.5261 | 15.5607 | 15.5261 | 15.5407 | 4169564.0 |
| 2013-05-15 10:35:00 | AAPL | Stock | 15.5439 | 15.5536 | 15.5207 | 15.5326 | 4982796.0 |
> showing 50 of 341,253 rows — these rows as CSV