PREVIEW / futures_30min / 2019-07-02
file: by_date/futures_30min/2019/2019-07-02.parquet size: 95 KB rows: 3,493
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-07-02 00:00:00 | ES | Futures | 3216.79 | 3217.6 | 3216.52 | 3216.79 | 1839.0 |
| 2019-07-02 00:30:00 | ES | Futures | 3216.79 | 3217.87 | 3215.98 | 3217.06 | 2500.0 |
| 2019-07-02 01:00:00 | ES | Futures | 3217.06 | 3217.6 | 3214.35 | 3214.62 | 2735.0 |
| 2019-07-02 01:30:00 | ES | Futures | 3214.62 | 3215.71 | 3213.81 | 3215.16 | 3091.0 |
| 2019-07-02 02:00:00 | ES | Futures | 3215.16 | 3217.6 | 3214.89 | 3217.6 | 4379.0 |
| 2019-07-02 02:30:00 | ES | Futures | 3217.33 | 3218.14 | 3216.52 | 3217.06 | 3071.0 |
| 2019-07-02 03:00:00 | ES | Futures | 3217.06 | 3217.6 | 3211.1 | 3211.37 | 12661.0 |
| 2019-07-02 03:30:00 | ES | Futures | 3211.37 | 3213.54 | 3210.56 | 3210.83 | 8808.0 |
| 2019-07-02 04:00:00 | ES | Futures | 3210.83 | 3211.1 | 3207.31 | 3208.4 | 11070.0 |
| 2019-07-02 04:30:00 | ES | Futures | 3208.67 | 3209.48 | 3206.5 | 3208.4 | 7364.0 |
| 2019-07-02 05:00:00 | ES | Futures | 3208.4 | 3210.02 | 3207.31 | 3209.21 | 6262.0 |
| 2019-07-02 05:30:00 | ES | Futures | 3209.21 | 3210.56 | 3208.13 | 3208.67 | 9431.0 |
| 2019-07-02 06:00:00 | ES | Futures | 3208.67 | 3211.92 | 3208.13 | 3211.92 | 7004.0 |
| 2019-07-02 06:30:00 | ES | Futures | 3211.92 | 3212.73 | 3210.29 | 3211.1 | 4613.0 |
| 2019-07-02 07:00:00 | ES | Futures | 3211.1 | 3212.73 | 3208.94 | 3209.48 | 5402.0 |
| 2019-07-02 07:30:00 | ES | Futures | 3209.21 | 3211.37 | 3208.67 | 3210.83 | 5868.0 |
| 2019-07-02 08:00:00 | ES | Futures | 3210.56 | 3212.46 | 3210.29 | 3210.83 | 6334.0 |
| 2019-07-02 08:30:00 | ES | Futures | 3210.83 | 3213.0 | 3209.75 | 3211.1 | 11024.0 |
| 2019-07-02 09:00:00 | ES | Futures | 3210.83 | 3214.35 | 3210.83 | 3213.54 | 14077.0 |
| 2019-07-02 09:30:00 | ES | Futures | 3213.81 | 3214.62 | 3208.4 | 3210.02 | 120703.0 |
| 2019-07-02 10:00:00 | ES | Futures | 3210.02 | 3217.33 | 3209.48 | 3217.06 | 78119.0 |
| 2019-07-02 10:30:00 | ES | Futures | 3216.79 | 3219.5 | 3215.16 | 3216.79 | 76006.0 |
| 2019-07-02 11:00:00 | ES | Futures | 3216.52 | 3217.6 | 3213.0 | 3213.54 | 61325.0 |
| 2019-07-02 11:30:00 | ES | Futures | 3213.54 | 3213.81 | 3207.04 | 3211.92 | 82364.0 |
| 2019-07-02 12:00:00 | ES | Futures | 3211.92 | 3213.0 | 3205.96 | 3207.04 | 59781.0 |
| 2019-07-02 12:30:00 | ES | Futures | 3206.77 | 3208.67 | 3203.52 | 3208.13 | 69247.0 |
| 2019-07-02 13:00:00 | ES | Futures | 3208.13 | 3211.92 | 3205.96 | 3211.64 | 39011.0 |
| 2019-07-02 13:30:00 | ES | Futures | 3211.92 | 3214.35 | 3210.56 | 3213.0 | 35825.0 |
| 2019-07-02 14:00:00 | ES | Futures | 3213.27 | 3215.43 | 3212.73 | 3214.35 | 30245.0 |
| 2019-07-02 14:30:00 | ES | Futures | 3214.62 | 3216.79 | 3211.64 | 3212.73 | 37389.0 |
| 2019-07-02 15:00:00 | ES | Futures | 3212.46 | 3217.6 | 3211.64 | 3214.89 | 61355.0 |
| 2019-07-02 15:30:00 | ES | Futures | 3214.89 | 3223.56 | 3214.89 | 3223.29 | 100325.0 |
| 2019-07-02 16:00:00 | ES | Futures | 3223.29 | 3226.8 | 3220.31 | 3226.53 | 51269.0 |
| 2019-07-02 16:30:00 | ES | Futures | 3225.99 | 3226.8 | 3225.18 | 3225.72 | 7344.0 |
| 2019-07-02 18:00:00 | ES | Futures | 3225.72 | 3226.53 | 3224.1 | 3224.64 | 3555.0 |
| 2019-07-02 18:30:00 | ES | Futures | 3224.37 | 3224.91 | 3223.01 | 3224.37 | 1886.0 |
| 2019-07-02 19:00:00 | ES | Futures | 3224.37 | 3225.18 | 3224.1 | 3224.64 | 1035.0 |
| 2019-07-02 19:30:00 | ES | Futures | 3224.64 | 3225.72 | 3223.29 | 3224.64 | 3083.0 |
| 2019-07-02 20:00:00 | ES | Futures | 3224.64 | 3224.91 | 3222.47 | 3224.37 | 5675.0 |
| 2019-07-02 20:30:00 | ES | Futures | 3224.1 | 3225.18 | 3223.01 | 3223.01 | 3630.0 |
| 2019-07-02 21:00:00 | ES | Futures | 3223.01 | 3223.29 | 3220.58 | 3221.39 | 6191.0 |
| 2019-07-02 21:30:00 | ES | Futures | 3221.39 | 3222.2 | 3220.04 | 3221.39 | 5388.0 |
| 2019-07-02 22:00:00 | ES | Futures | 3221.66 | 3223.83 | 3220.85 | 3222.2 | 4686.0 |
| 2019-07-02 22:30:00 | ES | Futures | 3222.2 | 3222.47 | 3220.85 | 3221.39 | 2386.0 |
| 2019-07-02 23:00:00 | ES | Futures | 3221.66 | 3222.74 | 3221.12 | 3221.93 | 1871.0 |
| 2019-07-02 23:30:00 | ES | Futures | 3222.2 | 3222.74 | 3221.66 | 3222.47 | 1701.0 |
| 2019-07-02 00:00:00 | NQ | Futures | 9046.35 | 9049.54 | 9044.61 | 9046.35 | 793.0 |
| 2019-07-02 00:30:00 | NQ | Futures | 9046.35 | 9051.57 | 9045.77 | 9048.38 | 1119.0 |
| 2019-07-02 01:00:00 | NQ | Futures | 9048.09 | 9050.41 | 9038.81 | 9040.55 | 1063.0 |
| 2019-07-02 01:30:00 | NQ | Futures | 9040.84 | 9042.58 | 9037.07 | 9039.68 | 959.0 |
> showing 50 of 3,493 rows — these rows as CSV