PREVIEW / stock_5min / 2012-04-25
file: by_date/stock_5min/2012/2012-04-25.parquet size: 4.9 MB rows: 334,260 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 |
|---|---|---|---|---|---|---|---|
| 2012-04-25 04:00:00 | AAPL | Stock | 21.5643 | 21.8214 | 21.5643 | 21.7857 | 132552.0 |
| 2012-04-25 04:05:00 | AAPL | Stock | 21.7857 | 21.8214 | 21.7857 | 21.8211 | 61600.0 |
| 2012-04-25 04:10:00 | AAPL | Stock | 21.8264 | 21.8393 | 21.8264 | 21.8393 | 14000.0 |
| 2012-04-25 04:15:00 | AAPL | Stock | 21.8407 | 21.8636 | 21.8407 | 21.8636 | 42000.0 |
| 2012-04-25 04:20:00 | AAPL | Stock | 21.8704 | 21.8782 | 21.8571 | 21.8571 | 17668.0 |
| 2012-04-25 04:25:00 | AAPL | Stock | 21.8786 | 21.8796 | 21.8725 | 21.8786 | 30240.0 |
| 2012-04-25 04:30:00 | AAPL | Stock | 21.8746 | 21.8782 | 21.8457 | 21.8532 | 107800.0 |
| 2012-04-25 04:35:00 | AAPL | Stock | 21.8429 | 21.8539 | 21.8393 | 21.8518 | 392980.0 |
| 2012-04-25 04:40:00 | AAPL | Stock | 21.8518 | 21.8686 | 21.8464 | 21.8571 | 544320.0 |
| 2012-04-25 04:45:00 | AAPL | Stock | 21.8575 | 21.8632 | 21.8539 | 21.8539 | 42980.0 |
| 2012-04-25 04:50:00 | AAPL | Stock | 21.8611 | 21.8636 | 21.8539 | 21.8539 | 42420.0 |
| 2012-04-25 04:55:00 | AAPL | Stock | 21.8539 | 21.8686 | 21.8539 | 21.8686 | 83356.0 |
| 2012-04-25 05:00:00 | AAPL | Stock | 21.8686 | 21.8743 | 21.8536 | 21.8571 | 63420.0 |
| 2012-04-25 05:05:00 | AAPL | Stock | 21.8732 | 21.8732 | 21.8482 | 21.8482 | 66024.0 |
| 2012-04-25 05:10:00 | AAPL | Stock | 21.8507 | 21.8507 | 21.8468 | 21.8468 | 15764.0 |
| 2012-04-25 05:15:00 | AAPL | Stock | 21.85 | 21.85 | 21.85 | 21.85 | 5040.0 |
| 2012-04-25 05:20:00 | AAPL | Stock | 21.8714 | 21.8746 | 21.8546 | 21.8546 | 52780.0 |
| 2012-04-25 05:25:00 | AAPL | Stock | 21.8532 | 21.8532 | 21.8532 | 21.8532 | 5600.0 |
| 2012-04-25 05:30:00 | AAPL | Stock | 21.8732 | 21.8746 | 21.8593 | 21.8593 | 34244.0 |
| 2012-04-25 05:35:00 | AAPL | Stock | 21.8661 | 21.8661 | 21.8661 | 21.8661 | 15568.0 |
| 2012-04-25 05:40:00 | AAPL | Stock | 21.8571 | 21.8571 | 21.8568 | 21.8568 | 19600.0 |
| 2012-04-25 05:45:00 | AAPL | Stock | 21.8571 | 21.8661 | 21.8571 | 21.8661 | 12544.0 |
| 2012-04-25 05:50:00 | AAPL | Stock | 21.8661 | 21.8661 | 21.8611 | 21.8661 | 42000.0 |
| 2012-04-25 05:55:00 | AAPL | Stock | 21.8743 | 21.8746 | 21.8743 | 21.8746 | 19600.0 |
| 2012-04-25 06:00:00 | AAPL | Stock | 21.8661 | 21.8886 | 21.86 | 21.8886 | 51520.0 |
| 2012-04-25 06:05:00 | AAPL | Stock | 21.9268 | 21.9286 | 21.915 | 21.9268 | 36960.0 |
| 2012-04-25 06:10:00 | AAPL | Stock | 21.9214 | 21.9214 | 21.9157 | 21.9157 | 22400.0 |
| 2012-04-25 06:15:00 | AAPL | Stock | 21.9214 | 21.9236 | 21.9129 | 21.9236 | 24752.0 |
| 2012-04-25 06:20:00 | AAPL | Stock | 21.9264 | 21.9429 | 21.9236 | 21.9429 | 70140.0 |
| 2012-04-25 06:25:00 | AAPL | Stock | 21.9586 | 22.0 | 21.9586 | 21.9946 | 147952.0 |
| 2012-04-25 06:30:00 | AAPL | Stock | 21.9821 | 21.9911 | 21.9571 | 21.9686 | 47712.0 |
| 2012-04-25 06:35:00 | AAPL | Stock | 21.9571 | 21.9571 | 21.875 | 21.8857 | 117180.0 |
| 2012-04-25 06:40:00 | AAPL | Stock | 21.8993 | 21.8993 | 21.8564 | 21.8571 | 174356.0 |
| 2012-04-25 06:45:00 | AAPL | Stock | 21.875 | 21.9107 | 21.8446 | 21.9107 | 426804.0 |
| 2012-04-25 06:50:00 | AAPL | Stock | 21.9068 | 21.9068 | 21.8818 | 21.8818 | 148064.0 |
| 2012-04-25 06:55:00 | AAPL | Stock | 21.8875 | 21.8929 | 21.8482 | 21.8571 | 573972.0 |
| 2012-04-25 07:00:00 | AAPL | Stock | 21.8486 | 21.8911 | 21.8071 | 21.845 | 846776.0 |
| 2012-04-25 07:05:00 | AAPL | Stock | 21.8382 | 21.8571 | 21.8214 | 21.8539 | 444472.0 |
| 2012-04-25 07:10:00 | AAPL | Stock | 21.8432 | 21.8532 | 21.8186 | 21.8218 | 273028.0 |
| 2012-04-25 07:15:00 | AAPL | Stock | 21.8218 | 21.8232 | 21.7771 | 21.7868 | 707392.0 |
| 2012-04-25 07:20:00 | AAPL | Stock | 21.7857 | 21.835 | 21.7857 | 21.8125 | 915012.0 |
| 2012-04-25 07:25:00 | AAPL | Stock | 21.8182 | 21.8182 | 21.7189 | 21.7629 | 654136.0 |
| 2012-04-25 07:30:00 | AAPL | Stock | 21.7407 | 21.7857 | 21.7321 | 21.7693 | 297164.0 |
| 2012-04-25 07:35:00 | AAPL | Stock | 21.7686 | 21.7896 | 21.7525 | 21.7611 | 197484.0 |
| 2012-04-25 07:40:00 | AAPL | Stock | 21.7714 | 21.7818 | 21.75 | 21.7793 | 592284.0 |
| 2012-04-25 07:45:00 | AAPL | Stock | 21.78 | 21.8536 | 21.78 | 21.8354 | 1391264.0 |
| 2012-04-25 07:50:00 | AAPL | Stock | 21.825 | 21.8393 | 21.7957 | 21.8075 | 303268.0 |
| 2012-04-25 07:55:00 | AAPL | Stock | 21.8054 | 21.8393 | 21.8054 | 21.8304 | 457016.0 |
| 2012-04-25 08:00:00 | AAPL | Stock | 21.8325 | 21.8929 | 21.7589 | 21.8214 | 3414824.0 |
| 2012-04-25 08:05:00 | AAPL | Stock | 21.8693 | 21.9321 | 21.8589 | 21.9254 | 2112964.0 |
> showing 50 of 334,260 rows — these rows as CSV