PREVIEW / futures_1hour / 2021-07-25
file: by_date/futures_1hour/2021/2021-07-25.parquet size: 18 KB rows: 391
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-07-25 18:00:00 | ES | Futures | 4956.41 | 4960.63 | 4955.85 | 4959.51 | 4939.0 |
| 2021-07-25 19:00:00 | ES | Futures | 4959.79 | 4961.76 | 4957.25 | 4958.66 | 5457.0 |
| 2021-07-25 20:00:00 | ES | Futures | 4958.94 | 4959.51 | 4945.71 | 4947.96 | 12522.0 |
| 2021-07-25 21:00:00 | ES | Futures | 4948.24 | 4949.37 | 4941.77 | 4945.99 | 10878.0 |
| 2021-07-25 22:00:00 | ES | Futures | 4945.99 | 4947.4 | 4942.05 | 4942.89 | 6614.0 |
| 2021-07-25 23:00:00 | ES | Futures | 4943.18 | 4945.71 | 4942.33 | 4944.3 | 4406.0 |
| 2021-07-25 18:00:00 | NQ | Futures | 17494.43 | 17509.49 | 17488.06 | 17506.89 | 2897.0 |
| 2021-07-25 19:00:00 | NQ | Futures | 17507.18 | 17527.16 | 17504.28 | 17521.66 | 3557.0 |
| 2021-07-25 20:00:00 | NQ | Futures | 17521.95 | 17524.27 | 17485.74 | 17492.69 | 6355.0 |
| 2021-07-25 21:00:00 | NQ | Futures | 17492.69 | 17496.75 | 17467.2 | 17485.16 | 6321.0 |
| 2021-07-25 22:00:00 | NQ | Futures | 17485.45 | 17492.69 | 17474.73 | 17479.37 | 3455.0 |
| 2021-07-25 23:00:00 | NQ | Futures | 17477.92 | 17486.9 | 17471.84 | 17479.37 | 2082.0 |
| 2021-07-25 18:00:00 | YM | Futures | 39041.3 | 39053.5 | 39021.1 | 39041.3 | 1131.0 |
| 2021-07-25 19:00:00 | YM | Futures | 39042.4 | 39053.5 | 39012.2 | 39022.3 | 1236.0 |
| 2021-07-25 20:00:00 | YM | Futures | 39022.3 | 39030.1 | 38894.9 | 38927.3 | 3916.0 |
| 2021-07-25 21:00:00 | YM | Futures | 38928.4 | 38937.4 | 38875.9 | 38896.0 | 2159.0 |
| 2021-07-25 22:00:00 | YM | Futures | 38893.8 | 38908.3 | 38859.1 | 38871.4 | 1300.0 |
| 2021-07-25 23:00:00 | YM | Futures | 38870.3 | 38888.2 | 38862.5 | 38878.1 | 1091.0 |
| 2021-07-25 18:00:00 | CL | Futures | 49.57 | 49.74 | 49.51 | 49.66 | 2613.0 |
| 2021-07-25 19:00:00 | CL | Futures | 49.66 | 49.71 | 49.61 | 49.66 | 991.0 |
| 2021-07-25 20:00:00 | CL | Futures | 49.66 | 49.66 | 49.39 | 49.42 | 3615.0 |
| 2021-07-25 21:00:00 | CL | Futures | 49.41 | 49.49 | 49.25 | 49.4 | 6597.0 |
| 2021-07-25 22:00:00 | CL | Futures | 49.4 | 49.42 | 49.19 | 49.25 | 4309.0 |
| 2021-07-25 23:00:00 | CL | Futures | 49.25 | 49.27 | 49.16 | 49.19 | 2779.0 |
| 2021-07-25 18:00:00 | GC | Futures | 2174.5 | 2174.9 | 2172.6 | 2173.1 | 1392.0 |
| 2021-07-25 19:00:00 | GC | Futures | 2172.9 | 2174.0 | 2172.1 | 2172.6 | 839.0 |
| 2021-07-25 20:00:00 | GC | Futures | 2172.5 | 2172.9 | 2170.0 | 2171.0 | 2043.0 |
| 2021-07-25 21:00:00 | GC | Futures | 2171.1 | 2180.2 | 2170.0 | 2179.8 | 6022.0 |
| 2021-07-25 22:00:00 | GC | Futures | 2179.9 | 2180.8 | 2177.4 | 2178.0 | 3560.0 |
| 2021-07-25 23:00:00 | GC | Futures | 2178.0 | 2181.1 | 2177.9 | 2180.3 | 3141.0 |
| 2021-07-25 18:00:00 | ZN | Futures | 136.450732 | 136.450732 | 136.403066 | 136.418955 | 4089.0 |
| 2021-07-25 19:00:00 | ZN | Futures | 136.418955 | 136.450732 | 136.403066 | 136.418955 | 3644.0 |
| 2021-07-25 20:00:00 | ZN | Futures | 136.434843 | 136.498397 | 136.434843 | 136.482509 | 10611.0 |
| 2021-07-25 21:00:00 | ZN | Futures | 136.482509 | 136.57784 | 136.482509 | 136.546063 | 18630.0 |
| 2021-07-25 22:00:00 | ZN | Futures | 136.561951 | 136.609617 | 136.546063 | 136.57784 | 12085.0 |
| 2021-07-25 23:00:00 | ZN | Futures | 136.57784 | 136.609617 | 136.57784 | 136.57784 | 6735.0 |
> showing 36 of 391 rows — these rows as CSV