PREVIEW / stock_5min / 2020-07-16
file: by_date/stock_5min/2020/2020-07-16.parquet size: 6.4 MB rows: 405,484 symbols: 2,439
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-07-16 04:00:00 | AAPL | Stock | 96.925 | 96.925 | 96.575 | 96.6175 | 6872.0 |
| 2020-07-16 04:05:00 | AAPL | Stock | 96.7175 | 96.72 | 96.705 | 96.705 | 2108.0 |
| 2020-07-16 04:10:00 | AAPL | Stock | 96.58 | 96.75 | 96.58 | 96.58 | 19132.0 |
| 2020-07-16 04:15:00 | AAPL | Stock | 96.575 | 96.575 | 96.575 | 96.575 | 400.0 |
| 2020-07-16 04:20:00 | AAPL | Stock | 96.55 | 96.5575 | 96.5 | 96.5 | 7148.0 |
| 2020-07-16 04:30:00 | AAPL | Stock | 96.2825 | 96.335 | 96.2825 | 96.33 | 3944.0 |
| 2020-07-16 04:35:00 | AAPL | Stock | 96.305 | 96.305 | 96.1225 | 96.225 | 2000.0 |
| 2020-07-16 04:40:00 | AAPL | Stock | 96.1875 | 96.1875 | 96.1875 | 96.1875 | 400.0 |
| 2020-07-16 04:45:00 | AAPL | Stock | 96.2025 | 96.2025 | 96.19 | 96.19 | 2632.0 |
| 2020-07-16 04:55:00 | AAPL | Stock | 96.21 | 96.21 | 96.21 | 96.21 | 708.0 |
| 2020-07-16 05:00:00 | AAPL | Stock | 96.21 | 96.295 | 96.1875 | 96.295 | 1400.0 |
| 2020-07-16 05:05:00 | AAPL | Stock | 96.1775 | 96.1775 | 96.125 | 96.125 | 3520.0 |
| 2020-07-16 05:10:00 | AAPL | Stock | 96.115 | 96.115 | 96.0575 | 96.0575 | 7736.0 |
| 2020-07-16 05:15:00 | AAPL | Stock | 96.0575 | 96.1 | 96.0575 | 96.1 | 8540.0 |
| 2020-07-16 05:20:00 | AAPL | Stock | 96.17 | 96.175 | 96.17 | 96.175 | 2308.0 |
| 2020-07-16 05:30:00 | AAPL | Stock | 96.3025 | 96.335 | 96.25 | 96.25 | 10156.0 |
| 2020-07-16 05:35:00 | AAPL | Stock | 96.2775 | 96.325 | 96.25 | 96.325 | 3540.0 |
| 2020-07-16 05:40:00 | AAPL | Stock | 96.35 | 96.35 | 96.3425 | 96.3425 | 2212.0 |
| 2020-07-16 05:45:00 | AAPL | Stock | 96.2525 | 96.2525 | 96.245 | 96.245 | 812.0 |
| 2020-07-16 05:50:00 | AAPL | Stock | 96.25 | 96.25 | 96.25 | 96.25 | 2800.0 |
| 2020-07-16 06:05:00 | AAPL | Stock | 96.275 | 96.3375 | 96.25 | 96.25 | 3492.0 |
| 2020-07-16 06:10:00 | AAPL | Stock | 96.275 | 96.3 | 96.275 | 96.3 | 1300.0 |
| 2020-07-16 06:15:00 | AAPL | Stock | 96.3 | 96.3375 | 96.2775 | 96.305 | 4400.0 |
| 2020-07-16 06:25:00 | AAPL | Stock | 96.3075 | 96.3075 | 96.3075 | 96.3075 | 800.0 |
| 2020-07-16 06:30:00 | AAPL | Stock | 96.25 | 96.25 | 96.06 | 96.06 | 4036.0 |
| 2020-07-16 06:35:00 | AAPL | Stock | 96.03 | 96.03 | 95.755 | 95.925 | 14632.0 |
| 2020-07-16 06:40:00 | AAPL | Stock | 96.0375 | 96.0375 | 96.0375 | 96.0375 | 400.0 |
| 2020-07-16 06:45:00 | AAPL | Stock | 96.0375 | 96.25 | 96.0375 | 96.1775 | 5340.0 |
| 2020-07-16 06:50:00 | AAPL | Stock | 96.3375 | 96.3625 | 96.3375 | 96.3625 | 1240.0 |
| 2020-07-16 06:55:00 | AAPL | Stock | 96.2125 | 96.265 | 96.2125 | 96.265 | 1600.0 |
| 2020-07-16 07:00:00 | AAPL | Stock | 96.3125 | 96.6 | 96.125 | 96.6 | 90840.0 |
| 2020-07-16 07:05:00 | AAPL | Stock | 96.5475 | 96.565 | 96.315 | 96.315 | 28624.0 |
| 2020-07-16 07:10:00 | AAPL | Stock | 96.275 | 96.43 | 96.275 | 96.3525 | 7600.0 |
| 2020-07-16 07:15:00 | AAPL | Stock | 96.325 | 96.45 | 96.275 | 96.45 | 16072.0 |
| 2020-07-16 07:20:00 | AAPL | Stock | 96.5 | 96.625 | 96.4925 | 96.5875 | 19192.0 |
| 2020-07-16 07:25:00 | AAPL | Stock | 96.5875 | 96.61 | 96.5525 | 96.61 | 12924.0 |
| 2020-07-16 07:30:00 | AAPL | Stock | 96.605 | 96.75 | 96.605 | 96.7475 | 45820.0 |
| 2020-07-16 07:35:00 | AAPL | Stock | 96.7525 | 96.795 | 96.59 | 96.59 | 19228.0 |
| 2020-07-16 07:40:00 | AAPL | Stock | 96.595 | 96.7125 | 96.5875 | 96.665 | 14360.0 |
| 2020-07-16 07:45:00 | AAPL | Stock | 96.72 | 96.8575 | 96.7175 | 96.755 | 8432.0 |
| 2020-07-16 07:50:00 | AAPL | Stock | 96.8325 | 96.875 | 96.7625 | 96.8175 | 31352.0 |
| 2020-07-16 07:55:00 | AAPL | Stock | 96.7625 | 96.7625 | 96.58 | 96.675 | 14332.0 |
| 2020-07-16 08:00:00 | AAPL | Stock | 96.2625 | 96.875 | 96.2225 | 96.5625 | 130540.0 |
| 2020-07-16 08:05:00 | AAPL | Stock | 96.57 | 96.75 | 96.53 | 96.6775 | 23664.0 |
| 2020-07-16 08:10:00 | AAPL | Stock | 96.71 | 96.71 | 96.6 | 96.625 | 24860.0 |
| 2020-07-16 08:15:00 | AAPL | Stock | 96.625 | 96.75 | 96.625 | 96.7375 | 18604.0 |
| 2020-07-16 08:20:00 | AAPL | Stock | 96.775 | 96.775 | 96.6625 | 96.6875 | 24792.0 |
| 2020-07-16 08:25:00 | AAPL | Stock | 96.7475 | 96.7475 | 96.625 | 96.6625 | 11876.0 |
| 2020-07-16 08:30:00 | AAPL | Stock | 96.735 | 96.75 | 96.5475 | 96.6 | 36992.0 |
| 2020-07-16 08:35:00 | AAPL | Stock | 96.5775 | 96.5775 | 96.27 | 96.27 | 90316.0 |
> showing 50 of 405,484 rows — these rows as CSV