PREVIEW / futures_30min / 2019-08-13
file: by_date/futures_30min/2019/2019-08-13.parquet size: 100 KB rows: 3,510
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-08-13 00:00:00 | ES | Futures | 3123.67 | 3125.83 | 3122.85 | 3125.56 | 2573.0 |
| 2019-08-13 00:30:00 | ES | Futures | 3125.56 | 3126.64 | 3124.75 | 3125.29 | 2934.0 |
| 2019-08-13 01:00:00 | ES | Futures | 3125.29 | 3126.64 | 3124.75 | 3126.1 | 3475.0 |
| 2019-08-13 01:30:00 | ES | Futures | 3126.1 | 3126.64 | 3122.31 | 3123.67 | 6085.0 |
| 2019-08-13 02:00:00 | ES | Futures | 3123.67 | 3125.29 | 3113.65 | 3115.82 | 12304.0 |
| 2019-08-13 02:30:00 | ES | Futures | 3115.82 | 3116.36 | 3109.05 | 3112.57 | 22489.0 |
| 2019-08-13 03:00:00 | ES | Futures | 3112.57 | 3119.61 | 3110.94 | 3114.19 | 22773.0 |
| 2019-08-13 03:30:00 | ES | Futures | 3114.19 | 3116.63 | 3108.51 | 3111.48 | 18439.0 |
| 2019-08-13 04:00:00 | ES | Futures | 3111.75 | 3117.44 | 3110.67 | 3114.73 | 20799.0 |
| 2019-08-13 04:30:00 | ES | Futures | 3114.73 | 3122.04 | 3113.65 | 3119.33 | 18854.0 |
| 2019-08-13 05:00:00 | ES | Futures | 3119.33 | 3119.61 | 3106.88 | 3108.24 | 24444.0 |
| 2019-08-13 05:30:00 | ES | Futures | 3108.24 | 3110.4 | 3104.18 | 3107.96 | 23670.0 |
| 2019-08-13 06:00:00 | ES | Futures | 3107.96 | 3114.46 | 3105.53 | 3113.38 | 17863.0 |
| 2019-08-13 06:30:00 | ES | Futures | 3113.65 | 3117.71 | 3111.75 | 3117.17 | 17564.0 |
| 2019-08-13 07:00:00 | ES | Futures | 3117.17 | 3119.33 | 3111.75 | 3113.65 | 16300.0 |
| 2019-08-13 07:30:00 | ES | Futures | 3113.65 | 3114.19 | 3109.86 | 3111.48 | 13508.0 |
| 2019-08-13 08:00:00 | ES | Futures | 3111.48 | 3114.73 | 3109.32 | 3113.92 | 14146.0 |
| 2019-08-13 08:30:00 | ES | Futures | 3113.65 | 3113.92 | 3104.99 | 3112.03 | 47173.0 |
| 2019-08-13 09:00:00 | ES | Futures | 3112.3 | 3118.52 | 3109.86 | 3118.25 | 32267.0 |
| 2019-08-13 09:30:00 | ES | Futures | 3118.25 | 3178.89 | 3113.92 | 3174.83 | 460170.0 |
| 2019-08-13 10:00:00 | ES | Futures | 3174.83 | 3188.09 | 3164.54 | 3183.76 | 239035.0 |
| 2019-08-13 10:30:00 | ES | Futures | 3183.76 | 3185.39 | 3168.06 | 3168.33 | 152056.0 |
| 2019-08-13 11:00:00 | ES | Futures | 3168.6 | 3175.64 | 3159.4 | 3163.19 | 163639.0 |
| 2019-08-13 11:30:00 | ES | Futures | 3162.92 | 3175.1 | 3159.13 | 3174.56 | 106632.0 |
| 2019-08-13 12:00:00 | ES | Futures | 3174.83 | 3180.51 | 3170.77 | 3175.37 | 66310.0 |
| 2019-08-13 12:30:00 | ES | Futures | 3175.64 | 3176.45 | 3168.87 | 3172.39 | 62979.0 |
| 2019-08-13 13:00:00 | ES | Futures | 3172.39 | 3177.54 | 3164.81 | 3171.04 | 90612.0 |
| 2019-08-13 13:30:00 | ES | Futures | 3171.04 | 3173.75 | 3168.87 | 3172.39 | 43092.0 |
| 2019-08-13 14:00:00 | ES | Futures | 3172.39 | 3176.72 | 3171.04 | 3176.45 | 34882.0 |
| 2019-08-13 14:30:00 | ES | Futures | 3176.18 | 3179.43 | 3174.02 | 3174.29 | 48122.0 |
| 2019-08-13 15:00:00 | ES | Futures | 3174.29 | 3176.18 | 3169.41 | 3172.66 | 43940.0 |
| 2019-08-13 15:30:00 | ES | Futures | 3172.66 | 3172.66 | 3165.9 | 3169.69 | 149994.0 |
| 2019-08-13 16:00:00 | ES | Futures | 3169.69 | 3175.64 | 3168.06 | 3175.1 | 55011.0 |
| 2019-08-13 16:30:00 | ES | Futures | 3175.37 | 3177.27 | 3174.29 | 3174.56 | 6982.0 |
| 2019-08-13 18:00:00 | ES | Futures | 3173.75 | 3175.1 | 3170.77 | 3173.75 | 5117.0 |
| 2019-08-13 18:30:00 | ES | Futures | 3173.75 | 3176.45 | 3173.48 | 3175.1 | 2504.0 |
| 2019-08-13 19:00:00 | ES | Futures | 3175.37 | 3177.54 | 3175.1 | 3177.27 | 1826.0 |
| 2019-08-13 19:30:00 | ES | Futures | 3177.27 | 3177.54 | 3172.66 | 3175.37 | 4976.0 |
| 2019-08-13 20:00:00 | ES | Futures | 3175.64 | 3176.72 | 3172.66 | 3174.29 | 9161.0 |
| 2019-08-13 20:30:00 | ES | Futures | 3174.29 | 3174.56 | 3170.23 | 3172.12 | 7421.0 |
| 2019-08-13 21:00:00 | ES | Futures | 3172.39 | 3179.7 | 3170.77 | 3172.93 | 10720.0 |
| 2019-08-13 21:30:00 | ES | Futures | 3172.93 | 3174.02 | 3168.33 | 3170.77 | 6673.0 |
| 2019-08-13 22:00:00 | ES | Futures | 3170.5 | 3171.04 | 3166.17 | 3167.79 | 9949.0 |
| 2019-08-13 22:30:00 | ES | Futures | 3167.52 | 3168.87 | 3165.35 | 3168.06 | 3948.0 |
| 2019-08-13 23:00:00 | ES | Futures | 3168.06 | 3169.69 | 3167.52 | 3169.41 | 6881.0 |
| 2019-08-13 23:30:00 | ES | Futures | 3169.69 | 3170.23 | 3166.44 | 3169.41 | 7136.0 |
| 2019-08-13 00:00:00 | NQ | Futures | 8792.48 | 8803.21 | 8790.16 | 8802.05 | 1701.0 |
| 2019-08-13 00:30:00 | NQ | Futures | 8801.76 | 8805.53 | 8797.7 | 8799.73 | 1376.0 |
| 2019-08-13 01:00:00 | NQ | Futures | 8799.73 | 8804.37 | 8798.28 | 8800.31 | 1224.0 |
| 2019-08-13 01:30:00 | NQ | Futures | 8801.18 | 8803.79 | 8790.45 | 8798.28 | 3602.0 |
> showing 50 of 3,510 rows — these rows as CSV