PREVIEW / futures_30min / 2019-10-30
file: by_date/futures_30min/2019/2019-10-30.parquet size: 94 KB rows: 3,538
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-10-30 00:00:00 | ES | Futures | 3295.7 | 3296.24 | 3294.88 | 3295.43 | 1172.0 |
| 2019-10-30 00:30:00 | ES | Futures | 3295.16 | 3295.97 | 3294.61 | 3295.43 | 1781.0 |
| 2019-10-30 01:00:00 | ES | Futures | 3295.7 | 3297.06 | 3295.43 | 3297.06 | 1254.0 |
| 2019-10-30 01:30:00 | ES | Futures | 3297.06 | 3297.06 | 3295.7 | 3296.24 | 2064.0 |
| 2019-10-30 02:00:00 | ES | Futures | 3295.97 | 3296.51 | 3294.88 | 3295.43 | 2496.0 |
| 2019-10-30 02:30:00 | ES | Futures | 3295.43 | 3296.51 | 3295.43 | 3296.24 | 1508.0 |
| 2019-10-30 03:00:00 | ES | Futures | 3296.51 | 3296.51 | 3295.16 | 3295.7 | 1820.0 |
| 2019-10-30 03:30:00 | ES | Futures | 3295.7 | 3297.06 | 3295.16 | 3297.06 | 2814.0 |
| 2019-10-30 04:00:00 | ES | Futures | 3297.33 | 3298.69 | 3296.79 | 3297.87 | 7135.0 |
| 2019-10-30 04:30:00 | ES | Futures | 3297.87 | 3298.14 | 3295.43 | 3296.24 | 4776.0 |
| 2019-10-30 05:00:00 | ES | Futures | 3296.24 | 3297.33 | 3295.16 | 3297.06 | 3947.0 |
| 2019-10-30 05:30:00 | ES | Futures | 3296.79 | 3297.6 | 3295.97 | 3296.79 | 3293.0 |
| 2019-10-30 06:00:00 | ES | Futures | 3296.51 | 3298.41 | 3296.24 | 3297.33 | 5357.0 |
| 2019-10-30 06:30:00 | ES | Futures | 3297.06 | 3298.96 | 3296.79 | 3298.14 | 3602.0 |
| 2019-10-30 07:00:00 | ES | Futures | 3298.14 | 3300.04 | 3297.87 | 3299.77 | 5215.0 |
| 2019-10-30 07:30:00 | ES | Futures | 3299.5 | 3300.86 | 3299.23 | 3299.77 | 5360.0 |
| 2019-10-30 08:00:00 | ES | Futures | 3299.77 | 3300.04 | 3298.14 | 3298.69 | 6871.0 |
| 2019-10-30 08:30:00 | ES | Futures | 3298.69 | 3301.67 | 3298.69 | 3300.59 | 14851.0 |
| 2019-10-30 09:00:00 | ES | Futures | 3300.59 | 3301.95 | 3300.32 | 3300.86 | 9528.0 |
| 2019-10-30 09:30:00 | ES | Futures | 3300.86 | 3300.86 | 3292.44 | 3294.61 | 108839.0 |
| 2019-10-30 10:00:00 | ES | Futures | 3294.61 | 3296.24 | 3284.83 | 3294.88 | 138328.0 |
| 2019-10-30 10:30:00 | ES | Futures | 3294.61 | 3297.06 | 3292.17 | 3296.51 | 58326.0 |
| 2019-10-30 11:00:00 | ES | Futures | 3296.51 | 3297.06 | 3291.9 | 3294.07 | 40365.0 |
| 2019-10-30 11:30:00 | ES | Futures | 3293.8 | 3294.88 | 3291.08 | 3293.53 | 36437.0 |
| 2019-10-30 12:00:00 | ES | Futures | 3293.53 | 3297.33 | 3293.25 | 3296.79 | 36958.0 |
| 2019-10-30 12:30:00 | ES | Futures | 3296.79 | 3297.87 | 3294.61 | 3294.88 | 34709.0 |
| 2019-10-30 13:00:00 | ES | Futures | 3295.16 | 3296.51 | 3294.34 | 3294.88 | 28730.0 |
| 2019-10-30 13:30:00 | ES | Futures | 3294.88 | 3296.51 | 3288.91 | 3290.27 | 39190.0 |
| 2019-10-30 14:00:00 | ES | Futures | 3290.81 | 3300.04 | 3286.73 | 3295.97 | 94919.0 |
| 2019-10-30 14:30:00 | ES | Futures | 3295.97 | 3304.66 | 3289.72 | 3303.03 | 121569.0 |
| 2019-10-30 15:00:00 | ES | Futures | 3303.03 | 3312.81 | 3302.49 | 3308.19 | 88814.0 |
| 2019-10-30 15:30:00 | ES | Futures | 3308.47 | 3309.82 | 3304.93 | 3308.47 | 112132.0 |
| 2019-10-30 16:00:00 | ES | Futures | 3308.74 | 3312.27 | 3307.65 | 3312.0 | 60597.0 |
| 2019-10-30 16:30:00 | ES | Futures | 3311.45 | 3319.33 | 3311.18 | 3314.44 | 29354.0 |
| 2019-10-30 18:00:00 | ES | Futures | 3315.8 | 3316.07 | 3312.0 | 3312.54 | 5567.0 |
| 2019-10-30 18:30:00 | ES | Futures | 3312.81 | 3313.35 | 3312.27 | 3312.54 | 2032.0 |
| 2019-10-30 19:00:00 | ES | Futures | 3312.54 | 3312.81 | 3311.45 | 3312.0 | 1858.0 |
| 2019-10-30 19:30:00 | ES | Futures | 3312.0 | 3313.35 | 3311.45 | 3312.27 | 2259.0 |
| 2019-10-30 20:00:00 | ES | Futures | 3312.54 | 3313.9 | 3311.18 | 3311.72 | 5607.0 |
| 2019-10-30 20:30:00 | ES | Futures | 3311.72 | 3313.9 | 3311.72 | 3312.81 | 3960.0 |
| 2019-10-30 21:00:00 | ES | Futures | 3313.08 | 3313.08 | 3309.55 | 3310.37 | 8054.0 |
| 2019-10-30 21:30:00 | ES | Futures | 3310.37 | 3311.45 | 3308.74 | 3309.55 | 4953.0 |
| 2019-10-30 22:00:00 | ES | Futures | 3309.82 | 3310.1 | 3307.92 | 3309.01 | 3966.0 |
| 2019-10-30 22:30:00 | ES | Futures | 3309.01 | 3310.1 | 3308.74 | 3309.82 | 1528.0 |
| 2019-10-30 23:00:00 | ES | Futures | 3310.1 | 3312.27 | 3309.55 | 3311.45 | 2052.0 |
| 2019-10-30 23:30:00 | ES | Futures | 3311.45 | 3312.0 | 3310.1 | 3311.18 | 3346.0 |
| 2019-10-30 00:00:00 | NQ | Futures | 9357.05 | 9358.79 | 9353.27 | 9354.72 | 800.0 |
| 2019-10-30 00:30:00 | NQ | Futures | 9355.01 | 9357.92 | 9352.98 | 9357.63 | 905.0 |
| 2019-10-30 01:00:00 | NQ | Futures | 9357.63 | 9362.57 | 9357.05 | 9362.57 | 721.0 |
| 2019-10-30 01:30:00 | NQ | Futures | 9362.57 | 9362.57 | 9358.5 | 9359.66 | 708.0 |
> showing 50 of 3,538 rows — these rows as CSV