PREVIEW / stock_5min / 2019-11-27
file: by_date/stock_5min/2019/2019-11-27.parquet size: 5.7 MB rows: 361,058 symbols: 2,477
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 |
|---|---|---|---|---|---|---|---|
| 2019-11-27 04:00:00 | AAPL | Stock | 66.375 | 66.425 | 66.375 | 66.425 | 6392.0 |
| 2019-11-27 04:05:00 | AAPL | Stock | 66.425 | 66.425 | 66.425 | 66.425 | 500.0 |
| 2019-11-27 04:35:00 | AAPL | Stock | 66.45 | 66.45 | 66.45 | 66.45 | 1384.0 |
| 2019-11-27 04:40:00 | AAPL | Stock | 66.4025 | 66.4025 | 66.4 | 66.4 | 2196.0 |
| 2019-11-27 04:45:00 | AAPL | Stock | 66.4475 | 66.45 | 66.4475 | 66.45 | 22424.0 |
| 2019-11-27 05:00:00 | AAPL | Stock | 66.45 | 66.45 | 66.45 | 66.45 | 400.0 |
| 2019-11-27 05:05:00 | AAPL | Stock | 66.45 | 66.45 | 66.45 | 66.45 | 400.0 |
| 2019-11-27 05:20:00 | AAPL | Stock | 66.4025 | 66.4025 | 66.4 | 66.4 | 6412.0 |
| 2019-11-27 05:25:00 | AAPL | Stock | 66.4 | 66.4 | 66.4 | 66.4 | 3200.0 |
| 2019-11-27 05:30:00 | AAPL | Stock | 66.4 | 66.4 | 66.4 | 66.4 | 416.0 |
| 2019-11-27 05:35:00 | AAPL | Stock | 66.425 | 66.4625 | 66.425 | 66.4625 | 2208.0 |
| 2019-11-27 05:45:00 | AAPL | Stock | 66.425 | 66.425 | 66.425 | 66.425 | 744.0 |
| 2019-11-27 05:50:00 | AAPL | Stock | 66.4525 | 66.4525 | 66.4525 | 66.4525 | 1700.0 |
| 2019-11-27 05:55:00 | AAPL | Stock | 66.4575 | 66.4575 | 66.4575 | 66.4575 | 600.0 |
| 2019-11-27 06:00:00 | AAPL | Stock | 66.425 | 66.425 | 66.425 | 66.425 | 2708.0 |
| 2019-11-27 06:15:00 | AAPL | Stock | 66.4125 | 66.4125 | 66.4125 | 66.4125 | 7772.0 |
| 2019-11-27 06:40:00 | AAPL | Stock | 66.35 | 66.35 | 66.35 | 66.35 | 400.0 |
| 2019-11-27 06:55:00 | AAPL | Stock | 66.325 | 66.3275 | 66.3125 | 66.3125 | 7868.0 |
| 2019-11-27 07:00:00 | AAPL | Stock | 66.29 | 66.31 | 66.25 | 66.3075 | 21612.0 |
| 2019-11-27 07:05:00 | AAPL | Stock | 66.3 | 66.3 | 66.3 | 66.3 | 3100.0 |
| 2019-11-27 07:10:00 | AAPL | Stock | 66.2975 | 66.31 | 66.25 | 66.25 | 15308.0 |
| 2019-11-27 07:15:00 | AAPL | Stock | 66.305 | 66.305 | 66.25 | 66.25 | 3464.0 |
| 2019-11-27 07:20:00 | AAPL | Stock | 66.2525 | 66.2625 | 66.25 | 66.2625 | 1600.0 |
| 2019-11-27 07:35:00 | AAPL | Stock | 66.2625 | 66.2625 | 66.255 | 66.255 | 800.0 |
| 2019-11-27 07:40:00 | AAPL | Stock | 66.275 | 66.275 | 66.275 | 66.275 | 400.0 |
| 2019-11-27 07:45:00 | AAPL | Stock | 66.2775 | 66.285 | 66.2775 | 66.285 | 5940.0 |
| 2019-11-27 07:50:00 | AAPL | Stock | 66.29 | 66.3125 | 66.2875 | 66.3125 | 8244.0 |
| 2019-11-27 07:55:00 | AAPL | Stock | 66.315 | 66.335 | 66.315 | 66.325 | 8804.0 |
| 2019-11-27 08:00:00 | AAPL | Stock | 66.3 | 66.3375 | 66.275 | 66.3325 | 25088.0 |
| 2019-11-27 08:05:00 | AAPL | Stock | 66.325 | 66.325 | 66.325 | 66.325 | 400.0 |
| 2019-11-27 08:10:00 | AAPL | Stock | 66.325 | 66.3325 | 66.3225 | 66.325 | 17096.0 |
| 2019-11-27 08:15:00 | AAPL | Stock | 66.3275 | 66.345 | 66.3275 | 66.345 | 13604.0 |
| 2019-11-27 08:20:00 | AAPL | Stock | 66.345 | 66.345 | 66.3 | 66.3075 | 19780.0 |
| 2019-11-27 08:25:00 | AAPL | Stock | 66.2925 | 66.32 | 66.2875 | 66.3175 | 10816.0 |
| 2019-11-27 08:30:00 | AAPL | Stock | 66.325 | 66.4075 | 66.325 | 66.395 | 40136.0 |
| 2019-11-27 08:35:00 | AAPL | Stock | 66.3925 | 66.4 | 66.335 | 66.3375 | 24344.0 |
| 2019-11-27 08:40:00 | AAPL | Stock | 66.37 | 66.375 | 66.35 | 66.3625 | 6048.0 |
| 2019-11-27 08:45:00 | AAPL | Stock | 66.36 | 66.3625 | 66.3375 | 66.3375 | 6196.0 |
| 2019-11-27 08:50:00 | AAPL | Stock | 66.32 | 66.325 | 66.295 | 66.2975 | 6284.0 |
| 2019-11-27 08:55:00 | AAPL | Stock | 66.3105 | 66.3105 | 66.2725 | 66.2725 | 46460.0 |
| 2019-11-27 09:00:00 | AAPL | Stock | 66.275 | 66.3 | 66.2625 | 66.2625 | 33552.0 |
| 2019-11-27 09:05:00 | AAPL | Stock | 66.2575 | 66.2925 | 66.255 | 66.2725 | 9748.0 |
| 2019-11-27 09:10:00 | AAPL | Stock | 66.2825 | 66.285 | 66.2625 | 66.285 | 15076.0 |
| 2019-11-27 09:15:00 | AAPL | Stock | 66.28 | 66.29 | 66.2725 | 66.2725 | 7556.0 |
| 2019-11-27 09:20:00 | AAPL | Stock | 66.2875 | 66.325 | 66.25 | 66.325 | 56992.0 |
| 2019-11-27 09:25:00 | AAPL | Stock | 66.3075 | 66.4575 | 66.2975 | 66.4025 | 155472.0 |
| 2019-11-27 09:30:00 | AAPL | Stock | 66.4075 | 66.495 | 66.3375 | 66.4137 | 2930756.0 |
| 2019-11-27 09:35:00 | AAPL | Stock | 66.415 | 66.47 | 66.3275 | 66.4375 | 1329180.0 |
| 2019-11-27 09:40:00 | AAPL | Stock | 66.4375 | 66.46 | 66.3525 | 66.4575 | 1258564.0 |
| 2019-11-27 09:45:00 | AAPL | Stock | 66.4575 | 66.5575 | 66.4475 | 66.5368 | 1641388.0 |
> showing 50 of 361,058 rows — these rows as CSV