PREVIEW / futures_30min / 2024-10-13
file: by_date/futures_30min/2024/2024-10-13.parquet size: 29 KB rows: 819
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-13 18:00:00 | ES | Futures | 6077.52 | 6080.11 | 6074.92 | 6079.6 | 4711.0 |
| 2024-10-13 18:30:00 | ES | Futures | 6079.6 | 6082.19 | 6079.6 | 6081.67 | 2218.0 |
| 2024-10-13 19:00:00 | ES | Futures | 6081.67 | 6083.49 | 6078.3 | 6078.82 | 2374.0 |
| 2024-10-13 19:30:00 | ES | Futures | 6079.08 | 6082.19 | 6078.04 | 6078.56 | 1770.0 |
| 2024-10-13 20:00:00 | ES | Futures | 6078.56 | 6080.37 | 6076.74 | 6078.82 | 2421.0 |
| 2024-10-13 20:30:00 | ES | Futures | 6078.82 | 6079.34 | 6077.0 | 6078.3 | 1512.0 |
| 2024-10-13 21:00:00 | ES | Futures | 6078.04 | 6078.56 | 6075.7 | 6077.26 | 2810.0 |
| 2024-10-13 21:30:00 | ES | Futures | 6077.26 | 6080.11 | 6075.96 | 6076.74 | 2675.0 |
| 2024-10-13 22:00:00 | ES | Futures | 6076.74 | 6077.0 | 6072.85 | 6076.74 | 2501.0 |
| 2024-10-13 22:30:00 | ES | Futures | 6076.74 | 6078.04 | 6075.44 | 6077.26 | 1503.0 |
| 2024-10-13 23:00:00 | ES | Futures | 6077.52 | 6079.85 | 6075.18 | 6079.85 | 1750.0 |
| 2024-10-13 23:30:00 | ES | Futures | 6079.6 | 6080.37 | 6078.3 | 6078.56 | 885.0 |
| 2024-10-13 18:00:00 | NQ | Futures | 21324.36 | 21332.19 | 21298.27 | 21326.19 | 2738.0 |
| 2024-10-13 18:30:00 | NQ | Futures | 21326.19 | 21336.11 | 21325.93 | 21332.45 | 996.0 |
| 2024-10-13 19:00:00 | NQ | Futures | 21332.45 | 21340.54 | 21320.19 | 21325.93 | 1391.0 |
| 2024-10-13 19:30:00 | NQ | Futures | 21326.45 | 21343.41 | 21314.45 | 21318.1 | 1612.0 |
| 2024-10-13 20:00:00 | NQ | Futures | 21318.88 | 21324.36 | 21304.01 | 21313.41 | 1730.0 |
| 2024-10-13 20:30:00 | NQ | Futures | 21312.88 | 21316.54 | 21301.14 | 21306.1 | 1015.0 |
| 2024-10-13 21:00:00 | NQ | Futures | 21306.1 | 21308.19 | 21291.49 | 21298.27 | 1860.0 |
| 2024-10-13 21:30:00 | NQ | Futures | 21298.79 | 21310.54 | 21284.97 | 21290.71 | 1990.0 |
| 2024-10-13 22:00:00 | NQ | Futures | 21290.45 | 21296.45 | 21272.96 | 21295.4 | 2027.0 |
| 2024-10-13 22:30:00 | NQ | Futures | 21295.92 | 21300.62 | 21289.4 | 21293.32 | 1346.0 |
| 2024-10-13 23:00:00 | NQ | Futures | 21293.58 | 21306.1 | 21280.27 | 21303.23 | 1588.0 |
| 2024-10-13 23:30:00 | NQ | Futures | 21302.71 | 21309.23 | 21296.71 | 21298.79 | 775.0 |
| 2024-10-13 18:00:00 | YM | Futures | 44866.8 | 44882.4 | 44847.1 | 44880.4 | 448.0 |
| 2024-10-13 18:30:00 | YM | Futures | 44881.4 | 44903.3 | 44879.3 | 44897.0 | 382.0 |
| 2024-10-13 19:00:00 | YM | Futures | 44894.9 | 44908.5 | 44875.2 | 44876.2 | 331.0 |
| 2024-10-13 19:30:00 | YM | Futures | 44877.2 | 44896.0 | 44871.0 | 44880.4 | 269.0 |
| 2024-10-13 20:00:00 | YM | Futures | 44879.3 | 44899.1 | 44873.1 | 44889.7 | 439.0 |
| 2024-10-13 20:30:00 | YM | Futures | 44890.8 | 44896.0 | 44882.4 | 44890.8 | 204.0 |
| 2024-10-13 21:00:00 | YM | Futures | 44887.6 | 44891.8 | 44876.2 | 44879.3 | 453.0 |
| 2024-10-13 21:30:00 | YM | Futures | 44880.4 | 44905.3 | 44875.2 | 44886.6 | 315.0 |
| 2024-10-13 22:00:00 | YM | Futures | 44883.5 | 44891.8 | 44863.7 | 44891.8 | 359.0 |
| 2024-10-13 22:30:00 | YM | Futures | 44888.7 | 44902.2 | 44884.5 | 44901.2 | 249.0 |
| 2024-10-13 23:00:00 | YM | Futures | 44902.2 | 44910.5 | 44889.7 | 44909.5 | 230.0 |
| 2024-10-13 23:30:00 | YM | Futures | 44908.5 | 44911.6 | 44900.1 | 44902.2 | 96.0 |
| 2024-10-13 18:00:00 | CL | Futures | 67.31 | 67.34 | 66.64 | 66.87 | 4598.0 |
| 2024-10-13 18:30:00 | CL | Futures | 66.88 | 66.95 | 66.68 | 66.68 | 1013.0 |
| 2024-10-13 19:00:00 | CL | Futures | 66.68 | 66.76 | 66.45 | 66.58 | 2143.0 |
| 2024-10-13 19:30:00 | CL | Futures | 66.57 | 66.65 | 66.54 | 66.56 | 471.0 |
| 2024-10-13 20:00:00 | CL | Futures | 66.57 | 66.78 | 66.44 | 66.77 | 1535.0 |
| 2024-10-13 20:30:00 | CL | Futures | 66.77 | 66.85 | 66.71 | 66.85 | 1089.0 |
| 2024-10-13 21:00:00 | CL | Futures | 66.85 | 66.9 | 66.53 | 66.75 | 4672.0 |
| 2024-10-13 21:30:00 | CL | Futures | 66.75 | 66.94 | 66.57 | 66.77 | 2331.0 |
| 2024-10-13 22:00:00 | CL | Futures | 66.77 | 66.77 | 66.55 | 66.62 | 1999.0 |
| 2024-10-13 22:30:00 | CL | Futures | 66.62 | 66.96 | 66.6 | 66.93 | 1720.0 |
| 2024-10-13 23:00:00 | CL | Futures | 66.94 | 67.04 | 66.89 | 67.02 | 1122.0 |
| 2024-10-13 23:30:00 | CL | Futures | 67.01 | 67.12 | 66.97 | 66.97 | 1125.0 |
| 2024-10-13 18:00:00 | GC | Futures | 2814.7 | 2815.4 | 2801.8 | 2808.0 | 4394.0 |
| 2024-10-13 18:30:00 | GC | Futures | 2807.8 | 2808.9 | 2807.2 | 2808.4 | 447.0 |
> showing 50 of 819 rows — these rows as CSV