PREVIEW / stock_5min / 2018-01-24
file: by_date/stock_5min/2018/2018-01-24.parquet size: 5.8 MB rows: 370,428 symbols: 2,901
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-24 04:05:00 | AAPL | Stock | 44.3125 | 44.3125 | 44.3125 | 44.3125 | 876.0 |
| 2018-01-24 04:15:00 | AAPL | Stock | 44.3125 | 44.3125 | 44.3125 | 44.3125 | 976.0 |
| 2018-01-24 04:25:00 | AAPL | Stock | 44.33 | 44.33 | 44.33 | 44.33 | 400.0 |
| 2018-01-24 04:30:00 | AAPL | Stock | 44.33 | 44.33 | 44.33 | 44.33 | 400.0 |
| 2018-01-24 04:35:00 | AAPL | Stock | 44.33 | 44.385 | 44.33 | 44.385 | 3580.0 |
| 2018-01-24 04:40:00 | AAPL | Stock | 44.3825 | 44.3875 | 44.37 | 44.3775 | 6884.0 |
| 2018-01-24 04:45:00 | AAPL | Stock | 44.315 | 44.3625 | 44.3125 | 44.3625 | 12328.0 |
| 2018-01-24 05:00:00 | AAPL | Stock | 44.3575 | 44.3575 | 44.3575 | 44.3575 | 400.0 |
| 2018-01-24 06:00:00 | AAPL | Stock | 44.3275 | 44.3275 | 44.3275 | 44.3275 | 4800.0 |
| 2018-01-24 06:40:00 | AAPL | Stock | 44.37 | 44.37 | 44.37 | 44.37 | 400.0 |
| 2018-01-24 06:45:00 | AAPL | Stock | 44.3525 | 44.3525 | 44.3275 | 44.3275 | 5548.0 |
| 2018-01-24 07:00:00 | AAPL | Stock | 44.325 | 44.35 | 44.325 | 44.35 | 10380.0 |
| 2018-01-24 07:05:00 | AAPL | Stock | 44.35 | 44.3525 | 44.345 | 44.3525 | 5740.0 |
| 2018-01-24 07:10:00 | AAPL | Stock | 44.3525 | 44.3675 | 44.35 | 44.35 | 2840.0 |
| 2018-01-24 07:15:00 | AAPL | Stock | 44.3625 | 44.375 | 44.3525 | 44.375 | 13992.0 |
| 2018-01-24 07:20:00 | AAPL | Stock | 44.3625 | 44.4 | 44.3625 | 44.4 | 11800.0 |
| 2018-01-24 07:25:00 | AAPL | Stock | 44.4 | 44.4 | 44.3175 | 44.3175 | 44756.0 |
| 2018-01-24 07:35:00 | AAPL | Stock | 44.3275 | 44.345 | 44.32 | 44.34 | 14540.0 |
| 2018-01-24 07:40:00 | AAPL | Stock | 44.345 | 44.345 | 44.32 | 44.325 | 26796.0 |
| 2018-01-24 07:45:00 | AAPL | Stock | 44.3175 | 44.3375 | 44.3175 | 44.335 | 12708.0 |
| 2018-01-24 07:50:00 | AAPL | Stock | 44.315 | 44.325 | 44.3 | 44.325 | 112256.0 |
| 2018-01-24 07:55:00 | AAPL | Stock | 44.31 | 44.3125 | 44.2775 | 44.3 | 18272.0 |
| 2018-01-24 08:00:00 | AAPL | Stock | 44.315 | 44.35 | 44.25 | 44.3325 | 61960.0 |
| 2018-01-24 08:05:00 | AAPL | Stock | 44.345 | 44.345 | 44.3125 | 44.3425 | 13648.0 |
| 2018-01-24 08:10:00 | AAPL | Stock | 44.345 | 44.345 | 44.3375 | 44.3375 | 6600.0 |
| 2018-01-24 08:15:00 | AAPL | Stock | 44.33 | 44.4275 | 44.33 | 44.425 | 59772.0 |
| 2018-01-24 08:20:00 | AAPL | Stock | 44.4425 | 44.4425 | 44.39 | 44.39 | 54548.0 |
| 2018-01-24 08:25:00 | AAPL | Stock | 44.4125 | 44.4175 | 44.405 | 44.4175 | 20040.0 |
| 2018-01-24 08:30:00 | AAPL | Stock | 44.4 | 44.42 | 44.3925 | 44.42 | 8200.0 |
| 2018-01-24 08:35:00 | AAPL | Stock | 44.42 | 44.495 | 44.42 | 44.4925 | 95340.0 |
| 2018-01-24 08:40:00 | AAPL | Stock | 44.475 | 44.4875 | 44.4625 | 44.4625 | 49324.0 |
| 2018-01-24 08:45:00 | AAPL | Stock | 44.47 | 44.4725 | 44.44 | 44.45 | 22544.0 |
| 2018-01-24 08:50:00 | AAPL | Stock | 44.4525 | 44.46 | 44.4375 | 44.45 | 25684.0 |
| 2018-01-24 08:55:00 | AAPL | Stock | 44.455 | 44.455 | 44.435 | 44.4375 | 17384.0 |
| 2018-01-24 09:00:00 | AAPL | Stock | 44.4275 | 44.4475 | 44.4275 | 44.4375 | 25632.0 |
| 2018-01-24 09:05:00 | AAPL | Stock | 44.445 | 44.445 | 44.3725 | 44.375 | 96420.0 |
| 2018-01-24 09:10:00 | AAPL | Stock | 44.3575 | 44.375 | 44.325 | 44.325 | 48772.0 |
| 2018-01-24 09:15:00 | AAPL | Stock | 44.3375 | 44.3375 | 44.295 | 44.3 | 79180.0 |
| 2018-01-24 09:20:00 | AAPL | Stock | 44.3 | 44.375 | 44.3 | 44.3425 | 195508.0 |
| 2018-01-24 09:25:00 | AAPL | Stock | 44.3175 | 44.325 | 44.305 | 44.3125 | 16772.0 |
| 2018-01-24 09:30:00 | AAPL | Stock | 44.3125 | 44.325 | 44.0875 | 44.1875 | 6192768.0 |
| 2018-01-24 09:35:00 | AAPL | Stock | 44.19 | 44.1975 | 44.0125 | 44.053 | 4734720.0 |
| 2018-01-24 09:40:00 | AAPL | Stock | 44.06 | 44.0925 | 43.945 | 44.03 | 4337668.0 |
| 2018-01-24 09:45:00 | AAPL | Stock | 44.0275 | 44.0325 | 43.765 | 43.78 | 5195576.0 |
| 2018-01-24 09:50:00 | AAPL | Stock | 43.7848 | 43.895 | 43.695 | 43.8725 | 7452088.0 |
| 2018-01-24 09:55:00 | AAPL | Stock | 43.881 | 43.9375 | 43.8168 | 43.9288 | 2914384.0 |
| 2018-01-24 10:00:00 | AAPL | Stock | 43.9275 | 43.97 | 43.825 | 43.8775 | 3028800.0 |
| 2018-01-24 10:05:00 | AAPL | Stock | 43.875 | 43.925 | 43.7925 | 43.905 | 2583788.0 |
| 2018-01-24 10:10:00 | AAPL | Stock | 43.905 | 43.9675 | 43.875 | 43.945 | 1875212.0 |
| 2018-01-24 10:15:00 | AAPL | Stock | 43.945 | 43.965 | 43.865 | 43.887 | 2203796.0 |
> showing 50 of 370,428 rows — these rows as CSV