PREVIEW / stock_5min / 2019-11-07
file: by_date/stock_5min/2019/2019-11-07.parquet size: 5.8 MB rows: 365,096 symbols: 2,526
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-07 04:00:00 | AAPL | Stock | 64.54 | 64.55 | 64.4375 | 64.5475 | 7004.0 |
| 2019-11-07 04:05:00 | AAPL | Stock | 64.53 | 64.575 | 64.53 | 64.575 | 10944.0 |
| 2019-11-07 04:10:00 | AAPL | Stock | 64.6 | 64.6 | 64.6 | 64.6 | 3592.0 |
| 2019-11-07 04:15:00 | AAPL | Stock | 64.6 | 64.625 | 64.6 | 64.625 | 10248.0 |
| 2019-11-07 04:20:00 | AAPL | Stock | 64.66 | 64.66 | 64.625 | 64.65 | 8000.0 |
| 2019-11-07 04:25:00 | AAPL | Stock | 64.7 | 64.7 | 64.625 | 64.625 | 7720.0 |
| 2019-11-07 04:30:00 | AAPL | Stock | 64.6075 | 64.625 | 64.6075 | 64.625 | 1600.0 |
| 2019-11-07 04:35:00 | AAPL | Stock | 64.635 | 64.64 | 64.635 | 64.64 | 868.0 |
| 2019-11-07 04:40:00 | AAPL | Stock | 64.625 | 64.65 | 64.625 | 64.625 | 6400.0 |
| 2019-11-07 04:45:00 | AAPL | Stock | 64.5875 | 64.6 | 64.5625 | 64.5625 | 9668.0 |
| 2019-11-07 04:50:00 | AAPL | Stock | 64.6 | 64.6 | 64.575 | 64.575 | 3796.0 |
| 2019-11-07 04:55:00 | AAPL | Stock | 64.565 | 64.575 | 64.5525 | 64.5525 | 5232.0 |
| 2019-11-07 05:00:00 | AAPL | Stock | 64.5625 | 64.575 | 64.5625 | 64.575 | 3052.0 |
| 2019-11-07 05:05:00 | AAPL | Stock | 64.575 | 64.575 | 64.575 | 64.575 | 5664.0 |
| 2019-11-07 05:10:00 | AAPL | Stock | 64.575 | 64.595 | 64.575 | 64.595 | 1200.0 |
| 2019-11-07 05:15:00 | AAPL | Stock | 64.5775 | 64.5775 | 64.575 | 64.575 | 6120.0 |
| 2019-11-07 05:20:00 | AAPL | Stock | 64.575 | 64.5875 | 64.575 | 64.575 | 6452.0 |
| 2019-11-07 05:25:00 | AAPL | Stock | 64.575 | 64.575 | 64.575 | 64.575 | 2000.0 |
| 2019-11-07 05:35:00 | AAPL | Stock | 64.55 | 64.55 | 64.55 | 64.55 | 2460.0 |
| 2019-11-07 05:40:00 | AAPL | Stock | 64.5125 | 64.5125 | 64.5 | 64.505 | 4404.0 |
| 2019-11-07 05:50:00 | AAPL | Stock | 64.505 | 64.52 | 64.505 | 64.52 | 4516.0 |
| 2019-11-07 05:55:00 | AAPL | Stock | 64.5 | 64.51 | 64.5 | 64.5 | 4052.0 |
| 2019-11-07 06:00:00 | AAPL | Stock | 64.5175 | 64.52 | 64.5175 | 64.52 | 800.0 |
| 2019-11-07 06:10:00 | AAPL | Stock | 64.5225 | 64.5225 | 64.52 | 64.52 | 1200.0 |
| 2019-11-07 06:15:00 | AAPL | Stock | 64.5 | 64.5 | 64.5 | 64.5 | 3996.0 |
| 2019-11-07 06:20:00 | AAPL | Stock | 64.525 | 64.525 | 64.5125 | 64.5125 | 3600.0 |
| 2019-11-07 06:30:00 | AAPL | Stock | 64.5125 | 64.5125 | 64.5125 | 64.5125 | 3692.0 |
| 2019-11-07 06:40:00 | AAPL | Stock | 64.5125 | 64.5125 | 64.5125 | 64.5125 | 800.0 |
| 2019-11-07 06:45:00 | AAPL | Stock | 64.5225 | 64.5225 | 64.5125 | 64.5125 | 800.0 |
| 2019-11-07 06:50:00 | AAPL | Stock | 64.5 | 64.5 | 64.5 | 64.5 | 972.0 |
| 2019-11-07 06:55:00 | AAPL | Stock | 64.5 | 64.5 | 64.5 | 64.5 | 984.0 |
| 2019-11-07 07:00:00 | AAPL | Stock | 64.5 | 64.72 | 64.485 | 64.675 | 118892.0 |
| 2019-11-07 07:05:00 | AAPL | Stock | 64.6825 | 64.6825 | 64.6275 | 64.6275 | 17784.0 |
| 2019-11-07 07:10:00 | AAPL | Stock | 64.625 | 64.65 | 64.625 | 64.65 | 12716.0 |
| 2019-11-07 07:15:00 | AAPL | Stock | 64.6425 | 64.6425 | 64.6375 | 64.6375 | 10800.0 |
| 2019-11-07 07:20:00 | AAPL | Stock | 64.6375 | 64.675 | 64.6375 | 64.6625 | 37740.0 |
| 2019-11-07 07:25:00 | AAPL | Stock | 64.6425 | 64.655 | 64.6025 | 64.645 | 28748.0 |
| 2019-11-07 07:30:00 | AAPL | Stock | 64.65 | 64.6575 | 64.64 | 64.65 | 14236.0 |
| 2019-11-07 07:35:00 | AAPL | Stock | 64.6575 | 64.6625 | 64.6425 | 64.6425 | 18936.0 |
| 2019-11-07 07:40:00 | AAPL | Stock | 64.6375 | 64.6375 | 64.625 | 64.625 | 6776.0 |
| 2019-11-07 07:45:00 | AAPL | Stock | 64.6125 | 64.62 | 64.6125 | 64.62 | 7200.0 |
| 2019-11-07 07:50:00 | AAPL | Stock | 64.625 | 64.65 | 64.625 | 64.65 | 4452.0 |
| 2019-11-07 07:55:00 | AAPL | Stock | 64.645 | 64.6625 | 64.6325 | 64.655 | 29608.0 |
| 2019-11-07 08:00:00 | AAPL | Stock | 64.6828 | 64.7175 | 64.51 | 64.63 | 184304.0 |
| 2019-11-07 08:05:00 | AAPL | Stock | 64.625 | 64.6525 | 64.6225 | 64.6375 | 30576.0 |
| 2019-11-07 08:10:00 | AAPL | Stock | 64.64 | 64.65 | 64.6375 | 64.65 | 50416.0 |
| 2019-11-07 08:15:00 | AAPL | Stock | 64.65 | 64.6625 | 64.65 | 64.6625 | 24720.0 |
| 2019-11-07 08:20:00 | AAPL | Stock | 64.65 | 64.6575 | 64.625 | 64.6475 | 13568.0 |
| 2019-11-07 08:25:00 | AAPL | Stock | 64.6475 | 64.65 | 64.625 | 64.625 | 7332.0 |
| 2019-11-07 08:30:00 | AAPL | Stock | 64.6375 | 64.65 | 64.6375 | 64.65 | 17824.0 |
> showing 50 of 365,096 rows — these rows as CSV