PREVIEW / futures_30min / 2018-08-10
file: by_date/futures_30min/2018/2018-08-10.parquet size: 78 KB rows: 2,662
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-08-10 00:00:00 | ES | Futures | 3106.12 | 3106.39 | 3104.21 | 3104.75 | 1322.0 |
| 2018-08-10 00:30:00 | ES | Futures | 3104.75 | 3105.84 | 3104.75 | 3104.75 | 1186.0 |
| 2018-08-10 01:00:00 | ES | Futures | 3105.03 | 3105.03 | 3099.85 | 3100.12 | 10343.0 |
| 2018-08-10 01:30:00 | ES | Futures | 3099.85 | 3100.39 | 3097.67 | 3098.76 | 10111.0 |
| 2018-08-10 02:00:00 | ES | Futures | 3098.76 | 3099.85 | 3097.4 | 3098.49 | 9162.0 |
| 2018-08-10 02:30:00 | ES | Futures | 3098.76 | 3098.76 | 3095.49 | 3095.49 | 11112.0 |
| 2018-08-10 03:00:00 | ES | Futures | 3095.49 | 3098.76 | 3094.13 | 3098.76 | 15117.0 |
| 2018-08-10 03:30:00 | ES | Futures | 3098.76 | 3099.85 | 3094.4 | 3095.49 | 13784.0 |
| 2018-08-10 04:00:00 | ES | Futures | 3095.49 | 3097.67 | 3094.67 | 3095.49 | 8483.0 |
| 2018-08-10 04:30:00 | ES | Futures | 3095.76 | 3098.21 | 3094.67 | 3096.03 | 8971.0 |
| 2018-08-10 05:00:00 | ES | Futures | 3096.03 | 3099.3 | 3095.49 | 3096.85 | 8030.0 |
| 2018-08-10 05:30:00 | ES | Futures | 3096.85 | 3097.67 | 3091.68 | 3092.49 | 13735.0 |
| 2018-08-10 06:00:00 | ES | Futures | 3092.76 | 3097.4 | 3092.22 | 3096.85 | 9977.0 |
| 2018-08-10 06:30:00 | ES | Futures | 3097.12 | 3097.94 | 3096.03 | 3097.4 | 8927.0 |
| 2018-08-10 07:00:00 | ES | Futures | 3097.67 | 3097.94 | 3095.76 | 3097.12 | 7351.0 |
| 2018-08-10 07:30:00 | ES | Futures | 3097.12 | 3097.94 | 3094.94 | 3095.22 | 12697.0 |
| 2018-08-10 08:00:00 | ES | Futures | 3095.22 | 3096.58 | 3093.04 | 3095.76 | 19170.0 |
| 2018-08-10 08:30:00 | ES | Futures | 3095.76 | 3099.3 | 3094.13 | 3094.67 | 29573.0 |
| 2018-08-10 09:00:00 | ES | Futures | 3094.67 | 3095.76 | 3090.04 | 3091.95 | 41917.0 |
| 2018-08-10 09:30:00 | ES | Futures | 3091.95 | 3096.85 | 3088.68 | 3089.77 | 168082.0 |
| 2018-08-10 10:00:00 | ES | Futures | 3089.5 | 3094.94 | 3086.5 | 3090.59 | 115669.0 |
| 2018-08-10 10:30:00 | ES | Futures | 3090.86 | 3094.67 | 3088.41 | 3094.4 | 75247.0 |
| 2018-08-10 11:00:00 | ES | Futures | 3094.13 | 3097.4 | 3091.13 | 3094.94 | 62651.0 |
| 2018-08-10 11:30:00 | ES | Futures | 3094.94 | 3098.49 | 3094.13 | 3094.67 | 54642.0 |
| 2018-08-10 12:00:00 | ES | Futures | 3094.67 | 3094.67 | 3091.95 | 3094.4 | 39877.0 |
| 2018-08-10 12:30:00 | ES | Futures | 3094.4 | 3095.22 | 3091.4 | 3093.04 | 27305.0 |
| 2018-08-10 13:00:00 | ES | Futures | 3093.04 | 3093.31 | 3088.68 | 3091.4 | 34414.0 |
| 2018-08-10 13:30:00 | ES | Futures | 3091.13 | 3091.68 | 3083.77 | 3084.59 | 60685.0 |
| 2018-08-10 14:00:00 | ES | Futures | 3084.32 | 3087.59 | 3080.5 | 3080.5 | 68944.0 |
| 2018-08-10 14:30:00 | ES | Futures | 3080.5 | 3085.14 | 3080.23 | 3082.96 | 50504.0 |
| 2018-08-10 15:00:00 | ES | Futures | 3082.96 | 3093.58 | 3079.96 | 3090.31 | 116294.0 |
| 2018-08-10 15:30:00 | ES | Futures | 3090.31 | 3091.4 | 3086.5 | 3088.41 | 139170.0 |
| 2018-08-10 16:00:00 | ES | Futures | 3088.41 | 3093.31 | 3088.13 | 3092.49 | 65997.0 |
| 2018-08-10 16:30:00 | ES | Futures | 3091.95 | 3094.67 | 3091.68 | 3094.4 | 9501.0 |
| 2018-08-10 00:00:00 | NQ | Futures | 8787.2 | 8787.79 | 8781.02 | 8783.67 | 482.0 |
| 2018-08-10 00:30:00 | NQ | Futures | 8783.38 | 8787.5 | 8782.79 | 8783.38 | 505.0 |
| 2018-08-10 01:00:00 | NQ | Futures | 8783.38 | 8783.97 | 8763.65 | 8764.24 | 2876.0 |
| 2018-08-10 01:30:00 | NQ | Futures | 8764.24 | 8764.24 | 8750.4 | 8758.35 | 3503.0 |
| 2018-08-10 02:00:00 | NQ | Futures | 8758.35 | 8763.95 | 8754.82 | 8763.06 | 2648.0 |
| 2018-08-10 02:30:00 | NQ | Futures | 8762.47 | 8763.65 | 8753.05 | 8753.05 | 2026.0 |
| 2018-08-10 03:00:00 | NQ | Futures | 8753.35 | 8762.77 | 8748.64 | 8762.47 | 3442.0 |
| 2018-08-10 03:30:00 | NQ | Futures | 8763.06 | 8769.54 | 8753.05 | 8758.35 | 3824.0 |
| 2018-08-10 04:00:00 | NQ | Futures | 8758.06 | 8766.01 | 8755.41 | 8758.65 | 1737.0 |
| 2018-08-10 04:30:00 | NQ | Futures | 8759.23 | 8764.83 | 8756.88 | 8761.59 | 2032.0 |
| 2018-08-10 05:00:00 | NQ | Futures | 8761.59 | 8769.54 | 8759.23 | 8761.88 | 1685.0 |
| 2018-08-10 05:30:00 | NQ | Futures | 8761.88 | 8765.71 | 8744.81 | 8746.87 | 3401.0 |
| 2018-08-10 06:00:00 | NQ | Futures | 8746.57 | 8758.65 | 8743.34 | 8756.88 | 2950.0 |
| 2018-08-10 06:30:00 | NQ | Futures | 8756.58 | 8761.3 | 8753.35 | 8760.12 | 1651.0 |
| 2018-08-10 07:00:00 | NQ | Futures | 8760.71 | 8762.18 | 8754.82 | 8760.12 | 1784.0 |
| 2018-08-10 07:30:00 | NQ | Futures | 8760.12 | 8763.06 | 8751.58 | 8752.46 | 2037.0 |
> showing 50 of 2,662 rows — these rows as CSV