PREVIEW / futures_30min / 2018-03-13
file: by_date/futures_30min/2018/2018-03-13.parquet size: 82 KB rows: 3,039
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-03-13 00:00:00 | ES | Futures | 3043.23 | 3044.05 | 3042.96 | 3043.78 | 507.0 |
| 2018-03-13 00:30:00 | ES | Futures | 3044.05 | 3045.42 | 3043.78 | 3045.15 | 993.0 |
| 2018-03-13 01:00:00 | ES | Futures | 3044.87 | 3045.97 | 3044.05 | 3044.87 | 888.0 |
| 2018-03-13 01:30:00 | ES | Futures | 3044.87 | 3045.97 | 3044.6 | 3045.42 | 534.0 |
| 2018-03-13 02:00:00 | ES | Futures | 3045.42 | 3045.97 | 3044.87 | 3045.69 | 605.0 |
| 2018-03-13 02:30:00 | ES | Futures | 3045.42 | 3045.42 | 3044.6 | 3044.87 | 191.0 |
| 2018-03-13 03:00:00 | ES | Futures | 3044.87 | 3047.61 | 3044.87 | 3047.33 | 1091.0 |
| 2018-03-13 03:30:00 | ES | Futures | 3047.33 | 3048.43 | 3045.97 | 3047.33 | 1082.0 |
| 2018-03-13 04:00:00 | ES | Futures | 3047.61 | 3049.52 | 3047.33 | 3047.88 | 2191.0 |
| 2018-03-13 04:30:00 | ES | Futures | 3047.88 | 3049.25 | 3046.79 | 3048.43 | 1179.0 |
| 2018-03-13 05:00:00 | ES | Futures | 3048.7 | 3051.43 | 3048.43 | 3050.07 | 1995.0 |
| 2018-03-13 05:30:00 | ES | Futures | 3050.07 | 3050.89 | 3048.15 | 3049.52 | 1969.0 |
| 2018-03-13 06:00:00 | ES | Futures | 3049.79 | 3051.16 | 3049.25 | 3050.89 | 1717.0 |
| 2018-03-13 06:30:00 | ES | Futures | 3050.89 | 3051.71 | 3049.52 | 3050.61 | 1334.0 |
| 2018-03-13 07:00:00 | ES | Futures | 3050.61 | 3051.43 | 3048.97 | 3050.34 | 1830.0 |
| 2018-03-13 07:30:00 | ES | Futures | 3050.34 | 3050.89 | 3049.25 | 3049.79 | 1819.0 |
| 2018-03-13 08:00:00 | ES | Futures | 3050.07 | 3050.61 | 3047.33 | 3047.61 | 2825.0 |
| 2018-03-13 08:30:00 | ES | Futures | 3047.61 | 3061.27 | 3047.33 | 3055.53 | 41409.0 |
| 2018-03-13 09:00:00 | ES | Futures | 3055.53 | 3058.81 | 3052.53 | 3057.72 | 7707.0 |
| 2018-03-13 09:30:00 | ES | Futures | 3057.45 | 3064.01 | 3054.44 | 3058.27 | 27791.0 |
| 2018-03-13 10:00:00 | ES | Futures | 3058.27 | 3060.18 | 3054.44 | 3056.35 | 22944.0 |
| 2018-03-13 10:30:00 | ES | Futures | 3056.35 | 3056.9 | 3048.43 | 3048.7 | 27868.0 |
| 2018-03-13 11:00:00 | ES | Futures | 3048.97 | 3049.25 | 3039.13 | 3041.87 | 31960.0 |
| 2018-03-13 11:30:00 | ES | Futures | 3042.14 | 3044.05 | 3037.49 | 3039.41 | 30718.0 |
| 2018-03-13 12:00:00 | ES | Futures | 3039.41 | 3041.05 | 3027.93 | 3034.49 | 35778.0 |
| 2018-03-13 12:30:00 | ES | Futures | 3034.21 | 3041.32 | 3034.21 | 3039.41 | 17511.0 |
| 2018-03-13 13:00:00 | ES | Futures | 3039.13 | 3043.23 | 3038.31 | 3040.23 | 14915.0 |
| 2018-03-13 13:30:00 | ES | Futures | 3040.23 | 3042.41 | 3032.57 | 3033.39 | 17421.0 |
| 2018-03-13 14:00:00 | ES | Futures | 3033.39 | 3036.13 | 3028.75 | 3030.39 | 16448.0 |
| 2018-03-13 14:30:00 | ES | Futures | 3030.66 | 3036.4 | 3025.47 | 3028.47 | 17904.0 |
| 2018-03-13 15:00:00 | ES | Futures | 3028.75 | 3031.48 | 3018.91 | 3020.55 | 29227.0 |
| 2018-03-13 15:30:00 | ES | Futures | 3020.82 | 3026.01 | 3015.9 | 3023.01 | 56777.0 |
| 2018-03-13 16:00:00 | ES | Futures | 3023.01 | 3027.93 | 3022.46 | 3026.29 | 16577.0 |
| 2018-03-13 16:30:00 | ES | Futures | 3026.83 | 3027.11 | 3021.64 | 3021.64 | 2596.0 |
| 2018-03-13 18:00:00 | ES | Futures | 3020.82 | 3020.82 | 3015.63 | 3018.91 | 1849.0 |
| 2018-03-13 18:30:00 | ES | Futures | 3018.91 | 3021.64 | 3018.63 | 3021.09 | 880.0 |
| 2018-03-13 19:00:00 | ES | Futures | 3021.09 | 3022.19 | 3019.18 | 3020.82 | 951.0 |
| 2018-03-13 19:30:00 | ES | Futures | 3020.55 | 3023.01 | 3020.0 | 3021.91 | 1196.0 |
| 2018-03-13 20:00:00 | ES | Futures | 3021.91 | 3024.65 | 3021.64 | 3022.46 | 1910.0 |
| 2018-03-13 20:30:00 | ES | Futures | 3022.46 | 3024.37 | 3021.64 | 3021.64 | 1125.0 |
| 2018-03-13 21:00:00 | ES | Futures | 3021.91 | 3022.46 | 3018.91 | 3019.73 | 1837.0 |
| 2018-03-13 21:30:00 | ES | Futures | 3019.73 | 3020.82 | 3017.81 | 3019.45 | 1412.0 |
| 2018-03-13 22:00:00 | ES | Futures | 3019.73 | 3021.09 | 3019.45 | 3019.45 | 612.0 |
| 2018-03-13 22:30:00 | ES | Futures | 3019.18 | 3021.09 | 3016.72 | 3017.27 | 1056.0 |
| 2018-03-13 23:00:00 | ES | Futures | 3017.54 | 3018.63 | 3015.9 | 3018.36 | 823.0 |
| 2018-03-13 23:30:00 | ES | Futures | 3018.36 | 3020.55 | 3018.09 | 3019.45 | 689.0 |
| 2018-03-13 00:00:00 | NQ | Futures | 8460.94 | 8466.28 | 8460.94 | 8465.69 | 350.0 |
| 2018-03-13 00:30:00 | NQ | Futures | 8465.69 | 8469.84 | 8465.69 | 8468.36 | 225.0 |
| 2018-03-13 01:00:00 | NQ | Futures | 8468.66 | 8471.03 | 8464.8 | 8466.28 | 190.0 |
| 2018-03-13 01:30:00 | NQ | Futures | 8466.88 | 8472.21 | 8465.99 | 8469.84 | 239.0 |
> showing 50 of 3,039 rows — these rows as CSV