PREVIEW / futures_30min / 2018-06-13
file: by_date/futures_30min/2018/2018-06-13.parquet size: 81 KB rows: 3,056
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-06-13 00:00:00 | ES | Futures | 3044.56 | 3045.38 | 3044.56 | 3044.84 | 327.0 |
| 2018-06-13 00:30:00 | ES | Futures | 3044.84 | 3045.38 | 3044.84 | 3045.38 | 269.0 |
| 2018-06-13 01:00:00 | ES | Futures | 3045.11 | 3045.65 | 3045.11 | 3045.65 | 453.0 |
| 2018-06-13 01:30:00 | ES | Futures | 3045.93 | 3045.93 | 3045.38 | 3045.38 | 250.0 |
| 2018-06-13 02:00:00 | ES | Futures | 3045.38 | 3045.65 | 3042.11 | 3042.38 | 1938.0 |
| 2018-06-13 02:30:00 | ES | Futures | 3042.38 | 3043.74 | 3042.11 | 3042.65 | 1137.0 |
| 2018-06-13 03:00:00 | ES | Futures | 3042.92 | 3043.74 | 3041.56 | 3041.56 | 2326.0 |
| 2018-06-13 03:30:00 | ES | Futures | 3041.29 | 3042.38 | 3040.74 | 3041.83 | 1827.0 |
| 2018-06-13 04:00:00 | ES | Futures | 3041.83 | 3042.38 | 3040.2 | 3041.01 | 1072.0 |
| 2018-06-13 04:30:00 | ES | Futures | 3040.74 | 3042.38 | 3040.74 | 3041.83 | 789.0 |
| 2018-06-13 05:00:00 | ES | Futures | 3042.11 | 3042.65 | 3040.74 | 3041.29 | 1171.0 |
| 2018-06-13 05:30:00 | ES | Futures | 3041.56 | 3044.29 | 3041.01 | 3043.2 | 2290.0 |
| 2018-06-13 06:00:00 | ES | Futures | 3043.2 | 3044.84 | 3043.2 | 3043.74 | 1133.0 |
| 2018-06-13 06:30:00 | ES | Futures | 3043.74 | 3044.84 | 3042.92 | 3044.29 | 634.0 |
| 2018-06-13 07:00:00 | ES | Futures | 3044.56 | 3045.38 | 3043.47 | 3044.56 | 1539.0 |
| 2018-06-13 07:30:00 | ES | Futures | 3044.29 | 3045.11 | 3044.02 | 3044.29 | 806.0 |
| 2018-06-13 08:00:00 | ES | Futures | 3044.29 | 3044.29 | 3043.2 | 3043.2 | 1709.0 |
| 2018-06-13 08:30:00 | ES | Futures | 3042.92 | 3043.74 | 3041.83 | 3042.92 | 2260.0 |
| 2018-06-13 09:00:00 | ES | Futures | 3043.2 | 3044.02 | 3042.11 | 3043.47 | 2999.0 |
| 2018-06-13 09:30:00 | ES | Futures | 3043.47 | 3044.84 | 3041.56 | 3042.38 | 19678.0 |
| 2018-06-13 10:00:00 | ES | Futures | 3042.38 | 3045.65 | 3042.38 | 3044.84 | 8311.0 |
| 2018-06-13 10:30:00 | ES | Futures | 3045.11 | 3046.47 | 3042.65 | 3043.74 | 12912.0 |
| 2018-06-13 11:00:00 | ES | Futures | 3044.02 | 3046.75 | 3044.02 | 3046.2 | 4714.0 |
| 2018-06-13 11:30:00 | ES | Futures | 3046.2 | 3047.02 | 3045.11 | 3045.65 | 4267.0 |
| 2018-06-13 12:00:00 | ES | Futures | 3045.65 | 3045.93 | 3042.11 | 3043.47 | 3613.0 |
| 2018-06-13 12:30:00 | ES | Futures | 3043.2 | 3044.02 | 3041.83 | 3041.83 | 3089.0 |
| 2018-06-13 13:00:00 | ES | Futures | 3041.83 | 3042.65 | 3040.47 | 3041.83 | 3955.0 |
| 2018-06-13 13:30:00 | ES | Futures | 3041.56 | 3043.47 | 3041.29 | 3042.65 | 2353.0 |
| 2018-06-13 14:00:00 | ES | Futures | 3042.92 | 3043.47 | 3033.1 | 3034.19 | 22944.0 |
| 2018-06-13 14:30:00 | ES | Futures | 3034.19 | 3039.92 | 3030.64 | 3038.83 | 20288.0 |
| 2018-06-13 15:00:00 | ES | Futures | 3038.56 | 3044.29 | 3036.1 | 3037.19 | 15998.0 |
| 2018-06-13 15:30:00 | ES | Futures | 3037.47 | 3038.01 | 3028.19 | 3029.83 | 24062.0 |
| 2018-06-13 16:00:00 | ES | Futures | 3029.83 | 3032.55 | 3027.91 | 3027.91 | 11003.0 |
| 2018-06-13 16:30:00 | ES | Futures | 3029.01 | 3030.1 | 3027.91 | 3029.55 | 1895.0 |
| 2018-06-13 18:00:00 | ES | Futures | 3027.37 | 3031.19 | 3027.37 | 3030.1 | 256.0 |
| 2018-06-13 18:30:00 | ES | Futures | 3030.1 | 3031.19 | 3030.1 | 3030.92 | 63.0 |
| 2018-06-13 19:00:00 | ES | Futures | 3031.19 | 3031.46 | 3029.83 | 3029.83 | 377.0 |
| 2018-06-13 19:30:00 | ES | Futures | 3029.55 | 3031.19 | 3029.01 | 3030.1 | 233.0 |
| 2018-06-13 20:00:00 | ES | Futures | 3030.37 | 3030.92 | 3029.01 | 3030.92 | 934.0 |
| 2018-06-13 20:30:00 | ES | Futures | 3030.92 | 3032.55 | 3030.37 | 3032.55 | 531.0 |
| 2018-06-13 21:00:00 | ES | Futures | 3032.55 | 3033.65 | 3032.28 | 3032.83 | 766.0 |
| 2018-06-13 21:30:00 | ES | Futures | 3032.83 | 3033.37 | 3032.28 | 3033.1 | 875.0 |
| 2018-06-13 22:00:00 | ES | Futures | 3033.1 | 3033.37 | 3031.46 | 3031.74 | 423.0 |
| 2018-06-13 22:30:00 | ES | Futures | 3031.74 | 3032.01 | 3028.19 | 3028.19 | 559.0 |
| 2018-06-13 23:00:00 | ES | Futures | 3028.19 | 3029.55 | 3027.37 | 3029.01 | 652.0 |
| 2018-06-13 23:30:00 | ES | Futures | 3029.28 | 3030.1 | 3028.73 | 3029.83 | 139.0 |
| 2018-06-13 00:00:00 | NQ | Futures | 8536.74 | 8538.51 | 8534.97 | 8536.45 | 68.0 |
| 2018-06-13 00:30:00 | NQ | Futures | 8536.15 | 8538.22 | 8534.38 | 8538.22 | 78.0 |
| 2018-06-13 01:00:00 | NQ | Futures | 8538.22 | 8539.4 | 8536.45 | 8537.92 | 115.0 |
| 2018-06-13 01:30:00 | NQ | Futures | 8537.63 | 8537.92 | 8535.56 | 8537.04 | 117.0 |
> showing 50 of 3,056 rows — these rows as CSV