PREVIEW / futures_30min / 2019-07-01
file: by_date/futures_30min/2019/2019-07-01.parquet size: 95 KB rows: 3,479
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-07-01 00:00:00 | ES | Futures | 3215.71 | 3217.06 | 3215.16 | 3215.98 | 3864.0 |
| 2019-07-01 00:30:00 | ES | Futures | 3216.25 | 3218.14 | 3215.71 | 3217.6 | 3328.0 |
| 2019-07-01 01:00:00 | ES | Futures | 3217.6 | 3221.39 | 3217.06 | 3221.12 | 8834.0 |
| 2019-07-01 01:30:00 | ES | Futures | 3221.12 | 3224.91 | 3220.31 | 3224.37 | 7662.0 |
| 2019-07-01 02:00:00 | ES | Futures | 3224.37 | 3225.45 | 3221.93 | 3224.64 | 9559.0 |
| 2019-07-01 02:30:00 | ES | Futures | 3224.91 | 3225.18 | 3222.74 | 3224.1 | 4787.0 |
| 2019-07-01 03:00:00 | ES | Futures | 3223.83 | 3226.8 | 3223.56 | 3223.56 | 17870.0 |
| 2019-07-01 03:30:00 | ES | Futures | 3223.56 | 3227.35 | 3222.74 | 3223.01 | 13676.0 |
| 2019-07-01 04:00:00 | ES | Futures | 3223.29 | 3224.37 | 3221.93 | 3223.01 | 13211.0 |
| 2019-07-01 04:30:00 | ES | Futures | 3223.29 | 3223.29 | 3221.93 | 3222.2 | 8667.0 |
| 2019-07-01 05:00:00 | ES | Futures | 3221.93 | 3223.29 | 3219.77 | 3221.66 | 9588.0 |
| 2019-07-01 05:30:00 | ES | Futures | 3221.39 | 3223.83 | 3221.12 | 3222.47 | 6161.0 |
| 2019-07-01 06:00:00 | ES | Futures | 3222.47 | 3226.26 | 3222.2 | 3225.72 | 6863.0 |
| 2019-07-01 06:30:00 | ES | Futures | 3225.72 | 3226.26 | 3223.29 | 3223.56 | 5784.0 |
| 2019-07-01 07:00:00 | ES | Futures | 3223.56 | 3223.83 | 3221.66 | 3223.01 | 7568.0 |
| 2019-07-01 07:30:00 | ES | Futures | 3222.74 | 3224.91 | 3222.74 | 3223.83 | 7546.0 |
| 2019-07-01 08:00:00 | ES | Futures | 3224.1 | 3226.8 | 3223.56 | 3226.26 | 14644.0 |
| 2019-07-01 08:30:00 | ES | Futures | 3225.99 | 3226.26 | 3223.29 | 3224.1 | 12906.0 |
| 2019-07-01 09:00:00 | ES | Futures | 3223.83 | 3227.89 | 3223.83 | 3225.99 | 20482.0 |
| 2019-07-01 09:30:00 | ES | Futures | 3225.99 | 3228.7 | 3218.95 | 3220.58 | 191721.0 |
| 2019-07-01 10:00:00 | ES | Futures | 3220.85 | 3224.64 | 3215.43 | 3215.98 | 126021.0 |
| 2019-07-01 10:30:00 | ES | Futures | 3215.98 | 3219.77 | 3213.0 | 3215.98 | 80485.0 |
| 2019-07-01 11:00:00 | ES | Futures | 3215.98 | 3218.14 | 3211.1 | 3211.37 | 67028.0 |
| 2019-07-01 11:30:00 | ES | Futures | 3211.37 | 3216.79 | 3210.83 | 3212.46 | 60108.0 |
| 2019-07-01 12:00:00 | ES | Futures | 3212.73 | 3214.35 | 3209.21 | 3210.29 | 45169.0 |
| 2019-07-01 12:30:00 | ES | Futures | 3210.29 | 3211.1 | 3203.79 | 3204.61 | 54235.0 |
| 2019-07-01 13:00:00 | ES | Futures | 3204.61 | 3207.86 | 3202.17 | 3206.23 | 75978.0 |
| 2019-07-01 13:30:00 | ES | Futures | 3205.96 | 3206.77 | 3203.52 | 3206.5 | 40592.0 |
| 2019-07-01 14:00:00 | ES | Futures | 3206.23 | 3206.77 | 3200.55 | 3201.09 | 46645.0 |
| 2019-07-01 14:30:00 | ES | Futures | 3201.09 | 3203.79 | 3200.28 | 3200.82 | 38155.0 |
| 2019-07-01 15:00:00 | ES | Futures | 3201.09 | 3210.56 | 3200.55 | 3209.48 | 68115.0 |
| 2019-07-01 15:30:00 | ES | Futures | 3209.48 | 3215.98 | 3209.48 | 3214.08 | 163273.0 |
| 2019-07-01 16:00:00 | ES | Futures | 3214.08 | 3214.35 | 3211.64 | 3214.08 | 55126.0 |
| 2019-07-01 16:30:00 | ES | Futures | 3214.35 | 3214.89 | 3213.27 | 3213.81 | 6679.0 |
| 2019-07-01 18:00:00 | ES | Futures | 3213.81 | 3214.89 | 3204.88 | 3206.5 | 7479.0 |
| 2019-07-01 18:30:00 | ES | Futures | 3206.5 | 3210.29 | 3206.23 | 3208.94 | 4337.0 |
| 2019-07-01 19:00:00 | ES | Futures | 3209.21 | 3209.48 | 3207.58 | 3209.48 | 1535.0 |
| 2019-07-01 19:30:00 | ES | Futures | 3209.48 | 3209.75 | 3207.31 | 3209.48 | 3138.0 |
| 2019-07-01 20:00:00 | ES | Futures | 3209.21 | 3213.54 | 3209.21 | 3212.19 | 6565.0 |
| 2019-07-01 20:30:00 | ES | Futures | 3212.19 | 3214.08 | 3210.83 | 3213.27 | 4367.0 |
| 2019-07-01 21:00:00 | ES | Futures | 3213.27 | 3214.62 | 3212.19 | 3213.27 | 3494.0 |
| 2019-07-01 21:30:00 | ES | Futures | 3213.27 | 3216.79 | 3212.46 | 3215.71 | 6536.0 |
| 2019-07-01 22:00:00 | ES | Futures | 3215.98 | 3216.52 | 3213.54 | 3214.89 | 3331.0 |
| 2019-07-01 22:30:00 | ES | Futures | 3215.16 | 3215.98 | 3214.08 | 3215.71 | 2330.0 |
| 2019-07-01 23:00:00 | ES | Futures | 3215.43 | 3215.98 | 3214.08 | 3215.98 | 1661.0 |
| 2019-07-01 23:30:00 | ES | Futures | 3215.71 | 3217.06 | 3215.43 | 3216.79 | 1944.0 |
| 2019-07-01 00:00:00 | NQ | Futures | 9045.48 | 9050.99 | 9043.74 | 9048.38 | 1472.0 |
| 2019-07-01 00:30:00 | NQ | Futures | 9047.8 | 9053.6 | 9046.93 | 9049.25 | 1400.0 |
| 2019-07-01 01:00:00 | NQ | Futures | 9049.25 | 9063.18 | 9047.51 | 9061.44 | 2766.0 |
| 2019-07-01 01:30:00 | NQ | Futures | 9061.44 | 9080.01 | 9058.25 | 9077.98 | 3966.0 |
> showing 50 of 3,479 rows — these rows as CSV