PREVIEW / stock_5min / 2018-12-18
file: by_date/stock_5min/2018/2018-12-18.parquet size: 6.0 MB rows: 381,584 symbols: 2,731
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 |
|---|---|---|---|---|---|---|---|
| 2018-12-18 04:00:00 | AAPL | Stock | 41.175 | 41.175 | 41.175 | 41.175 | 5332.0 |
| 2018-12-18 04:05:00 | AAPL | Stock | 41.175 | 41.175 | 41.175 | 41.175 | 2000.0 |
| 2018-12-18 04:10:00 | AAPL | Stock | 41.17 | 41.175 | 41.17 | 41.175 | 4088.0 |
| 2018-12-18 04:15:00 | AAPL | Stock | 41.2125 | 41.2125 | 41.15 | 41.15 | 1680.0 |
| 2018-12-18 04:20:00 | AAPL | Stock | 41.1 | 41.1 | 41.1 | 41.1 | 2220.0 |
| 2018-12-18 04:40:00 | AAPL | Stock | 41.18 | 41.2075 | 41.18 | 41.2075 | 2688.0 |
| 2018-12-18 04:45:00 | AAPL | Stock | 41.2225 | 41.3325 | 41.2225 | 41.3325 | 3684.0 |
| 2018-12-18 05:25:00 | AAPL | Stock | 41.3325 | 41.375 | 41.3325 | 41.375 | 2400.0 |
| 2018-12-18 05:30:00 | AAPL | Stock | 41.37 | 41.375 | 41.37 | 41.3725 | 1600.0 |
| 2018-12-18 05:35:00 | AAPL | Stock | 41.3725 | 41.3725 | 41.37 | 41.37 | 800.0 |
| 2018-12-18 05:40:00 | AAPL | Stock | 41.345 | 41.345 | 41.345 | 41.345 | 1868.0 |
| 2018-12-18 05:45:00 | AAPL | Stock | 41.3125 | 41.315 | 41.255 | 41.3 | 4672.0 |
| 2018-12-18 06:00:00 | AAPL | Stock | 41.275 | 41.325 | 41.275 | 41.325 | 4788.0 |
| 2018-12-18 06:05:00 | AAPL | Stock | 41.325 | 41.37 | 41.325 | 41.37 | 800.0 |
| 2018-12-18 06:10:00 | AAPL | Stock | 41.375 | 41.375 | 41.375 | 41.375 | 2400.0 |
| 2018-12-18 06:20:00 | AAPL | Stock | 41.35 | 41.375 | 41.3375 | 41.3375 | 6000.0 |
| 2018-12-18 06:30:00 | AAPL | Stock | 41.4 | 41.4 | 41.375 | 41.375 | 3072.0 |
| 2018-12-18 06:35:00 | AAPL | Stock | 41.37 | 41.37 | 41.37 | 41.37 | 972.0 |
| 2018-12-18 06:40:00 | AAPL | Stock | 41.37 | 41.37 | 41.355 | 41.355 | 1600.0 |
| 2018-12-18 06:45:00 | AAPL | Stock | 41.375 | 41.375 | 41.375 | 41.375 | 800.0 |
| 2018-12-18 06:50:00 | AAPL | Stock | 41.375 | 41.375 | 41.375 | 41.375 | 800.0 |
| 2018-12-18 06:55:00 | AAPL | Stock | 41.3775 | 41.3825 | 41.375 | 41.3825 | 1600.0 |
| 2018-12-18 07:00:00 | AAPL | Stock | 41.41 | 41.41 | 41.375 | 41.3825 | 28028.0 |
| 2018-12-18 07:05:00 | AAPL | Stock | 41.3625 | 41.3625 | 41.3 | 41.3025 | 13200.0 |
| 2018-12-18 07:10:00 | AAPL | Stock | 41.3375 | 41.345 | 41.3125 | 41.3175 | 22804.0 |
| 2018-12-18 07:15:00 | AAPL | Stock | 41.31 | 41.31 | 41.3 | 41.3 | 1328.0 |
| 2018-12-18 07:20:00 | AAPL | Stock | 41.3025 | 41.345 | 41.3025 | 41.3275 | 8324.0 |
| 2018-12-18 07:25:00 | AAPL | Stock | 41.355 | 41.3625 | 41.3375 | 41.3625 | 10192.0 |
| 2018-12-18 07:30:00 | AAPL | Stock | 41.36 | 41.375 | 41.355 | 41.375 | 28780.0 |
| 2018-12-18 07:35:00 | AAPL | Stock | 41.365 | 41.4225 | 41.3625 | 41.375 | 24044.0 |
| 2018-12-18 07:40:00 | AAPL | Stock | 41.375 | 41.375 | 41.365 | 41.365 | 2892.0 |
| 2018-12-18 07:45:00 | AAPL | Stock | 41.365 | 41.4375 | 41.355 | 41.4 | 36272.0 |
| 2018-12-18 07:50:00 | AAPL | Stock | 41.42 | 41.4325 | 41.4 | 41.4325 | 26324.0 |
| 2018-12-18 07:55:00 | AAPL | Stock | 41.425 | 41.435 | 41.4025 | 41.4025 | 1900.0 |
| 2018-12-18 08:00:00 | AAPL | Stock | 41.352 | 41.44 | 41.295 | 41.375 | 107732.0 |
| 2018-12-18 08:05:00 | AAPL | Stock | 41.4 | 41.4 | 41.36 | 41.3775 | 20268.0 |
| 2018-12-18 08:10:00 | AAPL | Stock | 41.38 | 41.44 | 41.375 | 41.425 | 29980.0 |
| 2018-12-18 08:15:00 | AAPL | Stock | 41.3925 | 41.3925 | 41.37 | 41.37 | 21880.0 |
| 2018-12-18 08:20:00 | AAPL | Stock | 41.375 | 41.375 | 41.34 | 41.35 | 20556.0 |
| 2018-12-18 08:25:00 | AAPL | Stock | 41.375 | 41.375 | 41.3525 | 41.37 | 10956.0 |
| 2018-12-18 08:30:00 | AAPL | Stock | 41.3525 | 41.405 | 41.3425 | 41.35 | 6380.0 |
| 2018-12-18 08:35:00 | AAPL | Stock | 41.35 | 41.365 | 41.3425 | 41.3525 | 11772.0 |
| 2018-12-18 08:40:00 | AAPL | Stock | 41.3625 | 41.3675 | 41.3175 | 41.325 | 40716.0 |
| 2018-12-18 08:45:00 | AAPL | Stock | 41.3425 | 41.3675 | 41.3425 | 41.3625 | 5288.0 |
| 2018-12-18 08:50:00 | AAPL | Stock | 41.36 | 41.3625 | 41.2925 | 41.3 | 26756.0 |
| 2018-12-18 08:55:00 | AAPL | Stock | 41.3425 | 41.3475 | 41.3 | 41.3375 | 12400.0 |
| 2018-12-18 09:00:00 | AAPL | Stock | 41.3025 | 41.3375 | 41.295 | 41.3025 | 29148.0 |
| 2018-12-18 09:05:00 | AAPL | Stock | 41.3175 | 41.3375 | 41.3125 | 41.3275 | 20992.0 |
| 2018-12-18 09:10:00 | AAPL | Stock | 41.335 | 41.35 | 41.3125 | 41.325 | 29700.0 |
| 2018-12-18 09:15:00 | AAPL | Stock | 41.3375 | 41.35 | 41.315 | 41.34 | 10212.0 |
> showing 50 of 381,584 rows — these rows as CSV