PREVIEW / futures_30min / 2019-05-07
file: by_date/futures_30min/2019/2019-05-07.parquet size: 98 KB rows: 3,528
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-05-07 00:00:00 | ES | Futures | 3158.34 | 3161.59 | 3158.34 | 3159.97 | 5404.0 |
| 2019-05-07 00:30:00 | ES | Futures | 3159.97 | 3164.03 | 3158.61 | 3163.49 | 8281.0 |
| 2019-05-07 01:00:00 | ES | Futures | 3163.76 | 3163.76 | 3159.15 | 3159.43 | 5132.0 |
| 2019-05-07 01:30:00 | ES | Futures | 3159.43 | 3162.41 | 3158.88 | 3162.14 | 3786.0 |
| 2019-05-07 02:00:00 | ES | Futures | 3161.87 | 3176.78 | 3161.32 | 3176.23 | 22783.0 |
| 2019-05-07 02:30:00 | ES | Futures | 3176.23 | 3177.86 | 3173.52 | 3173.79 | 9577.0 |
| 2019-05-07 03:00:00 | ES | Futures | 3174.07 | 3175.42 | 3170.81 | 3172.17 | 10866.0 |
| 2019-05-07 03:30:00 | ES | Futures | 3171.9 | 3174.61 | 3170.27 | 3171.35 | 9571.0 |
| 2019-05-07 04:00:00 | ES | Futures | 3171.35 | 3172.44 | 3168.1 | 3169.46 | 9426.0 |
| 2019-05-07 04:30:00 | ES | Futures | 3169.19 | 3169.73 | 3165.93 | 3167.02 | 8705.0 |
| 2019-05-07 05:00:00 | ES | Futures | 3166.75 | 3167.02 | 3163.49 | 3164.03 | 9249.0 |
| 2019-05-07 05:30:00 | ES | Futures | 3164.03 | 3165.93 | 3161.87 | 3165.12 | 10763.0 |
| 2019-05-07 06:00:00 | ES | Futures | 3165.12 | 3165.93 | 3162.95 | 3164.58 | 8656.0 |
| 2019-05-07 06:30:00 | ES | Futures | 3164.31 | 3165.12 | 3159.15 | 3159.7 | 9836.0 |
| 2019-05-07 07:00:00 | ES | Futures | 3159.97 | 3161.05 | 3158.88 | 3160.78 | 9063.0 |
| 2019-05-07 07:30:00 | ES | Futures | 3160.78 | 3163.22 | 3154.0 | 3155.63 | 21330.0 |
| 2019-05-07 08:00:00 | ES | Futures | 3155.36 | 3160.78 | 3153.73 | 3159.7 | 26643.0 |
| 2019-05-07 08:30:00 | ES | Futures | 3159.43 | 3160.78 | 3158.34 | 3158.34 | 19513.0 |
| 2019-05-07 09:00:00 | ES | Futures | 3158.34 | 3158.61 | 3147.77 | 3151.02 | 68579.0 |
| 2019-05-07 09:30:00 | ES | Futures | 3151.29 | 3158.88 | 3139.91 | 3147.5 | 348692.0 |
| 2019-05-07 10:00:00 | ES | Futures | 3147.5 | 3147.77 | 3134.21 | 3145.33 | 216853.0 |
| 2019-05-07 10:30:00 | ES | Futures | 3145.6 | 3146.41 | 3130.96 | 3132.86 | 164529.0 |
| 2019-05-07 11:00:00 | ES | Futures | 3132.86 | 3138.55 | 3127.71 | 3134.76 | 160346.0 |
| 2019-05-07 11:30:00 | ES | Futures | 3134.76 | 3139.36 | 3125.81 | 3129.6 | 160282.0 |
| 2019-05-07 12:00:00 | ES | Futures | 3129.33 | 3139.09 | 3124.72 | 3138.01 | 95459.0 |
| 2019-05-07 12:30:00 | ES | Futures | 3138.01 | 3139.91 | 3132.32 | 3132.32 | 69393.0 |
| 2019-05-07 13:00:00 | ES | Futures | 3132.32 | 3133.4 | 3116.32 | 3118.22 | 129916.0 |
| 2019-05-07 13:30:00 | ES | Futures | 3118.22 | 3124.18 | 3113.34 | 3119.84 | 160773.0 |
| 2019-05-07 14:00:00 | ES | Futures | 3119.57 | 3124.18 | 3113.34 | 3114.42 | 117264.0 |
| 2019-05-07 14:30:00 | ES | Futures | 3114.42 | 3119.84 | 3109.0 | 3117.13 | 142539.0 |
| 2019-05-07 15:00:00 | ES | Futures | 3117.13 | 3121.2 | 3111.17 | 3113.34 | 116268.0 |
| 2019-05-07 15:30:00 | ES | Futures | 3113.07 | 3130.42 | 3104.12 | 3128.52 | 317393.0 |
| 2019-05-07 16:00:00 | ES | Futures | 3128.52 | 3135.84 | 3127.98 | 3134.76 | 118117.0 |
| 2019-05-07 16:30:00 | ES | Futures | 3133.67 | 3135.03 | 3131.5 | 3134.76 | 14446.0 |
| 2019-05-07 18:00:00 | ES | Futures | 3133.67 | 3134.76 | 3128.79 | 3130.15 | 6306.0 |
| 2019-05-07 18:30:00 | ES | Futures | 3130.15 | 3133.13 | 3129.6 | 3130.96 | 3057.0 |
| 2019-05-07 19:00:00 | ES | Futures | 3131.23 | 3132.59 | 3129.88 | 3130.15 | 2376.0 |
| 2019-05-07 19:30:00 | ES | Futures | 3130.15 | 3130.96 | 3127.16 | 3128.25 | 5437.0 |
| 2019-05-07 20:00:00 | ES | Futures | 3128.25 | 3132.04 | 3126.08 | 3130.96 | 12235.0 |
| 2019-05-07 20:30:00 | ES | Futures | 3130.69 | 3132.59 | 3129.06 | 3130.15 | 9669.0 |
| 2019-05-07 21:00:00 | ES | Futures | 3130.15 | 3135.84 | 3130.15 | 3135.03 | 10895.0 |
| 2019-05-07 21:30:00 | ES | Futures | 3135.3 | 3137.2 | 3133.67 | 3136.38 | 10426.0 |
| 2019-05-07 22:00:00 | ES | Futures | 3136.38 | 3139.91 | 3134.48 | 3138.55 | 12921.0 |
| 2019-05-07 22:30:00 | ES | Futures | 3138.28 | 3139.91 | 3137.47 | 3137.74 | 7522.0 |
| 2019-05-07 23:00:00 | ES | Futures | 3138.01 | 3138.55 | 3135.84 | 3137.2 | 8985.0 |
| 2019-05-07 23:30:00 | ES | Futures | 3137.47 | 3138.01 | 3133.94 | 3135.84 | 3993.0 |
| 2019-05-07 00:00:00 | NQ | Futures | 9018.56 | 9026.13 | 9018.27 | 9020.89 | 1672.0 |
| 2019-05-07 00:30:00 | NQ | Futures | 9020.6 | 9033.99 | 9017.39 | 9032.83 | 3002.0 |
| 2019-05-07 01:00:00 | NQ | Futures | 9032.83 | 9033.41 | 9015.94 | 9017.1 | 2195.0 |
| 2019-05-07 01:30:00 | NQ | Futures | 9017.1 | 9025.55 | 9015.65 | 9024.96 | 1608.0 |
> showing 50 of 3,528 rows — these rows as CSV