PREVIEW / stock_5min / 2019-09-11
file: by_date/stock_5min/2019/2019-09-11.parquet size: 5.9 MB rows: 371,881 symbols: 2,565
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-09-11 04:00:00 | AAPL | Stock | 54.2975 | 54.4125 | 54.2625 | 54.4125 | 21816.0 |
| 2019-09-11 04:05:00 | AAPL | Stock | 54.415 | 54.415 | 54.3575 | 54.3575 | 800.0 |
| 2019-09-11 04:10:00 | AAPL | Stock | 54.3125 | 54.3475 | 54.27 | 54.27 | 3600.0 |
| 2019-09-11 04:15:00 | AAPL | Stock | 54.2625 | 54.2625 | 54.25 | 54.25 | 3324.0 |
| 2019-09-11 04:20:00 | AAPL | Stock | 54.25 | 54.25 | 54.25 | 54.25 | 800.0 |
| 2019-09-11 04:25:00 | AAPL | Stock | 54.25 | 54.25 | 54.25 | 54.25 | 400.0 |
| 2019-09-11 04:40:00 | AAPL | Stock | 54.295 | 54.3 | 54.295 | 54.3 | 5200.0 |
| 2019-09-11 04:45:00 | AAPL | Stock | 54.3425 | 54.3425 | 54.265 | 54.285 | 4380.0 |
| 2019-09-11 04:55:00 | AAPL | Stock | 54.2875 | 54.2875 | 54.2625 | 54.2625 | 1200.0 |
| 2019-09-11 05:00:00 | AAPL | Stock | 54.1925 | 54.1925 | 54.1325 | 54.1325 | 2344.0 |
| 2019-09-11 05:05:00 | AAPL | Stock | 54.1375 | 54.1375 | 54.1375 | 54.1375 | 400.0 |
| 2019-09-11 05:10:00 | AAPL | Stock | 54.1325 | 54.1325 | 54.1325 | 54.1325 | 1600.0 |
| 2019-09-11 05:15:00 | AAPL | Stock | 54.1525 | 54.1525 | 54.1525 | 54.1525 | 1600.0 |
| 2019-09-11 05:20:00 | AAPL | Stock | 54.1525 | 54.175 | 54.1525 | 54.175 | 2704.0 |
| 2019-09-11 05:30:00 | AAPL | Stock | 54.2 | 54.2 | 54.2 | 54.2 | 3860.0 |
| 2019-09-11 05:35:00 | AAPL | Stock | 54.2275 | 54.2275 | 54.2275 | 54.2275 | 400.0 |
| 2019-09-11 05:40:00 | AAPL | Stock | 54.205 | 54.205 | 54.205 | 54.205 | 2872.0 |
| 2019-09-11 05:45:00 | AAPL | Stock | 54.205 | 54.205 | 54.155 | 54.155 | 11728.0 |
| 2019-09-11 05:50:00 | AAPL | Stock | 54.195 | 54.2125 | 54.195 | 54.21 | 9416.0 |
| 2019-09-11 05:55:00 | AAPL | Stock | 54.2375 | 54.2475 | 54.235 | 54.2475 | 4184.0 |
| 2019-09-11 06:00:00 | AAPL | Stock | 54.22 | 54.22 | 54.205 | 54.205 | 1200.0 |
| 2019-09-11 06:15:00 | AAPL | Stock | 54.2125 | 54.215 | 54.2125 | 54.215 | 2400.0 |
| 2019-09-11 06:20:00 | AAPL | Stock | 54.2475 | 54.2875 | 54.2475 | 54.2875 | 2964.0 |
| 2019-09-11 06:35:00 | AAPL | Stock | 54.275 | 54.275 | 54.275 | 54.275 | 1928.0 |
| 2019-09-11 06:55:00 | AAPL | Stock | 54.225 | 54.225 | 54.21 | 54.21 | 6560.0 |
| 2019-09-11 07:00:00 | AAPL | Stock | 54.25 | 54.3 | 54.21 | 54.275 | 28164.0 |
| 2019-09-11 07:05:00 | AAPL | Stock | 54.275 | 54.3 | 54.275 | 54.285 | 27560.0 |
| 2019-09-11 07:10:00 | AAPL | Stock | 54.29 | 54.2925 | 54.275 | 54.2875 | 3736.0 |
| 2019-09-11 07:15:00 | AAPL | Stock | 54.2875 | 54.2875 | 54.2625 | 54.2625 | 7760.0 |
| 2019-09-11 07:20:00 | AAPL | Stock | 54.2625 | 54.2975 | 54.2625 | 54.295 | 20012.0 |
| 2019-09-11 07:25:00 | AAPL | Stock | 54.2975 | 54.3375 | 54.295 | 54.335 | 38052.0 |
| 2019-09-11 07:30:00 | AAPL | Stock | 54.325 | 54.35 | 54.3 | 54.3 | 31908.0 |
| 2019-09-11 07:35:00 | AAPL | Stock | 54.3025 | 54.33 | 54.3 | 54.3225 | 31136.0 |
| 2019-09-11 07:40:00 | AAPL | Stock | 54.2925 | 54.3375 | 54.2925 | 54.325 | 34204.0 |
| 2019-09-11 07:45:00 | AAPL | Stock | 54.3225 | 54.3575 | 54.3125 | 54.3125 | 55920.0 |
| 2019-09-11 07:50:00 | AAPL | Stock | 54.3125 | 54.3275 | 54.2875 | 54.325 | 37788.0 |
| 2019-09-11 07:55:00 | AAPL | Stock | 54.325 | 54.37 | 54.325 | 54.35 | 33592.0 |
| 2019-09-11 08:00:00 | AAPL | Stock | 54.35 | 54.3725 | 54.2275 | 54.35 | 193516.0 |
| 2019-09-11 08:05:00 | AAPL | Stock | 54.35 | 54.3582 | 54.3255 | 54.3255 | 28080.0 |
| 2019-09-11 08:10:00 | AAPL | Stock | 54.35 | 54.3625 | 54.3375 | 54.3625 | 48112.0 |
| 2019-09-11 08:15:00 | AAPL | Stock | 54.35 | 54.3975 | 54.35 | 54.375 | 93256.0 |
| 2019-09-11 08:20:00 | AAPL | Stock | 54.3775 | 54.4125 | 54.375 | 54.4125 | 34204.0 |
| 2019-09-11 08:25:00 | AAPL | Stock | 54.41 | 54.41 | 54.375 | 54.3975 | 18304.0 |
| 2019-09-11 08:30:00 | AAPL | Stock | 54.41 | 54.41 | 54.3675 | 54.395 | 52048.0 |
| 2019-09-11 08:35:00 | AAPL | Stock | 54.375 | 54.4025 | 54.375 | 54.3875 | 16784.0 |
| 2019-09-11 08:40:00 | AAPL | Stock | 54.38 | 54.4 | 54.375 | 54.4 | 17656.0 |
| 2019-09-11 08:45:00 | AAPL | Stock | 54.3825 | 54.395 | 54.375 | 54.3775 | 32660.0 |
| 2019-09-11 08:50:00 | AAPL | Stock | 54.375 | 54.4375 | 54.375 | 54.425 | 90912.0 |
| 2019-09-11 08:55:00 | AAPL | Stock | 54.4075 | 54.4425 | 54.4075 | 54.425 | 55524.0 |
| 2019-09-11 09:00:00 | AAPL | Stock | 54.425 | 54.49 | 54.4125 | 54.4575 | 96180.0 |
> showing 50 of 371,881 rows — these rows as CSV