PREVIEW / stock_5min / 2019-05-21
file: by_date/stock_5min/2019/2019-05-21.parquet size: 5.6 MB rows: 353,372 symbols: 2,594
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-21 04:35:00 | AAPL | Stock | 46.05 | 46.05 | 46.0 | 46.0 | 1600.0 |
| 2019-05-21 04:40:00 | AAPL | Stock | 46.0 | 46.0 | 45.9525 | 45.9525 | 10164.0 |
| 2019-05-21 05:00:00 | AAPL | Stock | 45.995 | 46.0125 | 45.9925 | 46.0 | 3200.0 |
| 2019-05-21 05:05:00 | AAPL | Stock | 45.955 | 45.97 | 45.94 | 45.9675 | 7564.0 |
| 2019-05-21 05:10:00 | AAPL | Stock | 45.955 | 45.955 | 45.955 | 45.955 | 756.0 |
| 2019-05-21 05:15:00 | AAPL | Stock | 45.9625 | 46.165 | 45.9425 | 46.165 | 20416.0 |
| 2019-05-21 05:20:00 | AAPL | Stock | 46.14 | 46.14 | 46.14 | 46.14 | 1200.0 |
| 2019-05-21 05:25:00 | AAPL | Stock | 46.14 | 46.14 | 46.0875 | 46.0875 | 3104.0 |
| 2019-05-21 05:30:00 | AAPL | Stock | 46.1875 | 46.1875 | 46.1875 | 46.1875 | 800.0 |
| 2019-05-21 05:40:00 | AAPL | Stock | 46.1675 | 46.225 | 46.125 | 46.225 | 12888.0 |
| 2019-05-21 05:50:00 | AAPL | Stock | 46.225 | 46.2375 | 46.225 | 46.2375 | 3876.0 |
| 2019-05-21 05:55:00 | AAPL | Stock | 46.25 | 46.3 | 46.25 | 46.3 | 10160.0 |
| 2019-05-21 06:00:00 | AAPL | Stock | 46.35 | 46.375 | 46.35 | 46.375 | 4400.0 |
| 2019-05-21 06:10:00 | AAPL | Stock | 46.425 | 46.425 | 46.3275 | 46.3275 | 13752.0 |
| 2019-05-21 06:15:00 | AAPL | Stock | 46.36 | 46.36 | 46.36 | 46.36 | 460.0 |
| 2019-05-21 06:20:00 | AAPL | Stock | 46.375 | 46.3925 | 46.365 | 46.3925 | 6000.0 |
| 2019-05-21 06:25:00 | AAPL | Stock | 46.3925 | 46.3925 | 46.3925 | 46.3925 | 400.0 |
| 2019-05-21 06:30:00 | AAPL | Stock | 46.3825 | 46.3975 | 46.3775 | 46.38 | 5988.0 |
| 2019-05-21 06:35:00 | AAPL | Stock | 46.3925 | 46.3925 | 46.3925 | 46.3925 | 9236.0 |
| 2019-05-21 06:40:00 | AAPL | Stock | 46.3925 | 46.465 | 46.3925 | 46.465 | 8076.0 |
| 2019-05-21 06:45:00 | AAPL | Stock | 46.45 | 46.45 | 46.375 | 46.3875 | 3320.0 |
| 2019-05-21 06:50:00 | AAPL | Stock | 46.39 | 46.4 | 46.3875 | 46.3875 | 11816.0 |
| 2019-05-21 07:00:00 | AAPL | Stock | 46.405 | 46.41 | 46.28 | 46.28 | 37672.0 |
| 2019-05-21 07:05:00 | AAPL | Stock | 46.28 | 46.3325 | 46.275 | 46.325 | 10416.0 |
| 2019-05-21 07:10:00 | AAPL | Stock | 46.3225 | 46.325 | 46.225 | 46.245 | 15676.0 |
| 2019-05-21 07:15:00 | AAPL | Stock | 46.25 | 46.28 | 46.2125 | 46.28 | 24440.0 |
| 2019-05-21 07:20:00 | AAPL | Stock | 46.28 | 46.28 | 46.185 | 46.185 | 25536.0 |
| 2019-05-21 07:25:00 | AAPL | Stock | 46.185 | 46.2025 | 46.0875 | 46.13 | 37788.0 |
| 2019-05-21 07:30:00 | AAPL | Stock | 46.0875 | 46.14 | 46.0875 | 46.105 | 9168.0 |
| 2019-05-21 07:35:00 | AAPL | Stock | 46.135 | 46.185 | 46.135 | 46.17 | 14964.0 |
| 2019-05-21 07:40:00 | AAPL | Stock | 46.1675 | 46.1675 | 46.155 | 46.155 | 4400.0 |
| 2019-05-21 07:45:00 | AAPL | Stock | 46.16 | 46.1625 | 46.0975 | 46.16 | 21660.0 |
| 2019-05-21 07:50:00 | AAPL | Stock | 46.175 | 46.175 | 46.14 | 46.14 | 12892.0 |
| 2019-05-21 07:55:00 | AAPL | Stock | 46.165 | 46.2 | 46.15 | 46.2 | 5532.0 |
| 2019-05-21 08:00:00 | AAPL | Stock | 46.2125 | 46.425 | 46.085 | 46.25 | 190020.0 |
| 2019-05-21 08:05:00 | AAPL | Stock | 46.25 | 46.25 | 46.205 | 46.225 | 22104.0 |
| 2019-05-21 08:10:00 | AAPL | Stock | 46.215 | 46.215 | 46.095 | 46.15 | 25116.0 |
| 2019-05-21 08:15:00 | AAPL | Stock | 46.2225 | 46.2225 | 46.1325 | 46.1425 | 25360.0 |
| 2019-05-21 08:20:00 | AAPL | Stock | 46.1925 | 46.21 | 46.1522 | 46.18 | 20284.0 |
| 2019-05-21 08:25:00 | AAPL | Stock | 46.18 | 46.2625 | 46.1675 | 46.22 | 48772.0 |
| 2019-05-21 08:30:00 | AAPL | Stock | 46.2425 | 46.3125 | 46.19 | 46.2875 | 62648.0 |
| 2019-05-21 08:35:00 | AAPL | Stock | 46.2925 | 46.3425 | 46.2925 | 46.3425 | 17964.0 |
| 2019-05-21 08:40:00 | AAPL | Stock | 46.3325 | 46.3625 | 46.3 | 46.3075 | 38400.0 |
| 2019-05-21 08:45:00 | AAPL | Stock | 46.275 | 46.33 | 46.275 | 46.3 | 28328.0 |
| 2019-05-21 08:50:00 | AAPL | Stock | 46.3 | 46.33 | 46.275 | 46.3 | 30904.0 |
| 2019-05-21 08:55:00 | AAPL | Stock | 46.3 | 46.3725 | 46.285 | 46.355 | 70876.0 |
| 2019-05-21 09:00:00 | AAPL | Stock | 46.34 | 46.3875 | 46.3225 | 46.345 | 76392.0 |
| 2019-05-21 09:05:00 | AAPL | Stock | 46.335 | 46.335 | 46.275 | 46.3125 | 128668.0 |
| 2019-05-21 09:10:00 | AAPL | Stock | 46.2925 | 46.35 | 46.285 | 46.3375 | 43216.0 |
| 2019-05-21 09:15:00 | AAPL | Stock | 46.3375 | 46.345 | 46.317 | 46.3375 | 32532.0 |
> showing 50 of 353,372 rows — these rows as CSV