PREVIEW / stock_5min / 2020-05-12
file: by_date/stock_5min/2020/2020-05-12.parquet size: 6.5 MB rows: 409,703 symbols: 2,373
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-12 04:00:00 | AAPL | Stock | 78.8025 | 78.8025 | 78.65 | 78.65 | 4624.0 |
| 2020-05-12 04:05:00 | AAPL | Stock | 78.64 | 78.645 | 78.56 | 78.56 | 1920.0 |
| 2020-05-12 04:10:00 | AAPL | Stock | 78.57 | 78.575 | 78.57 | 78.575 | 1200.0 |
| 2020-05-12 04:15:00 | AAPL | Stock | 78.65 | 78.675 | 78.65 | 78.675 | 10780.0 |
| 2020-05-12 04:50:00 | AAPL | Stock | 78.63 | 78.63 | 78.63 | 78.63 | 400.0 |
| 2020-05-12 05:00:00 | AAPL | Stock | 78.6 | 78.6 | 78.5025 | 78.5025 | 4800.0 |
| 2020-05-12 05:25:00 | AAPL | Stock | 78.6 | 78.65 | 78.6 | 78.65 | 1544.0 |
| 2020-05-12 05:40:00 | AAPL | Stock | 78.6 | 78.6 | 78.5875 | 78.5875 | 6804.0 |
| 2020-05-12 05:45:00 | AAPL | Stock | 78.535 | 78.535 | 78.535 | 78.535 | 532.0 |
| 2020-05-12 05:50:00 | AAPL | Stock | 78.75 | 78.75 | 78.75 | 78.75 | 468.0 |
| 2020-05-12 05:55:00 | AAPL | Stock | 78.75 | 78.75 | 78.7175 | 78.7175 | 2736.0 |
| 2020-05-12 06:05:00 | AAPL | Stock | 78.7475 | 78.75 | 78.7475 | 78.75 | 2800.0 |
| 2020-05-12 06:10:00 | AAPL | Stock | 78.75 | 78.8225 | 78.75 | 78.8225 | 10000.0 |
| 2020-05-12 06:20:00 | AAPL | Stock | 78.8875 | 78.925 | 78.8875 | 78.925 | 1988.0 |
| 2020-05-12 06:25:00 | AAPL | Stock | 78.9225 | 78.9225 | 78.9225 | 78.9225 | 400.0 |
| 2020-05-12 06:35:00 | AAPL | Stock | 78.9575 | 79.0125 | 78.9575 | 79.0125 | 4936.0 |
| 2020-05-12 06:40:00 | AAPL | Stock | 79.0125 | 79.0375 | 78.9525 | 78.9525 | 10704.0 |
| 2020-05-12 06:45:00 | AAPL | Stock | 78.93 | 78.93 | 78.93 | 78.93 | 440.0 |
| 2020-05-12 06:50:00 | AAPL | Stock | 78.9 | 78.9 | 78.9 | 78.9 | 1436.0 |
| 2020-05-12 07:00:00 | AAPL | Stock | 78.995 | 79.1625 | 78.995 | 79.1475 | 84912.0 |
| 2020-05-12 07:05:00 | AAPL | Stock | 79.1825 | 79.34 | 79.1825 | 79.325 | 83812.0 |
| 2020-05-12 07:10:00 | AAPL | Stock | 79.325 | 79.34 | 79.275 | 79.2775 | 27196.0 |
| 2020-05-12 07:15:00 | AAPL | Stock | 79.3 | 79.3625 | 79.3 | 79.3475 | 32708.0 |
| 2020-05-12 07:20:00 | AAPL | Stock | 79.34 | 79.4475 | 79.3375 | 79.445 | 62568.0 |
| 2020-05-12 07:25:00 | AAPL | Stock | 79.455 | 79.4875 | 79.4275 | 79.4875 | 63992.0 |
| 2020-05-12 07:30:00 | AAPL | Stock | 79.485 | 79.4975 | 79.405 | 79.44 | 46352.0 |
| 2020-05-12 07:35:00 | AAPL | Stock | 79.4325 | 79.4475 | 79.375 | 79.375 | 12068.0 |
| 2020-05-12 07:40:00 | AAPL | Stock | 79.35 | 79.35 | 79.27 | 79.27 | 23340.0 |
| 2020-05-12 07:45:00 | AAPL | Stock | 79.325 | 79.4 | 79.2825 | 79.35 | 13376.0 |
| 2020-05-12 07:50:00 | AAPL | Stock | 79.3425 | 79.42 | 79.3425 | 79.3475 | 8420.0 |
| 2020-05-12 07:55:00 | AAPL | Stock | 79.375 | 79.375 | 79.3 | 79.3725 | 36204.0 |
| 2020-05-12 08:00:00 | AAPL | Stock | 79.375 | 79.4975 | 79.0 | 79.3625 | 227360.0 |
| 2020-05-12 08:05:00 | AAPL | Stock | 79.3625 | 79.3625 | 79.28 | 79.3375 | 22376.0 |
| 2020-05-12 08:10:00 | AAPL | Stock | 79.35 | 79.4 | 79.3375 | 79.4 | 22700.0 |
| 2020-05-12 08:15:00 | AAPL | Stock | 79.3775 | 79.4125 | 79.345 | 79.375 | 39660.0 |
| 2020-05-12 08:20:00 | AAPL | Stock | 79.375 | 79.375 | 79.3125 | 79.35 | 12608.0 |
| 2020-05-12 08:25:00 | AAPL | Stock | 79.365 | 79.4125 | 79.33 | 79.375 | 46880.0 |
| 2020-05-12 08:30:00 | AAPL | Stock | 79.325 | 79.3875 | 79.1875 | 79.1975 | 85328.0 |
| 2020-05-12 08:35:00 | AAPL | Stock | 79.1925 | 79.25 | 79.1775 | 79.2475 | 33384.0 |
| 2020-05-12 08:40:00 | AAPL | Stock | 79.29 | 79.325 | 79.2725 | 79.325 | 19648.0 |
| 2020-05-12 08:45:00 | AAPL | Stock | 79.3325 | 79.345 | 79.3225 | 79.3275 | 12752.0 |
| 2020-05-12 08:50:00 | AAPL | Stock | 79.335 | 79.335 | 79.3075 | 79.3225 | 9788.0 |
| 2020-05-12 08:55:00 | AAPL | Stock | 79.31 | 79.375 | 79.31 | 79.36 | 33080.0 |
| 2020-05-12 09:00:00 | AAPL | Stock | 79.375 | 79.425 | 79.36 | 79.42 | 34624.0 |
| 2020-05-12 09:05:00 | AAPL | Stock | 79.4025 | 79.4125 | 79.2975 | 79.325 | 31060.0 |
| 2020-05-12 09:10:00 | AAPL | Stock | 79.325 | 79.36 | 79.2675 | 79.325 | 18712.0 |
| 2020-05-12 09:15:00 | AAPL | Stock | 79.325 | 79.4375 | 79.3 | 79.4375 | 36576.0 |
| 2020-05-12 09:20:00 | AAPL | Stock | 79.4375 | 79.4375 | 79.4 | 79.4 | 44308.0 |
| 2020-05-12 09:25:00 | AAPL | Stock | 79.4 | 79.52 | 79.4 | 79.48 | 89592.0 |
| 2020-05-12 09:30:00 | AAPL | Stock | 79.48 | 79.775 | 79.2892 | 79.4125 | 7188092.0 |
> showing 50 of 409,703 rows — these rows as CSV