PREVIEW / stock_5min / 2020-08-10
file: by_date/stock_5min/2020/2020-08-10.parquet size: 6.8 MB rows: 425,260 symbols: 2,451
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-08-10 04:00:00 | AAPL | Stock | 111.625 | 111.625 | 111.5 | 111.625 | 11504.0 |
| 2020-08-10 04:05:00 | AAPL | Stock | 111.625 | 111.625 | 111.625 | 111.625 | 1200.0 |
| 2020-08-10 04:10:00 | AAPL | Stock | 111.425 | 111.425 | 111.375 | 111.375 | 1512.0 |
| 2020-08-10 04:25:00 | AAPL | Stock | 111.35 | 111.35 | 111.35 | 111.35 | 400.0 |
| 2020-08-10 04:30:00 | AAPL | Stock | 111.375 | 111.5 | 111.375 | 111.5 | 2328.0 |
| 2020-08-10 04:40:00 | AAPL | Stock | 111.3775 | 111.4925 | 111.3775 | 111.4925 | 2800.0 |
| 2020-08-10 04:45:00 | AAPL | Stock | 111.5 | 111.6175 | 111.4975 | 111.6175 | 3752.0 |
| 2020-08-10 04:50:00 | AAPL | Stock | 111.6175 | 111.635 | 111.6175 | 111.635 | 1848.0 |
| 2020-08-10 04:55:00 | AAPL | Stock | 111.7 | 111.7 | 111.7 | 111.7 | 1308.0 |
| 2020-08-10 05:00:00 | AAPL | Stock | 111.7375 | 111.875 | 111.7375 | 111.75 | 3920.0 |
| 2020-08-10 05:10:00 | AAPL | Stock | 111.8425 | 111.8425 | 111.8425 | 111.8425 | 800.0 |
| 2020-08-10 05:15:00 | AAPL | Stock | 111.8475 | 111.8625 | 111.8475 | 111.8625 | 800.0 |
| 2020-08-10 05:20:00 | AAPL | Stock | 111.875 | 111.875 | 111.875 | 111.875 | 5180.0 |
| 2020-08-10 05:30:00 | AAPL | Stock | 111.85 | 111.875 | 111.8275 | 111.8275 | 5224.0 |
| 2020-08-10 05:40:00 | AAPL | Stock | 111.825 | 111.825 | 111.785 | 111.785 | 1640.0 |
| 2020-08-10 05:45:00 | AAPL | Stock | 111.6875 | 111.6875 | 111.6875 | 111.6875 | 1004.0 |
| 2020-08-10 05:50:00 | AAPL | Stock | 111.875 | 111.9625 | 111.875 | 111.89 | 9352.0 |
| 2020-08-10 05:55:00 | AAPL | Stock | 111.925 | 111.925 | 111.925 | 111.925 | 772.0 |
| 2020-08-10 06:00:00 | AAPL | Stock | 111.8775 | 111.8775 | 111.805 | 111.805 | 3268.0 |
| 2020-08-10 06:05:00 | AAPL | Stock | 111.825 | 111.825 | 111.825 | 111.825 | 692.0 |
| 2020-08-10 06:10:00 | AAPL | Stock | 111.75 | 111.8125 | 111.75 | 111.8125 | 1012.0 |
| 2020-08-10 06:25:00 | AAPL | Stock | 111.7975 | 111.7975 | 111.7975 | 111.7975 | 400.0 |
| 2020-08-10 06:30:00 | AAPL | Stock | 111.8125 | 111.875 | 111.8125 | 111.875 | 3688.0 |
| 2020-08-10 06:35:00 | AAPL | Stock | 111.865 | 111.87 | 111.8125 | 111.87 | 5604.0 |
| 2020-08-10 06:40:00 | AAPL | Stock | 111.8375 | 111.875 | 111.825 | 111.825 | 3180.0 |
| 2020-08-10 06:45:00 | AAPL | Stock | 111.815 | 111.825 | 111.7825 | 111.825 | 5640.0 |
| 2020-08-10 06:50:00 | AAPL | Stock | 111.85 | 112.0 | 111.85 | 112.0 | 4824.0 |
| 2020-08-10 06:55:00 | AAPL | Stock | 111.9775 | 112.0 | 111.9 | 111.9 | 5764.0 |
| 2020-08-10 07:00:00 | AAPL | Stock | 111.95 | 112.3425 | 111.85 | 112.25 | 166224.0 |
| 2020-08-10 07:05:00 | AAPL | Stock | 112.245 | 112.25 | 112.09 | 112.1375 | 42736.0 |
| 2020-08-10 07:10:00 | AAPL | Stock | 112.1375 | 112.2925 | 112.1375 | 112.225 | 45776.0 |
| 2020-08-10 07:15:00 | AAPL | Stock | 112.2225 | 112.3 | 112.2 | 112.2375 | 47228.0 |
| 2020-08-10 07:20:00 | AAPL | Stock | 112.25 | 112.3575 | 112.2375 | 112.3 | 45260.0 |
| 2020-08-10 07:25:00 | AAPL | Stock | 112.2998 | 112.305 | 112.2525 | 112.305 | 14040.0 |
| 2020-08-10 07:30:00 | AAPL | Stock | 112.3102 | 112.435 | 112.3102 | 112.4 | 66028.0 |
| 2020-08-10 07:35:00 | AAPL | Stock | 112.3775 | 112.3875 | 112.1875 | 112.25 | 66932.0 |
| 2020-08-10 07:40:00 | AAPL | Stock | 112.255 | 112.3625 | 112.2448 | 112.325 | 27408.0 |
| 2020-08-10 07:45:00 | AAPL | Stock | 112.3375 | 112.375 | 112.3175 | 112.35 | 22480.0 |
| 2020-08-10 07:50:00 | AAPL | Stock | 112.325 | 112.4 | 112.325 | 112.4 | 18068.0 |
| 2020-08-10 07:55:00 | AAPL | Stock | 112.4 | 112.4975 | 112.4 | 112.485 | 19576.0 |
| 2020-08-10 08:00:00 | AAPL | Stock | 112.18 | 112.5 | 111.9 | 112.325 | 245160.0 |
| 2020-08-10 08:05:00 | AAPL | Stock | 112.3625 | 112.42 | 112.337 | 112.42 | 21368.0 |
| 2020-08-10 08:10:00 | AAPL | Stock | 112.3975 | 112.3975 | 112.2975 | 112.33 | 57484.0 |
| 2020-08-10 08:15:00 | AAPL | Stock | 112.36 | 112.435 | 112.3475 | 112.42 | 67800.0 |
| 2020-08-10 08:20:00 | AAPL | Stock | 112.415 | 112.5 | 112.365 | 112.4625 | 53796.0 |
| 2020-08-10 08:25:00 | AAPL | Stock | 112.49 | 112.6575 | 112.4875 | 112.6275 | 139336.0 |
| 2020-08-10 08:30:00 | AAPL | Stock | 112.625 | 112.7775 | 112.5875 | 112.725 | 169912.0 |
| 2020-08-10 08:35:00 | AAPL | Stock | 112.725 | 112.795 | 112.675 | 112.7225 | 136428.0 |
| 2020-08-10 08:40:00 | AAPL | Stock | 112.6875 | 112.935 | 112.6775 | 112.8975 | 205840.0 |
| 2020-08-10 08:45:00 | AAPL | Stock | 112.8975 | 113.0425 | 112.8252 | 112.96 | 260580.0 |
> showing 50 of 425,260 rows — these rows as CSV