PREVIEW / stock_5min / 2018-07-26
file: by_date/stock_5min/2018/2018-07-26.parquet size: 5.5 MB rows: 352,533 symbols: 2,832
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-07-26 04:00:00 | AAPL | Stock | 48.205 | 48.2525 | 48.205 | 48.2525 | 4348.0 |
| 2018-07-26 04:05:00 | AAPL | Stock | 48.245 | 48.245 | 48.245 | 48.245 | 828.0 |
| 2018-07-26 04:10:00 | AAPL | Stock | 48.2525 | 48.2525 | 48.2525 | 48.2525 | 512.0 |
| 2018-07-26 04:25:00 | AAPL | Stock | 48.3125 | 48.3175 | 48.31 | 48.31 | 4192.0 |
| 2018-07-26 04:30:00 | AAPL | Stock | 48.3125 | 48.3125 | 48.3125 | 48.3125 | 400.0 |
| 2018-07-26 04:50:00 | AAPL | Stock | 48.25 | 48.3125 | 48.2475 | 48.3125 | 11864.0 |
| 2018-07-26 04:55:00 | AAPL | Stock | 48.3125 | 48.3125 | 48.3125 | 48.3125 | 7700.0 |
| 2018-07-26 05:05:00 | AAPL | Stock | 48.3 | 48.3 | 48.2475 | 48.2475 | 2076.0 |
| 2018-07-26 05:10:00 | AAPL | Stock | 48.2975 | 48.3125 | 48.265 | 48.265 | 5932.0 |
| 2018-07-26 05:15:00 | AAPL | Stock | 48.3125 | 48.3125 | 48.3125 | 48.3125 | 752.0 |
| 2018-07-26 05:20:00 | AAPL | Stock | 48.25 | 48.2525 | 48.25 | 48.25 | 4316.0 |
| 2018-07-26 05:25:00 | AAPL | Stock | 48.3025 | 48.3025 | 48.3025 | 48.3025 | 400.0 |
| 2018-07-26 05:30:00 | AAPL | Stock | 48.3125 | 48.3125 | 48.3125 | 48.3125 | 20756.0 |
| 2018-07-26 05:35:00 | AAPL | Stock | 48.3125 | 48.3125 | 48.3125 | 48.3125 | 2800.0 |
| 2018-07-26 06:15:00 | AAPL | Stock | 48.2875 | 48.2875 | 48.2875 | 48.2875 | 2224.0 |
| 2018-07-26 06:20:00 | AAPL | Stock | 48.2875 | 48.2875 | 48.2875 | 48.2875 | 1200.0 |
| 2018-07-26 06:25:00 | AAPL | Stock | 48.2875 | 48.36 | 48.2875 | 48.36 | 7200.0 |
| 2018-07-26 06:30:00 | AAPL | Stock | 48.3575 | 48.3625 | 48.3575 | 48.3625 | 2000.0 |
| 2018-07-26 06:35:00 | AAPL | Stock | 48.35 | 48.35 | 48.35 | 48.35 | 4000.0 |
| 2018-07-26 06:40:00 | AAPL | Stock | 48.375 | 48.375 | 48.375 | 48.375 | 7000.0 |
| 2018-07-26 06:45:00 | AAPL | Stock | 48.3775 | 48.3775 | 48.375 | 48.375 | 9580.0 |
| 2018-07-26 06:55:00 | AAPL | Stock | 48.41 | 48.4125 | 48.375 | 48.375 | 25320.0 |
| 2018-07-26 07:00:00 | AAPL | Stock | 48.38 | 48.4125 | 48.3625 | 48.4125 | 33912.0 |
| 2018-07-26 07:05:00 | AAPL | Stock | 48.4 | 48.4325 | 48.4 | 48.4325 | 23000.0 |
| 2018-07-26 07:10:00 | AAPL | Stock | 48.445 | 48.445 | 48.425 | 48.4375 | 9740.0 |
| 2018-07-26 07:15:00 | AAPL | Stock | 48.4375 | 48.4375 | 48.3975 | 48.4375 | 5676.0 |
| 2018-07-26 07:20:00 | AAPL | Stock | 48.435 | 48.435 | 48.435 | 48.435 | 400.0 |
| 2018-07-26 07:25:00 | AAPL | Stock | 48.415 | 48.415 | 48.3925 | 48.3925 | 3308.0 |
| 2018-07-26 07:30:00 | AAPL | Stock | 48.3975 | 48.4075 | 48.3875 | 48.3875 | 3656.0 |
| 2018-07-26 07:35:00 | AAPL | Stock | 48.4 | 48.4075 | 48.4 | 48.4075 | 4756.0 |
| 2018-07-26 07:40:00 | AAPL | Stock | 48.4125 | 48.445 | 48.4125 | 48.445 | 10876.0 |
| 2018-07-26 07:45:00 | AAPL | Stock | 48.45 | 48.45 | 48.4325 | 48.4325 | 4972.0 |
| 2018-07-26 07:50:00 | AAPL | Stock | 48.4325 | 48.4325 | 48.4325 | 48.4325 | 444.0 |
| 2018-07-26 07:55:00 | AAPL | Stock | 48.44 | 48.4475 | 48.44 | 48.4475 | 8624.0 |
| 2018-07-26 08:00:00 | AAPL | Stock | 48.39 | 48.455 | 48.39 | 48.455 | 56848.0 |
| 2018-07-26 08:05:00 | AAPL | Stock | 48.4575 | 48.6875 | 48.45 | 48.57 | 180980.0 |
| 2018-07-26 08:10:00 | AAPL | Stock | 48.5725 | 48.6275 | 48.57 | 48.625 | 34672.0 |
| 2018-07-26 08:15:00 | AAPL | Stock | 48.625 | 48.625 | 48.575 | 48.5925 | 41084.0 |
| 2018-07-26 08:20:00 | AAPL | Stock | 48.6 | 48.625 | 48.59 | 48.6225 | 43108.0 |
| 2018-07-26 08:25:00 | AAPL | Stock | 48.6225 | 48.625 | 48.57 | 48.6 | 44184.0 |
| 2018-07-26 08:30:00 | AAPL | Stock | 48.57 | 48.6175 | 48.5 | 48.55 | 121004.0 |
| 2018-07-26 08:35:00 | AAPL | Stock | 48.5475 | 48.5475 | 48.4875 | 48.545 | 34732.0 |
| 2018-07-26 08:40:00 | AAPL | Stock | 48.5125 | 48.5475 | 48.5125 | 48.525 | 14648.0 |
| 2018-07-26 08:45:00 | AAPL | Stock | 48.515 | 48.515 | 48.475 | 48.5 | 30312.0 |
| 2018-07-26 08:50:00 | AAPL | Stock | 48.5 | 48.5125 | 48.48 | 48.5 | 13384.0 |
| 2018-07-26 08:55:00 | AAPL | Stock | 48.4875 | 48.5025 | 48.4875 | 48.5025 | 15140.0 |
| 2018-07-26 09:00:00 | AAPL | Stock | 48.4975 | 48.535 | 48.4975 | 48.53 | 15588.0 |
| 2018-07-26 09:05:00 | AAPL | Stock | 48.5325 | 48.55 | 48.5025 | 48.55 | 23764.0 |
| 2018-07-26 09:10:00 | AAPL | Stock | 48.5475 | 48.55 | 48.5275 | 48.54 | 19696.0 |
| 2018-07-26 09:15:00 | AAPL | Stock | 48.5375 | 48.5375 | 48.515 | 48.5225 | 13056.0 |
> showing 50 of 352,533 rows — these rows as CSV