PREVIEW / futures_30min / 2020-04-30
file: by_date/futures_30min/2020/2020-04-30.parquet size: 105 KB rows: 3,510
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-04-30 00:00:00 | ES | Futures | 3245.5 | 3254.55 | 3243.03 | 3253.73 | 6090.0 |
| 2020-04-30 00:30:00 | ES | Futures | 3253.73 | 3254.55 | 3247.42 | 3250.16 | 12586.0 |
| 2020-04-30 01:00:00 | ES | Futures | 3250.16 | 3251.26 | 3245.22 | 3246.05 | 9425.0 |
| 2020-04-30 01:30:00 | ES | Futures | 3246.05 | 3251.54 | 3244.13 | 3244.67 | 15372.0 |
| 2020-04-30 02:00:00 | ES | Futures | 3244.67 | 3244.95 | 3235.34 | 3239.46 | 12502.0 |
| 2020-04-30 02:30:00 | ES | Futures | 3239.74 | 3245.77 | 3236.17 | 3244.4 | 8013.0 |
| 2020-04-30 03:00:00 | ES | Futures | 3244.13 | 3244.4 | 3228.76 | 3228.76 | 18659.0 |
| 2020-04-30 03:30:00 | ES | Futures | 3228.76 | 3235.62 | 3226.01 | 3228.48 | 17005.0 |
| 2020-04-30 04:00:00 | ES | Futures | 3228.48 | 3232.6 | 3226.01 | 3230.95 | 13215.0 |
| 2020-04-30 04:30:00 | ES | Futures | 3231.23 | 3241.11 | 3228.48 | 3229.03 | 13187.0 |
| 2020-04-30 05:00:00 | ES | Futures | 3229.31 | 3234.25 | 3227.39 | 3233.7 | 8999.0 |
| 2020-04-30 05:30:00 | ES | Futures | 3233.7 | 3236.72 | 3230.68 | 3236.17 | 9401.0 |
| 2020-04-30 06:00:00 | ES | Futures | 3236.17 | 3239.46 | 3228.76 | 3230.41 | 14789.0 |
| 2020-04-30 06:30:00 | ES | Futures | 3230.13 | 3230.41 | 3214.76 | 3220.53 | 22616.0 |
| 2020-04-30 07:00:00 | ES | Futures | 3220.25 | 3222.45 | 3213.12 | 3213.94 | 22764.0 |
| 2020-04-30 07:30:00 | ES | Futures | 3213.94 | 3223.0 | 3205.43 | 3206.81 | 29915.0 |
| 2020-04-30 08:00:00 | ES | Futures | 3206.81 | 3215.04 | 3205.16 | 3209.55 | 25042.0 |
| 2020-04-30 08:30:00 | ES | Futures | 3209.82 | 3217.23 | 3193.08 | 3193.63 | 52830.0 |
| 2020-04-30 09:00:00 | ES | Futures | 3193.36 | 3200.22 | 3184.85 | 3199.4 | 53796.0 |
| 2020-04-30 09:30:00 | ES | Futures | 3199.4 | 3200.49 | 3176.07 | 3193.91 | 183586.0 |
| 2020-04-30 10:00:00 | ES | Futures | 3194.18 | 3204.06 | 3187.32 | 3202.41 | 150715.0 |
| 2020-04-30 10:30:00 | ES | Futures | 3202.41 | 3205.16 | 3186.77 | 3191.99 | 93761.0 |
| 2020-04-30 11:00:00 | ES | Futures | 3192.26 | 3201.59 | 3188.69 | 3188.97 | 88441.0 |
| 2020-04-30 11:30:00 | ES | Futures | 3188.97 | 3195.01 | 3175.52 | 3175.8 | 97849.0 |
| 2020-04-30 12:00:00 | ES | Futures | 3175.8 | 3176.62 | 3167.02 | 3171.41 | 95190.0 |
| 2020-04-30 12:30:00 | ES | Futures | 3171.41 | 3181.56 | 3164.82 | 3179.91 | 76741.0 |
| 2020-04-30 13:00:00 | ES | Futures | 3179.91 | 3185.13 | 3172.78 | 3177.72 | 60867.0 |
| 2020-04-30 13:30:00 | ES | Futures | 3177.72 | 3179.91 | 3170.58 | 3171.41 | 56133.0 |
| 2020-04-30 14:00:00 | ES | Futures | 3171.41 | 3179.91 | 3167.84 | 3177.17 | 50601.0 |
| 2020-04-30 14:30:00 | ES | Futures | 3177.17 | 3182.38 | 3168.66 | 3173.05 | 62857.0 |
| 2020-04-30 15:00:00 | ES | Futures | 3173.05 | 3190.62 | 3170.58 | 3186.5 | 85446.0 |
| 2020-04-30 15:30:00 | ES | Futures | 3186.5 | 3193.63 | 3174.7 | 3184.58 | 285452.0 |
| 2020-04-30 16:00:00 | ES | Futures | 3184.3 | 3187.6 | 3170.03 | 3180.74 | 88584.0 |
| 2020-04-30 16:30:00 | ES | Futures | 3179.36 | 3186.5 | 3159.06 | 3164.0 | 28787.0 |
| 2020-04-30 18:00:00 | ES | Futures | 3151.92 | 3152.47 | 3131.62 | 3141.49 | 24160.0 |
| 2020-04-30 18:30:00 | ES | Futures | 3141.77 | 3148.63 | 3136.56 | 3147.26 | 6229.0 |
| 2020-04-30 19:00:00 | ES | Futures | 3147.26 | 3150.55 | 3144.24 | 3148.9 | 5574.0 |
| 2020-04-30 19:30:00 | ES | Futures | 3148.63 | 3156.31 | 3146.98 | 3154.94 | 7870.0 |
| 2020-04-30 20:00:00 | ES | Futures | 3155.22 | 3158.78 | 3149.18 | 3150.83 | 9256.0 |
| 2020-04-30 20:30:00 | ES | Futures | 3150.55 | 3158.78 | 3146.98 | 3158.23 | 7547.0 |
| 2020-04-30 21:00:00 | ES | Futures | 3158.23 | 3160.98 | 3153.84 | 3154.12 | 5108.0 |
| 2020-04-30 21:30:00 | ES | Futures | 3153.84 | 3154.67 | 3146.43 | 3150.28 | 6093.0 |
| 2020-04-30 22:00:00 | ES | Futures | 3150.55 | 3152.2 | 3141.49 | 3143.42 | 5771.0 |
| 2020-04-30 22:30:00 | ES | Futures | 3143.42 | 3145.89 | 3137.1 | 3140.12 | 5539.0 |
| 2020-04-30 23:00:00 | ES | Futures | 3140.12 | 3142.59 | 3134.91 | 3142.04 | 5978.0 |
| 2020-04-30 23:30:00 | ES | Futures | 3141.77 | 3145.61 | 3138.48 | 3139.85 | 4335.0 |
| 2020-04-30 00:00:00 | NQ | Futures | 10417.03 | 10442.74 | 10406.17 | 10440.74 | 1874.0 |
| 2020-04-30 00:30:00 | NQ | Futures | 10440.45 | 10448.45 | 10422.17 | 10431.31 | 2678.0 |
| 2020-04-30 01:00:00 | NQ | Futures | 10431.88 | 10436.74 | 10415.31 | 10419.03 | 1758.0 |
| 2020-04-30 01:30:00 | NQ | Futures | 10419.03 | 10439.59 | 10415.31 | 10418.46 | 2101.0 |
> showing 50 of 3,510 rows — these rows as CSV