PREVIEW / stock_5min / 2016-04-08
file: by_date/stock_5min/2016/2016-04-08.parquet size: 5.2 MB rows: 348,906 symbols: 3,334
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 |
|---|---|---|---|---|---|---|---|
| 2016-04-08 04:00:00 | AAPL | Stock | 27.335 | 27.3425 | 27.335 | 27.3425 | 1600.0 |
| 2016-04-08 04:05:00 | AAPL | Stock | 27.2825 | 27.2825 | 27.2825 | 27.2825 | 480.0 |
| 2016-04-08 04:15:00 | AAPL | Stock | 27.3075 | 27.3075 | 27.3075 | 27.3075 | 560.0 |
| 2016-04-08 04:35:00 | AAPL | Stock | 27.3075 | 27.3075 | 27.3075 | 27.3075 | 800.0 |
| 2016-04-08 06:00:00 | AAPL | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 752.0 |
| 2016-04-08 06:15:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 2000.0 |
| 2016-04-08 06:55:00 | AAPL | Stock | 27.33 | 27.3425 | 27.33 | 27.3425 | 1056.0 |
| 2016-04-08 07:00:00 | AAPL | Stock | 27.35 | 27.375 | 27.35 | 27.375 | 15704.0 |
| 2016-04-08 07:05:00 | AAPL | Stock | 27.355 | 27.355 | 27.34 | 27.34 | 18500.0 |
| 2016-04-08 07:10:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 400.0 |
| 2016-04-08 07:15:00 | AAPL | Stock | 27.31 | 27.31 | 27.31 | 27.31 | 1000.0 |
| 2016-04-08 07:20:00 | AAPL | Stock | 27.31 | 27.3125 | 27.31 | 27.3125 | 6104.0 |
| 2016-04-08 07:25:00 | AAPL | Stock | 27.3175 | 27.3175 | 27.3175 | 27.3175 | 4000.0 |
| 2016-04-08 07:30:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 400.0 |
| 2016-04-08 07:40:00 | AAPL | Stock | 27.335 | 27.3375 | 27.335 | 27.3375 | 800.0 |
| 2016-04-08 07:45:00 | AAPL | Stock | 27.34 | 27.3675 | 27.3375 | 27.3375 | 15300.0 |
| 2016-04-08 07:50:00 | AAPL | Stock | 27.325 | 27.3275 | 27.325 | 27.3275 | 3000.0 |
| 2016-04-08 07:55:00 | AAPL | Stock | 27.34 | 27.3625 | 27.34 | 27.35 | 14480.0 |
| 2016-04-08 08:00:00 | AAPL | Stock | 27.35 | 27.375 | 27.3125 | 27.335 | 69544.0 |
| 2016-04-08 08:05:00 | AAPL | Stock | 27.3375 | 27.3375 | 27.33 | 27.3325 | 30340.0 |
| 2016-04-08 08:10:00 | AAPL | Stock | 27.33 | 27.3375 | 27.33 | 27.3325 | 21332.0 |
| 2016-04-08 08:15:00 | AAPL | Stock | 27.3325 | 27.3425 | 27.33 | 27.335 | 8140.0 |
| 2016-04-08 08:20:00 | AAPL | Stock | 27.3425 | 27.35 | 27.3375 | 27.35 | 6552.0 |
| 2016-04-08 08:25:00 | AAPL | Stock | 27.35 | 27.365 | 27.35 | 27.35 | 12664.0 |
| 2016-04-08 08:30:00 | AAPL | Stock | 27.355 | 27.3875 | 27.355 | 27.3875 | 113572.0 |
| 2016-04-08 08:35:00 | AAPL | Stock | 27.3875 | 27.405 | 27.37 | 27.38 | 26324.0 |
| 2016-04-08 08:40:00 | AAPL | Stock | 27.385 | 27.39 | 27.3675 | 27.39 | 23736.0 |
| 2016-04-08 08:45:00 | AAPL | Stock | 27.37 | 27.37 | 27.35 | 27.3625 | 19220.0 |
| 2016-04-08 08:50:00 | AAPL | Stock | 27.3625 | 27.3875 | 27.3625 | 27.3775 | 25960.0 |
| 2016-04-08 08:55:00 | AAPL | Stock | 27.3825 | 27.3925 | 27.37 | 27.375 | 38800.0 |
| 2016-04-08 09:00:00 | AAPL | Stock | 27.375 | 27.375 | 27.365 | 27.365 | 13640.0 |
| 2016-04-08 09:05:00 | AAPL | Stock | 27.3625 | 27.3625 | 27.3525 | 27.3625 | 19640.0 |
| 2016-04-08 09:10:00 | AAPL | Stock | 27.3575 | 27.36 | 27.35 | 27.35 | 7300.0 |
| 2016-04-08 09:15:00 | AAPL | Stock | 27.345 | 27.355 | 27.3375 | 27.34 | 56916.0 |
| 2016-04-08 09:20:00 | AAPL | Stock | 27.35 | 27.355 | 27.3425 | 27.35 | 26920.0 |
| 2016-04-08 09:25:00 | AAPL | Stock | 27.355 | 27.355 | 27.2325 | 27.2325 | 259512.0 |
| 2016-04-08 09:30:00 | AAPL | Stock | 27.235 | 27.3125 | 27.17 | 27.31 | 4256048.0 |
| 2016-04-08 09:35:00 | AAPL | Stock | 27.31 | 27.3875 | 27.2775 | 27.2825 | 3019636.0 |
| 2016-04-08 09:40:00 | AAPL | Stock | 27.285 | 27.3625 | 27.2775 | 27.34 | 2168816.0 |
| 2016-04-08 09:45:00 | AAPL | Stock | 27.3425 | 27.37 | 27.2625 | 27.2925 | 1818184.0 |
| 2016-04-08 09:50:00 | AAPL | Stock | 27.2975 | 27.3225 | 27.26 | 27.2875 | 1786968.0 |
| 2016-04-08 09:55:00 | AAPL | Stock | 27.289 | 27.3625 | 27.27 | 27.36 | 1285396.0 |
| 2016-04-08 10:00:00 | AAPL | Stock | 27.3575 | 27.3925 | 27.3375 | 27.3922 | 1889752.0 |
| 2016-04-08 10:05:00 | AAPL | Stock | 27.3862 | 27.425 | 27.3675 | 27.4175 | 1918396.0 |
| 2016-04-08 10:10:00 | AAPL | Stock | 27.4175 | 27.4225 | 27.3552 | 27.4075 | 1281040.0 |
| 2016-04-08 10:15:00 | AAPL | Stock | 27.408 | 27.435 | 27.4075 | 27.415 | 1405348.0 |
| 2016-04-08 10:20:00 | AAPL | Stock | 27.4125 | 27.4225 | 27.3575 | 27.365 | 1425756.0 |
| 2016-04-08 10:25:00 | AAPL | Stock | 27.3638 | 27.41 | 27.355 | 27.385 | 1134884.0 |
| 2016-04-08 10:30:00 | AAPL | Stock | 27.385 | 27.4092 | 27.3835 | 27.3992 | 654268.0 |
| 2016-04-08 10:35:00 | AAPL | Stock | 27.4 | 27.44 | 27.3962 | 27.3962 | 1318272.0 |
> showing 50 of 348,906 rows — these rows as CSV