PREVIEW / stock_5min / 2016-08-18
file: by_date/stock_5min/2016/2016-08-18.parquet size: 5.3 MB rows: 346,742 symbols: 3,253
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-08-18 04:35:00 | AAPL | Stock | 27.33 | 27.33 | 27.33 | 27.33 | 764.0 |
| 2016-08-18 04:50:00 | AAPL | Stock | 27.345 | 27.345 | 27.345 | 27.345 | 400.0 |
| 2016-08-18 06:00:00 | AAPL | Stock | 27.3475 | 27.3475 | 27.3475 | 27.3475 | 3604.0 |
| 2016-08-18 06:25:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 2216.0 |
| 2016-08-18 06:40:00 | AAPL | Stock | 27.3275 | 27.3275 | 27.3275 | 27.3275 | 2384.0 |
| 2016-08-18 07:05:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 1600.0 |
| 2016-08-18 07:25:00 | AAPL | Stock | 27.3025 | 27.3025 | 27.3 | 27.3 | 6400.0 |
| 2016-08-18 07:35:00 | AAPL | Stock | 27.295 | 27.295 | 27.295 | 27.295 | 400.0 |
| 2016-08-18 07:40:00 | AAPL | Stock | 27.29 | 27.29 | 27.29 | 27.29 | 3404.0 |
| 2016-08-18 07:50:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.2875 | 27.2875 | 3512.0 |
| 2016-08-18 07:55:00 | AAPL | Stock | 27.27 | 27.27 | 27.265 | 27.265 | 3000.0 |
| 2016-08-18 08:00:00 | AAPL | Stock | 27.2875 | 27.2975 | 27.2675 | 27.2675 | 31136.0 |
| 2016-08-18 08:05:00 | AAPL | Stock | 27.2825 | 27.2825 | 27.265 | 27.265 | 2400.0 |
| 2016-08-18 08:10:00 | AAPL | Stock | 27.275 | 27.285 | 27.2675 | 27.275 | 14056.0 |
| 2016-08-18 08:15:00 | AAPL | Stock | 27.2675 | 27.285 | 27.2625 | 27.285 | 17528.0 |
| 2016-08-18 08:20:00 | AAPL | Stock | 27.275 | 27.275 | 27.265 | 27.265 | 5200.0 |
| 2016-08-18 08:25:00 | AAPL | Stock | 27.275 | 27.275 | 27.275 | 27.275 | 800.0 |
| 2016-08-18 08:30:00 | AAPL | Stock | 27.275 | 27.275 | 27.275 | 27.275 | 2152.0 |
| 2016-08-18 08:35:00 | AAPL | Stock | 27.26 | 27.2725 | 27.26 | 27.2725 | 880.0 |
| 2016-08-18 08:40:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.2625 | 27.2625 | 1020.0 |
| 2016-08-18 08:45:00 | AAPL | Stock | 27.26 | 27.2625 | 27.26 | 27.2625 | 4400.0 |
| 2016-08-18 08:50:00 | AAPL | Stock | 27.265 | 27.265 | 27.26 | 27.26 | 4640.0 |
| 2016-08-18 09:05:00 | AAPL | Stock | 27.275 | 27.275 | 27.2625 | 27.2625 | 4192.0 |
| 2016-08-18 09:10:00 | AAPL | Stock | 27.2625 | 27.275 | 27.2625 | 27.275 | 3220.0 |
| 2016-08-18 09:15:00 | AAPL | Stock | 27.2875 | 27.2925 | 27.2875 | 27.2925 | 19632.0 |
| 2016-08-18 09:20:00 | AAPL | Stock | 27.2925 | 27.2975 | 27.275 | 27.275 | 21600.0 |
| 2016-08-18 09:25:00 | AAPL | Stock | 27.3 | 27.305 | 27.3 | 27.305 | 49440.0 |
| 2016-08-18 09:30:00 | AAPL | Stock | 27.3075 | 27.39 | 27.295 | 27.3862 | 3616104.0 |
| 2016-08-18 09:35:00 | AAPL | Stock | 27.385 | 27.4 | 27.3225 | 27.3775 | 2501208.0 |
| 2016-08-18 09:40:00 | AAPL | Stock | 27.3775 | 27.38 | 27.311 | 27.3375 | 2127600.0 |
| 2016-08-18 09:45:00 | AAPL | Stock | 27.3375 | 27.3812 | 27.3375 | 27.37 | 1530088.0 |
| 2016-08-18 09:50:00 | AAPL | Stock | 27.3725 | 27.38 | 27.325 | 27.3338 | 1173888.0 |
| 2016-08-18 09:55:00 | AAPL | Stock | 27.3338 | 27.36 | 27.3225 | 27.331 | 1054936.0 |
| 2016-08-18 10:00:00 | AAPL | Stock | 27.335 | 27.3525 | 27.3125 | 27.325 | 1539268.0 |
| 2016-08-18 10:05:00 | AAPL | Stock | 27.3262 | 27.3325 | 27.285 | 27.3 | 1859616.0 |
| 2016-08-18 10:10:00 | AAPL | Stock | 27.3025 | 27.3545 | 27.3025 | 27.3325 | 1409944.0 |
| 2016-08-18 10:15:00 | AAPL | Stock | 27.3325 | 27.3448 | 27.3175 | 27.3338 | 746664.0 |
| 2016-08-18 10:20:00 | AAPL | Stock | 27.335 | 27.35 | 27.3225 | 27.3272 | 678852.0 |
| 2016-08-18 10:25:00 | AAPL | Stock | 27.3262 | 27.3425 | 27.31 | 27.3262 | 813836.0 |
| 2016-08-18 10:30:00 | AAPL | Stock | 27.3275 | 27.3438 | 27.3275 | 27.3288 | 497568.0 |
| 2016-08-18 10:35:00 | AAPL | Stock | 27.329 | 27.3375 | 27.3088 | 27.3335 | 658300.0 |
| 2016-08-18 10:40:00 | AAPL | Stock | 27.3325 | 27.3615 | 27.3225 | 27.3565 | 998300.0 |
| 2016-08-18 10:45:00 | AAPL | Stock | 27.355 | 27.3575 | 27.3388 | 27.355 | 583508.0 |
| 2016-08-18 10:50:00 | AAPL | Stock | 27.355 | 27.3725 | 27.355 | 27.3575 | 788476.0 |
| 2016-08-18 10:55:00 | AAPL | Stock | 27.355 | 27.37 | 27.35 | 27.3625 | 820616.0 |
| 2016-08-18 11:00:00 | AAPL | Stock | 27.3625 | 27.3625 | 27.3175 | 27.3325 | 983492.0 |
| 2016-08-18 11:05:00 | AAPL | Stock | 27.3325 | 27.35 | 27.33 | 27.3335 | 829164.0 |
| 2016-08-18 11:10:00 | AAPL | Stock | 27.335 | 27.35 | 27.3325 | 27.35 | 467700.0 |
| 2016-08-18 11:15:00 | AAPL | Stock | 27.3512 | 27.3525 | 27.335 | 27.3498 | 473956.0 |
| 2016-08-18 11:20:00 | AAPL | Stock | 27.3485 | 27.365 | 27.335 | 27.3612 | 775356.0 |
> showing 50 of 346,742 rows — these rows as CSV