PREVIEW / futures_30min / 2019-08-30
file: by_date/futures_30min/2019/2019-08-30.parquet size: 78 KB rows: 2,748
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-30 00:00:00 | ES | Futures | 3176.18 | 3176.45 | 3175.1 | 3175.37 | 2444.0 |
| 2019-08-30 00:30:00 | ES | Futures | 3175.37 | 3176.18 | 3174.29 | 3174.83 | 1776.0 |
| 2019-08-30 01:00:00 | ES | Futures | 3174.83 | 3174.83 | 3169.96 | 3171.31 | 6220.0 |
| 2019-08-30 01:30:00 | ES | Futures | 3171.04 | 3173.48 | 3170.23 | 3173.48 | 4998.0 |
| 2019-08-30 02:00:00 | ES | Futures | 3173.48 | 3173.48 | 3164.54 | 3165.63 | 12987.0 |
| 2019-08-30 02:30:00 | ES | Futures | 3165.63 | 3170.77 | 3164.81 | 3168.33 | 8998.0 |
| 2019-08-30 03:00:00 | ES | Futures | 3168.33 | 3176.72 | 3165.9 | 3175.37 | 36634.0 |
| 2019-08-30 03:30:00 | ES | Futures | 3175.37 | 3178.62 | 3172.39 | 3177.81 | 19008.0 |
| 2019-08-30 04:00:00 | ES | Futures | 3177.81 | 3179.97 | 3176.72 | 3178.89 | 14526.0 |
| 2019-08-30 04:30:00 | ES | Futures | 3179.16 | 3185.39 | 3178.35 | 3184.03 | 21608.0 |
| 2019-08-30 05:00:00 | ES | Futures | 3184.03 | 3186.47 | 3183.22 | 3186.2 | 18562.0 |
| 2019-08-30 05:30:00 | ES | Futures | 3186.2 | 3190.53 | 3185.39 | 3189.45 | 19693.0 |
| 2019-08-30 06:00:00 | ES | Futures | 3189.45 | 3189.99 | 3186.47 | 3188.64 | 21247.0 |
| 2019-08-30 06:30:00 | ES | Futures | 3188.64 | 3189.72 | 3187.01 | 3189.45 | 8472.0 |
| 2019-08-30 07:00:00 | ES | Futures | 3189.45 | 3189.99 | 3183.76 | 3185.12 | 13436.0 |
| 2019-08-30 07:30:00 | ES | Futures | 3185.12 | 3188.91 | 3184.57 | 3188.64 | 10415.0 |
| 2019-08-30 08:00:00 | ES | Futures | 3188.36 | 3188.64 | 3184.85 | 3187.82 | 13210.0 |
| 2019-08-30 08:30:00 | ES | Futures | 3188.09 | 3188.91 | 3186.2 | 3187.01 | 12891.0 |
| 2019-08-30 09:00:00 | ES | Futures | 3187.01 | 3187.55 | 3183.49 | 3184.85 | 19550.0 |
| 2019-08-30 09:30:00 | ES | Futures | 3185.12 | 3185.39 | 3176.45 | 3178.62 | 133712.0 |
| 2019-08-30 10:00:00 | ES | Futures | 3178.62 | 3184.3 | 3174.56 | 3176.45 | 111806.0 |
| 2019-08-30 10:30:00 | ES | Futures | 3176.45 | 3179.43 | 3172.12 | 3172.12 | 84203.0 |
| 2019-08-30 11:00:00 | ES | Futures | 3172.39 | 3173.48 | 3154.53 | 3158.05 | 160415.0 |
| 2019-08-30 11:30:00 | ES | Futures | 3158.32 | 3167.52 | 3158.05 | 3165.08 | 87400.0 |
| 2019-08-30 12:00:00 | ES | Futures | 3164.81 | 3168.6 | 3162.38 | 3168.33 | 55443.0 |
| 2019-08-30 12:30:00 | ES | Futures | 3168.06 | 3171.58 | 3165.9 | 3169.96 | 38321.0 |
| 2019-08-30 13:00:00 | ES | Futures | 3169.96 | 3171.31 | 3164.54 | 3165.9 | 36269.0 |
| 2019-08-30 13:30:00 | ES | Futures | 3165.9 | 3166.98 | 3162.65 | 3164.54 | 33447.0 |
| 2019-08-30 14:00:00 | ES | Futures | 3164.54 | 3169.14 | 3164.54 | 3168.06 | 36334.0 |
| 2019-08-30 14:30:00 | ES | Futures | 3168.06 | 3169.14 | 3160.21 | 3162.38 | 64612.0 |
| 2019-08-30 15:00:00 | ES | Futures | 3162.11 | 3165.35 | 3157.23 | 3164.0 | 69361.0 |
| 2019-08-30 15:30:00 | ES | Futures | 3164.27 | 3171.85 | 3162.38 | 3165.35 | 249694.0 |
| 2019-08-30 16:00:00 | ES | Futures | 3165.35 | 3166.44 | 3161.02 | 3163.19 | 83545.0 |
| 2019-08-30 16:30:00 | ES | Futures | 3162.38 | 3165.9 | 3162.11 | 3165.9 | 9648.0 |
| 2019-08-30 00:00:00 | NQ | Futures | 8970.04 | 8970.91 | 8965.69 | 8965.98 | 1147.0 |
| 2019-08-30 00:30:00 | NQ | Futures | 8965.69 | 8968.01 | 8962.5 | 8963.95 | 933.0 |
| 2019-08-30 01:00:00 | NQ | Futures | 8964.24 | 8964.53 | 8952.05 | 8955.25 | 2748.0 |
| 2019-08-30 01:30:00 | NQ | Futures | 8955.25 | 8960.18 | 8951.76 | 8960.18 | 3010.0 |
| 2019-08-30 02:00:00 | NQ | Futures | 8959.89 | 8960.18 | 8927.39 | 8933.2 | 5359.0 |
| 2019-08-30 02:30:00 | NQ | Futures | 8932.91 | 8955.83 | 8929.42 | 8945.38 | 4385.0 |
| 2019-08-30 03:00:00 | NQ | Futures | 8945.38 | 8974.4 | 8934.36 | 8969.75 | 13067.0 |
| 2019-08-30 03:30:00 | NQ | Futures | 8969.75 | 8979.91 | 8958.73 | 8978.17 | 6583.0 |
| 2019-08-30 04:00:00 | NQ | Futures | 8977.88 | 8987.45 | 8974.4 | 8984.26 | 4834.0 |
| 2019-08-30 04:30:00 | NQ | Futures | 8984.55 | 9000.8 | 8981.94 | 8997.9 | 6709.0 |
| 2019-08-30 05:00:00 | NQ | Futures | 8997.61 | 9006.6 | 8995.87 | 9006.31 | 6619.0 |
| 2019-08-30 05:30:00 | NQ | Futures | 9006.02 | 9018.21 | 9000.22 | 9014.73 | 7995.0 |
| 2019-08-30 06:00:00 | NQ | Futures | 9014.44 | 9016.76 | 9002.54 | 9007.76 | 5825.0 |
| 2019-08-30 06:30:00 | NQ | Futures | 9007.47 | 9013.27 | 9002.83 | 9013.27 | 3228.0 |
| 2019-08-30 07:00:00 | NQ | Futures | 9012.98 | 9014.44 | 8995.0 | 8997.9 | 4728.0 |
| 2019-08-30 07:30:00 | NQ | Futures | 8997.61 | 9009.5 | 8996.16 | 9007.18 | 3995.0 |
> showing 50 of 2,748 rows — these rows as CSV