PREVIEW / futures_30min / 2019-06-07
file: by_date/futures_30min/2019/2019-06-07.parquet size: 78 KB rows: 2,734
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-07 00:00:00 | ES | Futures | 3090.29 | 3090.84 | 3090.02 | 3090.02 | 1135.0 |
| 2019-06-07 00:30:00 | ES | Futures | 3090.02 | 3091.11 | 3090.02 | 3090.57 | 1672.0 |
| 2019-06-07 01:00:00 | ES | Futures | 3090.57 | 3091.38 | 3089.21 | 3089.48 | 2609.0 |
| 2019-06-07 01:30:00 | ES | Futures | 3089.75 | 3091.11 | 3089.48 | 3091.11 | 1738.0 |
| 2019-06-07 02:00:00 | ES | Futures | 3090.84 | 3091.65 | 3090.02 | 3091.38 | 5328.0 |
| 2019-06-07 02:30:00 | ES | Futures | 3091.38 | 3091.38 | 3087.85 | 3089.21 | 4954.0 |
| 2019-06-07 03:00:00 | ES | Futures | 3089.48 | 3094.36 | 3088.94 | 3091.92 | 13145.0 |
| 2019-06-07 03:30:00 | ES | Futures | 3091.92 | 3094.36 | 3090.84 | 3091.92 | 8409.0 |
| 2019-06-07 04:00:00 | ES | Futures | 3091.92 | 3096.53 | 3091.92 | 3095.17 | 11676.0 |
| 2019-06-07 04:30:00 | ES | Futures | 3095.45 | 3095.99 | 3094.09 | 3094.36 | 6565.0 |
| 2019-06-07 05:00:00 | ES | Futures | 3094.36 | 3096.53 | 3094.09 | 3096.53 | 5771.0 |
| 2019-06-07 05:30:00 | ES | Futures | 3096.26 | 3096.53 | 3093.82 | 3094.9 | 8237.0 |
| 2019-06-07 06:00:00 | ES | Futures | 3094.63 | 3096.8 | 3093.82 | 3096.8 | 7056.0 |
| 2019-06-07 06:30:00 | ES | Futures | 3096.8 | 3097.89 | 3095.45 | 3097.07 | 10216.0 |
| 2019-06-07 07:00:00 | ES | Futures | 3097.34 | 3097.34 | 3094.9 | 3095.17 | 10366.0 |
| 2019-06-07 07:30:00 | ES | Futures | 3095.17 | 3096.26 | 3094.63 | 3094.9 | 7169.0 |
| 2019-06-07 08:00:00 | ES | Futures | 3094.63 | 3096.8 | 3093.28 | 3095.45 | 14245.0 |
| 2019-06-07 08:30:00 | ES | Futures | 3095.45 | 3102.77 | 3086.5 | 3093.01 | 123940.0 |
| 2019-06-07 09:00:00 | ES | Futures | 3093.01 | 3098.7 | 3091.92 | 3097.89 | 43316.0 |
| 2019-06-07 09:30:00 | ES | Futures | 3097.89 | 3110.63 | 3095.72 | 3110.36 | 201673.0 |
| 2019-06-07 10:00:00 | ES | Futures | 3110.36 | 3114.69 | 3109.54 | 3113.88 | 127730.0 |
| 2019-06-07 10:30:00 | ES | Futures | 3114.15 | 3128.79 | 3113.88 | 3128.79 | 158399.0 |
| 2019-06-07 11:00:00 | ES | Futures | 3128.79 | 3129.88 | 3118.49 | 3119.03 | 120987.0 |
| 2019-06-07 11:30:00 | ES | Futures | 3118.76 | 3122.28 | 3117.41 | 3119.03 | 75979.0 |
| 2019-06-07 12:00:00 | ES | Futures | 3119.03 | 3122.56 | 3116.59 | 3122.28 | 54851.0 |
| 2019-06-07 12:30:00 | ES | Futures | 3122.01 | 3126.08 | 3119.84 | 3126.08 | 54936.0 |
| 2019-06-07 13:00:00 | ES | Futures | 3126.08 | 3127.16 | 3119.84 | 3121.47 | 53290.0 |
| 2019-06-07 13:30:00 | ES | Futures | 3121.74 | 3124.72 | 3121.47 | 3123.64 | 36212.0 |
| 2019-06-07 14:00:00 | ES | Futures | 3123.91 | 3124.72 | 3120.66 | 3122.83 | 38514.0 |
| 2019-06-07 14:30:00 | ES | Futures | 3122.83 | 3124.18 | 3117.41 | 3117.95 | 54145.0 |
| 2019-06-07 15:00:00 | ES | Futures | 3117.95 | 3123.64 | 3117.68 | 3122.56 | 52829.0 |
| 2019-06-07 15:30:00 | ES | Futures | 3122.56 | 3123.64 | 3114.97 | 3116.05 | 150592.0 |
| 2019-06-07 16:00:00 | ES | Futures | 3116.05 | 3119.57 | 3113.07 | 3117.95 | 75641.0 |
| 2019-06-07 16:30:00 | ES | Futures | 3117.13 | 3120.93 | 3116.59 | 3120.39 | 7575.0 |
| 2019-06-07 00:00:00 | NQ | Futures | 8489.82 | 8493.31 | 8489.53 | 8491.28 | 512.0 |
| 2019-06-07 00:30:00 | NQ | Futures | 8491.28 | 8493.31 | 8489.53 | 8489.82 | 766.0 |
| 2019-06-07 01:00:00 | NQ | Futures | 8489.82 | 8492.73 | 8486.03 | 8487.2 | 1057.0 |
| 2019-06-07 01:30:00 | NQ | Futures | 8487.2 | 8491.86 | 8485.74 | 8491.28 | 751.0 |
| 2019-06-07 02:00:00 | NQ | Futures | 8491.57 | 8492.44 | 8487.49 | 8490.98 | 1302.0 |
| 2019-06-07 02:30:00 | NQ | Futures | 8490.69 | 8490.69 | 8481.08 | 8485.16 | 1653.0 |
| 2019-06-07 03:00:00 | NQ | Futures | 8484.87 | 8500.59 | 8482.83 | 8493.02 | 4002.0 |
| 2019-06-07 03:30:00 | NQ | Futures | 8492.73 | 8500.59 | 8491.28 | 8493.31 | 2449.0 |
| 2019-06-07 04:00:00 | NQ | Futures | 8493.6 | 8516.9 | 8493.02 | 8513.69 | 5389.0 |
| 2019-06-07 04:30:00 | NQ | Futures | 8513.99 | 8515.44 | 8509.04 | 8511.36 | 1829.0 |
| 2019-06-07 05:00:00 | NQ | Futures | 8511.36 | 8519.81 | 8510.2 | 8518.93 | 1803.0 |
| 2019-06-07 05:30:00 | NQ | Futures | 8518.93 | 8520.39 | 8512.24 | 8514.28 | 2042.0 |
| 2019-06-07 06:00:00 | NQ | Futures | 8514.28 | 8521.26 | 8510.49 | 8520.68 | 1769.0 |
| 2019-06-07 06:30:00 | NQ | Futures | 8520.97 | 8526.21 | 8516.9 | 8524.18 | 2605.0 |
| 2019-06-07 07:00:00 | NQ | Futures | 8524.18 | 8525.34 | 8513.69 | 8514.28 | 2535.0 |
| 2019-06-07 07:30:00 | NQ | Futures | 8514.86 | 8516.9 | 8511.07 | 8512.24 | 1940.0 |
> showing 50 of 2,734 rows — these rows as CSV