PREVIEW / stock_5min / 2020-02-05
file: by_date/stock_5min/2020/2020-02-05.parquet size: 6.0 MB rows: 374,024 symbols: 2,428
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-05 04:00:00 | AAPL | Stock | 80.1625 | 80.19 | 79.9975 | 80.05 | 65456.0 |
| 2020-02-05 04:05:00 | AAPL | Stock | 80.05 | 80.1975 | 80.05 | 80.1975 | 7532.0 |
| 2020-02-05 04:10:00 | AAPL | Stock | 80.245 | 80.25 | 80.225 | 80.245 | 1812.0 |
| 2020-02-05 04:15:00 | AAPL | Stock | 80.2 | 80.2 | 80.2 | 80.2 | 676.0 |
| 2020-02-05 04:20:00 | AAPL | Stock | 80.355 | 80.355 | 80.33 | 80.33 | 1520.0 |
| 2020-02-05 04:25:00 | AAPL | Stock | 80.37 | 80.495 | 80.37 | 80.455 | 46152.0 |
| 2020-02-05 04:30:00 | AAPL | Stock | 80.4875 | 80.4875 | 80.4625 | 80.4625 | 19824.0 |
| 2020-02-05 04:35:00 | AAPL | Stock | 80.485 | 80.5025 | 80.41 | 80.41 | 14564.0 |
| 2020-02-05 04:40:00 | AAPL | Stock | 80.4625 | 80.515 | 80.46 | 80.5125 | 28368.0 |
| 2020-02-05 04:45:00 | AAPL | Stock | 80.6075 | 80.6125 | 80.6075 | 80.6075 | 6436.0 |
| 2020-02-05 04:50:00 | AAPL | Stock | 80.5775 | 80.86 | 80.5775 | 80.86 | 14392.0 |
| 2020-02-05 04:55:00 | AAPL | Stock | 80.86 | 80.9 | 80.4975 | 80.5975 | 43840.0 |
| 2020-02-05 05:00:00 | AAPL | Stock | 80.575 | 80.66 | 80.575 | 80.66 | 4760.0 |
| 2020-02-05 05:10:00 | AAPL | Stock | 80.6475 | 80.6475 | 80.49 | 80.49 | 14032.0 |
| 2020-02-05 05:15:00 | AAPL | Stock | 80.49 | 80.6925 | 80.485 | 80.4875 | 21964.0 |
| 2020-02-05 05:20:00 | AAPL | Stock | 80.455 | 80.49 | 80.45 | 80.49 | 5332.0 |
| 2020-02-05 05:25:00 | AAPL | Stock | 80.4625 | 80.4625 | 80.4475 | 80.4475 | 6632.0 |
| 2020-02-05 05:30:00 | AAPL | Stock | 80.485 | 80.485 | 80.25 | 80.3075 | 43964.0 |
| 2020-02-05 05:35:00 | AAPL | Stock | 80.3475 | 80.4 | 80.3125 | 80.4 | 16632.0 |
| 2020-02-05 05:40:00 | AAPL | Stock | 80.4125 | 80.4125 | 80.4125 | 80.4125 | 2440.0 |
| 2020-02-05 05:45:00 | AAPL | Stock | 80.4025 | 80.425 | 80.375 | 80.425 | 4400.0 |
| 2020-02-05 05:50:00 | AAPL | Stock | 80.38 | 80.4125 | 80.37 | 80.37 | 6220.0 |
| 2020-02-05 05:55:00 | AAPL | Stock | 80.375 | 80.375 | 80.375 | 80.375 | 4276.0 |
| 2020-02-05 06:00:00 | AAPL | Stock | 80.315 | 80.32 | 80.315 | 80.315 | 9888.0 |
| 2020-02-05 06:05:00 | AAPL | Stock | 80.3375 | 80.345 | 80.335 | 80.345 | 1200.0 |
| 2020-02-05 06:10:00 | AAPL | Stock | 80.3625 | 80.3625 | 80.325 | 80.3375 | 7556.0 |
| 2020-02-05 06:15:00 | AAPL | Stock | 80.3375 | 80.3375 | 80.3375 | 80.3375 | 2400.0 |
| 2020-02-05 06:20:00 | AAPL | Stock | 80.4375 | 80.495 | 80.4375 | 80.495 | 2040.0 |
| 2020-02-05 06:25:00 | AAPL | Stock | 80.5 | 80.575 | 80.5 | 80.575 | 1360.0 |
| 2020-02-05 06:30:00 | AAPL | Stock | 80.5375 | 80.575 | 80.5375 | 80.575 | 4000.0 |
| 2020-02-05 06:35:00 | AAPL | Stock | 80.435 | 80.435 | 80.2525 | 80.28 | 9480.0 |
| 2020-02-05 06:40:00 | AAPL | Stock | 80.375 | 80.375 | 80.29 | 80.35 | 9460.0 |
| 2020-02-05 06:45:00 | AAPL | Stock | 80.3625 | 80.3625 | 80.3625 | 80.3625 | 520.0 |
| 2020-02-05 06:50:00 | AAPL | Stock | 80.365 | 80.4225 | 80.35 | 80.4225 | 4600.0 |
| 2020-02-05 06:55:00 | AAPL | Stock | 80.3625 | 80.3625 | 80.325 | 80.325 | 12596.0 |
| 2020-02-05 07:00:00 | AAPL | Stock | 80.36 | 80.36 | 80.25 | 80.25 | 121432.0 |
| 2020-02-05 07:05:00 | AAPL | Stock | 80.25 | 80.325 | 80.2125 | 80.32 | 64584.0 |
| 2020-02-05 07:10:00 | AAPL | Stock | 80.325 | 80.5 | 80.305 | 80.4875 | 68644.0 |
| 2020-02-05 07:15:00 | AAPL | Stock | 80.5 | 80.5875 | 80.5 | 80.5275 | 95568.0 |
| 2020-02-05 07:20:00 | AAPL | Stock | 80.525 | 80.565 | 80.515 | 80.55 | 38684.0 |
| 2020-02-05 07:25:00 | AAPL | Stock | 80.5475 | 80.5625 | 80.4975 | 80.4975 | 70148.0 |
| 2020-02-05 07:30:00 | AAPL | Stock | 80.5225 | 80.5225 | 80.45 | 80.5 | 24524.0 |
| 2020-02-05 07:35:00 | AAPL | Stock | 80.4925 | 80.525 | 80.4875 | 80.4875 | 21752.0 |
| 2020-02-05 07:40:00 | AAPL | Stock | 80.495 | 80.4975 | 80.455 | 80.4975 | 12260.0 |
| 2020-02-05 07:45:00 | AAPL | Stock | 80.495 | 80.51 | 80.475 | 80.5075 | 39192.0 |
| 2020-02-05 07:50:00 | AAPL | Stock | 80.505 | 80.51 | 80.4925 | 80.5 | 42156.0 |
| 2020-02-05 07:55:00 | AAPL | Stock | 80.5075 | 80.515 | 80.4525 | 80.47 | 101748.0 |
| 2020-02-05 08:00:00 | AAPL | Stock | 80.2625 | 80.575 | 80.215 | 80.53 | 265024.0 |
| 2020-02-05 08:05:00 | AAPL | Stock | 80.5175 | 80.5625 | 80.4875 | 80.5625 | 92932.0 |
| 2020-02-05 08:10:00 | AAPL | Stock | 80.57 | 80.6 | 80.55 | 80.6 | 72280.0 |
> showing 50 of 374,024 rows — these rows as CSV