PREVIEW / futures_1hour / 2022-05-01
file: by_date/futures_1hour/2022/2022-05-01.parquet size: 19 KB rows: 420
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 |
|---|---|---|---|---|---|---|---|
| 2022-05-01 18:00:00 | ES | Futures | 4698.3 | 4702.27 | 4667.41 | 4687.53 | 27387.0 |
| 2022-05-01 19:00:00 | ES | Futures | 4687.53 | 4698.59 | 4673.65 | 4684.7 | 15811.0 |
| 2022-05-01 20:00:00 | ES | Futures | 4684.42 | 4691.79 | 4677.61 | 4686.97 | 15745.0 |
| 2022-05-01 21:00:00 | ES | Futures | 4687.25 | 4692.92 | 4673.65 | 4675.06 | 12462.0 |
| 2022-05-01 22:00:00 | ES | Futures | 4675.06 | 4691.22 | 4671.09 | 4688.67 | 10427.0 |
| 2022-05-01 23:00:00 | ES | Futures | 4688.67 | 4709.64 | 4688.67 | 4703.97 | 13728.0 |
| 2022-05-01 18:00:00 | NQ | Futures | 14953.72 | 14991.42 | 14853.68 | 14940.67 | 14236.0 |
| 2022-05-01 19:00:00 | NQ | Futures | 14941.25 | 14989.1 | 14887.32 | 14941.83 | 8851.0 |
| 2022-05-01 20:00:00 | NQ | Futures | 14940.09 | 14969.38 | 14912.26 | 14960.39 | 7408.0 |
| 2022-05-01 21:00:00 | NQ | Futures | 14960.97 | 14980.69 | 14912.84 | 14920.38 | 5832.0 |
| 2022-05-01 22:00:00 | NQ | Futures | 14919.51 | 14971.41 | 14893.7 | 14956.62 | 6031.0 |
| 2022-05-01 23:00:00 | NQ | Futures | 14958.07 | 15045.07 | 14958.07 | 15015.49 | 7162.0 |
| 2022-05-01 18:00:00 | YM | Futures | 37188.4 | 37274.1 | 37013.7 | 37163.6 | 5531.0 |
| 2022-05-01 19:00:00 | YM | Futures | 37163.6 | 37233.5 | 37064.4 | 37130.9 | 2900.0 |
| 2022-05-01 20:00:00 | YM | Futures | 37128.6 | 37186.1 | 37080.2 | 37142.2 | 2438.0 |
| 2022-05-01 21:00:00 | YM | Futures | 37136.5 | 37170.3 | 37038.5 | 37043.0 | 2074.0 |
| 2022-05-01 22:00:00 | YM | Futures | 37041.8 | 37160.2 | 37020.4 | 37145.5 | 2042.0 |
| 2022-05-01 23:00:00 | YM | Futures | 37147.8 | 37283.1 | 37147.8 | 37245.9 | 3526.0 |
| 2022-05-01 18:00:00 | CL | Futures | 77.95 | 78.69 | 77.56 | 78.31 | 4146.0 |
| 2022-05-01 19:00:00 | CL | Futures | 78.32 | 78.82 | 78.31 | 78.47 | 2106.0 |
| 2022-05-01 20:00:00 | CL | Futures | 78.46 | 78.59 | 78.05 | 78.47 | 3723.0 |
| 2022-05-01 21:00:00 | CL | Futures | 78.46 | 78.55 | 77.69 | 77.78 | 2457.0 |
| 2022-05-01 22:00:00 | CL | Futures | 77.78 | 77.83 | 77.53 | 77.77 | 2693.0 |
| 2022-05-01 23:00:00 | CL | Futures | 77.74 | 78.02 | 77.74 | 77.9 | 1430.0 |
| 2022-05-01 18:00:00 | GC | Futures | 2270.6 | 2275.6 | 2270.3 | 2273.6 | 2374.0 |
| 2022-05-01 19:00:00 | GC | Futures | 2273.3 | 2275.6 | 2272.2 | 2272.5 | 1848.0 |
| 2022-05-01 20:00:00 | GC | Futures | 2272.5 | 2274.0 | 2261.9 | 2264.1 | 5730.0 |
| 2022-05-01 21:00:00 | GC | Futures | 2264.3 | 2266.6 | 2263.3 | 2263.7 | 1898.0 |
| 2022-05-01 22:00:00 | GC | Futures | 2263.7 | 2265.6 | 2255.9 | 2260.9 | 4374.0 |
| 2022-05-01 23:00:00 | GC | Futures | 2260.9 | 2263.0 | 2259.4 | 2261.7 | 2054.0 |
| 2022-05-01 18:00:00 | ZN | Futures | 121.915149 | 122.027439 | 121.867025 | 122.027439 | 15248.0 |
| 2022-05-01 19:00:00 | ZN | Futures | 122.027439 | 122.059522 | 121.963273 | 121.963273 | 8476.0 |
| 2022-05-01 20:00:00 | ZN | Futures | 121.979315 | 122.091605 | 121.899108 | 121.947232 | 18031.0 |
| 2022-05-01 21:00:00 | ZN | Futures | 121.931191 | 121.995356 | 121.883066 | 121.947232 | 15448.0 |
| 2022-05-01 22:00:00 | ZN | Futures | 121.947232 | 122.027439 | 121.931191 | 122.011398 | 7303.0 |
| 2022-05-01 23:00:00 | ZN | Futures | 121.995356 | 122.043481 | 121.931191 | 121.995356 | 6171.0 |
> showing 36 of 420 rows — these rows as CSV