PREVIEW / futures_1hour / 2021-04-04
file: by_date/futures_1hour/2021/2021-04-04.parquet size: 16 KB rows: 330
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-04 18:00:00 | ES | Futures | 4529.23 | 4532.04 | 4520.8 | 4523.33 | 12580.0 |
| 2021-04-04 19:00:00 | ES | Futures | 4523.33 | 4533.44 | 4522.76 | 4532.04 | 7214.0 |
| 2021-04-04 20:00:00 | ES | Futures | 4532.04 | 4532.32 | 4527.82 | 4530.63 | 7725.0 |
| 2021-04-04 21:00:00 | ES | Futures | 4530.35 | 4530.63 | 4527.54 | 4528.94 | 4007.0 |
| 2021-04-04 22:00:00 | ES | Futures | 4528.94 | 4530.07 | 4525.01 | 4525.01 | 4729.0 |
| 2021-04-04 23:00:00 | ES | Futures | 4525.01 | 4526.98 | 4524.73 | 4526.42 | 2579.0 |
| 2021-04-04 18:00:00 | NQ | Futures | 15446.31 | 15459.05 | 15406.07 | 15426.62 | 8550.0 |
| 2021-04-04 19:00:00 | NQ | Futures | 15425.76 | 15466.0 | 15419.39 | 15460.79 | 3968.0 |
| 2021-04-04 20:00:00 | NQ | Futures | 15460.79 | 15461.36 | 15437.34 | 15450.07 | 3748.0 |
| 2021-04-04 21:00:00 | NQ | Futures | 15449.78 | 15454.42 | 15443.99 | 15449.49 | 1611.0 |
| 2021-04-04 22:00:00 | NQ | Futures | 15449.21 | 15455.57 | 15421.99 | 15424.89 | 3443.0 |
| 2021-04-04 23:00:00 | NQ | Futures | 15424.89 | 15435.6 | 15424.89 | 15432.41 | 1762.0 |
| 2021-04-04 18:00:00 | YM | Futures | 37018.9 | 37052.3 | 36930.9 | 36953.2 | 2723.0 |
| 2021-04-04 19:00:00 | YM | Futures | 36953.2 | 37042.3 | 36953.2 | 37021.1 | 1999.0 |
| 2021-04-04 20:00:00 | YM | Futures | 37021.1 | 37040.0 | 36997.7 | 37032.2 | 1883.0 |
| 2021-04-04 21:00:00 | YM | Futures | 37031.1 | 37037.8 | 37013.3 | 37037.8 | 1193.0 |
| 2021-04-04 22:00:00 | YM | Futures | 37036.7 | 37048.9 | 37022.2 | 37025.6 | 1163.0 |
| 2021-04-04 23:00:00 | YM | Futures | 37025.6 | 37047.8 | 37024.4 | 37044.5 | 689.0 |
| 2021-04-04 18:00:00 | CL | Futures | 41.71 | 41.71 | 41.28 | 41.52 | 5001.0 |
| 2021-04-04 19:00:00 | CL | Futures | 41.52 | 41.65 | 41.52 | 41.56 | 2027.0 |
| 2021-04-04 20:00:00 | CL | Futures | 41.56 | 41.63 | 41.36 | 41.56 | 4941.0 |
| 2021-04-04 21:00:00 | CL | Futures | 41.55 | 41.59 | 41.42 | 41.47 | 2750.0 |
| 2021-04-04 22:00:00 | CL | Futures | 41.47 | 41.51 | 41.37 | 41.44 | 2467.0 |
| 2021-04-04 23:00:00 | CL | Futures | 41.44 | 41.45 | 41.3 | 41.3 | 1710.0 |
| 2021-04-04 18:00:00 | GC | Futures | 2089.9 | 2090.3 | 2086.9 | 2088.5 | 2090.0 |
| 2021-04-04 19:00:00 | GC | Futures | 2088.6 | 2090.3 | 2087.1 | 2088.7 | 1309.0 |
| 2021-04-04 20:00:00 | GC | Futures | 2088.7 | 2089.2 | 2086.9 | 2088.5 | 1152.0 |
| 2021-04-04 21:00:00 | GC | Futures | 2088.5 | 2090.9 | 2088.2 | 2088.3 | 1468.0 |
| 2021-04-04 22:00:00 | GC | Futures | 2088.2 | 2089.3 | 2084.2 | 2085.3 | 2083.0 |
| 2021-04-04 23:00:00 | GC | Futures | 2085.3 | 2086.0 | 2084.1 | 2084.7 | 1110.0 |
| 2021-04-04 18:00:00 | ZN | Futures | 132.28584 | 132.44368 | 132.238488 | 132.380544 | 19040.0 |
| 2021-04-04 19:00:00 | ZN | Futures | 132.36476 | 132.475248 | 132.36476 | 132.427896 | 7657.0 |
| 2021-04-04 20:00:00 | ZN | Futures | 132.427896 | 132.475248 | 132.36476 | 132.380544 | 9750.0 |
| 2021-04-04 21:00:00 | ZN | Futures | 132.380544 | 132.427896 | 132.36476 | 132.36476 | 6153.0 |
| 2021-04-04 22:00:00 | ZN | Futures | 132.36476 | 132.380544 | 132.28584 | 132.301624 | 18521.0 |
| 2021-04-04 23:00:00 | ZN | Futures | 132.301624 | 132.36476 | 132.301624 | 132.348976 | 4992.0 |
> showing 36 of 330 rows — these rows as CSV