PREVIEW / futures_5min / 2019-06-30
file: by_date/futures_5min/2019/2019-06-30.parquet size: 68 KB rows: 3,476
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-06-30 18:00:00 | ES | Futures | 3215.98 | 3221.39 | 3214.35 | 3218.95 | 13454.0 |
| 2019-06-30 18:05:00 | ES | Futures | 3219.22 | 3224.1 | 3218.68 | 3221.39 | 5740.0 |
| 2019-06-30 18:10:00 | ES | Futures | 3221.39 | 3221.66 | 3218.68 | 3220.58 | 3389.0 |
| 2019-06-30 18:15:00 | ES | Futures | 3220.58 | 3221.39 | 3220.04 | 3220.31 | 2057.0 |
| 2019-06-30 18:20:00 | ES | Futures | 3220.31 | 3221.93 | 3219.77 | 3219.77 | 3238.0 |
| 2019-06-30 18:25:00 | ES | Futures | 3219.77 | 3220.31 | 3218.68 | 3220.31 | 1997.0 |
| 2019-06-30 18:30:00 | ES | Futures | 3220.04 | 3220.58 | 3217.33 | 3217.87 | 2260.0 |
| 2019-06-30 18:35:00 | ES | Futures | 3218.14 | 3218.95 | 3217.6 | 3218.14 | 1732.0 |
| 2019-06-30 18:40:00 | ES | Futures | 3218.14 | 3218.14 | 3216.52 | 3216.79 | 1267.0 |
| 2019-06-30 18:45:00 | ES | Futures | 3216.79 | 3217.6 | 3216.52 | 3216.52 | 1224.0 |
| 2019-06-30 18:50:00 | ES | Futures | 3216.52 | 3217.33 | 3216.25 | 3217.06 | 866.0 |
| 2019-06-30 18:55:00 | ES | Futures | 3217.06 | 3218.95 | 3217.06 | 3217.6 | 1445.0 |
| 2019-06-30 19:00:00 | ES | Futures | 3217.87 | 3218.68 | 3217.6 | 3218.41 | 668.0 |
| 2019-06-30 19:05:00 | ES | Futures | 3218.41 | 3218.68 | 3217.6 | 3217.6 | 594.0 |
| 2019-06-30 19:10:00 | ES | Futures | 3217.6 | 3218.14 | 3216.52 | 3217.06 | 719.0 |
| 2019-06-30 19:15:00 | ES | Futures | 3216.79 | 3217.33 | 3216.25 | 3216.52 | 832.0 |
| 2019-06-30 19:20:00 | ES | Futures | 3216.79 | 3217.33 | 3216.52 | 3216.79 | 437.0 |
| 2019-06-30 19:25:00 | ES | Futures | 3216.79 | 3217.06 | 3216.25 | 3216.52 | 436.0 |
| 2019-06-30 19:30:00 | ES | Futures | 3216.52 | 3217.6 | 3216.25 | 3216.25 | 1482.0 |
| 2019-06-30 19:35:00 | ES | Futures | 3216.25 | 3216.52 | 3215.71 | 3216.52 | 832.0 |
| 2019-06-30 19:40:00 | ES | Futures | 3216.25 | 3217.06 | 3215.98 | 3217.06 | 749.0 |
| 2019-06-30 19:45:00 | ES | Futures | 3216.79 | 3217.33 | 3216.52 | 3216.79 | 775.0 |
| 2019-06-30 19:50:00 | ES | Futures | 3216.52 | 3217.33 | 3215.98 | 3217.33 | 863.0 |
| 2019-06-30 19:55:00 | ES | Futures | 3217.06 | 3217.6 | 3217.06 | 3217.6 | 623.0 |
| 2019-06-30 20:00:00 | ES | Futures | 3217.33 | 3217.6 | 3215.98 | 3216.52 | 3124.0 |
| 2019-06-30 20:05:00 | ES | Futures | 3216.25 | 3216.79 | 3215.98 | 3215.98 | 1972.0 |
| 2019-06-30 20:10:00 | ES | Futures | 3215.98 | 3216.79 | 3215.43 | 3215.71 | 990.0 |
| 2019-06-30 20:15:00 | ES | Futures | 3215.98 | 3215.98 | 3214.35 | 3214.62 | 2467.0 |
| 2019-06-30 20:20:00 | ES | Futures | 3214.62 | 3215.16 | 3214.08 | 3214.35 | 1941.0 |
| 2019-06-30 20:25:00 | ES | Futures | 3214.62 | 3214.62 | 3212.73 | 3213.0 | 1536.0 |
| 2019-06-30 20:30:00 | ES | Futures | 3213.27 | 3213.54 | 3211.92 | 3211.92 | 1330.0 |
| 2019-06-30 20:35:00 | ES | Futures | 3211.92 | 3212.19 | 3210.83 | 3211.1 | 1637.0 |
| 2019-06-30 20:40:00 | ES | Futures | 3211.1 | 3211.1 | 3210.56 | 3210.83 | 885.0 |
| 2019-06-30 20:45:00 | ES | Futures | 3210.83 | 3211.64 | 3210.56 | 3211.1 | 1199.0 |
| 2019-06-30 20:50:00 | ES | Futures | 3210.83 | 3211.1 | 3209.75 | 3209.75 | 1029.0 |
| 2019-06-30 20:55:00 | ES | Futures | 3210.02 | 3210.29 | 3208.4 | 3209.75 | 1825.0 |
| 2019-06-30 21:00:00 | ES | Futures | 3209.48 | 3211.64 | 3209.48 | 3211.37 | 2381.0 |
| 2019-06-30 21:05:00 | ES | Futures | 3211.37 | 3213.54 | 3211.37 | 3213.54 | 1635.0 |
| 2019-06-30 21:10:00 | ES | Futures | 3213.27 | 3214.08 | 3212.19 | 3213.27 | 1355.0 |
| 2019-06-30 21:15:00 | ES | Futures | 3213.0 | 3213.27 | 3212.46 | 3213.27 | 1008.0 |
| 2019-06-30 21:20:00 | ES | Futures | 3213.27 | 3213.27 | 3210.83 | 3211.64 | 1066.0 |
| 2019-06-30 21:25:00 | ES | Futures | 3211.37 | 3213.27 | 3211.37 | 3213.27 | 645.0 |
| 2019-06-30 21:30:00 | ES | Futures | 3213.0 | 3213.0 | 3211.37 | 3212.46 | 780.0 |
| 2019-06-30 21:35:00 | ES | Futures | 3212.19 | 3212.19 | 3210.56 | 3210.83 | 1334.0 |
| 2019-06-30 21:40:00 | ES | Futures | 3210.83 | 3211.92 | 3210.83 | 3211.64 | 726.0 |
| 2019-06-30 21:45:00 | ES | Futures | 3211.37 | 3213.27 | 3209.75 | 3213.27 | 1812.0 |
| 2019-06-30 21:50:00 | ES | Futures | 3213.0 | 3213.27 | 3212.19 | 3212.73 | 873.0 |
| 2019-06-30 21:55:00 | ES | Futures | 3212.73 | 3213.81 | 3212.19 | 3213.81 | 1379.0 |
| 2019-06-30 22:00:00 | ES | Futures | 3213.81 | 3214.62 | 3213.54 | 3214.08 | 845.0 |
| 2019-06-30 22:05:00 | ES | Futures | 3214.08 | 3215.16 | 3213.81 | 3214.62 | 1420.0 |
> showing 50 of 3,476 rows — these rows as CSV