PREVIEW / futures_30min / 2019-06-26
file: by_date/futures_30min/2019/2019-06-26.parquet size: 92 KB rows: 3,454
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-06-26 00:00:00 | ES | Futures | 3165.63 | 3166.17 | 3165.08 | 3165.63 | 995.0 |
| 2019-06-26 00:30:00 | ES | Futures | 3165.9 | 3165.9 | 3162.11 | 3162.38 | 3239.0 |
| 2019-06-26 01:00:00 | ES | Futures | 3162.38 | 3164.27 | 3162.11 | 3163.19 | 2230.0 |
| 2019-06-26 01:30:00 | ES | Futures | 3163.19 | 3165.08 | 3162.11 | 3164.81 | 2864.0 |
| 2019-06-26 02:00:00 | ES | Futures | 3164.81 | 3166.17 | 3164.27 | 3164.54 | 3412.0 |
| 2019-06-26 02:30:00 | ES | Futures | 3164.81 | 3167.52 | 3164.27 | 3166.71 | 4857.0 |
| 2019-06-26 03:00:00 | ES | Futures | 3166.71 | 3167.79 | 3164.27 | 3165.08 | 13027.0 |
| 2019-06-26 03:30:00 | ES | Futures | 3164.81 | 3166.98 | 3164.27 | 3166.44 | 7881.0 |
| 2019-06-26 04:00:00 | ES | Futures | 3166.17 | 3167.25 | 3165.35 | 3165.63 | 7756.0 |
| 2019-06-26 04:30:00 | ES | Futures | 3165.9 | 3169.69 | 3165.63 | 3169.14 | 9025.0 |
| 2019-06-26 05:00:00 | ES | Futures | 3169.41 | 3181.6 | 3168.6 | 3180.78 | 45942.0 |
| 2019-06-26 05:30:00 | ES | Futures | 3180.78 | 3181.33 | 3178.62 | 3179.16 | 16918.0 |
| 2019-06-26 06:00:00 | ES | Futures | 3179.16 | 3182.41 | 3179.16 | 3180.78 | 11729.0 |
| 2019-06-26 06:30:00 | ES | Futures | 3180.78 | 3181.06 | 3176.72 | 3177.81 | 14906.0 |
| 2019-06-26 07:00:00 | ES | Futures | 3177.54 | 3179.16 | 3176.18 | 3177.27 | 10507.0 |
| 2019-06-26 07:30:00 | ES | Futures | 3177.27 | 3178.62 | 3175.91 | 3177.27 | 8883.0 |
| 2019-06-26 08:00:00 | ES | Futures | 3177.27 | 3178.62 | 3174.83 | 3175.91 | 19750.0 |
| 2019-06-26 08:30:00 | ES | Futures | 3175.91 | 3176.45 | 3169.14 | 3172.66 | 35354.0 |
| 2019-06-26 09:00:00 | ES | Futures | 3172.39 | 3175.1 | 3171.04 | 3173.75 | 19055.0 |
| 2019-06-26 09:30:00 | ES | Futures | 3174.02 | 3179.97 | 3169.69 | 3172.12 | 169900.0 |
| 2019-06-26 10:00:00 | ES | Futures | 3172.12 | 3172.66 | 3166.44 | 3169.14 | 101202.0 |
| 2019-06-26 10:30:00 | ES | Futures | 3169.14 | 3174.29 | 3168.87 | 3172.66 | 72680.0 |
| 2019-06-26 11:00:00 | ES | Futures | 3172.39 | 3174.83 | 3168.06 | 3171.31 | 57869.0 |
| 2019-06-26 11:30:00 | ES | Futures | 3171.31 | 3171.31 | 3167.25 | 3171.04 | 49279.0 |
| 2019-06-26 12:00:00 | ES | Futures | 3170.77 | 3172.39 | 3167.52 | 3170.23 | 44156.0 |
| 2019-06-26 12:30:00 | ES | Futures | 3169.96 | 3173.48 | 3169.69 | 3171.31 | 29514.0 |
| 2019-06-26 13:00:00 | ES | Futures | 3171.04 | 3171.85 | 3165.9 | 3165.9 | 35610.0 |
| 2019-06-26 13:30:00 | ES | Futures | 3165.9 | 3166.44 | 3162.65 | 3165.63 | 42891.0 |
| 2019-06-26 14:00:00 | ES | Futures | 3165.35 | 3167.52 | 3163.19 | 3165.9 | 34454.0 |
| 2019-06-26 14:30:00 | ES | Futures | 3165.63 | 3165.9 | 3158.59 | 3162.92 | 63946.0 |
| 2019-06-26 15:00:00 | ES | Futures | 3162.65 | 3165.35 | 3161.84 | 3162.11 | 46374.0 |
| 2019-06-26 15:30:00 | ES | Futures | 3162.11 | 3166.71 | 3159.4 | 3160.48 | 111333.0 |
| 2019-06-26 16:00:00 | ES | Futures | 3160.48 | 3161.29 | 3158.32 | 3159.67 | 49150.0 |
| 2019-06-26 16:30:00 | ES | Futures | 3159.4 | 3160.75 | 3155.88 | 3156.69 | 8059.0 |
| 2019-06-26 18:00:00 | ES | Futures | 3156.15 | 3158.86 | 3156.15 | 3158.86 | 2742.0 |
| 2019-06-26 18:30:00 | ES | Futures | 3158.86 | 3159.4 | 3157.23 | 3157.23 | 1571.0 |
| 2019-06-26 19:00:00 | ES | Futures | 3156.96 | 3159.13 | 3156.96 | 3158.59 | 1196.0 |
| 2019-06-26 19:30:00 | ES | Futures | 3158.59 | 3160.75 | 3158.59 | 3160.48 | 1963.0 |
| 2019-06-26 20:00:00 | ES | Futures | 3160.48 | 3161.56 | 3159.4 | 3160.75 | 4648.0 |
| 2019-06-26 20:30:00 | ES | Futures | 3160.48 | 3162.92 | 3160.48 | 3162.38 | 4367.0 |
| 2019-06-26 21:00:00 | ES | Futures | 3162.65 | 3164.54 | 3162.11 | 3164.0 | 5773.0 |
| 2019-06-26 21:30:00 | ES | Futures | 3164.0 | 3169.14 | 3163.73 | 3168.06 | 11487.0 |
| 2019-06-26 22:00:00 | ES | Futures | 3168.06 | 3170.23 | 3167.25 | 3169.14 | 8439.0 |
| 2019-06-26 22:30:00 | ES | Futures | 3169.14 | 3171.31 | 3168.6 | 3170.23 | 5059.0 |
| 2019-06-26 23:00:00 | ES | Futures | 3169.96 | 3170.23 | 3168.6 | 3169.14 | 2522.0 |
| 2019-06-26 23:30:00 | ES | Futures | 3169.41 | 3170.23 | 3169.14 | 3169.96 | 2323.0 |
| 2019-06-26 00:00:00 | NQ | Futures | 8866.17 | 8867.04 | 8863.56 | 8864.43 | 514.0 |
| 2019-06-26 00:30:00 | NQ | Futures | 8864.14 | 8865.88 | 8848.76 | 8848.76 | 2587.0 |
| 2019-06-26 01:00:00 | NQ | Futures | 8848.47 | 8854.28 | 8848.47 | 8851.09 | 1158.0 |
| 2019-06-26 01:30:00 | NQ | Futures | 8851.09 | 8857.76 | 8845.57 | 8857.47 | 1587.0 |
> showing 50 of 3,454 rows — these rows as CSV