PREVIEW / stock_5min / 2020-03-02
file: by_date/stock_5min/2020/2020-03-02.parquet size: 6.6 MB rows: 404,679 symbols: 2,447
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-03-02 04:00:00 | AAPL | Stock | 70.75 | 71.03 | 70.16 | 71.03 | 147116.0 |
| 2020-03-02 04:05:00 | AAPL | Stock | 71.0 | 71.21 | 71.0 | 71.0475 | 102880.0 |
| 2020-03-02 04:10:00 | AAPL | Stock | 71.0275 | 71.15 | 70.65 | 70.65 | 59140.0 |
| 2020-03-02 04:15:00 | AAPL | Stock | 70.575 | 70.675 | 70.41 | 70.5125 | 27276.0 |
| 2020-03-02 04:20:00 | AAPL | Stock | 70.6375 | 71.0 | 70.6375 | 71.0 | 17408.0 |
| 2020-03-02 04:25:00 | AAPL | Stock | 70.925 | 70.925 | 70.75 | 70.75 | 11388.0 |
| 2020-03-02 04:30:00 | AAPL | Stock | 70.7875 | 70.7875 | 70.0 | 70.3525 | 51960.0 |
| 2020-03-02 04:35:00 | AAPL | Stock | 70.3775 | 70.5 | 70.35 | 70.35 | 34072.0 |
| 2020-03-02 04:40:00 | AAPL | Stock | 70.32 | 70.325 | 69.7525 | 69.7525 | 23816.0 |
| 2020-03-02 04:45:00 | AAPL | Stock | 69.7525 | 70.4325 | 69.75 | 70.4325 | 13396.0 |
| 2020-03-02 04:50:00 | AAPL | Stock | 70.25 | 70.25 | 70.0125 | 70.0125 | 7020.0 |
| 2020-03-02 04:55:00 | AAPL | Stock | 70.0 | 70.12 | 69.78 | 70.0 | 22392.0 |
| 2020-03-02 05:00:00 | AAPL | Stock | 70.1 | 70.2 | 70.05 | 70.17 | 8320.0 |
| 2020-03-02 05:05:00 | AAPL | Stock | 70.0875 | 70.0875 | 70.0 | 70.0 | 2400.0 |
| 2020-03-02 05:10:00 | AAPL | Stock | 70.08 | 70.125 | 69.8875 | 69.93 | 39312.0 |
| 2020-03-02 05:15:00 | AAPL | Stock | 69.93 | 70.25 | 69.925 | 70.2425 | 10200.0 |
| 2020-03-02 05:20:00 | AAPL | Stock | 70.1875 | 70.2425 | 69.9775 | 69.9975 | 22004.0 |
| 2020-03-02 05:25:00 | AAPL | Stock | 69.995 | 70.1575 | 69.995 | 70.1575 | 15460.0 |
| 2020-03-02 05:30:00 | AAPL | Stock | 70.1925 | 70.3225 | 70.1925 | 70.3225 | 11792.0 |
| 2020-03-02 05:35:00 | AAPL | Stock | 70.25 | 70.3475 | 70.25 | 70.3475 | 1200.0 |
| 2020-03-02 05:40:00 | AAPL | Stock | 70.325 | 70.325 | 70.1 | 70.25 | 56104.0 |
| 2020-03-02 05:45:00 | AAPL | Stock | 70.3125 | 70.3525 | 69.8275 | 69.8275 | 53308.0 |
| 2020-03-02 05:50:00 | AAPL | Stock | 69.95 | 69.95 | 69.825 | 69.875 | 24184.0 |
| 2020-03-02 05:55:00 | AAPL | Stock | 69.995 | 70.05 | 69.81 | 69.81 | 11860.0 |
| 2020-03-02 06:00:00 | AAPL | Stock | 69.7675 | 69.7675 | 69.3075 | 69.3075 | 31028.0 |
| 2020-03-02 06:05:00 | AAPL | Stock | 69.4925 | 69.595 | 69.4 | 69.495 | 6380.0 |
| 2020-03-02 06:10:00 | AAPL | Stock | 69.4525 | 69.4525 | 69.0275 | 69.1875 | 14824.0 |
| 2020-03-02 06:15:00 | AAPL | Stock | 69.155 | 69.5925 | 69.15 | 69.5925 | 33936.0 |
| 2020-03-02 06:20:00 | AAPL | Stock | 69.5925 | 69.625 | 69.475 | 69.475 | 7484.0 |
| 2020-03-02 06:25:00 | AAPL | Stock | 69.4525 | 69.4525 | 69.0825 | 69.0825 | 10468.0 |
| 2020-03-02 06:30:00 | AAPL | Stock | 69.0825 | 69.1475 | 68.84 | 68.84 | 9420.0 |
| 2020-03-02 06:35:00 | AAPL | Stock | 68.83 | 69.095 | 68.83 | 69.095 | 20412.0 |
| 2020-03-02 06:40:00 | AAPL | Stock | 68.9625 | 69.0 | 68.625 | 68.775 | 16384.0 |
| 2020-03-02 06:45:00 | AAPL | Stock | 68.75 | 69.05 | 68.75 | 69.0125 | 9968.0 |
| 2020-03-02 06:50:00 | AAPL | Stock | 68.9875 | 68.9875 | 68.675 | 68.675 | 3276.0 |
| 2020-03-02 06:55:00 | AAPL | Stock | 68.67 | 68.67 | 68.25 | 68.4325 | 49164.0 |
| 2020-03-02 07:00:00 | AAPL | Stock | 68.425 | 69.0 | 68.16 | 68.8125 | 141792.0 |
| 2020-03-02 07:05:00 | AAPL | Stock | 68.82 | 69.0 | 68.7 | 68.9225 | 95552.0 |
| 2020-03-02 07:10:00 | AAPL | Stock | 68.9875 | 69.075 | 68.775 | 68.825 | 156180.0 |
| 2020-03-02 07:15:00 | AAPL | Stock | 68.9125 | 69.075 | 68.875 | 68.875 | 26536.0 |
| 2020-03-02 07:20:00 | AAPL | Stock | 68.875 | 69.1375 | 68.8 | 69.1375 | 65060.0 |
| 2020-03-02 07:25:00 | AAPL | Stock | 69.1225 | 69.3125 | 69.065 | 69.2875 | 73452.0 |
| 2020-03-02 07:30:00 | AAPL | Stock | 69.2975 | 69.4325 | 69.075 | 69.1875 | 80692.0 |
| 2020-03-02 07:35:00 | AAPL | Stock | 69.19 | 69.4425 | 69.1525 | 69.3275 | 35696.0 |
| 2020-03-02 07:40:00 | AAPL | Stock | 69.33 | 69.5 | 69.29 | 69.3 | 74508.0 |
| 2020-03-02 07:45:00 | AAPL | Stock | 69.35 | 69.4875 | 69.2 | 69.275 | 71584.0 |
| 2020-03-02 07:50:00 | AAPL | Stock | 69.25 | 69.2875 | 69.1875 | 69.2225 | 42460.0 |
| 2020-03-02 07:55:00 | AAPL | Stock | 69.2475 | 69.6025 | 69.2425 | 69.5375 | 105032.0 |
| 2020-03-02 08:00:00 | AAPL | Stock | 68.875 | 69.6275 | 68.625 | 69.4 | 598116.0 |
| 2020-03-02 08:05:00 | AAPL | Stock | 69.4125 | 69.5 | 69.25 | 69.3 | 155064.0 |
> showing 50 of 404,679 rows — these rows as CSV