PREVIEW / futures_30min / 2023-09-03
file: by_date/futures_30min/2023/2023-09-03.parquet size: 24 KB rows: 657
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-09-03 18:00:00 | ES | Futures | 4964.54 | 4967.01 | 4960.42 | 4961.24 | 2631.0 |
| 2023-09-03 18:30:00 | ES | Futures | 4960.97 | 4962.07 | 4960.42 | 4960.97 | 1108.0 |
| 2023-09-03 19:00:00 | ES | Futures | 4961.24 | 4961.24 | 4960.42 | 4960.7 | 572.0 |
| 2023-09-03 19:30:00 | ES | Futures | 4960.97 | 4963.44 | 4960.7 | 4962.89 | 1508.0 |
| 2023-09-03 20:00:00 | ES | Futures | 4962.62 | 4964.81 | 4962.07 | 4964.26 | 2386.0 |
| 2023-09-03 20:30:00 | ES | Futures | 4964.54 | 4966.73 | 4964.26 | 4966.19 | 1789.0 |
| 2023-09-03 21:00:00 | ES | Futures | 4966.19 | 4967.56 | 4963.72 | 4966.19 | 2771.0 |
| 2023-09-03 21:30:00 | ES | Futures | 4966.19 | 4966.19 | 4962.62 | 4963.72 | 2509.0 |
| 2023-09-03 22:00:00 | ES | Futures | 4963.72 | 4965.36 | 4962.62 | 4964.54 | 2807.0 |
| 2023-09-03 22:30:00 | ES | Futures | 4964.54 | 4967.56 | 4964.26 | 4967.56 | 2027.0 |
| 2023-09-03 23:00:00 | ES | Futures | 4967.56 | 4967.83 | 4965.64 | 4965.64 | 1074.0 |
| 2023-09-03 23:30:00 | ES | Futures | 4965.91 | 4966.73 | 4965.09 | 4965.36 | 932.0 |
| 2023-09-03 18:00:00 | NQ | Futures | 17263.04 | 17272.78 | 17244.69 | 17250.81 | 1843.0 |
| 2023-09-03 18:30:00 | NQ | Futures | 17250.81 | 17258.04 | 17248.86 | 17253.03 | 880.0 |
| 2023-09-03 19:00:00 | NQ | Futures | 17253.59 | 17255.53 | 17250.53 | 17253.31 | 353.0 |
| 2023-09-03 19:30:00 | NQ | Futures | 17253.59 | 17266.38 | 17252.47 | 17262.49 | 818.0 |
| 2023-09-03 20:00:00 | NQ | Futures | 17262.77 | 17267.77 | 17256.37 | 17263.88 | 1206.0 |
| 2023-09-03 20:30:00 | NQ | Futures | 17264.99 | 17276.39 | 17263.6 | 17273.33 | 1279.0 |
| 2023-09-03 21:00:00 | NQ | Futures | 17273.89 | 17284.74 | 17263.04 | 17278.06 | 1770.0 |
| 2023-09-03 21:30:00 | NQ | Futures | 17278.06 | 17278.06 | 17261.65 | 17268.61 | 1307.0 |
| 2023-09-03 22:00:00 | NQ | Futures | 17267.77 | 17281.4 | 17265.82 | 17278.9 | 1238.0 |
| 2023-09-03 22:30:00 | NQ | Futures | 17278.62 | 17289.47 | 17277.78 | 17288.35 | 1333.0 |
| 2023-09-03 23:00:00 | NQ | Futures | 17288.63 | 17291.69 | 17280.84 | 17281.4 | 997.0 |
| 2023-09-03 23:30:00 | NQ | Futures | 17281.68 | 17285.85 | 17279.18 | 17281.4 | 533.0 |
| 2023-09-03 18:00:00 | YM | Futures | 38200.6 | 38223.6 | 38176.5 | 38180.8 | 416.0 |
| 2023-09-03 18:30:00 | YM | Futures | 38183.0 | 38189.6 | 38179.8 | 38186.3 | 117.0 |
| 2023-09-03 19:00:00 | YM | Futures | 38188.5 | 38188.5 | 38179.8 | 38181.9 | 106.0 |
| 2023-09-03 19:30:00 | YM | Futures | 38183.0 | 38201.7 | 38178.7 | 38199.5 | 240.0 |
| 2023-09-03 20:00:00 | YM | Futures | 38199.5 | 38215.9 | 38198.4 | 38212.6 | 293.0 |
| 2023-09-03 20:30:00 | YM | Futures | 38213.7 | 38223.6 | 38213.7 | 38219.2 | 189.0 |
| 2023-09-03 21:00:00 | YM | Futures | 38221.4 | 38226.9 | 38206.0 | 38221.4 | 318.0 |
| 2023-09-03 21:30:00 | YM | Futures | 38221.4 | 38221.4 | 38198.4 | 38204.9 | 160.0 |
| 2023-09-03 22:00:00 | YM | Futures | 38204.9 | 38211.5 | 38195.1 | 38203.9 | 293.0 |
| 2023-09-03 22:30:00 | YM | Futures | 38202.8 | 38221.4 | 38200.6 | 38220.3 | 223.0 |
| 2023-09-03 23:00:00 | YM | Futures | 38221.4 | 38225.8 | 38215.9 | 38217.0 | 158.0 |
| 2023-09-03 23:30:00 | YM | Futures | 38218.1 | 38221.4 | 38211.5 | 38213.7 | 159.0 |
| 2023-09-03 18:00:00 | CL | Futures | 70.53 | 70.55 | 70.26 | 70.35 | 1007.0 |
| 2023-09-03 18:30:00 | CL | Futures | 70.34 | 70.5 | 70.3 | 70.43 | 802.0 |
| 2023-09-03 19:00:00 | CL | Futures | 70.41 | 70.43 | 70.34 | 70.37 | 552.0 |
| 2023-09-03 19:30:00 | CL | Futures | 70.37 | 70.42 | 70.34 | 70.35 | 352.0 |
| 2023-09-03 20:00:00 | CL | Futures | 70.34 | 70.37 | 70.25 | 70.32 | 1029.0 |
| 2023-09-03 20:30:00 | CL | Futures | 70.32 | 70.43 | 70.31 | 70.37 | 935.0 |
| 2023-09-03 21:00:00 | CL | Futures | 70.37 | 70.39 | 70.21 | 70.28 | 2111.0 |
| 2023-09-03 21:30:00 | CL | Futures | 70.29 | 70.31 | 70.16 | 70.19 | 1502.0 |
| 2023-09-03 22:00:00 | CL | Futures | 70.18 | 70.25 | 70.18 | 70.21 | 696.0 |
| 2023-09-03 22:30:00 | CL | Futures | 70.2 | 70.25 | 70.19 | 70.2 | 726.0 |
| 2023-09-03 23:00:00 | CL | Futures | 70.2 | 70.2 | 70.15 | 70.18 | 744.0 |
| 2023-09-03 23:30:00 | CL | Futures | 70.17 | 70.21 | 70.17 | 70.18 | 405.0 |
| 2023-09-03 18:00:00 | GC | Futures | 2196.7 | 2197.1 | 2195.4 | 2195.6 | 461.0 |
| 2023-09-03 18:30:00 | GC | Futures | 2195.6 | 2196.4 | 2195.2 | 2195.5 | 365.0 |
> showing 50 of 657 rows — these rows as CSV