PREVIEW / stock_5min / 2019-03-04
file: by_date/stock_5min/2019/2019-03-04.parquet size: 5.9 MB rows: 367,800 symbols: 2,653
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-03-04 04:00:00 | AAPL | Stock | 43.8875 | 43.9175 | 43.8775 | 43.9175 | 3920.0 |
| 2019-03-04 04:05:00 | AAPL | Stock | 43.95 | 43.95 | 43.95 | 43.95 | 888.0 |
| 2019-03-04 04:10:00 | AAPL | Stock | 43.95 | 43.95 | 43.95 | 43.95 | 400.0 |
| 2019-03-04 04:15:00 | AAPL | Stock | 43.975 | 43.975 | 43.975 | 43.975 | 400.0 |
| 2019-03-04 04:20:00 | AAPL | Stock | 43.97 | 43.97 | 43.9375 | 43.955 | 7416.0 |
| 2019-03-04 04:25:00 | AAPL | Stock | 43.9375 | 43.9375 | 43.925 | 43.925 | 4000.0 |
| 2019-03-04 04:45:00 | AAPL | Stock | 43.9275 | 43.9275 | 43.925 | 43.925 | 3464.0 |
| 2019-03-04 05:05:00 | AAPL | Stock | 43.88 | 43.88 | 43.8775 | 43.8775 | 800.0 |
| 2019-03-04 05:10:00 | AAPL | Stock | 43.88 | 43.88 | 43.88 | 43.88 | 1952.0 |
| 2019-03-04 05:15:00 | AAPL | Stock | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 400.0 |
| 2019-03-04 05:25:00 | AAPL | Stock | 43.9025 | 43.9025 | 43.9025 | 43.9025 | 400.0 |
| 2019-03-04 05:35:00 | AAPL | Stock | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 400.0 |
| 2019-03-04 05:45:00 | AAPL | Stock | 43.9025 | 43.9025 | 43.9025 | 43.9025 | 2000.0 |
| 2019-03-04 05:50:00 | AAPL | Stock | 43.935 | 43.935 | 43.935 | 43.935 | 400.0 |
| 2019-03-04 06:25:00 | AAPL | Stock | 43.9375 | 43.9425 | 43.9375 | 43.9425 | 11456.0 |
| 2019-03-04 06:35:00 | AAPL | Stock | 43.94 | 43.9425 | 43.94 | 43.9425 | 800.0 |
| 2019-03-04 06:45:00 | AAPL | Stock | 43.9375 | 43.9375 | 43.9375 | 43.9375 | 1992.0 |
| 2019-03-04 06:50:00 | AAPL | Stock | 43.9375 | 43.9375 | 43.9375 | 43.9375 | 800.0 |
| 2019-03-04 06:55:00 | AAPL | Stock | 43.945 | 43.945 | 43.945 | 43.945 | 2048.0 |
| 2019-03-04 07:00:00 | AAPL | Stock | 43.9375 | 43.975 | 43.9 | 43.95 | 16176.0 |
| 2019-03-04 07:05:00 | AAPL | Stock | 43.9575 | 43.98 | 43.9575 | 43.9625 | 3040.0 |
| 2019-03-04 07:10:00 | AAPL | Stock | 43.96 | 43.975 | 43.96 | 43.9725 | 4000.0 |
| 2019-03-04 07:15:00 | AAPL | Stock | 43.975 | 43.9875 | 43.975 | 43.975 | 8360.0 |
| 2019-03-04 07:20:00 | AAPL | Stock | 43.975 | 43.975 | 43.95 | 43.95 | 14168.0 |
| 2019-03-04 07:25:00 | AAPL | Stock | 43.95 | 43.9675 | 43.95 | 43.95 | 19200.0 |
| 2019-03-04 07:30:00 | AAPL | Stock | 43.9525 | 43.9525 | 43.9525 | 43.9525 | 400.0 |
| 2019-03-04 07:35:00 | AAPL | Stock | 43.95 | 43.9625 | 43.945 | 43.945 | 8924.0 |
| 2019-03-04 07:40:00 | AAPL | Stock | 43.945 | 43.95 | 43.94 | 43.95 | 5400.0 |
| 2019-03-04 07:45:00 | AAPL | Stock | 43.94 | 43.94 | 43.9375 | 43.94 | 2236.0 |
| 2019-03-04 07:50:00 | AAPL | Stock | 43.9475 | 43.9475 | 43.9375 | 43.9375 | 10524.0 |
| 2019-03-04 07:55:00 | AAPL | Stock | 43.955 | 43.955 | 43.955 | 43.955 | 1864.0 |
| 2019-03-04 08:00:00 | AAPL | Stock | 43.9698 | 44.0 | 43.9375 | 44.0 | 105388.0 |
| 2019-03-04 08:05:00 | AAPL | Stock | 43.9975 | 43.9975 | 43.975 | 43.975 | 10720.0 |
| 2019-03-04 08:10:00 | AAPL | Stock | 43.965 | 43.98 | 43.9575 | 43.975 | 12152.0 |
| 2019-03-04 08:15:00 | AAPL | Stock | 43.975 | 43.975 | 43.9725 | 43.9725 | 5348.0 |
| 2019-03-04 08:20:00 | AAPL | Stock | 43.975 | 43.9975 | 43.9725 | 43.99 | 42876.0 |
| 2019-03-04 08:25:00 | AAPL | Stock | 43.99 | 43.99 | 43.9775 | 43.985 | 23868.0 |
| 2019-03-04 08:30:00 | AAPL | Stock | 43.985 | 44.0 | 43.9775 | 43.985 | 27256.0 |
| 2019-03-04 08:35:00 | AAPL | Stock | 43.995 | 44.0 | 43.985 | 43.995 | 17268.0 |
| 2019-03-04 08:40:00 | AAPL | Stock | 43.99 | 43.995 | 43.98 | 43.9825 | 11580.0 |
| 2019-03-04 08:45:00 | AAPL | Stock | 43.985 | 43.9875 | 43.9625 | 43.9675 | 27296.0 |
| 2019-03-04 08:50:00 | AAPL | Stock | 43.965 | 43.9675 | 43.945 | 43.945 | 14820.0 |
| 2019-03-04 08:55:00 | AAPL | Stock | 43.95 | 43.96 | 43.9225 | 43.9425 | 24948.0 |
| 2019-03-04 09:00:00 | AAPL | Stock | 43.9625 | 43.985 | 43.9575 | 43.985 | 41988.0 |
| 2019-03-04 09:05:00 | AAPL | Stock | 43.985 | 44.025 | 43.985 | 44.0 | 151356.0 |
| 2019-03-04 09:10:00 | AAPL | Stock | 43.9975 | 43.9975 | 43.99 | 43.995 | 10576.0 |
| 2019-03-04 09:15:00 | AAPL | Stock | 43.99 | 43.99 | 43.9625 | 43.975 | 28060.0 |
| 2019-03-04 09:20:00 | AAPL | Stock | 43.9625 | 43.985 | 43.9625 | 43.985 | 12768.0 |
| 2019-03-04 09:25:00 | AAPL | Stock | 43.9625 | 43.9625 | 43.9 | 43.915 | 33936.0 |
| 2019-03-04 09:30:00 | AAPL | Stock | 43.9175 | 44.2125 | 43.91 | 44.1025 | 4986860.0 |
> showing 50 of 367,800 rows — these rows as CSV