PREVIEW / stock_5min / 2019-07-11
file: by_date/stock_5min/2019/2019-07-11.parquet size: 5.6 MB rows: 353,555 symbols: 2,591
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 |
|---|---|---|---|---|---|---|---|
| 2019-07-11 04:10:00 | AAPL | Stock | 50.9025 | 50.9025 | 50.9025 | 50.9025 | 3784.0 |
| 2019-07-11 04:35:00 | AAPL | Stock | 50.96 | 50.96 | 50.96 | 50.96 | 704.0 |
| 2019-07-11 04:45:00 | AAPL | Stock | 50.95 | 50.95 | 50.95 | 50.95 | 400.0 |
| 2019-07-11 04:50:00 | AAPL | Stock | 50.94 | 50.94 | 50.94 | 50.94 | 1000.0 |
| 2019-07-11 04:55:00 | AAPL | Stock | 50.925 | 50.925 | 50.925 | 50.925 | 600.0 |
| 2019-07-11 05:00:00 | AAPL | Stock | 50.9375 | 50.9375 | 50.9375 | 50.9375 | 400.0 |
| 2019-07-11 05:05:00 | AAPL | Stock | 50.975 | 50.975 | 50.975 | 50.975 | 400.0 |
| 2019-07-11 05:10:00 | AAPL | Stock | 50.9925 | 50.9925 | 50.9925 | 50.9925 | 880.0 |
| 2019-07-11 05:20:00 | AAPL | Stock | 51.0325 | 51.0325 | 51.0325 | 51.0325 | 1784.0 |
| 2019-07-11 05:25:00 | AAPL | Stock | 51.0325 | 51.0325 | 51.0325 | 51.0325 | 400.0 |
| 2019-07-11 06:00:00 | AAPL | Stock | 51.0275 | 51.0275 | 51.0275 | 51.0275 | 2052.0 |
| 2019-07-11 06:05:00 | AAPL | Stock | 51.0275 | 51.0275 | 50.9875 | 50.9875 | 5216.0 |
| 2019-07-11 06:15:00 | AAPL | Stock | 51.05 | 51.05 | 51.05 | 51.05 | 400.0 |
| 2019-07-11 06:20:00 | AAPL | Stock | 50.9875 | 50.9875 | 50.9875 | 50.9875 | 400.0 |
| 2019-07-11 06:30:00 | AAPL | Stock | 50.975 | 50.975 | 50.91 | 50.91 | 7920.0 |
| 2019-07-11 06:35:00 | AAPL | Stock | 50.9375 | 50.9375 | 50.925 | 50.925 | 800.0 |
| 2019-07-11 06:55:00 | AAPL | Stock | 50.9975 | 50.9975 | 50.9975 | 50.9975 | 400.0 |
| 2019-07-11 07:00:00 | AAPL | Stock | 50.9925 | 50.9925 | 50.9925 | 50.9925 | 400.0 |
| 2019-07-11 07:05:00 | AAPL | Stock | 50.995 | 51.0125 | 50.995 | 51.0125 | 19388.0 |
| 2019-07-11 07:10:00 | AAPL | Stock | 51.0225 | 51.0325 | 51.0125 | 51.0325 | 3600.0 |
| 2019-07-11 07:15:00 | AAPL | Stock | 51.0325 | 51.0475 | 51.025 | 51.0425 | 29948.0 |
| 2019-07-11 07:20:00 | AAPL | Stock | 51.045 | 51.045 | 51.005 | 51.005 | 13948.0 |
| 2019-07-11 07:30:00 | AAPL | Stock | 51.03 | 51.03 | 51.005 | 51.005 | 3956.0 |
| 2019-07-11 07:35:00 | AAPL | Stock | 51.005 | 51.005 | 50.98 | 50.98 | 7792.0 |
| 2019-07-11 07:40:00 | AAPL | Stock | 50.995 | 51.0175 | 50.9875 | 51.0125 | 7400.0 |
| 2019-07-11 07:45:00 | AAPL | Stock | 51.0175 | 51.025 | 50.875 | 50.875 | 66564.0 |
| 2019-07-11 07:50:00 | AAPL | Stock | 50.875 | 50.9325 | 50.85 | 50.9 | 28272.0 |
| 2019-07-11 07:55:00 | AAPL | Stock | 50.935 | 50.9375 | 50.925 | 50.935 | 2400.0 |
| 2019-07-11 08:00:00 | AAPL | Stock | 50.9975 | 51.025 | 50.9575 | 50.9775 | 47384.0 |
| 2019-07-11 08:05:00 | AAPL | Stock | 50.98 | 50.98 | 50.975 | 50.975 | 6340.0 |
| 2019-07-11 08:10:00 | AAPL | Stock | 50.975 | 50.975 | 50.975 | 50.975 | 1156.0 |
| 2019-07-11 08:15:00 | AAPL | Stock | 50.975 | 51.0025 | 50.975 | 51.0 | 6836.0 |
| 2019-07-11 08:20:00 | AAPL | Stock | 51.0 | 51.025 | 50.9925 | 51.005 | 14480.0 |
| 2019-07-11 08:25:00 | AAPL | Stock | 51.0075 | 51.0425 | 51.0075 | 51.0325 | 12248.0 |
| 2019-07-11 08:30:00 | AAPL | Stock | 51.025 | 51.025 | 50.9 | 50.9 | 65488.0 |
| 2019-07-11 08:35:00 | AAPL | Stock | 50.9525 | 50.9925 | 50.9125 | 50.925 | 11492.0 |
| 2019-07-11 08:40:00 | AAPL | Stock | 50.9325 | 50.9875 | 50.9125 | 50.9375 | 16672.0 |
| 2019-07-11 08:45:00 | AAPL | Stock | 50.985 | 51.0075 | 50.95 | 50.95 | 20776.0 |
| 2019-07-11 08:50:00 | AAPL | Stock | 50.95 | 50.9975 | 50.95 | 50.9875 | 5380.0 |
| 2019-07-11 08:55:00 | AAPL | Stock | 50.975 | 50.9875 | 50.95 | 50.9875 | 9800.0 |
| 2019-07-11 09:00:00 | AAPL | Stock | 50.965 | 51.0025 | 50.9525 | 51.0 | 4020.0 |
| 2019-07-11 09:05:00 | AAPL | Stock | 50.975 | 51.0125 | 50.975 | 51.0 | 16544.0 |
| 2019-07-11 09:10:00 | AAPL | Stock | 50.995 | 50.995 | 50.9375 | 50.965 | 61768.0 |
| 2019-07-11 09:15:00 | AAPL | Stock | 50.965 | 50.965 | 50.8875 | 50.8875 | 60536.0 |
| 2019-07-11 09:20:00 | AAPL | Stock | 50.8875 | 50.89 | 50.8625 | 50.8675 | 59688.0 |
| 2019-07-11 09:25:00 | AAPL | Stock | 50.8625 | 50.8625 | 50.805 | 50.815 | 26720.0 |
| 2019-07-11 09:30:00 | AAPL | Stock | 50.8375 | 51.0975 | 50.7752 | 51.069 | 3442020.0 |
| 2019-07-11 09:35:00 | AAPL | Stock | 51.0625 | 51.095 | 50.9675 | 51.045 | 1579152.0 |
| 2019-07-11 09:40:00 | AAPL | Stock | 51.05 | 51.05 | 50.94 | 50.9925 | 1073976.0 |
| 2019-07-11 09:45:00 | AAPL | Stock | 50.9975 | 51.0275 | 50.9005 | 50.92 | 1709888.0 |
> showing 50 of 353,555 rows — these rows as CSV