PREVIEW / stock_5min / 2018-10-02
file: by_date/stock_5min/2018/2018-10-02.parquet size: 5.8 MB rows: 360,424 symbols: 2,786
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-02 06:00:00 | AAPL | Stock | 56.4375 | 56.525 | 56.4175 | 56.4775 | 10000.0 |
| 2018-10-02 06:05:00 | AAPL | Stock | 56.5125 | 56.56 | 56.5125 | 56.56 | 2404.0 |
| 2018-10-02 06:10:00 | AAPL | Stock | 56.525 | 56.525 | 56.525 | 56.525 | 400.0 |
| 2018-10-02 06:25:00 | AAPL | Stock | 56.55 | 56.55 | 56.55 | 56.55 | 800.0 |
| 2018-10-02 06:30:00 | AAPL | Stock | 56.5 | 56.5 | 56.4575 | 56.4575 | 800.0 |
| 2018-10-02 06:40:00 | AAPL | Stock | 56.5 | 56.5275 | 56.5 | 56.5 | 12332.0 |
| 2018-10-02 06:45:00 | AAPL | Stock | 56.525 | 56.525 | 56.525 | 56.525 | 400.0 |
| 2018-10-02 06:50:00 | AAPL | Stock | 56.5 | 56.5125 | 56.5 | 56.5125 | 2220.0 |
| 2018-10-02 06:55:00 | AAPL | Stock | 56.5625 | 56.5625 | 56.495 | 56.5175 | 19768.0 |
| 2018-10-02 07:00:00 | AAPL | Stock | 56.5375 | 56.5675 | 56.5125 | 56.5675 | 21252.0 |
| 2018-10-02 07:05:00 | AAPL | Stock | 56.605 | 56.66 | 56.605 | 56.66 | 16436.0 |
| 2018-10-02 07:10:00 | AAPL | Stock | 56.65 | 56.675 | 56.65 | 56.65 | 17800.0 |
| 2018-10-02 07:15:00 | AAPL | Stock | 56.645 | 56.645 | 56.635 | 56.635 | 1600.0 |
| 2018-10-02 07:20:00 | AAPL | Stock | 56.63 | 56.63 | 56.5975 | 56.5975 | 12596.0 |
| 2018-10-02 07:25:00 | AAPL | Stock | 56.585 | 56.675 | 56.585 | 56.65 | 55480.0 |
| 2018-10-02 07:30:00 | AAPL | Stock | 56.6525 | 56.675 | 56.6375 | 56.675 | 3600.0 |
| 2018-10-02 07:35:00 | AAPL | Stock | 56.6925 | 56.6925 | 56.6875 | 56.6875 | 1500.0 |
| 2018-10-02 07:40:00 | AAPL | Stock | 56.675 | 56.675 | 56.675 | 56.675 | 400.0 |
| 2018-10-02 07:45:00 | AAPL | Stock | 56.66 | 56.66 | 56.65 | 56.65 | 2000.0 |
| 2018-10-02 07:50:00 | AAPL | Stock | 56.6525 | 56.67 | 56.6525 | 56.67 | 2400.0 |
| 2018-10-02 07:55:00 | AAPL | Stock | 56.66 | 56.66 | 56.66 | 56.66 | 1360.0 |
| 2018-10-02 08:00:00 | AAPL | Stock | 56.5562 | 56.95 | 56.5562 | 56.73 | 72292.0 |
| 2018-10-02 08:05:00 | AAPL | Stock | 56.725 | 56.7625 | 56.725 | 56.75 | 10732.0 |
| 2018-10-02 08:10:00 | AAPL | Stock | 56.7625 | 56.7625 | 56.7425 | 56.7625 | 22760.0 |
| 2018-10-02 08:15:00 | AAPL | Stock | 56.76 | 56.765 | 56.76 | 56.765 | 4128.0 |
| 2018-10-02 08:20:00 | AAPL | Stock | 56.755 | 56.755 | 56.755 | 56.755 | 4400.0 |
| 2018-10-02 08:25:00 | AAPL | Stock | 56.755 | 56.765 | 56.755 | 56.765 | 2800.0 |
| 2018-10-02 08:30:00 | AAPL | Stock | 56.765 | 56.78 | 56.725 | 56.765 | 27644.0 |
| 2018-10-02 08:35:00 | AAPL | Stock | 56.7375 | 56.7625 | 56.725 | 56.725 | 16920.0 |
| 2018-10-02 08:40:00 | AAPL | Stock | 56.725 | 56.7475 | 56.725 | 56.7475 | 9128.0 |
| 2018-10-02 08:45:00 | AAPL | Stock | 56.725 | 56.725 | 56.7125 | 56.72 | 10048.0 |
| 2018-10-02 08:50:00 | AAPL | Stock | 56.725 | 56.7475 | 56.7225 | 56.7475 | 18296.0 |
| 2018-10-02 08:55:00 | AAPL | Stock | 56.75 | 56.7625 | 56.7375 | 56.75 | 30420.0 |
| 2018-10-02 09:00:00 | AAPL | Stock | 56.77 | 56.775 | 56.75 | 56.7625 | 10880.0 |
| 2018-10-02 09:05:00 | AAPL | Stock | 56.75 | 56.75 | 56.7325 | 56.7375 | 4764.0 |
| 2018-10-02 09:10:00 | AAPL | Stock | 56.76 | 56.78 | 56.76 | 56.7762 | 21512.0 |
| 2018-10-02 09:15:00 | AAPL | Stock | 56.7725 | 56.8 | 56.77 | 56.8 | 5124.0 |
| 2018-10-02 09:20:00 | AAPL | Stock | 56.7775 | 56.7875 | 56.745 | 56.745 | 13920.0 |
| 2018-10-02 09:25:00 | AAPL | Stock | 56.73 | 56.8275 | 56.725 | 56.8275 | 40500.0 |
| 2018-10-02 09:30:00 | AAPL | Stock | 56.8275 | 57.05 | 56.75 | 56.955 | 3004580.0 |
| 2018-10-02 09:35:00 | AAPL | Stock | 56.965 | 57.005 | 56.672 | 56.8025 | 2075076.0 |
| 2018-10-02 09:40:00 | AAPL | Stock | 56.806 | 56.9625 | 56.6575 | 56.9562 | 1637176.0 |
| 2018-10-02 09:45:00 | AAPL | Stock | 56.95 | 57.1125 | 56.95 | 57.0578 | 1847168.0 |
| 2018-10-02 09:50:00 | AAPL | Stock | 57.0575 | 57.1625 | 57.0485 | 57.1 | 1753724.0 |
| 2018-10-02 09:55:00 | AAPL | Stock | 57.1 | 57.335 | 57.0925 | 57.3075 | 2724340.0 |
| 2018-10-02 10:00:00 | AAPL | Stock | 57.31 | 57.3575 | 57.255 | 57.29 | 1622328.0 |
| 2018-10-02 10:05:00 | AAPL | Stock | 57.2925 | 57.3025 | 57.2075 | 57.21 | 1270144.0 |
| 2018-10-02 10:10:00 | AAPL | Stock | 57.2135 | 57.24 | 57.14 | 57.185 | 1114544.0 |
| 2018-10-02 10:15:00 | AAPL | Stock | 57.185 | 57.2225 | 57.14 | 57.17 | 1016492.0 |
| 2018-10-02 10:20:00 | AAPL | Stock | 57.175 | 57.22 | 57.1425 | 57.21 | 929956.0 |
> showing 50 of 360,424 rows — these rows as CSV