PREVIEW / stock_5min / 2018-01-18
file: by_date/stock_5min/2018/2018-01-18.parquet size: 5.7 MB rows: 366,894 symbols: 2,898
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-01-18 04:00:00 | AAPL | Stock | 44.815 | 44.815 | 44.75 | 44.75 | 2800.0 |
| 2018-01-18 04:05:00 | AAPL | Stock | 44.7525 | 44.7525 | 44.7525 | 44.7525 | 1640.0 |
| 2018-01-18 04:10:00 | AAPL | Stock | 44.7275 | 44.7275 | 44.7 | 44.7 | 11596.0 |
| 2018-01-18 04:15:00 | AAPL | Stock | 44.7 | 44.7 | 44.7 | 44.7 | 6000.0 |
| 2018-01-18 04:20:00 | AAPL | Stock | 44.7 | 44.7 | 44.7 | 44.7 | 1880.0 |
| 2018-01-18 04:25:00 | AAPL | Stock | 44.7175 | 44.7175 | 44.7175 | 44.7175 | 7120.0 |
| 2018-01-18 04:30:00 | AAPL | Stock | 44.7125 | 44.7125 | 44.7125 | 44.7125 | 1380.0 |
| 2018-01-18 04:35:00 | AAPL | Stock | 44.7125 | 44.7125 | 44.7125 | 44.7125 | 800.0 |
| 2018-01-18 04:45:00 | AAPL | Stock | 44.825 | 44.825 | 44.8125 | 44.8125 | 1920.0 |
| 2018-01-18 04:55:00 | AAPL | Stock | 44.8 | 44.8 | 44.8 | 44.8 | 1600.0 |
| 2018-01-18 05:30:00 | AAPL | Stock | 44.775 | 44.775 | 44.775 | 44.775 | 7552.0 |
| 2018-01-18 05:45:00 | AAPL | Stock | 44.8 | 44.8 | 44.8 | 44.8 | 800.0 |
| 2018-01-18 06:00:00 | AAPL | Stock | 44.7775 | 44.7775 | 44.775 | 44.775 | 4796.0 |
| 2018-01-18 06:10:00 | AAPL | Stock | 44.775 | 44.775 | 44.7725 | 44.775 | 8008.0 |
| 2018-01-18 06:20:00 | AAPL | Stock | 44.8 | 44.8 | 44.8 | 44.8 | 1600.0 |
| 2018-01-18 06:25:00 | AAPL | Stock | 44.8475 | 44.8725 | 44.8475 | 44.8725 | 19200.0 |
| 2018-01-18 06:30:00 | AAPL | Stock | 44.8725 | 44.8725 | 44.8725 | 44.8725 | 400.0 |
| 2018-01-18 06:35:00 | AAPL | Stock | 44.8725 | 44.8725 | 44.8725 | 44.8725 | 440.0 |
| 2018-01-18 06:40:00 | AAPL | Stock | 44.8725 | 44.8725 | 44.8725 | 44.8725 | 1600.0 |
| 2018-01-18 06:45:00 | AAPL | Stock | 44.8725 | 44.8725 | 44.8525 | 44.87 | 1600.0 |
| 2018-01-18 06:50:00 | AAPL | Stock | 44.87 | 44.87 | 44.85 | 44.85 | 800.0 |
| 2018-01-18 06:55:00 | AAPL | Stock | 44.87 | 44.87 | 44.87 | 44.87 | 400.0 |
| 2018-01-18 07:00:00 | AAPL | Stock | 44.87 | 44.9325 | 44.87 | 44.9125 | 59580.0 |
| 2018-01-18 07:05:00 | AAPL | Stock | 44.91 | 44.91 | 44.9 | 44.91 | 2492.0 |
| 2018-01-18 07:10:00 | AAPL | Stock | 44.91 | 44.925 | 44.9 | 44.925 | 14168.0 |
| 2018-01-18 07:15:00 | AAPL | Stock | 44.91 | 44.91 | 44.895 | 44.895 | 6388.0 |
| 2018-01-18 07:20:00 | AAPL | Stock | 44.895 | 44.895 | 44.875 | 44.8875 | 17240.0 |
| 2018-01-18 07:25:00 | AAPL | Stock | 44.875 | 44.875 | 44.8725 | 44.8725 | 4540.0 |
| 2018-01-18 07:30:00 | AAPL | Stock | 44.875 | 44.875 | 44.865 | 44.875 | 11656.0 |
| 2018-01-18 07:35:00 | AAPL | Stock | 44.8625 | 44.8625 | 44.8275 | 44.8275 | 52068.0 |
| 2018-01-18 07:40:00 | AAPL | Stock | 44.8225 | 44.8225 | 44.7975 | 44.81 | 10008.0 |
| 2018-01-18 07:45:00 | AAPL | Stock | 44.8 | 44.8125 | 44.79 | 44.795 | 15428.0 |
| 2018-01-18 07:50:00 | AAPL | Stock | 44.79 | 44.79 | 44.77 | 44.77 | 13124.0 |
| 2018-01-18 07:55:00 | AAPL | Stock | 44.7575 | 44.7575 | 44.7375 | 44.7375 | 21596.0 |
| 2018-01-18 08:00:00 | AAPL | Stock | 44.75 | 44.9325 | 44.6925 | 44.6925 | 124716.0 |
| 2018-01-18 08:05:00 | AAPL | Stock | 44.7125 | 44.7275 | 44.6775 | 44.7275 | 39640.0 |
| 2018-01-18 08:10:00 | AAPL | Stock | 44.715 | 44.785 | 44.715 | 44.775 | 38556.0 |
| 2018-01-18 08:15:00 | AAPL | Stock | 44.7725 | 44.775 | 44.755 | 44.775 | 4596.0 |
| 2018-01-18 08:20:00 | AAPL | Stock | 44.7825 | 44.7825 | 44.7625 | 44.765 | 17344.0 |
| 2018-01-18 08:25:00 | AAPL | Stock | 44.7625 | 44.7875 | 44.7625 | 44.7875 | 16656.0 |
| 2018-01-18 08:30:00 | AAPL | Stock | 44.775 | 44.775 | 44.725 | 44.7625 | 110560.0 |
| 2018-01-18 08:35:00 | AAPL | Stock | 44.7125 | 44.7625 | 44.7125 | 44.7625 | 12292.0 |
| 2018-01-18 08:40:00 | AAPL | Stock | 44.76 | 44.7875 | 44.725 | 44.7375 | 26668.0 |
| 2018-01-18 08:45:00 | AAPL | Stock | 44.73 | 44.775 | 44.725 | 44.7375 | 57936.0 |
| 2018-01-18 08:50:00 | AAPL | Stock | 44.7375 | 44.74 | 44.7025 | 44.715 | 38756.0 |
| 2018-01-18 08:55:00 | AAPL | Stock | 44.7225 | 44.7475 | 44.7225 | 44.7375 | 52028.0 |
| 2018-01-18 09:00:00 | AAPL | Stock | 44.7525 | 44.7725 | 44.74 | 44.7725 | 34764.0 |
| 2018-01-18 09:05:00 | AAPL | Stock | 44.755 | 44.7725 | 44.7275 | 44.75 | 92392.0 |
| 2018-01-18 09:10:00 | AAPL | Stock | 44.75 | 44.775 | 44.7475 | 44.75 | 34940.0 |
| 2018-01-18 09:15:00 | AAPL | Stock | 44.75 | 44.77 | 44.75 | 44.77 | 16780.0 |
> showing 50 of 366,894 rows — these rows as CSV