PREVIEW / futures_30min / 2020-07-01
file: by_date/futures_30min/2020/2020-07-01.parquet size: 95 KB rows: 3,400
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-07-01 00:00:00 | ES | Futures | 3446.14 | 3447.54 | 3445.03 | 3445.31 | 1985.0 |
| 2020-07-01 00:30:00 | ES | Futures | 3445.59 | 3446.14 | 3441.96 | 3442.51 | 2717.0 |
| 2020-07-01 01:00:00 | ES | Futures | 3442.79 | 3443.91 | 3434.42 | 3437.49 | 7955.0 |
| 2020-07-01 01:30:00 | ES | Futures | 3437.49 | 3438.6 | 3432.18 | 3436.65 | 5778.0 |
| 2020-07-01 02:00:00 | ES | Futures | 3436.37 | 3441.12 | 3432.18 | 3440.56 | 7664.0 |
| 2020-07-01 02:30:00 | ES | Futures | 3440.56 | 3445.86 | 3439.44 | 3445.03 | 5348.0 |
| 2020-07-01 03:00:00 | ES | Futures | 3445.03 | 3450.05 | 3441.68 | 3449.22 | 9360.0 |
| 2020-07-01 03:30:00 | ES | Futures | 3449.22 | 3453.13 | 3447.26 | 3449.22 | 6285.0 |
| 2020-07-01 04:00:00 | ES | Futures | 3448.94 | 3452.85 | 3444.47 | 3446.14 | 6801.0 |
| 2020-07-01 04:30:00 | ES | Futures | 3446.42 | 3448.38 | 3444.75 | 3447.26 | 3865.0 |
| 2020-07-01 05:00:00 | ES | Futures | 3447.54 | 3454.52 | 3447.26 | 3454.24 | 3898.0 |
| 2020-07-01 05:30:00 | ES | Futures | 3454.52 | 3455.36 | 3437.49 | 3440.0 | 23184.0 |
| 2020-07-01 06:00:00 | ES | Futures | 3440.28 | 3447.54 | 3438.88 | 3442.51 | 16650.0 |
| 2020-07-01 06:30:00 | ES | Futures | 3442.51 | 3445.86 | 3429.11 | 3432.74 | 21498.0 |
| 2020-07-01 07:00:00 | ES | Futures | 3432.46 | 3433.02 | 3424.64 | 3430.23 | 26713.0 |
| 2020-07-01 07:30:00 | ES | Futures | 3429.95 | 3430.23 | 3421.01 | 3429.11 | 27938.0 |
| 2020-07-01 08:00:00 | ES | Futures | 3428.83 | 3436.37 | 3427.16 | 3436.09 | 24725.0 |
| 2020-07-01 08:30:00 | ES | Futures | 3436.09 | 3456.76 | 3434.97 | 3456.48 | 48717.0 |
| 2020-07-01 09:00:00 | ES | Futures | 3456.2 | 3465.69 | 3453.68 | 3456.2 | 61314.0 |
| 2020-07-01 09:30:00 | ES | Futures | 3456.48 | 3471.56 | 3453.4 | 3458.99 | 179872.0 |
| 2020-07-01 10:00:00 | ES | Futures | 3459.27 | 3472.95 | 3458.71 | 3471.83 | 116782.0 |
| 2020-07-01 10:30:00 | ES | Futures | 3471.83 | 3475.46 | 3458.43 | 3467.93 | 93974.0 |
| 2020-07-01 11:00:00 | ES | Futures | 3468.2 | 3469.32 | 3450.61 | 3452.57 | 95410.0 |
| 2020-07-01 11:30:00 | ES | Futures | 3452.57 | 3466.53 | 3452.29 | 3464.3 | 59978.0 |
| 2020-07-01 12:00:00 | ES | Futures | 3464.3 | 3473.79 | 3462.34 | 3472.67 | 43009.0 |
| 2020-07-01 12:30:00 | ES | Futures | 3472.67 | 3477.7 | 3466.25 | 3470.16 | 85683.0 |
| 2020-07-01 13:00:00 | ES | Futures | 3470.16 | 3471.83 | 3464.57 | 3470.44 | 39615.0 |
| 2020-07-01 13:30:00 | ES | Futures | 3470.72 | 3473.23 | 3465.13 | 3469.88 | 40634.0 |
| 2020-07-01 14:00:00 | ES | Futures | 3469.6 | 3475.74 | 3468.76 | 3471.83 | 51048.0 |
| 2020-07-01 14:30:00 | ES | Futures | 3471.83 | 3474.63 | 3464.85 | 3471.28 | 47527.0 |
| 2020-07-01 15:00:00 | ES | Futures | 3471.28 | 3480.49 | 3469.88 | 3478.26 | 54177.0 |
| 2020-07-01 15:30:00 | ES | Futures | 3478.26 | 3482.45 | 3466.53 | 3467.93 | 166545.0 |
| 2020-07-01 16:00:00 | ES | Futures | 3467.93 | 3469.6 | 3463.46 | 3465.41 | 43838.0 |
| 2020-07-01 16:30:00 | ES | Futures | 3465.41 | 3468.48 | 3462.62 | 3463.46 | 6502.0 |
| 2020-07-01 18:00:00 | ES | Futures | 3464.57 | 3467.37 | 3460.94 | 3465.97 | 6853.0 |
| 2020-07-01 18:30:00 | ES | Futures | 3466.25 | 3469.04 | 3464.85 | 3468.48 | 3066.0 |
| 2020-07-01 19:00:00 | ES | Futures | 3468.76 | 3470.16 | 3464.02 | 3464.3 | 3510.0 |
| 2020-07-01 19:30:00 | ES | Futures | 3464.3 | 3469.32 | 3463.18 | 3465.41 | 4352.0 |
| 2020-07-01 20:00:00 | ES | Futures | 3464.85 | 3468.2 | 3458.71 | 3459.83 | 8310.0 |
| 2020-07-01 20:30:00 | ES | Futures | 3459.55 | 3463.18 | 3458.71 | 3461.22 | 5969.0 |
| 2020-07-01 21:00:00 | ES | Futures | 3461.22 | 3464.85 | 3457.59 | 3464.02 | 6974.0 |
| 2020-07-01 21:30:00 | ES | Futures | 3464.02 | 3468.76 | 3461.22 | 3464.85 | 7207.0 |
| 2020-07-01 22:00:00 | ES | Futures | 3465.41 | 3472.67 | 3464.3 | 3471.56 | 4851.0 |
| 2020-07-01 22:30:00 | ES | Futures | 3471.56 | 3473.51 | 3469.04 | 3472.95 | 4148.0 |
| 2020-07-01 23:00:00 | ES | Futures | 3472.95 | 3474.91 | 3471.56 | 3473.23 | 3688.0 |
| 2020-07-01 23:30:00 | ES | Futures | 3473.23 | 3473.79 | 3468.48 | 3469.6 | 4519.0 |
| 2020-07-01 00:00:00 | NQ | Futures | 11729.37 | 11734.0 | 11725.61 | 11726.19 | 491.0 |
| 2020-07-01 00:30:00 | NQ | Futures | 11725.61 | 11728.5 | 11713.18 | 11717.23 | 928.0 |
| 2020-07-01 01:00:00 | NQ | Futures | 11716.94 | 11721.27 | 11691.2 | 11699.87 | 2405.0 |
| 2020-07-01 01:30:00 | NQ | Futures | 11699.01 | 11705.08 | 11688.31 | 11701.61 | 1618.0 |
> showing 50 of 3,400 rows — these rows as CSV