PREVIEW / stock_5min / 2019-05-13
file: by_date/stock_5min/2019/2019-05-13.parquet size: 5.8 MB rows: 363,772 symbols: 2,620
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-13 04:00:00 | AAPL | Stock | 48.25 | 48.3 | 48.14 | 48.2 | 3792.0 |
| 2019-05-13 04:05:00 | AAPL | Stock | 48.1275 | 48.2 | 48.1075 | 48.1975 | 2020.0 |
| 2019-05-13 04:10:00 | AAPL | Stock | 48.18 | 48.18 | 48.18 | 48.18 | 400.0 |
| 2019-05-13 04:15:00 | AAPL | Stock | 48.2 | 48.245 | 48.2 | 48.2 | 2384.0 |
| 2019-05-13 04:20:00 | AAPL | Stock | 48.25 | 48.3175 | 48.25 | 48.25 | 17164.0 |
| 2019-05-13 04:25:00 | AAPL | Stock | 48.2775 | 48.2775 | 48.25 | 48.25 | 5384.0 |
| 2019-05-13 04:30:00 | AAPL | Stock | 48.25 | 48.2775 | 48.25 | 48.2775 | 3316.0 |
| 2019-05-13 04:40:00 | AAPL | Stock | 48.3275 | 48.3275 | 48.325 | 48.325 | 800.0 |
| 2019-05-13 04:45:00 | AAPL | Stock | 48.3375 | 48.3375 | 48.3375 | 48.3375 | 800.0 |
| 2019-05-13 04:50:00 | AAPL | Stock | 48.2725 | 48.2725 | 48.25 | 48.25 | 2116.0 |
| 2019-05-13 04:55:00 | AAPL | Stock | 48.2425 | 48.2425 | 48.2 | 48.2 | 2420.0 |
| 2019-05-13 05:00:00 | AAPL | Stock | 48.3325 | 48.3375 | 48.3325 | 48.3375 | 1064.0 |
| 2019-05-13 05:05:00 | AAPL | Stock | 48.335 | 48.335 | 48.2875 | 48.2875 | 1600.0 |
| 2019-05-13 05:10:00 | AAPL | Stock | 48.2625 | 48.2625 | 48.25 | 48.25 | 800.0 |
| 2019-05-13 05:15:00 | AAPL | Stock | 48.25 | 48.25 | 48.25 | 48.25 | 400.0 |
| 2019-05-13 05:25:00 | AAPL | Stock | 48.21 | 48.2475 | 48.205 | 48.2475 | 2976.0 |
| 2019-05-13 05:45:00 | AAPL | Stock | 48.25 | 48.275 | 48.25 | 48.275 | 23440.0 |
| 2019-05-13 05:50:00 | AAPL | Stock | 48.2675 | 48.2675 | 48.2675 | 48.2675 | 936.0 |
| 2019-05-13 06:00:00 | AAPL | Stock | 48.2875 | 48.2875 | 48.2875 | 48.2875 | 400.0 |
| 2019-05-13 06:10:00 | AAPL | Stock | 48.3125 | 48.3125 | 48.3125 | 48.3125 | 400.0 |
| 2019-05-13 06:15:00 | AAPL | Stock | 48.3 | 48.3 | 48.2 | 48.2 | 15368.0 |
| 2019-05-13 06:25:00 | AAPL | Stock | 48.1625 | 48.1625 | 48.15 | 48.16 | 7276.0 |
| 2019-05-13 06:30:00 | AAPL | Stock | 48.2125 | 48.2125 | 48.15 | 48.1625 | 8936.0 |
| 2019-05-13 06:35:00 | AAPL | Stock | 48.21 | 48.21 | 48.21 | 48.21 | 400.0 |
| 2019-05-13 06:40:00 | AAPL | Stock | 48.1875 | 48.245 | 48.12 | 48.2025 | 16852.0 |
| 2019-05-13 06:45:00 | AAPL | Stock | 48.115 | 48.185 | 48.115 | 48.185 | 2404.0 |
| 2019-05-13 06:50:00 | AAPL | Stock | 48.1525 | 48.2125 | 48.1525 | 48.2125 | 4792.0 |
| 2019-05-13 06:55:00 | AAPL | Stock | 48.21 | 48.2125 | 48.21 | 48.2125 | 800.0 |
| 2019-05-13 07:00:00 | AAPL | Stock | 48.24 | 48.2975 | 48.1625 | 48.175 | 39208.0 |
| 2019-05-13 07:05:00 | AAPL | Stock | 48.165 | 48.1875 | 48.125 | 48.125 | 21292.0 |
| 2019-05-13 07:10:00 | AAPL | Stock | 48.1275 | 48.1275 | 48.115 | 48.125 | 24612.0 |
| 2019-05-13 07:15:00 | AAPL | Stock | 48.115 | 48.115 | 48.035 | 48.05 | 49068.0 |
| 2019-05-13 07:20:00 | AAPL | Stock | 48.0675 | 48.08 | 48.0625 | 48.0625 | 4840.0 |
| 2019-05-13 07:25:00 | AAPL | Stock | 48.085 | 48.0925 | 48.025 | 48.04 | 23580.0 |
| 2019-05-13 07:30:00 | AAPL | Stock | 48.05 | 48.1125 | 48.05 | 48.1 | 13092.0 |
| 2019-05-13 07:35:00 | AAPL | Stock | 48.0875 | 48.0875 | 48.0325 | 48.0625 | 31236.0 |
| 2019-05-13 07:40:00 | AAPL | Stock | 48.0675 | 48.12 | 48.0675 | 48.1 | 7068.0 |
| 2019-05-13 07:45:00 | AAPL | Stock | 48.07 | 48.09 | 47.95 | 47.95 | 58880.0 |
| 2019-05-13 07:50:00 | AAPL | Stock | 47.95 | 47.98 | 47.875 | 47.9 | 47356.0 |
| 2019-05-13 07:55:00 | AAPL | Stock | 47.9 | 47.925 | 47.8925 | 47.8925 | 22592.0 |
| 2019-05-13 08:00:00 | AAPL | Stock | 48.165 | 48.2525 | 47.8775 | 47.9375 | 256916.0 |
| 2019-05-13 08:05:00 | AAPL | Stock | 47.95 | 47.99 | 47.675 | 47.6758 | 166924.0 |
| 2019-05-13 08:10:00 | AAPL | Stock | 47.71 | 47.805 | 47.6475 | 47.65 | 374184.0 |
| 2019-05-13 08:15:00 | AAPL | Stock | 47.6425 | 47.6575 | 47.5 | 47.5 | 398360.0 |
| 2019-05-13 08:20:00 | AAPL | Stock | 47.5 | 47.5825 | 47.4675 | 47.5 | 190864.0 |
| 2019-05-13 08:25:00 | AAPL | Stock | 47.54 | 47.5975 | 47.4675 | 47.4675 | 232652.0 |
| 2019-05-13 08:30:00 | AAPL | Stock | 47.4875 | 47.49 | 47.375 | 47.375 | 196420.0 |
| 2019-05-13 08:35:00 | AAPL | Stock | 47.375 | 47.475 | 47.35 | 47.4625 | 142472.0 |
| 2019-05-13 08:40:00 | AAPL | Stock | 47.4525 | 47.4715 | 47.38 | 47.45 | 117632.0 |
| 2019-05-13 08:45:00 | AAPL | Stock | 47.43 | 47.47 | 47.4035 | 47.4125 | 65036.0 |
> showing 50 of 363,772 rows — these rows as CSV