PREVIEW / futures_30min / 2023-05-31
file: by_date/futures_30min/2023/2023-05-31.parquet size: 110 KB rows: 3,917
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-31 00:00:00 | ES | Futures | 4665.64 | 4666.47 | 4664.25 | 4665.36 | 2147.0 |
| 2023-05-31 00:30:00 | ES | Futures | 4665.36 | 4666.19 | 4664.53 | 4664.81 | 2114.0 |
| 2023-05-31 01:00:00 | ES | Futures | 4664.53 | 4664.53 | 4660.37 | 4661.48 | 5827.0 |
| 2023-05-31 01:30:00 | ES | Futures | 4661.76 | 4663.7 | 4659.54 | 4662.31 | 6465.0 |
| 2023-05-31 02:00:00 | ES | Futures | 4662.31 | 4663.42 | 4653.44 | 4656.76 | 11426.0 |
| 2023-05-31 02:30:00 | ES | Futures | 4657.04 | 4660.92 | 4656.76 | 4657.04 | 6531.0 |
| 2023-05-31 03:00:00 | ES | Futures | 4657.04 | 4665.92 | 4654.54 | 4665.08 | 17895.0 |
| 2023-05-31 03:30:00 | ES | Futures | 4664.81 | 4667.58 | 4662.31 | 4664.53 | 12294.0 |
| 2023-05-31 04:00:00 | ES | Futures | 4664.53 | 4668.13 | 4661.48 | 4665.08 | 9912.0 |
| 2023-05-31 04:30:00 | ES | Futures | 4665.08 | 4667.03 | 4660.09 | 4666.75 | 7662.0 |
| 2023-05-31 05:00:00 | ES | Futures | 4666.47 | 4670.91 | 4666.19 | 4668.97 | 7012.0 |
| 2023-05-31 05:30:00 | ES | Futures | 4669.24 | 4671.19 | 4663.97 | 4664.25 | 6274.0 |
| 2023-05-31 06:00:00 | ES | Futures | 4664.25 | 4666.75 | 4660.37 | 4660.92 | 8108.0 |
| 2023-05-31 06:30:00 | ES | Futures | 4660.65 | 4666.75 | 4659.81 | 4665.92 | 9005.0 |
| 2023-05-31 07:00:00 | ES | Futures | 4665.92 | 4667.58 | 4661.2 | 4662.87 | 9276.0 |
| 2023-05-31 07:30:00 | ES | Futures | 4662.87 | 4664.81 | 4655.1 | 4656.76 | 12072.0 |
| 2023-05-31 08:00:00 | ES | Futures | 4656.76 | 4658.15 | 4653.16 | 4654.82 | 11903.0 |
| 2023-05-31 08:30:00 | ES | Futures | 4654.54 | 4656.21 | 4651.49 | 4653.16 | 16332.0 |
| 2023-05-31 09:00:00 | ES | Futures | 4653.16 | 4655.93 | 4650.66 | 4653.71 | 25837.0 |
| 2023-05-31 09:30:00 | ES | Futures | 4653.71 | 4664.53 | 4651.22 | 4652.33 | 212069.0 |
| 2023-05-31 10:00:00 | ES | Futures | 4652.33 | 4654.27 | 4633.19 | 4638.18 | 213422.0 |
| 2023-05-31 10:30:00 | ES | Futures | 4637.9 | 4641.79 | 4631.8 | 4637.63 | 155134.0 |
| 2023-05-31 11:00:00 | ES | Futures | 4637.63 | 4640.12 | 4631.25 | 4631.25 | 98551.0 |
| 2023-05-31 11:30:00 | ES | Futures | 4631.25 | 4640.4 | 4630.69 | 4636.79 | 94640.0 |
| 2023-05-31 12:00:00 | ES | Futures | 4636.52 | 4641.51 | 4634.3 | 4636.79 | 65858.0 |
| 2023-05-31 12:30:00 | ES | Futures | 4636.52 | 4644.01 | 4633.19 | 4639.84 | 79598.0 |
| 2023-05-31 13:00:00 | ES | Futures | 4639.84 | 4646.22 | 4638.18 | 4646.22 | 63019.0 |
| 2023-05-31 13:30:00 | ES | Futures | 4646.22 | 4655.93 | 4643.17 | 4653.99 | 127799.0 |
| 2023-05-31 14:00:00 | ES | Futures | 4653.71 | 4658.7 | 4650.38 | 4657.04 | 83267.0 |
| 2023-05-31 14:30:00 | ES | Futures | 4656.76 | 4658.15 | 4645.67 | 4652.05 | 93785.0 |
| 2023-05-31 15:00:00 | ES | Futures | 4652.05 | 4653.44 | 4647.33 | 4652.88 | 78612.0 |
| 2023-05-31 15:30:00 | ES | Futures | 4653.16 | 4663.42 | 4646.5 | 4649.83 | 330281.0 |
| 2023-05-31 16:00:00 | ES | Futures | 4649.83 | 4652.88 | 4645.39 | 4650.11 | 96076.0 |
| 2023-05-31 16:30:00 | ES | Futures | 4650.38 | 4651.77 | 4645.95 | 4646.5 | 18288.0 |
| 2023-05-31 18:00:00 | ES | Futures | 4646.78 | 4649.55 | 4646.5 | 4648.17 | 4211.0 |
| 2023-05-31 18:30:00 | ES | Futures | 4647.89 | 4651.77 | 4647.33 | 4651.49 | 3608.0 |
| 2023-05-31 19:00:00 | ES | Futures | 4651.49 | 4652.88 | 4649.83 | 4650.94 | 2474.0 |
| 2023-05-31 19:30:00 | ES | Futures | 4651.22 | 4656.21 | 4650.66 | 4655.38 | 3487.0 |
| 2023-05-31 20:00:00 | ES | Futures | 4655.65 | 4656.76 | 4653.71 | 4654.82 | 5832.0 |
| 2023-05-31 20:30:00 | ES | Futures | 4654.54 | 4655.38 | 4645.95 | 4648.44 | 6570.0 |
| 2023-05-31 21:00:00 | ES | Futures | 4648.17 | 4662.31 | 4647.89 | 4656.49 | 9405.0 |
| 2023-05-31 21:30:00 | ES | Futures | 4656.76 | 4657.32 | 4640.12 | 4647.89 | 19527.0 |
| 2023-05-31 22:00:00 | ES | Futures | 4647.89 | 4649.83 | 4642.62 | 4645.67 | 7104.0 |
| 2023-05-31 22:30:00 | ES | Futures | 4645.67 | 4650.66 | 4645.67 | 4649.27 | 4199.0 |
| 2023-05-31 23:00:00 | ES | Futures | 4649.27 | 4652.6 | 4648.44 | 4651.49 | 3326.0 |
| 2023-05-31 23:30:00 | ES | Futures | 4651.49 | 4652.6 | 4649.0 | 4651.77 | 3250.0 |
| 2023-05-31 00:00:00 | NQ | Futures | 16195.49 | 16197.75 | 16185.36 | 16187.61 | 1238.0 |
| 2023-05-31 00:30:00 | NQ | Futures | 16187.89 | 16192.68 | 16185.64 | 16185.92 | 1186.0 |
| 2023-05-31 01:00:00 | NQ | Futures | 16185.64 | 16185.64 | 16163.4 | 16167.9 | 3548.0 |
| 2023-05-31 01:30:00 | NQ | Futures | 16167.62 | 16175.5 | 16154.67 | 16167.9 | 3276.0 |
> showing 50 of 3,917 rows — these rows as CSV