PREVIEW / futures_30min / 2020-02-24
file: by_date/futures_30min/2020/2020-02-24.parquet size: 105 KB rows: 3,628
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-02-24 00:00:00 | ES | Futures | 3570.0 | 3571.4 | 3566.8 | 3568.7 | 9866.0 |
| 2020-02-24 00:30:00 | ES | Futures | 3568.7 | 3569.8 | 3566.5 | 3567.0 | 4490.0 |
| 2020-02-24 01:00:00 | ES | Futures | 3566.8 | 3569.8 | 3566.5 | 3567.9 | 11340.0 |
| 2020-02-24 01:30:00 | ES | Futures | 3567.9 | 3569.8 | 3566.5 | 3568.9 | 7278.0 |
| 2020-02-24 02:00:00 | ES | Futures | 3569.2 | 3570.0 | 3558.1 | 3562.4 | 27348.0 |
| 2020-02-24 02:30:00 | ES | Futures | 3562.4 | 3567.3 | 3557.0 | 3558.6 | 19614.0 |
| 2020-02-24 03:00:00 | ES | Futures | 3558.6 | 3560.0 | 3542.1 | 3542.4 | 85278.0 |
| 2020-02-24 03:30:00 | ES | Futures | 3542.4 | 3544.0 | 3536.2 | 3539.1 | 74274.0 |
| 2020-02-24 04:00:00 | ES | Futures | 3539.1 | 3541.0 | 3518.5 | 3525.0 | 85570.0 |
| 2020-02-24 04:30:00 | ES | Futures | 3525.0 | 3534.5 | 3514.7 | 3534.3 | 70141.0 |
| 2020-02-24 05:00:00 | ES | Futures | 3534.0 | 3534.3 | 3526.1 | 3527.5 | 30929.0 |
| 2020-02-24 05:30:00 | ES | Futures | 3527.2 | 3527.5 | 3517.5 | 3519.9 | 39928.0 |
| 2020-02-24 06:00:00 | ES | Futures | 3519.9 | 3526.7 | 3513.9 | 3525.3 | 41809.0 |
| 2020-02-24 06:30:00 | ES | Futures | 3525.3 | 3537.0 | 3524.5 | 3532.1 | 43899.0 |
| 2020-02-24 07:00:00 | ES | Futures | 3532.1 | 3540.2 | 3532.1 | 3532.9 | 38492.0 |
| 2020-02-24 07:30:00 | ES | Futures | 3532.6 | 3535.6 | 3524.0 | 3528.3 | 34344.0 |
| 2020-02-24 08:00:00 | ES | Futures | 3528.0 | 3534.0 | 3523.1 | 3526.9 | 38618.0 |
| 2020-02-24 08:30:00 | ES | Futures | 3526.9 | 3528.6 | 3517.2 | 3518.8 | 51317.0 |
| 2020-02-24 09:00:00 | ES | Futures | 3518.8 | 3519.4 | 3501.5 | 3503.9 | 92370.0 |
| 2020-02-24 09:30:00 | ES | Futures | 3504.2 | 3531.5 | 3500.7 | 3528.3 | 360724.0 |
| 2020-02-24 10:00:00 | ES | Futures | 3528.6 | 3533.7 | 3516.9 | 3517.7 | 200565.0 |
| 2020-02-24 10:30:00 | ES | Futures | 3517.7 | 3523.4 | 3509.3 | 3521.8 | 191499.0 |
| 2020-02-24 11:00:00 | ES | Futures | 3522.1 | 3523.4 | 3512.3 | 3516.9 | 139873.0 |
| 2020-02-24 11:30:00 | ES | Futures | 3516.9 | 3519.6 | 3503.1 | 3508.0 | 141765.0 |
| 2020-02-24 12:00:00 | ES | Futures | 3508.2 | 3508.2 | 3495.2 | 3498.2 | 145912.0 |
| 2020-02-24 12:30:00 | ES | Futures | 3498.5 | 3507.4 | 3493.6 | 3495.8 | 118240.0 |
| 2020-02-24 13:00:00 | ES | Futures | 3495.8 | 3498.5 | 3483.6 | 3497.9 | 158700.0 |
| 2020-02-24 13:30:00 | ES | Futures | 3497.9 | 3504.7 | 3494.4 | 3502.0 | 109906.0 |
| 2020-02-24 14:00:00 | ES | Futures | 3502.3 | 3510.9 | 3492.3 | 3509.1 | 120544.0 |
| 2020-02-24 14:30:00 | ES | Futures | 3509.1 | 3522.9 | 3506.1 | 3521.0 | 140027.0 |
| 2020-02-24 15:00:00 | ES | Futures | 3521.0 | 3526.4 | 3512.8 | 3513.7 | 152525.0 |
| 2020-02-24 15:30:00 | ES | Futures | 3513.9 | 3516.1 | 3496.3 | 3496.3 | 309333.0 |
| 2020-02-24 16:00:00 | ES | Futures | 3496.3 | 3498.8 | 3490.9 | 3497.9 | 114206.0 |
| 2020-02-24 16:30:00 | ES | Futures | 3497.4 | 3500.9 | 3492.0 | 3497.9 | 20770.0 |
| 2020-02-24 18:00:00 | ES | Futures | 3493.6 | 3509.1 | 3484.1 | 3504.7 | 26701.0 |
| 2020-02-24 18:30:00 | ES | Futures | 3504.7 | 3513.7 | 3499.8 | 3511.8 | 17471.0 |
| 2020-02-24 19:00:00 | ES | Futures | 3512.0 | 3518.0 | 3509.3 | 3516.9 | 23589.0 |
| 2020-02-24 19:30:00 | ES | Futures | 3516.6 | 3521.0 | 3513.9 | 3520.4 | 16030.0 |
| 2020-02-24 20:00:00 | ES | Futures | 3520.7 | 3532.1 | 3519.6 | 3527.5 | 30544.0 |
| 2020-02-24 20:30:00 | ES | Futures | 3527.5 | 3533.2 | 3525.9 | 3526.1 | 23743.0 |
| 2020-02-24 21:00:00 | ES | Futures | 3526.1 | 3530.2 | 3523.7 | 3527.2 | 16017.0 |
| 2020-02-24 21:30:00 | ES | Futures | 3527.2 | 3528.8 | 3519.4 | 3520.2 | 15588.0 |
| 2020-02-24 22:00:00 | ES | Futures | 3520.2 | 3523.7 | 3517.7 | 3523.7 | 13756.0 |
| 2020-02-24 22:30:00 | ES | Futures | 3524.0 | 3525.0 | 3521.0 | 3524.5 | 7168.0 |
| 2020-02-24 23:00:00 | ES | Futures | 3524.5 | 3525.3 | 3520.4 | 3525.0 | 6110.0 |
| 2020-02-24 23:30:00 | ES | Futures | 3525.3 | 3525.9 | 3524.0 | 3525.9 | 4222.0 |
| 2020-02-24 00:00:00 | NQ | Futures | 10749.73 | 10754.35 | 10731.51 | 10741.92 | 6870.0 |
| 2020-02-24 00:30:00 | NQ | Futures | 10741.92 | 10750.02 | 10737.29 | 10737.87 | 2242.0 |
| 2020-02-24 01:00:00 | NQ | Futures | 10737.58 | 10749.44 | 10736.43 | 10741.34 | 5204.0 |
| 2020-02-24 01:30:00 | NQ | Futures | 10741.34 | 10747.41 | 10736.14 | 10744.23 | 2859.0 |
> showing 50 of 3,628 rows — these rows as CSV