PREVIEW / futures_30min / 2019-03-25
file: by_date/futures_30min/2019/2019-03-25.parquet size: 88 KB rows: 3,302
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-25 00:00:00 | ES | Futures | 3034.45 | 3034.99 | 3032.28 | 3032.28 | 2268.0 |
| 2019-03-25 00:30:00 | ES | Futures | 3032.28 | 3034.72 | 3032.28 | 3034.72 | 2172.0 |
| 2019-03-25 01:00:00 | ES | Futures | 3034.72 | 3035.26 | 3033.09 | 3034.45 | 2418.0 |
| 2019-03-25 01:30:00 | ES | Futures | 3034.45 | 3035.53 | 3032.01 | 3032.82 | 3136.0 |
| 2019-03-25 02:00:00 | ES | Futures | 3032.82 | 3033.91 | 3029.57 | 3030.92 | 5346.0 |
| 2019-03-25 02:30:00 | ES | Futures | 3030.92 | 3031.19 | 3025.77 | 3027.13 | 6824.0 |
| 2019-03-25 03:00:00 | ES | Futures | 3027.13 | 3034.18 | 3027.13 | 3033.36 | 9220.0 |
| 2019-03-25 03:30:00 | ES | Futures | 3033.36 | 3034.72 | 3031.47 | 3034.18 | 5519.0 |
| 2019-03-25 04:00:00 | ES | Futures | 3034.18 | 3037.7 | 3032.82 | 3034.45 | 13615.0 |
| 2019-03-25 04:30:00 | ES | Futures | 3034.45 | 3040.41 | 3033.09 | 3035.26 | 13112.0 |
| 2019-03-25 05:00:00 | ES | Futures | 3035.26 | 3045.56 | 3035.26 | 3040.41 | 21322.0 |
| 2019-03-25 05:30:00 | ES | Futures | 3040.41 | 3045.56 | 3040.14 | 3043.39 | 7961.0 |
| 2019-03-25 06:00:00 | ES | Futures | 3043.12 | 3045.83 | 3040.41 | 3045.29 | 8245.0 |
| 2019-03-25 06:30:00 | ES | Futures | 3045.29 | 3047.46 | 3043.39 | 3043.67 | 7853.0 |
| 2019-03-25 07:00:00 | ES | Futures | 3043.67 | 3043.94 | 3039.6 | 3040.68 | 7689.0 |
| 2019-03-25 07:30:00 | ES | Futures | 3040.95 | 3042.85 | 3038.79 | 3039.06 | 10114.0 |
| 2019-03-25 08:00:00 | ES | Futures | 3039.06 | 3045.56 | 3037.97 | 3044.75 | 14941.0 |
| 2019-03-25 08:30:00 | ES | Futures | 3044.48 | 3045.83 | 3042.58 | 3045.02 | 13954.0 |
| 2019-03-25 09:00:00 | ES | Futures | 3045.02 | 3045.02 | 3037.16 | 3038.51 | 24964.0 |
| 2019-03-25 09:30:00 | ES | Futures | 3038.24 | 3050.98 | 3028.21 | 3029.03 | 255487.0 |
| 2019-03-25 10:00:00 | ES | Futures | 3029.03 | 3034.18 | 3025.77 | 3032.82 | 161956.0 |
| 2019-03-25 10:30:00 | ES | Futures | 3032.82 | 3046.65 | 3031.74 | 3043.94 | 139650.0 |
| 2019-03-25 11:00:00 | ES | Futures | 3043.67 | 3052.88 | 3040.68 | 3052.07 | 115319.0 |
| 2019-03-25 11:30:00 | ES | Futures | 3052.07 | 3052.61 | 3039.06 | 3039.06 | 84622.0 |
| 2019-03-25 12:00:00 | ES | Futures | 3039.33 | 3045.83 | 3037.7 | 3042.85 | 63807.0 |
| 2019-03-25 12:30:00 | ES | Futures | 3043.12 | 3043.94 | 3032.55 | 3040.68 | 88627.0 |
| 2019-03-25 13:00:00 | ES | Futures | 3040.68 | 3044.48 | 3034.99 | 3037.16 | 72739.0 |
| 2019-03-25 13:30:00 | ES | Futures | 3037.16 | 3040.14 | 3029.3 | 3030.92 | 81375.0 |
| 2019-03-25 14:00:00 | ES | Futures | 3030.65 | 3033.36 | 3024.96 | 3028.48 | 79375.0 |
| 2019-03-25 14:30:00 | ES | Futures | 3028.21 | 3037.7 | 3028.21 | 3037.16 | 61810.0 |
| 2019-03-25 15:00:00 | ES | Futures | 3037.16 | 3044.75 | 3034.99 | 3042.04 | 70136.0 |
| 2019-03-25 15:30:00 | ES | Futures | 3042.04 | 3043.94 | 3037.43 | 3040.14 | 122927.0 |
| 2019-03-25 16:00:00 | ES | Futures | 3039.87 | 3044.48 | 3038.79 | 3044.21 | 45494.0 |
| 2019-03-25 16:30:00 | ES | Futures | 3044.48 | 3046.11 | 3043.94 | 3045.29 | 7157.0 |
| 2019-03-25 18:00:00 | ES | Futures | 3045.56 | 3046.11 | 3043.94 | 3044.75 | 2603.0 |
| 2019-03-25 18:30:00 | ES | Futures | 3044.75 | 3045.56 | 3043.12 | 3043.12 | 3516.0 |
| 2019-03-25 19:00:00 | ES | Futures | 3043.12 | 3044.75 | 3042.85 | 3044.48 | 1624.0 |
| 2019-03-25 19:30:00 | ES | Futures | 3044.48 | 3048.82 | 3043.12 | 3047.19 | 5681.0 |
| 2019-03-25 20:00:00 | ES | Futures | 3047.19 | 3048.55 | 3046.11 | 3046.92 | 6360.0 |
| 2019-03-25 20:30:00 | ES | Futures | 3046.92 | 3051.8 | 3046.92 | 3049.9 | 6595.0 |
| 2019-03-25 21:00:00 | ES | Futures | 3050.17 | 3053.42 | 3049.36 | 3051.26 | 8686.0 |
| 2019-03-25 21:30:00 | ES | Futures | 3051.26 | 3053.42 | 3049.09 | 3049.63 | 10046.0 |
| 2019-03-25 22:00:00 | ES | Futures | 3049.9 | 3054.78 | 3049.9 | 3051.8 | 5610.0 |
| 2019-03-25 22:30:00 | ES | Futures | 3051.8 | 3054.24 | 3050.98 | 3053.15 | 2691.0 |
| 2019-03-25 23:00:00 | ES | Futures | 3053.42 | 3053.42 | 3050.98 | 3051.26 | 4652.0 |
| 2019-03-25 23:30:00 | ES | Futures | 3051.53 | 3053.7 | 3051.26 | 3053.42 | 4314.0 |
| 2019-03-25 00:00:00 | NQ | Futures | 8522.72 | 8523.88 | 8515.44 | 8515.44 | 1083.0 |
| 2019-03-25 00:30:00 | NQ | Futures | 8515.44 | 8523.59 | 8513.99 | 8522.43 | 1031.0 |
| 2019-03-25 01:00:00 | NQ | Futures | 8523.3 | 8527.67 | 8518.06 | 8523.88 | 1425.0 |
| 2019-03-25 01:30:00 | NQ | Futures | 8524.18 | 8527.38 | 8514.57 | 8517.19 | 1663.0 |
> showing 50 of 3,302 rows — these rows as CSV