PREVIEW / futures_30min / 2019-09-10
file: by_date/futures_30min/2019/2019-09-10.parquet size: 82 KB rows: 3,058
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-09-10 00:00:00 | ES | Futures | 3223.29 | 3223.83 | 3222.2 | 3223.29 | 1027.0 |
| 2019-09-10 00:30:00 | ES | Futures | 3223.29 | 3224.1 | 3221.39 | 3221.66 | 3228.0 |
| 2019-09-10 01:00:00 | ES | Futures | 3221.93 | 3221.93 | 3219.5 | 3221.39 | 3938.0 |
| 2019-09-10 01:30:00 | ES | Futures | 3221.12 | 3221.93 | 3219.77 | 3221.39 | 2777.0 |
| 2019-09-10 02:00:00 | ES | Futures | 3221.66 | 3221.93 | 3218.14 | 3220.31 | 5085.0 |
| 2019-09-10 02:30:00 | ES | Futures | 3220.31 | 3221.93 | 3219.5 | 3221.39 | 5524.0 |
| 2019-09-10 03:00:00 | ES | Futures | 3221.39 | 3224.1 | 3217.6 | 3218.14 | 17063.0 |
| 2019-09-10 03:30:00 | ES | Futures | 3218.14 | 3219.22 | 3213.27 | 3215.71 | 16725.0 |
| 2019-09-10 04:00:00 | ES | Futures | 3215.71 | 3216.25 | 3211.1 | 3212.19 | 13450.0 |
| 2019-09-10 04:30:00 | ES | Futures | 3212.46 | 3215.43 | 3211.64 | 3214.62 | 12275.0 |
| 2019-09-10 05:00:00 | ES | Futures | 3214.35 | 3219.77 | 3214.08 | 3217.06 | 14652.0 |
| 2019-09-10 05:30:00 | ES | Futures | 3217.33 | 3220.31 | 3215.16 | 3218.95 | 10907.0 |
| 2019-09-10 06:00:00 | ES | Futures | 3218.95 | 3220.85 | 3218.41 | 3220.31 | 8795.0 |
| 2019-09-10 06:30:00 | ES | Futures | 3220.31 | 3221.66 | 3217.87 | 3218.41 | 8066.0 |
| 2019-09-10 07:00:00 | ES | Futures | 3218.14 | 3225.18 | 3218.14 | 3221.93 | 18724.0 |
| 2019-09-10 07:30:00 | ES | Futures | 3221.93 | 3222.74 | 3217.33 | 3219.22 | 10578.0 |
| 2019-09-10 08:00:00 | ES | Futures | 3219.22 | 3220.58 | 3217.6 | 3217.87 | 12233.0 |
| 2019-09-10 08:30:00 | ES | Futures | 3217.87 | 3221.39 | 3217.33 | 3217.87 | 12518.0 |
| 2019-09-10 09:00:00 | ES | Futures | 3217.6 | 3218.95 | 3216.25 | 3217.33 | 21532.0 |
| 2019-09-10 09:30:00 | ES | Futures | 3217.33 | 3217.87 | 3202.98 | 3205.96 | 227750.0 |
| 2019-09-10 10:00:00 | ES | Futures | 3205.96 | 3210.83 | 3202.17 | 3210.83 | 128136.0 |
| 2019-09-10 10:30:00 | ES | Futures | 3210.56 | 3211.64 | 3204.07 | 3205.15 | 87252.0 |
| 2019-09-10 11:00:00 | ES | Futures | 3205.42 | 3209.48 | 3203.25 | 3204.61 | 61799.0 |
| 2019-09-10 11:30:00 | ES | Futures | 3204.34 | 3216.52 | 3203.52 | 3212.46 | 119739.0 |
| 2019-09-10 12:00:00 | ES | Futures | 3212.19 | 3219.77 | 3207.04 | 3217.87 | 77537.0 |
| 2019-09-10 12:30:00 | ES | Futures | 3218.14 | 3221.93 | 3216.52 | 3220.04 | 44287.0 |
| 2019-09-10 13:00:00 | ES | Futures | 3219.77 | 3220.58 | 3212.73 | 3215.43 | 52967.0 |
| 2019-09-10 13:30:00 | ES | Futures | 3215.16 | 3219.22 | 3214.89 | 3215.16 | 29602.0 |
| 2019-09-10 14:00:00 | ES | Futures | 3215.16 | 3216.52 | 3210.56 | 3210.83 | 44495.0 |
| 2019-09-10 14:30:00 | ES | Futures | 3210.83 | 3213.27 | 3208.13 | 3211.37 | 49003.0 |
| 2019-09-10 15:00:00 | ES | Futures | 3211.1 | 3213.27 | 3209.75 | 3211.92 | 43365.0 |
| 2019-09-10 15:30:00 | ES | Futures | 3211.64 | 3226.53 | 3211.37 | 3226.26 | 122928.0 |
| 2019-09-10 16:00:00 | ES | Futures | 3226.26 | 3226.53 | 3223.29 | 3225.72 | 62239.0 |
| 2019-09-10 16:30:00 | ES | Futures | 3226.26 | 3227.62 | 3224.37 | 3226.26 | 9626.0 |
| 2019-09-10 18:00:00 | ES | Futures | 3225.72 | 3226.26 | 3223.29 | 3224.1 | 3925.0 |
| 2019-09-10 18:30:00 | ES | Futures | 3224.37 | 3224.37 | 3222.47 | 3222.47 | 1748.0 |
| 2019-09-10 19:00:00 | ES | Futures | 3222.47 | 3224.64 | 3222.2 | 3224.64 | 1642.0 |
| 2019-09-10 19:30:00 | ES | Futures | 3224.64 | 3225.45 | 3223.83 | 3223.83 | 2375.0 |
| 2019-09-10 20:00:00 | ES | Futures | 3224.1 | 3224.1 | 3221.12 | 3222.74 | 6330.0 |
| 2019-09-10 20:30:00 | ES | Futures | 3223.01 | 3223.29 | 3220.58 | 3221.93 | 3743.0 |
| 2019-09-10 21:00:00 | ES | Futures | 3221.66 | 3222.74 | 3220.31 | 3221.39 | 4376.0 |
| 2019-09-10 21:30:00 | ES | Futures | 3221.39 | 3221.93 | 3218.41 | 3218.41 | 6729.0 |
| 2019-09-10 22:00:00 | ES | Futures | 3218.41 | 3221.93 | 3218.14 | 3221.66 | 3858.0 |
| 2019-09-10 22:30:00 | ES | Futures | 3221.39 | 3223.29 | 3221.39 | 3222.74 | 3211.0 |
| 2019-09-10 23:00:00 | ES | Futures | 3222.47 | 3226.8 | 3222.47 | 3226.53 | 5338.0 |
| 2019-09-10 23:30:00 | ES | Futures | 3226.26 | 3227.35 | 3225.18 | 3225.45 | 3707.0 |
| 2019-09-10 00:00:00 | NQ | Futures | 9083.49 | 9085.23 | 9078.56 | 9082.91 | 679.0 |
| 2019-09-10 00:30:00 | NQ | Futures | 9082.62 | 9085.81 | 9076.82 | 9077.98 | 1148.0 |
| 2019-09-10 01:00:00 | NQ | Futures | 9078.56 | 9079.72 | 9066.66 | 9073.62 | 2213.0 |
| 2019-09-10 01:30:00 | NQ | Futures | 9073.33 | 9077.11 | 9066.95 | 9073.91 | 1472.0 |
> showing 50 of 3,058 rows — these rows as CSV