PREVIEW / futures_30min / 2018-09-26
file: by_date/futures_30min/2018/2018-09-26.parquet size: 82 KB rows: 3,174
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-09-26 00:00:00 | ES | Futures | 3185.37 | 3185.64 | 3184.56 | 3184.56 | 1286.0 |
| 2018-09-26 00:30:00 | ES | Futures | 3184.56 | 3185.1 | 3184.56 | 3185.1 | 735.0 |
| 2018-09-26 01:00:00 | ES | Futures | 3185.1 | 3186.46 | 3185.1 | 3185.92 | 2809.0 |
| 2018-09-26 01:30:00 | ES | Futures | 3185.92 | 3186.19 | 3184.83 | 3185.37 | 1749.0 |
| 2018-09-26 02:00:00 | ES | Futures | 3185.37 | 3185.64 | 3183.74 | 3183.74 | 3163.0 |
| 2018-09-26 02:30:00 | ES | Futures | 3183.74 | 3184.28 | 3183.2 | 3183.74 | 2454.0 |
| 2018-09-26 03:00:00 | ES | Futures | 3183.74 | 3184.28 | 3182.92 | 3183.47 | 7392.0 |
| 2018-09-26 03:30:00 | ES | Futures | 3183.47 | 3184.28 | 3181.84 | 3184.28 | 4472.0 |
| 2018-09-26 04:00:00 | ES | Futures | 3184.01 | 3185.1 | 3183.47 | 3185.1 | 3401.0 |
| 2018-09-26 04:30:00 | ES | Futures | 3184.83 | 3186.19 | 3184.01 | 3184.83 | 4321.0 |
| 2018-09-26 05:00:00 | ES | Futures | 3185.1 | 3185.64 | 3184.28 | 3185.37 | 4062.0 |
| 2018-09-26 05:30:00 | ES | Futures | 3185.1 | 3185.1 | 3183.74 | 3184.56 | 5566.0 |
| 2018-09-26 06:00:00 | ES | Futures | 3184.56 | 3185.92 | 3184.28 | 3184.56 | 6560.0 |
| 2018-09-26 06:30:00 | ES | Futures | 3184.56 | 3185.92 | 3184.01 | 3185.37 | 7695.0 |
| 2018-09-26 07:00:00 | ES | Futures | 3185.37 | 3185.37 | 3184.01 | 3184.83 | 5842.0 |
| 2018-09-26 07:30:00 | ES | Futures | 3184.56 | 3184.83 | 3182.38 | 3182.65 | 4665.0 |
| 2018-09-26 08:00:00 | ES | Futures | 3182.65 | 3183.2 | 3181.56 | 3182.92 | 5665.0 |
| 2018-09-26 08:30:00 | ES | Futures | 3182.65 | 3182.92 | 3181.56 | 3182.38 | 5820.0 |
| 2018-09-26 09:00:00 | ES | Futures | 3182.11 | 3182.38 | 3178.57 | 3179.39 | 19834.0 |
| 2018-09-26 09:30:00 | ES | Futures | 3179.39 | 3184.01 | 3179.12 | 3182.11 | 98046.0 |
| 2018-09-26 10:00:00 | ES | Futures | 3182.38 | 3182.92 | 3177.21 | 3180.48 | 60103.0 |
| 2018-09-26 10:30:00 | ES | Futures | 3180.48 | 3184.83 | 3180.2 | 3184.01 | 57647.0 |
| 2018-09-26 11:00:00 | ES | Futures | 3184.01 | 3186.46 | 3183.74 | 3186.19 | 38231.0 |
| 2018-09-26 11:30:00 | ES | Futures | 3186.46 | 3186.73 | 3184.28 | 3185.1 | 28626.0 |
| 2018-09-26 12:00:00 | ES | Futures | 3185.1 | 3185.64 | 3183.74 | 3185.64 | 16271.0 |
| 2018-09-26 12:30:00 | ES | Futures | 3185.64 | 3187.55 | 3185.1 | 3187.55 | 25066.0 |
| 2018-09-26 13:00:00 | ES | Futures | 3187.55 | 3187.82 | 3186.19 | 3186.19 | 30037.0 |
| 2018-09-26 13:30:00 | ES | Futures | 3186.46 | 3186.73 | 3184.56 | 3184.83 | 39311.0 |
| 2018-09-26 14:00:00 | ES | Futures | 3185.1 | 3194.35 | 3184.56 | 3190.81 | 128273.0 |
| 2018-09-26 14:30:00 | ES | Futures | 3191.08 | 3192.44 | 3183.74 | 3185.1 | 98656.0 |
| 2018-09-26 15:00:00 | ES | Futures | 3185.1 | 3187.55 | 3181.29 | 3184.28 | 78897.0 |
| 2018-09-26 15:30:00 | ES | Futures | 3184.28 | 3184.56 | 3163.34 | 3168.24 | 352411.0 |
| 2018-09-26 16:00:00 | ES | Futures | 3168.24 | 3168.51 | 3163.88 | 3167.96 | 80115.0 |
| 2018-09-26 16:30:00 | ES | Futures | 3168.24 | 3169.87 | 3165.52 | 3168.24 | 11374.0 |
| 2018-09-26 18:00:00 | ES | Futures | 3167.69 | 3169.05 | 3166.6 | 3167.69 | 5064.0 |
| 2018-09-26 18:30:00 | ES | Futures | 3167.69 | 3170.41 | 3167.69 | 3170.14 | 3006.0 |
| 2018-09-26 19:00:00 | ES | Futures | 3169.87 | 3170.41 | 3169.6 | 3170.14 | 1286.0 |
| 2018-09-26 19:30:00 | ES | Futures | 3170.14 | 3170.68 | 3168.51 | 3170.14 | 3836.0 |
| 2018-09-26 20:00:00 | ES | Futures | 3170.14 | 3170.96 | 3169.32 | 3170.14 | 3431.0 |
| 2018-09-26 20:30:00 | ES | Futures | 3170.14 | 3171.23 | 3170.14 | 3170.96 | 1896.0 |
| 2018-09-26 21:00:00 | ES | Futures | 3170.96 | 3171.77 | 3170.14 | 3171.5 | 2973.0 |
| 2018-09-26 21:30:00 | ES | Futures | 3171.23 | 3171.77 | 3169.87 | 3171.77 | 2990.0 |
| 2018-09-26 22:00:00 | ES | Futures | 3171.5 | 3171.77 | 3170.96 | 3170.96 | 1745.0 |
| 2018-09-26 22:30:00 | ES | Futures | 3170.96 | 3172.32 | 3170.68 | 3172.04 | 2383.0 |
| 2018-09-26 23:00:00 | ES | Futures | 3171.77 | 3172.04 | 3170.96 | 3170.96 | 1655.0 |
| 2018-09-26 23:30:00 | ES | Futures | 3170.96 | 3170.96 | 3168.24 | 3169.32 | 4339.0 |
| 2018-09-26 00:00:00 | NQ | Futures | 8944.03 | 8945.2 | 8941.39 | 8941.68 | 910.0 |
| 2018-09-26 00:30:00 | NQ | Futures | 8941.68 | 8944.03 | 8941.39 | 8943.15 | 325.0 |
| 2018-09-26 01:00:00 | NQ | Futures | 8943.15 | 8950.77 | 8942.56 | 8949.01 | 1521.0 |
| 2018-09-26 01:30:00 | NQ | Futures | 8949.31 | 8949.89 | 8942.85 | 8946.08 | 781.0 |
> showing 50 of 3,174 rows — these rows as CSV