PREVIEW / stock_5min / 2019-05-10
file: by_date/stock_5min/2019/2019-05-10.parquet size: 5.7 MB rows: 353,405 symbols: 2,604
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-10 04:00:00 | AAPL | Stock | 49.9825 | 49.9825 | 49.745 | 49.8375 | 36072.0 |
| 2019-05-10 04:05:00 | AAPL | Stock | 49.8125 | 49.85 | 49.8125 | 49.8475 | 2068.0 |
| 2019-05-10 04:10:00 | AAPL | Stock | 49.8375 | 49.8375 | 49.7875 | 49.7875 | 3912.0 |
| 2019-05-10 04:25:00 | AAPL | Stock | 49.8625 | 49.9 | 49.8625 | 49.9 | 2400.0 |
| 2019-05-10 04:50:00 | AAPL | Stock | 49.905 | 49.905 | 49.905 | 49.905 | 8748.0 |
| 2019-05-10 04:55:00 | AAPL | Stock | 49.875 | 49.875 | 49.84 | 49.845 | 5500.0 |
| 2019-05-10 05:10:00 | AAPL | Stock | 49.9475 | 49.9725 | 49.9475 | 49.9725 | 3848.0 |
| 2019-05-10 05:15:00 | AAPL | Stock | 49.9725 | 49.9725 | 49.9525 | 49.9525 | 1448.0 |
| 2019-05-10 05:20:00 | AAPL | Stock | 50.0025 | 50.0025 | 50.0025 | 50.0025 | 400.0 |
| 2019-05-10 05:25:00 | AAPL | Stock | 50.0775 | 50.1 | 50.0775 | 50.1 | 1800.0 |
| 2019-05-10 05:30:00 | AAPL | Stock | 50.1 | 50.15 | 50.1 | 50.1 | 8004.0 |
| 2019-05-10 05:35:00 | AAPL | Stock | 50.145 | 50.15 | 50.145 | 50.15 | 7264.0 |
| 2019-05-10 05:45:00 | AAPL | Stock | 50.0625 | 50.0625 | 50.0625 | 50.0625 | 800.0 |
| 2019-05-10 05:50:00 | AAPL | Stock | 50.0 | 50.0 | 49.96 | 49.96 | 1200.0 |
| 2019-05-10 05:55:00 | AAPL | Stock | 49.9625 | 49.9625 | 49.9525 | 49.9525 | 1600.0 |
| 2019-05-10 06:05:00 | AAPL | Stock | 50.0025 | 50.0025 | 50.0025 | 50.0025 | 400.0 |
| 2019-05-10 06:10:00 | AAPL | Stock | 50.0 | 50.0 | 50.0 | 50.0 | 400.0 |
| 2019-05-10 06:15:00 | AAPL | Stock | 49.9625 | 49.9625 | 49.9625 | 49.9625 | 400.0 |
| 2019-05-10 06:35:00 | AAPL | Stock | 50.0025 | 50.0875 | 50.0 | 50.0875 | 4132.0 |
| 2019-05-10 06:40:00 | AAPL | Stock | 50.175 | 50.175 | 50.0625 | 50.0625 | 4400.0 |
| 2019-05-10 06:45:00 | AAPL | Stock | 50.07 | 50.07 | 50.07 | 50.07 | 1000.0 |
| 2019-05-10 06:50:00 | AAPL | Stock | 50.025 | 50.0725 | 49.85 | 49.85 | 9772.0 |
| 2019-05-10 06:55:00 | AAPL | Stock | 49.9625 | 49.985 | 49.73 | 49.73 | 42800.0 |
| 2019-05-10 07:00:00 | AAPL | Stock | 49.7675 | 49.81 | 49.7225 | 49.81 | 24464.0 |
| 2019-05-10 07:05:00 | AAPL | Stock | 49.81 | 49.875 | 49.81 | 49.8625 | 7024.0 |
| 2019-05-10 07:10:00 | AAPL | Stock | 49.8925 | 49.8925 | 49.7675 | 49.855 | 24644.0 |
| 2019-05-10 07:15:00 | AAPL | Stock | 49.825 | 49.845 | 49.825 | 49.825 | 2080.0 |
| 2019-05-10 07:20:00 | AAPL | Stock | 49.8375 | 49.85 | 49.7875 | 49.7875 | 44072.0 |
| 2019-05-10 07:25:00 | AAPL | Stock | 49.7525 | 49.7925 | 49.7 | 49.7 | 18888.0 |
| 2019-05-10 07:30:00 | AAPL | Stock | 49.725 | 49.735 | 49.695 | 49.7125 | 11656.0 |
| 2019-05-10 07:35:00 | AAPL | Stock | 49.6975 | 49.725 | 49.6975 | 49.725 | 5592.0 |
| 2019-05-10 07:40:00 | AAPL | Stock | 49.7 | 49.735 | 49.6975 | 49.7075 | 23964.0 |
| 2019-05-10 07:45:00 | AAPL | Stock | 49.7 | 49.735 | 49.6825 | 49.6975 | 18024.0 |
| 2019-05-10 07:50:00 | AAPL | Stock | 49.7 | 49.745 | 49.6 | 49.6 | 48120.0 |
| 2019-05-10 07:55:00 | AAPL | Stock | 49.6225 | 49.635 | 49.5825 | 49.6 | 19992.0 |
| 2019-05-10 08:00:00 | AAPL | Stock | 49.725 | 49.8975 | 49.4975 | 49.5175 | 219144.0 |
| 2019-05-10 08:05:00 | AAPL | Stock | 49.505 | 49.5175 | 49.4375 | 49.45 | 24764.0 |
| 2019-05-10 08:10:00 | AAPL | Stock | 49.45 | 49.46 | 49.3925 | 49.45 | 190632.0 |
| 2019-05-10 08:15:00 | AAPL | Stock | 49.4475 | 49.45 | 49.3875 | 49.4275 | 47492.0 |
| 2019-05-10 08:20:00 | AAPL | Stock | 49.4175 | 49.4675 | 49.3925 | 49.4375 | 179404.0 |
| 2019-05-10 08:25:00 | AAPL | Stock | 49.4325 | 49.46 | 49.375 | 49.4 | 87068.0 |
| 2019-05-10 08:30:00 | AAPL | Stock | 49.425 | 49.4525 | 49.27 | 49.3325 | 78572.0 |
| 2019-05-10 08:35:00 | AAPL | Stock | 49.3375 | 49.395 | 49.305 | 49.39 | 90684.0 |
| 2019-05-10 08:40:00 | AAPL | Stock | 49.3575 | 49.3625 | 49.3125 | 49.3255 | 46600.0 |
| 2019-05-10 08:45:00 | AAPL | Stock | 49.3252 | 49.385 | 49.3175 | 49.385 | 35684.0 |
| 2019-05-10 08:50:00 | AAPL | Stock | 49.385 | 49.395 | 49.3125 | 49.3125 | 44864.0 |
| 2019-05-10 08:55:00 | AAPL | Stock | 49.3475 | 49.3825 | 49.3125 | 49.3475 | 70724.0 |
| 2019-05-10 09:00:00 | AAPL | Stock | 49.3475 | 49.4675 | 49.335 | 49.4575 | 65412.0 |
| 2019-05-10 09:05:00 | AAPL | Stock | 49.45 | 49.5225 | 49.4252 | 49.5 | 94612.0 |
| 2019-05-10 09:10:00 | AAPL | Stock | 49.5 | 49.51 | 49.4125 | 49.4375 | 55344.0 |
> showing 50 of 353,405 rows — these rows as CSV