PREVIEW / stock_5min / 2018-02-12
file: by_date/stock_5min/2018/2018-02-12.parquet size: 5.7 MB rows: 368,775 symbols: 2,894
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-02-12 04:00:00 | AAPL | Stock | 39.4125 | 39.5 | 39.4125 | 39.5 | 1200.0 |
| 2018-02-12 04:05:00 | AAPL | Stock | 39.6275 | 39.85 | 39.6275 | 39.85 | 9452.0 |
| 2018-02-12 04:25:00 | AAPL | Stock | 39.7 | 39.7 | 39.7 | 39.7 | 400.0 |
| 2018-02-12 04:35:00 | AAPL | Stock | 39.71 | 39.71 | 39.71 | 39.71 | 800.0 |
| 2018-02-12 04:55:00 | AAPL | Stock | 39.7 | 39.705 | 39.7 | 39.705 | 9596.0 |
| 2018-02-12 05:05:00 | AAPL | Stock | 39.6225 | 39.6225 | 39.5875 | 39.5975 | 17816.0 |
| 2018-02-12 05:10:00 | AAPL | Stock | 39.5975 | 39.6 | 39.5975 | 39.6 | 5208.0 |
| 2018-02-12 05:30:00 | AAPL | Stock | 39.555 | 39.555 | 39.555 | 39.555 | 400.0 |
| 2018-02-12 05:35:00 | AAPL | Stock | 39.62 | 39.625 | 39.62 | 39.625 | 4436.0 |
| 2018-02-12 05:40:00 | AAPL | Stock | 39.5975 | 39.5975 | 39.5975 | 39.5975 | 400.0 |
| 2018-02-12 05:55:00 | AAPL | Stock | 39.6175 | 39.6175 | 39.6175 | 39.6175 | 400.0 |
| 2018-02-12 06:00:00 | AAPL | Stock | 39.55 | 39.625 | 39.535 | 39.625 | 4400.0 |
| 2018-02-12 06:05:00 | AAPL | Stock | 39.65 | 39.65 | 39.65 | 39.65 | 1200.0 |
| 2018-02-12 06:10:00 | AAPL | Stock | 39.65 | 39.65 | 39.65 | 39.65 | 800.0 |
| 2018-02-12 06:15:00 | AAPL | Stock | 39.625 | 39.625 | 39.6 | 39.6 | 3252.0 |
| 2018-02-12 06:20:00 | AAPL | Stock | 39.7 | 39.7 | 39.6025 | 39.6025 | 2000.0 |
| 2018-02-12 06:25:00 | AAPL | Stock | 39.625 | 39.625 | 39.625 | 39.625 | 804.0 |
| 2018-02-12 06:30:00 | AAPL | Stock | 39.605 | 39.625 | 39.6025 | 39.625 | 4448.0 |
| 2018-02-12 06:35:00 | AAPL | Stock | 39.615 | 39.615 | 39.575 | 39.575 | 2000.0 |
| 2018-02-12 06:40:00 | AAPL | Stock | 39.525 | 39.5975 | 39.505 | 39.525 | 9000.0 |
| 2018-02-12 06:45:00 | AAPL | Stock | 39.5375 | 39.5375 | 39.5 | 39.5 | 1800.0 |
| 2018-02-12 06:55:00 | AAPL | Stock | 39.465 | 39.5 | 39.465 | 39.4975 | 9584.0 |
| 2018-02-12 07:00:00 | AAPL | Stock | 39.525 | 39.5625 | 39.4675 | 39.5575 | 30740.0 |
| 2018-02-12 07:05:00 | AAPL | Stock | 39.5625 | 39.6225 | 39.5625 | 39.5975 | 25916.0 |
| 2018-02-12 07:10:00 | AAPL | Stock | 39.575 | 39.575 | 39.55 | 39.565 | 3888.0 |
| 2018-02-12 07:15:00 | AAPL | Stock | 39.555 | 39.6 | 39.555 | 39.6 | 6040.0 |
| 2018-02-12 07:20:00 | AAPL | Stock | 39.5975 | 39.625 | 39.5875 | 39.625 | 31976.0 |
| 2018-02-12 07:25:00 | AAPL | Stock | 39.6075 | 39.6075 | 39.585 | 39.6 | 29416.0 |
| 2018-02-12 07:30:00 | AAPL | Stock | 39.6125 | 39.625 | 39.585 | 39.6 | 25748.0 |
| 2018-02-12 07:35:00 | AAPL | Stock | 39.59 | 39.6475 | 39.585 | 39.645 | 42232.0 |
| 2018-02-12 07:40:00 | AAPL | Stock | 39.6475 | 39.65 | 39.625 | 39.63 | 49712.0 |
| 2018-02-12 07:45:00 | AAPL | Stock | 39.645 | 39.6675 | 39.6375 | 39.6475 | 24792.0 |
| 2018-02-12 07:50:00 | AAPL | Stock | 39.65 | 39.6875 | 39.65 | 39.675 | 26152.0 |
| 2018-02-12 07:55:00 | AAPL | Stock | 39.6625 | 39.7125 | 39.6625 | 39.68 | 29816.0 |
| 2018-02-12 08:00:00 | AAPL | Stock | 39.7 | 39.705 | 39.4712 | 39.67 | 140604.0 |
| 2018-02-12 08:05:00 | AAPL | Stock | 39.6875 | 39.6875 | 39.6575 | 39.6625 | 14616.0 |
| 2018-02-12 08:10:00 | AAPL | Stock | 39.675 | 39.705 | 39.1025 | 39.705 | 60440.0 |
| 2018-02-12 08:15:00 | AAPL | Stock | 39.7125 | 39.725 | 39.705 | 39.7175 | 51288.0 |
| 2018-02-12 08:20:00 | AAPL | Stock | 39.705 | 39.715 | 39.685 | 39.6925 | 54200.0 |
| 2018-02-12 08:25:00 | AAPL | Stock | 39.6875 | 39.725 | 39.685 | 39.725 | 49316.0 |
| 2018-02-12 08:30:00 | AAPL | Stock | 39.72 | 39.7375 | 39.7075 | 39.735 | 30036.0 |
| 2018-02-12 08:35:00 | AAPL | Stock | 39.7375 | 39.7375 | 39.7 | 39.7 | 37248.0 |
| 2018-02-12 08:40:00 | AAPL | Stock | 39.7025 | 39.7125 | 39.685 | 39.7 | 34096.0 |
| 2018-02-12 08:45:00 | AAPL | Stock | 39.7 | 39.7325 | 39.7 | 39.7325 | 58116.0 |
| 2018-02-12 08:50:00 | AAPL | Stock | 39.7325 | 39.7325 | 39.5825 | 39.5825 | 95852.0 |
| 2018-02-12 08:55:00 | AAPL | Stock | 39.585 | 39.6375 | 39.5675 | 39.6 | 75160.0 |
| 2018-02-12 09:00:00 | AAPL | Stock | 39.5975 | 39.61 | 39.5375 | 39.5375 | 62052.0 |
| 2018-02-12 09:05:00 | AAPL | Stock | 39.55 | 39.56 | 39.45 | 39.4975 | 87660.0 |
| 2018-02-12 09:10:00 | AAPL | Stock | 39.4875 | 39.4875 | 39.3925 | 39.41 | 105256.0 |
| 2018-02-12 09:15:00 | AAPL | Stock | 39.385 | 39.4525 | 39.25 | 39.4375 | 86060.0 |
> showing 50 of 368,775 rows — these rows as CSV