PREVIEW / stock_5min / 2018-04-18
file: by_date/stock_5min/2018/2018-04-18.parquet size: 5.5 MB rows: 355,986 symbols: 2,855
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-04-18 04:15:00 | AAPL | Stock | 44.685 | 44.685 | 44.685 | 44.685 | 400.0 |
| 2018-04-18 04:50:00 | AAPL | Stock | 44.595 | 44.595 | 44.595 | 44.595 | 800.0 |
| 2018-04-18 05:10:00 | AAPL | Stock | 44.625 | 44.625 | 44.625 | 44.625 | 800.0 |
| 2018-04-18 05:25:00 | AAPL | Stock | 44.585 | 44.585 | 44.585 | 44.585 | 800.0 |
| 2018-04-18 05:50:00 | AAPL | Stock | 44.54 | 44.54 | 44.54 | 44.54 | 2000.0 |
| 2018-04-18 06:10:00 | AAPL | Stock | 44.5425 | 44.5425 | 44.5375 | 44.5375 | 3348.0 |
| 2018-04-18 06:55:00 | AAPL | Stock | 44.6225 | 44.625 | 44.6225 | 44.625 | 5512.0 |
| 2018-04-18 07:00:00 | AAPL | Stock | 44.6 | 44.625 | 44.6 | 44.625 | 1600.0 |
| 2018-04-18 07:05:00 | AAPL | Stock | 44.65 | 44.685 | 44.6475 | 44.6725 | 21800.0 |
| 2018-04-18 07:10:00 | AAPL | Stock | 44.675 | 44.675 | 44.675 | 44.675 | 828.0 |
| 2018-04-18 07:20:00 | AAPL | Stock | 44.6775 | 44.6775 | 44.6775 | 44.6775 | 1600.0 |
| 2018-04-18 07:25:00 | AAPL | Stock | 44.6775 | 44.6775 | 44.675 | 44.675 | 4132.0 |
| 2018-04-18 07:35:00 | AAPL | Stock | 44.6575 | 44.6575 | 44.65 | 44.65 | 1600.0 |
| 2018-04-18 07:40:00 | AAPL | Stock | 44.65 | 44.65 | 44.6375 | 44.6375 | 9600.0 |
| 2018-04-18 07:45:00 | AAPL | Stock | 44.6375 | 44.6375 | 44.6225 | 44.625 | 8532.0 |
| 2018-04-18 07:50:00 | AAPL | Stock | 44.625 | 44.625 | 44.625 | 44.625 | 1376.0 |
| 2018-04-18 07:55:00 | AAPL | Stock | 44.6225 | 44.6225 | 44.6125 | 44.62 | 9112.0 |
| 2018-04-18 08:00:00 | AAPL | Stock | 44.625 | 44.6875 | 44.625 | 44.625 | 12464.0 |
| 2018-04-18 08:05:00 | AAPL | Stock | 44.625 | 44.625 | 44.625 | 44.625 | 2000.0 |
| 2018-04-18 08:10:00 | AAPL | Stock | 44.625 | 44.625 | 44.575 | 44.575 | 36404.0 |
| 2018-04-18 08:15:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 10800.0 |
| 2018-04-18 08:20:00 | AAPL | Stock | 44.5975 | 44.5975 | 44.575 | 44.575 | 4680.0 |
| 2018-04-18 08:25:00 | AAPL | Stock | 44.5875 | 44.5875 | 44.575 | 44.5875 | 16280.0 |
| 2018-04-18 08:30:00 | AAPL | Stock | 44.5875 | 44.5875 | 44.5875 | 44.5875 | 9800.0 |
| 2018-04-18 08:35:00 | AAPL | Stock | 44.5625 | 44.5625 | 44.5625 | 44.5625 | 3636.0 |
| 2018-04-18 08:40:00 | AAPL | Stock | 44.565 | 44.565 | 44.555 | 44.555 | 2800.0 |
| 2018-04-18 08:45:00 | AAPL | Stock | 44.555 | 44.555 | 44.535 | 44.535 | 24396.0 |
| 2018-04-18 08:50:00 | AAPL | Stock | 44.53 | 44.54 | 44.53 | 44.54 | 2800.0 |
| 2018-04-18 08:55:00 | AAPL | Stock | 44.56 | 44.56 | 44.55 | 44.55 | 8368.0 |
| 2018-04-18 09:00:00 | AAPL | Stock | 44.565 | 44.575 | 44.5525 | 44.5525 | 2160.0 |
| 2018-04-18 09:05:00 | AAPL | Stock | 44.5525 | 44.565 | 44.545 | 44.545 | 14964.0 |
| 2018-04-18 09:10:00 | AAPL | Stock | 44.5575 | 44.5675 | 44.545 | 44.545 | 5200.0 |
| 2018-04-18 09:15:00 | AAPL | Stock | 44.5625 | 44.5625 | 44.545 | 44.5475 | 23804.0 |
| 2018-04-18 09:20:00 | AAPL | Stock | 44.55 | 44.55 | 44.525 | 44.53 | 59876.0 |
| 2018-04-18 09:25:00 | AAPL | Stock | 44.525 | 44.525 | 44.445 | 44.445 | 75520.0 |
| 2018-04-18 09:30:00 | AAPL | Stock | 44.445 | 44.6225 | 44.445 | 44.6115 | 3581684.0 |
| 2018-04-18 09:35:00 | AAPL | Stock | 44.61 | 44.705 | 44.5025 | 44.5375 | 2060716.0 |
| 2018-04-18 09:40:00 | AAPL | Stock | 44.5375 | 44.6125 | 44.4725 | 44.5325 | 2053996.0 |
| 2018-04-18 09:45:00 | AAPL | Stock | 44.5375 | 44.5862 | 44.515 | 44.5762 | 1073612.0 |
| 2018-04-18 09:50:00 | AAPL | Stock | 44.5762 | 44.5925 | 44.485 | 44.49 | 1041536.0 |
| 2018-04-18 09:55:00 | AAPL | Stock | 44.49 | 44.525 | 44.3975 | 44.4238 | 1548544.0 |
| 2018-04-18 10:00:00 | AAPL | Stock | 44.425 | 44.4325 | 44.2925 | 44.3275 | 1862352.0 |
| 2018-04-18 10:05:00 | AAPL | Stock | 44.3275 | 44.3575 | 44.22 | 44.305 | 1952948.0 |
| 2018-04-18 10:10:00 | AAPL | Stock | 44.305 | 44.34 | 44.27 | 44.285 | 1289520.0 |
| 2018-04-18 10:15:00 | AAPL | Stock | 44.2838 | 44.3325 | 44.265 | 44.3195 | 1097452.0 |
| 2018-04-18 10:20:00 | AAPL | Stock | 44.3198 | 44.375 | 44.3138 | 44.33 | 1020772.0 |
| 2018-04-18 10:25:00 | AAPL | Stock | 44.33 | 44.35 | 44.2512 | 44.305 | 1039528.0 |
| 2018-04-18 10:30:00 | AAPL | Stock | 44.305 | 44.3275 | 44.275 | 44.2932 | 952012.0 |
| 2018-04-18 10:35:00 | AAPL | Stock | 44.2925 | 44.3225 | 44.2525 | 44.3225 | 900712.0 |
| 2018-04-18 10:40:00 | AAPL | Stock | 44.3225 | 44.41 | 44.3225 | 44.405 | 1126336.0 |
> showing 50 of 355,986 rows — these rows as CSV