PREVIEW / futures_30min / 2018-10-08
file: by_date/futures_30min/2018/2018-10-08.parquet size: 88 KB rows: 3,195
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-08 00:00:00 | ES | Futures | 3148.65 | 3149.47 | 3147.56 | 3149.47 | 1811.0 |
| 2018-10-08 00:30:00 | ES | Futures | 3149.2 | 3150.83 | 3148.92 | 3149.47 | 3067.0 |
| 2018-10-08 01:00:00 | ES | Futures | 3149.47 | 3150.83 | 3148.38 | 3148.65 | 2004.0 |
| 2018-10-08 01:30:00 | ES | Futures | 3148.65 | 3149.74 | 3148.11 | 3148.92 | 1084.0 |
| 2018-10-08 02:00:00 | ES | Futures | 3148.92 | 3149.47 | 3146.48 | 3147.02 | 2776.0 |
| 2018-10-08 02:30:00 | ES | Futures | 3147.29 | 3147.29 | 3143.76 | 3143.76 | 4478.0 |
| 2018-10-08 03:00:00 | ES | Futures | 3144.03 | 3144.57 | 3140.49 | 3141.85 | 14054.0 |
| 2018-10-08 03:30:00 | ES | Futures | 3141.58 | 3142.94 | 3139.13 | 3140.76 | 8766.0 |
| 2018-10-08 04:00:00 | ES | Futures | 3141.04 | 3142.67 | 3138.04 | 3139.95 | 9432.0 |
| 2018-10-08 04:30:00 | ES | Futures | 3139.95 | 3139.95 | 3136.68 | 3136.68 | 10444.0 |
| 2018-10-08 05:00:00 | ES | Futures | 3136.68 | 3139.95 | 3136.14 | 3139.4 | 8795.0 |
| 2018-10-08 05:30:00 | ES | Futures | 3139.68 | 3143.48 | 3139.4 | 3141.85 | 13451.0 |
| 2018-10-08 06:00:00 | ES | Futures | 3141.85 | 3143.21 | 3139.13 | 3140.22 | 9132.0 |
| 2018-10-08 06:30:00 | ES | Futures | 3139.95 | 3141.04 | 3138.32 | 3140.22 | 5148.0 |
| 2018-10-08 07:00:00 | ES | Futures | 3139.95 | 3142.12 | 3139.4 | 3141.85 | 6682.0 |
| 2018-10-08 07:30:00 | ES | Futures | 3141.85 | 3144.03 | 3141.31 | 3142.94 | 8219.0 |
| 2018-10-08 08:00:00 | ES | Futures | 3142.67 | 3143.48 | 3140.76 | 3141.31 | 7684.0 |
| 2018-10-08 08:30:00 | ES | Futures | 3141.58 | 3141.58 | 3139.13 | 3139.95 | 12417.0 |
| 2018-10-08 09:00:00 | ES | Futures | 3139.95 | 3140.49 | 3134.78 | 3135.05 | 30077.0 |
| 2018-10-08 09:30:00 | ES | Futures | 3134.78 | 3145.66 | 3131.24 | 3142.4 | 214120.0 |
| 2018-10-08 10:00:00 | ES | Futures | 3142.4 | 3147.56 | 3141.85 | 3145.66 | 92892.0 |
| 2018-10-08 10:30:00 | ES | Futures | 3145.93 | 3146.48 | 3138.86 | 3141.04 | 83187.0 |
| 2018-10-08 11:00:00 | ES | Futures | 3140.76 | 3141.04 | 3133.96 | 3133.96 | 77729.0 |
| 2018-10-08 11:30:00 | ES | Futures | 3133.96 | 3134.51 | 3118.19 | 3125.26 | 191831.0 |
| 2018-10-08 12:00:00 | ES | Futures | 3125.26 | 3129.61 | 3121.45 | 3129.07 | 101921.0 |
| 2018-10-08 12:30:00 | ES | Futures | 3129.07 | 3129.61 | 3119.28 | 3119.55 | 81444.0 |
| 2018-10-08 13:00:00 | ES | Futures | 3119.28 | 3128.52 | 3118.73 | 3121.72 | 83355.0 |
| 2018-10-08 13:30:00 | ES | Futures | 3121.72 | 3131.52 | 3121.45 | 3128.25 | 72556.0 |
| 2018-10-08 14:00:00 | ES | Futures | 3127.98 | 3139.95 | 3127.71 | 3137.5 | 104317.0 |
| 2018-10-08 14:30:00 | ES | Futures | 3137.5 | 3145.12 | 3137.5 | 3141.31 | 94030.0 |
| 2018-10-08 15:00:00 | ES | Futures | 3141.31 | 3147.29 | 3140.49 | 3143.21 | 78240.0 |
| 2018-10-08 15:30:00 | ES | Futures | 3143.21 | 3148.38 | 3142.94 | 3144.03 | 150584.0 |
| 2018-10-08 16:00:00 | ES | Futures | 3144.03 | 3148.65 | 3143.48 | 3148.65 | 60388.0 |
| 2018-10-08 16:30:00 | ES | Futures | 3148.38 | 3148.65 | 3145.93 | 3147.02 | 8146.0 |
| 2018-10-08 18:00:00 | ES | Futures | 3146.75 | 3147.84 | 3145.93 | 3147.56 | 2923.0 |
| 2018-10-08 18:30:00 | ES | Futures | 3147.56 | 3147.56 | 3146.2 | 3147.29 | 1009.0 |
| 2018-10-08 19:00:00 | ES | Futures | 3147.29 | 3147.84 | 3145.39 | 3146.2 | 2491.0 |
| 2018-10-08 19:30:00 | ES | Futures | 3146.2 | 3146.48 | 3144.84 | 3145.66 | 2262.0 |
| 2018-10-08 20:00:00 | ES | Futures | 3145.39 | 3145.93 | 3143.48 | 3144.57 | 5255.0 |
| 2018-10-08 20:30:00 | ES | Futures | 3144.57 | 3146.2 | 3143.48 | 3145.66 | 2508.0 |
| 2018-10-08 21:00:00 | ES | Futures | 3145.66 | 3145.93 | 3143.48 | 3145.12 | 5041.0 |
| 2018-10-08 21:30:00 | ES | Futures | 3145.39 | 3147.29 | 3143.21 | 3145.12 | 4638.0 |
| 2018-10-08 22:00:00 | ES | Futures | 3144.84 | 3148.92 | 3144.3 | 3148.38 | 5526.0 |
| 2018-10-08 22:30:00 | ES | Futures | 3148.38 | 3148.65 | 3146.75 | 3147.56 | 2928.0 |
| 2018-10-08 23:00:00 | ES | Futures | 3147.56 | 3147.56 | 3145.12 | 3145.66 | 3286.0 |
| 2018-10-08 23:30:00 | ES | Futures | 3145.66 | 3145.93 | 3144.03 | 3145.12 | 2900.0 |
| 2018-10-08 00:00:00 | NQ | Futures | 8718.47 | 8720.82 | 8713.19 | 8720.52 | 1430.0 |
| 2018-10-08 00:30:00 | NQ | Futures | 8720.23 | 8724.92 | 8719.35 | 8720.52 | 1476.0 |
| 2018-10-08 01:00:00 | NQ | Futures | 8721.11 | 8729.03 | 8717.59 | 8720.23 | 1504.0 |
| 2018-10-08 01:30:00 | NQ | Futures | 8720.23 | 8724.34 | 8718.18 | 8722.58 | 625.0 |
> showing 50 of 3,195 rows — these rows as CSV