PREVIEW / stock_5min / 2020-02-21
file: by_date/stock_5min/2020/2020-02-21.parquet size: 6.0 MB rows: 367,796 symbols: 2,425
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-21 04:00:00 | AAPL | Stock | 79.425 | 79.425 | 79.425 | 79.425 | 2352.0 |
| 2020-02-21 04:10:00 | AAPL | Stock | 79.5025 | 79.5025 | 79.5 | 79.5 | 3480.0 |
| 2020-02-21 04:15:00 | AAPL | Stock | 79.4775 | 79.4775 | 79.45 | 79.45 | 8868.0 |
| 2020-02-21 04:20:00 | AAPL | Stock | 79.4375 | 79.4375 | 79.4375 | 79.4375 | 600.0 |
| 2020-02-21 04:25:00 | AAPL | Stock | 79.4175 | 79.465 | 79.415 | 79.465 | 1552.0 |
| 2020-02-21 04:30:00 | AAPL | Stock | 79.485 | 79.485 | 79.485 | 79.485 | 2736.0 |
| 2020-02-21 04:35:00 | AAPL | Stock | 79.4375 | 79.4375 | 79.4375 | 79.4375 | 1352.0 |
| 2020-02-21 04:45:00 | AAPL | Stock | 79.475 | 79.475 | 79.43 | 79.43 | 6480.0 |
| 2020-02-21 04:50:00 | AAPL | Stock | 79.41 | 79.41 | 79.375 | 79.375 | 6184.0 |
| 2020-02-21 04:55:00 | AAPL | Stock | 79.35 | 79.35 | 79.35 | 79.35 | 3200.0 |
| 2020-02-21 05:00:00 | AAPL | Stock | 79.42 | 79.4375 | 79.42 | 79.4375 | 1600.0 |
| 2020-02-21 05:05:00 | AAPL | Stock | 79.45 | 79.465 | 79.4475 | 79.465 | 1640.0 |
| 2020-02-21 05:10:00 | AAPL | Stock | 79.485 | 79.5225 | 79.485 | 79.5225 | 1584.0 |
| 2020-02-21 05:15:00 | AAPL | Stock | 79.53 | 79.565 | 79.515 | 79.565 | 2328.0 |
| 2020-02-21 05:20:00 | AAPL | Stock | 79.525 | 79.525 | 79.525 | 79.525 | 2000.0 |
| 2020-02-21 05:25:00 | AAPL | Stock | 79.5225 | 79.5225 | 79.5225 | 79.5225 | 1200.0 |
| 2020-02-21 05:40:00 | AAPL | Stock | 79.4825 | 79.4825 | 79.475 | 79.475 | 3912.0 |
| 2020-02-21 05:50:00 | AAPL | Stock | 79.54 | 79.625 | 79.54 | 79.625 | 7496.0 |
| 2020-02-21 06:05:00 | AAPL | Stock | 79.5 | 79.5 | 79.475 | 79.475 | 9416.0 |
| 2020-02-21 06:15:00 | AAPL | Stock | 79.4575 | 79.4575 | 79.4575 | 79.4575 | 400.0 |
| 2020-02-21 06:30:00 | AAPL | Stock | 79.495 | 79.57 | 79.495 | 79.57 | 3460.0 |
| 2020-02-21 06:45:00 | AAPL | Stock | 79.6725 | 79.6725 | 79.61 | 79.61 | 1200.0 |
| 2020-02-21 07:00:00 | AAPL | Stock | 79.5175 | 79.5975 | 79.5175 | 79.5525 | 27736.0 |
| 2020-02-21 07:05:00 | AAPL | Stock | 79.54 | 79.55 | 79.525 | 79.5375 | 11380.0 |
| 2020-02-21 07:10:00 | AAPL | Stock | 79.575 | 79.5875 | 79.5 | 79.5025 | 36016.0 |
| 2020-02-21 07:15:00 | AAPL | Stock | 79.53 | 79.5725 | 79.53 | 79.5325 | 12744.0 |
| 2020-02-21 07:20:00 | AAPL | Stock | 79.55 | 79.62 | 79.55 | 79.62 | 7120.0 |
| 2020-02-21 07:25:00 | AAPL | Stock | 79.6 | 79.625 | 79.6 | 79.625 | 14460.0 |
| 2020-02-21 07:30:00 | AAPL | Stock | 79.635 | 79.6575 | 79.625 | 79.625 | 5812.0 |
| 2020-02-21 07:35:00 | AAPL | Stock | 79.6675 | 79.72 | 79.6675 | 79.7 | 12916.0 |
| 2020-02-21 07:40:00 | AAPL | Stock | 79.705 | 79.7075 | 79.6875 | 79.7075 | 5600.0 |
| 2020-02-21 07:45:00 | AAPL | Stock | 79.7 | 79.7775 | 79.7 | 79.7775 | 21700.0 |
| 2020-02-21 07:50:00 | AAPL | Stock | 79.75 | 79.75 | 79.725 | 79.725 | 11024.0 |
| 2020-02-21 07:55:00 | AAPL | Stock | 79.72 | 79.72 | 79.675 | 79.675 | 12712.0 |
| 2020-02-21 08:00:00 | AAPL | Stock | 79.575 | 79.7825 | 79.525 | 79.675 | 166544.0 |
| 2020-02-21 08:05:00 | AAPL | Stock | 79.7225 | 79.745 | 79.6625 | 79.675 | 14332.0 |
| 2020-02-21 08:10:00 | AAPL | Stock | 79.7122 | 79.7122 | 79.575 | 79.575 | 29788.0 |
| 2020-02-21 08:15:00 | AAPL | Stock | 79.6125 | 79.675 | 79.6 | 79.6025 | 23580.0 |
| 2020-02-21 08:20:00 | AAPL | Stock | 79.6 | 79.625 | 79.5625 | 79.622 | 23140.0 |
| 2020-02-21 08:25:00 | AAPL | Stock | 79.625 | 79.645 | 79.6 | 79.6 | 14920.0 |
| 2020-02-21 08:30:00 | AAPL | Stock | 79.625 | 79.6505 | 79.55 | 79.56 | 22832.0 |
| 2020-02-21 08:35:00 | AAPL | Stock | 79.625 | 79.667 | 79.625 | 79.6625 | 3480.0 |
| 2020-02-21 08:40:00 | AAPL | Stock | 79.63 | 79.65 | 79.605 | 79.625 | 5812.0 |
| 2020-02-21 08:45:00 | AAPL | Stock | 79.6375 | 79.6375 | 79.5675 | 79.6225 | 20664.0 |
| 2020-02-21 08:50:00 | AAPL | Stock | 79.6375 | 79.6375 | 79.58 | 79.6 | 11732.0 |
| 2020-02-21 08:55:00 | AAPL | Stock | 79.5995 | 79.6125 | 79.5875 | 79.6 | 19784.0 |
| 2020-02-21 09:00:00 | AAPL | Stock | 79.5875 | 79.625 | 79.5875 | 79.6 | 21888.0 |
| 2020-02-21 09:05:00 | AAPL | Stock | 79.625 | 79.6697 | 79.62 | 79.6325 | 10328.0 |
| 2020-02-21 09:10:00 | AAPL | Stock | 79.67 | 79.7125 | 79.67 | 79.7 | 9872.0 |
| 2020-02-21 09:15:00 | AAPL | Stock | 79.71 | 79.775 | 79.71 | 79.775 | 45584.0 |
> showing 50 of 367,796 rows — these rows as CSV