PREVIEW / futures_30min / 2019-05-02
file: by_date/futures_30min/2019/2019-05-02.parquet size: 85 KB rows: 3,302
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-02 00:00:00 | ES | Futures | 3173.25 | 3173.25 | 3171.63 | 3172.44 | 2108.0 |
| 2019-05-02 00:30:00 | ES | Futures | 3172.71 | 3172.98 | 3171.63 | 3171.9 | 1655.0 |
| 2019-05-02 01:00:00 | ES | Futures | 3171.9 | 3172.17 | 3170.27 | 3170.54 | 3118.0 |
| 2019-05-02 01:30:00 | ES | Futures | 3170.81 | 3171.9 | 3170.54 | 3170.81 | 1954.0 |
| 2019-05-02 02:00:00 | ES | Futures | 3170.81 | 3173.52 | 3170.81 | 3173.25 | 6683.0 |
| 2019-05-02 02:30:00 | ES | Futures | 3173.52 | 3176.51 | 3172.44 | 3175.15 | 7950.0 |
| 2019-05-02 03:00:00 | ES | Futures | 3175.42 | 3175.42 | 3173.25 | 3173.79 | 9896.0 |
| 2019-05-02 03:30:00 | ES | Futures | 3173.52 | 3178.13 | 3173.25 | 3175.42 | 9198.0 |
| 2019-05-02 04:00:00 | ES | Futures | 3175.15 | 3175.42 | 3173.25 | 3175.42 | 8161.0 |
| 2019-05-02 04:30:00 | ES | Futures | 3175.42 | 3178.67 | 3175.15 | 3176.51 | 9005.0 |
| 2019-05-02 05:00:00 | ES | Futures | 3176.51 | 3179.76 | 3176.23 | 3178.67 | 8813.0 |
| 2019-05-02 05:30:00 | ES | Futures | 3178.4 | 3179.76 | 3178.13 | 3179.22 | 5972.0 |
| 2019-05-02 06:00:00 | ES | Futures | 3179.22 | 3179.22 | 3175.15 | 3175.69 | 7910.0 |
| 2019-05-02 06:30:00 | ES | Futures | 3175.96 | 3178.95 | 3175.69 | 3176.23 | 7696.0 |
| 2019-05-02 07:00:00 | ES | Futures | 3176.23 | 3177.05 | 3171.63 | 3173.79 | 12368.0 |
| 2019-05-02 07:30:00 | ES | Futures | 3173.52 | 3175.69 | 3172.44 | 3174.07 | 11105.0 |
| 2019-05-02 08:00:00 | ES | Futures | 3173.79 | 3174.61 | 3169.73 | 3171.35 | 17682.0 |
| 2019-05-02 08:30:00 | ES | Futures | 3171.63 | 3173.79 | 3167.56 | 3169.73 | 28381.0 |
| 2019-05-02 09:00:00 | ES | Futures | 3169.73 | 3170.27 | 3167.83 | 3169.19 | 18011.0 |
| 2019-05-02 09:30:00 | ES | Futures | 3169.46 | 3176.23 | 3165.66 | 3174.61 | 174487.0 |
| 2019-05-02 10:00:00 | ES | Futures | 3174.61 | 3180.3 | 3174.34 | 3176.51 | 99185.0 |
| 2019-05-02 10:30:00 | ES | Futures | 3176.51 | 3178.95 | 3168.37 | 3168.64 | 89617.0 |
| 2019-05-02 11:00:00 | ES | Futures | 3168.91 | 3172.44 | 3155.9 | 3156.17 | 157264.0 |
| 2019-05-02 11:30:00 | ES | Futures | 3156.17 | 3162.14 | 3145.87 | 3151.02 | 228976.0 |
| 2019-05-02 12:00:00 | ES | Futures | 3151.02 | 3155.63 | 3148.04 | 3154.55 | 111218.0 |
| 2019-05-02 12:30:00 | ES | Futures | 3154.55 | 3159.7 | 3153.46 | 3156.71 | 100799.0 |
| 2019-05-02 13:00:00 | ES | Futures | 3156.44 | 3164.58 | 3151.84 | 3162.14 | 100297.0 |
| 2019-05-02 13:30:00 | ES | Futures | 3162.14 | 3165.93 | 3160.24 | 3161.59 | 82273.0 |
| 2019-05-02 14:00:00 | ES | Futures | 3161.59 | 3167.02 | 3160.24 | 3163.49 | 80628.0 |
| 2019-05-02 14:30:00 | ES | Futures | 3163.22 | 3165.93 | 3155.36 | 3159.43 | 75885.0 |
| 2019-05-02 15:00:00 | ES | Futures | 3159.15 | 3165.39 | 3158.34 | 3163.49 | 59535.0 |
| 2019-05-02 15:30:00 | ES | Futures | 3163.76 | 3165.66 | 3158.88 | 3165.12 | 146805.0 |
| 2019-05-02 16:00:00 | ES | Futures | 3165.12 | 3165.12 | 3161.05 | 3164.31 | 44529.0 |
| 2019-05-02 16:30:00 | ES | Futures | 3164.03 | 3166.2 | 3163.49 | 3165.39 | 7134.0 |
| 2019-05-02 18:00:00 | ES | Futures | 3164.85 | 3168.1 | 3164.31 | 3165.66 | 4076.0 |
| 2019-05-02 18:30:00 | ES | Futures | 3165.66 | 3167.02 | 3165.12 | 3166.2 | 1047.0 |
| 2019-05-02 19:00:00 | ES | Futures | 3166.2 | 3167.02 | 3165.66 | 3165.66 | 1069.0 |
| 2019-05-02 19:30:00 | ES | Futures | 3165.93 | 3167.29 | 3165.39 | 3165.66 | 2169.0 |
| 2019-05-02 20:00:00 | ES | Futures | 3165.66 | 3167.02 | 3163.76 | 3166.75 | 3819.0 |
| 2019-05-02 20:30:00 | ES | Futures | 3166.75 | 3167.56 | 3166.47 | 3167.29 | 1608.0 |
| 2019-05-02 21:00:00 | ES | Futures | 3167.29 | 3167.29 | 3163.76 | 3164.85 | 2957.0 |
| 2019-05-02 21:30:00 | ES | Futures | 3164.85 | 3166.47 | 3162.68 | 3166.47 | 4598.0 |
| 2019-05-02 22:00:00 | ES | Futures | 3166.47 | 3167.83 | 3165.39 | 3166.75 | 2752.0 |
| 2019-05-02 22:30:00 | ES | Futures | 3167.02 | 3169.46 | 3166.75 | 3169.19 | 2828.0 |
| 2019-05-02 23:00:00 | ES | Futures | 3169.19 | 3172.98 | 3168.91 | 3169.19 | 8644.0 |
| 2019-05-02 23:30:00 | ES | Futures | 3169.19 | 3170.27 | 3169.19 | 3169.19 | 1681.0 |
| 2019-05-02 00:00:00 | NQ | Futures | 9046.8 | 9048.84 | 9040.4 | 9045.93 | 1285.0 |
| 2019-05-02 00:30:00 | NQ | Futures | 9045.64 | 9047.38 | 9044.18 | 9044.18 | 736.0 |
| 2019-05-02 01:00:00 | NQ | Futures | 9043.89 | 9046.51 | 9040.69 | 9041.85 | 1370.0 |
| 2019-05-02 01:30:00 | NQ | Futures | 9042.14 | 9044.47 | 9038.36 | 9040.1 | 1423.0 |
> showing 50 of 3,302 rows — these rows as CSV