PREVIEW / futures_30min / 2019-05-30
file: by_date/futures_30min/2019/2019-05-30.parquet size: 94 KB rows: 3,458
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-05-30 00:00:00 | ES | Futures | 3020.08 | 3021.16 | 3019.81 | 3020.89 | 1505.0 |
| 2019-05-30 00:30:00 | ES | Futures | 3020.89 | 3021.71 | 3020.08 | 3021.16 | 2199.0 |
| 2019-05-30 01:00:00 | ES | Futures | 3021.16 | 3021.98 | 3020.08 | 3020.62 | 3389.0 |
| 2019-05-30 01:30:00 | ES | Futures | 3020.35 | 3021.98 | 3020.08 | 3021.98 | 2725.0 |
| 2019-05-30 02:00:00 | ES | Futures | 3021.98 | 3024.42 | 3020.89 | 3022.52 | 6532.0 |
| 2019-05-30 02:30:00 | ES | Futures | 3022.52 | 3025.5 | 3021.98 | 3024.42 | 5238.0 |
| 2019-05-30 03:00:00 | ES | Futures | 3024.69 | 3028.21 | 3023.6 | 3026.59 | 14217.0 |
| 2019-05-30 03:30:00 | ES | Futures | 3026.59 | 3028.75 | 3025.77 | 3026.59 | 8109.0 |
| 2019-05-30 04:00:00 | ES | Futures | 3026.86 | 3026.86 | 3023.33 | 3025.5 | 6437.0 |
| 2019-05-30 04:30:00 | ES | Futures | 3025.5 | 3026.59 | 3023.6 | 3024.15 | 5194.0 |
| 2019-05-30 05:00:00 | ES | Futures | 3024.15 | 3027.67 | 3024.15 | 3026.31 | 6948.0 |
| 2019-05-30 05:30:00 | ES | Futures | 3026.04 | 3027.4 | 3025.23 | 3027.13 | 8820.0 |
| 2019-05-30 06:00:00 | ES | Futures | 3027.13 | 3027.94 | 3025.77 | 3027.13 | 6816.0 |
| 2019-05-30 06:30:00 | ES | Futures | 3027.13 | 3027.94 | 3021.71 | 3022.79 | 10562.0 |
| 2019-05-30 07:00:00 | ES | Futures | 3022.79 | 3023.33 | 3020.89 | 3021.71 | 6450.0 |
| 2019-05-30 07:30:00 | ES | Futures | 3021.71 | 3023.87 | 3021.43 | 3022.25 | 8844.0 |
| 2019-05-30 08:00:00 | ES | Futures | 3022.25 | 3026.04 | 3020.08 | 3025.23 | 24261.0 |
| 2019-05-30 08:30:00 | ES | Futures | 3025.23 | 3027.13 | 3023.6 | 3024.15 | 19084.0 |
| 2019-05-30 09:00:00 | ES | Futures | 3023.87 | 3026.59 | 3021.71 | 3024.96 | 18230.0 |
| 2019-05-30 09:30:00 | ES | Futures | 3025.23 | 3033.91 | 3023.33 | 3032.28 | 142307.0 |
| 2019-05-30 10:00:00 | ES | Futures | 3032.28 | 3033.91 | 3029.03 | 3031.47 | 73654.0 |
| 2019-05-30 10:30:00 | ES | Futures | 3031.74 | 3035.26 | 3021.98 | 3024.69 | 96104.0 |
| 2019-05-30 11:00:00 | ES | Futures | 3024.69 | 3026.86 | 3019.27 | 3023.33 | 74033.0 |
| 2019-05-30 11:30:00 | ES | Futures | 3023.33 | 3024.42 | 3017.1 | 3020.62 | 61589.0 |
| 2019-05-30 12:00:00 | ES | Futures | 3020.89 | 3023.87 | 3018.72 | 3020.89 | 53686.0 |
| 2019-05-30 12:30:00 | ES | Futures | 3021.16 | 3029.57 | 3019.54 | 3026.86 | 55160.0 |
| 2019-05-30 13:00:00 | ES | Futures | 3026.86 | 3028.21 | 3021.71 | 3023.06 | 41178.0 |
| 2019-05-30 13:30:00 | ES | Futures | 3023.06 | 3023.33 | 3018.18 | 3021.16 | 45632.0 |
| 2019-05-30 14:00:00 | ES | Futures | 3021.43 | 3023.87 | 3016.28 | 3016.56 | 44890.0 |
| 2019-05-30 14:30:00 | ES | Futures | 3016.56 | 3020.62 | 3010.86 | 3020.35 | 89938.0 |
| 2019-05-30 15:00:00 | ES | Futures | 3020.35 | 3022.52 | 3012.22 | 3020.62 | 91506.0 |
| 2019-05-30 15:30:00 | ES | Futures | 3020.62 | 3027.4 | 3017.91 | 3024.69 | 121151.0 |
| 2019-05-30 16:00:00 | ES | Futures | 3024.69 | 3026.59 | 3023.06 | 3026.31 | 32797.0 |
| 2019-05-30 16:30:00 | ES | Futures | 3026.31 | 3026.59 | 3024.15 | 3025.23 | 4742.0 |
| 2019-05-30 18:00:00 | ES | Futures | 3024.15 | 3026.59 | 3023.87 | 3025.5 | 2354.0 |
| 2019-05-30 18:30:00 | ES | Futures | 3025.77 | 3026.04 | 3024.15 | 3024.69 | 1226.0 |
| 2019-05-30 19:00:00 | ES | Futures | 3024.69 | 3026.04 | 3024.69 | 3024.96 | 885.0 |
| 2019-05-30 19:30:00 | ES | Futures | 3025.23 | 3025.23 | 2998.12 | 2999.48 | 51559.0 |
| 2019-05-30 20:00:00 | ES | Futures | 2999.75 | 3004.9 | 2996.76 | 3000.83 | 34910.0 |
| 2019-05-30 20:30:00 | ES | Futures | 3001.1 | 3003.27 | 2998.93 | 3000.02 | 13382.0 |
| 2019-05-30 21:00:00 | ES | Futures | 2999.75 | 3005.17 | 2998.12 | 3004.36 | 13841.0 |
| 2019-05-30 21:30:00 | ES | Futures | 3004.36 | 3007.61 | 3002.19 | 3003.81 | 16716.0 |
| 2019-05-30 22:00:00 | ES | Futures | 3003.81 | 3005.71 | 3000.56 | 3001.92 | 9533.0 |
| 2019-05-30 22:30:00 | ES | Futures | 3001.92 | 3006.52 | 2997.04 | 3005.44 | 17003.0 |
| 2019-05-30 23:00:00 | ES | Futures | 3005.44 | 3006.8 | 3003.27 | 3005.44 | 6573.0 |
| 2019-05-30 23:30:00 | ES | Futures | 3005.44 | 3010.32 | 3003.81 | 3007.34 | 11446.0 |
| 2019-05-30 00:00:00 | NQ | Futures | 8420.82 | 8425.47 | 8420.23 | 8425.47 | 750.0 |
| 2019-05-30 00:30:00 | NQ | Futures | 8425.76 | 8427.51 | 8421.69 | 8425.18 | 1118.0 |
| 2019-05-30 01:00:00 | NQ | Futures | 8424.89 | 8428.39 | 8420.52 | 8421.69 | 1671.0 |
| 2019-05-30 01:30:00 | NQ | Futures | 8421.4 | 8428.09 | 8419.65 | 8427.8 | 1330.0 |
> showing 50 of 3,458 rows — these rows as CSV