PREVIEW / stock_5min / 2020-01-06
file: by_date/stock_5min/2020/2020-01-06.parquet size: 6.0 MB rows: 373,905 symbols: 2,475
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-01-06 04:00:00 | AAPL | Stock | 73.8575 | 73.8775 | 73.55 | 73.6925 | 7300.0 |
| 2020-01-06 04:05:00 | AAPL | Stock | 73.6925 | 73.75 | 73.68 | 73.7425 | 5404.0 |
| 2020-01-06 04:10:00 | AAPL | Stock | 73.6625 | 73.6625 | 73.625 | 73.65 | 12828.0 |
| 2020-01-06 04:15:00 | AAPL | Stock | 73.6625 | 73.6625 | 73.6375 | 73.6375 | 2280.0 |
| 2020-01-06 04:20:00 | AAPL | Stock | 73.515 | 73.575 | 73.49 | 73.55 | 14480.0 |
| 2020-01-06 04:25:00 | AAPL | Stock | 73.575 | 73.595 | 73.55 | 73.575 | 14096.0 |
| 2020-01-06 04:30:00 | AAPL | Stock | 73.5625 | 73.575 | 73.5375 | 73.575 | 6800.0 |
| 2020-01-06 04:35:00 | AAPL | Stock | 73.575 | 73.575 | 73.555 | 73.555 | 2672.0 |
| 2020-01-06 04:40:00 | AAPL | Stock | 73.54 | 73.625 | 73.5 | 73.5375 | 27276.0 |
| 2020-01-06 04:45:00 | AAPL | Stock | 73.65 | 73.6625 | 73.65 | 73.65 | 3204.0 |
| 2020-01-06 04:50:00 | AAPL | Stock | 73.725 | 73.725 | 73.6875 | 73.7 | 10920.0 |
| 2020-01-06 04:55:00 | AAPL | Stock | 73.725 | 73.725 | 73.725 | 73.725 | 3560.0 |
| 2020-01-06 05:00:00 | AAPL | Stock | 73.725 | 73.73 | 73.7 | 73.73 | 19060.0 |
| 2020-01-06 05:05:00 | AAPL | Stock | 73.7425 | 73.825 | 73.7425 | 73.8 | 8644.0 |
| 2020-01-06 05:10:00 | AAPL | Stock | 73.8 | 73.8 | 73.7775 | 73.7975 | 4800.0 |
| 2020-01-06 05:15:00 | AAPL | Stock | 73.7775 | 73.7775 | 73.7775 | 73.7775 | 1896.0 |
| 2020-01-06 05:30:00 | AAPL | Stock | 73.6825 | 73.6875 | 73.6825 | 73.6875 | 1800.0 |
| 2020-01-06 05:35:00 | AAPL | Stock | 73.7225 | 73.7225 | 73.68 | 73.68 | 2364.0 |
| 2020-01-06 05:40:00 | AAPL | Stock | 73.6725 | 73.6875 | 73.6725 | 73.6875 | 2488.0 |
| 2020-01-06 05:50:00 | AAPL | Stock | 73.6975 | 73.7375 | 73.6975 | 73.7375 | 17608.0 |
| 2020-01-06 06:00:00 | AAPL | Stock | 73.6775 | 73.7375 | 73.675 | 73.675 | 7060.0 |
| 2020-01-06 06:05:00 | AAPL | Stock | 73.675 | 73.675 | 73.475 | 73.6 | 29072.0 |
| 2020-01-06 06:10:00 | AAPL | Stock | 73.5925 | 73.615 | 73.575 | 73.615 | 10412.0 |
| 2020-01-06 06:15:00 | AAPL | Stock | 73.6025 | 73.625 | 73.6025 | 73.6025 | 2636.0 |
| 2020-01-06 06:20:00 | AAPL | Stock | 73.67 | 73.7625 | 73.67 | 73.7625 | 8416.0 |
| 2020-01-06 06:25:00 | AAPL | Stock | 73.7625 | 73.78 | 73.75 | 73.78 | 7984.0 |
| 2020-01-06 06:30:00 | AAPL | Stock | 73.7725 | 73.7725 | 73.75 | 73.75 | 3120.0 |
| 2020-01-06 06:35:00 | AAPL | Stock | 73.705 | 73.725 | 73.6375 | 73.6375 | 18568.0 |
| 2020-01-06 06:40:00 | AAPL | Stock | 73.6875 | 73.72 | 73.63 | 73.68 | 17896.0 |
| 2020-01-06 06:45:00 | AAPL | Stock | 73.65 | 73.65 | 73.5625 | 73.6075 | 10896.0 |
| 2020-01-06 06:55:00 | AAPL | Stock | 73.63 | 73.675 | 73.6125 | 73.675 | 4000.0 |
| 2020-01-06 07:00:00 | AAPL | Stock | 73.685 | 73.7825 | 73.62 | 73.7375 | 113024.0 |
| 2020-01-06 07:05:00 | AAPL | Stock | 73.765 | 73.8125 | 73.745 | 73.76 | 53832.0 |
| 2020-01-06 07:10:00 | AAPL | Stock | 73.76 | 73.7725 | 73.725 | 73.77 | 43264.0 |
| 2020-01-06 07:15:00 | AAPL | Stock | 73.8 | 73.8 | 73.7625 | 73.775 | 17808.0 |
| 2020-01-06 07:20:00 | AAPL | Stock | 73.78 | 73.82 | 73.775 | 73.82 | 11696.0 |
| 2020-01-06 07:25:00 | AAPL | Stock | 73.825 | 73.875 | 73.825 | 73.875 | 23528.0 |
| 2020-01-06 07:30:00 | AAPL | Stock | 73.8475 | 73.8475 | 73.6025 | 73.6025 | 109460.0 |
| 2020-01-06 07:35:00 | AAPL | Stock | 73.6225 | 73.7975 | 73.6225 | 73.745 | 41844.0 |
| 2020-01-06 07:40:00 | AAPL | Stock | 73.73 | 73.745 | 73.605 | 73.675 | 95504.0 |
| 2020-01-06 07:45:00 | AAPL | Stock | 73.685 | 73.785 | 73.6375 | 73.745 | 30940.0 |
| 2020-01-06 07:50:00 | AAPL | Stock | 73.745 | 73.745 | 73.6875 | 73.6875 | 14532.0 |
| 2020-01-06 07:55:00 | AAPL | Stock | 73.69 | 73.725 | 73.665 | 73.6875 | 33648.0 |
| 2020-01-06 08:00:00 | AAPL | Stock | 73.7625 | 73.875 | 73.575 | 73.5925 | 365484.0 |
| 2020-01-06 08:05:00 | AAPL | Stock | 73.61 | 73.6275 | 73.57 | 73.6125 | 69040.0 |
| 2020-01-06 08:10:00 | AAPL | Stock | 73.65 | 73.7125 | 73.6125 | 73.6125 | 95544.0 |
| 2020-01-06 08:15:00 | AAPL | Stock | 73.6025 | 73.715 | 73.575 | 73.7 | 86908.0 |
| 2020-01-06 08:20:00 | AAPL | Stock | 73.695 | 73.725 | 73.665 | 73.6675 | 38388.0 |
| 2020-01-06 08:25:00 | AAPL | Stock | 73.7125 | 73.725 | 73.675 | 73.7238 | 18592.0 |
| 2020-01-06 08:30:00 | AAPL | Stock | 73.7292 | 73.7292 | 73.6275 | 73.6375 | 43904.0 |
> showing 50 of 373,905 rows — these rows as CSV