PREVIEW / futures_30min / 2024-05-19
file: by_date/futures_30min/2024/2024-05-19.parquet size: 27 KB rows: 782
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-05-19 18:00:00 | ES | Futures | 5655.31 | 5660.61 | 5655.04 | 5659.55 | 4311.0 |
| 2024-05-19 18:30:00 | ES | Futures | 5659.55 | 5659.82 | 5657.96 | 5658.76 | 1940.0 |
| 2024-05-19 19:00:00 | ES | Futures | 5658.76 | 5661.41 | 5658.76 | 5661.15 | 1668.0 |
| 2024-05-19 19:30:00 | ES | Futures | 5661.15 | 5663.0 | 5660.61 | 5661.68 | 2228.0 |
| 2024-05-19 20:00:00 | ES | Futures | 5661.94 | 5662.21 | 5658.49 | 5660.88 | 3541.0 |
| 2024-05-19 20:30:00 | ES | Futures | 5661.15 | 5662.74 | 5660.61 | 5661.41 | 2299.0 |
| 2024-05-19 21:00:00 | ES | Futures | 5661.15 | 5661.94 | 5660.08 | 5660.08 | 2397.0 |
| 2024-05-19 21:30:00 | ES | Futures | 5660.35 | 5661.15 | 5659.82 | 5660.35 | 1644.0 |
| 2024-05-19 22:00:00 | ES | Futures | 5660.61 | 5660.88 | 5658.76 | 5660.88 | 1975.0 |
| 2024-05-19 22:30:00 | ES | Futures | 5660.61 | 5662.47 | 5660.35 | 5661.94 | 2237.0 |
| 2024-05-19 23:00:00 | ES | Futures | 5662.21 | 5662.74 | 5661.15 | 5662.21 | 1826.0 |
| 2024-05-19 23:30:00 | ES | Futures | 5662.21 | 5662.21 | 5660.35 | 5660.61 | 1322.0 |
| 2024-05-19 18:00:00 | NQ | Futures | 19938.15 | 19964.63 | 19937.61 | 19961.95 | 2117.0 |
| 2024-05-19 18:30:00 | NQ | Futures | 19961.95 | 19962.76 | 19956.34 | 19960.08 | 878.0 |
| 2024-05-19 19:00:00 | NQ | Futures | 19960.35 | 19970.25 | 19959.01 | 19969.98 | 1034.0 |
| 2024-05-19 19:30:00 | NQ | Futures | 19969.44 | 19978.54 | 19968.64 | 19973.72 | 1144.0 |
| 2024-05-19 20:00:00 | NQ | Futures | 19974.79 | 19976.67 | 19964.9 | 19975.06 | 1715.0 |
| 2024-05-19 20:30:00 | NQ | Futures | 19975.6 | 19980.14 | 19972.12 | 19973.46 | 1182.0 |
| 2024-05-19 21:00:00 | NQ | Futures | 19972.65 | 19978.54 | 19966.77 | 19971.58 | 1608.0 |
| 2024-05-19 21:30:00 | NQ | Futures | 19970.78 | 19975.6 | 19967.84 | 19972.65 | 1074.0 |
| 2024-05-19 22:00:00 | NQ | Futures | 19971.58 | 19974.26 | 19965.43 | 19974.26 | 991.0 |
| 2024-05-19 22:30:00 | NQ | Futures | 19973.99 | 19984.16 | 19972.92 | 19981.75 | 1553.0 |
| 2024-05-19 23:00:00 | NQ | Futures | 19981.75 | 19987.1 | 19978.81 | 19983.62 | 1214.0 |
| 2024-05-19 23:30:00 | NQ | Futures | 19982.82 | 19983.62 | 19975.86 | 19976.93 | 999.0 |
| 2024-05-19 18:00:00 | YM | Futures | 42609.3 | 42659.2 | 42609.3 | 42650.7 | 699.0 |
| 2024-05-19 18:30:00 | YM | Futures | 42651.8 | 42652.8 | 42638.0 | 42642.2 | 257.0 |
| 2024-05-19 19:00:00 | YM | Futures | 42641.2 | 42662.4 | 42640.1 | 42662.4 | 237.0 |
| 2024-05-19 19:30:00 | YM | Futures | 42661.3 | 42664.5 | 42655.0 | 42659.2 | 246.0 |
| 2024-05-19 20:00:00 | YM | Futures | 42659.2 | 42660.3 | 42636.9 | 42656.0 | 412.0 |
| 2024-05-19 20:30:00 | YM | Futures | 42656.0 | 42667.7 | 42651.8 | 42663.4 | 293.0 |
| 2024-05-19 21:00:00 | YM | Futures | 42661.3 | 42674.1 | 42653.9 | 42655.0 | 502.0 |
| 2024-05-19 21:30:00 | YM | Futures | 42656.0 | 42659.2 | 42651.8 | 42658.1 | 212.0 |
| 2024-05-19 22:00:00 | YM | Futures | 42658.1 | 42660.3 | 42648.6 | 42658.1 | 194.0 |
| 2024-05-19 22:30:00 | YM | Futures | 42659.2 | 42664.5 | 42656.0 | 42661.3 | 280.0 |
| 2024-05-19 23:00:00 | YM | Futures | 42660.3 | 42662.4 | 42653.9 | 42659.2 | 234.0 |
| 2024-05-19 23:30:00 | YM | Futures | 42659.2 | 42660.3 | 42647.5 | 42649.6 | 155.0 |
| 2024-05-19 18:00:00 | CL | Futures | 67.76 | 67.86 | 67.69 | 67.82 | 2575.0 |
| 2024-05-19 18:30:00 | CL | Futures | 67.82 | 67.88 | 67.7 | 67.71 | 843.0 |
| 2024-05-19 19:00:00 | CL | Futures | 67.71 | 67.74 | 67.61 | 67.64 | 719.0 |
| 2024-05-19 19:30:00 | CL | Futures | 67.63 | 67.65 | 67.54 | 67.57 | 395.0 |
| 2024-05-19 20:00:00 | CL | Futures | 67.56 | 67.66 | 67.49 | 67.65 | 884.0 |
| 2024-05-19 20:30:00 | CL | Futures | 67.65 | 67.74 | 67.57 | 67.74 | 1187.0 |
| 2024-05-19 21:00:00 | CL | Futures | 67.74 | 67.85 | 67.59 | 67.84 | 2981.0 |
| 2024-05-19 21:30:00 | CL | Futures | 67.84 | 67.96 | 67.79 | 67.85 | 2068.0 |
| 2024-05-19 22:00:00 | CL | Futures | 67.85 | 67.95 | 67.83 | 67.89 | 799.0 |
| 2024-05-19 22:30:00 | CL | Futures | 67.88 | 67.97 | 67.77 | 67.78 | 1443.0 |
| 2024-05-19 23:00:00 | CL | Futures | 67.78 | 67.8 | 67.71 | 67.77 | 1175.0 |
| 2024-05-19 23:30:00 | CL | Futures | 67.77 | 67.85 | 67.76 | 67.83 | 501.0 |
| 2024-05-19 18:00:00 | GC | Futures | 2628.5 | 2636.7 | 2627.8 | 2632.2 | 3983.0 |
| 2024-05-19 18:30:00 | GC | Futures | 2632.0 | 2632.0 | 2627.4 | 2628.5 | 1442.0 |
> showing 50 of 782 rows — these rows as CSV