PREVIEW / futures_30min / 2023-06-25
file: by_date/futures_30min/2023/2023-06-25.parquet size: 27 KB rows: 773
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-06-25 18:00:00 | ES | Futures | 4820.42 | 4826.18 | 4817.68 | 4824.26 | 6473.0 |
| 2023-06-25 18:30:00 | ES | Futures | 4824.54 | 4828.93 | 4823.44 | 4828.38 | 2924.0 |
| 2023-06-25 19:00:00 | ES | Futures | 4828.38 | 4830.3 | 4827.28 | 4829.75 | 2464.0 |
| 2023-06-25 19:30:00 | ES | Futures | 4830.03 | 4830.03 | 4827.01 | 4828.93 | 2635.0 |
| 2023-06-25 20:00:00 | ES | Futures | 4829.2 | 4829.48 | 4823.99 | 4827.83 | 6166.0 |
| 2023-06-25 20:30:00 | ES | Futures | 4827.83 | 4828.93 | 4825.91 | 4828.38 | 3388.0 |
| 2023-06-25 21:00:00 | ES | Futures | 4828.11 | 4829.2 | 4824.26 | 4828.66 | 4563.0 |
| 2023-06-25 21:30:00 | ES | Futures | 4828.93 | 4832.22 | 4828.66 | 4828.93 | 5894.0 |
| 2023-06-25 22:00:00 | ES | Futures | 4828.93 | 4830.85 | 4828.66 | 4829.75 | 3129.0 |
| 2023-06-25 22:30:00 | ES | Futures | 4829.75 | 4831.95 | 4829.48 | 4831.13 | 1928.0 |
| 2023-06-25 23:00:00 | ES | Futures | 4831.13 | 4833.87 | 4831.13 | 4833.6 | 3518.0 |
| 2023-06-25 23:30:00 | ES | Futures | 4833.6 | 4833.6 | 4830.58 | 4831.68 | 2735.0 |
| 2023-06-25 18:00:00 | NQ | Futures | 16752.12 | 16785.21 | 16748.22 | 16776.59 | 3457.0 |
| 2023-06-25 18:30:00 | NQ | Futures | 16776.87 | 16798.84 | 16771.59 | 16797.17 | 2104.0 |
| 2023-06-25 19:00:00 | NQ | Futures | 16797.73 | 16803.85 | 16785.21 | 16801.07 | 1732.0 |
| 2023-06-25 19:30:00 | NQ | Futures | 16801.35 | 16801.9 | 16789.39 | 16799.4 | 1523.0 |
| 2023-06-25 20:00:00 | NQ | Futures | 16799.68 | 16801.07 | 16780.76 | 16793.28 | 2769.0 |
| 2023-06-25 20:30:00 | NQ | Futures | 16793.0 | 16796.34 | 16783.55 | 16791.06 | 1515.0 |
| 2023-06-25 21:00:00 | NQ | Futures | 16791.33 | 16791.61 | 16771.59 | 16790.78 | 2432.0 |
| 2023-06-25 21:30:00 | NQ | Futures | 16791.33 | 16811.64 | 16790.5 | 16798.29 | 3163.0 |
| 2023-06-25 22:00:00 | NQ | Futures | 16797.45 | 16804.96 | 16796.62 | 16800.51 | 1483.0 |
| 2023-06-25 22:30:00 | NQ | Futures | 16800.51 | 16808.58 | 16799.12 | 16804.96 | 885.0 |
| 2023-06-25 23:00:00 | NQ | Futures | 16805.24 | 16814.7 | 16804.13 | 16811.36 | 1507.0 |
| 2023-06-25 23:30:00 | NQ | Futures | 16811.64 | 16811.64 | 16796.9 | 16801.07 | 1352.0 |
| 2023-06-25 18:00:00 | YM | Futures | 37223.3 | 37270.4 | 37199.2 | 37257.3 | 921.0 |
| 2023-06-25 18:30:00 | YM | Futures | 37256.2 | 37289.1 | 37254.0 | 37283.6 | 501.0 |
| 2023-06-25 19:00:00 | YM | Futures | 37284.7 | 37301.1 | 37277.0 | 37297.8 | 418.0 |
| 2023-06-25 19:30:00 | YM | Futures | 37296.7 | 37297.8 | 37277.0 | 37288.0 | 407.0 |
| 2023-06-25 20:00:00 | YM | Futures | 37286.9 | 37292.4 | 37256.2 | 37279.2 | 672.0 |
| 2023-06-25 20:30:00 | YM | Futures | 37278.1 | 37286.9 | 37267.2 | 37283.6 | 345.0 |
| 2023-06-25 21:00:00 | YM | Futures | 37284.7 | 37294.6 | 37265.0 | 37288.0 | 518.0 |
| 2023-06-25 21:30:00 | YM | Futures | 37290.2 | 37311.0 | 37286.9 | 37291.3 | 527.0 |
| 2023-06-25 22:00:00 | YM | Futures | 37289.1 | 37296.7 | 37284.7 | 37289.1 | 184.0 |
| 2023-06-25 22:30:00 | YM | Futures | 37289.1 | 37301.1 | 37285.8 | 37295.6 | 200.0 |
| 2023-06-25 23:00:00 | YM | Futures | 37296.7 | 37316.5 | 37295.6 | 37314.3 | 441.0 |
| 2023-06-25 23:30:00 | YM | Futures | 37315.4 | 37316.5 | 37298.9 | 37302.2 | 199.0 |
| 2023-06-25 18:00:00 | CL | Futures | 56.67 | 56.89 | 56.32 | 56.76 | 3496.0 |
| 2023-06-25 18:30:00 | CL | Futures | 56.76 | 56.84 | 56.68 | 56.83 | 1258.0 |
| 2023-06-25 19:00:00 | CL | Futures | 56.84 | 56.84 | 56.75 | 56.8 | 643.0 |
| 2023-06-25 19:30:00 | CL | Futures | 56.79 | 56.81 | 56.74 | 56.75 | 493.0 |
| 2023-06-25 20:00:00 | CL | Futures | 56.77 | 56.8 | 56.55 | 56.62 | 1238.0 |
| 2023-06-25 20:30:00 | CL | Futures | 56.62 | 56.71 | 56.58 | 56.69 | 706.0 |
| 2023-06-25 21:00:00 | CL | Futures | 56.68 | 56.69 | 56.41 | 56.43 | 4036.0 |
| 2023-06-25 21:30:00 | CL | Futures | 56.43 | 56.5 | 56.26 | 56.27 | 3525.0 |
| 2023-06-25 22:00:00 | CL | Futures | 56.27 | 56.45 | 56.25 | 56.38 | 2019.0 |
| 2023-06-25 22:30:00 | CL | Futures | 56.37 | 56.38 | 56.24 | 56.26 | 1313.0 |
| 2023-06-25 23:00:00 | CL | Futures | 56.26 | 56.28 | 56.0 | 56.13 | 3185.0 |
| 2023-06-25 23:30:00 | CL | Futures | 56.14 | 56.14 | 56.07 | 56.13 | 838.0 |
| 2023-06-25 18:00:00 | GC | Futures | 2205.7 | 2205.8 | 2201.7 | 2202.2 | 1899.0 |
| 2023-06-25 18:30:00 | GC | Futures | 2202.2 | 2204.1 | 2201.1 | 2203.6 | 1521.0 |
> showing 50 of 773 rows — these rows as CSV