PREVIEW / futures_30min / 2018-10-02
file: by_date/futures_30min/2018/2018-10-02.parquet size: 87 KB rows: 3,235
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-10-02 00:00:00 | ES | Futures | 3183.74 | 3184.28 | 3183.2 | 3183.2 | 780.0 |
| 2018-10-02 00:30:00 | ES | Futures | 3183.2 | 3184.28 | 3183.2 | 3183.2 | 2096.0 |
| 2018-10-02 01:00:00 | ES | Futures | 3183.47 | 3183.47 | 3181.56 | 3182.38 | 2339.0 |
| 2018-10-02 01:30:00 | ES | Futures | 3182.11 | 3182.92 | 3181.56 | 3182.11 | 2345.0 |
| 2018-10-02 02:00:00 | ES | Futures | 3181.84 | 3182.65 | 3179.39 | 3180.75 | 6289.0 |
| 2018-10-02 02:30:00 | ES | Futures | 3180.75 | 3180.75 | 3178.57 | 3179.12 | 5125.0 |
| 2018-10-02 03:00:00 | ES | Futures | 3179.39 | 3181.29 | 3178.03 | 3179.39 | 13653.0 |
| 2018-10-02 03:30:00 | ES | Futures | 3179.39 | 3182.92 | 3179.12 | 3182.92 | 9193.0 |
| 2018-10-02 04:00:00 | ES | Futures | 3182.65 | 3182.92 | 3179.66 | 3179.66 | 6787.0 |
| 2018-10-02 04:30:00 | ES | Futures | 3179.66 | 3180.2 | 3175.31 | 3176.4 | 12105.0 |
| 2018-10-02 05:00:00 | ES | Futures | 3176.4 | 3177.48 | 3174.22 | 3176.94 | 13211.0 |
| 2018-10-02 05:30:00 | ES | Futures | 3176.94 | 3178.03 | 3174.76 | 3177.48 | 7153.0 |
| 2018-10-02 06:00:00 | ES | Futures | 3177.48 | 3179.66 | 3177.48 | 3178.03 | 7968.0 |
| 2018-10-02 06:30:00 | ES | Futures | 3178.03 | 3181.29 | 3177.21 | 3180.48 | 7817.0 |
| 2018-10-02 07:00:00 | ES | Futures | 3180.48 | 3182.38 | 3178.84 | 3180.2 | 10224.0 |
| 2018-10-02 07:30:00 | ES | Futures | 3180.2 | 3182.38 | 3179.66 | 3181.56 | 8859.0 |
| 2018-10-02 08:00:00 | ES | Futures | 3181.84 | 3184.56 | 3181.29 | 3184.28 | 11645.0 |
| 2018-10-02 08:30:00 | ES | Futures | 3184.28 | 3184.28 | 3182.65 | 3183.74 | 8836.0 |
| 2018-10-02 09:00:00 | ES | Futures | 3184.01 | 3185.92 | 3183.47 | 3185.64 | 16784.0 |
| 2018-10-02 09:30:00 | ES | Futures | 3185.64 | 3188.64 | 3183.74 | 3187.28 | 132174.0 |
| 2018-10-02 10:00:00 | ES | Futures | 3187.0 | 3187.28 | 3182.38 | 3185.37 | 82050.0 |
| 2018-10-02 10:30:00 | ES | Futures | 3185.1 | 3189.72 | 3181.29 | 3187.0 | 88677.0 |
| 2018-10-02 11:00:00 | ES | Futures | 3187.0 | 3189.72 | 3186.19 | 3187.55 | 51298.0 |
| 2018-10-02 11:30:00 | ES | Futures | 3187.55 | 3193.53 | 3187.28 | 3192.72 | 56230.0 |
| 2018-10-02 12:00:00 | ES | Futures | 3192.72 | 3194.35 | 3190.54 | 3191.9 | 48293.0 |
| 2018-10-02 12:30:00 | ES | Futures | 3191.9 | 3194.35 | 3188.91 | 3190.27 | 52400.0 |
| 2018-10-02 13:00:00 | ES | Futures | 3190.0 | 3192.72 | 3190.0 | 3191.63 | 31729.0 |
| 2018-10-02 13:30:00 | ES | Futures | 3191.63 | 3193.8 | 3191.36 | 3192.17 | 24645.0 |
| 2018-10-02 14:00:00 | ES | Futures | 3192.17 | 3194.35 | 3191.36 | 3193.53 | 27203.0 |
| 2018-10-02 14:30:00 | ES | Futures | 3193.53 | 3193.8 | 3188.09 | 3188.91 | 47111.0 |
| 2018-10-02 15:00:00 | ES | Futures | 3188.91 | 3188.91 | 3181.29 | 3183.74 | 102216.0 |
| 2018-10-02 15:30:00 | ES | Futures | 3183.74 | 3188.09 | 3183.47 | 3185.92 | 131897.0 |
| 2018-10-02 16:00:00 | ES | Futures | 3185.92 | 3186.73 | 3185.64 | 3186.46 | 40474.0 |
| 2018-10-02 16:30:00 | ES | Futures | 3186.46 | 3188.09 | 3186.19 | 3187.82 | 5710.0 |
| 2018-10-02 18:00:00 | ES | Futures | 3186.73 | 3187.55 | 3186.19 | 3187.28 | 2365.0 |
| 2018-10-02 18:30:00 | ES | Futures | 3187.55 | 3187.82 | 3186.73 | 3187.0 | 728.0 |
| 2018-10-02 19:00:00 | ES | Futures | 3187.0 | 3187.28 | 3186.46 | 3187.0 | 606.0 |
| 2018-10-02 19:30:00 | ES | Futures | 3187.0 | 3187.55 | 3185.37 | 3185.92 | 1522.0 |
| 2018-10-02 20:00:00 | ES | Futures | 3186.19 | 3186.46 | 3183.47 | 3184.01 | 4204.0 |
| 2018-10-02 20:30:00 | ES | Futures | 3184.28 | 3185.37 | 3183.2 | 3185.1 | 1927.0 |
| 2018-10-02 21:00:00 | ES | Futures | 3185.37 | 3186.19 | 3183.74 | 3184.56 | 2664.0 |
| 2018-10-02 21:30:00 | ES | Futures | 3184.83 | 3189.45 | 3184.01 | 3188.91 | 4695.0 |
| 2018-10-02 22:00:00 | ES | Futures | 3188.64 | 3194.08 | 3188.64 | 3192.72 | 12004.0 |
| 2018-10-02 22:30:00 | ES | Futures | 3192.72 | 3193.26 | 3191.36 | 3192.99 | 3743.0 |
| 2018-10-02 23:00:00 | ES | Futures | 3193.26 | 3193.26 | 3191.63 | 3191.9 | 1712.0 |
| 2018-10-02 23:30:00 | ES | Futures | 3191.9 | 3192.17 | 3190.0 | 3190.0 | 3768.0 |
| 2018-10-02 00:00:00 | NQ | Futures | 8993.6 | 8995.65 | 8991.84 | 8992.13 | 377.0 |
| 2018-10-02 00:30:00 | NQ | Futures | 8991.84 | 8995.65 | 8990.96 | 8992.72 | 536.0 |
| 2018-10-02 01:00:00 | NQ | Futures | 8992.72 | 8993.31 | 8983.04 | 8987.44 | 1317.0 |
| 2018-10-02 01:30:00 | NQ | Futures | 8987.44 | 8990.08 | 8984.21 | 8986.27 | 990.0 |
> showing 50 of 3,235 rows — these rows as CSV