PREVIEW / futures_30min / 2019-03-13
file: by_date/futures_30min/2019/2019-03-13.parquet size: 85 KB rows: 3,236
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-13 00:00:00 | ES | Futures | 3026.81 | 3028.17 | 3026.54 | 3028.17 | 474.0 |
| 2019-03-13 00:30:00 | ES | Futures | 3027.9 | 3027.9 | 3027.08 | 3027.35 | 364.0 |
| 2019-03-13 01:00:00 | ES | Futures | 3027.35 | 3029.25 | 3026.81 | 3029.25 | 1141.0 |
| 2019-03-13 01:30:00 | ES | Futures | 3029.25 | 3031.97 | 3029.25 | 3031.7 | 1261.0 |
| 2019-03-13 02:00:00 | ES | Futures | 3031.7 | 3031.97 | 3028.71 | 3029.25 | 1028.0 |
| 2019-03-13 02:30:00 | ES | Futures | 3028.98 | 3029.25 | 3028.44 | 3028.98 | 746.0 |
| 2019-03-13 03:00:00 | ES | Futures | 3028.71 | 3029.8 | 3026.27 | 3028.44 | 1591.0 |
| 2019-03-13 03:30:00 | ES | Futures | 3028.44 | 3030.34 | 3028.44 | 3030.34 | 1015.0 |
| 2019-03-13 04:00:00 | ES | Futures | 3030.07 | 3032.78 | 3030.07 | 3032.78 | 2212.0 |
| 2019-03-13 04:30:00 | ES | Futures | 3032.78 | 3035.77 | 3032.78 | 3035.77 | 3198.0 |
| 2019-03-13 05:00:00 | ES | Futures | 3035.77 | 3035.77 | 3033.87 | 3034.69 | 2513.0 |
| 2019-03-13 05:30:00 | ES | Futures | 3034.69 | 3036.86 | 3033.6 | 3034.69 | 1936.0 |
| 2019-03-13 06:00:00 | ES | Futures | 3034.69 | 3037.13 | 3034.41 | 3036.86 | 2300.0 |
| 2019-03-13 06:30:00 | ES | Futures | 3037.13 | 3038.49 | 3035.5 | 3038.22 | 1609.0 |
| 2019-03-13 07:00:00 | ES | Futures | 3038.22 | 3039.03 | 3037.4 | 3037.67 | 1241.0 |
| 2019-03-13 07:30:00 | ES | Futures | 3037.94 | 3040.12 | 3037.4 | 3040.12 | 2204.0 |
| 2019-03-13 08:00:00 | ES | Futures | 3040.12 | 3042.83 | 3040.12 | 3041.75 | 3866.0 |
| 2019-03-13 08:30:00 | ES | Futures | 3042.02 | 3042.29 | 3038.76 | 3039.3 | 4311.0 |
| 2019-03-13 09:00:00 | ES | Futures | 3039.57 | 3044.46 | 3039.03 | 3044.19 | 4382.0 |
| 2019-03-13 09:30:00 | ES | Futures | 3044.46 | 3049.08 | 3042.02 | 3047.99 | 17479.0 |
| 2019-03-13 10:00:00 | ES | Futures | 3047.99 | 3051.8 | 3047.72 | 3048.54 | 17490.0 |
| 2019-03-13 10:30:00 | ES | Futures | 3048.54 | 3054.78 | 3048.27 | 3053.7 | 14345.0 |
| 2019-03-13 11:00:00 | ES | Futures | 3053.43 | 3060.76 | 3053.43 | 3060.49 | 14967.0 |
| 2019-03-13 11:30:00 | ES | Futures | 3060.49 | 3061.84 | 3057.23 | 3058.86 | 10757.0 |
| 2019-03-13 12:00:00 | ES | Futures | 3058.86 | 3061.03 | 3055.33 | 3056.96 | 11626.0 |
| 2019-03-13 12:30:00 | ES | Futures | 3056.68 | 3059.4 | 3055.33 | 3059.13 | 6420.0 |
| 2019-03-13 13:00:00 | ES | Futures | 3058.86 | 3061.03 | 3058.59 | 3059.94 | 5278.0 |
| 2019-03-13 13:30:00 | ES | Futures | 3059.67 | 3061.03 | 3057.77 | 3061.03 | 4666.0 |
| 2019-03-13 14:00:00 | ES | Futures | 3061.03 | 3064.83 | 3060.76 | 3061.57 | 9734.0 |
| 2019-03-13 14:30:00 | ES | Futures | 3061.57 | 3061.57 | 3051.25 | 3056.68 | 22904.0 |
| 2019-03-13 15:00:00 | ES | Futures | 3056.68 | 3057.5 | 3051.25 | 3053.43 | 16765.0 |
| 2019-03-13 15:30:00 | ES | Futures | 3053.43 | 3058.04 | 3052.07 | 3053.7 | 21475.0 |
| 2019-03-13 16:00:00 | ES | Futures | 3053.7 | 3058.04 | 3053.15 | 3057.5 | 9475.0 |
| 2019-03-13 16:30:00 | ES | Futures | 3057.5 | 3059.4 | 3057.5 | 3058.59 | 1598.0 |
| 2019-03-13 18:00:00 | ES | Futures | 3059.13 | 3061.03 | 3057.5 | 3061.03 | 725.0 |
| 2019-03-13 18:30:00 | ES | Futures | 3061.03 | 3061.84 | 3060.21 | 3060.76 | 440.0 |
| 2019-03-13 19:00:00 | ES | Futures | 3061.03 | 3061.03 | 3058.04 | 3059.13 | 849.0 |
| 2019-03-13 19:30:00 | ES | Futures | 3059.13 | 3059.4 | 3056.41 | 3057.77 | 576.0 |
| 2019-03-13 20:00:00 | ES | Futures | 3057.77 | 3059.67 | 3056.68 | 3057.23 | 1046.0 |
| 2019-03-13 20:30:00 | ES | Futures | 3056.96 | 3056.96 | 3053.7 | 3053.97 | 1351.0 |
| 2019-03-13 21:00:00 | ES | Futures | 3053.97 | 3054.78 | 3053.15 | 3054.24 | 1566.0 |
| 2019-03-13 21:30:00 | ES | Futures | 3054.51 | 3055.87 | 3052.07 | 3055.6 | 1792.0 |
| 2019-03-13 22:00:00 | ES | Futures | 3055.6 | 3056.41 | 3053.97 | 3056.14 | 997.0 |
| 2019-03-13 22:30:00 | ES | Futures | 3056.41 | 3056.41 | 3054.51 | 3055.33 | 1368.0 |
| 2019-03-13 23:00:00 | ES | Futures | 3055.33 | 3056.14 | 3054.24 | 3054.78 | 702.0 |
| 2019-03-13 23:30:00 | ES | Futures | 3054.51 | 3054.51 | 3051.52 | 3053.15 | 1097.0 |
| 2019-03-13 00:00:00 | NQ | Futures | 8407.16 | 8413.88 | 8406.87 | 8413.3 | 176.0 |
| 2019-03-13 00:30:00 | NQ | Futures | 8412.72 | 8412.72 | 8409.5 | 8410.09 | 124.0 |
| 2019-03-13 01:00:00 | NQ | Futures | 8409.79 | 8413.88 | 8406.87 | 8413.88 | 391.0 |
| 2019-03-13 01:30:00 | NQ | Futures | 8413.59 | 8422.07 | 8413.3 | 8420.9 | 446.0 |
> showing 50 of 3,236 rows — these rows as CSV