PREVIEW / stock_5min / 2018-10-16
file: by_date/stock_5min/2018/2018-10-16.parquet size: 5.8 MB rows: 362,428 symbols: 2,767
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-10-16 04:00:00 | AAPL | Stock | 54.5 | 54.725 | 54.5 | 54.725 | 4688.0 |
| 2018-10-16 04:15:00 | AAPL | Stock | 54.7125 | 54.7125 | 54.7125 | 54.7125 | 400.0 |
| 2018-10-16 04:25:00 | AAPL | Stock | 54.63 | 54.63 | 54.63 | 54.63 | 1200.0 |
| 2018-10-16 04:30:00 | AAPL | Stock | 54.625 | 54.625 | 54.625 | 54.625 | 400.0 |
| 2018-10-16 04:35:00 | AAPL | Stock | 54.5675 | 54.5675 | 54.55 | 54.55 | 2976.0 |
| 2018-10-16 04:40:00 | AAPL | Stock | 54.5425 | 54.5425 | 54.525 | 54.525 | 1320.0 |
| 2018-10-16 04:45:00 | AAPL | Stock | 54.525 | 54.525 | 54.5 | 54.5 | 5584.0 |
| 2018-10-16 05:45:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 2000.0 |
| 2018-10-16 05:50:00 | AAPL | Stock | 54.6 | 54.6 | 54.6 | 54.6 | 400.0 |
| 2018-10-16 06:00:00 | AAPL | Stock | 54.5975 | 54.5975 | 54.575 | 54.575 | 3196.0 |
| 2018-10-16 06:05:00 | AAPL | Stock | 54.575 | 54.575 | 54.575 | 54.575 | 1440.0 |
| 2018-10-16 06:20:00 | AAPL | Stock | 54.6 | 54.65 | 54.6 | 54.65 | 9200.0 |
| 2018-10-16 06:50:00 | AAPL | Stock | 54.6875 | 54.6875 | 54.6875 | 54.6875 | 400.0 |
| 2018-10-16 06:55:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.6725 | 54.6725 | 784.0 |
| 2018-10-16 07:00:00 | AAPL | Stock | 54.6725 | 54.6725 | 54.5375 | 54.54 | 27988.0 |
| 2018-10-16 07:05:00 | AAPL | Stock | 54.5625 | 54.5875 | 54.5 | 54.5725 | 26988.0 |
| 2018-10-16 07:10:00 | AAPL | Stock | 54.57 | 54.57 | 54.5175 | 54.555 | 8076.0 |
| 2018-10-16 07:15:00 | AAPL | Stock | 54.555 | 54.6625 | 54.555 | 54.6625 | 29668.0 |
| 2018-10-16 07:20:00 | AAPL | Stock | 54.65 | 54.655 | 54.625 | 54.625 | 9880.0 |
| 2018-10-16 07:25:00 | AAPL | Stock | 54.6375 | 54.645 | 54.625 | 54.625 | 12960.0 |
| 2018-10-16 07:30:00 | AAPL | Stock | 54.625 | 54.6525 | 54.625 | 54.6525 | 25996.0 |
| 2018-10-16 07:35:00 | AAPL | Stock | 54.65 | 54.6625 | 54.6375 | 54.66 | 12824.0 |
| 2018-10-16 07:40:00 | AAPL | Stock | 54.6375 | 54.6475 | 54.6 | 54.6475 | 14548.0 |
| 2018-10-16 07:45:00 | AAPL | Stock | 54.6475 | 54.6575 | 54.64 | 54.6575 | 8680.0 |
| 2018-10-16 07:50:00 | AAPL | Stock | 54.6525 | 54.675 | 54.6375 | 54.6725 | 23792.0 |
| 2018-10-16 07:55:00 | AAPL | Stock | 54.67 | 54.6875 | 54.665 | 54.6875 | 24432.0 |
| 2018-10-16 08:00:00 | AAPL | Stock | 54.6 | 54.695 | 54.515 | 54.6675 | 98552.0 |
| 2018-10-16 08:05:00 | AAPL | Stock | 54.675 | 54.71 | 54.67 | 54.71 | 44320.0 |
| 2018-10-16 08:10:00 | AAPL | Stock | 54.7075 | 54.79 | 54.6825 | 54.79 | 62992.0 |
| 2018-10-16 08:15:00 | AAPL | Stock | 54.785 | 54.7875 | 54.7625 | 54.775 | 28520.0 |
| 2018-10-16 08:20:00 | AAPL | Stock | 54.7875 | 54.7875 | 54.7475 | 54.75 | 28144.0 |
| 2018-10-16 08:25:00 | AAPL | Stock | 54.75 | 54.7725 | 54.7375 | 54.7375 | 12632.0 |
| 2018-10-16 08:30:00 | AAPL | Stock | 54.7375 | 54.745 | 54.7225 | 54.7275 | 10400.0 |
| 2018-10-16 08:35:00 | AAPL | Stock | 54.7325 | 54.7875 | 54.7325 | 54.7825 | 18600.0 |
| 2018-10-16 08:40:00 | AAPL | Stock | 54.7825 | 54.7875 | 54.7625 | 54.77 | 27280.0 |
| 2018-10-16 08:45:00 | AAPL | Stock | 54.755 | 54.77 | 54.755 | 54.77 | 19860.0 |
| 2018-10-16 08:50:00 | AAPL | Stock | 54.795 | 54.815 | 54.7875 | 54.8 | 56724.0 |
| 2018-10-16 08:55:00 | AAPL | Stock | 54.7975 | 54.825 | 54.7875 | 54.7875 | 28412.0 |
| 2018-10-16 09:00:00 | AAPL | Stock | 54.795 | 54.805 | 54.7775 | 54.785 | 27624.0 |
| 2018-10-16 09:05:00 | AAPL | Stock | 54.77 | 54.81 | 54.7625 | 54.81 | 21360.0 |
| 2018-10-16 09:10:00 | AAPL | Stock | 54.81 | 54.8775 | 54.81 | 54.87 | 58444.0 |
| 2018-10-16 09:15:00 | AAPL | Stock | 54.8725 | 54.88 | 54.8225 | 54.83 | 64372.0 |
| 2018-10-16 09:20:00 | AAPL | Stock | 54.81 | 54.87 | 54.8 | 54.8375 | 30756.0 |
| 2018-10-16 09:25:00 | AAPL | Stock | 54.85 | 54.85 | 54.7 | 54.7225 | 97384.0 |
| 2018-10-16 09:30:00 | AAPL | Stock | 54.7425 | 54.825 | 54.5225 | 54.5425 | 4689712.0 |
| 2018-10-16 09:35:00 | AAPL | Stock | 54.5425 | 54.7362 | 54.45 | 54.7362 | 2442228.0 |
| 2018-10-16 09:40:00 | AAPL | Stock | 54.735 | 54.8 | 54.6075 | 54.705 | 2274504.0 |
| 2018-10-16 09:45:00 | AAPL | Stock | 54.7088 | 54.755 | 54.5025 | 54.59 | 1782248.0 |
| 2018-10-16 09:50:00 | AAPL | Stock | 54.5875 | 54.6075 | 54.4575 | 54.5125 | 1433348.0 |
| 2018-10-16 09:55:00 | AAPL | Stock | 54.5125 | 54.695 | 54.505 | 54.635 | 1480704.0 |
> showing 50 of 362,428 rows — these rows as CSV