PREVIEW / futures_30min / 2024-04-07
file: by_date/futures_30min/2024/2024-04-07.parquet size: 30 KB rows: 820
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-04-07 18:00:00 | ES | Futures | 5585.27 | 5591.64 | 5578.9 | 5579.7 | 8019.0 |
| 2024-04-07 18:30:00 | ES | Futures | 5579.7 | 5580.23 | 5577.05 | 5578.37 | 2316.0 |
| 2024-04-07 19:00:00 | ES | Futures | 5578.11 | 5581.29 | 5577.84 | 5580.76 | 3717.0 |
| 2024-04-07 19:30:00 | ES | Futures | 5580.76 | 5581.82 | 5578.11 | 5580.5 | 3439.0 |
| 2024-04-07 20:00:00 | ES | Futures | 5581.03 | 5581.29 | 5571.74 | 5572.01 | 5946.0 |
| 2024-04-07 20:30:00 | ES | Futures | 5571.74 | 5575.99 | 5570.41 | 5575.99 | 5357.0 |
| 2024-04-07 21:00:00 | ES | Futures | 5575.99 | 5578.9 | 5574.39 | 5577.05 | 5131.0 |
| 2024-04-07 21:30:00 | ES | Futures | 5576.78 | 5579.7 | 5574.92 | 5576.78 | 4939.0 |
| 2024-04-07 22:00:00 | ES | Futures | 5576.78 | 5577.58 | 5574.92 | 5576.25 | 2873.0 |
| 2024-04-07 22:30:00 | ES | Futures | 5575.99 | 5576.78 | 5574.92 | 5576.78 | 2127.0 |
| 2024-04-07 23:00:00 | ES | Futures | 5576.78 | 5577.05 | 5568.29 | 5568.82 | 4677.0 |
| 2024-04-07 23:30:00 | ES | Futures | 5568.82 | 5569.62 | 5564.58 | 5567.5 | 4838.0 |
| 2024-04-07 18:00:00 | NQ | Futures | 19632.92 | 19658.6 | 19591.73 | 19596.54 | 4541.0 |
| 2024-04-07 18:30:00 | NQ | Futures | 19597.35 | 19600.29 | 19587.18 | 19593.6 | 1558.0 |
| 2024-04-07 19:00:00 | NQ | Futures | 19592.8 | 19609.12 | 19591.73 | 19602.96 | 1748.0 |
| 2024-04-07 19:30:00 | NQ | Futures | 19602.96 | 19608.58 | 19591.73 | 19601.09 | 1427.0 |
| 2024-04-07 20:00:00 | NQ | Futures | 19602.16 | 19604.03 | 19566.05 | 19566.05 | 2978.0 |
| 2024-04-07 20:30:00 | NQ | Futures | 19566.05 | 19597.35 | 19563.91 | 19597.08 | 2605.0 |
| 2024-04-07 21:00:00 | NQ | Futures | 19597.35 | 19612.86 | 19589.59 | 19604.57 | 2731.0 |
| 2024-04-07 21:30:00 | NQ | Futures | 19606.17 | 19617.68 | 19597.08 | 19606.44 | 3309.0 |
| 2024-04-07 22:00:00 | NQ | Futures | 19606.71 | 19610.72 | 19598.42 | 19604.84 | 1631.0 |
| 2024-04-07 22:30:00 | NQ | Futures | 19605.64 | 19609.65 | 19601.09 | 19609.12 | 850.0 |
| 2024-04-07 23:00:00 | NQ | Futures | 19609.38 | 19609.92 | 19571.4 | 19573.0 | 1657.0 |
| 2024-04-07 23:30:00 | NQ | Futures | 19572.47 | 19576.48 | 19549.46 | 19565.78 | 2726.0 |
| 2024-04-07 18:00:00 | YM | Futures | 41703.7 | 41771.6 | 41703.7 | 41724.9 | 1875.0 |
| 2024-04-07 18:30:00 | YM | Futures | 41726.0 | 41727.0 | 41697.3 | 41701.5 | 302.0 |
| 2024-04-07 19:00:00 | YM | Futures | 41700.5 | 41718.5 | 41699.4 | 41715.3 | 323.0 |
| 2024-04-07 19:30:00 | YM | Futures | 41716.4 | 41722.8 | 41696.2 | 41704.7 | 376.0 |
| 2024-04-07 20:00:00 | YM | Futures | 41709.0 | 41711.1 | 41650.6 | 41652.7 | 647.0 |
| 2024-04-07 20:30:00 | YM | Futures | 41652.7 | 41670.8 | 41637.8 | 41669.7 | 499.0 |
| 2024-04-07 21:00:00 | YM | Futures | 41669.7 | 41681.4 | 41658.0 | 41671.8 | 565.0 |
| 2024-04-07 21:30:00 | YM | Futures | 41672.9 | 41689.9 | 41663.3 | 41671.8 | 616.0 |
| 2024-04-07 22:00:00 | YM | Futures | 41673.9 | 41676.1 | 41660.1 | 41670.8 | 347.0 |
| 2024-04-07 22:30:00 | YM | Futures | 41670.8 | 41673.9 | 41659.1 | 41668.6 | 335.0 |
| 2024-04-07 23:00:00 | YM | Futures | 41668.6 | 41670.8 | 41617.7 | 41620.9 | 656.0 |
| 2024-04-07 23:30:00 | YM | Futures | 41621.9 | 41626.2 | 41597.5 | 41614.5 | 696.0 |
| 2024-04-07 18:00:00 | CL | Futures | 72.44 | 72.58 | 72.19 | 72.5 | 4526.0 |
| 2024-04-07 18:30:00 | CL | Futures | 72.5 | 72.52 | 72.32 | 72.38 | 1303.0 |
| 2024-04-07 19:00:00 | CL | Futures | 72.38 | 72.43 | 72.34 | 72.35 | 722.0 |
| 2024-04-07 19:30:00 | CL | Futures | 72.35 | 72.38 | 72.21 | 72.28 | 1568.0 |
| 2024-04-07 20:00:00 | CL | Futures | 72.27 | 72.28 | 71.84 | 71.85 | 3653.0 |
| 2024-04-07 20:30:00 | CL | Futures | 71.84 | 71.89 | 71.71 | 71.75 | 2545.0 |
| 2024-04-07 21:00:00 | CL | Futures | 71.75 | 71.75 | 71.26 | 71.48 | 7089.0 |
| 2024-04-07 21:30:00 | CL | Futures | 71.47 | 71.91 | 71.38 | 71.88 | 4615.0 |
| 2024-04-07 22:00:00 | CL | Futures | 71.89 | 72.04 | 71.85 | 72.01 | 2472.0 |
| 2024-04-07 22:30:00 | CL | Futures | 72.01 | 72.18 | 72.0 | 72.08 | 2613.0 |
| 2024-04-07 23:00:00 | CL | Futures | 72.09 | 72.12 | 71.99 | 72.01 | 1379.0 |
| 2024-04-07 23:30:00 | CL | Futures | 72.01 | 72.07 | 71.96 | 72.01 | 1203.0 |
| 2024-04-07 18:00:00 | GC | Futures | 2543.2 | 2548.1 | 2520.9 | 2527.8 | 9463.0 |
| 2024-04-07 18:30:00 | GC | Futures | 2527.8 | 2529.5 | 2523.0 | 2524.8 | 3188.0 |
> showing 50 of 820 rows — these rows as CSV