PREVIEW / futures_30min / 2023-08-13
file: by_date/futures_30min/2023/2023-08-13.parquet size: 29 KB rows: 796
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-08-13 18:00:00 | ES | Futures | 4924.73 | 4931.87 | 4922.54 | 4931.32 | 6588.0 |
| 2023-08-13 18:30:00 | ES | Futures | 4931.32 | 4931.6 | 4928.85 | 4929.68 | 1787.0 |
| 2023-08-13 19:00:00 | ES | Futures | 4929.68 | 4931.6 | 4927.48 | 4930.5 | 1921.0 |
| 2023-08-13 19:30:00 | ES | Futures | 4930.5 | 4931.05 | 4928.58 | 4929.13 | 1429.0 |
| 2023-08-13 20:00:00 | ES | Futures | 4929.4 | 4930.77 | 4926.93 | 4929.95 | 5645.0 |
| 2023-08-13 20:30:00 | ES | Futures | 4929.95 | 4930.22 | 4921.71 | 4922.54 | 4597.0 |
| 2023-08-13 21:00:00 | ES | Futures | 4922.54 | 4924.73 | 4916.5 | 4920.62 | 6354.0 |
| 2023-08-13 21:30:00 | ES | Futures | 4920.34 | 4922.26 | 4914.03 | 4919.24 | 8479.0 |
| 2023-08-13 22:00:00 | ES | Futures | 4919.24 | 4919.52 | 4909.64 | 4910.46 | 8607.0 |
| 2023-08-13 22:30:00 | ES | Futures | 4910.46 | 4913.75 | 4908.54 | 4909.64 | 4222.0 |
| 2023-08-13 23:00:00 | ES | Futures | 4909.36 | 4911.56 | 4907.44 | 4909.36 | 6640.0 |
| 2023-08-13 23:30:00 | ES | Futures | 4909.36 | 4909.91 | 4902.77 | 4909.09 | 6008.0 |
| 2023-08-13 18:00:00 | NQ | Futures | 16803.57 | 16850.58 | 16799.4 | 16847.52 | 4285.0 |
| 2023-08-13 18:30:00 | NQ | Futures | 16848.07 | 16850.3 | 16838.06 | 16842.51 | 1416.0 |
| 2023-08-13 19:00:00 | NQ | Futures | 16842.51 | 16848.63 | 16832.77 | 16843.07 | 1564.0 |
| 2023-08-13 19:30:00 | NQ | Futures | 16844.18 | 16846.4 | 16838.06 | 16841.4 | 802.0 |
| 2023-08-13 20:00:00 | NQ | Futures | 16841.4 | 16853.63 | 16832.5 | 16847.52 | 3363.0 |
| 2023-08-13 20:30:00 | NQ | Futures | 16847.79 | 16849.74 | 16809.97 | 16812.75 | 3131.0 |
| 2023-08-13 21:00:00 | NQ | Futures | 16812.47 | 16820.26 | 16776.31 | 16798.01 | 4225.0 |
| 2023-08-13 21:30:00 | NQ | Futures | 16797.45 | 16804.96 | 16764.63 | 16791.89 | 4955.0 |
| 2023-08-13 22:00:00 | NQ | Futures | 16791.89 | 16793.84 | 16747.94 | 16750.73 | 5127.0 |
| 2023-08-13 22:30:00 | NQ | Futures | 16750.17 | 16761.3 | 16737.65 | 16741.83 | 3852.0 |
| 2023-08-13 23:00:00 | NQ | Futures | 16741.27 | 16751.28 | 16732.37 | 16746.83 | 3699.0 |
| 2023-08-13 23:30:00 | NQ | Futures | 16747.11 | 16751.28 | 16710.95 | 16744.05 | 4115.0 |
| 2023-08-13 18:00:00 | YM | Futures | 38772.4 | 38799.8 | 38749.4 | 38780.1 | 812.0 |
| 2023-08-13 18:30:00 | YM | Futures | 38781.2 | 38782.3 | 38770.2 | 38771.3 | 312.0 |
| 2023-08-13 19:00:00 | YM | Futures | 38770.2 | 38788.9 | 38754.9 | 38772.4 | 629.0 |
| 2023-08-13 19:30:00 | YM | Futures | 38773.5 | 38779.0 | 38761.5 | 38770.2 | 307.0 |
| 2023-08-13 20:00:00 | YM | Futures | 38770.2 | 38784.5 | 38754.9 | 38781.2 | 778.0 |
| 2023-08-13 20:30:00 | YM | Futures | 38781.2 | 38784.5 | 38726.4 | 38735.2 | 695.0 |
| 2023-08-13 21:00:00 | YM | Futures | 38734.1 | 38751.6 | 38702.3 | 38729.7 | 855.0 |
| 2023-08-13 21:30:00 | YM | Futures | 38729.7 | 38736.3 | 38684.8 | 38716.6 | 1108.0 |
| 2023-08-13 22:00:00 | YM | Futures | 38716.6 | 38719.9 | 38651.9 | 38658.5 | 960.0 |
| 2023-08-13 22:30:00 | YM | Futures | 38657.4 | 38678.2 | 38646.5 | 38653.0 | 577.0 |
| 2023-08-13 23:00:00 | YM | Futures | 38651.9 | 38669.5 | 38639.9 | 38650.8 | 910.0 |
| 2023-08-13 23:30:00 | YM | Futures | 38649.7 | 38653.0 | 38603.7 | 38647.5 | 1040.0 |
| 2023-08-13 18:00:00 | CL | Futures | 67.57 | 67.58 | 67.34 | 67.35 | 1507.0 |
| 2023-08-13 18:30:00 | CL | Futures | 67.36 | 67.44 | 67.32 | 67.33 | 656.0 |
| 2023-08-13 19:00:00 | CL | Futures | 67.33 | 67.35 | 67.29 | 67.31 | 429.0 |
| 2023-08-13 19:30:00 | CL | Futures | 67.31 | 67.43 | 67.29 | 67.41 | 584.0 |
| 2023-08-13 20:00:00 | CL | Futures | 67.42 | 67.48 | 67.39 | 67.48 | 686.0 |
| 2023-08-13 20:30:00 | CL | Futures | 67.47 | 67.48 | 67.39 | 67.42 | 482.0 |
| 2023-08-13 21:00:00 | CL | Futures | 67.4 | 67.44 | 67.3 | 67.41 | 1446.0 |
| 2023-08-13 21:30:00 | CL | Futures | 67.42 | 67.57 | 67.36 | 67.53 | 1472.0 |
| 2023-08-13 22:00:00 | CL | Futures | 67.53 | 67.57 | 67.31 | 67.34 | 1300.0 |
| 2023-08-13 22:30:00 | CL | Futures | 67.34 | 67.39 | 67.17 | 67.18 | 1481.0 |
| 2023-08-13 23:00:00 | CL | Futures | 67.18 | 67.18 | 67.02 | 67.06 | 2119.0 |
| 2023-08-13 23:30:00 | CL | Futures | 67.07 | 67.1 | 67.05 | 67.07 | 805.0 |
| 2023-08-13 18:00:00 | GC | Futures | 2173.2 | 2174.7 | 2172.2 | 2174.3 | 1047.0 |
| 2023-08-13 18:30:00 | GC | Futures | 2174.2 | 2174.3 | 2172.9 | 2173.2 | 358.0 |
> showing 50 of 796 rows — these rows as CSV