PREVIEW / stock_5min / 2020-07-28
file: by_date/stock_5min/2020/2020-07-28.parquet size: 6.4 MB rows: 400,418 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-07-28 04:20:00 | AAPL | Stock | 95.1375 | 95.1375 | 95.0 | 95.01 | 2800.0 |
| 2020-07-28 04:30:00 | AAPL | Stock | 94.955 | 94.9925 | 94.955 | 94.9925 | 4012.0 |
| 2020-07-28 04:35:00 | AAPL | Stock | 95.01 | 95.01 | 95.01 | 95.01 | 400.0 |
| 2020-07-28 04:40:00 | AAPL | Stock | 95.0125 | 95.1025 | 95.0125 | 95.1025 | 3200.0 |
| 2020-07-28 04:45:00 | AAPL | Stock | 95.125 | 95.125 | 95.0825 | 95.1125 | 1400.0 |
| 2020-07-28 04:55:00 | AAPL | Stock | 95.145 | 95.1525 | 95.145 | 95.15 | 19908.0 |
| 2020-07-28 05:10:00 | AAPL | Stock | 95.22 | 95.22 | 95.22 | 95.22 | 400.0 |
| 2020-07-28 05:15:00 | AAPL | Stock | 95.295 | 95.295 | 95.26 | 95.26 | 2000.0 |
| 2020-07-28 05:20:00 | AAPL | Stock | 95.15 | 95.15 | 95.0 | 95.025 | 8736.0 |
| 2020-07-28 05:45:00 | AAPL | Stock | 95.0975 | 95.0975 | 95.0975 | 95.0975 | 676.0 |
| 2020-07-28 05:50:00 | AAPL | Stock | 95.0 | 95.0075 | 94.85 | 94.85 | 5160.0 |
| 2020-07-28 05:55:00 | AAPL | Stock | 94.625 | 94.745 | 94.6225 | 94.675 | 12796.0 |
| 2020-07-28 06:00:00 | AAPL | Stock | 94.675 | 94.7 | 94.675 | 94.7 | 4260.0 |
| 2020-07-28 06:05:00 | AAPL | Stock | 94.6575 | 94.6575 | 94.5075 | 94.5075 | 5336.0 |
| 2020-07-28 06:10:00 | AAPL | Stock | 94.5275 | 94.5925 | 94.5275 | 94.5925 | 1200.0 |
| 2020-07-28 06:15:00 | AAPL | Stock | 94.5575 | 94.75 | 94.555 | 94.75 | 5120.0 |
| 2020-07-28 06:25:00 | AAPL | Stock | 94.6725 | 94.675 | 94.6725 | 94.6725 | 5200.0 |
| 2020-07-28 06:35:00 | AAPL | Stock | 94.75 | 94.75 | 94.725 | 94.75 | 6300.0 |
| 2020-07-28 06:40:00 | AAPL | Stock | 94.75 | 94.75 | 94.75 | 94.75 | 608.0 |
| 2020-07-28 06:45:00 | AAPL | Stock | 94.75 | 94.75 | 94.75 | 94.75 | 2400.0 |
| 2020-07-28 06:50:00 | AAPL | Stock | 94.75 | 94.75 | 94.75 | 94.75 | 800.0 |
| 2020-07-28 06:55:00 | AAPL | Stock | 94.75 | 94.76 | 94.75 | 94.76 | 5868.0 |
| 2020-07-28 07:00:00 | AAPL | Stock | 94.8075 | 94.9725 | 94.8075 | 94.9125 | 29008.0 |
| 2020-07-28 07:05:00 | AAPL | Stock | 94.9175 | 94.9225 | 94.8525 | 94.8525 | 3680.0 |
| 2020-07-28 07:10:00 | AAPL | Stock | 94.85 | 94.87 | 94.7475 | 94.7975 | 15076.0 |
| 2020-07-28 07:15:00 | AAPL | Stock | 94.765 | 94.765 | 94.625 | 94.625 | 21760.0 |
| 2020-07-28 07:20:00 | AAPL | Stock | 94.6 | 94.635 | 94.5625 | 94.625 | 10848.0 |
| 2020-07-28 07:25:00 | AAPL | Stock | 94.6475 | 94.6475 | 94.625 | 94.625 | 7248.0 |
| 2020-07-28 07:30:00 | AAPL | Stock | 94.595 | 94.595 | 94.425 | 94.45 | 28028.0 |
| 2020-07-28 07:35:00 | AAPL | Stock | 94.4525 | 94.4525 | 94.36 | 94.425 | 37572.0 |
| 2020-07-28 07:40:00 | AAPL | Stock | 94.455 | 94.4575 | 94.4 | 94.45 | 22840.0 |
| 2020-07-28 07:45:00 | AAPL | Stock | 94.455 | 94.585 | 94.4475 | 94.585 | 12964.0 |
| 2020-07-28 07:50:00 | AAPL | Stock | 94.55 | 94.55 | 94.5 | 94.53 | 8336.0 |
| 2020-07-28 07:55:00 | AAPL | Stock | 94.5475 | 94.5475 | 94.5 | 94.5225 | 23532.0 |
| 2020-07-28 08:00:00 | AAPL | Stock | 94.9347 | 94.9875 | 94.3428 | 94.59 | 104044.0 |
| 2020-07-28 08:05:00 | AAPL | Stock | 94.57 | 94.59 | 94.504 | 94.59 | 20368.0 |
| 2020-07-28 08:10:00 | AAPL | Stock | 94.563 | 94.635 | 94.5625 | 94.625 | 6220.0 |
| 2020-07-28 08:15:00 | AAPL | Stock | 94.635 | 94.6575 | 94.5375 | 94.5375 | 22280.0 |
| 2020-07-28 08:20:00 | AAPL | Stock | 94.5425 | 94.555 | 94.525 | 94.555 | 5684.0 |
| 2020-07-28 08:25:00 | AAPL | Stock | 94.5148 | 94.5725 | 94.5 | 94.5725 | 9168.0 |
| 2020-07-28 08:30:00 | AAPL | Stock | 94.575 | 94.6268 | 94.5625 | 94.5625 | 9540.0 |
| 2020-07-28 08:35:00 | AAPL | Stock | 94.5625 | 94.5625 | 94.5625 | 94.5625 | 2336.0 |
| 2020-07-28 08:40:00 | AAPL | Stock | 94.5475 | 94.6275 | 94.5475 | 94.615 | 7396.0 |
| 2020-07-28 08:45:00 | AAPL | Stock | 94.635 | 94.7248 | 94.615 | 94.615 | 10184.0 |
| 2020-07-28 08:50:00 | AAPL | Stock | 94.6375 | 94.65 | 94.6175 | 94.65 | 5520.0 |
| 2020-07-28 08:55:00 | AAPL | Stock | 94.615 | 94.7 | 94.6125 | 94.6975 | 11692.0 |
| 2020-07-28 09:00:00 | AAPL | Stock | 94.675 | 94.6825 | 94.62 | 94.625 | 15232.0 |
| 2020-07-28 09:05:00 | AAPL | Stock | 94.6252 | 94.7 | 94.5775 | 94.6138 | 16360.0 |
| 2020-07-28 09:10:00 | AAPL | Stock | 94.62 | 94.62 | 94.5025 | 94.5075 | 15720.0 |
| 2020-07-28 09:15:00 | AAPL | Stock | 94.52 | 94.595 | 94.4125 | 94.43 | 55436.0 |
> showing 50 of 400,418 rows — these rows as CSV