PREVIEW / stock_5min / 2020-06-02
file: by_date/stock_5min/2020/2020-06-02.parquet size: 6.5 MB rows: 408,792 symbols: 2,410
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-06-02 04:00:00 | AAPL | Stock | 80.6225 | 80.645 | 80.6225 | 80.645 | 800.0 |
| 2020-06-02 04:05:00 | AAPL | Stock | 80.625 | 80.65 | 80.625 | 80.65 | 20352.0 |
| 2020-06-02 04:10:00 | AAPL | Stock | 80.65 | 80.65 | 80.65 | 80.65 | 1200.0 |
| 2020-06-02 04:15:00 | AAPL | Stock | 80.67 | 80.75 | 80.67 | 80.735 | 8316.0 |
| 2020-06-02 04:25:00 | AAPL | Stock | 80.7175 | 80.7175 | 80.7175 | 80.7175 | 964.0 |
| 2020-06-02 04:30:00 | AAPL | Stock | 80.7475 | 80.75 | 80.7475 | 80.75 | 8856.0 |
| 2020-06-02 04:45:00 | AAPL | Stock | 80.875 | 80.9 | 80.875 | 80.9 | 3404.0 |
| 2020-06-02 04:50:00 | AAPL | Stock | 80.905 | 80.905 | 80.905 | 80.905 | 400.0 |
| 2020-06-02 05:00:00 | AAPL | Stock | 80.8525 | 80.8525 | 80.8525 | 80.8525 | 1200.0 |
| 2020-06-02 05:05:00 | AAPL | Stock | 80.9325 | 80.9325 | 80.9325 | 80.9325 | 400.0 |
| 2020-06-02 05:20:00 | AAPL | Stock | 80.885 | 80.895 | 80.885 | 80.895 | 1744.0 |
| 2020-06-02 05:25:00 | AAPL | Stock | 80.8925 | 80.9 | 80.8925 | 80.9 | 3608.0 |
| 2020-06-02 05:30:00 | AAPL | Stock | 80.9125 | 80.945 | 80.9 | 80.945 | 2360.0 |
| 2020-06-02 05:40:00 | AAPL | Stock | 80.9975 | 80.9975 | 80.9975 | 80.9975 | 608.0 |
| 2020-06-02 06:05:00 | AAPL | Stock | 80.98 | 80.995 | 80.9775 | 80.995 | 2032.0 |
| 2020-06-02 06:10:00 | AAPL | Stock | 80.9525 | 80.985 | 80.945 | 80.985 | 1988.0 |
| 2020-06-02 06:15:00 | AAPL | Stock | 80.985 | 80.985 | 80.95 | 80.95 | 1996.0 |
| 2020-06-02 06:30:00 | AAPL | Stock | 80.8775 | 80.8775 | 80.875 | 80.875 | 1600.0 |
| 2020-06-02 06:35:00 | AAPL | Stock | 80.8525 | 80.8525 | 80.85 | 80.85 | 1200.0 |
| 2020-06-02 06:45:00 | AAPL | Stock | 80.95 | 80.995 | 80.9475 | 80.995 | 2812.0 |
| 2020-06-02 06:55:00 | AAPL | Stock | 80.9475 | 80.9475 | 80.9475 | 80.9475 | 8856.0 |
| 2020-06-02 07:00:00 | AAPL | Stock | 80.8625 | 80.96 | 80.7575 | 80.8825 | 33184.0 |
| 2020-06-02 07:05:00 | AAPL | Stock | 80.9 | 80.905 | 80.9 | 80.905 | 8680.0 |
| 2020-06-02 07:10:00 | AAPL | Stock | 80.915 | 80.925 | 80.905 | 80.9075 | 12592.0 |
| 2020-06-02 07:15:00 | AAPL | Stock | 80.9025 | 80.9025 | 80.8275 | 80.8275 | 23672.0 |
| 2020-06-02 07:20:00 | AAPL | Stock | 80.8575 | 80.8575 | 80.6875 | 80.6875 | 32836.0 |
| 2020-06-02 07:25:00 | AAPL | Stock | 80.7 | 80.7 | 80.5125 | 80.575 | 40416.0 |
| 2020-06-02 07:30:00 | AAPL | Stock | 80.625 | 80.625 | 80.5425 | 80.5425 | 10776.0 |
| 2020-06-02 07:35:00 | AAPL | Stock | 80.555 | 80.625 | 80.555 | 80.6 | 15012.0 |
| 2020-06-02 07:40:00 | AAPL | Stock | 80.5975 | 80.6 | 80.5425 | 80.5425 | 37812.0 |
| 2020-06-02 07:45:00 | AAPL | Stock | 80.5725 | 80.685 | 80.535 | 80.5825 | 39164.0 |
| 2020-06-02 07:50:00 | AAPL | Stock | 80.5875 | 80.5875 | 80.3325 | 80.35 | 80548.0 |
| 2020-06-02 07:55:00 | AAPL | Stock | 80.35 | 80.35 | 80.2025 | 80.3125 | 57812.0 |
| 2020-06-02 08:00:00 | AAPL | Stock | 80.8075 | 80.9538 | 80.1975 | 80.35 | 89384.0 |
| 2020-06-02 08:05:00 | AAPL | Stock | 80.35 | 80.3675 | 80.3125 | 80.315 | 29576.0 |
| 2020-06-02 08:10:00 | AAPL | Stock | 80.3 | 80.375 | 80.25 | 80.3375 | 48044.0 |
| 2020-06-02 08:15:00 | AAPL | Stock | 80.34 | 80.3825 | 80.29 | 80.3725 | 28476.0 |
| 2020-06-02 08:20:00 | AAPL | Stock | 80.33 | 80.33 | 80.1 | 80.1 | 117028.0 |
| 2020-06-02 08:25:00 | AAPL | Stock | 80.185 | 80.1875 | 80.05 | 80.175 | 66780.0 |
| 2020-06-02 08:30:00 | AAPL | Stock | 80.2 | 80.2875 | 80.15 | 80.2875 | 18004.0 |
| 2020-06-02 08:35:00 | AAPL | Stock | 80.2878 | 80.325 | 80.25 | 80.255 | 29976.0 |
| 2020-06-02 08:40:00 | AAPL | Stock | 80.2625 | 80.2625 | 80.1 | 80.1875 | 59296.0 |
| 2020-06-02 08:45:00 | AAPL | Stock | 80.2 | 80.2 | 80.065 | 80.1 | 80304.0 |
| 2020-06-02 08:50:00 | AAPL | Stock | 80.1 | 80.1725 | 80.0725 | 80.1725 | 15032.0 |
| 2020-06-02 08:55:00 | AAPL | Stock | 80.1725 | 80.2375 | 80.155 | 80.225 | 21508.0 |
| 2020-06-02 09:00:00 | AAPL | Stock | 80.225 | 80.2375 | 80.1275 | 80.155 | 37360.0 |
| 2020-06-02 09:05:00 | AAPL | Stock | 80.2475 | 80.25 | 80.175 | 80.25 | 11560.0 |
| 2020-06-02 09:10:00 | AAPL | Stock | 80.2475 | 80.375 | 80.2475 | 80.3325 | 36928.0 |
| 2020-06-02 09:15:00 | AAPL | Stock | 80.35 | 80.3575 | 80.27 | 80.325 | 47720.0 |
| 2020-06-02 09:20:00 | AAPL | Stock | 80.3375 | 80.375 | 80.325 | 80.36 | 53836.0 |
> showing 50 of 408,792 rows — these rows as CSV