PREVIEW / futures_30min / 2020-06-30
file: by_date/futures_30min/2020/2020-06-30.parquet size: 96 KB rows: 3,425
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 |
|---|---|---|---|---|---|---|---|
| 2020-06-30 00:00:00 | ES | Futures | 3410.12 | 3412.36 | 3409.56 | 3410.12 | 2448.0 |
| 2020-06-30 00:30:00 | ES | Futures | 3409.84 | 3412.08 | 3409.56 | 3410.96 | 1975.0 |
| 2020-06-30 01:00:00 | ES | Futures | 3410.96 | 3414.59 | 3409.84 | 3410.68 | 4738.0 |
| 2020-06-30 01:30:00 | ES | Futures | 3410.4 | 3410.96 | 3397.84 | 3397.84 | 12681.0 |
| 2020-06-30 02:00:00 | ES | Futures | 3397.56 | 3402.86 | 3391.13 | 3396.44 | 13285.0 |
| 2020-06-30 02:30:00 | ES | Futures | 3396.44 | 3400.35 | 3395.32 | 3397.56 | 5988.0 |
| 2020-06-30 03:00:00 | ES | Futures | 3397.28 | 3406.77 | 3390.02 | 3393.93 | 19791.0 |
| 2020-06-30 03:30:00 | ES | Futures | 3393.65 | 3397.56 | 3390.02 | 3395.04 | 11548.0 |
| 2020-06-30 04:00:00 | ES | Futures | 3395.04 | 3397.56 | 3390.02 | 3394.76 | 10404.0 |
| 2020-06-30 04:30:00 | ES | Futures | 3394.76 | 3395.6 | 3386.11 | 3389.46 | 14062.0 |
| 2020-06-30 05:00:00 | ES | Futures | 3389.18 | 3395.32 | 3384.71 | 3394.2 | 17888.0 |
| 2020-06-30 05:30:00 | ES | Futures | 3394.2 | 3399.23 | 3391.69 | 3398.11 | 13763.0 |
| 2020-06-30 06:00:00 | ES | Futures | 3397.84 | 3403.42 | 3396.16 | 3401.74 | 11842.0 |
| 2020-06-30 06:30:00 | ES | Futures | 3401.74 | 3402.86 | 3398.11 | 3398.67 | 8376.0 |
| 2020-06-30 07:00:00 | ES | Futures | 3398.39 | 3405.93 | 3396.44 | 3405.1 | 10130.0 |
| 2020-06-30 07:30:00 | ES | Futures | 3404.82 | 3412.64 | 3400.63 | 3402.3 | 21866.0 |
| 2020-06-30 08:00:00 | ES | Futures | 3402.3 | 3403.14 | 3394.76 | 3395.6 | 12591.0 |
| 2020-06-30 08:30:00 | ES | Futures | 3395.6 | 3396.16 | 3390.3 | 3395.04 | 21997.0 |
| 2020-06-30 09:00:00 | ES | Futures | 3395.32 | 3398.39 | 3390.3 | 3393.93 | 30233.0 |
| 2020-06-30 09:30:00 | ES | Futures | 3394.2 | 3409.84 | 3392.81 | 3402.86 | 141390.0 |
| 2020-06-30 10:00:00 | ES | Futures | 3403.14 | 3416.27 | 3402.3 | 3410.96 | 110074.0 |
| 2020-06-30 10:30:00 | ES | Futures | 3410.68 | 3424.64 | 3408.17 | 3423.25 | 106173.0 |
| 2020-06-30 11:00:00 | ES | Futures | 3423.25 | 3431.9 | 3421.57 | 3426.88 | 82966.0 |
| 2020-06-30 11:30:00 | ES | Futures | 3427.16 | 3427.43 | 3419.9 | 3426.04 | 54940.0 |
| 2020-06-30 12:00:00 | ES | Futures | 3426.04 | 3434.14 | 3423.8 | 3430.51 | 45728.0 |
| 2020-06-30 12:30:00 | ES | Futures | 3430.79 | 3432.46 | 3419.34 | 3420.45 | 60219.0 |
| 2020-06-30 13:00:00 | ES | Futures | 3420.45 | 3423.25 | 3413.47 | 3421.85 | 52155.0 |
| 2020-06-30 13:30:00 | ES | Futures | 3421.85 | 3424.08 | 3415.99 | 3422.69 | 34014.0 |
| 2020-06-30 14:00:00 | ES | Futures | 3422.69 | 3428.55 | 3417.1 | 3428.55 | 54034.0 |
| 2020-06-30 14:30:00 | ES | Futures | 3428.55 | 3433.02 | 3426.88 | 3432.74 | 43442.0 |
| 2020-06-30 15:00:00 | ES | Futures | 3433.02 | 3438.33 | 3424.64 | 3435.81 | 80341.0 |
| 2020-06-30 15:30:00 | ES | Futures | 3435.81 | 3464.02 | 3434.97 | 3443.63 | 369773.0 |
| 2020-06-30 16:00:00 | ES | Futures | 3445.31 | 3450.89 | 3440.84 | 3443.91 | 86034.0 |
| 2020-06-30 16:30:00 | ES | Futures | 3444.19 | 3448.38 | 3441.96 | 3445.59 | 9448.0 |
| 2020-06-30 18:00:00 | ES | Futures | 3446.14 | 3449.22 | 3441.96 | 3447.54 | 6505.0 |
| 2020-06-30 18:30:00 | ES | Futures | 3447.82 | 3449.5 | 3442.51 | 3442.51 | 4767.0 |
| 2020-06-30 19:00:00 | ES | Futures | 3442.79 | 3448.1 | 3441.68 | 3445.03 | 5823.0 |
| 2020-06-30 19:30:00 | ES | Futures | 3445.31 | 3446.42 | 3440.0 | 3442.23 | 8331.0 |
| 2020-06-30 20:00:00 | ES | Futures | 3442.23 | 3443.63 | 3438.88 | 3443.07 | 7565.0 |
| 2020-06-30 20:30:00 | ES | Futures | 3443.07 | 3447.82 | 3442.23 | 3444.75 | 5566.0 |
| 2020-06-30 21:00:00 | ES | Futures | 3445.03 | 3448.94 | 3441.4 | 3443.07 | 6938.0 |
| 2020-06-30 21:30:00 | ES | Futures | 3443.35 | 3448.94 | 3441.4 | 3446.42 | 5517.0 |
| 2020-06-30 22:00:00 | ES | Futures | 3446.42 | 3447.82 | 3443.35 | 3444.19 | 3487.0 |
| 2020-06-30 22:30:00 | ES | Futures | 3444.19 | 3445.03 | 3439.72 | 3442.79 | 4282.0 |
| 2020-06-30 23:00:00 | ES | Futures | 3442.79 | 3446.42 | 3441.96 | 3444.47 | 2228.0 |
| 2020-06-30 23:30:00 | ES | Futures | 3444.47 | 3447.54 | 3443.07 | 3445.86 | 2953.0 |
| 2020-06-30 00:00:00 | NQ | Futures | 11576.97 | 11582.76 | 11576.97 | 11579.29 | 744.0 |
| 2020-06-30 00:30:00 | NQ | Futures | 11579.29 | 11583.34 | 11577.55 | 11580.73 | 584.0 |
| 2020-06-30 01:00:00 | NQ | Futures | 11581.31 | 11599.82 | 11578.71 | 11584.2 | 2168.0 |
| 2020-06-30 01:30:00 | NQ | Futures | 11583.91 | 11586.81 | 11541.98 | 11544.01 | 4446.0 |
> showing 50 of 3,425 rows — these rows as CSV