PREVIEW / stock_5min / 2017-01-25
file: by_date/stock_5min/2017/2017-01-25.parquet size: 5.5 MB rows: 357,820 symbols: 3,128
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 |
|---|---|---|---|---|---|---|---|
| 2017-01-25 04:00:00 | AAPL | Stock | 30.025 | 30.065 | 30.025 | 30.065 | 1488.0 |
| 2017-01-25 05:00:00 | AAPL | Stock | 30.1 | 30.1 | 30.1 | 30.1 | 400.0 |
| 2017-01-25 05:10:00 | AAPL | Stock | 30.1 | 30.1 | 30.1 | 30.1 | 4656.0 |
| 2017-01-25 05:15:00 | AAPL | Stock | 30.1 | 30.1 | 30.1 | 30.1 | 524.0 |
| 2017-01-25 05:25:00 | AAPL | Stock | 30.11 | 30.11 | 30.11 | 30.11 | 400.0 |
| 2017-01-25 05:35:00 | AAPL | Stock | 30.065 | 30.0925 | 30.0625 | 30.0925 | 7440.0 |
| 2017-01-25 06:00:00 | AAPL | Stock | 30.0875 | 30.0875 | 30.0875 | 30.0875 | 400.0 |
| 2017-01-25 06:15:00 | AAPL | Stock | 30.0925 | 30.0925 | 30.0925 | 30.0925 | 1600.0 |
| 2017-01-25 06:25:00 | AAPL | Stock | 30.095 | 30.095 | 30.095 | 30.095 | 4000.0 |
| 2017-01-25 06:35:00 | AAPL | Stock | 30.09 | 30.09 | 30.09 | 30.09 | 400.0 |
| 2017-01-25 07:00:00 | AAPL | Stock | 30.09 | 30.1 | 30.09 | 30.1 | 3064.0 |
| 2017-01-25 07:05:00 | AAPL | Stock | 30.1 | 30.1 | 30.09 | 30.09 | 16936.0 |
| 2017-01-25 07:20:00 | AAPL | Stock | 30.09 | 30.09 | 30.09 | 30.09 | 1124.0 |
| 2017-01-25 07:30:00 | AAPL | Stock | 30.0875 | 30.0875 | 30.0875 | 30.0875 | 724.0 |
| 2017-01-25 07:40:00 | AAPL | Stock | 30.0875 | 30.0875 | 30.08 | 30.08 | 12816.0 |
| 2017-01-25 07:45:00 | AAPL | Stock | 30.0775 | 30.095 | 30.0775 | 30.095 | 1372.0 |
| 2017-01-25 07:50:00 | AAPL | Stock | 30.09 | 30.09 | 30.0875 | 30.09 | 7236.0 |
| 2017-01-25 07:55:00 | AAPL | Stock | 30.09 | 30.09 | 30.09 | 30.09 | 400.0 |
| 2017-01-25 08:00:00 | AAPL | Stock | 30.095 | 30.095 | 30.065 | 30.065 | 23912.0 |
| 2017-01-25 08:05:00 | AAPL | Stock | 30.0625 | 30.0725 | 30.0575 | 30.0725 | 10012.0 |
| 2017-01-25 08:10:00 | AAPL | Stock | 30.0725 | 30.075 | 30.0725 | 30.0725 | 14500.0 |
| 2017-01-25 08:15:00 | AAPL | Stock | 30.0625 | 30.07 | 30.0575 | 30.0625 | 21456.0 |
| 2017-01-25 08:20:00 | AAPL | Stock | 30.0625 | 30.0625 | 30.0575 | 30.0575 | 9116.0 |
| 2017-01-25 08:25:00 | AAPL | Stock | 30.0575 | 30.065 | 30.0575 | 30.065 | 10704.0 |
| 2017-01-25 08:30:00 | AAPL | Stock | 30.0625 | 30.075 | 30.0425 | 30.075 | 25120.0 |
| 2017-01-25 08:35:00 | AAPL | Stock | 30.07 | 30.0725 | 30.0675 | 30.07 | 14572.0 |
| 2017-01-25 08:40:00 | AAPL | Stock | 30.075 | 30.075 | 30.0675 | 30.075 | 40708.0 |
| 2017-01-25 08:45:00 | AAPL | Stock | 30.08 | 30.0875 | 30.08 | 30.0875 | 10248.0 |
| 2017-01-25 08:50:00 | AAPL | Stock | 30.0875 | 30.095 | 30.0875 | 30.095 | 13400.0 |
| 2017-01-25 08:55:00 | AAPL | Stock | 30.0875 | 30.095 | 30.0875 | 30.095 | 9300.0 |
| 2017-01-25 09:00:00 | AAPL | Stock | 30.0875 | 30.09 | 30.0875 | 30.09 | 11000.0 |
| 2017-01-25 09:05:00 | AAPL | Stock | 30.09 | 30.095 | 30.08 | 30.095 | 10764.0 |
| 2017-01-25 09:10:00 | AAPL | Stock | 30.0925 | 30.1 | 30.0925 | 30.1 | 41824.0 |
| 2017-01-25 09:15:00 | AAPL | Stock | 30.1 | 30.11 | 30.1 | 30.1 | 85676.0 |
| 2017-01-25 09:20:00 | AAPL | Stock | 30.1 | 30.105 | 30.1 | 30.105 | 5600.0 |
| 2017-01-25 09:25:00 | AAPL | Stock | 30.105 | 30.11 | 30.0625 | 30.11 | 189576.0 |
| 2017-01-25 09:30:00 | AAPL | Stock | 30.105 | 30.23 | 30.07 | 30.22 | 7639916.0 |
| 2017-01-25 09:35:00 | AAPL | Stock | 30.22 | 30.25 | 30.2125 | 30.24 | 3922748.0 |
| 2017-01-25 09:40:00 | AAPL | Stock | 30.2375 | 30.2975 | 30.23 | 30.2825 | 5255008.0 |
| 2017-01-25 09:45:00 | AAPL | Stock | 30.2825 | 30.2875 | 30.25 | 30.275 | 2316088.0 |
| 2017-01-25 09:50:00 | AAPL | Stock | 30.2725 | 30.28 | 30.25 | 30.275 | 1914640.0 |
| 2017-01-25 09:55:00 | AAPL | Stock | 30.2775 | 30.31 | 30.26 | 30.282 | 3241924.0 |
| 2017-01-25 10:00:00 | AAPL | Stock | 30.2825 | 30.295 | 30.265 | 30.285 | 1357016.0 |
| 2017-01-25 10:05:00 | AAPL | Stock | 30.285 | 30.3225 | 30.255 | 30.3215 | 2061752.0 |
| 2017-01-25 10:10:00 | AAPL | Stock | 30.3212 | 30.3525 | 30.3175 | 30.3425 | 2083692.0 |
| 2017-01-25 10:15:00 | AAPL | Stock | 30.345 | 30.37 | 30.3275 | 30.3588 | 2431160.0 |
| 2017-01-25 10:20:00 | AAPL | Stock | 30.3575 | 30.39 | 30.3525 | 30.3775 | 2421656.0 |
| 2017-01-25 10:25:00 | AAPL | Stock | 30.3775 | 30.38 | 30.3425 | 30.3712 | 1486772.0 |
| 2017-01-25 10:30:00 | AAPL | Stock | 30.372 | 30.385 | 30.365 | 30.3725 | 1670752.0 |
| 2017-01-25 10:35:00 | AAPL | Stock | 30.37 | 30.3825 | 30.3688 | 30.38 | 1642872.0 |
> showing 50 of 357,820 rows — these rows as CSV