PREVIEW / stock_5min / 2020-02-14
file: by_date/stock_5min/2020/2020-02-14.parquet size: 5.9 MB rows: 361,543 symbols: 2,409
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-02-14 04:15:00 | AAPL | Stock | 81.3575 | 81.3875 | 81.3575 | 81.3875 | 5816.0 |
| 2020-02-14 04:20:00 | AAPL | Stock | 81.4875 | 81.4875 | 81.4875 | 81.4875 | 4000.0 |
| 2020-02-14 04:35:00 | AAPL | Stock | 81.4875 | 81.4875 | 81.47 | 81.4875 | 5532.0 |
| 2020-02-14 04:40:00 | AAPL | Stock | 81.5475 | 81.5625 | 81.5475 | 81.5625 | 3372.0 |
| 2020-02-14 04:45:00 | AAPL | Stock | 81.5 | 81.5 | 81.5 | 81.5 | 1696.0 |
| 2020-02-14 04:55:00 | AAPL | Stock | 81.5475 | 81.5475 | 81.5325 | 81.5325 | 2000.0 |
| 2020-02-14 05:05:00 | AAPL | Stock | 81.55 | 81.55 | 81.5225 | 81.55 | 3532.0 |
| 2020-02-14 05:10:00 | AAPL | Stock | 81.55 | 81.55 | 81.55 | 81.55 | 3472.0 |
| 2020-02-14 05:15:00 | AAPL | Stock | 81.54 | 81.54 | 81.54 | 81.54 | 800.0 |
| 2020-02-14 05:25:00 | AAPL | Stock | 81.5375 | 81.5375 | 81.5375 | 81.5375 | 400.0 |
| 2020-02-14 05:50:00 | AAPL | Stock | 81.5925 | 81.625 | 81.59 | 81.625 | 1988.0 |
| 2020-02-14 06:10:00 | AAPL | Stock | 81.5025 | 81.5025 | 81.5025 | 81.5025 | 400.0 |
| 2020-02-14 06:20:00 | AAPL | Stock | 81.4675 | 81.4675 | 81.4675 | 81.4675 | 464.0 |
| 2020-02-14 06:30:00 | AAPL | Stock | 81.5 | 81.5 | 81.5 | 81.5 | 1600.0 |
| 2020-02-14 06:35:00 | AAPL | Stock | 81.5025 | 81.5025 | 81.5 | 81.5 | 800.0 |
| 2020-02-14 06:55:00 | AAPL | Stock | 81.4825 | 81.5 | 81.475 | 81.5 | 2364.0 |
| 2020-02-14 07:00:00 | AAPL | Stock | 81.52 | 81.55 | 81.485 | 81.525 | 25612.0 |
| 2020-02-14 07:05:00 | AAPL | Stock | 81.55 | 81.55 | 81.5125 | 81.52 | 3400.0 |
| 2020-02-14 07:10:00 | AAPL | Stock | 81.5225 | 81.545 | 81.5225 | 81.545 | 12284.0 |
| 2020-02-14 07:15:00 | AAPL | Stock | 81.5475 | 81.5675 | 81.5475 | 81.5625 | 17608.0 |
| 2020-02-14 07:20:00 | AAPL | Stock | 81.57 | 81.6 | 81.5525 | 81.6 | 13020.0 |
| 2020-02-14 07:25:00 | AAPL | Stock | 81.58 | 81.58 | 81.55 | 81.575 | 10152.0 |
| 2020-02-14 07:30:00 | AAPL | Stock | 81.55 | 81.5625 | 81.545 | 81.5525 | 7452.0 |
| 2020-02-14 07:35:00 | AAPL | Stock | 81.54 | 81.5575 | 81.54 | 81.5575 | 1712.0 |
| 2020-02-14 07:40:00 | AAPL | Stock | 81.55 | 81.55 | 81.55 | 81.55 | 400.0 |
| 2020-02-14 07:45:00 | AAPL | Stock | 81.54 | 81.54 | 81.54 | 81.54 | 1564.0 |
| 2020-02-14 07:50:00 | AAPL | Stock | 81.555 | 81.555 | 81.555 | 81.555 | 400.0 |
| 2020-02-14 07:55:00 | AAPL | Stock | 81.54 | 81.555 | 81.54 | 81.5475 | 7260.0 |
| 2020-02-14 08:00:00 | AAPL | Stock | 81.55 | 81.6 | 81.5 | 81.5225 | 64268.0 |
| 2020-02-14 08:05:00 | AAPL | Stock | 81.5375 | 81.5375 | 81.5 | 81.5025 | 27532.0 |
| 2020-02-14 08:10:00 | AAPL | Stock | 81.515 | 81.515 | 81.475 | 81.485 | 15648.0 |
| 2020-02-14 08:15:00 | AAPL | Stock | 81.475 | 81.4942 | 81.4575 | 81.4625 | 18752.0 |
| 2020-02-14 08:20:00 | AAPL | Stock | 81.4575 | 81.5375 | 81.4575 | 81.4925 | 54056.0 |
| 2020-02-14 08:25:00 | AAPL | Stock | 81.5 | 81.5 | 81.45 | 81.475 | 12212.0 |
| 2020-02-14 08:30:00 | AAPL | Stock | 81.475 | 81.475 | 81.3575 | 81.3875 | 26204.0 |
| 2020-02-14 08:35:00 | AAPL | Stock | 81.3625 | 81.3625 | 81.2675 | 81.325 | 44504.0 |
| 2020-02-14 08:40:00 | AAPL | Stock | 81.3375 | 81.372 | 81.325 | 81.369 | 19344.0 |
| 2020-02-14 08:45:00 | AAPL | Stock | 81.37 | 81.37 | 81.2525 | 81.295 | 71460.0 |
| 2020-02-14 08:50:00 | AAPL | Stock | 81.2925 | 81.3 | 81.2375 | 81.295 | 93716.0 |
| 2020-02-14 08:55:00 | AAPL | Stock | 81.3 | 81.325 | 81.295 | 81.32 | 10836.0 |
| 2020-02-14 09:00:00 | AAPL | Stock | 81.3 | 81.325 | 81.265 | 81.325 | 18920.0 |
| 2020-02-14 09:05:00 | AAPL | Stock | 81.325 | 81.325 | 81.2875 | 81.294 | 16108.0 |
| 2020-02-14 09:10:00 | AAPL | Stock | 81.3 | 81.3225 | 81.25 | 81.2825 | 22792.0 |
| 2020-02-14 09:15:00 | AAPL | Stock | 81.25 | 81.295 | 81.25 | 81.2775 | 12100.0 |
| 2020-02-14 09:20:00 | AAPL | Stock | 81.3 | 81.35 | 81.3 | 81.3 | 25604.0 |
| 2020-02-14 09:25:00 | AAPL | Stock | 81.345 | 81.345 | 81.085 | 81.14 | 95888.0 |
| 2020-02-14 09:30:00 | AAPL | Stock | 81.1775 | 81.495 | 81.14 | 81.451 | 2756516.0 |
| 2020-02-14 09:35:00 | AAPL | Stock | 81.445 | 81.4622 | 81.205 | 81.3428 | 1552256.0 |
| 2020-02-14 09:40:00 | AAPL | Stock | 81.3275 | 81.3675 | 81.09 | 81.1275 | 1476016.0 |
| 2020-02-14 09:45:00 | AAPL | Stock | 81.13 | 81.22 | 81.11 | 81.1275 | 1014692.0 |
> showing 50 of 361,543 rows — these rows as CSV