PREVIEW / stock_5min / 2019-11-01
file: by_date/stock_5min/2019/2019-11-01.parquet size: 5.7 MB rows: 356,785 symbols: 2,485
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-11-01 04:00:00 | AAPL | Stock | 62.3575 | 62.375 | 62.3575 | 62.375 | 3612.0 |
| 2019-11-01 04:05:00 | AAPL | Stock | 62.3725 | 62.375 | 62.3725 | 62.375 | 3532.0 |
| 2019-11-01 04:15:00 | AAPL | Stock | 62.4 | 62.4 | 62.4 | 62.4 | 1940.0 |
| 2019-11-01 04:20:00 | AAPL | Stock | 62.3825 | 62.3825 | 62.255 | 62.255 | 1276.0 |
| 2019-11-01 04:25:00 | AAPL | Stock | 62.25 | 62.25 | 62.25 | 62.25 | 1488.0 |
| 2019-11-01 04:30:00 | AAPL | Stock | 62.255 | 62.255 | 62.25 | 62.25 | 6436.0 |
| 2019-11-01 04:35:00 | AAPL | Stock | 62.2475 | 62.25 | 62.2475 | 62.25 | 1780.0 |
| 2019-11-01 04:45:00 | AAPL | Stock | 62.2525 | 62.2925 | 62.2525 | 62.2925 | 5668.0 |
| 2019-11-01 04:50:00 | AAPL | Stock | 62.2925 | 62.2925 | 62.2925 | 62.2925 | 800.0 |
| 2019-11-01 04:55:00 | AAPL | Stock | 62.3625 | 62.3625 | 62.3625 | 62.3625 | 440.0 |
| 2019-11-01 05:00:00 | AAPL | Stock | 62.3625 | 62.3625 | 62.3625 | 62.3625 | 400.0 |
| 2019-11-01 05:40:00 | AAPL | Stock | 62.3475 | 62.35 | 62.3475 | 62.35 | 3956.0 |
| 2019-11-01 05:45:00 | AAPL | Stock | 62.35 | 62.35 | 62.35 | 62.35 | 1596.0 |
| 2019-11-01 06:20:00 | AAPL | Stock | 62.345 | 62.345 | 62.345 | 62.345 | 5840.0 |
| 2019-11-01 06:45:00 | AAPL | Stock | 62.3225 | 62.3225 | 62.3225 | 62.3225 | 800.0 |
| 2019-11-01 06:55:00 | AAPL | Stock | 62.3425 | 62.3425 | 62.3425 | 62.3425 | 400.0 |
| 2019-11-01 07:00:00 | AAPL | Stock | 62.3325 | 62.35 | 62.32 | 62.3275 | 12128.0 |
| 2019-11-01 07:05:00 | AAPL | Stock | 62.32 | 62.32 | 62.3075 | 62.3075 | 8544.0 |
| 2019-11-01 07:15:00 | AAPL | Stock | 62.32 | 62.325 | 62.2925 | 62.2925 | 9676.0 |
| 2019-11-01 07:20:00 | AAPL | Stock | 62.295 | 62.295 | 62.275 | 62.28 | 1200.0 |
| 2019-11-01 07:25:00 | AAPL | Stock | 62.275 | 62.2775 | 62.2725 | 62.275 | 4000.0 |
| 2019-11-01 07:30:00 | AAPL | Stock | 62.275 | 62.275 | 62.275 | 62.275 | 5804.0 |
| 2019-11-01 07:35:00 | AAPL | Stock | 62.275 | 62.2875 | 62.26 | 62.28 | 5120.0 |
| 2019-11-01 07:40:00 | AAPL | Stock | 62.275 | 62.295 | 62.275 | 62.295 | 17524.0 |
| 2019-11-01 07:45:00 | AAPL | Stock | 62.295 | 62.295 | 62.275 | 62.275 | 2000.0 |
| 2019-11-01 07:50:00 | AAPL | Stock | 62.275 | 62.275 | 62.2 | 62.2225 | 32308.0 |
| 2019-11-01 07:55:00 | AAPL | Stock | 62.2 | 62.2 | 62.15 | 62.15 | 39460.0 |
| 2019-11-01 08:00:00 | AAPL | Stock | 62.33 | 62.35 | 62.15 | 62.165 | 167360.0 |
| 2019-11-01 08:05:00 | AAPL | Stock | 62.19 | 62.1925 | 62.175 | 62.1925 | 26868.0 |
| 2019-11-01 08:10:00 | AAPL | Stock | 62.1925 | 62.2175 | 62.1875 | 62.1975 | 23772.0 |
| 2019-11-01 08:15:00 | AAPL | Stock | 62.1975 | 62.2075 | 62.1875 | 62.2025 | 8352.0 |
| 2019-11-01 08:20:00 | AAPL | Stock | 62.2025 | 62.225 | 62.2025 | 62.225 | 12396.0 |
| 2019-11-01 08:25:00 | AAPL | Stock | 62.21 | 62.225 | 62.19 | 62.225 | 10164.0 |
| 2019-11-01 08:30:00 | AAPL | Stock | 62.235 | 62.4125 | 62.235 | 62.375 | 228448.0 |
| 2019-11-01 08:35:00 | AAPL | Stock | 62.3875 | 62.4275 | 62.375 | 62.4225 | 80648.0 |
| 2019-11-01 08:40:00 | AAPL | Stock | 62.4 | 62.425 | 62.3375 | 62.3975 | 41004.0 |
| 2019-11-01 08:45:00 | AAPL | Stock | 62.4125 | 62.4125 | 62.375 | 62.3875 | 26688.0 |
| 2019-11-01 08:50:00 | AAPL | Stock | 62.375 | 62.3875 | 62.34 | 62.34 | 31268.0 |
| 2019-11-01 08:55:00 | AAPL | Stock | 62.3475 | 62.3875 | 62.3475 | 62.375 | 29224.0 |
| 2019-11-01 09:00:00 | AAPL | Stock | 62.38 | 62.4375 | 62.38 | 62.425 | 103332.0 |
| 2019-11-01 09:05:00 | AAPL | Stock | 62.4275 | 62.4475 | 62.3938 | 62.41 | 43748.0 |
| 2019-11-01 09:10:00 | AAPL | Stock | 62.4 | 62.4375 | 62.38 | 62.4 | 46436.0 |
| 2019-11-01 09:15:00 | AAPL | Stock | 62.4 | 62.425 | 62.3725 | 62.3875 | 53272.0 |
| 2019-11-01 09:20:00 | AAPL | Stock | 62.4 | 62.4375 | 62.3875 | 62.4325 | 46804.0 |
| 2019-11-01 09:25:00 | AAPL | Stock | 62.43 | 62.4375 | 62.3225 | 62.4 | 123716.0 |
| 2019-11-01 09:30:00 | AAPL | Stock | 62.385 | 62.72 | 62.29 | 62.682 | 8759220.0 |
| 2019-11-01 09:35:00 | AAPL | Stock | 62.68 | 62.715 | 62.4325 | 62.645 | 2887620.0 |
| 2019-11-01 09:40:00 | AAPL | Stock | 62.65 | 62.7425 | 62.565 | 62.7275 | 2375652.0 |
| 2019-11-01 09:45:00 | AAPL | Stock | 62.72 | 62.815 | 62.675 | 62.7162 | 3796264.0 |
| 2019-11-01 09:50:00 | AAPL | Stock | 62.7162 | 62.8575 | 62.7162 | 62.846 | 1865092.0 |
> showing 50 of 356,785 rows — these rows as CSV