PREVIEW / futures_30min / 2019-06-10
file: by_date/futures_30min/2019/2019-06-10.parquet size: 74 KB rows: 2,924
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-06-10 00:00:00 | ES | Futures | 3126.62 | 3127.44 | 3126.35 | 3126.89 | 3046.0 |
| 2019-06-10 00:30:00 | ES | Futures | 3126.89 | 3128.79 | 3126.35 | 3128.52 | 3077.0 |
| 2019-06-10 01:00:00 | ES | Futures | 3128.52 | 3128.79 | 3127.16 | 3127.71 | 2899.0 |
| 2019-06-10 01:30:00 | ES | Futures | 3127.98 | 3127.98 | 3126.35 | 3126.89 | 3452.0 |
| 2019-06-10 02:00:00 | ES | Futures | 3126.89 | 3129.6 | 3125.81 | 3128.79 | 6041.0 |
| 2019-06-10 02:30:00 | ES | Futures | 3128.79 | 3128.79 | 3127.16 | 3127.71 | 3531.0 |
| 2019-06-10 03:00:00 | ES | Futures | 3127.71 | 3128.79 | 3125.54 | 3128.52 | 7621.0 |
| 2019-06-10 03:30:00 | ES | Futures | 3128.52 | 3130.15 | 3126.89 | 3129.33 | 8126.0 |
| 2019-06-10 04:00:00 | ES | Futures | 3129.06 | 3130.42 | 3127.16 | 3128.52 | 8177.0 |
| 2019-06-10 04:30:00 | ES | Futures | 3128.52 | 3128.52 | 3125.27 | 3126.89 | 7916.0 |
| 2019-06-10 05:00:00 | ES | Futures | 3126.89 | 3127.71 | 3125.54 | 3126.35 | 6747.0 |
| 2019-06-10 05:30:00 | ES | Futures | 3126.35 | 3127.98 | 3125.54 | 3127.98 | 3738.0 |
| 2019-06-10 06:00:00 | ES | Futures | 3128.25 | 3129.33 | 3127.44 | 3129.33 | 6011.0 |
| 2019-06-10 06:30:00 | ES | Futures | 3129.6 | 3130.69 | 3127.71 | 3127.98 | 5693.0 |
| 2019-06-10 07:00:00 | ES | Futures | 3127.71 | 3131.77 | 3126.35 | 3131.5 | 11733.0 |
| 2019-06-10 07:30:00 | ES | Futures | 3131.5 | 3133.67 | 3130.15 | 3132.86 | 10735.0 |
| 2019-06-10 08:00:00 | ES | Futures | 3132.86 | 3134.76 | 3130.96 | 3131.5 | 13325.0 |
| 2019-06-10 08:30:00 | ES | Futures | 3131.23 | 3135.3 | 3130.69 | 3132.32 | 27871.0 |
| 2019-06-10 09:00:00 | ES | Futures | 3132.32 | 3135.3 | 3131.23 | 3134.76 | 18112.0 |
| 2019-06-10 09:30:00 | ES | Futures | 3134.76 | 3140.18 | 3132.86 | 3138.55 | 153760.0 |
| 2019-06-10 10:00:00 | ES | Futures | 3138.55 | 3142.35 | 3136.65 | 3140.72 | 100705.0 |
| 2019-06-10 10:30:00 | ES | Futures | 3140.99 | 3143.97 | 3138.55 | 3141.53 | 83979.0 |
| 2019-06-10 11:00:00 | ES | Futures | 3141.53 | 3145.6 | 3140.99 | 3143.97 | 78128.0 |
| 2019-06-10 11:30:00 | ES | Futures | 3143.97 | 3151.02 | 3143.7 | 3149.4 | 79380.0 |
| 2019-06-10 12:00:00 | ES | Futures | 3149.4 | 3150.21 | 3142.62 | 3143.43 | 56943.0 |
| 2019-06-10 12:30:00 | ES | Futures | 3143.43 | 3143.7 | 3139.91 | 3139.91 | 51875.0 |
| 2019-06-10 13:00:00 | ES | Futures | 3139.91 | 3144.52 | 3139.91 | 3140.72 | 45159.0 |
| 2019-06-10 13:30:00 | ES | Futures | 3140.72 | 3142.89 | 3136.65 | 3138.28 | 49772.0 |
| 2019-06-10 14:00:00 | ES | Futures | 3138.28 | 3138.55 | 3130.42 | 3135.3 | 97307.0 |
| 2019-06-10 14:30:00 | ES | Futures | 3135.03 | 3139.36 | 3134.48 | 3138.82 | 45518.0 |
| 2019-06-10 15:00:00 | ES | Futures | 3139.09 | 3140.18 | 3133.4 | 3133.94 | 48256.0 |
| 2019-06-10 15:30:00 | ES | Futures | 3133.94 | 3139.09 | 3129.88 | 3130.42 | 145179.0 |
| 2019-06-10 16:00:00 | ES | Futures | 3130.42 | 3133.67 | 3129.88 | 3133.67 | 46603.0 |
| 2019-06-10 16:30:00 | ES | Futures | 3133.4 | 3135.57 | 3133.13 | 3133.94 | 7437.0 |
| 2019-06-10 18:00:00 | ES | Futures | 3134.21 | 3134.76 | 3130.69 | 3132.32 | 3331.0 |
| 2019-06-10 18:30:00 | ES | Futures | 3132.32 | 3133.13 | 3132.04 | 3133.13 | 1788.0 |
| 2019-06-10 19:00:00 | ES | Futures | 3133.13 | 3133.13 | 3131.23 | 3132.32 | 1434.0 |
| 2019-06-10 19:30:00 | ES | Futures | 3132.32 | 3132.32 | 3129.88 | 3130.42 | 2979.0 |
| 2019-06-10 20:00:00 | ES | Futures | 3130.42 | 3133.13 | 3129.88 | 3132.04 | 6671.0 |
| 2019-06-10 20:30:00 | ES | Futures | 3132.04 | 3136.92 | 3132.04 | 3136.11 | 6968.0 |
| 2019-06-10 21:00:00 | ES | Futures | 3135.84 | 3139.91 | 3135.84 | 3138.55 | 9187.0 |
| 2019-06-10 21:30:00 | ES | Futures | 3138.55 | 3140.18 | 3137.47 | 3139.91 | 8592.0 |
| 2019-06-10 22:00:00 | ES | Futures | 3140.18 | 3140.45 | 3138.82 | 3140.45 | 3450.0 |
| 2019-06-10 22:30:00 | ES | Futures | 3140.18 | 3140.99 | 3139.91 | 3140.72 | 4494.0 |
| 2019-06-10 23:00:00 | ES | Futures | 3140.72 | 3140.99 | 3139.09 | 3139.64 | 4253.0 |
| 2019-06-10 23:30:00 | ES | Futures | 3139.64 | 3140.45 | 3138.55 | 3139.09 | 2416.0 |
| 2019-06-10 00:00:00 | NQ | Futures | 8667.13 | 8671.21 | 8665.68 | 8668.3 | 897.0 |
| 2019-06-10 00:30:00 | NQ | Futures | 8668.3 | 8675.58 | 8664.8 | 8674.41 | 1107.0 |
| 2019-06-10 01:00:00 | NQ | Futures | 8674.12 | 8675.87 | 8670.04 | 8671.5 | 991.0 |
| 2019-06-10 01:30:00 | NQ | Futures | 8671.79 | 8673.25 | 8666.26 | 8668.3 | 1160.0 |
> showing 50 of 2,924 rows — these rows as CSV