PREVIEW / stock_5min / 2015-09-02
file: by_date/stock_5min/2015/2015-09-02.parquet size: 5.4 MB rows: 365,176 symbols: 3,479
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 |
|---|---|---|---|---|---|---|---|
| 2015-09-02 04:00:00 | AAPL | Stock | 27.0925 | 27.4975 | 27.0925 | 27.4725 | 12600.0 |
| 2015-09-02 04:05:00 | AAPL | Stock | 27.375 | 27.375 | 27.355 | 27.355 | 800.0 |
| 2015-09-02 04:10:00 | AAPL | Stock | 27.375 | 27.46 | 27.375 | 27.3875 | 13652.0 |
| 2015-09-02 04:20:00 | AAPL | Stock | 27.3025 | 27.3025 | 27.3 | 27.3 | 5000.0 |
| 2015-09-02 04:25:00 | AAPL | Stock | 27.2775 | 27.2775 | 27.2775 | 27.2775 | 400.0 |
| 2015-09-02 04:30:00 | AAPL | Stock | 27.305 | 27.3125 | 27.305 | 27.3125 | 1972.0 |
| 2015-09-02 04:40:00 | AAPL | Stock | 27.3125 | 27.3125 | 27.3125 | 27.3125 | 400.0 |
| 2015-09-02 04:55:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 800.0 |
| 2015-09-02 05:00:00 | AAPL | Stock | 27.325 | 27.325 | 27.2 | 27.2 | 16800.0 |
| 2015-09-02 05:05:00 | AAPL | Stock | 27.2025 | 27.29 | 27.2 | 27.29 | 4400.0 |
| 2015-09-02 05:15:00 | AAPL | Stock | 27.285 | 27.285 | 27.2525 | 27.2525 | 4000.0 |
| 2015-09-02 05:25:00 | AAPL | Stock | 27.3025 | 27.3025 | 27.3025 | 27.3025 | 2112.0 |
| 2015-09-02 05:30:00 | AAPL | Stock | 27.3025 | 27.3025 | 27.3 | 27.3 | 6000.0 |
| 2015-09-02 05:45:00 | AAPL | Stock | 27.275 | 27.3225 | 27.275 | 27.3225 | 1600.0 |
| 2015-09-02 05:50:00 | AAPL | Stock | 27.275 | 27.275 | 27.275 | 27.275 | 3200.0 |
| 2015-09-02 06:00:00 | AAPL | Stock | 27.3125 | 27.375 | 27.3125 | 27.3675 | 11200.0 |
| 2015-09-02 06:05:00 | AAPL | Stock | 27.375 | 27.4 | 27.375 | 27.385 | 10400.0 |
| 2015-09-02 06:10:00 | AAPL | Stock | 27.33 | 27.33 | 27.33 | 27.33 | 740.0 |
| 2015-09-02 06:15:00 | AAPL | Stock | 27.3925 | 27.3925 | 27.385 | 27.3925 | 9508.0 |
| 2015-09-02 06:20:00 | AAPL | Stock | 27.365 | 27.375 | 27.365 | 27.37 | 15132.0 |
| 2015-09-02 06:25:00 | AAPL | Stock | 27.37 | 27.37 | 27.365 | 27.365 | 20292.0 |
| 2015-09-02 06:30:00 | AAPL | Stock | 27.345 | 27.345 | 27.3125 | 27.3125 | 6800.0 |
| 2015-09-02 06:35:00 | AAPL | Stock | 27.315 | 27.315 | 27.285 | 27.285 | 4476.0 |
| 2015-09-02 06:40:00 | AAPL | Stock | 27.255 | 27.255 | 27.25 | 27.25 | 12768.0 |
| 2015-09-02 06:45:00 | AAPL | Stock | 27.25 | 27.25 | 27.22 | 27.2275 | 28632.0 |
| 2015-09-02 06:50:00 | AAPL | Stock | 27.225 | 27.2375 | 27.22 | 27.2375 | 21400.0 |
| 2015-09-02 06:55:00 | AAPL | Stock | 27.2225 | 27.235 | 27.205 | 27.235 | 21016.0 |
| 2015-09-02 07:00:00 | AAPL | Stock | 27.235 | 27.25 | 27.2075 | 27.25 | 51784.0 |
| 2015-09-02 07:05:00 | AAPL | Stock | 27.25 | 27.31 | 27.2375 | 27.31 | 38252.0 |
| 2015-09-02 07:10:00 | AAPL | Stock | 27.2825 | 27.305 | 27.23 | 27.23 | 51696.0 |
| 2015-09-02 07:15:00 | AAPL | Stock | 27.24 | 27.245 | 27.2125 | 27.2375 | 21728.0 |
| 2015-09-02 07:20:00 | AAPL | Stock | 27.2275 | 27.2575 | 27.225 | 27.2575 | 29876.0 |
| 2015-09-02 07:25:00 | AAPL | Stock | 27.2575 | 27.2575 | 27.245 | 27.2575 | 18400.0 |
| 2015-09-02 07:30:00 | AAPL | Stock | 27.275 | 27.275 | 27.27 | 27.275 | 11520.0 |
| 2015-09-02 07:35:00 | AAPL | Stock | 27.275 | 27.3075 | 27.225 | 27.3075 | 56716.0 |
| 2015-09-02 07:40:00 | AAPL | Stock | 27.305 | 27.31 | 27.275 | 27.275 | 43400.0 |
| 2015-09-02 07:45:00 | AAPL | Stock | 27.2875 | 27.3575 | 27.275 | 27.35 | 152928.0 |
| 2015-09-02 07:50:00 | AAPL | Stock | 27.3375 | 27.3575 | 27.31 | 27.31 | 62856.0 |
| 2015-09-02 07:55:00 | AAPL | Stock | 27.3125 | 27.36 | 27.3075 | 27.3275 | 57316.0 |
| 2015-09-02 08:00:00 | AAPL | Stock | 27.25 | 27.4125 | 27.225 | 27.395 | 562528.0 |
| 2015-09-02 08:05:00 | AAPL | Stock | 27.3975 | 27.3975 | 27.345 | 27.3475 | 95336.0 |
| 2015-09-02 08:10:00 | AAPL | Stock | 27.355 | 27.37 | 27.345 | 27.35 | 53320.0 |
| 2015-09-02 08:15:00 | AAPL | Stock | 27.3575 | 27.3625 | 27.3325 | 27.3625 | 101876.0 |
| 2015-09-02 08:20:00 | AAPL | Stock | 27.3575 | 27.4 | 27.35 | 27.3625 | 68836.0 |
| 2015-09-02 08:25:00 | AAPL | Stock | 27.375 | 27.41 | 27.3675 | 27.3675 | 91496.0 |
| 2015-09-02 08:30:00 | AAPL | Stock | 27.3775 | 27.4 | 27.3775 | 27.385 | 66816.0 |
| 2015-09-02 08:35:00 | AAPL | Stock | 27.3975 | 27.45 | 27.3875 | 27.45 | 387312.0 |
| 2015-09-02 08:40:00 | AAPL | Stock | 27.45 | 27.5 | 27.4325 | 27.47 | 140652.0 |
| 2015-09-02 08:45:00 | AAPL | Stock | 27.48 | 27.4875 | 27.45 | 27.45 | 57044.0 |
| 2015-09-02 08:50:00 | AAPL | Stock | 27.455 | 27.4825 | 27.4375 | 27.48 | 104396.0 |
> showing 50 of 365,176 rows — these rows as CSV