PREVIEW / futures_30min / 2019-08-14
file: by_date/futures_30min/2019/2019-08-14.parquet size: 102 KB rows: 3,553
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-14 00:00:00 | ES | Futures | 3169.41 | 3172.93 | 3169.41 | 3171.58 | 3771.0 |
| 2019-08-14 00:30:00 | ES | Futures | 3171.85 | 3175.64 | 3170.5 | 3174.02 | 5873.0 |
| 2019-08-14 01:00:00 | ES | Futures | 3174.29 | 3176.18 | 3172.12 | 3172.12 | 3788.0 |
| 2019-08-14 01:30:00 | ES | Futures | 3172.39 | 3173.48 | 3171.31 | 3172.93 | 2518.0 |
| 2019-08-14 02:00:00 | ES | Futures | 3173.2 | 3174.29 | 3170.77 | 3174.02 | 7063.0 |
| 2019-08-14 02:30:00 | ES | Futures | 3174.29 | 3175.37 | 3171.85 | 3172.12 | 7090.0 |
| 2019-08-14 03:00:00 | ES | Futures | 3171.85 | 3172.39 | 3163.73 | 3165.63 | 19049.0 |
| 2019-08-14 03:30:00 | ES | Futures | 3165.63 | 3167.79 | 3163.46 | 3167.79 | 13716.0 |
| 2019-08-14 04:00:00 | ES | Futures | 3168.06 | 3169.41 | 3166.17 | 3168.06 | 11744.0 |
| 2019-08-14 04:30:00 | ES | Futures | 3168.33 | 3169.69 | 3159.94 | 3162.92 | 18569.0 |
| 2019-08-14 05:00:00 | ES | Futures | 3162.92 | 3163.73 | 3156.69 | 3157.77 | 16111.0 |
| 2019-08-14 05:30:00 | ES | Futures | 3158.05 | 3159.13 | 3154.8 | 3156.15 | 15811.0 |
| 2019-08-14 06:00:00 | ES | Futures | 3155.88 | 3156.15 | 3142.34 | 3146.68 | 38828.0 |
| 2019-08-14 06:30:00 | ES | Futures | 3146.68 | 3150.74 | 3144.78 | 3146.95 | 20254.0 |
| 2019-08-14 07:00:00 | ES | Futures | 3146.95 | 3148.57 | 3142.89 | 3146.95 | 19480.0 |
| 2019-08-14 07:30:00 | ES | Futures | 3146.95 | 3147.76 | 3128.54 | 3132.33 | 54481.0 |
| 2019-08-14 08:00:00 | ES | Futures | 3132.33 | 3136.93 | 3125.02 | 3132.6 | 70602.0 |
| 2019-08-14 08:30:00 | ES | Futures | 3132.06 | 3134.49 | 3125.56 | 3133.41 | 45836.0 |
| 2019-08-14 09:00:00 | ES | Futures | 3133.41 | 3135.31 | 3117.71 | 3121.23 | 69586.0 |
| 2019-08-14 09:30:00 | ES | Futures | 3121.23 | 3129.08 | 3113.92 | 3123.94 | 283809.0 |
| 2019-08-14 10:00:00 | ES | Futures | 3123.94 | 3124.48 | 3111.75 | 3119.88 | 171599.0 |
| 2019-08-14 10:30:00 | ES | Futures | 3119.61 | 3120.69 | 3104.99 | 3105.26 | 136543.0 |
| 2019-08-14 11:00:00 | ES | Futures | 3105.53 | 3107.42 | 3092.81 | 3100.11 | 203950.0 |
| 2019-08-14 11:30:00 | ES | Futures | 3100.11 | 3104.99 | 3092.26 | 3095.78 | 114950.0 |
| 2019-08-14 12:00:00 | ES | Futures | 3095.51 | 3095.51 | 3086.85 | 3090.64 | 128867.0 |
| 2019-08-14 12:30:00 | ES | Futures | 3090.37 | 3096.6 | 3079.27 | 3081.44 | 112493.0 |
| 2019-08-14 13:00:00 | ES | Futures | 3081.17 | 3097.95 | 3076.56 | 3091.99 | 129484.0 |
| 2019-08-14 13:30:00 | ES | Futures | 3091.72 | 3098.76 | 3090.91 | 3093.35 | 119398.0 |
| 2019-08-14 14:00:00 | ES | Futures | 3093.62 | 3095.78 | 3086.31 | 3086.85 | 87224.0 |
| 2019-08-14 14:30:00 | ES | Futures | 3087.12 | 3089.83 | 3076.83 | 3082.79 | 118064.0 |
| 2019-08-14 15:00:00 | ES | Futures | 3083.06 | 3094.43 | 3074.4 | 3083.87 | 162151.0 |
| 2019-08-14 15:30:00 | ES | Futures | 3083.87 | 3086.58 | 3074.67 | 3076.56 | 277704.0 |
| 2019-08-14 16:00:00 | ES | Futures | 3076.29 | 3080.08 | 3072.5 | 3075.21 | 102660.0 |
| 2019-08-14 16:30:00 | ES | Futures | 3075.48 | 3076.83 | 3070.61 | 3070.61 | 16831.0 |
| 2019-08-14 18:00:00 | ES | Futures | 3070.88 | 3073.59 | 3068.44 | 3073.59 | 8869.0 |
| 2019-08-14 18:30:00 | ES | Futures | 3073.59 | 3076.29 | 3069.8 | 3070.07 | 6879.0 |
| 2019-08-14 19:00:00 | ES | Futures | 3070.07 | 3075.21 | 3070.07 | 3074.4 | 5444.0 |
| 2019-08-14 19:30:00 | ES | Futures | 3074.4 | 3082.52 | 3074.4 | 3082.25 | 9911.0 |
| 2019-08-14 20:00:00 | ES | Futures | 3081.98 | 3085.77 | 3081.98 | 3082.25 | 15010.0 |
| 2019-08-14 20:30:00 | ES | Futures | 3082.52 | 3084.68 | 3080.62 | 3082.79 | 9043.0 |
| 2019-08-14 21:00:00 | ES | Futures | 3083.06 | 3088.47 | 3080.89 | 3083.33 | 13995.0 |
| 2019-08-14 21:30:00 | ES | Futures | 3083.6 | 3093.08 | 3081.98 | 3092.26 | 17634.0 |
| 2019-08-14 22:00:00 | ES | Futures | 3092.26 | 3092.53 | 3087.66 | 3092.26 | 10111.0 |
| 2019-08-14 22:30:00 | ES | Futures | 3092.53 | 3094.16 | 3090.1 | 3090.37 | 8842.0 |
| 2019-08-14 23:00:00 | ES | Futures | 3090.64 | 3092.53 | 3090.1 | 3092.26 | 4103.0 |
| 2019-08-14 23:30:00 | ES | Futures | 3091.99 | 3092.53 | 3083.06 | 3083.6 | 8700.0 |
| 2019-08-14 00:00:00 | NQ | Futures | 8976.43 | 8986.0 | 8976.43 | 8983.68 | 1714.0 |
| 2019-08-14 00:30:00 | NQ | Futures | 8983.68 | 9001.67 | 8978.46 | 8998.48 | 3427.0 |
| 2019-08-14 01:00:00 | NQ | Futures | 8998.48 | 9004.28 | 8986.58 | 8986.58 | 2749.0 |
| 2019-08-14 01:30:00 | NQ | Futures | 8986.29 | 8992.96 | 8984.26 | 8992.09 | 1686.0 |
> showing 50 of 3,553 rows — these rows as CSV