PREVIEW / futures_30min / 2019-10-08
file: by_date/futures_30min/2019/2019-10-08.parquet size: 98 KB rows: 3,532
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-08 00:00:00 | ES | Futures | 3201.44 | 3201.99 | 3200.9 | 3201.44 | 1679.0 |
| 2019-10-08 00:30:00 | ES | Futures | 3201.44 | 3202.53 | 3200.9 | 3202.26 | 1482.0 |
| 2019-10-08 01:00:00 | ES | Futures | 3202.53 | 3202.53 | 3198.45 | 3199.27 | 3410.0 |
| 2019-10-08 01:30:00 | ES | Futures | 3199.54 | 3202.26 | 3199.0 | 3201.17 | 2766.0 |
| 2019-10-08 02:00:00 | ES | Futures | 3201.17 | 3205.25 | 3200.9 | 3202.53 | 5384.0 |
| 2019-10-08 02:30:00 | ES | Futures | 3202.53 | 3203.62 | 3200.36 | 3200.36 | 3496.0 |
| 2019-10-08 03:00:00 | ES | Futures | 3200.36 | 3200.63 | 3196.82 | 3196.82 | 10874.0 |
| 2019-10-08 03:30:00 | ES | Futures | 3196.82 | 3197.64 | 3186.5 | 3187.32 | 29767.0 |
| 2019-10-08 04:00:00 | ES | Futures | 3187.32 | 3191.39 | 3186.77 | 3189.76 | 21116.0 |
| 2019-10-08 04:30:00 | ES | Futures | 3190.03 | 3192.48 | 3186.23 | 3188.68 | 11878.0 |
| 2019-10-08 05:00:00 | ES | Futures | 3188.68 | 3190.31 | 3184.6 | 3185.14 | 13168.0 |
| 2019-10-08 05:30:00 | ES | Futures | 3185.14 | 3185.42 | 3179.98 | 3182.43 | 19599.0 |
| 2019-10-08 06:00:00 | ES | Futures | 3182.7 | 3182.97 | 3170.75 | 3175.64 | 41215.0 |
| 2019-10-08 06:30:00 | ES | Futures | 3175.37 | 3177.54 | 3171.83 | 3174.28 | 17053.0 |
| 2019-10-08 07:00:00 | ES | Futures | 3174.28 | 3174.28 | 3162.06 | 3169.12 | 46822.0 |
| 2019-10-08 07:30:00 | ES | Futures | 3169.39 | 3175.91 | 3168.03 | 3171.02 | 19869.0 |
| 2019-10-08 08:00:00 | ES | Futures | 3171.02 | 3173.46 | 3166.95 | 3172.38 | 22932.0 |
| 2019-10-08 08:30:00 | ES | Futures | 3172.11 | 3173.46 | 3168.3 | 3171.02 | 21092.0 |
| 2019-10-08 09:00:00 | ES | Futures | 3171.02 | 3174.55 | 3168.3 | 3168.85 | 20770.0 |
| 2019-10-08 09:30:00 | ES | Futures | 3168.58 | 3169.12 | 3153.91 | 3153.91 | 201925.0 |
| 2019-10-08 10:00:00 | ES | Futures | 3153.91 | 3156.35 | 3147.12 | 3151.46 | 149442.0 |
| 2019-10-08 10:30:00 | ES | Futures | 3151.73 | 3160.15 | 3147.39 | 3159.34 | 126138.0 |
| 2019-10-08 11:00:00 | ES | Futures | 3159.34 | 3161.78 | 3150.92 | 3151.73 | 95023.0 |
| 2019-10-08 11:30:00 | ES | Futures | 3151.73 | 3154.72 | 3145.22 | 3152.55 | 100107.0 |
| 2019-10-08 12:00:00 | ES | Futures | 3152.55 | 3159.07 | 3149.83 | 3157.71 | 51339.0 |
| 2019-10-08 12:30:00 | ES | Futures | 3157.71 | 3169.66 | 3155.27 | 3161.24 | 72122.0 |
| 2019-10-08 13:00:00 | ES | Futures | 3161.24 | 3165.86 | 3158.25 | 3165.04 | 44382.0 |
| 2019-10-08 13:30:00 | ES | Futures | 3165.32 | 3168.85 | 3162.06 | 3164.23 | 43517.0 |
| 2019-10-08 14:00:00 | ES | Futures | 3164.5 | 3165.59 | 3159.34 | 3163.41 | 48459.0 |
| 2019-10-08 14:30:00 | ES | Futures | 3163.41 | 3177.81 | 3154.18 | 3162.87 | 165138.0 |
| 2019-10-08 15:00:00 | ES | Futures | 3162.6 | 3169.93 | 3154.72 | 3161.51 | 107246.0 |
| 2019-10-08 15:30:00 | ES | Futures | 3161.51 | 3164.77 | 3140.87 | 3141.96 | 178362.0 |
| 2019-10-08 16:00:00 | ES | Futures | 3141.68 | 3147.66 | 3140.6 | 3142.77 | 61549.0 |
| 2019-10-08 16:30:00 | ES | Futures | 3142.5 | 3144.67 | 3141.14 | 3143.86 | 8108.0 |
| 2019-10-08 18:00:00 | ES | Futures | 3143.86 | 3146.57 | 3142.5 | 3144.4 | 5939.0 |
| 2019-10-08 18:30:00 | ES | Futures | 3144.4 | 3145.22 | 3138.42 | 3140.05 | 2905.0 |
| 2019-10-08 19:00:00 | ES | Futures | 3140.05 | 3143.86 | 3138.15 | 3142.23 | 5484.0 |
| 2019-10-08 19:30:00 | ES | Futures | 3142.23 | 3143.31 | 3140.6 | 3142.23 | 2705.0 |
| 2019-10-08 20:00:00 | ES | Futures | 3142.23 | 3149.83 | 3142.23 | 3148.2 | 9047.0 |
| 2019-10-08 20:30:00 | ES | Futures | 3148.47 | 3150.92 | 3146.84 | 3149.56 | 4360.0 |
| 2019-10-08 21:00:00 | ES | Futures | 3149.56 | 3152.01 | 3148.75 | 3149.29 | 4796.0 |
| 2019-10-08 21:30:00 | ES | Futures | 3149.29 | 3152.82 | 3147.93 | 3152.28 | 5638.0 |
| 2019-10-08 22:00:00 | ES | Futures | 3152.28 | 3152.55 | 3149.29 | 3151.46 | 4407.0 |
| 2019-10-08 22:30:00 | ES | Futures | 3151.46 | 3154.45 | 3151.46 | 3153.36 | 4464.0 |
| 2019-10-08 23:00:00 | ES | Futures | 3153.64 | 3154.45 | 3152.55 | 3152.82 | 2799.0 |
| 2019-10-08 23:30:00 | ES | Futures | 3152.82 | 3153.09 | 3150.1 | 3152.28 | 3909.0 |
| 2019-10-08 00:00:00 | NQ | Futures | 9034.31 | 9034.89 | 9032.28 | 9033.44 | 660.0 |
| 2019-10-08 00:30:00 | NQ | Futures | 9033.44 | 9038.38 | 9032.86 | 9036.34 | 671.0 |
| 2019-10-08 01:00:00 | NQ | Futures | 9036.93 | 9036.93 | 9023.27 | 9025.89 | 1390.0 |
| 2019-10-08 01:30:00 | NQ | Futures | 9025.89 | 9033.44 | 9023.85 | 9029.95 | 1574.0 |
> showing 50 of 3,532 rows — these rows as CSV