PREVIEW / stock_5min / 2014-08-13
file: by_date/stock_5min/2014/2014-08-13.parquet size: 5.2 MB rows: 350,774 symbols: 3,571
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-13 04:00:00 | AAPL | Stock | 24.0725 | 24.0725 | 24.0725 | 24.0725 | 1000.0 |
| 2014-08-13 04:15:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.0625 | 24.0625 | 3200.0 |
| 2014-08-13 04:25:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.055 | 24.055 | 1600.0 |
| 2014-08-13 04:30:00 | AAPL | Stock | 24.055 | 24.055 | 24.05 | 24.055 | 10000.0 |
| 2014-08-13 04:35:00 | AAPL | Stock | 24.04 | 24.04 | 24.0325 | 24.0325 | 9600.0 |
| 2014-08-13 04:40:00 | AAPL | Stock | 24.03 | 24.04 | 24.0225 | 24.0225 | 8692.0 |
| 2014-08-13 04:45:00 | AAPL | Stock | 24.0025 | 24.005 | 24.0025 | 24.005 | 4000.0 |
| 2014-08-13 04:50:00 | AAPL | Stock | 24.005 | 24.025 | 24.005 | 24.025 | 6800.0 |
| 2014-08-13 04:55:00 | AAPL | Stock | 24.0125 | 24.0225 | 24.0125 | 24.0225 | 12084.0 |
| 2014-08-13 05:10:00 | AAPL | Stock | 24.0275 | 24.0275 | 24.0275 | 24.0275 | 9208.0 |
| 2014-08-13 05:15:00 | AAPL | Stock | 24.0275 | 24.0275 | 24.0175 | 24.0175 | 8716.0 |
| 2014-08-13 05:20:00 | AAPL | Stock | 24.0125 | 24.0125 | 24.0 | 24.0 | 9200.0 |
| 2014-08-13 05:25:00 | AAPL | Stock | 23.9975 | 23.9975 | 23.9975 | 23.9975 | 7260.0 |
| 2014-08-13 05:55:00 | AAPL | Stock | 24.025 | 24.0275 | 24.025 | 24.0275 | 3120.0 |
| 2014-08-13 06:00:00 | AAPL | Stock | 24.0275 | 24.035 | 24.0275 | 24.035 | 3200.0 |
| 2014-08-13 06:15:00 | AAPL | Stock | 24.0475 | 24.0475 | 24.0475 | 24.0475 | 2404.0 |
| 2014-08-13 06:25:00 | AAPL | Stock | 24.045 | 24.045 | 24.045 | 24.045 | 400.0 |
| 2014-08-13 06:30:00 | AAPL | Stock | 24.0525 | 24.055 | 24.05 | 24.055 | 10492.0 |
| 2014-08-13 06:35:00 | AAPL | Stock | 24.05 | 24.055 | 24.05 | 24.055 | 5200.0 |
| 2014-08-13 06:40:00 | AAPL | Stock | 24.0575 | 24.0625 | 24.0575 | 24.0625 | 5548.0 |
| 2014-08-13 06:50:00 | AAPL | Stock | 24.07 | 24.07 | 24.065 | 24.065 | 3200.0 |
| 2014-08-13 06:55:00 | AAPL | Stock | 24.0625 | 24.065 | 24.0625 | 24.065 | 2400.0 |
| 2014-08-13 07:00:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.0625 | 24.0625 | 4084.0 |
| 2014-08-13 07:05:00 | AAPL | Stock | 24.055 | 24.0625 | 24.0525 | 24.0625 | 1600.0 |
| 2014-08-13 07:10:00 | AAPL | Stock | 24.0625 | 24.075 | 24.0625 | 24.075 | 7748.0 |
| 2014-08-13 07:15:00 | AAPL | Stock | 24.075 | 24.0875 | 24.075 | 24.0875 | 11212.0 |
| 2014-08-13 07:20:00 | AAPL | Stock | 24.085 | 24.0875 | 24.085 | 24.0875 | 2000.0 |
| 2014-08-13 07:25:00 | AAPL | Stock | 24.0875 | 24.0975 | 24.0875 | 24.0975 | 9520.0 |
| 2014-08-13 07:30:00 | AAPL | Stock | 24.0925 | 24.095 | 24.0875 | 24.095 | 8240.0 |
| 2014-08-13 07:35:00 | AAPL | Stock | 24.0875 | 24.0925 | 24.0875 | 24.0925 | 3600.0 |
| 2014-08-13 07:45:00 | AAPL | Stock | 24.0775 | 24.09 | 24.0775 | 24.09 | 5220.0 |
| 2014-08-13 07:50:00 | AAPL | Stock | 24.0875 | 24.0875 | 24.0775 | 24.0775 | 4800.0 |
| 2014-08-13 07:55:00 | AAPL | Stock | 24.08 | 24.0875 | 24.08 | 24.0875 | 31600.0 |
| 2014-08-13 08:00:00 | AAPL | Stock | 24.0875 | 24.0975 | 24.0625 | 24.08 | 112236.0 |
| 2014-08-13 08:05:00 | AAPL | Stock | 24.075 | 24.0825 | 24.075 | 24.08 | 30844.0 |
| 2014-08-13 08:10:00 | AAPL | Stock | 24.075 | 24.0775 | 24.0375 | 24.0625 | 46536.0 |
| 2014-08-13 08:15:00 | AAPL | Stock | 24.0625 | 24.07 | 24.0525 | 24.0625 | 50644.0 |
| 2014-08-13 08:20:00 | AAPL | Stock | 24.0575 | 24.0575 | 24.045 | 24.05 | 25804.0 |
| 2014-08-13 08:25:00 | AAPL | Stock | 24.05 | 24.05 | 24.045 | 24.05 | 22884.0 |
| 2014-08-13 08:30:00 | AAPL | Stock | 24.055 | 24.0625 | 24.0425 | 24.0625 | 31116.0 |
| 2014-08-13 08:35:00 | AAPL | Stock | 24.0525 | 24.0525 | 24.045 | 24.05 | 27376.0 |
| 2014-08-13 08:40:00 | AAPL | Stock | 24.05 | 24.05 | 24.05 | 24.05 | 16400.0 |
| 2014-08-13 08:45:00 | AAPL | Stock | 24.055 | 24.055 | 24.045 | 24.0475 | 53248.0 |
| 2014-08-13 08:50:00 | AAPL | Stock | 24.0525 | 24.0525 | 24.045 | 24.05 | 6600.0 |
| 2014-08-13 08:55:00 | AAPL | Stock | 24.05 | 24.0575 | 24.04 | 24.05 | 16784.0 |
| 2014-08-13 09:00:00 | AAPL | Stock | 24.0575 | 24.0575 | 24.0475 | 24.0475 | 17888.0 |
| 2014-08-13 09:05:00 | AAPL | Stock | 24.05 | 24.05 | 24.0375 | 24.045 | 53496.0 |
| 2014-08-13 09:10:00 | AAPL | Stock | 24.045 | 24.0475 | 24.0425 | 24.0475 | 15936.0 |
| 2014-08-13 09:15:00 | AAPL | Stock | 24.045 | 24.045 | 24.035 | 24.035 | 16400.0 |
| 2014-08-13 09:20:00 | AAPL | Stock | 24.035 | 24.0375 | 24.025 | 24.03 | 52400.0 |
> showing 50 of 350,774 rows — these rows as CSV